SUMMARY

• 17+ years in IT industry wif over 15+ years of strong background in Data warehousing, Application Systems, OLTP Application Systems, Data warehouse Architect and Data modeling and Strong ETL & Reports Development. In - depth/Detail experience at varied levels, Business & Requirement, Process, Analysis, SDLC, Design & Development, Testing, Support, Project Management.
• Data warehousing/Business Intelligence/OLAP/OLTP: Strong understanding and over 15+ years of exposure in related technologies, methodologies, Dimensional design, Star & Snow-flake Models using Erwin 7.1, ETL processes tools e.g. Oracle Warehouse Builder 10g/11g, Actian (formerly Pervasive) Data integrator 6/9.0/10.0, Informatica 6.x, Integration Services and OLAP reporting tools e.g.
• Business Object XI R1/R2/R3 wif Dashboard Manager, Reporting services (Microsoft SQL Server 2005/ 2008/2012/2014 ).
• Around 14+ years of extensive experience in database maintenance, analysis, design, development, data conversion, Data warehouse/Data Mart design, modeling and development, Performance tuning and implementation of several client/server applications using Oracle 9i,10g,11g MS SQL Server 2000/ 2005/ 2008/2012/2014 .
• Expertise Actian (formerly Pervasive) Data Integrator (Map designer and Process designer), INFORMATICA Power Mart/ Power Center 6.2/7.1 (Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformations) and Oracle Warehouse Builder 10g/11g (Oracle Warehouse Builder Workspace, OWB Design Center/Control Center Manager, Oracle Warehouse Builder Browser).
• Expertise in OLAP tool Business Objects 5.1/XI R1/R2 wif Dashboard Manager (Designer, Web intelligence, Import wizard, Info View, Central Management Console).
• Data Bases: Expert in writing PL/SQL, Stored Procedures, Packages, Database Triggers, Database Links & SQL * Loader.
• DBA skills include Creating Table spaces, Files, Partition, Privileges, and Roles, Performing Imports and Exports of Database and also creating internal database structures like tables & columns wif table constraints, views, sequences, materialized views, PL/SQL tables, synonyms, etc.
• OLAP/DSS: Worked extensively for more TEMPthan 15+ years on OLAP tools like Business Objects (5.1.5, XI R1/R2/R3), Web Intelligence, Designer, Developer Suite (Supervisor, Designer, and Info View, Central Management Console, Dashboard Manager), Universe Developer, Supervisor, and Reporting. Managed Universes, generated Dynamic/Static Reports and extended functionality wif Dashboard manager. Customized Reports and generated 2D, PIE, Master/Detail, Slice & Dice, Drill Reports and Speedometer and Metric Reports.
• ETL: Worked Extensively for more TEMPthan 15+ years on ETL methodology for supporting Data Extraction, transformations, loading to process solution in a corporate-wide-ETL Solution used Oracle Warehouse Builder and Informatica & Pervasive Data Integrator suite series.
• Expertise in UNIX/Linux shell scripting (ksh, sh), PowerShell Scripts job scheduling in CRON / Scheduler tools.
• Management: Expertise in designing technical processes and leading Team and working wif analytical teams to gather requirements and create specifications. Specialize in managing relations wif teh smaller vendor. Experienced in task creation and scheduling for ETL projects.
• Expert in agile and waterfall project management methodologies. Able to manage large project teams and non for high-quality deliverables dat meet or exceed timeline and budgetary targets.
• Business strategist; plan and manage multimillion-dollar projects aligning business goals wif technology solutions to drive process improvements, competitive advantage, and bottom-line gains.

TECHNICAL SKILLS

ETL Tools: Informatica 6.x/7.1 Oracle Warehouse Builder10g/11g, Integration Services. Actian(formerly Pervasive) Data integrator 6.0/9.0/10.0 Data stage 7.5.2

OLAP/BI Tools: Business Objects 5.1,XI R1/R2/R3 Dashboard Manager, Cognos 6.5.Reporting Services, Oracle Discoverer

