SUMMARY:

• IT Professional with 11 years of experience in Oracle ODI, Pl/Sql, DWH as Sr. ODI Consultant, Tech Lead.
• 11+ yrs years of total technical experience with 7+ yrs of exp in Oracle ODI, Datawarehousing, and ETL tools including Informatica, SQL, PL/SQL, UNIX in Telecommunication, Retail & Consumer, Pharmaceutical Research & Development, Industries.
• Strong experience in Data warehousing concepts. Good exposure on logical and physical Data Modeling using normalization Techniques,
• Expertise with all ODI (11g & 12c) tools - Topology, Security Manager, Designer and Operator. Worked with knowledge modules like LKM, IKM, CKM and implemented simple and consistent CDC though JKM.
• Exposure to OBIEE environements and handson experience in various offerings in OBIEE. Experienced in gathering reporting and analysis requirements, documenting the report specifications, implementing the metadata layers including Physical, Business Model and Mapping, and Presentation layer.
• Good Knowledge on Standalone Agent and J2EE Agent for scheduling the Interface/mapping execution.
• Expertise in Data Warehouse/Data mart, ODS, OLTP implementations along with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Experience in all phases of Data warehouse development from requirements gathering to develop the code, Unit Testing and Documenting.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Experience in the Integration of large volume of data from multiple Oracle 11g data sources, flat files, CSV, XML,Oracle, SQL Server into the staging area, ODS, Data Warehouse and Data Mart.
• Strong understanding of Dimensional data Modeling in data warehouse environment such as star schema and snow flake schema.
• Experienced in development of Physical and Logical datamodels using ERWIN.
• Hands on experience in developing SQL, PL/SQL, Stored Procedure and UNIX Scripting.
• Posses hands on experience in Batch systems scheduling and processing using CA Workload automation, Control-M and Tivoli Workload Scheduler.
• Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.
• Trained in creating Data synchronization, Data replication tasks using Informatica, relational databse and flat files.
• Trained in Big data platforms like Hadoop, HDFS, Hive, Pig, Hbase.
• Experienced in software development life cycle (SDLC), Agile methodologies.
• Experience in leading and managing technical teams. Handled multiple roles - Delivery leader, Technical team leader, Senior Developer etc.
• Highly productive, tech-savvy, result oriented with strong analytical and problem solving skills and passion for learning newer technologies.

TECHNICAL SKILLS:

Database: Oracle, SQL Server, DB2.

ETL Tool: ODI, Informatica 9.x

Languages: Unix shell scripting, SQL, PL/SQL, Java, C, C++.

Automation Tool: Tivoli TWS, Control M, Unix Cron and Windows schedulersOther Tools: HP ALM, MQC, HPSD, Remedy, GRS, Service-now, QMF, Eclipse

Data Modeling Tool: Erwin, Visio, Toad, Oracle Sql Developer

PROFESSIONAL EXPERIENCE:

Confidential, Raritan, NJ

Sr. ETL Developer

Tools: ODI, Oracle Pl/Sql, Unix, Toad, Visio

Responsibilities:

• Responsible for requirement analysis along with the Vendor, business analysts and other Key stakeholders.
• Leading the technical team by working closely with business analysts to understand technical requirements and conducting POC’s, and helping in prepairing functional specification document.
• Prepairing the technical design document for new requirements.
• Installed ODI. Set up ODI connection with Oracle DB and flat files.
• Set up the Topology including physical architecture, logical architecture and context.
• Performed scoping analysis for source data and map to target DB structure in pharmaceutical safety database standard architecture.
• Worked closely with the Project Manager and Data Architect. Assisted Data Architect in design by doing source data analysis, rectifying the requirement documents, creating source to target mappings.
• Developed interfaces to load the data from source SCEPTRE DB to target Argus Datawarehouse.
• Did SQL and PL/SQL programming for ODI and oracle.Created PL/SQL stored procedures, functions and triggers.
• Developed interfaces for loading the lookup and transactional data.
• Created ODI packages, scenarios using interfaces, variables, procedure
• Used ODI commands like ODIFile Move, odiFileAppend, odiFilecopy etc
• Implemented logic for incremental loading at target DB using simple and consistent CDC and utlized the associated knowledge modules.
• Performance tuned the ODI interfaces.
• Performed unit and integration testing. Created various test scenarios to test the interface and data consistencies.
• Built the data model using Toad data modeller to design stage and multidimensional tables.
• Develop mappings following SCD type 1&2 design patterns and user defined function for data cleanup and manipulation for data validation.
• Implemented code using data masking,normalizer,dynamic lookup,external stored procedure transformations etc.
• Coordinating with offshore team members, code review and identifying bottlenecks for performance tuning of the mappings and suggesting best approach.
• Mentoring junior team members with implementation and development.
• Designed the automation using standalone and J2EE agents to schedule the entire business process.
• Release planning and conducting deployments.

Confidential, Raritan, NJ

Sr. ETL Developer

Tools: Oracle ODI, Oracle Pl/sql, Toad, Visio, Unix, ERWIN

• Responsible for requirememt analysis with client and business analyst.
• Preparing test data and developing high level design on VISIO to facilitate discussion along with other teams.
• Responsible for building the development plan by working closely with project manager.
• Coordinating activities from onsite, and helping business analyst to build the functional requirement specification document.
• Performimg the imapact analysis on the existing OLTP application for the new ETL to be developed.
• Analysing the source OLTP application and building the data model for several staging areas and ODS using ERWIN.
• Responsible for understanding the requirement and preparing the archietecture and design document for the new interface.
• Created ODI design documents and mappings. Used these design documents in development of ODI interfaces/packages.
• Performance tuned the interfaces, queries through use of indexes, ranks, Oracle hints, exchange partitions etc.
• Wrote unit test cases, test scenarios, unit test documents and also verified the test scenarios of the QA team. Unit tested for all the possible test scenarios.
• Resposible for implementing the change data capture to populate the staging area.
• Responsible for developing database views and stored procedure on staging area to clean up source data as according to the requirement.
• Developing mataerialize view to maintain the data quality and loading data into ODS.
• Responsible for development of the mapping, using design patterns like scd 1, and scd 2 where applicable.
• Designing the archiving strategy for the intermediate staging tables on the OLTP system.
• Did SQL and PL/SQL programming for ODI and oracle. Worked extensively with ODI Designer, operator and metadata Navigator.
• Involved in rotational production support.Leading the offshore development team and actively involed in development for several componenents.
• Working closely with project manager to update the development status during the clint meetings.

Confidential, Raritan, NJ

Onsite team lead

Tools: Oracle ODI, Oracle pl/sql, Toad, Unix

• Design and development of ODI projects as per business requirement.
• Effort estimation, impact analysis, design and development of new system change request.
• Responsible for providing ODI design solution for new business requirement.
• Responsible for prepairing the technical design document for new requirements.
• Responsible for development of the ODI mappings and workflows.
• Conforming to the SLAs mentioned in the SOW for the Production tickets and meet the timeline for the Discretionary works.
• ODI Code standardization and following existing process structure.
• Point of contact for any ODI ETL related issues.
• Perform root cause analysis for critical and recurring incidents.
• Writing of the emergency change request document and change control plan according to the Confidential standards.
• Responsible for the initial phase planning, designing of the complete development process.
• Sole responsible for developing database objects like triggers, views, procedures etc to migrate data from SCEPTRE source system to staging tables.
• Sole responsible for development of the end to end mapping for individual staging tables using transformation like, EXP, lookup, Router, etc to implement the business logic.
• Sole resposible for preparation and execution of several Database IQ’s (Installation Qualification), migrating the ODI code in several environments and monitoring the overall process
• Worked on performance tuning of ODI interface.
• Production support on DB related issues, updates and changes.

Confidential, Mounds View, MN.

Team Lead

Tools: Oracle ODI, Tivoli Workload Scheduler.

• Did extensive data analysis using source data and UI specifications to understand the data, to assist data architech in designing the databases, to identify bad data, to help Business in improving and redefining the requirements.
• Involved in DataMart and Application Database Design meetings. Created Technical design documents.
• Created ODI design documents. Used these design documents in development of ODI interfaces/packages.
• Schedule and monitor ETL jobs in Tivoli TWS and analyse job failures and remediations for daily data loads.
• Participated in code reviews. Did code promotions from dev to test, staging and production environment using ODI.
• Wrote unit test cases, test scenarios, unit test documents and also verified the test scenarios of the QA team. Unit tested for all the possible test scenarios.
• Helped QA team in writing the appropriate test scenarios.
• Did error analysis for continued improvement of the system by catching data anomalies and code issues.
• Planning and prioritizing the tasks to meet the deliverable deadlines.
• Participated in all the phases of project - development, testing, deployment and support.
• Used Oracle analytic functions, global temporary tables, etc
• Involved in release meetings and created release notes.
• Interacted with BI team during design and development of facts and dimensions to accommodate all the reporting requirements.
• Resolve production support tickets for the application data interface.

Confidential, BaskingRidge, NJ.

Tech Lead

Tools: Oracle MDM, DWH ETL, Unix, Oracle PLSQL

• Responsible for technical consultation for Enterprise applications and acquire KT from Nortel.
• Wrote UNIX shell scripts and automated the ETL processes using UNIX shell scripting.
• Prepared Application Information Document (AID) for support model and delivered to Client.
• Prepared migration task lists to make the applications functional in cloned environment.
• Executed tasks relating to UNIX/Perl Script changes, Job Scheduling(Cron, Windows batch, Sql server DTS packages), SMTP email configurations and various in and out interfaces which exchange data using FTP, SFTP, Oracle replication, ODBC etc. to make the IT applications live.
• Responsible for managing scope, planning, tracking of deliverables.
• Guided and helped team for internal KT, task distribution, Client communications.
• Prepared test plan for application readiness and data interface communications, uploaded them into Mercury Quality Center, Reviewed, executed test plan, tracked and fixed defects.
• Responsible for Hypercare support of cloned applications and warm handover to support team.

Confidential, BaskingRidge, NJ.

Sr System Engineer

Tools: DWH, C, PRO*C, Unix, Oracle PLSQL

• Developed C/Pro C programs and UNIX scripts for EDI application to remove harbinger database dependency. Supported Java based Gentran Integration Suite for Avaya’s EDI operation.
• Responsible for support and enhancement of various business applications like EDI, XMS, SAPHR and their Interfaces with Data warehouse.
• Investigated and analyzed the problem situations to prevent outages and made root cause analysis.
• Developed scripts to automate SAPHR jobs, analyze various scripts for enhancing product performance.
• Interacted with client for new requirements, translated functional to technical requirements and prepared specifications, analyzed, developed requirements and solved support tickets.

Confidential, BaskingRidge, NJ.

Sr System Engineer

Tools: UNIX/Perl scripting, Oracle PL/SQL, C++

• Developed post release software patches for customer site issues strictly adhering TL9K standards and SDLC framework
• Developed scripts and monitored Oracle Replication for Data Server, monitored capture, propagate and apply processes to ensure synchronization of DBs.
• Investigated HLR, Provisioning server, Data Server field issues as reported by customers at the site, Taking ownership of cases from investigation, issue reproduction, design, test and delivery.
• Developed scripts to perform debugging tasks for day to day work and created reusable components.
• Interacted with the customer for issue assessment and recovery actions.
• Knowledge sharing in team for work item delegation and for new joiners.

Confidential, BaskingRidge, NJ.

Developer

Tools: UNIX scripting, C++, OOP

• Worked as a developer in various features e.g.: LBS Multi MPC Support, MEID Enhancement for E911 Phase-II, CRBT Support for Flexible Alerting, Tracking Call Drops Due to Carrier Failure, SMS Origination Authentication and Implicit Registration etc.
• Took ownership of requirement specifications; develop code, test, document and deliver.
• Updated the progress status, impacts, issues, concerns to project manager.
• Participated in team meetings, reviews, trainings and provide consultation to team.
• Mentored new joiners and help them to demonstrate expertise and deliver solution to client
• Took ownership of Change Requests from investigation, issue reproduction, bug fix, test and delivery.