NAZNEEN SAHEER
Ernakulam
Summary
A highly motivated and determined individual working as a ‘Technology Lead’ in business intelligence at Infosys Pvt India Ltd having total experience of 8.5 years experience as a Business Intelligence Developer and Data Analyst in Development and implementation of Client server applications and data system. Previously as Senior Certified SQL and Power BI developer at ITC Infotech India Pvt Ltd., bringing exceptional abilities in data analysis, business intelligence development for web application development and support. Have 2 year experience of working as .NET developer and 5 years in SQL & Power BI. Involved in Full life - cycle Implementation which includes Requirements Gathering, Analysis, development, Testing Process, Production environment with support of Data Flow and Process Models. Extensive knowledge in BI Design and Development, maintenance of I.T business applications using cutting edge software solutions. Experienced in using Microsoft BI Studio reporting tools as Power BI and products like SSRS and SSAS. Outstanding knowledge on building and deployment of reports either by native browser mode generating subscriptions or share point integration mode by using SQL Server reporting service. Extensively involved in activities like understanding the client requirements, Business Analysis, data analysis, preparing various project documents required for demonstrations. Strong understanding of BI application design and development principles. Good understanding and working knowledge on cloud-based solution tools like Power BI in creating and publishing reports. Applied technical skills using SQL in data analysis and reporting to procure data from database structures to report and provide solutions to client requests in a timely manner. Strong communication and management skills with excellent role-playing capabilities.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Technology Lead
Infosys Pvt India Ltd
10.2023 - Current
- Lead data team for progressively tracking and closing incidents in remedy and servicenow efficiently to become top domain
- Promptly resolved 50 tickets in platforms for powerbi and pyramid and done 100 service requests in various MRPI and MWP reporting in powerbi and DWH analysis servers
- Extensively involved in development and supporting of design for Power BI Dashboard Reports for various risk areas as per mappings provided across different countries that are within the scope of the project
- Involved in analyzing the Technical aspects of Business requirements, converting them to Functional requirement specifications to facilitate development and maintenance of the Power BI reports
- Create report visualizations via data mapping the source field columns from ETL-BI aggregates to AAS Tabular model
- Ability to Create Dashboard Reports by making data source settings to wide range of connections like Live Azure Analysis services, Excel, SQL DB etc
- Extensive knowledge in Developing different kinds of visualizations on report dashboards including bar charts, line charts, Matrix visuals, Heatmaps, Line and clustered charts, donut charts, card visuals etc
- Well versed and familiar in using all the Interface features of Power BI Desktop app like Filter selections, Format and Analytics components, Selection panes, Bookmarking, sync panes during development of reports
- Capable of creating workspaces and Power BI Apps to host and publish the reports
- Ability to troubleshoot various report UI bugs encountered during incidents and providing quick fixes
- Worked on Preparing Unit test cases/ SQL Queries for the adhoc reporting using OLAP pivot table in excel
- Involved in Production Deployment of Power BI Reports to Service and managed access to datasets, reports via role-based user management
- Involved in development of several POC’s to test the functionality of the business requirement using functions
- Knowledge on implementing Power BI Report templates and Themes
- Capable of handling various Operational and Project related settings in DevOps to create projects and perform bulk uploading of tasks via team settings, Creation of different work items, backlogs etc
- Created Deployment checklists, Object lists and release notes as part of Production release activities for Publishing Power BI Reports to Service
- Knowledge on Azure analysis Services Dimensions, Facts, Measures and data relationships in Tabular model design
- Ability to understand the Cube Design, data source views and deploying of Cubes via Azure analytical services
- Client appreciation in terms of quick response in various complex adhoc reporting in sql ,advanced excel and powerbi
- Client appreciation for the hardwork as part of DCC Important Tier Disasater Recovery activity and apps testing.
Technology Lead
Infosys
06.2022 - Current
- Top performer in no
- Of Jiras closed as goal from Oct 2022 to April 2023
- Leading and Monitoring EasyGo Maps team for completing tasks within SLA and gave status report daily to management
- Helped the team to gain skills in learning platforms
- Worked with Citrix Engineering team to support successful end user testing for migrated applications in new windows environment by resolving various IBM DLL issues
- Developed shell scripts to add more columns in a file via MQFTE process to business users and ETL team and get extracted files
- Developed reusable queries for getting userlist for KCMS applications in IBM DB2
- Participated in project planning sessions with Finance Team, BA's for requirement gathering or analysis
- Created SP for AD team for Promo forecast at sales level and GTIN Level which were deployed successfully
- Appreciated by Client Product manager for providing fine details in solution to end user as part of agile scrum process
- Top performer in completing maximum no of Jira Tasks in Agile board in the year
- Gave improvement idea for automation of Audit dashboard which were done manually
- As a Tech lead, currently leading a team of 10 members, progressively solving technical and functional challenges to ensure timely and quality deliverables within SLA
- Got client appreciation for tremendous progress and dedication for success in promo planning Q2 OKR’S for Q1 results in Kroger project
- Implemented idea of automation of daily dashboard through VBScript and task scheduler within team environment.
Senior SQL Server & PBI Developer
ITC Infotech
12.2020 - 03.2022
- Responsibilities: Database code performance tuning
- Server side coding and SQL backend developer
- Analysis and data cleaning
- Developed New joinee BOT for new hires which eases Asset allocation and cubicle allocation
- Automated process in SQL Procedures and Views
- Integration of various DB's and make the Onboading process easy for management team
- Done PBI report of various TAT's for newjoinee data
- Experience with scheduling jobs using SQL Agent
- Analysis, design documentation and implementation of various modules in projects
- Worked on various database objects like Stored Procedures, Tables, Views, UDT's and Functions by using Microsoft SQL Server for development, modification and organization of databases
- Strong command and experience on Oracle & SQL database (including DDL, DML, TCL, data modelling, query optimization (PBI), database instance tuning)
- Converted business logic into DB design and apply to project it using db schema and objects like SP, User defined functions, views, T-SQL scripting and jobs.
Senior Powerbi Developer
ITC Infotech
05.2020 - 02.2022
- Responsibilities: Analyzing requirements and deployed the dashboard to services and shared the report to members in organization who had license
- Providing Viewer or admin access to all SL/SSL Heads, CEPs, Geo Heads & EMC members
- Documented the deployment steps as per guidelines for future reference and published on linked in for the same
- Published through app which available on internal company website
- Done Powerbi Admin activities like scheduled Automatic refresh in power bi service
- Managed to get recognition of CEO for successful delivery.
SQL Developer and Support
ITC Infotech
04.2019 - 12.2021
- Responsibilities: Analyzing requirements and implementing it
- Tasks in both front end and back end
- Planning, designing database based on BR and provided documentation
- Created tables, views and Stored Procedures and triggers
- Unit test cases executed and maintained audit logs
- Developed SQL Queries/scripts to validate data and data aggregations.
Senior SQL Developer and Solution Architect
ITC Infotech
03.2020 - 10.2021
- Responsibilities: Analyzing requirements and implementing it
- Tasks in both front end and back end
- Planning, designing database based on BR and provided documentation
- Created tables, views, functions and Stored Procedures and triggers
- Used sql repositories for manage, analysis of data for reporting, i.e data for projects and opportunities from One point DB views and CRM systems respectively for the purpose of forecasting
- Unit test cases executed and maintained audit logs
- Troubleshooting of issues
- Development and maintenance of ITC Products and Services Portal in Oracle SQL
- Experienced in conducting audit logs and database recovery log shipping Activities as part of SQL Database administration.
Power Bi, SQL Developer and Analyst
ITC Infotech
08.2018 - 01.2019
- Responsibilities: Analyzing requirements and implementing it
- Tasks in both front end and back end
- Developed power bi reports and dashboards from SQL data sources
- Developed SQL Queries/scripts to validate data and data aggregations
- Explored data in various ways across multiple visualizations using PBI
- Designed power bi reports using pie, bar charts and bar graphs along with tabular & matrix visuals.
.NET and SQL Developer and Support
ITC Infotech India Ltd
05.2017 - 03.2018
- Responsibilities: Analyzing requirements and implementing it
- Tasks in both front end and back end
- Implement admin configuration using roles and permissions and update admin functionalities by given requirements
- Giving role access to users in different countries
- Worked on various export functionalities on data on HR module, Environment Measure module, Audit reports
- Developed Quarterly report for analyzing data for various environment measures in a year for various hierarchy levels
- Worked on various validations and screen developments
- Timely delivery of solutions to customers
- Developed Custom classes in .NET C# server side and used angular JS for client side.
Junior .NET Developer
ITC Infotech
02.2017 - 04.2017
- Responsibilities: Analyzing requirements and implementing it
- Tasks in both front end and back end
- Implement admin configuration using roles and permissions and update admin functionalities by given requirements
- Giving access to users in different countries
- Worked on validations using jQuery and html5 in Employee Onboarding System
- Worked for developing html templates for conversion into Pdf for download and upload of Bayer documents.
Education
BTech.: Information Technology -
RSET - Kochi
03.2016
High School Diploma -
Vidyodaya
Kochi, India07.2012
Skills
- Tools: Microsoft Business Intelligence Tools, MS SQL, Oracle SQL Developer, MVC, WPF, WCF, MS Office, Visual Studio-2017, Power Automate, Pyramid, OLAP Pivot table, Reporting Tool: Power BI, SQL Server Reporting services, Advanced Excel
- Scripting and programming language: SQL, HTML, DAX queries, Power pivot query, C#, C
- Operating Systems: MS Windows 8, 10, 11
- Planning & collaboration: Team Foundation Server(TFS) repository, VSS 2017, servicenow, Jira
- Intermediate Data validation
- Technical Writing
- Subjects of interest: Data analytics, Database Management Systems
- Good logical thinking and problem solving skills
- Team player and user communication
- Investigative and troubleshooting skills
- Organization of tasks
- IT Infrastructure Management
Accomplishments
· Infosys Internal Certification in SSIS (Intermediate) in 2023
· Front liner Service award and Team Player certificate in 2021
· Received Team player PAT ON THE BACK award in ITC Infotech
· Received Star Project Award in Club of Honor in ITC Infotech
· Got nominated for Outstanding dependency in Resilience awards in annual TAP NITE of ITC Infotech
· Business team recognized quick turnaround and excellent work in short span and good feedback from senior management for Opera Manpower Planning reports.
· Contribution recognition of successful completion and delivery of BRS system
· Achiever of Month nominee for data analysis /reporting dashboards based on Assets/Flap barrier timings rolling out in short span of time during crisis period
· Received appreciation feedback from the company CEO & SSL heads for being a part of Delivery dashboard dev team which was need for organization and taking to next level
· Gained recognition from Business and SSL heads for good overall development and timely support in Revenue forecasting system, to Delivery, sales and business teams
· Got into Semi finale of TechGig Data Science Hackathon in 2017
· Acknowledged and appreciated the work done by all the team members by VP for GOM dashboard and Delivery dashboard in Power BI deployment
· ITIL Beginner foundation certification
· Attended servicenow trainings and lead the team to resolve access issues and complete 100% trainings and Servicenow UAT testings in our data domain
· Completed Musgrave GDPR and Infra security certification with good score
· GDPR and Infra Security course certificate
· Musgrave(Client) Code of Conduct certificate
Certification
- Certified SQL data Scientist from University of Davis, California
- Microsoft Data Analyst Associate Certification in Power bi
- Infosys Internal Certification in SSIS (Intermediate) in 2023
- Front liner Service award and Team Player certificate in 2021
- Received Team player PAT ON THE BACK award in ITC Infotech
- Received Star Project Award in Club of Honor in ITC Infotech
- Got nominated for Outstanding dependency in Resilience awards in annual TAP NITE of ITC Infotech
- Business team recognized quick turnaround and excellent work in short span and good feedback from senior management for Opera Manpower Planning reports.
- Contribution recognition of successful completion and delivery of BRS system
- Achiever of Month nominee for data analysis /reporting dashboards based on Assets/Flap barrier timings rolling out in short span of time during crisis period
- Received appreciation feedback from the company CEO & SSL heads for being a part of Delivery dashboard dev team which was need for organization and taking to next level
- Gained recognition from Business and SSL heads for good overall development and timely support in Revenue forecasting system, to Delivery, sales and business teams
- Got into Semi finale of TechGig Data Science Hackathon in 2017
- Acknowledged and appreciated the work done by all the team members by VP for GOM dashboard and Delivery dashboard in Power BI deployment
- ITIL Beginner foundation certification
- Attended servicenow trainings and lead the team to resolve access issues and complete 100% trainings and Servicenow UAT testings in our data domain
- Completed Musgrave GDPR and Infra security certification with good score
- GDPR and Infra Security course certificate
- Musgrave(Client) Code of Conduct certificate
Affiliations
- Certified SQL data Scientist from University of Davis ,California
- Microsoft Data Analyst Associate Certification in Power bi
Timeline
Technology Lead
Infosys Pvt India Ltd
10.2023 - Current
Technology Lead
Infosys
06.2022 - Current
Senior SQL Server & PBI Developer
ITC Infotech
12.2020 - 03.2022
Senior Powerbi Developer
ITC Infotech
05.2020 - 02.2022
Senior SQL Developer and Solution Architect
ITC Infotech
03.2020 - 10.2021
SQL Developer and Support
ITC Infotech
04.2019 - 12.2021
Power Bi, SQL Developer and Analyst
ITC Infotech
08.2018 - 01.2019
.NET and SQL Developer and Support
ITC Infotech India Ltd
05.2017 - 03.2018
Junior .NET Developer
ITC Infotech
02.2017 - 04.2017
BTech.: Information Technology -
RSET - Kochi
High School Diploma -
Vidyodaya
Similar Profiles
SAKTHIPRIYAN MANICKAMSAKTHIPRIYAN MANICKAM
Test Analyst at Infosys India Pvt Ltd (Client : FiveBelow )Test Analyst at Infosys India Pvt Ltd (Client : FiveBelow )
JILLS JOY KOIKARAJILLS JOY KOIKARA
Consultant - Supply Chain Analytics at Infosys India Pvt LtdConsultant - Supply Chain Analytics at Infosys India Pvt Ltd
Suraj Sekhar PurohitSuraj Sekhar Purohit
Product Owner / Consultant at Danske IT India Pvt Ltd (Acquired By Infosys Limited)Product Owner / Consultant at Danske IT India Pvt Ltd (Acquired By Infosys Limited)