SUMMARY:

• Business Analyst / QA Analyst / Data Analyst with over 9 years of experience in all phases of Software Development Life Cycle: Gathering Requirements, Analysis, Testing and Implementation of projects. A motivated, sincere, committed, quick learner, detail - oriented team player with excellent communication, analytical, leadership, interpersonal and problem solving skills.
• A dynamic IT Professional with more than 9 Years of experience.
• Experience in SQL Server, Oracle and Teradata SQL programming and report generation.
• Good experience in SQL queries, SSIS and SSRS development.
• Extensive experience in QA testing using HP Quality Center, Mercury RQM and MS Team Foundation Server Tools.
• Successfully executed many Projects with high quality.
• Experience in Maximo tool for change management process.
• Extensive experience in MS EXCEL for business analysis and charting.
• Experience in Teradata ETL using Mainframe platform.
• Experience in SharePoint development using SharePoint Designer Tool..
• Excel at communicating with clients and stakeholders to provide accurate reporting and information regarding the ongoing projects & initiatives
• Good Understanding in SDLC and STLC processes.
• Experience in gathering Business Requirements, evaluating data sources, translating requirements into specifications, application design, technical and business writing and testing various methodologies.
• Projects executed using AGILE methodology.
• Worked with Onshore/ offshore resources.
• Performed as a Test lead for few projects.
• Good interpersonal communication skills, presentation skills and Leadership Qualities.
• Experience in Agile and Waterfall methodology.

TECHNICAL SKILLS:

Programming Languages: SQL, VB Script, HTML, XML

Methodologies: SDLC, Product Life Cycle, Agile, SCRUM, GAP Analysis.

Databases: SQL Server, Teradata, MS-Access, MySQL, Oracle.

Teradata Tools: SQL Assistant, MLOAD, FASTLOAD, BTEQ

Office Tools: SharePoint, SharePoint Designer, MS Visio, MS Word, MS Excel and MS PowerPoint

Operating System: Windows, UNIX / LINUX, Mainframe MVS/TSO

QA Tools: HP Quality Center, QTP, Mercury Tools, MS TFS, Rational Quality Manager Test Tools,Clear Quest, Service Now,TOAD,DB Visualizer

Web Technology: JAVA,XML,HTML,ASP,HTTPS, .NET,C#,etc.

Reporting Tools: SSRS, Crystal Reports.

Virtualization Technologies: Citrix Receiver, Webex.Citrix XenApp

PROFESSIONAL EXPERIENCE:

Confidential

Skill/Tools: Linux, MS Office Tools, Oracle / DB2, Toad, DB Visualizer, Ab-Initio, Control- M, Clear Quest, Service Now, HP ALM,MS Access, WinSCP, Metadata Hub,Remedy.

Senior ETL QA Analyst

Responsibilities:

• Involved as a Test Lead for few projects.
• Analyzed the Detail Design Document, Business Requirement, Functional requirement document, Source to Target mapping document and created the Test plan, Test cases and Test Data.
• Structural testing - Verification of table names, schema names, column name, and column data types as per physical data model.
• Regression testing.-Verification of the existing logic.
• Worked on Care Management and Disease Management (CMDM) Extracts validations.
• Space Reclamation and Archival testing.
• Organized the Test Review meeting with the broader team (BA, SA, Project Team, DEV, QA) to review the Test cases and Test Results.
• Involved in creating the S2T Mapping document within the scope of Testing Team to make the Tester job easier while comparing the data against the target tables.
• Involved in setting up the Test Environment and deployed the code/Tag in test environment as guided by the deployment guide.
• Tested various Incoming file against the Target table once ETL jobs are completed successfully.
• Logged the Defect in Clear Quest as per the company standard and followed up in it until it is fully resolved.
• Debugged the failed job and performed Root Cause Analysis on failed jobs.
• Extensively used Control M for automation of scheduling jobs on daily, bi-weekly, weekly monthly basis with proper dependencies.
• Provided Application production support using application run-book.
• Wrote complex SQL queries using joins, sub queries to validate the data in Target table as per Source to Target Business rules .
• Extensively used UNIX to run the Ab Initio graph from command line and Control-M error debugging. Analyzed different directories in Sand Box like MP, Xfr, run, db, dml, sql etc.
• Using Ab-Initio Metadata Hub.
• Tested different Data Marts like MRA, PMF and CAE as they were built to fulfill the Analytical aspect of the Company
• Critical Production Issue tickets.
• MedPAC validations.
• Worked on HEDIS Medmeasure Extracts Automate process of Local Plans.
• Worked on HEDIS files like Medical Claims,Rx claims, Provider,Provider Speciality,Member Enrollment files for various testing.
• Experience in Service Now.
• Deployment testing.-Final test to verify stability of an application before application get deployed to production.
• ETL Job execution testing. ETL jobs are executed from Control M in PV environment to verify control M Job schedule, dependency, parameters, etc are working correctly.
• Report testing - Adhoc reports are created for HRA enhancement and are validated against the data IN CAE database.
• Defect testing - Reverification of the code after the fix.
• Source to Target Mapping validation.
• Data validation Knowledge of ICD9, ICD10, CPT, HCPCS, NDC.
• Uploaded all the test cases to HP Quality Center and executed in Test lab.
• Worked on Monthly Production Releases.

