EXPERIENCE SUMMARY:

• Over 7 years of experience as Data Analyst/Business Analyst with experience in data warehousing/business intelligence which includes analyzing and modeling business processes, requirements gathering, design, analysis, development, implementation and testing of various complex applications
• Proficient at translating strategic IT user requirements into specific database capabilities
• Ability to write clear documentation of procedures, and ability to write specifications for data models to be developed
• Excellent TSQL,PL/SQL skills with both DML,DDL commands and demonstrated ability to write complex queries for purpose of analyzing data and evaluating how information needs might be translated into back end database structures
• Experience in scheduling meetings, preparing meeting minutes, action items and follow - up
• Expert in MS Excel for data analysis and reporting using its various functionalities such as VLOOKUP, PIVOT Table, Text to Columns, etc.
• Experience working with various relational database management systems such as MS Access, MS SQL Server, Oracle, Teradata and IBM Netezza
• Have actively involved in design impact analysis, data modeling and project design, development (analysis, programming, and testing), implementation, maintenance and administration
• Have performed several roles and have been part of full SDLC of several Development Projects
• Experience in writing requirements for ETL Data warehousing, database profiling.
• Solid understanding of master data management (MDM).
• Experience in developing and executing test cases, test scripts

TECHNICAL SKILLS:

Platforms: Windows 7,Unix,Red Hat Linux

Databases and Tools: MS SQL Server 2008/2012,Oracle 11g, Teradata, IBM Netezza, Toad

ETL: SSIS, Informatica, Abnitio, Data Stage

BI Tools: Microsoft SSRS, Tableau, Cognos, MicroStrategy, OBIEE, SAS,Business Objects

Language: TSQL,PL/SQL, Python

Quality Management: JIRA,HP QC

Office Applications: Ms Word, Excel, PowerPoint, Visio

PROJECT EXPERIENCE

Confidential, Charlotte, NC

Sr. Data Analyst

Responsibilities:

• Create source to target mapping and store them in a centralized table
• Analyze stored procedures to capture logic and store them in mapping table
• Act as point of contact for mapping related issues and mentor new team members on legacy and new system architecture
• Use TSQL to validate source to target mapping
• Create data flow diagram in PowerPoint to document data movement from source to target
• Use bulk copy program(BCP) to load data from legacy production environment to new environment for regulatory reporting
• Consult with data architect to review DDL scripts to standardize database objects creation
• Identify, document data gap between legacy and new system and notify stakeholders
• Use SSIS to automate data load from flat file, Excel sources daily and monthly to SQL Server tables using various transformations such derived column, data conversion, script task
• Identify reconciliation differences for column, row count between CRDRS and CoRS for specific business date using TSQL, classify issue type and notify stakeholders
• Prepare and load test data from production to QA environment for testing
• Document data type/length differences between CRDRS and CoRS tables
• Convert legacy stored procedure using mapping document, test and compare results between the two systems
• Develop documents for data lineage, metadata and data dictionaries and upload to Confluence page
• Attend daily meeting with team lead and discuss on the progress of the assigned task

Environment: TSQL, SQL Server 2012, SQL Server 2014, SQL Server Data Tools, Visual Studio 2015, MS Excel, MS Word, MS PowerPoint, MS Visio 2010, Windows 7, JIRA

Confidential, Charlotte, NC

Sr. Data Analyst

Responsibilities:

• Identified data quality issues in the target system(Saber2) and communicated findings to the upstream data provider(Artic)
• Performed data quality checks on Key Business Elements (KBE) writing complex queries to ensure data validity, accuracy and completeness
• Identified data gaps and missing elements in the target system and notified source data providers
• Partnered with project manager and upstream data provider team to create data requirements for Mortgage, Cash, Equities products
• Attended daily meetings to discuss project task and statuses
• Uploaded data analysis artifacts to internal Confluence page
• Involved in defining the source to target data mappings
• Prepared business logic document(BLD) partnering with stakeholders to perform data quality checks on key business elements
• Wrote SQL queries to verify and validate business rules

Environment: IBM Netezza, TOAD, SQL, MS Excel, MS Word, MS PowerPoint, Windows 7, JIRA

Confidential, Charlotte, NC

Sr. Technical Data Analyst

Responsibilities:

• Identified key data elements used to develop each regulatory reports and provide metrics to senior management for weekly reporting using Excel and PowerPoint
• Profiled data for identified data elements, document technical metadata and define using MS SQL Server 2012 for the Counterpart Risk System(CORS) NextGen project
• Created Technical Data Dictionary for BCBS project
• Wrote complex SQL queries for ad hoc data analysis and support data lineage task
• Reviewed data elements, metadata definitions with respective lines of business(LOBs) to ensure correctness
• Create a weekly ad hoc report using Excel, PowerPoint on project status for senior management
• Worked with Internal Auditors to validate the accuracy and completeness of the data flow designed by Audit team in collaboration with Counterparty Risk Management(CCRM) team
• Worked directly with report SMEs, senior management to validate accuracy of data lineage from system of origin(SOR) to downstream reporting systems
• Identified and documented gap on key data elements that didn’t have stored procedures, log files and transformation logic
• Identified gap of data movement from CRISP to external Sungard Adaptiv system
• Remediated gap consulting with SMEs, document and update the lineage template and concerned parties
• Provided support for internal project identifying, researching and analyzing issues in order to develop solutions and resolve recurring issues
• Helped with data analysis to improve operation including uncovering data anomalies and performing research of other forms of key operational data to enable efficiencies and overall data quality
• Modified and updated existing CRISP data flow diagram for Counterparty Credit Risk Management after review with SMEs
• Worked with AbInitio Metahub team to load Excel lineage templates into Metahub portal

