SUMMARY

• Led business and data analysis for 7 years in end to end implementation working through all SDLC stages from Conception through Implementation.
• Created Business strategy, BRDs, TRDs, Source to Target mappings (STTM), UAT Plan, UAT cases for various applications.
• Experienced with data warehouse applications in finance and healthcare domain.
• Led end to end implementation for mission critical and complex project for Emblem Health - HEALTH INFORMATION EXCHANGE, OBAMA CARE.
• Processed and mapped Customer information with assigned plan benefits set information received through EHR.
• Extensive experience in using Toad and data load/export utilities like Fast Load and Fast Export.
• Exposure in Extracting, Transforming and Loading (ETL) data from other databases and text files.
• Excellent skills in retrieving the data by writing simple/ complex SQL Queries using SQL Management Studio.
• Extensive experience in reviewing Business Requirement Documents(BRD), Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Highly proficient in designing Data Analytics.
• Worked extensively in designing T SQL scripts to design data analytics.
• Created advanced reports using SQL Server Reporting Services (SSRS) and advanced Excel.
• Worked in designing data model and dimensional model according to project design and based on technical specification.

TECHNICAL SKILLS

ETL Tools: SSIS, SSRS, Tableau

Databases: SQL Server, Oracle SQL, MySQL

Operating Systems: Windows 95/98/ NT/2000/XP/Vista/7.0

Modeling Tools: Microsoft Visio, Rational Rose, Share Point 2010

Query Tools: SSMS 2005/2008, Oracle SQL Developer, Toad 9.7.2, SQL PLUS

Auxiliary Skills: Ms Excel, Outlook, Lotus Notes, MS Word, MS PowerPoint

PROFESSIONAL EXPERIENCE

Confidential, Yonkers, NY

SR. BUSINESS ANALYST

Responsibilities:

• Worked with end clients to discuss the strategy and proposal to design new applications and products in various areas like claims, eligibility and encounters.
• Gathered requirements to write Business Requirement Document (BRD) to design various claims and encounters applications.
• Created mapping documents to define transformation rules to translate requirements into technical design.
• Created test plan and test case documents in TFS tool to validate all the requirements, newly developed processes and all the technical objects.
• Used parallel testing, regression testing and unit testing to verify the applications from technical and functional standpoint.
• Created application overview (AOV) documents for various applications to explain the entire process and all the objects created for the application.
• Designed new application for claims repricing to implement the price recommendation provided by third party healthcare provider.
• Designed new processes to automate the existing claim audit process.
• Worked with NY State on various claims Encounter applications to transfer 837 files and receive 999 files for various third party claims.

Confidential, New York, NY

SR. BUSINESS ANALYST

Responsibilities:

• Worked on research analysis project for Rental Car product to be extended in Int'l domain with presenting the market potential across countries for OLA(Online Agency) and devised the strategy to implement steps for the company
• Designed different Data Analytics and reports to provide the data insides to support the front end teams in promoting new features to the website
• Implemented strategies based on data analysis to determine current market trends
• Designed executive summary reports based on data analytics to present the insights to high level management by using different tools like Tableau
• Validated and ensured creation of test cases to better clarify and communicate requirements
• Guided Interns to help them understand the culture of the firm and to move swiftly in day to day technical activities.
• Designed SQL classes to help learn basic fundamentals of relational database and structured query language.

Confidential, New York, NY

SR. BUSINESS DATA ANALYST

Responsibilities:

• Gathered functional and nonfunctional requirements from business by using various techniques such as story board and workshops.
• Led the impact analysis exercise and facilitated session with other IT and business teams across Emblem Health
• Performed detailed risk analysis to identify possible issues and bugs
• Managed and led the team of 6-8 people in the entire effort from analysis to validation phase of the SDLC.
• Worked closely with other SME’s to review implemented requirements for the sign off.
• Created BRD and TRDs for different products of HIX. (e.g. Qualified Health Plans, State Sponsored Plans)
• Created data flow architecture for the multiple data tiers involved in HIX architecture using MS Visio.
• Designed STTMs (Source to Target Mappings) based on mapping rules provided by business to process new state and extended vendor layout files to Data Warehouse and provision the in views for Customer Service Applications to access.
• Created Data Modeling Change Requests (DMCRs) to create new tables and columns in existing tables to process the new files as per new architecture.
• Performed heavy validation including end to end regression testing of new HIX member data with plan coverage to improve the SLA of processing and accuracy of data to be provided to Customer Service for better customer support.
• Developed and managed client presentations for the business to provide comprehensive report on building the architecture based on requirements provided.
• Performed the role of SME for the final sign off for validation.
• Provided team with direction to resolve issues, communication including gathering status reports and worked closely with senior management to raise possible risks.
• Performed analysis and implementation of PCRs (Project Change Requests) to address the new required for NY State department of Health.

Confidential, New York, NY

Advisory- Business/ Data Analyst

Responsibilities:

• Performed data analysis and data quality check by designing SQL scripts in Oracle environment and generated reports in MS Excel for clients in Europe Offices
• Wrote SQL scripts to design complex analytics to perform raw files data check against leaked patient health information.
• Developed and managed final presentations for the client meetings by keeping the security and integrity of the engagement.
• Worked with the tool called dTIndex to perform the complex search methodology called dT searching to find out various leaked patient health information (PHI).
• Documented findings of changes after communicating with the client orally and through written means to confirm changes accurately
• Worked closely with the team to perform the additional responsibility of analyzing, mining and designing analytics to meet deadlines
• Managed and prioritized the structure of the project work
• Documented findings of changes after communicating with the client orally and through written means to confirm changes accurately
• Worked in analyzing and mining data to design analytics for various mortgage finance users
• Prepared presentations for the client to explain the work flow of the project
• Wrote T SQL scripts to design complex analytics based on various Regulations and OCC consent orders
• Designed analytics based on compliance testing plans designed by the client for regulated real estate bodies
• Designed reports using Tableau to provide more comprehensive dimensional information
• Managed the Data Mining Project and Analytics tracking sheet to make sure that the correct results were obtained according to the review procedure of particular source/test step
• Worked closely with the team to perform the additional responsibility of analyzing, mining and designing analytics to meet deadlines

Confidential, Framingham, MA

Data Analyst

Responsibilities:

• Migrated the data and structure of the data from SQL 2005/08 R2 to dynamics GP using smart connect tool
• Worked with Financial database servers on implementing them on dynamics GP platform
• Developed critical financial reports by using SSRS on detailed data analysis for VP and accounting managers
• Designed SSIS packages with complex transformation to implement new data structures and modify existing data structures
• Created SQL jobs by writing procedures with timely execution
• Monitored daily data processes and executed packages
• Worked Excel 2007 Macros and Pivoting and Un pivoting the data for critical reports and performing complex formulas