Confidential, Jacksonville FL.

Skill/Tools: MS SQL Server 2008, MS Visio, MS Office Tools, .NET, AQT, Oracle, SnagIt, HP Quality Center etc.

Senior Data/QA Analyst

Responsibilities:

• Performed as a Test lead for few projects.
• Execution status reports generated using Quality Center.
• Data Analysis and Research.
• Involved in SQL testing scripts for Backend Testing.
• Performed ETL/Data warehouse Testing.
• Monthly Production Releases.
• Service Now Tickets in support of operation.
• Data validation using SQL queries against SQL Server and Oracle database.
• Developed Job aid tools for team using MS Excel for Testing.
• Performed manual Testing for the project.
• Actively involved in User Acceptance Testing phase for each software release.
• Generated bug reports based on QC process.
• Participated daily SCRUM calls.
• Performed smoke test on a daily basis.
• Worked with Onshore-Offshore resources.
• Participated in Regression, Integration, Database testing, etc.
• Identified, researched, investigated, analyzed, defined and documented business processes and Use Case Scenarios.
• Experience with Software development life cycle (SDLC) methodology, creating Test Plans based on Functionality and Business rules, creating Test Cases, Test scripts for each functionality of the application / Test Cases.
• Timely escalations of concerns and issues beyond control and follow-up for resolution.
• Developed and implemented processes and reports using SQL and MS Excel.
• Worked with IT Business Analyst, Development and Testing teams to accomplish timely release objectives.
• Project progress documented in MS Project and MS EXCEL.
• Participated in requirement and design project meetings.
• Worked on Rebranding Projects from Confidential to Voya Financials

Confidential, Jacksonville FL.

Skill/Tools: MS SQL Server 2008, SSRS, SSIS, Rational Quality Manager, Team Foundation ServerMS Visio, MS Office Tools, .NET, SnagIT etc.

Senior QA Analyst / Data Analyst

Responsibilities:

• Performed as a test lead for several releases.
• Developed and implemented processes and reports using T-SQL, SS packages and MS Excel.
• Performed manual and automated testing for Confidential 's DeskTop application.
• Actively involved in Confidential Desktop Quality control process to ensure that no errors before every releases.
• Generated bug reports based on QC process.
• Worked with Onshore and Offshore of Confidential team in India.
• Participated daily SCRUM calls.
• Performing daily connectivity test and Smoke test.
• Participated in Regression, Integration, Database testing, DR etc.
• Identified, researched, investigated, analyzed, defined and documented business processes and Use Case Scenarios.
• Performed manual testing during the major Desktop releases.
• Experience with Software development life cycle (SDLC) methodology, creating Test Plans based on Functionality and Business rules, creating Test Cases, Test scripts for each functionality of the application / Test Cases.
• Involved in SQL testing scripts for Backend Testing.
• Timely escalations of concerns and issues beyond control and follow-up for resolution.
• Study and Review the enhancing Requirement and Design Document.
• Planning and execution of the tasks for the team.
• Coordinating the daily calls between onsite and offshore and responsible for a smooth work flow.
• Responsible for all project documentations.
• Developed and implemented processes and reports using T-SQL and MS Excel.
• Provided business analysis as part of my job functionality.
• Developed automated reporting using process developed in MS Access and MS EXCEL.
• Worked with IT Business Analyst, Development and Testing teams to accomplish timely release objectives.

