Professional Summary:

• 10 years of IT experience in Transactional Applications, Analytical Platforms BI platforms as an architect, analyst and developer in Retail, Communication and Insurance Industries.
• Performed various roles in space of DWH BI like Data Architect, Data Analysis, ETL lead, ETL developer and BI reports, dashboards and advanced visualization of analytical report developer.
• Extensively worked on ODS for the implementation of source and reporting purpose and to transfer the data from OLTP to OLAP.
• Extensive knowledge in Erwin Data Modeler, IBM InfoSphereDatastage, Information Analyzer IBM Infosphere Business Glossary, IBM Metadata Workbench and IBM Cognos, MS Office.
• Proficient in working with Netezza, Oracle, Access, SQL Server, Teradata and DB2 Databases.
• Extensive experience working with Oracle 9i/10g/11i.
• Implemented database design on various database vendors like ORACLE, SQL SERVER, and NETEZZA.
• Having experience and good understanding on industry standard data models for Retail and Insurance business domain.
• Created various database layers like Conceptual Data Modeling, Logical Data Modeling, Physical Data Modeling, Enterprise Data Warehouse Design, Operational Datastore Design, Datamart Design, and Metadata Management.
• Used and enhanced database design using Design best practices and implemented reusable design components Erwin
• Worked on Kimball and Inman and IBM Data warehouse framework models for building data warehouse and marts. Worked on database design for OLTP Database and for Web application development databases.
• Worked with OLAP schemas like star schema and snowflake schema and OLTP Schemas like 3NF, 2NF and 1 NF..
• Well versed with Database notations, data flow diagrams and use case diagrams.
• Have experience on conducting workshops and get all stake holders on same page.
• Hands on experience with Requirement gathering, Analysis, Design, Modeling, Development, Implementation and testing of Data warehouse applications
• Involved in different stages of data warehouse development for moving Heterogeneous sources to a Data Mart/Data warehouse using ETL tools like Informatica, SSIS and data stage tools.
• Identified gaps in the Data Model and address them actively in collaboration with business teams.
• Large volume data conversion, data cleansing, production report generation, and upholding scheduled data delivery standards.
• Skilled in writing technical specification documents, Technical Design Documents, Solution Design Document, translating user requirements to technical specifications and Detailed Source To Target Documents.
• Effective in cross-functional and global environments to manage multiple tasks and assignments concurrently.
• On hand working experience with Oracle SiteHub, Oracle RPAS, Oracle RDF, Hyperion Planning, Oracle EBS, Markit EDM.
• Excellent working Experience in creating a

Technical Competencies:

ETL TOOLS: INFORMATICA POWER CENTER 8.6, SSIS, DTS, SAS and IBM Data stage, Markit EDM

PROFILING TOOLS: Informatica Data Quality, Information Analyzer, IBM Data Discovery

MODELING TOOLS: ErWin

REPORTING TOOLS: BUSINESS OBJECTS XI R3, COGNOS, QLIKVIEW

DATABASE SCRIPTING: SQL, PL/SQL, T-SQL

DATABASES: ORACLE, DB2 UDB, DB2 Mainframe, SQL SERVER, NETEZZA, TERADATA

CLIENT TOOLS: VC , VB, MS Office

AUTOMATION TOOLS: CONTROL-M, AUTOSYS, DATASTAGE SCHEDULER

APPLICATIONS Oracle SiteHUB, Oracle EBS, Hyperion Planning, Oracle RPAS, RDF, Markit EDM, SalesForce

Confidential

Sr.DataAnalyst/Data Modeler/Data Architect

Responsibilities:

• Coordinating with the owners of business to develop data warehouse to support the Participant, Plan and Fund Info, Data mart to support the Plan Health Score Card and various applications like Investment Master Data Management Markit EDM to server as Single Repository for Fund related Info and other Transactional Applications Fund related Systems, Web Inputs, Customer Rep Systems, Client Factsheets, IVR Input systems, SalesForce system etc .
• Conducted workshops on Data Modeling and demonstrated the modeling aspects.
• Identified the right granularity systems for the Investment Master Data management application Markit EDM .
• Generated Data profiling reports on various source systems to cleanse the data and provide the data governance to the other Team members.
• Performed Data Analysis and conducted reverse engineering for the existing legacy database applications.
• Suggested alternative ways to the desired data from the legacy systems.
• Developed HLD document for ETL.
• Suggestions provided for the existing Data Models and its implementation road maps.
• Worked with SMEs to get insides of business knowledge for the current project scope.
• Created Source to Target Mapping Documents for ODS Operation Data Layer and ADL Atomic Data Layer , DM Data Mart Layer , Transactional Applications and User Interface.
• Defined the Data Flow from Legacy to ODS, ODS to ADL, ADL to DataMart and Inter Applicaitons.
• Developed Reference Data Model, Goldcopy Data Model, Staging Data Model for various Complex Applications like Markit EDM to support various Rules, Validations, Transactions to hold the Master Data needed to support the Business Requirements.
• Generated DDLs, Views, Indexes and deployed across the environments and Maintained the Change Control Forms to make sure all the environments are in sync.
• Created Data flow Diagrams, Standardized Templates, Solution Design Documents, Rules and Validation Documents.
• Lead the Entire End to End Data Modeling Efforts and helped ETL Team in guiding thru the Database design and Development.
• Guided Development Team in various Implementation Aspects like writing complex sqls, performing best practices, Performance Tuning etc
• Guided the Business Team in understanding the different types of Modeling aspects like Conceptual, Logical and Physical as well as Constraints like Primary Key, Foreign Key, Composite Key, Surrogate Key Concepts.
• Worked with Business Glossary Team to store the Business Definitions and storing the definitions.
• Performed in-depth Data Analysis and generated dynamic MS Excel reports for business using Pivot Functions and other functions.
• Was involved in Project Estimation.
• Created complex SQLs and Views.
• Worked on Gap Analysis and Data Certification

