SUMMARY

• Over 13+ years of experience in the complete Data warehouse life cycle involving Analysis, Design, Development, Testing and maintenance of Software applications and implementing Data Warehouse applications and Data integration using ETL.
• Strong Knowledge of all phases of Software Development Life Cycle and have worked in large scale projects with incremental deliverables.
• Experience in OLTP Modelling (2NF, 3NF) and OLAP Dimensional Modelling (Star and Snow Flake) using Erwin (conceptual, logical and physical data models).
• Extensive knowledge in Architecture/Design of Extract, Transform, Load environment using Informatica Power Center.
• Experience in implementing the complex business rules by creating Informatica transformations, re - usable transformations (Lookups - Connected & Unconnected, Joiner, Union, Sorter, Aggregator, Rank, Normalizer, Filter, Router and Update Strategy) and developing complex Mappings & Mapplets.
• Extensively worked on Slowly Changing Dimensions and setting up Change Data Capture (CDC) mechanisms.
• Experience in Integration of various data sources like SQL Server, Oracle, Sybase, ODBC connectors & Flat Files.
• Expertise in Debugging and Performance tuning of Informatica mappings and sessions & SQL stored procedures.
• Experience in Identifying and Resolving ETL production issues.
• Experience in Maintenance, Enhancements, Performance tuning of ETL Mappings.
• Experience with relational databases such as Oracle 9i/10g, SQL Server, Sybase, MS Access.
• Strong skills in SQL, PL/SQL packages, functions, stored procedures & triggers.
• Experience in tuning and scaling the procedures for better performance by running explain plan and using different approaches like hint and bulk load.
• Designed data model for the data warehouse, business intelligence application.
• Experience with Database SQL tuning and query optimization tools like Explain Plan.
• Experience in External table concepts, SQL*Loader & UTL File concepts & BCP concepts.
• Hands on experience in UNIX shell scripting.
• Experience in using the Informatica command line utility ‘pmcmd’ to schedule and control sessions and batches.
• Experience in working with various scheduling tools (Control M & CA Autosys).
• Experience in OBIEE tool to build Data model based on business requirements and generating reports to business / IT Customers.
• Documentation of projects for Functional Requirement Specifications (FRS), Use case Specifications, ER-Diagrams, Test Plans, and Test Scripts & Test Cases.
• Team Player; Excellent Interpersonal skills; Ability to work effectively with multiple stakeholders in a project

TECHNICAL SKILLS

Operating Systems: Windows NT, 2000, XP, UNIX

Programming Languages: PL/SQL, Shell Scripting

Databases: Oracle 11g, postgres

Tools: Pl/sql developer, Filezilla, Postico, iTERM Toad 11.6, SQL Navigator, Oracle Developer, OBIEE, Informatica (Power Center 9.1, 8.6.1, 8.1)

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Senior Database Developer

Responsibilities:

• Map data elements from dealer database to DDSW data model.
• Replicate the data from dealer databases (DB2/AS400) into Postgres databases.
• Create complex SQL in Postgres using analytical functions to extract the data from dealer. databases, transform the data and metadata in streamset and load into Elastic Search
• Performance tune long running SQLs in Postgres by analyzing the SQL using explain.
• Create indexes and change join conditions as required to optimize the plan
• Create ETL jobs in streamsets to load data according to schema target setup in Kafka and Elastic Search.
• Create procedures, functions, packages, views and triggers for XAPT dealers to load data DDSW from dealer database.
• Used TOAD/SQL Developer for day to day operations.
• Developed UNIX scripting for Airflow job scheduling to load data from Attinuity to Oracle database.
• Performance tuning of invoice and workorder domain with COMPLEX VIEW creation and Indexing .
• Kanban board for tracking user stories.
• GIT for code checking and promotion for higher environment.

Environment: SQL, PLSQL, UNIX, Postgres, Sublime, iTERM, Agile,GIT

Confidential, Chicago, IL

PL/SQL Lead/OBIEE Developer

Responsibilities:

• Designed and developed programs using Oracle PL/SQL.
• Enhanced the performance of poorly performing SQL queries.
• Involved in Tivoli scheduling team for UNIX job creation.
• Developed mappings to migrate the US01/US05 data from ACD database to new booking model.
• SIT cycles testing of data using Functionality/Migration code.
• SQL Loader Utility to load files to files to database system.
• Extensively used advanced PL/SQL concepts (e.g., BULK COLLECT, PL/SQL tables, cursors, user defined object types, exception handling, database packages, nested tables) to manipulate data
• Used TOAD/SQL Developer for day to day operations.

Environment: Oracle 11g, PL/SQL, UNIX Shell Scripting

Confidential, Bloomfield, CT

PL/SQL Lead/Developer

Responsibilities:

• Developed the scripts to generate files for HealthQx, Aver and DYO. At maximum I generated 50 million data for above 3 customers for POC.
• Compression ratio/Time analysis for data using different utilities Linux for POC.
• UNIX Shell Scripting with all use of major commands for file generation and POC.
• Performance improvement for ICD10 to ICD9 crosswalk procedures from 500 hours runtime to 10 hours and finally to 2 hours.
• Developed procedures, functions and packages with extensive use of EXPLICIT cursors, BULK COLLECT, PIVOT and analytical functions.
• Coordination and Involved in defects fixing of all QA testing
• To coordinate with offshore for all requirements and delivery.
• Daily Scrum call with scrum manager for assigned user stories in Rally.
• Developed reporting script to status reports after job completion.

Environment: Oracle 11g, PL/SQL, UNIX Shell Scripting.

