SUMMARY

• 71/2 years of IT experience in Data Analysis with strong understanding of data modelling, data source evaluation and strong understanding of Data warehousing, Client/Server applications.
• Proficient in Relational Database Management System (RDMS), Data Warehouse Concepts, OLTP & OLAP, Data Mapping, Data Quality and Data Profiling.
• Experience in relational and dimensional data modeling and logical and physical database design.
• Extensive working experience in Normalization and De - Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default) and Indexes.
• Worked closely with various teams in the company to identify and solve business challenges utilizing large sets of data in a distributed processing environment and to develop marketing & management strategies.
• Experience in analyzing raw data to draw conclusions and recommendations
• Experience in manipulating, cleaning and processing data using Excel, Access and SQL.
• Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle, Waterfall and Agile methodologies.
• Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME's), Development and QA teams.
• Proficient in preparing different requirement artifacts like Functional Specifications (FS), workflow/process flow, algorithms, use cases, Service Request (SR) and Requirement Traceability Matrix (RTM).
• Developed and implemented a business intelligence strategy that ensures the systemdatais secure, integrated and accessible to staff.
• Worked with various groups including business users to resolve dataintegration issues and troubleshooting& testing of data issues.
• Development and maintenance of Business Metadata for the assigned applications and any corporate-level reports.
• Involved in Delivery Data Steward Activities from Impact Assessment (IA) Notification, Creation of Business Metadata, User Acceptance Testing (UAT) and Post-Production Validation (PPV) etc.
• Experience in Data Extraction, Transforming and Loading (ETL) using various tools
• Proficient in designing Data Mart and Data Ware house using Star and Snowflake Schemas
• Experience in advance Excel functions such as Pivot Table, Charts, Graphs and Macros.
• Excellent communication, analytical and leadership skills and a good team player.

TECHNICAL SKILLS

RDBMS: MS SQL2012, 2008/2008 R2,, 2005, 2000, MySQL, Oracle SQL/11g, MS-Access

Programming Languages: C, C++, SQL, PL/SQL, VB.NET, MATLAB

Data Analysis Tools: Python, SAS, MS-Excel, BI Tools, Teradata, Hadoop, Tableau

Data Modeling Tools: Erwin 4.0, ER/Studio, Informatica ETL, Vision 2002

Operating System: Windows 8/XP/NT/ 2000/2003/2007 , UNIX and Linux

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reporting, Cognos Version 8

PROFESSIONAL EXPERIENCE

Senior Data Modeler/Analyst

Confidential, Dallas, TX

Responsibilities:

• Worked on large sets of structured and unstructured data, and analyzing it to draw meaningful conclusions.
• Build and analyze queries from Teradata & SQL Server databases using SQL.
• Completion of IDM assessments that identifies important data within applications and compliance gaps to the Policy
• Development and maintenance of business metadata for their assigned applications and any corporate-level reports
• Documentation of data quality checks and thresholds for important data elements
• Ensure monitoring of the important data elements for data quality and integrity and creation of data quality reporting that is performed on at least a quarterly basis.
• Worked on customer data across multiple internal and external sources into a consolidated customer database.
• Participate in daily agile meeting, weekly and monthly staff meetings and collaborate with various teams to develop and support ongoing analyses.
• Conduct dataaccuracy analysis and support stakeholders for decision-making.
• Analyzing data using advance Excel functions such as Pivot Table, Charts, Graphs and Tableau.
• Worked on querying data and creating on-demand reports and involved in data validations.
• Developed and executed data retention plans that establishes the retention period for important data and the business justification for that defined retention period
• Supported Product Strategy DA team in testing, data analysis, and other projects as needed
• Provided technical support to data warehouse teams. Data set sizes are usually huge (in excess of hundreds of millions of records).
• Involved in Delivery Data Steward Activities from Impact Assessment Notification, Creation of Business Metadata, Coordinating User Acceptance Testing (UAT) and Post-Production Validation (PPV) etc.

