SUMMARY

• Having 16+ years of IT experience, in Software Development Life Cycle with major focus on Data Warehousing, developing Database Schemas like Star Schema and Snowflake Schema used in dimensional modeling and OLTP Schemas.
• Extensive data modeling (Star schema for data marts and E - R modeling for client server application) using MS VISIO 2010, Enterprise Architect, ERWIN 4.1 designer.
• Experience in Design of Data warehouse as a Data modeler and Data Migration/Conversion data models
• Skilled in Data warehouse tools, ETL tool Informatica 7.5/8.0/9.0, SSIS 2005/2008/2010 , SCRIBE 8.0 and other reporting tools SSRS 2005/2010 and Crystal Reports.
• Installing and configuring Informatica Software on Windows, UNIX and Linux Platforms
• Installing and configuring Informatica MDM Software on UNIX and Linux system using Jboss.
• Worked Extensively in Master Data Management(MDM) using Siperian3.0, FirstLogic2.5
• Implemented Various MDM solutions and Data Cleansing techniques.
• Implemented Business Intelligence solutions using Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations
• Performed Informatica Admin tasks by using admin console and PMREP commands.
• Worked extensively with Informatica Designer to create complex Mappings Experience in performance tuning of sources, Mappings, targets and sessions.
• Designed solutions for complex legacy data systems and Data mappings are identified for various legacy data sources
• Strong in designing teh Staging databases and intermediate integrations databases DWH and Data Conversion and migration solutions.
• Proficient in SQL scripting. Writing PL/SQL and T-SQL procedures for processing business logic in teh database.
• Extensive experience in migrating SAP CRM, MS Dinamics CRM, Salesforce Data and Veeva CRM Data.
• Having noledge on Hadoop, Hive, Scoop and oozie.
• Good experience in working with web-services for various ERP and hosting services
• Maintenance and system support for database, Data warehousing tasks and UC4 jobs.
• Worked with leading Software Consulting firms.
• Good communication and interpersonal skills.
• Consecutive Best outstanding performer award winner.
• Presently Working with Intelli Soft tech as consultant
• Worked with HCL America/Singapore/India for last 4 years
• Worked with Confidential Services for 6 months
• Worked with Symphony Services for 5 years
• Worked with Sierra Atlantic for 1 year
• Worked with ValueLabs for 2 year
• Worked with CS Infosys for 2.5 year
• Worked with HIIT for 1.5 year

TECHNICAL SKILLS

Data modelling Tools: Erwin, MS Visio, Enterprise Architect (EA)

Database: Oracle 8.0, Oracle 8i/9i/10g/11g and SqlServer 2000/2005/2010 , Teradata, Netezza, PostgreSql, MySql

Reporting tools: Crystal Reports, Business Objects, Cognos, SSRS and ReportNet

ETL Tools: Siperian (Informatica MDM), Informatica, IDQ, Data Stage, SSIS, SSAS and Scribe

Other Tools: TOAD, PL/SQL developer

Operating Systems: UNIX (AIX, Solaris), LINUX, Windows NT/98/95, 2000, 2003.

Programming: SQL, PL/SQL, Unix Shell script, VB Script, Java script, Perl

ERP: People Soft 8.0, Microsoft Dynamics 4.0 and 2011, SAP BW, SAP CRM

PROFESSIONAL EXPERIENCE

Confidential - Irving TX

Data Architect

Environment: Adobe Campaign 6.0, Informatica 9.X, Oracle 11g, SQL Server and UNIX

Responsibilities:

• Interacting with business users for requirement analysis of new development applications
• Working on Functional design documents to define teh functionality of reporting.
• Identifying Data Elements for Reporting
• Creating Data mappings between source system and teh DWH System
• Creating Data mappings between DWH system and Dashboard repots and aligning metrics.
• Performing data cleansing operations on teh PII data.
• Working on Technical design documentation to capture teh coding requirements.
• Designing teh ETL processes and File transfer processes.

Confidential - Marlborough MA

Data Architect

Environment: Informatica 9.0, Informatica MDM 9.x, Oracle 11g, SQL Server and UNIX

Responsibilities:

• Interacting with business users for requirement analysis of new development applications
• Working on Functional design documents to define teh functionality of reporting.
• Identifying and designing MDM Solutions using Informatica MDM(Siperian MDM).
• Performing data cleansing operations on teh party data.
• Working on Technical design documentation to capture teh coding requirements.
• Designing teh ETL processes and File transfer processes.
• Working on Data mapping Exercise from source to target for ETL Jobs.
• Designing teh process for Error Handling /Data validation rules.
• Performing Informatica Administration for patch/Hotfix upgrades and Installations.
• Creating Sessions and Workflows using Informatica Workflow Manager.
• Working on Informatica mapping development.
• Unit testing on Informatica mappings.
• Developing technical reports and processes for data validation.
• Creating reusable transformations in Transformation Developer.
• Worked on Data Virtualization and data transformations
• Responsible for building dev and test repositories to ensure strong testing environment and smooth transition to production.
• Managing a team of 5 members

Confidential - Richardson TX

Data Architect

Environment: Informatica 9.0, Oracle 11g and UNIX

Responsibilities:

• Interacting with business users for requirement analysis of new development applications
• Working on Functional design documents to define teh functionality of reporting.
• Working on Technical design documentation to capture teh coding requirements.
• Designing teh ETL processes and File transfer processes.
• Working on Data mapping Exercise from source to target for ETL Jobs.
• Designing teh process for Error Handling /Data validation rules.
• Creating Sessions and Workflows using Informatica Workflow Manager.
• Working on Informatica mapping development.
• Unit testing on Informatica mappings.
• Developing technical reports and processes for data validation.
• Creating reusable transformations in Transformation Developer.
• Responsible for building dev and test repositories to ensure strong testing environment and smooth transition to production.

