SUMMARY:

• 2+ years of experience in the Information Technology (IT) Industry serving as a Data Analyst in Data governance and warehousing environment.
• Excellent interpersonal skills and a fast learner.
• Broad knowledge of mortgage industry, health care, insurance and several other financial institutions.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, Data Warehouse, Data Modeling and Design.
• In - depth working knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases such as requirements gathering, analysis/design, development and testing.
• Full understanding of RAD, Waterfall, RUP and Agile methodologies.
• Extensive experience on interaction with system users in gathering business requirements and involved in developing projects.
• Worked extensively in Data consolidation.
• Experience in Data Transformation, Data Loading, Modeling and Performance Tuning.
• Extensive experience in Data Analysis and ETL Techniques for loading high volumes of data and smooth structural flow of the data.
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary and Interface requirements documents.
• Created and executed Test Plan, Test Scripts, and Test Cases based on Design document and User Requirement document for testing purposes.
• Extensive experience in the testing environment, which included User Acceptance Testing (UAT), functional testing and system testing and defect tracking.
• Acted as a liaison between the development team and the management team to resolve any conflicts in terms of requirements.
• Experience with SQL, PL/SQL objects
• Interacted with all levels of the project development team, from end users to Software Developers.
• Worked with heterogeneous relational databases such as Teradata, Oracle, MS Access and SQL Server.
• Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups.
• Experience in Other Utilities/Tools/Scripts like Shell Scripting, SQL Plus, SQL Loader, Export and Import utilities, TOAD 9.1 and Visio 10.0.
• Well versed with Data Migration, Data Conversions and Data Extraction/Transformation/ Loading (ETL).
• Experience in designing and developing Data Warehouse applications using ETL and Business Intelligence tools like Informatica Power Center, Datastage, Mainframes, OLTP, OLAP, Business Objects..
• Experience with creating reports using Business Objects, Crystal reports.

TECHNICAL SKILLS:

Languages: Teradata, SQL, PL/SQL

Reporting Tools: Business Objects 6.5, Crystal Report, SAS, Tableau, and SAP Lumira, SAP BO

RDBMS: Teradata, DB2, Oracle, SQL Server 2005/2008/2008 R2/2012, My SQL, MS Access

Data Warehouse Concepts: ODS, Star Schema, Snowflake schema, OLTP, OLAP

Operating Systems: UNIX, MS Windows 2000 & NT, MS DOS

Design: Entity-Relationships, Data Flow Diagrams

Tools: Informatica, Erwin, TOAD, Powerdesigner, Teradata, Rational rose, MS-Visio, E-R Studio, DB Visualizer, SQL developer, SQL*Loader, MS-Project, HPQC

Desktop Software: Microsoft Word, Excel, and PowerPoint.

PROFESSIONAL EXPERIENCE:

Confidential, Dorchester, MA

Data Analyst

Roles and Responsibilities:

• Responsible for gathering required documents, Designing and querying relation databases.
• Data Integration between multiple sources and environments
• Proficiency in building relational databases, writing complex SQL statements, and building connections to data warehouse environments .
• Building and implementing a relational database supporting data management strategy within Medtronic’s CVG quality system.
• Identifying the root cause for poor data quality within CVG.
• Lead execution of improvements to the CVG Quality Data Management SharePoint site collection.
• Develop site features such as Key Performance Indicator (KPI) scorecards, analysis dashboards, and interactive web databases.
• Enable analytics by developing data connections to existing Quality Data Warehouses
• Enhance and integrate existing databases to facilitate consistent datasets and the infrastructure to enable robust data analysis
• Coordinate with end users and Medtronic IT to ensure requirements are tested and satisfy software validation criteria
• Assist in the development of strategy measurement architecture.
• Created a database that allows FCAs, CAPAs, PHO and other quality events to share a common link for trending purposes.
• Generated reports on daily basis to determine the health of quality system and provide insights into quality Issues.
• Responsible for creating Mapping Documents. (Given Audit files where I had to map with CVG File).
• Monitor and identify the quality of data and assist in resolving the data issues.
• Highly involved in documenting for future reference and uploading it to SharePoint site.

Environment: MS Access, MS Excel, TrackWise, SAP Lumira, Visio, SharePoint, MS Office, Business Objects.

Confidential, Dayton, OH

Data Analyst

Roles & Responsibilities:

• Gathered and Analyzed Business requirements walkthrough with the business owners
• Involved in writing Test Plans and Test Cases.
• Performed testing in different environment as per needed.
• Involved in extensive Data validation by writing several SQL queries and involved in back-end testing and worked to resolve data quality issues.
• Checked claim data and explain finding to client and help present the information. .
• Developed statistical and analytical report from medical claim.
• Generated reports on claims on a daily or weekly basis. Finding number of outpatient or physician visits and number of claim for the diagnosis.
• Review medical claim and use analytical tools such as Excel to analyze data
• Conducted internal claim data review and create medical claim analysis report
• Develop, document and perform testing and validation as needed.
• Coordinated with business analysts to resolve data gap.
• Highly involved in preparing Source to Target mapping documents.
• Performed Data Analysis and Data Validation by writing SQL queries.
• Assist in ETL development, documentation and testing as needed.
• Work with SMEs to develop business rules that support the transformation of data
• Perform analysis of all data into, out of and within CareSource as needed.
• Identify and quantify data issues within the organization and assist in the development plans to resolve data issues.
• Facilitate discussions between end users and data modelers as needed.
• Monitor the quality of data submitted to regulatory agencies.
• Support the Verification of Data Accuracy.
• Support regular data management processes and ad hoc user requests.
• Created several reports monthly/weekly based on various Campaign for different end users

Environment:: Teradata, SQL Assistant, MS Excel, MS Office, SQL Server (Facets), Informatica, HPQC, ALM.