RELEVANT EXPERIENCE:

• 6+ 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, MN

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 Confidential ’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 Confidential 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 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 out Confidential t 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 Confidential 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.

Confidential, New York, NY

Data Analyst

Roles & Responsibilities:

• Conducted Business requirements walkthrough with the business owners.
• Gathered essential business requirements and transformations.
• Coordinated with business analysts to resolve the data gaps.
• Identified source and prepared source to target mapping documents.
• Served as a liaison between business and IT and business and the data analysis team.
• Worked with Massively Parallel Processing to provide higher level of availability and scalability
• Divide the larger problem into small units for processing across SQL.
• Worked with SME’s, process owners, process managers to identify logic for the reports and set appropriate thresholds for defects/exceptions.
• Analyzed, documented and prioritized CTQ’s(Critical to Quality) processes.
• Wrote complex Teradata SQL queries to pull the metrics for CTQ’s, in order to ensure that the process is within agreed tolerance limit.
• Involved in extensive Data validation by writing several SQL queries and involved in back-end testing and worked to resolve data quality issues.
• Regularly provided valuable feedback to the Dashboard team so as to enhance the visual reporting experience for everyone involved.
• Worked with the Business Intelligence (BI)/Execution Team to transit reports for day-to-day business use.
• Worked with the Business Intelligence team to get loan level reporting available to the business for the CTQ’s such that the details of the exceptions could be thoroughly assessed.
• Successfully coordinated dashboard User Acceptance Testing (UAT) with the business.
• Coached and mentored several new Data Analysts.
• Involved in Data analysis and Design and developed processes to bring the data to User tables for any Regulatory-reporting data needs.
• Worked on Source to Target mapping documents.
• Worked with the Process Engineer to build current and future state documents.
• Worked on Data Quality, Data Retention, and Data Governance.
• Clearly communicated information to diverse audiences.
• Data quality assurance (best practices, Data Quality rules (business, analytical, legal, retention)

Environment: Teradata SQL Assistant, Tableau, SAS, MS Excel, MS Visio, MS Office, Windows XP

Confidential, Downers Grove, ILL

Data Analyst

Roles & Responsibilities:

• Met with various groups, including business owners, SMEs (subject matter experts) and marketing team, for data requirements gathering in definition Stage.
• Performed Document Analysis to create Gap Analysis for client requirements, generated workflow process, flow charts and relevant artifacts.
• Defined and documented the vision and scope of the project in Data Requirement Documents and Requirement Specification Document.
• Performed Data Mappings based on the specified data requirements and to check for data uniformity and to modify /update the data fields.
• Verified Source to Target mapping and data validation.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Helped testers to define testing strategies based on the mapping.
• Wrote queries for SQL to pull required information from the database.
• Worked with the clients on the final signing process in the User Acceptance stages.
• Knowledge and experience with consolidating data from different sources for analysis and reporting.
• Involved in performance measurement of ongoing data collection to determine if a program is implementing activities and achieving objectives.
• Acted as a liaison between business users and technical team.
• Supported and reviewed ER Diagram as Logical Data Models.
• Data correlation and cleansing on data from multiple sources in multiple divisions.
• Designed, built and implemented a data governance framework including revenue recognition.
• Conducted market research and developed strategies for better customer experience and retention.
• Performed database quality evaluations for Adherence to Data Quality standards, Identification of data relationships and potential data integrity issues.
• Assessed and developed long-term strategic Data Governance goals, Data Quality Assurance processes, Master Data Management administration, and Data Retention Life Cycle policy implementation.
• Developed Data Security policy and processes.
• Obtaining, organizing, defining subject area Meta Data in applicable repositories (Teradata, SQL Server, Oracle).

Environment: Windows Vista, MS SQL Server, MS Visio, Oracle, Web Logic, MS Project, Informatica, Business Object XI, UAT, Defect Tracking Matrix, Teradata

Confidential, ILL

Data Analyst

Roles & Responsibilities:

• Wrote SQL queries in Teradata SQL Assistance to pull data from MSL views for marketing campaign projects.
• Involved in documenting business requirements and translating them into technical solutions.
• Created customized and adhoc reports for various campaign execution based on customer selection criteria.
• Created reports presented to the management for further decision-making on a campaign.
• Scrubbed data to accurately generate customer pull. Provide output files in various file format based on customer request.
• Reviewed specifications for feasibility of customer list, pull criteria and commit date.
• Executed Campaign based on customer request and reviewed execution log to keep track of the number of records going into and coming out of every job step.
• Created output counts report and sample records for customer approval/satisfaction.
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Commaa separated text, Pipe delimited text etc.)
• Executed campaign based on customer requirements.
• Responsible for designing documents for database application developments.
• Develop scripts for Tables, Stored Procedures, and Joins (SQL 2005, 2008 R2) tasks.
• Create Views to reduce apparent database complexity for end users.
• Actively monitor query performances on SQL sever using SQL Profiler and optimized it by creating appropriate indexes using Index Tuning Wizard.
• Create Stored Procedures to create dynamic SQL Queries to adopt dynamic environment.
• Created ETL package for data conversion using various transformations tasks.
• Created Tabular and Matrix reports using SSRS.
• Responsible for creating design strategies and mapplets for source to target, Joins and other data driven application.
• Worked with Excel, Pivot tables and charts for trend analysis.
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the business users in the required format.
• Scheduled tasks to run every day to update changes in the base tables.
• Prepare charts and graphs based on the monthly information in Excel.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.

Environment: SQL Server 2005/2008/2008 R2, Excel, Pivot tables, charts,ANSI SQL, Excel, Access, Windows 2000/2003/2008 server, XP, Teradata.