SUMMARY

• Senior Data Quality Analyst having experience of 7 years in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis, and developing design specifications.
• Strong understanding of relational database software development and integration techniques, tools, and methodologies.
• Experience in writing complex SQL Queries, created materialized views.
• Strong understanding of logical and physical database designs and dimensional modeling schemas like Star and Snowflake schema.
• Expertise in Data Modeling using tools like Erwin, ER/Studio and MS Visio along with the hands - on experience in using Forward Engineering and Reverse Engineering functionality.
• Expert in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in Data Modeling for Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Proficient in designing, modeling, creating, and maintaining Oracle database.
• Experience in Performance Tuning, SQL Tuning, Table Space Partitioning, creation of indexes for faster database access and better query performance.
• Experience in Understanding complex performance issues and worked with DBA’s to suggest valuable ways to fix the problem.
• Excellent project management skills including planning, scheduling, monitoring, and budgeting with experience in requirement gathering, Gap Analysis, Risk Analysis, Effort Estimation etc.
• Proficient in Rational tools including Rational Rose, and Requisite Pro. Excellent skills in Business Analysis, Data Analysis, Data Mapping, Requirement Analysis, Business Modeling and Use Case Development using UML methodology
• Thorough knowledge of Software Development Life Cycle (SDLC), understanding various phases like Requirement gathering, Analysis/Design, Development and Testing knowledge of Rational Unified Process (RUP).
• Adept in streamlining Business processes by recognizing and avoiding bottlenecks, thereby reducing Cycle time, and improving system efficiency and employee productivity.
• Extensive experience involving Business Process Re-Engineering, Software Re-Engineering using RUP methodology and ERP Systems Implementation and Continuous Improvement techniques.
• Excellent system, process, and quality validation skills.
• Excellent business communications skills in writing System Requirements document, Systems Design Specification and System Requirement Change Request.
• Excellent documentation skills in creating BRD and translating it into detailed Functional Specifications Document and Data Models.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, expert team, development and QA team for project meetings, walkthroughs, and customer interviews.

TECHNICAL SKILLS

Database Systems: SQL Server (2005/2000/7.0 ), Access 2003, Oracle (9i/8i/7.x), IBM DB2/UDBa, MySQL.

Data Modeling Tools: ER/Studio, ERwin, Oracle Designer, Power Designer, and Visio

Data warehousing: Microsoft OLAP Service, Data Marts

Data Mining: SAS Enterprise Miner and Knowledge Seeker

Reporting: Crystal Reports and SQL Server 2000/2005 reporting services

ETL Tools: ETL Tools Informatica Power Center 8/7.1.2/5.1.1/5.0., Ab initio Co operating system (2.14/2.15), SAS 9.3

Database Development: T-SQL and PL/SQL

Testing Tool: QTP, Quality Center

Office Applications: MS Office (Word, Excel, PowerPoint)

Web Development: HTML, XML and FrontPage

Operating Systems: Windows (Me, XP), Solaris, Linux, Unix

Programming Languages: C#, Visual Basic.NET, Java and C++, Perl

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Data Analyst

Responsibilities:

• Developed reports, dashboards, and SQL queries using Tableau. Worked on gathering data requirements from different sources and data cleansing.
• Designed different type of STAR schemas like detailed data marts and Plan data marts, Monthly Summary data marts using Erwin with various Dimensions Like Time, Services, Customers, and various FACT Tables.
• Assisted in migration of data is performed from various OLTP servers and documented issues related to data cleansing.
• Created data mapping documents mapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads
• Creating test cases for ETL mappings and design documents for production support
• Worked with ETL group for understating mappings for dimensions and facts
• Identified entities and attributes and developed conceptual, logical, and physical models using Erwin.
• Used reverse engineering to create Graphical Representation (E-R diagram) and to connect to existing database.
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis.
• IngestingdatatoHadoopfrom variety of sources like ERP, CRM, and transactional systems.
• BuildingHadoopbased ETL workflow to transform and aggregatedata.
• Mapped the data between Source and Targets.
• Writing Complex SQL queries in Teradata to pull the records with data issues reported by the users using complex joins, partitions, ordered analytical functions, aggregate functions etc.
• Created documents for logical, physical, and dimensional data models.
• Created various SQL Schema, Triggers, views, index/keys, and stored procedures along with compiling them in SQL server and troubleshoot errors.
• Returned mail also provides an opportunity to improve your CRM database. In this case CRM is Critical Records Management as well as Customer Relations Management.
• Created data model for the star schema using Erwin, created DDL scripts for static dimensions.
• Analyzing query results in Excel, creating pivot table/chart reports etc. and sharing them with MDM team members.
• Created ETL test data for all ETL mapping rules to test the functionality of theInformaticagraphs.
• Sound Knowledge and experience inMetadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Tested the ETLInformaticamappings and other ETL Processes (Data Warehouse Testing)
• Developed data mapping documents between Legacy, Production, and User Interface Systems.
• Responsibilities include gathering business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in Data Stage, and creating ETL jobs in Data Stage.
• Creating or modifying the T-SQL queries as per the business requirements.
• Generated high quality reports in the form of listing, HTML and PDF formats using SAS ODS
• Designed and Developed Oracle database Tables, Views, Indexes with proper privileges and Maintained and updated the database by deleting and removing old data
• Managed full SDLC processes involving requirements management, workflow analysis, source data analysis,datamapping, metadata management,dataquality, testing strategy and maintenance of the model.
• Instead of adding extra columns for existing tables, wrote procedures for creating datasheets and link the datasheet for table and use that datasheet for storing data as table columns.
• Imported millions of records from .CSV files .TXT files using SQL * LOADER and Test Importer.

