SUMMARY:

• 8+ years of Industry experience as a Data Analyst / Information Analyst / Project Manager with solid understanding of Data Management, Data Governance, Data Modeling, Data Analysis, Data profiling, creating data mapping documents and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
• Experience in data warehousing using IBM Infosphere DataStage & Quality Stage, Information Analyzer, MDM, manager, designer, director and administrator, DB2, MS SQL Server, Oracle 9.x/10g, SQL, PL/SQL under UNIX and Windows.
• Conducted detailed data analysis / reporting using IBM WebSphere Information Analyzer for the multiple sources from various systems.
• Experienced in forecasting the data space requirements using the features like Capacity planning, mapping source to target data using data lineage feature and also calculating the impact analysis.
• Extensive experience in different methodologies such as Agile, Waterfall, Conceptual, logical, Physical, Relational & Dimensional data modeling.
• Expert in writing Regular expression (Regex) commands.
• Developing Rule Based Data Quality Assessment.
• Experience in software installation, upgrades/patches, troubleshooting and maintenance on servers.
• Expert in writing SQL queries and optimizing the queries in Oracle, SQL Server 2008/2012.
• Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Performed data analysis and data profiling using complex SQL on various sources systems.
• Expert in IBM Infosphere Products, IIS Metadata Workbench, IIS Business Glossary, IIS Information Analyzer, IIS FastTrack, IIS DataStage, IIS Quality Stage, IIS Metadata Asset Manager, IBM MDM with their integration to BI Tools like QlikView.
• Experienced working with Excel Pivot and VBA macros for various business scenarios.
• Hands on Experience on Hadoop Data Lake with Hadoop Development and Hadoop Administration.
• Extensive experience in supporting Informatica, data extraction from heterogeneous sources.
• Experienced in automation and scheduling the ETL Tools using UNIX shell scripting configuring Korn - jobs.
• Excellent experience working and writing heavy complex SQL queries.
• Experience in Issue Management and Resolution, designing error and exception handling procedures to identify, record and report errors.
• Extensive experience using Microsoft Visio diagramming and vector graphics application.
• Excellent knowledge in preparing required project documentation and tracking and reporting regularly on the status of projects to all project stakeholders
• Extensive knowledge and experience in producing tables, reports, graphs and listings using various procedures and handling large databases to perform complex data manipulations.
• Excellent experience in troubleshooting test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos, QlikView, Tableau, Micro Strategy and Business Objects.
• Excellent experience in writing SQL queries to validate data movement between different layers in data warehouse environment.
• Excellent in creating various artifacts for projects which include specification documents, data mapping and data analysis documents.
• Involved in administrative activities such as Project/User creation, Roles Management, Import and Export projects, database configuration setup and dataset management.
• An excellent team player& technically strong person who has capability to work with business users, project managers, team leads, architects and peers, thus maintaining healthy environment in the project.

TECHNICAL SKILLS:

ETL Tools: IBM InfoSphere Products - IIS DataStage, IIS QualityStage, IIS Information Analyzer, IIS Business Glossary, IIS FastTrack, IIS Metadata Workbench, IIS Metadata Asset Manager, IBM WebSphere.

Databases: Oracle 11g/10g/9i, R14 MS SQL Server 2005/2008/2012.

Programming Languages: SQL, PL/SQL, C++, Python, HTML, UNIX, Shell Scripting

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Reporting Tools: QlikView, Cognos and Tableau

PROFESSIONAL EXPERIENCE:

Confidential, Greensboro, NC

Data Quality Lead

Responsibilities:

