SUMMARY

• Over 12 years of IT experience in the field of DWH/BIG Data Testing and Data analysis
• 2.5 year of experience in Big Data Testing. Expertise in Hive, Spark, Scala and Sqoop.
• Good knowledge about end to end Healthcare solution which includes Healthcare Foundations,
• Facets Product Foundations, Facets Technical Foundations that includes Data Models and Backend
• Batch Processing and its Configuration changes.
• Worked on FACETS Data tables and created SSRS reports using FACETS Data Model and good understanding of FACETS and Facets Data Model working on data model and data extracts.
• Experienced working in Facets modules such as Billing, Provider, Claims and Membership modules.
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis
• Design and Testing as per the Software Development Life Cycle.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Expertise in working on projects involving Data Warehousing/Report Testing/Master data management (MDM).
• Good experience of Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical
• Data Modeling using Informatica.
• Assisted to define GAP analysis to IT team for BRD, functional specifications and TDD documents.
• Analysis of ETL Mappings based on Facts & Dimensions from Source to Confidential tables for directs moves and indirect moves based on transformation rules & lookup tables.
• Used Metadata management approach to maintain the metadata.
• Acquire data from primary or secondary data sources and maintain databases/data systems
• Strong knowledge of and experience with reporting packages (Business Objects etc), databases (SQL etc), programming (ETL frameworks)
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing enterprise data warehouse (EDW).
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• Worked with other team members to complete special projects and achieve project deadlines.
• Performed daily data queries and prepared reports on daily, weekly, monthly, and quarterly basis.
• Ability to understand current business processes and implement efficient business process.
• Gathering business and Technical requirements that would best suit the needs of the technical architectural development process.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas, Slowly changing dimensions and created slowly growing Confidential mappings, Type1/2/3 dimension mappings.
• Data Warehousing Facet 5.3, SSRS, Informatica PowerCenter 8.6, MDM, Data stage, OBIEE.
• Databases Oracle 10g/9i/8i, Teradata,DB2, SQL Server 2010/2012
• Languages SQL, PL/SQL, Basics Unix Shell Scripting.
• Tools Big Data, Hive, Spark,Toad, SQL developer, Putty.
• Authorized to work in the US for any employer

TECHNICAL SKILLS

Operating Systems: Windows 95/98/2000, UNIX.

Quality Center: PVCS, Developer 2000 Forms 4.5 and Report 2.5, Appworx Scheduler, Platinum.

Data Analysis: Big Data Testing, ETL Testing

PROFESSIONAL EXPERIENCE

Senior Data Analyst

Confidential

Responsibilities:

• Perform testing of Hadoop data processing pipelines / Big data based on established best practice methods of Cognizant's project test strategy methodologies and theories for data and analytics solutions. The testing will be conducted using Cognizant accelerators which streamline the testing process and optimizes testing and data quality monitoring.
• Analyzing and achieving quality engineering and assurance of data ingestion and Analytics platform in Bigdata. The platform is built on Hadoop eco systems with technologies like Spark, hive, Cassandra,
• Scala, Teradata and Vertica.
• Daily tasks involve and not limited to identifying, comparing any data anomalies with respect to the data being processed. Also, he has to conduct quality review of process and provide sign off on project deliverables to certify quality of Data, Reports and Analytic dashboard data on time. leads end to end project implementation including requirement gathering, Test planning, Test Design, Test strategy documentation, Test script preparations and Test executions adhering to
• Cognizant best practices and standards. He also provides UAT and post go live support for business communities across the globe.
• The onsite deliverables are driven by amassing as much functional knowledge is available by connecting timely with all the stake holders including business and product teams. Multiple stake holders are involved around the critical application like iTunes Data analytics platform which includes crucial financial reporting for content providers, artists and publishing companies and media research partners

Data Analyst/SSRS Developer

Confidential

Responsibilities:

• Worked with the business/functional unit to assist in the development, documentation, and analysis of functional and technical requirements within FACETS.
• Perform research on Member, Provider, Claims data from Facets back end and front end application system for reporting purposes.
• Extensive involvement in data mapping using Facets data model and Facets back end tables and front end application system for data validation purposes.
• Interacted with client and the technical team for requirement gathering and translation of Business
• Requirements to Technical specifications.
• Developed different type of reports including: Claim Report, Provider Contact Report, Accounting Statement Report, Billing report and other insurance/EMA/Oclever Reports by using SSRS and SQL
• Server 2008/2012.
• Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements.
• Worked directly with Horizon client for requirement gathering /report development, Designed and developed a full - scale reporting solution for Horizon Client environment using MS SQL Server 2008 and
• MS SSRS 2008/2005.
• Created, implemented and maintained reports for Horizon account, Also customizing many reports to meet individual client needs.
• Created standard report sub and linked reports using MS SSRS 2008 as well as managed the subscription of the reports.
• Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Created dashboards for Claims, Customer, workflow and Production using benchmarked data to provide an analytical snapshot of point in time data.
• Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirement
• Developed different type of reports including: Audit Report, Client Contact Report, Billing and enrollment Report, Claims report, customer service report, Enrollment count summary report and workflow report and using SSRS and SQL Server 2008/2012.
• Developed parameterized reports which were used for making current and future business decisions
• Developed SQL report\report layout for various Drill-through reports, Parameterized reports, Tabular reports and Matrix reports using SSRS