Environment: SQL Server 2008 R2/2012, MS Access, MS Excel, MS Power Point, R, SAS, Teradata, Tableau, HTML, XML, Visio, ASP.NET, Cognos Version 8, Informatica ETL, UNIX.

Senior Data Modeler/Analyst

Confidential, Portland, OR

Responsibilities:

• Analyzed the large sets of data using various techniques such as quantitative analysis, advanced analytics and statistical modeling to find solutions.
• Developed predictive statistical models using statistical analysis and other predictive modeling techniques.
• Build and analyze queries from databases using SQL.
• Working with client on customer data by relating from multiple internal and external sources into a central consolidated company-wide customer database.
• Daily movement of users and handling cases, analysis and Adhoc Reporting.
• Provide input to improve customer dataprocessing.
• Participate in weekly staff meetings and collaborate with various teams to develop and support ongoing analyses.
• Conduct dataaccuracy analysis and support stakeholders for decision-making.
• Analyzing data using advance Excel functions such as Pivot Table, Charts, Graphs and Macros.
• Handled the company’s day-to-day reporting anddataaccess needs.
• Developed and implemented a business intelligence strategy that ensures the systemdatais secure, integrated and accessible to staff.
• Worked across departments to identify and understand key business questions, and standardize key metrics and measures.
• Implemented Complex business logic with User-Defined-Functions, Index, Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Analysis, design and data modeling of Logical and Physical database using E-R diagrams.
• Design/Build Extract Transform Load procedures in SQL Server 2005/2008/2008 R2 using DTS packages to import/export data feeds to/from data warehouse and claim systems.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Designed and created Report templates, bar graphs and pie charts based on the customer data.

Environment: SQL Server 2005/2008/2008 R2, MS Access, MS Excel, MS PowerPoint, Tableau, R, SAS, Informatica ETL, VBScript, HTML, XML, Visio, ASP.NET, VB.NET, BIDS.

Data Modeler/Analyst

Confidential, Houston, TX

Responsibilities:

• Reporting requirements and reports generation using MS Excel and advanced use of VBA and macros.
• Conducteddatamodeling anddatamapping for reportingdataelements.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked with internal architects and assisted in the development of current and target state enterprisedataarchitectures.
• Worked with project team representatives to ensure that logical and physicaldatamodels were developed in line with corporate standards and guidelines.
• Performeddataanalysis anddataprofiling using complex SQL on various sources systems.
• Created SQL scripts to finddataquality issues and to identify keys,dataanomalies, anddata validation issues.
• Worked on logical and physical modeling of variousdatamarts as well asdatawarehouse using Teradata.
• Involved in defining the source to targetdatamappings, business rules, anddatadefinitions.
• Responsible for defining the functional requirement documents for each source to target interface.
• Documented, clarified, and communicated change requests with the requestor and coordinated with the development and testing team.
• Reverse engineered all the Source Databases using Erwin.
• Defined milestones in project plan using MS Visio with the help of WBS and network diagram.
• Produced documentation including detailed Business Requirements, Functional Requirements and assisted to produce Technical Specification and Operations Manual.
• Assisted Developers inDataModeling using Entity Relationship Diagrams (ERD).
• Collaborated with cross-functional teams throughout the project life cycle.
• Useddataanalysis techniques to validate business rules and identified low quality missingdatain the existing EnterpriseDataWarehouse (EDW).

Environment: SQL Server 2005/2008/2008 R2, MS Access, MS Excel, MS Word, MS Outlook, Erwin, Crystal Reports, Teradata, MS PowerPoint, R, SharePoint.

Data Modeler/Analyst

Confidential, Springdale, AR

Responsibilities:

• Tested database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
• Identified, suggested and managed improvements in the process to meet data
• Quality criteria
• Created adhoc reports and pivot tables in Excel using VBA and macros.
• Identified and prioritized strategic themes of the business to align them with IT strategies thereby growing revenue, improving profits through efficient quality of services.
• Collected keydatametrics to determine mandatory and discretionary investments based on the prioritizations and projected the expected returns using MS Access.
• Responsible fordatamapping anddatamediation between the sourcedatatable and WMOdata tables using MS Access and MS Excel.
• Created SQL queries to pull outdataand metrics from the database.
• Reviewed all artifacts created with respect to Logical and physicaldatamodels including Tables, procedures, indices, synonyms, views, functions, triggers, sequence and constraints.
• Analyzing change request for the existing mapping and creating an impact analysis for the change on data.
• Prepared testdatapreparation strategy and data masking strategy for the shared test environment.
• Co-ordinate with development and QA team for handling of defects with respect todata.
• Interact with clients/business users when issues arise ondatagovernance.
• Provide support during parallel and reverse parallel runs.
• Created spreadsheet with all the production issues/solutions as part of lessons learnt and to help form FAQ for the maintenance team.
• Created ETL mapping documents for every mapping anddatamigration document for smooth transfer of project from development to testing environment and then to production environment.

Environment: SQL Server 2005/2008/2008 R2, PL/SQL, MS Access, MS Excel, MS PowerPoint, Quality Center 10.0, .NET, XML, HTML, Windows and Unix, Shell Scripting, COGNOS.

Data Modeler/Analyst

Confidential

Responsibilities:

• Involved in data warehouse and Data mart design.
• Worked according to the software development life cycle.
• Gathered requirements from remotely based business users and defined and elaborated the requirements by holding meetings with the users (who are also Fifth-third employees).
• Analyzed the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder.
• Wrote the test cases and technical requirements and got them electronically signed off.
• Created new reports based on requirements.
• Utilized simple methods like PowerPoint presentations while conducting walk throughs with the stakeholders.
• Developed PL/SQL Business Functions and calling into the Cognos Tools Designed and Developed Power Prompts for Web Users For Flexible Querying.
• Conducted GAP analysis so as to analyze the variance between the system capabilities and business requirements.
• Interacted with teams in AFS, ACBS and infolease to extract the information for the reports.
• Involved in defining the source to target data mappings, business rules, business and data definitions.
• Created Report-Models for ad-hoc reporting and analysis.
• Created Logical/physical Data Model in ERwin and have worked on loading the tables in the Data Warehouse.
• Worked extensively with the ERwin Model Mart for version control
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration,
• ETL and customization of data mart.
• Document various Data Quality mapping document.
• Perform small enhancements (data cleansing/data quality).
• Performed data analysis on the existing data warehouse’s of AFS, ACBS and info lease.
• Worked on daily basis with the main frame team and lead data warehouse developers to evaluate impact on current implementation.
• Upgraded the present application by adding new functionalities and adding new reports.
• Coordinated (with business users, data base administrator, mainframe team and testing team) in mirror to production testing.
• Conducted User Acceptance testing (UAT) and worked with users and vendor who build the system.

Environment: MS Office 2007, MS Visio 2003, Cognos, Windows XP, business objects, SQL server, MS powerpoint, UML and AFS.3

Data Analyst

Confidential

Responsibilities:

• Performed data profiling in the source systems that are required for Dual Medicare.
• Document the complete process flow to describe program development, logic, testing and implementation, application integration, coding.
• Involved in defining the trumping rules applied by Master Data Repository
• Define the list codes and code conversions between the source systems and MDR.
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines
• Involved in defining the source to target data mappings, business rules, business and data definitions
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Reverse engineered all the Source Database’s using Embarcadero .
• Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
• Involved in data warehouse and Data mart design.
• Experience with various ETL, data warehousing tools and concepts
• Documented the complete process flow to describe program development, logic, testing and implementation, application integration, coding.
• Worked with internal architects and, assisting in the development of current and target state data architectures
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines

Environment: MS Office, MS Visio, Cognos, ETL, Windows XP, business objects, SQL server, MS powerpoint, UML, Embarcadero .