ETL/ development and architecture, data modeling
Resume:
Narendra Rawat
Experience Summary
• More than 16 years of experience in software architecture, design, development, implementation and support of mission critical business applications using Data warehousing ETL/BI, Client/Server and web application on Windows and Unix platforms. And also using formal software engineering and project management methodologies.
• Worked on Projects for BFSI clients such as Deutsche Bank, Fidelity, RBS, GE Capital Treasury and Credit Suisse, Retail Client such as British American Tobacco, Del Monte Foods Inc. and ITC, Justice Sector Client like Department of Corrections, Govt. of New Zealand, Corporate Legal Service client like Wolters Kluwer, Oilfield service client like WeatherFord International Inc. and digital marketing service client like Dex Media.
• Working with Oracle - PL/SQL, Database design/architecture, performance tuning and troubleshooting, Data modeling (Relational and dimensional) using Erwin, MS Visio and Oracle Designer 10.1 for more than 10 years.
• Working with ETL - Informatica PowerCenter 8.6.1/9.5.1, Datastage 8.7, OWB 10.1, SSIS Designer, Repository Manager, Administration Console, Workflow Manager, Workflow Monitor including Administration and performance tuning of Informatica transformations/mappings/sessions/ workflow’s etc for 10+ years.
• Over 3 years of experience in generating various complex reports and Dash Boards using
SAP Business Objects XI R3.1/Crystal Reports 2008 and Oracle Discoverer 10.1
• Over 10 years of experience working in multi-terabytes data warehouse using Databases like Oracle 10g/11g, SQL Server 2008, IBM DB2, XML, MS Excel and Flat files.
• Knowledge of oracle 10/11g - RAC and ASM
• Worked with Siebel CRM 7.8 - EIM (Enterprise Integration Manager) for 2.5 years and Enterprise Salesforce.com CRM for few months.
Computer skills
Data Modeling Tools : ERwin 7.1, MS Visio, Oracle Designer 10.1
Database : Oracle 11g, SQL Server 2008 R2
DB GUI Tool : TOAD 9.1, SQL navigator, PL/SQL developer
ETL Tool : Informatica PowerCenter 8.1.1/8.6.1/9.5.1, Oracle Warehouse Builder
10.1, SSIS, DataStage 7.5/8.7
BI Tool : SAP Business Object XI R3.1, Crystal Reports 2008,
Oracle Discoverer 10.1
CRM : Siebel 7.8 (EIM), Salesforce.com
System Software : Unix Shell Programming
Languages : Java, Cobol, ‘C’, C++
Pre * Compiler : Pro* C, sqlJ.
Operating system : Unix, Linux (Redhat 7.1), Windows NT 4.0, Windows 2000, Windows
XP, Windows 7, VMS Server
Front End Tools : Developer/2000 ( Forms 10.1, Reports 10.1 ), Visual Basic 6.0.
Web Technologies : ASP, JavaScript, VBScript, HTML.
Version Control Tools : IBM Rational ClearCase, MS VSS, MS TFS, CVS
Bug Tracking Tools : IBM Rational ClearQuest, Bugzilla
Data Virtualization : Composite
Batch Scheduling Tool : Control-M
Work Experience
Compunnel Software Group Inc, United States, Senior Consultant, Oct 2015 - Till date.
Project executed:
Credit Suisse, New York City (NY), USA
Role: ETL-Data Architect / Project: Expense Analysis and Management Information System
Software/Hardware/OS: Oracle 11g, Erwin Data Modeler 7.1, Informatica 9.5.1, SQL Server 2012, Business Objects/Crystal Reports, Unix, Control-M.
Role & Responsibilities:
• Responsible for creating solution design and architecture (conceptual, technical, information/data, integration, and data delivery) of the datawarehouse application
• Ensuring that the delivered solutions are adhering to best practices and client enterprise architecture standards
• Adopt and communicate new concepts, ideas, techniques, best practices and technology assistance in BI space
• Lead ETL/BI solution requirements working sessions with business users
• Support the technical delivery review process
• Build logical and physical data model
• Define Database and ETL coding standard
• Build Oracle database coding framework for reusability
• Code review
• Define meta data standard for datawarehouse
• ETL/Database coding, performance tuning, data cleansing/purging as deliverables
• Gather requirements with business users and convert to solution design deliverables
• Deliverables conform to client standards and meet the specified requirements
• The test plans are in place and executed for the project
• Solution risks are identified early and properly managed
• Delivered solutions are flexible and follow industry standards and best practices
Tech Mahindra (Americas) Inc, United States, Solutions Architect, Feb 2015 - Oct 2015.
Project executed:
GE Capital, Stamford (CT), USA
Role: Data Architect / Project: GE Capital Treasury Datawarehouse
Software/Hardware/OS: Oracle 11g, Erwin Data Modeler 7.1, Informatica 9.5.1, Informatica Metadata Manager, SQL Server 2012,Cognos, TM1 Unix.
Role & Responsibilities:
• Responsible for creating solution design and architecture (conceptual, technical, information/data, integration, and data delivery) of the datawarehouse application
• Ensuring that the delivered solutions are adhering to best practices and client enterprise architecture standards
• Adopt and communicate new concepts, ideas, techniques, best practices and technology assistance in BI space
• Lead ETL/BI solution requirements working sessions with business users
• Support the technical delivery review process
• Build logical and physical data model
• Define Database and ETL coding standard
• Build Oracle database coding framework for reusability
• Code review
• Define meta data standard for datawarehouse
• ETL/Database coding, performance tuning, data cleansing/purging as deliverables
• Gather requirements with business users and convert to solution design deliverables
• Deliverables conform to client standards and meet the specified requirements
• The test plans are in place and executed for the project
• Delivered solutions are flexible and follow industry standards and best practices
HCL America Inc, United States, Senior Technical Lead, Sep 2007 to Feb 2015.
Projects executed:
Merck & Co. New Jersey, USA
Role : Data Architect / Project : Composite
Software/Hardware/ OS: : Oracle 11g, Erwin Data Modeler 7.1, Informatica 9.5.1, SQL Server 2012. Linux, Composite.
Role & Responsibilities:
• Responsible for creating solution design and architecture (conceptual, technical, information/data, integration, and data delivery) of the solutions
• Ensuring that the delivered solutions are adhering to best practices and client enterprise architecture standards
• Adopt and communicate new concepts, ideas, techniques, best practices and technology assistance in data migration space
• Build logical and physical data model
• Gather requirements with business users and convert to solution design deliverables
• Deliverables conform to clientt standards and meet the specified requirements
Dex Media Inc, Santa Monica(CA), USA
Role: ETL-Data Architect / Project: DexNet Sync
Software/Hardware/ OS : Oracle 11g, Erwin Data Modeler 7.1, Java, Informatica 9.5.1, SQL Server 2012. Linux, Unix
Role & Responsibilities:
• Participate in requirements definition, analysis and the design of logical and physical data models
• Responsible for creating solution design and architecture (conceptual, technical, information/data, integration, and data delivery) of the migration solutions
• Map business requirements to logical and physical data models
• Reverse engineer source system data structures
• Enforce & promote standards and best practices in data modeling efforts
• Build logical and physical data model
• Build Oracle database coding framework for reusability
• Code review
• Define meta data standard for datawarehouse
• ETL/Database coding, performance tuning, data cleansing as deliverables
• Gather requirements with business users and convert to solution design deliverables
• Deliverables conform to client standards and meet the specified requirements
Weatherford International, Huston(TX), USA
Role : ETL-Data Architect / Project: DataStage-Informatica ETL Migration
Software/Hardware/OS: Oracle 11g, Erwin Data Modeler 7.1, Informatica 9.5.1, DataStage 7.5/8.7, Unix
Role & Responsibilities:
• Responsible for creating solution design and architecture (conceptual, technical, information/data, integration, and data delivery) of the ETL solutions
• Ensuring that the delivered solutions are adhering to best practices and architecture standards
• Adopt and communicate new concepts, ideas, techniques, best practices and technology assistance in ETL space
• Define both ETL and database coding standard
• Build/Define environment for development, QA and production
• Lead ETL solution requirements working sessions with business users
• Support the technical delivery review process
• Effort estimation and planning
• ETL coding and performance tuning as deliverables
• Code review
• Deliverables conform to client standards and meet the specified requirements
• The test plans are in place and executed for the project
Del Monte Corp, Pittsburgh(PA), USA
Role : Data Architect / Project: Enterprise Data Migration
Software/Hardware/OS: Oracle 11g, Erwin Data Modeler 7.1, TIBCO, Unix
Role & Responsibilities:
• Responsible for creating solution design and architecture (conceptual, technical, information/data, integration, and data delivery) of the migration solutions
• Ensuring that the delivered solutions are adhering to best practices and client enterprise architecture standards
• Adopt and communicate new concepts, ideas, techniques, best practices and technology assistance in data migration space
• Lead ETL/BI solution requirements working sessions with business users
• Support the technical delivery review process
• Build logical and physical data model
• Build Oracle database coding framework for reusability
• Code review
• Define meta data standard for datawarehouse
Wolters Kluwer Corporate Legal Services, New York, US
Role : BI Architect / Project: CLS Reporting System
Software/Hardware/OS: Oracle 11g, SAP Business Object XI R3.1, Crystal Report 2008, Informatica 9.5.1, SSAS, SQL Server 2008 R2, Unix
Role & Responsibilities:
• Understanding Business Requirements
• Build technical process document
• Build ETL and database coding standard and best practices document
• Build logical and physical data model
• Effort estimation and planning
• ETL coding and performance tuning as deliverables
• Gather requirements with business users and convert to solution design deliverables
• Deliverables conform to client standards and meet the specified requirements
• Helped the team on performance tuning of the ETL mappings and database with respect
to project release.
• Code review
Dept. of Corrections, Govt. of New Zealand, New Zealand
Role: BAU Lead / Project: Corrections Analytic Reporting System (CARS)
Software/Hardware/OS : Informatica 8.6 (ETL), Oracle 11g, Erwin Data Modeler / MS Visio, Oracle Discoverer Report (BI), Oracle Forms and Reports 10.1, Oracle Designer 10.1, Unix
Role & Responsibilities:
• Understanding Functional Specifications for Development/Enhancement and Maintenance & support requests from the customer
• Translation of Functional Specifications into Technical Specifications and Detailed Design
• Build logical and physical data model
• Effort estimation and planning
• Build coding framework for both for database and ETL
• Build coding standard and best practices documentation
• Code review
• Reviewing ETL, database Coding and Unit test cases for deliverables
• Ensuring Project process compliance
Deutsche Bank, London, UK
Role : Project lead / Project: Deutsche Bank – GM DART
Software/Hardware/ OS : Oracle 10g, Erwin Data Modeler/MS Visio, Informatica 8.1.1/8.6.1(ETL), Cognos (BI), Java, Essbase, Hyperion Planning, DRM, Unix
Role & Responsibilities:
• Leading the offshore team for Development/Enhancement, Maintenance and support of the project
• Understanding Business Requirements
• Understanding Functional Specifications for Development/Enhancement and Maintenance & support requests from the customer
• Translation of Functional Specifications into Technical Specifications and Detailed Design
• Build coding standard and best practices documentation
• Build logical and physical data model
• Code review
• ETL coding and performance tuning as deliverables
• Providing estimates for each work request to the client and monitor the progress of work
ITC Infotech India Limited (SEI CMM Level 5 company), Bangalore (INDIA), Associate – IT Consultant, March 2005 to Sep 2007.
Projects executed:
BAT (British American Tobacco) South Africa
Role : Technical Lead / Project: BAT Seven Up
Software/Hardware/OS : Erwin Data Modeler, Oracle 10g – PL/SQL & Siebel 7.8 on Client/Server, Informatica
(ETL), Windows XP
Role and Responsibility:
Design – Build a data-mapping document using Siebel Tool, including transformation rules to be applied to legacy data for conversion to the new system. Identify a transformation tool to use to perform translations between data and systems. Design workflows using various transformation in informatica.
Development/Test – Build and test the data migration and transformation process/scripts. Validate the data mappings and transformation. Develop the scripts and procedures necessary to automate any migration processes.
BAT (British American Tobacco)
Role : Database-ETL Consultant Lead / Project: V3 - CRM Product Support & Maintenance/Development
Software/Hardware/OS : Erwin Data Modeler, Oracle 9i/10g & Siebel 7.7 on Client/ Server, Informatica (ETL), Unix
Responsibilities:
• Responsible as Database/ETL Consultant lead
• Creation of various V3 Databases and Schemas using Oracle 9i.
• Setting up Seed Data using Conversion Load Process which includes Oracle SqlLoader and Siebel EIM process.
• Setting up various V3 Related applications like Brand Coverage Planning, Batch Control Console (Backend), List of Values Mapper (Siebel), etc.
• Design mappings/workflows using various transformation available in informatica.
• Monitoring and correcting the failures related to the various Nightly Batch Tasks includes Replication, Oracle Queues, Oracle Pl/Sql Procedures and Packages Execution, etc.
• Training BAT Staff in handling the Usage and Execution of various Nightly Batch Related Processes
Other relevant Experience:
• Binary Semantics Limited, Gurgaon (INDIA), System Analyst, July 2004 to March 2005.
• Business Solution Inc., Gurgaon (INDIA), Software Developer, Jan 2000 to Nov 2003.
• Software Technology Group Limited, Gurgaon (INDIA), Trainer, July 1997 to Dec 1999.
• CMC Limited, Gurgaon (INDIA), Trainer, Sep 1995 to July 1997.
• Apex Information Services Pvt Ltd., New Delhi (INDIA), Software Developer, Sep 1994 to Sep 1995.
Education :
1991-94, D.A.V. (P.G.) College, Dehradun, Uttarakhand (INDIA), BSc. (Bachelor of Science)
2000-2003, Indira Gandhi National Open University, New Delhi (INDIA),
MCA (Master of Computer Applications).
Contact this candidate