Confidential Jacksonville FL.

Skill/Tools: Teradata, Mainframe, MS Visio, MS Office, SharePoint, LINUX, AutoSys scheduler, Maximo, ITSM Remedy,CA7, HP Quality Center etc.

Production Support Consultant

Responsibilities:

• Worked with Onshore,Offshore resoureces.
• Developed and implemented processes and reports using Teradata SQL and Teradata tools like BTEQ.
• Designed and developed team intranet sites using SharePoint and SharePoint designer tool.
• Responsible for maintaining and updating EOM process Sharepoint site.
• Participated in CAB meetings.
• Involved in Teradata Hardware and Software process.
• Designed and developed various management reports on Teradata system performance.
• Performed manual testing during Teradata software upgrade.
• Experience with Software development life cycle (SDLC) methodology, creating Test Plans based on Functionality and Business rules, creating Test Cases, Test scripts out of Manual Test Scripts/Test Cases.
• Developed automated reporting using process developed in MS Access and MS EXCEL.
• Identified, researched, investigated, analyzed, defined and documented business processes and Use Case Scenarios.
• Worked on Mainframe to support Teradata ETL process.
• Provided Application production support using application run-book.
• Performed Mainframe ETL and Data warehouse testing
• Responsible for project documentations.

Confidential, Pleasanton CA.

Skill/Tools: SQL Server, MySQL, HTML, ASP .NET, VB, Java Script

Business Analyst / Programmer

Responsibilities:

• Actively involved in requirement gathering and requirement management.
• Conducted JAD sessions with different team and development team as and when necessary to elicit use cases.
• Developed requirement traceability matrix and attribute traceability matrix to manage changing requirements.
• Created full life cycle documentation from product requirements in the developmental stage to functional specifications for the completed modules of application components.
• Developed and created several MySQL databases and tables for supporting the ISF website reporting.
• Provided day to day management web tracking reports using MySQL database to ISF Management.
• Interviewed the domain experts and carefully recorded the requirements in the format that can be reviewed and understood by both business people and technical people.
• Assisted in documenting various business related texts.
• Helped in designing workflow diagrams with the help of MS Visio.
• Prepared documents to conduct professional meetings for the client and team members.
• Participated in enhancement meetings to make the product more effective in real time. Worked with developers and QA Analyst.
• Extensively used brainstorming sessions to generate ideas.
• Done extensive query tuning on MYSQL to make ISF web reports more responsive.

Confidential .

Skill/Tools: Oracle Forms, VB, Crystal Reports, UNIX, Windows.

Programmer

Responsibilities:

• Worked according to the activities/roles laid down in each phase of software development life cycle.
• Analyzed and documented the system specifications, Business requirements and detail design of the software for full understanding of the business.
• Performed requirements analysis and gathering.
• Conducted JAD sessions for communicating with all the project directors and stakeholders. Created process workflows, functional specifications and project initiation artifacts.
• Analyzed, documented and managed all project requirements and change to requirements throughout the software development lifecycle.
• Created full life cycle documentation from product requirements in the developmental stage to functional specifications for the completed modules of application components.
• Involved in business and system process flows, user administration, requirements and assumptions.
• Designed forms on Oracle Developer 2000 for the Billing Management information system
• Created SQL queries
• Developed test cases and scripts based on business requirements for the GUI, functional, User Acceptance & System Back-end testing.
• Designed and developed reports using Crystal reports.
• Coded and scheduled several back-end table loading process using PL/SQL and Unix shell scripting and scheduled using UNIX Crontab.
• Worked closely with QA and Developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs.
• Maintained a close and strong working relationship with teammates and management staff to achieve an expected QA result for the project team.
• Involved in Testing of the Developer 2000 Code with developer in Unit Testing phase.
• Reviewed and evaluated all the modules of the software before delivery to user’s to confirm its meeting the standard criteria.
• Interacted with developers & various members of my team to discuss and resolve defects and their priorities.