Hardware/Software:

Erwin Data modeler 7.1,9.2, 9.5, IBM Information Server EE 8x Designer, Director , IBM Info Analyzer, IBM Metadata workbench, IBM Business Glossary, IBM Cognos, TOAD, DB2, UNIX/Linux, Sql server, Autosys, MS Office, MS Project, MS Visio, Markit EDM, SalesForce.

Confidential

Sr.DataProfiler/Data Modeler/Data Architect

Responsibilities:

• Coordinating with the owners of business to develop data warehouse, data mart and various applications like Oracle RPAS, Oracle RMS and Oracle RDF.
• Conducted workshops on Data Modeling and demonstrated the modeling aspects
• Defined Architecture Standards and created Documents to meet the Architecture needs and share with the Architectural Review Boards.
• Identified the right granularity systems for the Oracle RPAS.
• Generated Data profiling reports on various source systems to cleanse the data and provide the data governance to the other Team members.
• Performed Data Analysis and conducted reverse engineering for the existing legacy database applications.
• Suggested alternative ways to the desired data from the legacy systems.
• Developed HLD document for ETL.
• Suggestions provided for the existing IA model and its implementation road maps.
• Worked with SMEs to get insides of business knowledge for the current project scope.
• Worked as SME for the some of the existing system
• Created Source to Target Mapping Documents for ODS Operation Data Layer and ADL Atomic Data Layer , DM Data Mart Layer
• Defined the Data Flow from Legacy to ODS, ODS to ADL, ADL to DataMart and ADL to Various Applications.
• Developed various Complex forecast and Planning Applications like RPAS Retail Planning Application Server from Oracle and RDF Retail Demand in Forecast from Oracle , Oracle Site Hub, Hyperion Planning, Oracle EBS.
• Generated DDLs, Views and deployed across the environments.
• Created Data flow Diagrams, Standardized Templates.
• Was involved in Project Estimation.
• Created complex SQLs and Views.
• Worked on Gap Analysis and Data Certification

Hardware/Software:

Erwin Data modeler 7.1, IBM Information Server EE 8x Designer, Director , IBM Info Analyzer, IBM Metadata workbench, IBM Business Glossary, IBM Cognos, TOAD, Netezza, DB2, Oracle 10g, UNIX/Linux, Sql, Pl/SQL, UNIX Shell Scripting, Autosys, MS Office, MS Project, MS Visio, Oracle Site HUB, Oracle EBS.

Confidential

Sr.DataProfiler/Data Modeler/Data Architect

Responsibilities:

• Coordinating with the owners of business to develop data warehouse, data mart and various applications like Oracle RPAS, Oracle RMS and Oracle RDF.
• Conducted workshops on Data Modeling and demonstrated the modeling aspects
• Identified the right granularity systems for the Oracle RPAS.
• Generated Data profiling reports on various source systems to cleanse the data and provide the data governance to the other Team members.
• Performed Data Analysis and conducted reverse engineering for the existing legacy database applications.
• Suggested alternative ways to the desired data from the legacy systems.
• Developed HLD document for ETL.
• Suggestions provided for the existing IA model and its implementation road maps.
• Worked with SMEs to get insides of business knowledge for the current project scope.
• Created Source to Target Mapping Documents for ODS Operation Data Layer and ADL Atomic Data Layer , DM Data Mart Layer
• Defined the Data Flow from Legacy to ODS, ODS to ADL, ADL to DataMart and ADL to Various Applications.
• Developed various Complex forecast and Planning Applications like RPAS Retail Planning Application Server from Oracle and RDF Retail Demand in Forecast from Oracle , Oracle Site Hub, Hyperion Planning, Oracle EBS.
• Generated DDLs, Views and deployed across the environments.
• Created Data flow Diagrams, Standardized Templates.
• Was involved in Project Estimation.
• Created complex SQLs and Views.
• Worked on Gap Analysis and Data Certification