Confidential, Bloomfield, CT

PL/SQL Lead /OBIEE Developer

Responsibilities:

• Developed data models in OBIEE for reporting to business/IT customers based on templates.
• Involved with clients for requirement gathering and involved in several meetings to discuss project updates and new changes.
• Developed procedures for custom layer to build 5 custom tables from application tables.
• Developed LIST partitioning with set of procedures to migrate Informatica jobs to PLSQL procedures to have better performance improvement.
• Developed procedures and packages with extensive use of EXPLICIT cursors, BULK COLLECT and analytical functions.
• Data modelling for new custom/service layer tables.
• Developed procedures for service layer for CCW Warehouse.
• Build the Meta tables required for both custom and service layer.
• Developed UNIX and ESP scripts for all regions.
• Coordination and Involved in defects fixing of QA testing.
• Involved in data model validation for both layers.
• Involved with DBA for DDL/Procedures deployment in PVS, PFIX and PROD regions and validated the same.
• Involved with ESP team to deploy and running the jobs in System, PVS and PFIX regions.
• Developed reporting script to status reports after job completion.

Environment: PL/SQL, OBIEE and Shell Scripting, ESP script, Informatica.

Confidential, Hartford, CT

PLSQL lead/developer

Responsibilities:

• Autosys, UNIX and Informatica development support for all IM applications
• Developed PL/SQL Packages, procedures and functions; Created views, database triggers for various functional requirements.
• Resolved day-to-day technical issues during development and testing phase.
• Interact with the requirements team during development and with users during implementation and analyze new business requirements or enhancements or change.
• Worked on the new change requests and implemented them successfully.
• Support for the client taking new change request and bug fixing after implementation stage.
• Involved in performance tuning. Converted all Delete/Insert statements to Merge/Delete for all fact tables as part of performance tuning.
• SQL Performance tuning was done using Explain plan, correct Index creation, Analyzing table stats and creating the right data model.
• Performed Oracle DBA tasks such as monitoring the database, creating users, granting roles and grants, application build, run conversion scripts.
• Used development tools such as Toad and SQL Developer for writing code and executing the queries etc.
• Performance tuning of PL/SQL procedures and SQL queries and defining checklists for coding, testing & deliverables.
• Developing the High Level Design for the enhancements.
• Involved in Designing schema and schema objects, coding in PL/SQL and Shell Scripting, Review of Test Cases and System Testing.
• Developed various Complex Queries, Views for Generating Reports and created dyanamic procedures for various process in the project to load different tables.
• Tuned SQL queries using Explain Plan and TKProf utilities to improve performance.

Confidential

Responsibilities:

• Involved in conversation of PARMS (Teradata) to Procedures (Exadata).
• Created procedures and packages from Teradata PARMS using internal tool.
• Compiling and debugging of the procedures and packages from the tool output using TOAD.
• Unit testing of all the components.
• Created mappings / workflows using Informatica from Teradata PARMS.
• Changed all the UNIX scripts to be compatible with Exadata.

Confidential

Responsibilities:

• Prepared Unit test cases for all UNIX / Perl scripts for iKDB 10.1 releases.
• Coded and Unit Testing all UNIX / Perl scripts via UC4 jobs.
• Worked on Production Tickets and CR.
• Used google translator to understand the error description.
• Developed SQL, PL/SQL Stored procedures and cursors for implementing Complex business rules and transformations.
• Defect tracking, root cause analysis and ensuring on-time defect closure.
• Strict adherence to Configuration management and version control by coding, compiling and saving the source code as well as programs in SVN.

Confidential

Responsibilities:

• Developed UNIX scripts using UNIX commands to perform various business specification rules.
• Developed Unix Scripts for generating Reports sent to clients on various scenarios of Export & Import status.
• Program to do the export & import process from source to target database using Oracle Data pump utility commands.
• Extensively worked in writing Unit Test Cases & performing it.
• Co-coordinated the offshore team for various business activities on daily basis
• Contributed in preparing the job manual guide and Job calendar serving for scheduling purposes.
• Automated the script execution through various job sequencers.
• Developed UNIX shell scripts to automate job execution and data loading procedures based on business requirements.
• Modification/Enhancement of the existing components and working on new CR's.

Confidential

Responsibilities:

• Analyzed Business requirements from the interface document.
• Prepared Unit Test Plan from the requirement
• Execute the Test cases and Log the test results.
• Participating in the discussion for the enhancement of the existing application.
• Ongoing unit testing is done including the negative testing whenever the development is modified.
• Performed Regression Testing and impact analysis.
• Participated in Review meetings of the product acceptance

Confidential

Responsibilities:

• Involved with CSC clients in understanding the existing archival process from end to end.
• Proposed an efficient solution in handling the archival of files in a single Job.
• Developed UNIX scripts for the file archival process.
• Analysis of 65 files which Pushed/ Pulled to WAMU card services from TSYS vendor.
• Involved in coordination with offshore call for daily status.
• Involved in development/testing of new archival job.

Confidential

Responsibilities:

• I was involved in the maintenance and enhancement of VRP project for Hartford. I have strong knowledge of the technologies like Oracle 9i, Forms 6i and PL/SQL used in Hartford’s systems.
• Developed procedures, functions and packages based on business requirement.
• Preparation of Technical and Functional documents for the Plan, Design, Build and Deploy phases.
• Preparation of Unit/Assembly test scripts and Unit/Assembly Test logs for the components that are impacted.
• Develop code for the changes required and unit test them.
• Prepare delivery logs for each enhancementthat has been requested and deliver them.