SUMMARY

• 7 years of hands on experience in Information Technology as a Data Analyst, Data Engineer, Data Mapper and Data Modeler in Telecom Domains, Finance, Insurance, Health care. Experienced in database management strategic analysis, requirements gathering which play a key role in Software Development Life Cycle (SDLC).
• Proficient in gathering business requirements and handling requirements management.
• Proficient in Software Development Life Cycle (SDLC), Project Management methodologies.
• Good experience in data transformation, data mapping from source to target data base schemas.
• Solid knowledge in Data Mapping, Data Governance, Data Cleansing, Data Scrubbing for the Data Management process .
• Hands on experience in Data Stewardship tasks like creation and maintaining of Data, Knowledge in various Data Quality Tools.
• Experience with Data Conversion Process techniques and Methods.
• Good knowledge in Data Transformation, Meta Data and Reference Data Management.
• Well versed in Normalization (1NF, 2NF and 3NF) and De normalization techniques for optimum performance in relational and dimensional database environments.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP systems environment.
• Good Knowledge in ETL concepts and Data Mining techniques.
• Vast experience in developing conceptual, logical and physical data models for OLTP and OLAP systems.
• Experience in developing Entity - Relationship Diagrams (ERD) and modeling Transactional Databases and Data Warehouse using tools like Erwin, Power Designer.
• Experience in modeling with both OLTP/OLAP systems and Kimball and Inmon Data Warehousing environments, Business Intelligence (BI) applications.
• Good in building various logics to handle Slowly Changing Dimensions (SCD), Change Data Capture (CDC) and determining the hierarchies in dimensions.
• Proficient in Data Mart design and creation of cubes using dimensional data modeling - identifying Facts and Dimensions, Star Schema and Snowflake Schema.
• A good expertise in Extract Transform and Load (ETL) data from spreadsheets, database tables and other sources using Microsoft Data Transformation Service (DTS) and Informatica.
• Having experience in writing complex SQL queries to perform end-to-end ETL validations and support Ad-hoc business requests. Also good in developed Stored Procedures, Triggers, Functions, Packages.
• Quick learner, self-motivating and enthusiastic to work with new technologies. Possess excellent verbal and written communication.

TECHNICAL SKILLS

Data Modeling Tools: Erwin r9.5, Power Designer 9.0, ER Studio and Microsoft Visio.

OLAP Tools: Microsoft Analysis Services, Crystal Reports and SQL developer

ETL Tools: Informatica 8.6, Pentaho Data Integration (PDI), Microsoft DTS.

Programming Languages: SQL, SAS, HTML and XML.

Database Tools: Microsoft SQL Server 2008/2012, SQL server Management Studio 2005, TOAD for DB2,Oracle 10g/9i,IBM DB2Teradata and MS Access.

Packages: Microsoft Office 2010, 2007, 2003, Microsoft Project 2010.

Operating Systems: Microsoft Windows7 / NT / 2000/ XP / Vista

Data Quality Tools: Information Data Quality (IDQ), Info Sphere Information Analyzer.

PROFESSIONAL EXPERIENCE

Confidential, Moline, IL

Sr. Data Analyst/Data Modeler

Responsibilities:

• Interacted with the business users on regular basis to consolidate and analyze the requirements.
• Identified, formulated and documented detailed business rules and use cases based on requirements analysis, Involved in multiple projects with different business units.
• Created Conceptual, Logical and Physical data models using power designer.
• Used Normalization methods up to 3NF and De-normalization techniques for effective performance in OLTP systems.
• Enforced Referential Integrity (R.I) for consistent relationship between parent and child tables
• Extracted data from databases Oracle, SQL server and DB2 using Informatica to load it into a single repository for Data analysis.
• Reverse Engineered the Data Models and identified the Data Elements in the source systems and adding new Data Elements to the existing data models
• Compare data with original source documents and validate Data accuracy.
• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Targets.
• Worked with Data Stewardship team to maintain data standards, Performing Data profiling operations against Databases.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).
• Experienced in development of ETL mapping and scripts.
• Heavily used Pentaho Data Integrator (PDI) and Informatica Power Centre for migrating data from old data base to new data base.
• Involved in Star and Snow flake schema dimensional data models.
• Worked on multiple Data Marts in Enterprise Data Warehouse Project (EDW)
• Involved in designing OLAP data models extensively used slowly changing dimensions (SCD).

Environment: Power Designer, Erwin 9.5, IBM DB2, Oracle10g, SQL server 2012, Informatica Power Center 8.6, Pentaho Data Integrator (PDI) SQL BI 2008, Oracle BI, Visual Studio, Crystal Reports, SSIS&SSRS, SQL server management studio 2012, TOAD for DB2, Microsoft Excel, Access 2010.

Confidential, Columbus, OH

Data Modeler/ Data Analyst

Responsibilities:

• Demonstrated strong analytical skills in identifying and resolving data exchange issues.
• Developed Data Mapping, Data Governance, Transformation and cleansing rules for the Master Data Management Process.
• Executed enterprise Data Governance strategies in line with the organization’s business strategy and objectives.
• Conducted meetings with D.R.B team for Metadata approval.
• Good experience in data analysis querying and writing in SQL and TOAD.
• Extensively used Data Tools to maintain consistent data.
• Performed Data Stewardship roles like Implement data standards, create metadata and manage data bases.
• Convert data from multiple sources and run validation test on converted data.
• A thorough understanding and experience with the entire Data migration process from analysis of existing data, cleansing, validation, translation tables, conversions and subsequent upload into new platform.
• Used E.F Codd’s Normalization methods 1NF, 2NF, 3NF and Denormalization techniques for effective performance in OLTP and OLAP systems.
• Designed data models in Dimensional Modeling (D.M) environment.
• Executed SQL queries to retrieve data from databases for analysis purpose.
• Created Data Model reports and Data Dictionary (D.D) by using Erwin.
• Developing normalized Logical and Physical database models to design OLTP system for enterprise applications.
• Performing forward engineering operations to create a physical data model with DDL that best suits requirements from the Logical data model.

Environment: CA Erwin 9.5, Oracle10g, SQL server 2012, IBM DB2, Informatica Power Center 8.6, SQL BI 2008, Oracle BI, Visual Studio, Crystal Reports, SSIS&SSRS, SQL server management studio 2012, TOAD for DB2,Microsoft Excel, Access 2010.

Confidential, KS

Data Engineer

Responsibilities:

• Data Analysis, Development, Implementation & support of BSS Application in Telecommunication Industry.
• Implemented various Interfaces across Telecom Industry.
• Detailed understanding of Telecommunication Data Models.
• Data Mapping experience with Telecom tools Oracle BRM and RBM.
• Good understanding of CDR concepts in Telecom Domain.
• Executed Data Stewardship functions to maintain quality of data.
• Proficient in legacy conversion from Telecommunication systems to VOIP.
• Performed Data mapping between two distinct Telecom Data models.
• Solid understand of data analysis techniques and processes.
• Proficient in Enhanced Telecom Operations Map (eTOM) and New Generation Operation Support Systems (NGOSS)
• Detailed knowledge in Wire line/Land line/Wireless communications and DSL. Solid understanding of Telecom protocols, Wi-Fi and WiMAX concepts
• Consolidation of multiple Data Models into a single data base
• Data Mapped from legacy systems to target systems, Involved in Data Migration projects with full life cycle implementation.
• Worked with the business in helping define & develop business rules, Value maps, source to target Data Mapping documents and assisting ETL Development Team in development activities.
• Solid understanding of Data Validation and Data Quality Methods, Performed Data Profiling using SQL and other methods.

Environment: MS SQL Server 2008 R2, Oracle 9i, Oracle BRM and RBM, VOIP, Wi-Fi, Wi-Max, Informatica Power center, Pentaho Data Integrator (PDI) Power designer, SAS, DTS, MS Analysis Services, Crystal Reports, Visual Studio, Microsoft Excel, Access 2007.

Confidential, Cambridge, MA

Data Analyst/Data Mapper

Responsibilities:

• Involved in the creation and maintenance of repositories containing metadata.
• Document the conversion processes, Ensuring data accuracy and Integrity
• Used reverse engineering (RE) to connect to existing database and create graphical representation ERD diagram.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Developed process methodology for the reverse engineering phase of the project.
• Executed queries against data bases to analyze data pattern and created reports.
• Developed project plan with project manager’s assistance for the first two phases of the project.
• Involved in logical and physical designs and transforms logical models into physical implementations.
• Involved in Data Migration (DM) from old database to new database.
• Involved in different team review meetings and critical design review of the finalized database model.
• Created documentation and test cases, worked with users for new module enhancements and testing.

Environment: Oracle 9i database, SQL Server 2005, IBMDB2, Microsoft Transaction Server, Erwin, Crystal Reports, Informatica Power center, SAS, MS-SQL server analysis manager, TOAD for DB2, Microsoft Excel, Access 2007.

Confidential

Data Base Developer

Responsibilities:

• Involved in gathering user requirements along with business analysts, designed and developed the database.
• Involved in all phases of SDLC including analysis, designing, developing, testing and maintenance.
• Created logical and physical design of the central relational database.
• Part of team conducting logical data analysis and data modeling JAD sessions, maintained data-related standards.
• Initiated use case analysis using UML, which provided the framework for potential use case deliverables and their inter-relationships.
• Performed in-depth analysis on the business objectives.
• Extensively used Normalization techniques.
• Mapped the data between Source and Targets databases.
• Experience in Data Extraction and Conversion and in preparing the Gap Analysis.
• Maintained Design document and performed testing.
• Gathered user specifications and system requirements for development process.
• Converted Data stored in flat files into Oracle tables.
• Used MS Visio for Creating Process flow diagrams.
• Good experience in data analysis, querying and writing in SQL and TOAD.

Environment: Erwin 6.0 SQL server 2005,Oracle 9i database, IBM DB2, Visual Paradigm for UML 6.0,SQL server Management studio 2005,MS Visio, TOAD for DB2, MS Access 2003, SQL Navigator, Windows NT, Microsoft Office 2003.