PROFESSIONAL SUMMARY:

• 17+ years in IT industry with over 1 5 + 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 1 5 + 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 with 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/20 /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 with 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 with table constraints, views, sequences, materialized views, PL/SQL tables, synonyms, etc.
• OLAP/DSS: Worked extensively for more than 1 5 + 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 with Dashboard manager. Customized Reports and generated 2D, PIE, Master/Detail, Slice & Dice, Drill Reports and Speedometer and Metric Reports .
• ETL: Worked Extensively for more than 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 with analytical teams to gather requirements and create specifications. Specialize in managing relations with the 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 known for high-quality deliverables that meet or exceed timeline and budgetary targets.
• Business strategist; plan and manage multimillion-dollar projects aligning business goals with 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/I, 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 that include Development plan.
• Managing Teammber members and assign task .
• Interacting with Project sponsors, Data Architects and Data Modelers for architecting an ETL creations/changes
• Participating in design reviews, code reviews and documenting migration procedures with 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 that 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 the meeting
• Interacting with Project sponsors, Data Architects and Data Modelers for architecting an ETL creations/changes
• Participating in design reviews, code reviews and documenting migration procedures with 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 the meeting
• Interacting with Client, Data Architects and Data Modelers for architecting an ETL creation/change
• Participating in design reviews, code reviews and documenting migration procedures with Release Notes
• Design and Develop, Deploy more than 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 with the intent of designing an automated systematic solution to the business problem. Document the results of the analysis, proposing alternative solutions.
• Design and Develop ETL scripts/packages using Oracle PL/SQL (Procedure, Views, Packages) to load the data into the CORE system.
• Design and Develop Perl/SQL script to extract data from Multiple application to process into CORE system
• Conduct Meeting with internal customers to review their data report and exceptional processing needs;
• Provide Systems documentation of the 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 with their integration and reporting activities.
• Design/Deploy Based on Demand Item and took over to Production Deployments, followed the 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 the meeting
• Interacting with Client, Data Architects and Data Modelers for architecting an ETL creation/change
• Participating in design reviews, code reviews and documenting migration procedures with Release Notes
• Design and Develop, Deploy more than 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 the meeting
• Interacting with Data Architects and Data Modelers for architecting an ETL creation/change
• Participating in design reviews, code reviews and documenting migration procedures with Release Notes

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

Confidential

Tech Lead/Senior ETL Developer

Responsibilities:

• Interacting with Data Architects and Data Modelers for architecting an ETL change
• Participating in business meetings as a sole technical resource for technical inputs in the 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 the performance tuning.
• Participating in design reviews, code reviews and documenting migration procedures with Release Notes

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

Confidential

Senior ETL Developer

Responsibilities:

• Interacting with Data Architects and Data Modelers for architecting an ETL change
• Participating in business meetings as a sole technical resource for technical inputs in the 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 the performance tuning.
• Participating in design reviews, code reviews and documenting migration procedures with Release Notes

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

Confidential

Senior ETL Developer

Responsibilities:

• Interacting with Data Architects and Data Modelers for architecting an ETL change
• Participating in business meetings as a sole technical resource for technical inputs in the 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 the performance tuning.
• Participating in design reviews, code reviews and documenting migration procedures with 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 with 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 the PL/SQL procedures to organize the data across the databases.
• Implemented parameters in oracle warehouse builder using pre mapping operator.
• Involved in fine tuning the SQL and Procedures
• Creation of ETL Processes for the 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 with 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 the PL/SQL procedures to organize the data across the databases.
• Implemented parameters in oracle warehouse builder using pre mapping operator
• Involved in fine tuning the SQL and Procedures.
• Populated and maintained Fact and Dimension tables.
• Creation of ETL Processes for the 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 the loops using Aliases and contexts. Check the Integrity of the Universes. Export the 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 the 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