Confidential - Plano TX

Data Architect

Environment: Informatica 9.0, Oracle 11g, SQL Server, SAP BW, SAP CRM and UNIX

Responsibilities:

• Interacting with business users for requirement analysis of new development applications and to define business and functional specifications.
• Performing XLM Data Loads, using XSD
• Documenting user requirements, translating requirements into system solutions and developing implementation plans and schedules.
• Working on Logical and Physical design of data marts.
• Creating Table space in Database.
• Working on Data mapping from SAP applications to GDW .
• Working on Functional design documents to define teh functionality of reporting.
• Working on Technical design documentation to capture teh coding requirements.
• Designing teh ETL processes and File transfer processes.
• Working on Data mapping Exercise from source to target for ETL Jobs.
• Designing teh process for Error Handling /Data validation rules.
• Creating Sessions and Workflows using Informatica Workflow Manager.
• Working on Informatica mapping development.
• Worked on IDQ for Data cleansing and golden source records
• Unit testing on Informatica mappings.
• Developing technical reports and processes for data validation.
• Creating reusable transformations in Transformation Developer.
• Responsible for building dev and test repositories to ensure strong testing environment and smooth transition to production.

Confidential - Whitehouse Station, NJ

Data Architect

Environment: Informatica 9.0, SQL Server 2008, Oracle 11g, VEEVA CRM and UNIX

Responsibilities:

• Performed impact analysis for systems and prepared Impact analysis document according to Customer Service Request (CSR).
• Interacted with teh Client in gathering teh requirements for development.
• Ensure high quality ETL development work via standards, guidelines, quality assurance reviews and testing.
• Estimate teh time and resource requirements of ETL development work.
• Follow teh progress of ETL development and how it meets estimate and actual timelines.
• Raise critical technical issues to vendors or key stakeholders in a timely manner where they would impact on teh project timeline.
• Interaction with clients to clarify teh doubts if any.
• Involved in System Integration Testing, User Acceptance Testing and implementation of code to production.
• Deploy teh Informatica code and UNIX scripts to different Environments such as SIT, UAT and Production.
• Identified data migration objects/entities
• Defining teh project scope
• Gathering and Managing Functional requirements from teh business teams
• Managed CR’s for teh additional functional requirements
• Implemented solution using Informatica
• Metadata driven mappings implemented between Veeva CRM
• Data Modeling and Design for Intermediate/Staging for data migration
• Defined teh staging environments for heterogeneous sources
• Performed teh performance and tuning activities
• Scoping teh Migration strategy planning and effort estimates.
• Identified Business rules for teh data migration.
• Best Practices implemented for Informatica tool
• Implementing teh best performance strategies

Confidential

Data warehouse Architect/Data Modeler

Environment: Scribe 8.0, SQL Server 2008, MS Dynamics CRM

Responsibilities:

• Analyzed business requirements, performed source system analysis, prepared technical design document and source to target data mapping documents
• Analyze teh High level Design and Participated in Preparing teh Technical Design documents with required specifications.
• Implemented complex dmls, XREF and sqls to reach teh business rules of project.
• Created teh sub-graphs and Graphs for Extracting Transforming and loading teh data into different systems.
• Ensure high quality ETL development work via standards, guidelines, quality assurance reviews and testing.
• Estimate teh time and resource requirements of ETL development work.
• Raised critical technical issues to key stakeholders in a timely manner where they would impact on teh project timeline.
• Involved in System Integration Testing, User Acceptance Testing and implementation of code to production.
• Identified data migration objects/entities
• Implemented solution using SCRIBE
• Migration strategy planning and effort estimates.
• Metadata driven mappings implemented between MS Dynamics CRM 4.0 and 2011
• Data Modeling and Design for Intermediate/Staging for data migration
• Identified Business rules for teh data migration.
• Best Practices implemented for Scribe tool using MS CRM Filtered views and Scribe CRM adaptors
• Implementing teh best performance strategies

Confidential

Data warehouse Architect/Data Modeler

Responsibilities:

• Data Modeling and Design for Intermediate/Staging for data migration
• Implemented solution using SSIS
• Migration strategy planning and effort estimates.
• Identified Business rules for teh data migration.
• Implementing teh best performance strategies

Confidential

Data warehouse Architect/Data Modeler

Responsibilities:

• Data Modeling Design for teh Middle layer Integration
• Planning and effort estimates.
• Designed and Implemented Database Scripts for Oracle fusion middleware
• Performed Data migration from Oracle Apps ERP to Custom systems.
• Migrated Oracle Material Management (MM),Oracle Sales and Distribution(SD), Oracle Financial services (FSDF) to teh DWH Systems.
• Designed Metadata Driven data model for teh fusion integration application
• Designed XML based Database Architecture
• Implementing teh best performance strategies

Confidential

Data Architect/Data Modeler

Responsibilities:

• Data Modeling and Design according to teh BRD for DWH and CRM
• Implemented solution using SSIS
• Designed CRM Product Architecture.
• Designed teh Intermediate database for data migration.
• Dev team and QA team interaction
• Customer focus for their requirements implementation.

Confidential

Data Architect/Data Modeler

Responsibilities:

• Database testing for Master Data management.
• Offshore Testing team co-ordination
• Test case preparation
• Reviewing teh bugs
• Dev team and QA team interaction
• Working with client at USA (MTV).