SUMMARY

• Worked closely with ETL and reporting teams as a Data Analyst.
• Strong understanding of Relational databases, Data Warehousing, ETL, fact and dimensional model and Business Intelligence - Reporting with experience in the life sciences and healthcare domain.
• Expertise in identifying, developing and documenting Business, Functional and technical Requirements.
• Worked on Preparing the Technical Specification Document, functional specification document out of the Business Requirement Document.
• Worked with the business team in understanding the requirements that need to be translated into technical needs and feasibility of the reports.
• Performed Data analysis and profiling of data sources using SQL based on project needs.
• Led the business intelligence reports development effort by working closely with the business team and stake holders.
• Experience with generating ad hoc reports.
• Experience with analyzing and generating and maintaining reports using Business Intelligence tools.
• Thorough Understanding of Software Development Life Cycle (SDLC) and involved in various phases like Requirements elicitation, Analysis, Development and Testing. Experience with both waterfall and agile methodologies.
• Highly motivated, result oriented professional with a short learning curve and strong communication skills.
• Adept in learning new technologies and quickly adapting to new environment.
• Excellent communication skills (written and verbal), ability to proactively build relationships with other team members and interact with Business Units and all levels of Management within the organization.
• Bachelors of Technology in Biotechnology.

TECHNICAL SKILLS

Reporting: SQL Reporting 2005 / 2008 R2/ 2014 (SSRS), PowerPivot

ETL: Analysis of data mappings on Informatica, Datastage 7.5 and SSIS 2008R2, MS SQL Server 2000/2005/2008 R2/2014, MS Access, SQL, PL/SQL, SQL Query Analyzer, Oracle.

Programming: SQL, PL/SQL, Transact SQL

Operating systems: Windows.

Database Tools: SQL Server Management Studio 2005 / 2008 R2/ 2012, SQL Server 2005/2008/2012 Business Intelligence Development Studio, TOAD 9.0.1.

PROFESSIONAL EXPERIENCE

Confidential

Sr Business Data Analyst

Responsibilities:

• Involved in the initial discovery/analysis phase for projects to determine the scope and impacts to the datawarehousing systems.
• Conducted JAD sessions and acted as the lead facilitator for project meetings to gather the business and technical requirements from the business users and SME’s.
• Responsible for the creation of the functional and non-functional requirements documents
• Translated the business requirements to technical requirements and created the Technical requirements document TRD.
• Created various Operational, Maintenance and Ad-hoc BI reports for day-today analysis and statistical information.
• Developed the report mockups using excels for the various reports.
• Developed and supported the ETL process for the data warehouse from various data sources including EDW.
• Verified the data quality and tested the functionality of the reports to conform to the business requirements. Strengthened the existing program iteratively over a period of time as per the business needs.
• Performed data analysis using SQL, data profiling and validation on the various source data systems and feeds and cleansed and standardized the data to be provided to ETL
• Created /scheduled SQL server jobs and maintenance activities of database.
• Involved in testing the newly developed reports vs the pre-migration reports.
• Analyzed and fixed the defects raised by end users and Assisted users in trouble shooting their reports
• Worked on creating the Data Mapping document (Source-Target Mappings) from the Source to Target system which comprises the definition of every column on Target system, their significance and corresponding source column.
• Created customized report for different type of reports standardization of report formats, filter options, page break options, and output options; as well as additional flexibility in terms of report data selection.
• Created complex reports using union queries, conditional formatting and prompting, drill-through.
• Worked closely with Data Architects and development team, helping them understand the exact business functionality that needs to be developed.
• Collaborated with the test team to review the test cases and ensure their alignment with the requirements.
• Acted as a liaison between all the stakeholders - business units, solution architects, QA and development teams.
• Provided user support and coordinated resolution of issues to include change management, root cause analysis, and appropriate escalation as needed.
• Assisted with maintenance and communication of project status reports and tracking.
• Provide appropriate security access for users to use reports and access of database.

Confidential

Business Data Analyst

Responsibilities:

• Responsible for gathering business and technical requirements from the business team and SME’s.
• Translated the business requirements to technical requirements and created the Technical requirements document (TRD) to support the development team. Responsible for documenting the technical and functional requirements, current state and future state diagrams.
• Worked on creating the Data Mapping document (Source-Target Mappings) from the Source to Target system which comprises the definition of every column on Target system, their significance and corresponding source column.
• Worked extensively on user requirements gathering, gap analysis, and development of technical specifications for critical modules like Consumer Invoices, Vision eligibility files and billing and finance modules.
• Created Invoice mockups and templates for the healthcare reform exchange invoices in relation to the technical requirements and helped with formatting the target XML structure.
• Facilitated TRD review sessions and walkthrough with the business team as well as technology team to allow different stakeholders to communicate their perspectives resolve any issues and come to an agreement quickly.
• Developed the requirements traceability matrix for the various phases of the SDLC for the project.
• Collaborated with the test team to review the test cases and ensure their alignment with the requirements.
• Helped prepare and run unit, integration, UAT, regression testing.
• Responsible for all project documentations
• Worked closely with Data Architects and development team, helping them understand the exact business requirements that needs to translate into code.
• Assisted the development team by analyzing the various incoming data feeds using SQL and Excel, and providing the results to the source teams and developers.
• Acted as a liaison between business units, QA and development teams.
• Conducted JAD sessions and acted as the lead facilitator for various project meetings.
• Worked on a number of production support issues.
• Coordinated the process analyze, evaluate, implement, and maintain systems developed internally and/or externally with an outside vendor.
• Worked on the highly critical technical requirements of the invoice bills for subscribers enrolled through the healthcare reform(HCR) exchange.
• Experienced with requirements concerning batch-job interfaces and healthcare membership, eligibility, billing, payments, Provider data/domain.