Environment: TSQL, SQL Server 2012, SSIS, Ab Initio, MS Excel, MS Word, MS PowerPoint, MS Visio 2010, Windows 7, SharePoint

Confidential, Columbus, OH

Sr. Data Analyst

Responsibilities:

• Worked extensively on data quality issues, standard Business Data Requirements(BDR) structure for all lines of Confidential 's business before loading the files into access database to create weekly reports
• Worked closely with subject matter experts(SMEs), Data Management Council(DMC), Data Review Board(DRB) on metadata migration from existing legacy metadata hubs to centralized ICDW data warehouse
• Analyzed current reporting inventory, reverse engineered and decomposed critical reports to SOR attributes
• Analyzed complex SQL queries of in scope reports and identify critical elements, complex calculation logics and capture them in Enterprise standard requirements template
• Worked with data management council(DMC) on data standardization, de-duplication, data definition as part of master metadata management(MDM)
• Prepared data mapping document in excel for data migration from legacy Access database to Oracle database
• Performed gap analysis on various documents and outlined remediation steps
• Created weekly PowerPoint reports with Gantt chart and provide tasks completion update to the manager
• Used SharePoint extensively to download necessary documents from all lines of business to analyze, review data quality, correct them and load them to the access database to create weekly data analysis reports
• Attended daily conference calls with team members to update on the progress of data quality issues and resolution
• Reached out to each line of business to communicate the data quality, BDR structure, invalid value issues and fix them for the next weekly data analysis run
• Uploaded weekly data analysis reports to SharePoint and sent it to each line of business and respective stakeholders with major issues identified during data analysis process
• Worked with AbInitio Metadata Portal web application to monitor the data load from legacy Access database to the Oracle database
• Reviewed Change set from the AbInitio ETL process about the data load rejects, error messages and corrected them as a data analysis team
• Wrote complex SQL queries against the target Oracle database to generate reports and compare against legacy Access database reports
• Validated and tested regulatory reports built using Cognos against the staging table
• Tested, analyzed and corrected record mismatches between legacy Access database and the target Oracle database writing SQL queries

Environment: MS Access 2007, SQL, Oracle SQL Developer, Teradata, AbInitio, Cognos, MS Excel, MS Word, MS PowerPoint, MS Visio, Ms Project 2010, Windows 7, SharePoint

Confidentia, Foster City, CA

Data Analyst

Responsibilities:

• Extensively involved in every phase of the SDLC process starting from Inception to Transition
• Interviewed Business Users to gather reporting / data requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Prepared Functional Requirements from System Users that provided appropriate scope of work.
• Wrote complex SQL and PL/SQL queries to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results
• Created Data mapping, logical data modeling coordinating with data architects, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements
• Conducted meetings with various IT groups to get requirements
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
• Created adhoc reports and pivot tables in Excel using advanced excel functions
• Worked on Document for Version Controlling, to maintain up to date changes in the Documents
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications
• Analyzed the Business Object reports/extracts and submitted to the Risk manager after the proper validation.
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: SQL, PL/SQL, ETL Informatica, HP QC /ALM, Agile, Teradata, Windows and UNIX, TOAD for Oracle 10g, MS SQL Server 2008R2, DB2,Excel, Access, MS PowerPoint, MySQL, MS Excel, BI Business Objects

Confidential, Madison, WI

Data Analyst

Responsibilities:

• Worked closely with data mapping SME and understand the business rules for acceptable data quality standards and create metadata and mapping document.
• Performed data profiling on datasets with millions of rows on Teradata environment, validating key elements, ensuring correctness of codes and identifiers, and recommending mapping changes.
• Performed unit testing on transformation rules to insure data moved correctly.
• Researched and fixed mapping issues pointed out by QA team during regression tests.
• Interfaced with business users to verify business rules and communicated changes to ETL development team.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Involved deeply in all phases of End-to-End testing which includes user acceptance testing, Functionality Testing, Regression testing, performance testing and integration testing.
• Involved in source Data profiling and identification by writing complex SQL queries
• Interacted with automation testing team to clarify on regression test suites and test cases to be built.
• Perform Source-to-Target Data Mapping in Informatica (ETL) and optimized mappings.
• Designed and implemented basic SQL queries for testing and report/data validation.
• Understood the business process of the claim application systems adjudicate the claims received in local format and route the payable and reversed claims to payment system to produce checks.
• Validated outcome of adjudication and payment 835 transactions according to HIPAA guidelines
• Created mapping specification to source from Member data, provider data, created Price rules, Pricing Calculation methods and Benefit rules for claims
• Worked with the Whole Claim Pricing Price rules like Base Rules, Cap Rules and Outlier Rules

Environment: SQL, PL/SQL, Oracle, Informatica, DB2, Quality Center, XML, Teradata, Visio, AGILE, Erwin, Mainframe systems, Cognos, MS SQL Server 2008, MS Excel, Windows Server 2008