Data Bases/Bridges: Oracle 8i/9i/10g/11g MS SQL Server 2000/ 2005/ 2008/2012/2014, Sybase 11, Tera Data, MS-Access, FoxPro, MySql 4.0, ODBC, JDBC

Data Modeling/Data warehouse Design: ERWIN 7.1, Toad Data Modeler 3.0, MS Visio/ Star Schema/Snow flake Schema

Methodologies: Ralph Kimball & Bill Inmon Approaches, Star & Snowflake Schemas, Agile, Scrum & Waterfall

Programming/ Languages: PL/SQL, UNIX Shell Scripting, ‘C’, Java, JScript, PowerShell Script, VBScript, JScript, JavaScript, PL/me, C++, C, Fortran

Operating Systems: WINDOWS 95/98 ME/XP/2000/7 Server 2003/NT/2008/2012, Oracle Red Hat Linux, Sun Solaris 2.6/2.7/2.8, M.S DOS and all other flavors of UNIX.

Misc. Tools/Packs: DB2 Command Center, TOAD, Harvest, JBuilder, X-Win, HP (Mercury) Quality Center, GNU Debugger, Bugzilla, MS Office Suite

Documentation: High Level & Low-Level documentation of Data Warehouse (Technical & Business) standards, Database and Applications,Fitgap Analysis

PROFESSIONAL EXPERIENCE

Confidential

Technical Manager / ETL Lead

Responsibilities:

• Requirements gathering for business processes, Interfaces, configuration Settings
• Develop, Design, Deploy ETL’s dat include Development plan.
• Managing Teammber members and assign task .
• Interacting wif Project sponsors, Data Architects and Data Modelers for architecting an ETL creations/changes
• Participating in design reviews, code reviews and documenting migration procedures wif Release Notes
• Design and Develop, Deploy ETL/Database process.

Environment: Oracle 10g/11g,SQL Server 2008/2012/2014, Actian (formerly Pervasive) Data connect, Debtmanager/Titanium ORE (Java Based Product ), PL/SQL packages, Microsoft Server 2014/2012/2008, Hyland Onbase,jboss,jsp pages

Confidential

Development Lead (ETL)

Responsibilities:

• Requirements gathering for business processes, Interfaces, configuration Settings
• Develop, Design, Deploy ETL’s dat include Development plan.
• Giving valuable suggestions for ETL related activities/Infrastructure ( include configuration of third party tools)
• Participating in business meetings as a sole technical resource for technical inputs in teh meeting
• Interacting wif Project sponsors, Data Architects and Data Modelers for architecting an ETL creations/changes
• Participating in design reviews, code reviews and documenting migration procedures wif Release Notes
• Design and Develop, Deploy ETL process.

Environment: Oracle 10g/11g,SQL Server 2008/2012/2014, Actian (formerly Pervasive) Data integrator, Debtmanager/Titanium ORE (Java Based Product ), PL/SQL packages, Microsoft Server 2012/2008,Onbase,jboss,jsp pages

Confidential

ETL Lead Developer

Responsibilities:

• Requirements gathering for business processes
• Participating in business meetings as a sole technical resource for technical inputs in teh meeting
• Interacting wif Client, Data Architects and Data Modelers for architecting an ETL creation/change
• Participating in design reviews, code reviews and documenting migration procedures wif Release Notes
• Design and Develop, Deploy more TEMPthan ten data mart ( includes 140 maps ) ETL process and deployment
• Managing ETL Team members and resolve complex ETL/Report technical issue

Environment: SQL Server 2008, Oracle 10g, Pervasive Data integrator, Titanium ORE, PL/SQL package

Confidential

Senior Oracle Developer

Responsibilities:

• ETL Design, Develop, deploy a CORE project of our client business operation. Additionally, identify any business issues wif teh intent of designing an automated systematic solution to teh business problem. Document teh results of teh analysis, proposing alternative solutions.
• Design and Develop ETL scripts/packages using Oracle PL/SQL (Procedure, Views, Packages) to load teh data into teh CORE system.
• Design and Develop Perl/SQL script to extract data from Multiple application to process into CORE system
• Conduct Meeting wif internal customers to review their data report and exceptional processing needs;
• Provide Systems documentation of teh meeting results, identifying all conversion, interface, reporting, extract, and exceptional processing requirements
• Analyze alternative solutions to address all identified requirements.
• Develop and promote methods of increasing development efficiency, product quality, and profitability.
• Provide phone or on-site consultation services to support our clients wif their integration and reporting activities.
• Design/Deploy Based on Demand Item and took over to Production Deployments, followed teh SDLC process.

Environment: Oracle 10g/11g, Oracle PL/SQL (Procedure, Views, Packages), Shell Script, Oracle Grid Control 11g/10g

Confidential

Senior ETL Developer

Responsibilities:

• Requirements gathering for business processes
• Participating in business meetings as a sole technical resource for technical inputs in teh meeting
• Interacting wif Client, Data Architects and Data Modelers for architecting an ETL creation/change
• Participating in design reviews, code reviews and documenting migration procedures wif Release Notes
• Design and Develop, Deploy more TEMPthan ten data mart ( includes 140 maps ) ETL process and deployment

Environment: SQL Server 2008, Oracle 10g, Pervasive Data integrator, Titanium ORE, PL/SQL package

Confidential

Tech Lead /Senior ETL Developer

Responsibilities:

• Requirements gathering for business processes
• Participating in business meetings as a sole technical resource for technical inputs in teh meeting
• Interacting wif Data Architects and Data Modelers for architecting an ETL creation/change
• Participating in design reviews, code reviews and documenting migration procedures wif Release Notes

Environment: Oracle 10g, Erwin 7.1, Pervasive Data integrator, PL/SQL package

Confidential

Tech Lead/Senior ETL Developer

Responsibilities:

• Interacting wif Data Architects and Data Modelers for architecting an ETL change
• Participating in business meetings as a sole technical resource for technical inputs in teh meeting.
• Design/Develop bash scripts, sql scripts, Oracle Warehouse Builder mappings, stored procedures/Packages.
• Indicating areas for performance improvement and designing/altering existing code for implementing teh performance tuning.
• Participating in design reviews, code reviews and documenting migration procedures wif Release Notes

Environment: Oracle 10g, Oracle Warehouse Builder 10g, PL/SQL, Shell Script, SQL Loader

Confidential

Senior ETL Developer

Responsibilities:

• Interacting wif Data Architects and Data Modelers for architecting an ETL change
• Participating in business meetings as a sole technical resource for technical inputs in teh meeting.
• Design/Develop bash scripts, sql scripts, Oracle Warehouse Builder mappings, stored procedures/Packages.
• Indicating areas for performance improvement and designing/altering existing code for implementing teh performance tuning.
• Participating in design reviews, code reviews and documenting migration procedures wif Release Notes

Environment: Oracle 10g, Pervasive Data Integrator, Shell Script, SQL Loader

Confidential

Senior ETL Developer

Responsibilities:

• Interacting wif Data Architects and Data Modelers for architecting an ETL change
• Participating in business meetings as a sole technical resource for technical inputs in teh meeting.
• Design/Develop bash scripts, sql scripts, Oracle Warehouse Builder mappings, stored procedures/Packages.
• Indicating areas for performance improvement and designing/altering existing code for implementing teh performance tuning.
• Participating in design reviews, code reviews and documenting migration procedures wif Release Notes

Environment: Oracle 10g, Oracle Warehouse Builder 10g, PL/SQL, Shell Script, SQL Loader

Confidential

Senior Oracle Developer

Responsibilities:

• Installing and configuring oracle warehouse Builder repository ( Designer and Deployment )
• Creating mapping wif using ETL Functions (Unpivot, Lookup,Deduplicator Transformation and Join, split operator and Sequence and User Defined Transformation)
• Created New Flat files and configured parameters.
• Extracted data from CSV files and populated in to stage table on DWH.
• Resolved many production problems in various situations.
• Involved in developing teh PL/SQL procedures to organize teh data across teh databases.
• Implemented parameters in oracle warehouse builder using pre mapping operator.
• Involved in fine tuning teh SQL and Procedures
• Creation of ETL Processes for teh added new Customer Subject areas, Develop Data Extraction Transformation and Loading Program using integration services.
• Maintain ETL Process & Modification
• Expertise in ETL design, and development by applying business methodology.

Environment: Oracle Warehouse Builder 10g R2, Oracle Reports

Confidential

Data warehouse Analyst

Responsibilities:

• Installing and configuring oracle warehouse Builder repository ( Designer and Deployment )
• Creating mapping wif using ETL Functions (Deduplicator,Matchmerge,Set,Predefined Transformation and Join, split operator and Sequence and Data generator)
• Implemented in SCD 3 and SCD1
• Extracted data from text files and stored as External table and populated in to Data warehouse System.
• Populated Time dimension table and fact table.
• Resolved many production problems in various situations.
• Taken Backup oracle warehouse builder repository.
• Involved in developing teh PL/SQL procedures to organize teh data across teh databases.
• Implemented parameters in oracle warehouse builder using pre mapping operator
• Involved in fine tuning teh SQL and Procedures.
• Populated and maintained Fact and Dimension tables.
• Creation of ETL Processes for teh added new Subject areas, Develop Data Extraction, Transformation and Loading Program using integration services.
• Maintain ETL process And Report Generation & modification.
• Created Universes for report generation using Designer module in Business Objects. As a part of Universe development, created Classes, different kind of objects, cardinalities, Strategies. Resolved teh loops using Aliases and contexts. Check teh Integrity of teh Universes. Export teh Universes to Repository for making available to users
• Created different types of reports like Master/Detail, Cross Tab and Chart. Used Analyzer and Explorer to view reports from different prospect. For this used Slice and Dice and Drill down. Export teh documents to Repository
• Involved in Analysis, Development, Testing and Maintenance and resolved problems during implementation.
• Using Dashboard Manager - Created metrics reports, speedometer reports, metric view reports & web intelligence, standard reports, flat reports, cross tab reports.
• Expertise in data design and modeling, system study, design, and development by applying methodology of dimensional modeling.

Environment: BOE XI Dashboard Manager, Administration Console, Oracle Warehouse Builder 10g

Confidential

Tech Lead /ETL Developer

Responsibilities:

• Designed Dimensional model using ER-win tool.
• Created Universes for report generation using Designer module in Business Objects. As a part of Universe development, created Classes, different kind of objects, cardinalities, Strategies. Resolved teh loops using Aliases and contexts. Check teh Integrity of teh Universes. Export teh Universes to Repository for making available to users
• Created different types of reports like Master/Detail, Cross Tab and Chart. Used Analyzer and Explorer to view reports from different prospect. For this used Slice and Dice and Drill down. Export teh documents to Repository.
• Involved in Analysis, Development, Testing and Maintenance and resolved problems during implementation.
• Using Dashboard Manager - Created metrics reports, speedometer reports, metric view reports & web intelligence, standard reports, flat reports, cross tab reports.
• Expertise in data design and modeling, system study, design, and development by applying methodology of dimensional modeling.
• Used Oracle Warehouse Builder to Extract data from different sources (Oracle, Text files) and load to teh target database
• Populated and maintained Fact and Dimension tables.
• Imported various Sources and Targets, created Transformations using Oracle Warehouse Builder.
• Designed and developed Mappings and Sessions based on requirements and business rules to load data from source flat files and Relational target tables. Used transformations like Lookups, Aggregator, Expression, Update, split and Sequence generator.
• Performance tuning at source, transformation, target levels.
• Implemented Error handling using pre-mapping, post-mapping stored procedure transformation.
• Used Oracle Warehouse Builder to create, schedule, monitor and send teh error messages in case of process failure.
• Unit testing for data errors based on timestamp, and checked counts against daily summarized data and weekly summarized data and documented technical metadata.
• Taken Backup of OWB Repository backup & restore.

Environment: Business Objects XI - Dashboard manager (Performance Management), Business Object info view, Oracle Warehouse Builder 10g, Oracle 10g Data Mining Suite, Oracle 9i.