Hardware/Software:

Erwin Data modeler 7.1, IBM Information Server EE 8x Designer, Director , IBM Info Analyzer, IBM Metadata workbench, IBM Business Glossary, IBM Cognos, TOAD, Netezza, DB2, Oracle 10g, UNIX/Linux, Sql, Pl/SQL, UNIX Shell Scripting, Autosys, MS Office, MS Project, MS Visio, Oracle Site HUB, Oracle EBS.

Confidential

Sr Data Analyst/ Sr. Data Modeler/Sr.DataStage Lead/DataWareHouse Developer

Responsibilities:

• Actively participated in the Team meetings to gather the business requirements and developing the specifications.
• Extensively used DataStage Designer to develop various jobs to extract, cleanse, transform, integrate and load data into target tables.
• Prepared technical design/specifications for Data Extraction, Data Transformation, Data Cleansing and Data Loading.
• Worked extensively on ODS to integrate data from multiple sources for additional operations on the data before passing back to operational systems for further operations and to the data warehouse for reporting.
• Extracted data from various sources performed Data transformations and loaded into the target Oracle, DB2 and Teradata database.
• Designed DataStage Parallel jobs with Change Capture, Change Apply stages.
• Developed user-defined Transforms, Routines, Stage Variables and Stored Procedures.
• Automated and fine-tuned Data Stage jobs and sequences for loading source systems data into Data warehouse.
• Implemented logic for Slowly Changing Dimensions.
• Used Stage Variables, Transforms, Subroutines of DataStage Server Jobs.
• Used debug mode in data stage to test the data flow and fix jobs
• Extensively wrote user-defined SQL coding for overriding Auto generated SQL query in DataStage.
• Used local and shared containers to increase object code reusability and to increase throughput of the system.
• Wrote UNIX scripts as required for preprocessing steps and to validate input and output data elements, along with data stage routines.
• Developed job sequences with restart ability check points, and implemented proper failure actions.
• Developed back end interfaces using PL/SQL stored Packages, Procedures, Functions, Bulk Collections, Bulk Variables and Triggers.
• Used SSIS, SSRS for the reporting purpose for different requirements.
• Participated in the review of Technical, Business Transformation Requirements Documentation.

Hardware/Software:

IBM Information Server EE 8x Designer, Director , Quality Stage, IBM Infosphere suite, Teradata, DB2 UDB 8.0, Oracle 10g, UNIX/Linux, Sql, Pl/SQL, Toad, SQL Loader, UNIX Shell Scripting, Autosys, Erwin 7.2, BTEQ, MS Excel

Confidential

Data Analyst/ Datastage Developer

datastage manager for managing datastage repository.

Responsibilities:

• Worked with various sources such as Oracle DB, Accessmdb, Flat files to extract data and used IBM WebSphereDataStage to load the data into Data Warehouse built on Oracle.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.
• Designed various procedures for getting the data from operational systems in to Data Warehousing system.
• Worked using SOA repository manager to gather the information from various domains to design the various phases of systems development integration in computing.
• Designed the Data Mart model with Erwin using Star Schema methodology.
• Extensively used various stages and transforms of the DataStage Server jobs for various types of date conversions.
• Documented the metadata to capture from the sources.
• Created sessions and batches to extract the data.
• Closely worked with Autosys mid support team for setting up production job cycles for daily, monthly, weekly loads with proper dependencies.
• Created jobs using DataStage Designer and used Datastage Director to validate schedule run and monitor the DataStage jobs.

Software Environment:

IBM WebSphereDataStage 7.1 Director, Designer, , Profile Stage, MetaStage, DB2/UDB, Access, Oracle 10g, Autosys, PL/SQL, SQL Developer, SQL Plus, Red Hat Enterprise Linux AS, BTEQ, Windows Server 2003, IBM Cognos.

Confidential

Data Modeller/DataStage Developer

Responsibilities:

• Data modeling done for Claims and Annuity Data Marts.
• Designed and developed star schema data marts.
• Designed various procedures to get the data from various flat files to load in to Data Warehouse.
• Extensively used ETL to load Access data in to Oracle database.
• Designed and developed various Pl/Sql scripts to meet the business requirements.
• Used various server stages to design varios jobs.
• Involved in design, source to target mappings between sources to operational staging targets, using DataStage Designer.
• Used DataStage Director to run and monitor the jobs for performance statistics.
• Used ERWIN 4x for the data modeling purpose.

Software Environment:

AscentialDatastage 5x, Oracle , MS Access, MS Excel, MS windows.

-