SUMMARY

• 15+ years of experience in Data warehousing and Business Intelligence in analysis, design, development, testing and implementation of the reporting and ETL components.
• Experienced in development and design of reports and dashboards for supporting the business analysis in a corporate wide reporting using Cognos BI Suite and Tableau Reporting.
• Hands on experience with Power BI.
• Experienced in Agile Methodology - Organized and facilitated Agile and Scrum meetings, which included Sprint Planning, Daily Scrums or Standups, Sprint Check-In, Sprint Review & Retrospective.
• Experienced with Systems Development Life Cycle (SDLC) processes and procedures.
• Strong proficiency in the full life cycle of Business solution development with outstanding capabilities in analysis, problem definition and requirements gathering.
• Knowledge of data warehousing architecture and dimensional modeling concepts
• Demonstrated evidence of strong written and verbal communication skills.
• Experienced in reading and explaining a data model
• Experienced to read, write and maintain SQL Code.
• Database experience in IBM DB2/Oracle/SQL Server.
• Hands on experience in ETL tools like Informatica 8.6.1 (Designer, Workflow Manager, Workflow Monitor) and Alteryx.
• Proficient in full life cycle design and development of BI reporting Applications.
• Strong understanding of data warehousing concepts, OLTP, OLAP, Normalization, Star and Snow Flake data models.
• Experience in training developers and advising technical groups on reporting best practices.
• Flexible and versatile to adapt to any new environment with a strong desire to keep pace with latest technologies.
• Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team.
• Experience with facilitating and documenting system requirements sessions.

TECHNICAL SKILLS

• Cognos
• Tableau
• Power BI
• Informatica
• Alteryx
• Database(DB2, Oracle, SQL Server)
• Toad
• Advanced Query Tool
• Agile Team Services (TeamFoundation Server).

PROFESSIONAL EXPERIENCE

Confidential

Sr. BI/Data Analyst/Modeler/Developer

Responsibilities:

• Gather business requirements, develop logical solutions, assess implementation alternatives and formulate overall design approaches.
• Work closely with key business stakeholders across all business functions to determine the best solution possible.
• Work on ETL processes of large sets of data. Gather, store and model the data for analytics and reporting purposes.
• Created dashboards using Tableau for Order release timeline across all value streams.
• Created playbooks using Tableau for each department that supports ongoing problem solving and continuous improvement.
• Worked with large datasets to create meaningful, executive-level visualizations.
• Used Altreyx to extract data from various source system and create Tableau datasource for all dashboard needs.
• Created Self Service schema to create and populate tables required for Self Service Reports.
• Convert Cognos reports for Operational Excellence to Tableau/Power BI.
• Create Tableau dashboard for CAE team and deployed to the CAE Monitors to help managers use the data during their schedule meeting.

Confidential

Business Intelligence Analyst/Reporting Lead

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outlined the proposed solution.
• Responsible for translating the Business requirements into technical specifications.
• Analyzed data flow and business requirements to create High Level Design document.
• Working in Agile methodology and 3 week sprints mode.
• Experienced in development and design of reports and dashboards for supporting the business analysis in a corporate wide reporting using Cognos and Tableau.
• Writing SQL queries based on the requirements gathered and making sure the results meet the need before starting ETL or report developments.
• Involved in creating Informatica mapping to move data from mainframe tables to data warehouse environment.
• Develop reports using relational and dimensional model.
• Responsible for effective solutions to client in response to various business requirements
• Co-ordinated with the Business users for the UAT testing.
• Worked on very tight deadlines and aggressively for the completion of the each Sprints.

Confidential

BI Developer/ Business Analyst

Responsibilities:

• Involved in report migration from Cognos CRN to Cognos 10.
• Responsible in deployments of reports and cubes from QA to PROD server.
• Involved in requirement gathering from the business users and convert them into to Technical specification.
• Design Framework model, develop and publish packages.
• Develop reports using relational and dimensional model.
• Design and develop Power play cubes in Cognos 10.
• Responsible for resolving production issues and providing long term solutions
• Responsible for effective solutions to client in response to various business requirements
• Preparing Status Reports on a periodical basis and provide a regular update to the stakeholders.
• Monitor the Application server for performance related issues
• Coordinate with the business users to understand their reporting requirement, help them with the technical solutions.
• Develop complex reports and deliver the same to the users with the minimal bugs
• Providing Technical assistance to the team as and when required.
• Provide various analytical solutions to users which would help them analyze their data in efficient manner.

Confidential

BI Developer

Responsibilities:

• Created patient satisfaction dashboard to show the performance of key activities that directly or indirectly impact patient satisfaction.
• Created ER Status Dashboard to provide the type of metrics ER workers need to track and monitor.
• Involved in requirement gathering from the business users and convert them into to Technical specification.
• Responsible for resolving production issues and providing long term solutions
• Monitor the Application server for performance related issues
• Provide various analytical solutions to users which would help them analyze their data in efficient manner.
• Involved in Systems Development Life Cycle (SDLC) processes and procedures.

Confidential

BI Developer/ Onshore Offshore Coordinator

Responsibilities:

• Assisted in developing Cognos Architecture and standards
• Co-Ordinate between US and PASCI (Offshore team) and assign requirements to the offshore.
• Involve in User Requirement Specs.
• Translate Report requirement specs to Technical design specs.
• Make modification of the Cognos FWM
• Assist in the development of highly complex Cognos Reports.
• Assists in developing Cognos design and Unit test documents
• Ensure that development is performed as per requirements
• Communicate activities/progress to project managers, business development, business analysts and client.

Confidential

BI Developer/ Reporting Lead

Environment: Oracle 9i, Cognos 8, Suite, Data Stage

Responsibilities:

• Maintaining the Team and assign tasks to team member accordingly.
• Analysis of the report requirements and designing the reports.
• Designing table scripts which are needed for this report
• Development and testing of Audit reports
• Supporting UAT for Audit Reports
• Delivering the reports as per the schedule.