Confidential, Jefferson City, MO

Data Analyst

Responsibilities:

• Wrote the conversion rules in the Data mapping document and updating according to the business needs and the impacts identified during the conversion.
• Resolved the data related issues such as:assessing data quality, data consolidation, evaluating existing data sources.
• Worked closely with Data Architect to review all the conceptual, logical, and physical database design models with respect to functions, definition, maintenance review and supportData analysis, Data Qualityand ETL design that feeds the logical data models.
• Analyzed the source data coming from various data sources likeMainframe&Oracle.
• Createddata mapping documentsmapping Logical Data Elements to Physical Data Elements and Source Data Elements to Destination Data Elements.
• Defined key facts and dimensions necessary to support the business requirements.
• Worked onETL designfor various source systems.
• Extracted the source tables into SQL server and MS-Access databases and extracting the target tables from the Oracle database.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems usingInformatica.
• Validated Data to check for the proper conversion of the data. Data Cleansing to identify bad data and clean the data.
• Performeddata validation testing writing SQL queries. TestedETL batch processes using UNIX shell scripting.
• Involved inwriting SQL statementsto create test data for test cases and datavalidation teststo extract data from the tables.
• Reviewed all the systems design by assuring adherence to defined requirements.
• Met with user groups to analyze requirements and proposed changes in design and specifications.
• Flat file conversion from the data warehouse scenario.
• Created Static and Dynamic Parameters at the report level.
• Performed migration of Reports (Crystal Reports, and Excel) from one domain to another domain using Import/Export Wizard.
• Created and managed server groups using Central Management Console (CMC).
• Performed a wide range of QA testing to ensure data integrity and coordinated UAT to meet or exceed specified standards and end-user requirements.

Confidential, Baltimore, MD

Data Analyst

Responsibilities:

• Gathered the business requirements by conducting a series of meetings with business users.
• Created logical data model from the conceptual model and its conversion into the physical database design.
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models.
• Used Sybase Power Designer tool for relational database and dimensional data warehouse designs.
• Created reports using SQL Server Reporting Services (SSIS).
• 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.
• Responsible for creating mapping documents required for the ETL team.
• Developed SSIS Packages to transfer the data between SQL Server database and files.
• Created SQL, PL/SQL, SQL Loader control files, functions, procedures, and UNIX Shell scripts.
• Been a part of Architecture and modeling team and have used SOA (Service Oriented Architecture)
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, analyze using OLAP tools).
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support.
• Worked with ETL groups and Acquisition team and business analyst for understating mappings for dimensions and facts
• Experience on Extraction Transformation and Loading (ETL) process using SSIS
• Conduct data mapping sessions and write the required business requirements documentation including use cases.
• Created entity-relationship diagrams, functional decomposition diagrams and data flow diagrams.
• Used Star Schema and Snowflake Schema for data marts / Data Warehouse.
• Prepared the Joins/Filter logic documents that would help the ETL design team perform the Joins on the tables that are in the form of flat files before loading them to FDS or any downstream systems.
• Used DOORS to link requirements to test cases, business rules, design items to maintain traceability.
• Created documentation and test cases, worked with users for new module enhancements and testing.
• Used SQL Server 2005 tools like Management Studio, Query Editor, Business Intelligence Development Studio (BIDS) including SSIS and SSRS.
• Created job schedules to automate the ETL process
• Normalized the database up to 3NF to put them into the star schema of the data warehouse.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data
• Worked with business analyst to design weekly reports using Cognos Report Net.
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Reduced labor-intensive manual processes like job entry, approval, and invoicing by exposing well-defined SOA interface allowing B2B integration with Financial Clients
• Worked on building load rules and transformation logic for Extraction, Transformation and Loading (ETL) of the data into the data warehouse.

Confidential, Sacramento, CA

Data Analyst

Responsibilities:

• Worked on the thorough Metadata and Data analysis to make sure that all the sensitive data has been identified.
• Conducted workflow, process diagram and gap analyses to derive requirements for existing systems enhancements.
• Worked with the reference data to analyze the sensitivity of the data and secured it to protect the privacy of the client.
• Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
• Performed Data Analysis and developed Data Mapping documents for ETL (SSIS) projects.
• Developed Test Cases and SQL Queries to perform various Validations.
• Worked on transformation logic using Teradata queries.
• Worked with the Risk Matrix and identified the different tiers of the risks in the data warehouse environment.
• Used Heat Maps to identify different Risk Mediums across different internal departments.
• Performed Data Analysis and Data validation by writing SQL queries and Regular expressions.
• Worked on several mainframe and distributed environment databases such as Sybase, SQL, ADABAS, db2 etc.
• Worked on developing the tool to extract the data from db2 database and conducted MetaData and Data analysis.
• Wrote Perl scripts for parsing text and querying databases.
• Used regular expressions, text parsing, and data mining techniques to search for defined data patterns.
• Worked on several Database Management tools DBArtisian and other business intelligence tools.
• Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing.
• Worked extensively with UNIX and LINUX to view the data for analysis.
• Maintained/updated system data flow chart, Heat Maps, Tree Maps, Visio documents, and system documentations
• Lead meetings with the clients and business owners to discuss the sensitivity of the data.
• Created and maintained several custom reports using Business Objects.