SUMMARY:

• Over 10 years of experience in data analysis, modeling, design, and development of the databases.
• Highly experienced in scalable parallel processing infrastructure and worked with Oracle Data Integrator 11g/10g, OWB 11g/10g
• Extensively worked on procedures for data movement in data warehousing using ODI. This includes specification of data cleansing and design of staging area.
• Worked on Staging, Transformation, Pre Loading and Loading of data from multiple sources into Data Warehouse
• Managed Functional setup data configuration and load plan administration
• Excellent knowledge and experience in data warehouse development life cycle, dimensional modeling, repository management and administration, implementation of STAR and Snowflake schemas
• Identified and tracked the slowly changing dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Analyzed the quality of data to determine its consistency and reliability, Documented detailed findings together with recommendations for standardizations and reconstructions using Oracle Data Integrator
• Experienced with developing ELT design documentation, performing impact analysis, data profiling and data analysis
• Experience working with Oracle Data Integrator (ODI) topology manager, designer, Operator, console, and troubleshooting issues
• Fine - tuned the performance of the various ELT processes
• Experienced in integration of various data sources (DB2-UDB, SQL Server, Teradata, Sybase, and Oracle) into data staging area.
• Experience working with Oracle Business Intelligence Enterprise Edition (OBIEE) RPD, reports, dashboards and troubleshooting issues.
• Extensive working experience in maintenance and Production support of different Applications
• Experienced in shell scripting to automate the batch, file manipulation and text processing
• Expertise on oracle development tool set including PL/SQL, SQL * plus, SQL loader, TOAD
• Experience in writing, testing and implementations of Triggers, Procedures and functions using PL/SQL.
• Excellent team player with good communication, interpersonal & analytical skills. Problem-solving and trouble-shooting capabilities, Quick Learner, highly motivated, result oriented and an enthusiastic.
• Performed Unit testing, Volume testing and performance testing.

TECHNICAL SKILLS:

Tools: Oracle data Integrator 12.1.3/11.1.1.7/11.1.1.6/10.1.3.5, Oracle Warehouse Builder 11g/10gr2/10gr1/9.2 (OWB)

RDBMS: Netezza5.1/6.0,Oracle 11g/10g/9i, SQLServer 2000/2005/2008, Teradata v2r6/v2r5/v2r4

Reporting Tools: OBIEE 11g, Business Objects XI r3, XI r2/6.5, Crystal Reports XI/10/8.5

Data warehousing: Data marts, OLTP, OLAP, Normalization, Dimensional Modeling, facts, Dimensions star schema and snow flake schema

Data Modeling: Erwin 4.1/3.5, ER studio 3.5, MS Visio 2003

Languages: MS Visual C, MS Visual C++, UNIX Shell Scripting, SQL, PL/SQL, Visual Basic

Operating System: UNIX, AIX, Windows NT/95/98/2000/XP

Database Tool: PL/ SQL, TOAD, SQL Loader

Version Control: Microsoft TFS 2010, Rational Team Concert, PVCS, CVS

PROFESSIONAL EXPERIENCE

Confidential, CT

Senior ODI Developer

Responsibilities:

• Developed Design Documents, Process Flow Documents, Quality Testing Documents for building various process
• Enabled Functional Setup Manager (FSM) to manage and perform functional configuration tasks for Offerings 'Configure Initial Extract Date', and 'Configure Global Currencies'
• Worked on various user requirements with both Agile and Waterfall Methodologies.
• Developed several advanced queries for reconciliation process in the development and test environment for performing the Maintenance releases and Defect fixes.
• Create Production support documentation for overnight batch support purposes.
• Setup 24×7 proactive Batch monitoring which resulted in 60% decrease of downtime
• Create Automated scripts with Alarms for preventive maintenance activities
• Worked on setting up disaster recovery and supported in testing all the disaster recovery activities
• Worked on creating the offshore module by managed consistent performance and quality
• Developed processes with easy restart abilities and maintenance.
• Worked on Data Architect to modify the existing data models and perform reverse engineering on the models
• Create interfaces using Knowledge modules like IKM Oracle Incremental update for Securities & Portfolio information, IKM Oracle Control, CKM Oracle.
• Created OdiInvokeWebService for SOA with BAMUtiltyService/BAMMonitoringWebService (WSDL) for Audit framework.
• Involved with OBIEE reporting team in migrating OBIEE rpd and catalogs from one environment to another.
• Worked on building automated flows for successful nightly batch involving in building Enterprise datawarehouse from various dependent source systems
• Extracted data from various sources Legacy and flat files including XML and loaded into target Oracle system
• Managed Enterprise Manager (EM) for deployments and servers to monitor.
• Worked on Comprehensive Capital Analysis and Review (CCAR) actives in building advanced calculation engines to load projection data and analyzing the market values and book values as part of Federal audit process.

Environment: ODI 12c, OWB 11.2.0.4, Oracle 11g, SQL Developer, Linux, MS Office 2013, CA Autosys 2015, Red Hat Linux 6.5, Beyond Compare

Confidential, IL

ODI Consultant

Responsibilities:

• Worked on creating the design documents and creating the process for Anti Money Laundering Project.
• Migrated large volumes of data from several source systems of Confidential to Oracle Staging table in the Target databases.
• Understanding the technical process involved in populating the target database from several source systems.
• Developed SQL queries to extract data from different tables and different databases.
• Created models, interfaces, packages, variables, procedures in ODI designer.
• Involved in Analysis, requirements gathering, functional/technical specification, and development, deploying and testing.
• Some of the knowledge modules used are LKM (file to oracle, oracle to oracle, Sql server to oracle), IKM (oracle control append, oracle incremental update, oracle SCD), CKM (CKM Oracle)
• Used Control-M for automation of scheduling for UNIX shell script jobs on daily basis and proper dependencies and tasks.
• Created procedures, global variables and global user functions
• Developed Ad-hoc and standard Reports/Dashboards and contextual navigation, business rules with user identity.
• Responsible for unit, system and integration testing. Development test scripts, test plan and test data. Participated in UAT (User Acceptance Testing).
• Developed advanced queries and advanced stored procedures with SQL Server web clusters to populate the data from multiple databases.
• Worked on analyzing data profiling, data mining, data cleansing, data content, scrubbing data, and translating data via rules from one database to another.
• Provided Defect resolution process documentation for resolving the defects in the developed components and reconciliation processes to validate the rejected records in the process.
• Worked on providing the test files for the Application Database vendor as per business requirements after Data Validation, Reconciliation and extraction process.
• Defined production support document with recovery process.

Environment: ODI 11.1.1.6, OBIEE 11.1.1.5, Oracle 10g, MS Office, HP Quality Center, Control-M, MS SQL Server 2008/2005, IBM Db2 9.7, Ultra Compare, MS Office suite 2008

Confidential, IL

Senior Datawarehouse Developer

Responsibilities:

• Prepared technical design/specifications for Data Extraction, Data Transformation, Data Cleansing and Data Loading
• Worked data tracebility, data models, design documents and Technical specification documents and Analysis related to the STAR Project.
• Involved in evaluating the scope of application database, defining data relationship within and between different groups of data.
• Developed SQL queries to extract data from different tables and different databases.
• Administered all the Database duties in the development and test environment for performing the Database changes for Maintenance releases and Defect fixes.
• Maintaining system interfaces, extracting, translating and loading data between internal applications and externally to the Claim and benefit information.
• Worked on unit, system and integration testing. Development test scripts, test plan and test data. Participated in UAT (User Acceptance Testing).
• Developed advanced stored procedures with SQL Server web clusters to populate the data from multiple databases.
• Provided level 2 production support for the stored procedures and ELT related process involved as part of STAR Project and others.
• Defined production support document with recovery process.
• Involved in the preparation of nightly batch process documentation by following the business rule, procedures and naming conventions. Also, created major development, deployment and support documentation.

Environment: ASG Zena, Serna Dimensions, Ultra Compare, MS Office suite 2010

Confidential, IL

Sr. Application Developer

Responsibilities:

• Actively involved in the paymentnet4 project database Migration, ELT Process, implementation and production support.
• Developed design documentation needed for developing components based on the business requirements and existing database models for migrating the database.
• Worked majorly on importing metadata from MS SQL server database and migrating to Oracle 10g involving various complex business logics satisfying the customer requirements.
• Participated majorly in JAD sessions, requirements gathering, design meeting and code reviews.
• Extracting, cleansing, transforming, integrating and loading data into data warehouse using OBW
• Worked on Teradata as a referential database to load in to the oracle datawarehouse for scheduling process.
• Worked with the production support team to debug and modify the components related to audit report tables and shadow tables.
• Worked extensively on LKM, IKM, and CKM for running the interfaces and also some KM’s have been customized for the performance wise.
• Wrote some home grown function for date, strings, conditional, numeric, and hash.
• Configured flat files and oracle Data Servers in Topology Manager.
• Worked extensively on IBM Rational Clearcase tool, Rational Clear Quest and HP quality center to participate in the water fall methodology model.
• Designing and Developing PL/SQL Procedures, functions, and packages to create custom tables.
• Worked on Audit report tables and shadow tables to generate adhoc output files based on the customer needs.
• Developed nightly batch to run work flows in by taking into consideration the interdependencies and business requirements.
• Extensively used control-M for automation of scheduling for UNIX shell script jobs on daily, weekly monthly basis with proper dependencies

Environment: ODI 10.1.3.5, OWB 10g, Oracle10g, MS SQL Server 2005, Teradata, SQL Developer, Quality Center, UNIX, Rational Clear Quest, Rational Clear Case, Erwin 4.0

Confidential, MN

Senior Developer

Responsibilities:

• Involved in designing, developing and testing of the strategy to populate the banking data from various source systems (Flat files, DB2, COBOL copybooks and Oracle) feeds using Oracle Data Integrator, PL/SQL and Unix Shell scripts
• Imported various Application Sources (Database tables, Flat files, Cobol files, XML files, Etc)
• Involved in transforming various operational sources like Oracle, Teradata, DB2, SQL Server 2000, Flat files into a staging area.
• Parallel Design and Development on Interface Development based on the Source of the Data for Multiple Work Repository (Development).
• Providing support on Test and Production environment.
• Designed the ETL process flow and framework for loading the data using ODI
• Transformation of inconsistent records into consistent formats to improve the performance.
• Multi-data warehouse environment with repositories residing on UDB and DB2 RDBMs that run respectively on AIX and Z/OS Operating Systems.
• Used SQL Loader to load the data into Oracle tables.
• Created UNIX shell scripts using K-shell for calling the stored procedures for truncating the tables and calling the SQL Loader for loading the data into the target staging area and loading the stats into the stats tables.
• Involved in the testing of the various components developed and maintaining the test log.

Environment: Oracle 10g, SQL, PL/SQL, UNIX, SQL Server 2005, Erwin 4.0, ETL, DB2 9.1, Sun Solaris, Toad 9.1

Confidential, CT

Sr. Data Warehouse Developer

Responsibilities:

• Involved in requirement gathering, analysis and study of existing systems.
• Developed UNIX shell scripts for FTP source files maintenance
• SQL and PL/SQL wrote backend store procedures, functions and triggers.
• Maintaining system interfaces, extracting, translating and loading data between internal applications and externally to the shareholding and banking industry.
• Excellent experience working in DB2, Teradata and SQL Server databases.
• Experienced in transforming complex data files binding to the business requirements.
• Extracted data from oracle, DB2 databases, and transformed data and loaded into Oracle data warehouse.
• Worked extensively on LKM, IKM, and CKM for running the interfaces and also some KM’s have been customized for the performance wise.
• Wrote some home grown function for date, strings, conditional, numeric, and hash.
• Worked on ODI to Oracle table for insert/update strategy and for updating slowly changing dimensions
• Worked on Automating and scheduling tasks and report distribution
• Developed UNIX shell scripts to automate the Data Load processes to the target Data warehouse.

Environment: ODI 10.1.3.5, OWB 10g, Oracle10g, 9i, PL/SQL, Teradata, Business Objects XI r2, OLAP, Erwin5.5, SQL plus, SQL*Loader, TOAD, Sun Solaris 2.8.

Confidential, CT

Data Warehouse Consultant

Responsibilities:

• Extensively involved in determining the data needed to address business user’s analytical requirements and design data models to support these analysis.
• Used DataStage Manager to define Table definitions, Custom Routines and Custom Transformations and Export and import the Datastage jobs
• Designing and developing web user interfaces in Visual Basic.NET.
• Designed Parallel jobs for loading 8 Tera bytes of history data.
• Extensively worked with Parallel Extender for parallel processing to improve job performance while working with bulk data sources
• Worked extensively on different types of stages like Sequential file, ODBC, Hashed File, Aggregator, ORABulk, BCPLOAD, Transformer, Merge, Sort for developing jobs
• Extensively used Link Partitioner and Link collector in improving the performance.
• Extensively worked on the source data from Flat file source systems, Oracle source systems, and DB2 source systems.
• Designed jobs using the stages like Sequential file, Oracle enterprise, Teradata Enterprise, Transformer, Lookup, Join and Modify.
• Developed the data warehouse repository using DataStage Manager by importing the source and target database schemas
• Extensively worked on DataStage Job Sequencer to Schedule Jobs to run jobs in Sequence.
• Extensively used Teradata Load and Unload utilities such as Multi Load, Fast Export and Bulk Load stages in Jobs for loading/extracting huge data volumes
• Used the DataStage Director extensively to run, schedule, monitor, debug, Trouble shoot and test the application on development, and to obtain the performance statistics
• Involved in performance tuning of the ETL process and performed the data warehouse testing
• Designed the complete Decision Support System using Business objects by creating different types of reports for trend analysis using filters, conditions and calculations
• Worked extensively on SIEBEL CRM application tool for integrating telesales, account, and sales management by optimizing information shared by multiple employees, and streamlining existing processes like retailing.
• Used Unix shell scripts to run Datastage jobs and load data in to Database
• Extensively worked with Quality stage to standardize data by trimming the spaces, removing nonprinting characters, incorrect spellings using Transfer, Parse, collapse, Select, Unijoin and Build stages.
• Worked extensively on the testing the modules and rectifying the missing link in the different modules.

Environment: IBM Web Sphere Datastage 7.0, Erwin 4.0, Oracle 9i, PL/SQL, OLAP, MS SQL-Server 2000, SQL*Loader, Oracle Siebel CRM 7.7, Teradata, Sun Solaris 8

Confidential, PA

ETL Developer

Responsibilities:

• Actively involved in gathering requirements from the end users.
• Developed several Parallel jobs to improve performance by reducing the runtime for several jobs.
• Designed, developed and tested the Data stage jobs using Designer and director based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Analysed COBOL Copybooks for Source Dictionary.
• The data model is in Star-Schema, extensively used Erwin for data modeling.
• Expert in dimensional modeling, Star Schema modeling, Snowflake modeling, fact and dimension table design, physical and logical Data modeling using Erwin.
• Extensively worked with Datastage Parallel Extender for Parallel Processing to improve job performance while working with bulk data sources.
• Implemented round robin, Sort & Merge, Hash partitions for parallel processing.
• Edited Configuration file for configuring multi node for data stage Parallel edition implementation.
• Used stages like Transformer, sequential, Oracle, Aggregator, Remove Duplicates, Sort, Join, Merge, Lookup, Data Set, Funnel, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key.
• Scheduled, viewed and the edited the logs by using Director. Also monitored the results in Director.
• Did performance tuning at source, transformations, target and administrator.
• Used command line prompts and UNIX scripts for automation.
• Implemented data stage for integrating real time middleware messages with XML files
• Involved in creating different projects using administrator.
• Experienced in writing utilities (Which call the jobs from transformer stage) and custom programs (Used for complex logic and called from transformer).
• Importing/exporting the data stage projects and taking the backup.
• Written User defined SQL queries and run the stored procedures in after SQL of source and Target.
• Wrote PL/SQL stored procedures using Toad.

Environment: ETL, Ascential Datastage 7.0/PX/EE, TOAD 7.1, IIS Web Server, COBOL, SQL, PL/SQL, Oracle 9.2, ERwin, MQ Series, Business Objects

Confidential

Sr. Software Engineer

Responsibilities:

• Planned the application schema, designed database objects like Tables, Indexes, views, sequences and integrity constraints using technical documents.
• Worked closely with system administration during software installation and upgrades
• Involved in analysis, design, coding, testing, data conversion and implementation
• Used complex SQL queries to the query the database
• Used bulk collect, collection objects and ref cursor
• Used hints for query optimization
• Generated summary and detailed reports
• Rebuild the indexes for better performance
• Resolved the bottlenecks in the performance issues and helped in tuning the application
• Pinned the frequently used packages and procedures in the memory

Environment: Oracle 8i, Reports 2.x/3.0, PL/SQL, SQL, MS Office, Windo