ETL Test Lead

Responsibilities:

• The Medicare Advantage/Cost Encounter Data Submission (MAEDS) project has four national tracks:
• Internal Claims, External Claims, EDI, and Decision Support, as well as tracks for each region. All the tracks must have an interim solution in place for submitting non-DME claims starting in January
• 2012, and DME claims starting in mid-2012. A long- term solution will address regional changes to claim source systems as they migrate to Xcelys. Project Goal is moving the historical data from legacy system (Diamond) to CDW.
• • Worked as a data analyst and provided UAT/SIT support by creating validation scripts and business
• • Analysis of Business requirements and prepared the specification document for development team to design the RxEnroll Application
• • Analyzing the data before generation and after generation of feeds
• • Interacting with stake holders like Development team, Business and QA team members for finalization of business Technical specifications.
• • Data analysis and validation of Tables using complex SQL scripts.
• • Review the source to Confidential Data mapping document prepared by Development team
• • Involved in thorough validation of Data completeness, Data transformation, Data quality
• • Providing Estimates for changes in the functionality • Preparation of UAT scenarios and execute the same
• • Review and approval of System and Regression test results.
• • Direct interacting with the Client for clarifications and status reporting.

Test Lead

Confidential

Responsibilities:

• Analysis of DEB and HEM data to get the customer Bill for Home and industrial use
• Data validation of Tables from scratch.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Data Analysis and creation of Test Plan and Test Strategy documents with the onshore counterpart for System Testing and Regression testing
• Coordinated with the onsite point of contact and the client to get a thorough understanding of the requirement. Making sure that the offshore team is on the same page.
• Helping the team in writing and executing test cases to verify the data in the backend and the flow of data from backend database to the UI.
• Review of test cases and scripts prepared by the test team.
• Defect tracking in HP ALM 12 and working closely with development team until fixture.
• Execution of the SQL scripts to verify the data from D&I to Member portal as per the business rules
• Direct interacting with the Client for clarifications and status reporting.
• Daily status report preparation and communicating the same to the stake holders.

ETL Test Lead

Confidential

Responsibilities:

• Analysis of Business requirements for creation of test plan and high level test. Scenarios.
• Discussing with Business Team to understand the Business requirements & Functionality Of projects
• Involved in Test strategy & Planning, Test Case Writing, Verification and Validation as per the standards
• Set/given to test the process Supporting System Test execution, Data Validation and Data Integrity
• Interacting with Project team and Client QA manager
• Preparation of ETL design documentation and Technical Troubleshooting for the team, running the batch job for Initial feed and delta feed which will have complete historical /Daily data from SM1 and
• SM.
• Daily Delta feeds for both SM1 and SMe. These daily files for SM1 will be provided till SM1 is not decommissioned.
• Batch job execution for initialization& completion trigger file for each subject area.
• Obtain customer acceptance on deliverables
• Defect tracking in Quality Centre (QC) and working closely with development team until fixture. Direct interacting with the Client for clarifications and status reporting.

Test Lead

Confidential

Responsibilities:

• Analysis of Business requirements for creation of test plan and high level test scenarios.
• Preparing Test Estimation Report.
• Delegation of work to the team.
• Helping the team in writing and executing test cases to verify the data in the backend and the flow of data from backend database to the UI. Review of test cases written by team.
• Defect tracking in HP ALM and working closely with Client and development team until fixture.
• Direct interacting with the Client for clarifications and status reporting.
• Daily status report preparation and communicating the same to the stake holders.

QA Lead

Confidential

Responsibilities:

• As an Onsite Test lead, my responsibilities include analyzing and reviewing business and system requirements to create and finalize Test Plans incorporating input from all the technical & User communities.
• Providing accurate Testing status by creating Status report and sharing the same with Clients every day
• Prepared Approach and ETL specifications and Analyzed Informatica ETL code for business requirements to technical architecture
• Preparation of ETL design documentation and Technical Troubleshooting for the team.
• Scheduling weekly status meetings with the Developers, Users & QA Team and developing testing metrics.
• Documenting and tracking defects in HP - ALM.
• Scheduling Defect Triage call in daily basis and follow up with Dev team to get the critical defects fixed and deployed for Testing.
• As Onsite coordinator, my Responsibility includes Reviewing Test Cases, and clarifies the issues and concerns raised by offshore team.
• Participating in all phases of the project, from review of requirements and design to final system testing, deployment and maintenance.
• Mentor Offshore testers and business unit personnel on general testing and documentation practices.
• Identifying and recommending improvements to review processes, business products and services, particularly those that enhance customer satisfaction, minimize business risk and maximize efficiency.
• Working with development team, managers, and other QA members to better the QA process.
• Led the project, estimated and scheduled resources and time needed, developed guidelines and procedures, and scheduled timelines for the project.
• Managing portfolios of applications and concurrent ongoing test efforts, prioritizing projects, estimating and budgeting testing initiatives.

Offshore QA Lead

Confidential

Responsibilities:

• Reviewing Requirement, Design documents and understanding the requirements
• Interacting with Business users and developers, where relevant, to seek clarifications and discuss issues
• Involved in test case writing /Review for ETL
• Interface and provide the required support to Team member.
• Defect Logging and Defect tracking.
• Interacted with developers, Business & Management Teams and End Users.
• Co - ordinate with the QA team in various testing phases by resolving the defects and ensuring smooth execution of the test plans
• Perform the Data validation from source to stage, stage to Confidential in Database.
• Scheduled the job with Help of Control M tool.
• Tracked the defects using HP-ALM tool and generated defect summary reports

Test engineer

Confidential

Responsibilities:

• Discussing with Business Analysts to understand the Business requirements & Functionality Of projects
• Involved in Test Case Writing, Verification and Validation as per the standards
• Set/given to test the process Supporting System Test execution, Data Validation and Data Integrity.
• To check whether the Extract, Transform & Load operations between source to
• Stage tables and stage to Confidential tables are correct according to the ETL specifications
• To check whether the Reports are populated with correct data & format from the summary tables according to reporting document specifications using OBIEE tool.
• Involved in Functional, System Testing and Regression Testing for both ETL and Reports.
• Finding Issues/Defects and Defect Tracking till its resolved.
• Root Cause Analysis and possible solutions for errors encountered.
• Preparing Status Report and attending Triage calls.
• Check for missing data, negatives and consistency. Field - by-Field data verification can be done to check the Consistency of source and Confidential data.

Offshore QA Lead

Confidential

Responsibilities:

• Discussing with Onsite coordinator to understand the Business requirements & Functionality Of projects
• Prepared the Test Strategy document and Test Plan document for Different ETL interface
• Involved in test case writing /Review for ETL Interface and provide the required support to Team member.
• Task allocation for different Team member.
• Co - ordinate the review, presentation and release of design layouts, drawings, analysis and other documentation.
• Assure that the team members have the necessary education and training to effectively participate on the team.
• Coordinates meetings with the project manager and functional management to discuss project implementation,
• Escalate issues which cannot be resolved by the team.
• Conducted the Induction program for new Jcpenney Resource.

Software engineer

Confidential

Responsibilities:

• GE - Aviation has built a SDW (Sourcing Data warehouse) that is loaded on a daily basis from internal and external sources .The Enterprise Data Warehouse further feeds data at various intervals into SDW Mart. The SDW Mart provides critical information for business analytical and decision making purpose.
• This information is used by higher level management for future prediction and decision making purpose.SDW receives data in the from flat file and relational database, which are transformed and loaded into warehouse using Informatica as an ETL tool .Business users use this information for their decision-making.
• Using Cognos Reports, SDW Mart available 24x7 and reside on a distributed hardware across different sites.
• The project involves production support activities for the data load process for SDW Mart. The scope of support the code developed for data load process using Informatica, Unix Script, SQL script and
• Approwx Schedules. eNSMR eNSMR Project helps us in classifying and stratifying non-serviceable/scrap material to identify opportunities for new repair development, driving revenue growth. This Project helps us in obtaining actionable, on-demand information about scrap hold parts in a uniform format across all shops. Using this data, Users can identify and prioritize repair development opportunities and provide quicker customer feedback while maximizing productivity & OM.
• Worked as a Team Member
• End to End solution monitoring of the ETL Process.
• Abend fixing/Call resolution
• Maintain production log analysis and abend history
• Client communication
• Owned 5 Informatica folders and worked on the Informatica issues.
• Worked on many database related issues. Provide functional knowledge to the users.
• Performed Informatica testing after Informatica migration from 7.1 to 8.1.
• Client Status Reporting.