Employment History:

Confidential

Data System Analyst

Responsibilities:

• Reviewed business requirement documentation, technical architectures and ensure that documents are clear and accurate to meet project's expectations.
• Worked with stakeholders to document data elements definition, profiled, standardized and cleansed data sources. Captured metadata for data elements and created a data dictionary.
• Created conceptual and logical customer data model and developed sql scripts for physical data model creation on MS-SQL Server. Validated the creation of new database objects and loaded data from source system files.
• Expertise in understanding and writing complex SQL using Toad and Aginity.
• Experienced in analyzing, compiling, verifying, extracting, converting data, validating data and identifying data inconsistencies and errors for BI projects.
• Developed summary reports and provided input to business and project team on data and database issues. Assisted in preparation of test strategies, test plans and test cases to identify code/data errors and inconsistencies.
• Worked and experienced in creating metadata and data dictionaries, and designing and implementing reports
• Worked on QlikView it enables users to gain unexpected business insights by understanding how data is associated
• Experience in developing reports using a variety of business intelligence tools.
• Used SQL, MS SQL Server 2008, XML and Visio.

Confidential

Responsibilities:

• Interacted with business stakeholders/data owners to clarify business requirements, data related issues and created functional specification for ETL data conversation solutions.
• Designed source to target mapping including data Workflows, business rules/transformation logic and validated that data conversion result was delivered according to business requirement and changed request. Profiled data elements and reviewed and analyzed Conceptual/logical data Model to identify any data integrity related issue.
• Took the lead on gathering, analyzing and documenting source inventory system and provided gap analysis report to make sure that there is no business impact as a result of the data conversion.
• Experienced in analyzing, compiling, verifying, extracting, converting data, validating data and identifying data inconsistencies and errors for BI projects.
• Worked and experienced in creating metadata and data dictionaries, and designing and implementing reports
• Worked on QlikView it enables users to gain unexpected business insights by understanding how data is associated
• Expertise in understanding and writing complex SQL using Toad and Aginity
• Experience developing reports using a variety of business intelligence tools
• Used MS SQL Server 2008, Oracle11g, DB2, HP Quality Center 10.0, and dB visualizer v9.0.9, Erwin Data Modeling 9.0, Visio and SharePoint.

Confidential

Business/Systems Analyst

Responsibilities:

• Profiled source data using Ataccama DQ Analyzer, analyzed the profiling result, documented key findings and presented them to stakeholders. Recommended key actions to improve data quality and establish data quality best practices.
• Gathered and documented business and technical requirements related to data management through elicitation and consultation with internal clients.
• Researched, documented and developed reports and other solutions as required to enforce Data standardization and Data Governance program.
• Designed source to target mapping including data Workflows, business rules/transformation logic and validated that data conversion result was delivered according to business requirement and changed request. Profiled data elements and reviewed and analyzed Conceptual/logical data Model to identify any data integrity related issue.
• Developed data cleansing and business matching rules. Maintained daily Issues Log, Change Management Log, User Request and Application Access Control Log as required.
• Reviewed completed work to verify its quality and accuracy according to developed specifications.
• Worked and experienced in creating metadata and data dictionaries, and designing and implementing reports
• Worked on QlikView it enables users to gain unexpected business insights by understanding how data is associated
• Experienced in analyzing, compiling, verifying, extracting, converting data, validating data and identifying data inconsistencies and errors for BI projects.
• Expertise in understanding and writing complex SQL using Toad and Aginity
• Experience developing reports using a variety of business intelligence tools
• Created source to target mappings for data integration project and Investigated data by creating SQL scripts/stored procedures to validate data issues and their business impact.
• Continuously educated users on Data Quality, Data Governance, Master Data Management, various application functionality and improvements of the technology and operations team in order to facilitate further data process improvements and thus enriching the solution design process.
• Used Enterprise Architecture, Ataccama DQ Analyzer, DQ Global, Toad, Navicat, Visio and MySQL.

Confidential

Senior Consultant

Responsibilities:

• Installation and configuration of the IBM initiate MDM Standard Edition Engine Software, Workbench,
• Creation of MDM HUB databases and configuration of member type algorithms, Hub deployment configuration Instance.
• Reviewed analyzed, standardized, cleansed extracted derived data and created UNLs. Generated and deployed of graphical weights representation for review. Run a Bulk Cross Match and Loaded Entity Data into the hub database.
• Installed Pair Manager, generated and modified threshold analysis sample pairs to set the right threshold. Installed, deployed and configured inspector connection and use Inspector to validate the Hub.
• Worked and experienced in creating metadata and data dictionaries, and designing and implementing reports
• Worked on QlikView it enables users to gain unexpected business insights by understanding how data is associated
• Experienced in analyzing, compiling, verifying, extracting, converting data, validating data and identifying data inconsistencies and errors for BI projects.
• Used ER/Studio Data Architect v9.0, MS-Visio DB2 v9.7, MS SQL Server 2008.
• Gathered business requirements and created data mapping for new initiatives. Wrote Operations Support document and developed scripts to validate the extract and loading process.
• Expertise in understanding and writing complex SQL using Toad and Aginity
• Experience developing reports using a variety of business intelligence tools
• Used IBM Initiate MDM Standard Edition v10.0, Health Level 7 HL7 record formats, XML, MS Access, MS-Office, MS SQL Server 2008 and Visio.

Confidential

Data Analyst

Responsibilities:

• Responsible for validating the information to ensure quality and data governance standards are met.
• Developed the automation required for standard reporting and used Embarcadero ER/Studio to create data classification reports which were provided to data owner/stewards to identify the data sensitivity and retention
• Assisted in the creation of data dictionary, analysis of the source data and the roll out and population of the IBM Business Glossary and Metadata. Work with stakeholders to document data elements definition.
• Experience developing reports using a variety of business intelligence tools
• Worked and experienced in creating metadata and data dictionaries, and designing and implementing reports
• Used ER/Studio Data Architect v9.0, MS-Visio DB2 v9.7, MS SQL Server 2008.
• Experienced in analyzing, compiling, verifying, extracting, converting data, validating data and identifying data inconsistencies and errors for BI projects.