SUMMARY

• Over 7+ Years of IT experience in System Analysis, Application Design, Implementation and Testing of Enterprise Data Warehousing and Enterprise Database.
• Expertise in SQL queries, PL/SQL Packages, SQL Plus, Stored Procedures, Functions, Triggers and Performance Analysis, Creating Partitions, Indexes, Aggregating tables when required.
• Expertise in working with business users as part of requirements gathering and converting them into technical solution and data models.
• Experience in developing data models which will serve both OLTP and OLAP functionality.
• Experienced in working with RDBMS like Oracle 11g/10g/ 9i, Microsoft SQL Server 2012/2008 R2/2008/2005 and Teradata.
• Expertise in designing Conceptual, Logical and Physical Data Models for various environments and business processes.
• Strong understanding of the System Architecture and the data flow from various systems. Used Visio for creating process and data flow diagrams.
• Extensive experience in designing Normalized Data Model by business process by use cases.
• Performed Data mapping between source systems to Target systems, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Extensive experience using data modeling tools Erwin, Power designer and Microsoft Visio.
• Professional hands - on experience in data warehouse design, data modeling and database administration activities
• Expertise database normalization method defined by E.F CODD (3NF-Third Normal Form).
• Expertise in data design and modeling, system study, design, and development by applying Ralph Kimball methodology of dimensional and relational data modeling.
• Excellent knowledge on creating reports on Pentaho Business Intelligence, Tibco Spotfire & Tableau.
• 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 on Teradata SQL queries, Teradata Indexes, Utilities such as Mload, Tpump, Fast load and FastExport.
• Strong analytical, communication skills that helps in communicating with business users, development team and project management staffs.

TECHNICAL SKILLS

Database Tools: Microsoft SQL Server 2008/2012, Oracle 9g/10g/11g, PL/SQL, MS Access, Teradata.

Data Modeling Tools: Erwin 9x/8x/7x, MS Visio 2007/2010, ER Studio, Oracle Designer.

Reporting & Other Tools: SQL Server Reporting Services (SSRS), OLAP (Online Analytical Processing), Business Intelligence & Development Studio, SQL BI

ETL Tools: SSRS, SSIS (SQL Server Integration Services), Data Transformation Services (DTS), Informatica.

Languages: SQL, PL SQL, T SQL, XML

Packages: Microsoft Office 2007/2010, Microsoft Project 2010, Microsoft Visio, Share point Portal Server 2003/2007.

ETL/Datawarehouse Tools: Informatica, SAP Business Objects XIR3.1/XIR2, Web Intelligence, Talend, Tableau, Pivot Tables, Erwin, HP ALM, Quality Center (QC)

Operating System: Windows Server 2012/2008/2003 , Windows 8/7/XP, LINUX

Tools: & Software: TOAD, MS Office, BTEQ, Teradata SQL Assistant

Others: MSOffice (Word, Excel, PowerPoint, Access), MS Project, Rational Rose, UML

PROFESSIONAL EXPERIENCE

Confidential, Deerfield, IL

Data Analyst

Responsibilities:

• Worked with Data Stewards and subject matter experts to research reported data anomalies, identified root causes, and determined appropriate solutions.
• Worked with data source systems and Client systems to identify data issues, data gaps, identified and recommended solutions.
• Worked closely with Architects and developers to deliver the database components for large scale, complex applications.
• Worked on data manipulation and analysis & accessed raw data in varied formats with different methods and analyzing and processing data
• 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.
• Involved in data mining, transformation and loading from the source systems to the target system.
• Provided input into database systems optimization for performance efficiency and worked on full lifecycle of data modeling (logical - physical - deployment)
• Used Erwin for reverse engineering to connect to existing database and ODS to create graphical representation in the form of Entity Relationships and elicit more information
• Developed mapping spreadsheets for ETL team with source to targetdatamapping with physical naming standards,datatypes, volumetric, domain definitions, Transformation Rules and corporate meta-datadefinitions.
• Utilized SQL server’s reporting services; SSRS and SSIS; to support reporting requirements.
• Involved in performing extensive Back-End Testing by writing T-SQL queries and stored procedures to extract the data from SQL Database.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
• 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.

Environment: Erwin, T-SQL, Informatica 9.5, SQL Server 2012, ERWIN, Business Objects Clear Quest, Clear Case, Teradata R13, SSIS, SSRS, Windows Server 2012

Confidential, Nashville, TN

Data Analyst

Responsibilities:

• Used and supported database applications and tools for extraction, transformation and analysis of raw data
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Developed, managed and validated existing data models including logical and physical models of the data warehouse and source systems utilizing a 3NF model
• Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Created data masking mappings to mask the sensitive data between production and test environment.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and SQL server.
• Involved in extensive data validation by writing several complex SQL queries and involved in Back-End Testing and worked with data quality issues.
• Worked with end users to gain an understanding of information and core data concepts behind their business.
• Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
• Worked on data modeling and produced data mapping and data definition specification documentation.
• Wrote simple and advanced SQL queries and scripts to create standard and ad hoc reports for senior managers.
• Involved in creating/modifying reports using Tableau Reporting Tools.
• Identify source systems, their connectivity, related tables and fields and ensure data suitably for mapping
• Designed UML Models (Rational Rose, Visio) and Relational data Models for applications.
• Identify Data Quality Controls review Business Requirements Document and attend project release meetings.
• Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Environment: Erwin, SQL Server 2008R2, Oracle 10g, Rational Rose, Informatica 8.1, Quality Center 8.2, SQL, TOAD, PL/SQL, Flat Files, Tableau, Teradata

Confidential, Charlotte, NC

Data Analyst

Responsibilities:

• Analysis of functional and non-functional categorized data elements for Data Migration, 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.
• Experience developing data transformation and cleansing rules for migration using ETL tools
• Analyzed multiple source system to identify the data for migration
• Coordinated data migration from old to new system during Teradata system capacity expansion.
• Performed data mining on data using very complex SQL queries and discovered pattern.
• Created DML code and statements for underlying & impacting databases.
• Solid Back End Testing experience by writing and executing T-SQL Queries.
• Worked with ETL team who ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Worked at conceptual/logical/physical data model level using Erwin according to requirements.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling tools like ERWIN.
• Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.
• Perform data reconciliation between integrated systems.
• Good experience in Data Extraction, Modification, Validation, Analysis, Management and Reporting using SAS Software.
• Metrics reporting, data mining and trends in helpdesk environment using Access with SharePoint.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Extensively used MS Access to pull the data from various data bases and integrate the data.
• Performed data analysis, Data Migration and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Responsible for different Data mapping activities from Source systems to Teradata

Environment: Quality Center 9.2, MS Excel, T- SQL, SQL Server 2008, Erwin, Business Objects XIR2, ETL Tools Informatica 8.6, Teradata R12, Teradata SQL Assistant 12.0, IDQ

Confidential

Data Analyst

Responsibilities:

• Participated in requirements session with IT Business Analysts, SME's and business users to understand and document the business requirements as well as the goals of the project.
• Worked on enhancements to theDataWarehouse model using Erwin as per the Business reporting requirements.
• Analyzed the source system (Progress Databases) to understand the sourcedatarelationships along with deeper understanding of business rules anddataintegration checks.
• Implemented the Slowly changing dimension scheme (Type II) for most of the dimensions.
• Reviewed the logical model with Business users, ETL Team, DBA's and testing team to provide information about thedatamodel and business requirements.
• Worked withDataQuality Team in defining and configuration of Rules, Monitoring and preparation of DataQuality Analysis and Dashboards using Trillium.
• Created the DDL scripts using ER Studio and source to target mappings (S2T- for ETL) to bring the datafrom source to the warehouse.
• Worked with DBA to create the physical model and tables. Scheduled multiple brain storming sessions with DBAs and production support team to discuss about views, partitioning and indexing schemes, case by case for the facts and dimensions.
• Worked on TrilliumDataQuality tool for monitoring Production systems forDataAnomalies and resolve issues.
• Worked on Mercury Quality Center to track the defect logged against the logical and physical model.
• Worked as an onsite project coordinator once the design of the database was finalized in order to implement thedatawarehouse according to the implementation standards.
• Worked with client and off shore team to make sure that the reports and dashboards are delivered on time.
• Participated in UAT sessions to educate the business users about the reports, dashboards and the BI System. Worked with the test team to provide insights into thedatascenarios and test cases.
• Worked ondataprofiling anddatavalidation to ensure the accuracy of thedatabetween the warehouse and source systems.

Environment: ER Studio 8.0.3, Microsoft SQL 2005/2008 Server, Microsoft SQL Management Studio, SSRS, SSIS, Teradata, Mercury Quality Center 9

Confidential

Data Analyst

Responsibilities:

• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL.
• Provided database support to staff to ensure consistent and accurate data entry and storage.
• Extracted and analyzed data to provide data-driven product recommendations.
• Built dashboards, automated reports, and alerting systems.
• Developed and maintained all customers focused standardized reporting from requirements gathering to dashboard creation.
• Serviced requests for ad hoc campaign analysis, population sizing and data pull.
• Focus on optimizing and improving data processes through automation and new technology.
• Effectively communicate with various business owners and teams and escalate technical issues when appropriate.
• Partner with the database team to improve data quality, data availability and data integration with new and existing systems.
• Analyze data for troubleshooting and tracking Reporting/Metrics to resolve all reporting/ metrics related issues.
• Design reports to present meaningful information that is easy to understand by users of the report.
• Created Drill Down, Drill Through, Sub and Linked reports using the SSRS as well as managed the subscription and authentication of these reports.
• Maintained scheduling of subscription reports with the subscription report wizard.

Environment: MS SQL Server 2005, SSIS, SSRS, Windows XP, MS-Access, Excel. Crystal Reports