• Working Closely with Director of Data Management and Director of Data Governance to oversee organization’s data management program.
• Support Technical project managers to ensure that all aspects of the information analysis and requirements gathering process are completed with the highest degree of accuracy and quality, including the development and socialization of key project artifacts.
• Develop and participate in the review of requirements, data mappings, use cases and other artifacts and clearly communicate to both the business and technical team members the system requirements.
• Hands on Experience on Hadoop Data Lake with Hadoop Administration and Hadoop Development.
• Hands on Experience on Hive, Pig, Oozie Scheduler.
• Demonstrate the ability to define, analyze and translate functional and non-functional business requirements into activity diagrams source to target mappings, system use cases and supplemental specifications.
• Support ad hoc data requests within existing governance and security policies and best practices.
• Strong abilities to explain advanced data concepts to developers, architects, non-technical end users, and senior executives.
• Developing requirements for business intelligence, master data management and functional-data projects.
• Data profiling and harvesting of metadata.
• Data Cleansing and Data Standardization.
• Developing rule-based DQ assessments in four dimensions: completeness, conformity, validity, and accuracy.
• Implementing an ongoing DQ monitoring process.
• Regular Expression Commands writing for Data Quality, Data Profiling.
• Automation and scheduling of DQ Rule Assessment Project through scripting and command line interface for IBM Infosphere Server.
• QlikView BI Dashboards Development for Data Quality and Data Profiling and Data Governance efforts.
• IBM Infosphere configuration and installation with upgradation of newer Patches.
• Column Profiling and Data Analyzing using IBM Information Analyzer.
• Data Analysis Report Generation from IBM Information Analyzer.
• Data Quality Rules creation and configuration on IBM IIS Information Analyzer and IBM IIS DataStage.
• Data integration with Data Quality and Analyses from various sources.
• Deployment of Reporting structure For IBM DataStage and IBM Information Analyzer.
• Identify business rules for data migration and perform data administration through data models and metadata.
• Automation of Project to execute rules and reports using Unix Scripting for IBM Information Analyzer.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Involved with Design and Development team to implement the requirements Utilizing Meta Data for Business Glossary for Data Governance.
• Involved in the data migration, data lineage and also studying the data impact analysis.
• Modified DML/DDL scripts for Oracle 11G databases. Using Regular-Expression (Regex)
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Hands on experience in designing data models and working with database developers to implement reference data applications.
• Responsible for developing, designing and implementing the standards and processes to support the Data Quality.
• Changes in the data model as per the customer needs Co-ordinate with DBA and application developer to resolve any discrepancies in the data model in regards to current model.
• Hands on experience working with Oracle and DB2 database.

Confidential, Houston, TX

Application Support Engineer

Responsibilities:

• Worked on discovering entities, attributes, relationships and business rules from functional requirements
• Support Technical project managers to ensure that all aspects of the information analysis and requirements gathering process are completed with the highest degree of accuracy and quality, including the development and socialization of key project artifacts.
• Regular Expression Commands writing for Data Quality, Data Profiling efforts.
• Worked closely with development team and business representatives to fully understand data requirements to support business function.
• Performed Data Analysis and Data Profiling and worked on data transformations and data quality rules.
• Created Dimensional data Model, that contain the measurements or metrics or facts of business processes and resolve many-to-many relationships in fact tables.
• Created conformed dimensions to integrate data across the enterprise.
• Provide technical consulting in the definition, design, and creation of a database environment.
• Co-ordinated with Business Analyst for various requirements and Data Projects across the organization.
• Identify business rules for data migration and perform data administration through data models and metadata.
• BI Dashboards Development for Data Quality and Data Profiling and Data Governance efforts.
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Implementation of an ongoing DQ monitoring process.
• Involved in the data migration, data lineage and also studying the data impact analysis.
• Responsible for the development and maintenance of Logical and Physical data models, along with corresponding metadata.
• Responsible for developing, designing and implementing the standards and processes to support the Data Quality.
• Developing requirements for business intelligence, master data management and functional-data projects.
• Worked with project team representatives to ensure that logical and physical ERwin data models were developed in line with corporate standards and guidelines.
• Hands on experience in designing data models and working with database developers to implement reference data applications.
• Generated Physical/Logical reports; Data dictionary and Complete compare reports for the changes.

Confidential, Houston, TX

Sr. Data Analyst

Responsibilities:

• Independently leads cross functional teams for engineering projects, business systems and complex change controls.
• Data Quality Rules creation using regular expression.
• Worked on discovering entities, attributes, relationships and business rules from functional requirements
• Used Erwin R9.0, created Conceptual, Logical and Physical data models.
• Translated logical data models into physical database models, generated DDLs for DBAs
• Worked on data mapping and documenting ETL transformations
• Performed Data Analysis and Data Profiling and worked on data transformations and data quality rules.
• Data Cleansing and Data Standardization.
• Worked on creating Indexes to improve the performance, constraints on various tables
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Identifying the data inputs from various source systems depending upon the business requirement.
• Expertise and worked on Physical, logical and conceptual data model
• Perform data reconciliation between integrated systems.
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Collected, analyze and interpret complex data for reporting and/or performance trend analysis
• Experienced in forecasting the data space requirements using the features like Capacity planning, mapping source to target data using data lineage feature and also calculating the impact analysis.
• Collaborated with the data warehousing team, ensuring that data infrastructure supports the needs of analytics team and validating data quality.
• Advocated for exploration of interesting data anomalies or patterns that provided more explanatory detail about customer behaviors and predictive value to the business.
• Worked with various organizational Teams to develop, test, and maintain the accurate tracking, capturing and reporting of key product usage metrics via both server-side data collection and web analytics tagging.
• Developed enterprise data solution frameworks related to data design and logical solution partitioning
• Developed Enterprise Level data model and data content designs.
• Setting data architecture standards for enterprise information delivery solutions.
• Involved in the data migration, data lineage and also studying the data impact analysis.
• Architectural oversight of data design from analysis, modeling and mapping, through development and testing.

Confidential, Houston, TX

Sr. Data Analyst

Responsibilities:

• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Conducted workflow, process diagram and gap analysis to derive requirements for existing systems enhancements.
• Performed Data Analysis and Data Profiling and worked on data transformations and data quality rules.
• Microsoft SQL Server management Studio, Data extraction and Data Update from Databases.
• Cognos Business Intelligence Reporting - Creating and maintaining reports
• Microsoft Azure Service Bus Explorer - data reading
• Independently leads cross functional teams for engineering projects, business systems and complex change controls.
• Understanding the scope of application, present schema, and data model and defining relationship within and between groups of data.
• Installations, upgrades, configuration, and troubleshooting of tools.
• Provides training and technical among manufacturing team. 
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Expertise and worked on Physical, logical and conceptual data model
• Wrote and executed unit, system, integration and UAT scripts in a data warehouse projects.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Used DDL and DML to writing triggers, stored procedures to check the data entry and payment verification
• Experienced in source to target data mapping using Data lineage technique and also calculating the impact on the data flow using Impact Analysis.
• Perform data reconciliation between integrated systems.
• Written complex SQL queries for validating the data.
• Assisted in the oversight for compliance to the Enterprise Data Standards, data governance and data quality
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files, SQL Server 2005 with high volume data.
• Performing data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Analysis on Mainframe data to generate reports for business users.

Confidential, Houston, TX 

Sr. Data Analyst/Sr. Information Analyst

Responsibilities:

• Worked on discovering entities, attributes, relationships and business rules from functional requirements
• Data Quality Rules Development using Regex (Regular expressions) Command.
• Data Profiling and harvesting of metadata.
• Data Quality and Data Profiling scheduling automation.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements.
• Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.
• Wrote and executed SQL queries to verify that data has been moved from transactional system to DSS, Data warehouse, data mart reporting system in accordance with requirements.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Used CA ERwin Data Modeler   (ERwin) for   data modeling   (data   requirements analysis ,   database design   etc.) of custom developed information systems , including databases of transactional systems and   data marts .
• Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data, Relational Data (Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources.
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Provide support to client with assessing how many virtual user licenses would be needed for performance testing.
• Ensuring onsite to offshore transition, QA Processes and closure of problems & issues.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Data Integration with Data quality Rules creation from various sources.
• Prepares and submit the summarized audit reports and taking corrective actions
• Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed