PROFESSIONAL SUMMARY:

• Experienced in all phases of Software Development Life Cycle ( SDLC ).
• Efficient in analyzing and documenting business requirement documents (BRD) and functional requirement documents (FRD) along with Use Case Modeling and UML.
• Experienced in conducting Joint Application Development (JAD) sessions with the stakeholders, business users, and SME’s to obtain domain level information of projects.
• In depth understanding of Gap Analysis for AS - IS and TO-BE business processes, risk, impact and feasibility analysis.
• Proficient in interacting with users, analyzing client business processes, documenting business requirements, performing design analysis and developing design specifications.
• Experienced in developing Enterprise Canonical Model (ECM).
• Understanding in development of Conceptual, Logical and Physical Models for Online Transaction Processing and Online Analytical Processing (OLTP & OLAP).
• Hands on experience in Financial Services data model (FSDM).
• Good understanding of Agile (SCRUM) and Waterfall technologies.
• Extensive work experience in Entity-Relationship diagrams, Dimensional Modeling (Star Schema/ Snowflake Schema) and Data Warehousing.
• Proficient in Normalization (1NF/2NF/3NF) /De-normalization techniques in relational/dimensional database environments.
• Skillful in Data Analysis using SQL on Oracle, MS SQL Server, DB2 & Teradata.
• Excellent experience in trouble shooting SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Involved in the maintenance of enterprise metadata repositories.
• Expertise in Physical Modeling for multiple platforms such as Oracle/Teradata/ SQL Server/DB2.
• Identified Slowly Changing Dimensions and hierarchies.
• Designed data marts using Ralph Kimball and Bill Inmon dimensional data modeling techniques.
• Extensively worked on Forward Engineering and Reverse Engineering.
• Reverse engineered the database structure from the existing application using Sybase power designer.
• Experienced in Performance Tuning on oracle databases by leveraging explain plans, and tuning SQL queries.
• Proficient in writing DDL, DML commands using SQL developer and Toad.
• Expertise in performing User Acceptance Testing (UAT) and conducting end user training sessions.
• Proficient in data governance, data quality, data stewardship, metadata management, master data management.
• Developed Data Migration and Cleansing rules.
• Worked in Info sphere MDM data warehouse.
• Partnered with the business to facilitate and implement technology solutions for Wealth Management.
• Experience in Oracle SQL and PL/SQL including all database objects: Stored procedures, Stored functions.
• In depth and thorough knowledge of development and design with RDBMS -OLTP, dimensional modeling using data modeling tool ERWIN, Sybase Power Designer.
• Involved in analysis, development and migration of Stored Procedures, Triggers, Views and other related database objects with solid experience in MS-SQL Server 6.x to 2008, Sybase 10.12, Sybase 4.2 and Oracle, IBM-DB2.
• Proficient in R Programming Language, Data extraction, Data cleaning, Data Loading, Data Transformation, Predictive Modeling and Data visualization using R and Tableau.
• Statistical Analysis including univariate, bivariate, multivariate methods & extensive use of Logistic

TECHNICAL SUMMARY:

Data Modeling Tools: Erwin 9.5/8/7, MS Visio 2010/2014, ER Studio, Oracle Designer, SAP power designer 16.0/16.5.

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

Reporting & Other Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), OLAP (Online Analytical Processing), Multi-dimensional Cubes and Business Intelligence & Development Studio, SQL BI.

ETL Tools: SSRS, SSAS, SSIS (SQL Server Integration Services), Data Transformation Services (DTS), Informatica, tableau.Operating System: Windows, UNIX, Linux.

Languages: SQL, PL SQL, T SQL, XML, DDL, DML, HTML, VB Script, Java Script.

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

PROFESSIONAL EXPERIENCE:

Confidential, New jersey

ETL Developer/Data Analyst

Responsibilities:

• Extracted data from Oracle, SQL Server and DB2 using Informatica to load it into a single data warehouse repository.
• Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Developed and implemented measurements for various marketing campaigns.
• Created a net loss model which analyzes the impact of loan defaults and recoveries.
• Developed complex SQL queries, and perform execution validation for remediation and Analysis. 
• Created a relational model and dimensional model for online services such as online banking and automated bill pay.
• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.
• Developed logical data models and physical data models using ER-Studio.
• Adjusted and maintained SQL script and perform further data analysis and data aggregation. 
• SME (subject matter experts) for remediation exclusion and Data Dictionary.
• Involved in process improvement, infrastructure, Business Support (Remediation Process), Support Structure and Analytics. 
• Analyzed requirements and data models, development of cases for complex scenarios. 
• Worked with data and results; gather data in reports; extensively analyze data and observations; express analysis and observation. 
• Obtained information from disparate sources, including production and ad hoc systems, linking and analyzing the information, performing data integrity checks and exploratory data analysis. 
• Involved in defining the source to target data mappings, business rules and data definitions. 
• Comprehensively used data analysis techniques to validate business rules and identify low quality missing data.
• Extensively used SQL for accessing and manipulating database systems 
• Worked closely with QA team and developers to clarify/understand functionality, resolve issues and provided feedback to nail down the bugs. 
• Acted as a liaison between the development team and the management team to resolve any data conflicts in terms of requirements. 
• Interacted with all levels of the project team, from end users to Software Architects, data governance team, Database Administrators, and testers. 

Environment: Erwin r9.5, Informatica 8.6.1, Oracle SQL Developer, Oracle Data Modeler, TOAD, Oracle 9i/10g, Teradata 14, DB2, SSIS, Business Objects, SQL Server 2005/2008, SQL, PL/SQL, IBM DB2, VBA MS Excel, ER/Studio Windows XP, MS Excel, Sybase Power Designer.

Confidential, North Carolina

SSIS Developer

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.
• Involved in gathering user requirements along with Business Analyst.
• Interacted with end users to identify key dimensions and measures that were relevant quantitative.
• Created the Source System Analysis documents and Architectural Solution documents.
• Developed the logical and physical data model for the proposed solution.
• Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards.
• Involved in the complete life cycle of the product from requirements gathering to end of system testing.
• Created views to support the Business Objects.
• Responsible for creating the staging tables and source to target mapping documents for the ETL process.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Extensively used the dimensional modelling for the data ware house design.
• Involved in many of the integration projects.
• Created Indexes and capacity planning and worked closely with the DBA’s.
• Created Summary and Aggregate tables for better performance of the query.
• Worked with ETL teams and used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories.
• Developed and maintained data dictionary to create metadata reports for technical and business purpose.
• Created action plans to track identified open issues and action items related to the project.
• Prepared analytical and status reports and updated the project plan as required

Environment: Erwin r9.5, Oracle 9i/10g, Teradata 14, TOAD, ERWIN r7.3, Teradata SQL Assistant 13.0, DB2, SSIS, Business Objects, SQL Server 2005/2008, SQL, PL/SQL, IBM DB2, VBA MS Excel, ER/Studio Windows XP, MS Excel, Sybase Power Designer.

Confidential, Sparks Maryland

ETL Developer/ Data Analyst

Responsibilities:

• Refined and standardized data modeling practices to align with application paradigm (E.g. Business Intelligence, Transactional Processing, Big Data etc.)
• Translated and transformed business requirements into Conceptual, Logical, and Physical data models. 
• Conducted extensive data analysis to evaluate data sources to determine the best source for business information. 
• 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.
• Defined, developed and delivered consistent information and data standards, methodologies, guidelines, best practice and approved modeling techniques around data quality, data governance and data security.
• Partnered with subject matter experts, architects and developers to capture and analyze business needs to complete all data modeling related artifacts including Conceptual, Logical and Physical Data Models.
• Used Informatica Designer, Workflow Manager and Repository Manager to create source and target definition, design mappings, create repositories and establish users, groups and their privileges.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Extracted data from the databases (Oracle and SQL Server, DB2, FLAT FILES) using Informatica to load it into a single data warehouse repository.
• Involved in maintaining and updating Metadata Repository with details on the nature and use of applications/data transformations to facilitate impact analysis.
• Developed and maintained Data Dictionary to create Metadata Reports for technical and business purpose using Erwin 9.5 report designer.
• Experienced in development and design of RDBMS -OLTP, dimensional modeling using data modeling tool ERWIN, Sybase Power Designer.
• Designed, documented and implemented common message models (XML).
• Analyzed existing business processes and data flows and determined the most optimal level of normalization for message publication.
• Reviewed data & message Models with Architecture Review Board.

Environment: Erwin r9.5, Oracle SQL Developer, Oracle Data Modeler, Teradata 14, DB2, SSIS, Business Objects, SQL Server 2005/2008, ER/Studio Windows XP, MS Excel, Sybase Power Designer.

Confidential

ETL Developer/ Data Analyst

Responsibilities:

• Worked with Business Analyst for requirements gathering, business analysis and project coordination.
• Developed a Conceptual Model and Logical Model  using Erwin based on requirements analysis.
• Created the best fit Physical Data Model based on discussions with DBAs and ETL developers.
• Utilized Erwin’s forward/reverse engineering tools and target database schema conversion process.
• Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model.  
• Worked on data mapping process from source system to target system.
• Created dimensional model for the reporting system by identifying required facts and dimensions using Erwin.
• Extensively used Star and Snowflake Schema methodologies.
• Worked on Slowly Changing Dimension tables.
• Involved in maintaining and updating Metadata Repository with details on the nature and use of applications/data transformations to facilitate impact analysis.
• Developed and maintained Data Dictionary to create Metadata Reports for technical and business purpose.
• Experienced in data migration and cleansing rules for the integrated architecture (OLTP, ODS, DW).
• Worked on Performance Tuning of the database which includes indexes, optimizing SQL Statements.
• Experience with Oracle SQL and PL/SQL programming and used Database utility programs like TOAD and SQL Navigator.
• Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.

Environment: Erwin r8.2, Oracle SQL Developer, Oracle Data Modeler, Teradata 14, SSIS, Business Objects, SQL Server 2005/2008, ER/Studio Windows XP, MS Excel.

Confidential

MS SQL Server Developer / Database Analyst

Responsibilities:

• Coordinated in requirements gathering session with business users and sponsors to understand and document the business requirements as well as the goals of the project.
• Developed Conceptual model using Erwin based on requirements analysis.
• Worked with Business Analyst during requirements gathering and business analysis to prepare high level Logical Data Models and Physical Data Models.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Created dimensional model for the reporting system by identifying required facts and dimensions using Erwin.
• Implemented Forward engineering to create tables, views and SQL scripts and mapping documents.
• Prepared data dictionaries and Source-Target Mapping documents to ease the ETL process and user’s understanding of the data warehouse objects
• Implemented the slowly changing dimension (Type II) and determined the hierarchies in dimensions.
• Translated business concepts into XML vocabularies by designing XML Schemas with UML.
• Exhaustively collected business and technical Metadata and maintained naming standards.
• Extensively used reverse engineering feature of Erwin to save the data model with production.
• Used Erwin data model mart for storing different versions of the model.
• Involved in maintenance of models and loading models to Metadata Repository.
• Involved in data analysis of the Teradata.
• Experience in Oracle SQL and PL/SQL including all database objects: Stored procedures, Stored functions, Packages, Objects, Triggers, cursors, cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections.
• Responsible for integrating the work tasks with relevant teams for smooth transition from testing to implementation phase.

Environment: Erwin 8.0, SQL, SQL Server 2012, Teradata, SQL Assistant 12.0/13.11, Data stage 8.1, DB2.