SUMMARY

• 8 years of IT experience in Database/Application migration, integration and Data warehousing.
• Over 7 years of IT experience in ETL using PL/SQL and Data Stage.
• Seasoned in Designing, Developing and maintaining applications in data warehouse for Finance, Healthcare, Media and Public sector.
• Good exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, Documentation, Production Support.
• Ability to work independently, gather requirement, create the design and code faster to meet the deadline.
• Expertise in OLTP and OLAP both Environment using PL/SQL
• Ability to run end to end ETL Process including Data modeling, Job design, Unit testing and automation.
• Experienced in working with Waterfall and Agile (Scrum and Kanban) methodology.
• Good understanding in Logical, Physical and Dimensional data modeling (Star Schemas and Snow Flake Schemas).
• Expert in Data Warehousing techniques for Slowly Changing Dimension Phenomenon (SCD), Surrogate key assignment and CDC (Change Data Capture).
• Expertise in SQL/PLSQL programming development, creating Packages, Stored Procedures, Functions and Packages. Experience in Loader utilities including SQL Loader, Exchange Partition.
• Expertise in Dynamic SQL, Cursor, Bulk Collect, Collection and Ref Cursor.
• Experience of Performance tuning by using Explain Plan and Hints and Cost Based Optimization.
• Experienced working with custom - made Pl/SQL table driven ETL Framework, enhance the framework.
• Experienced in handling large volume of data and design job according to volume.
• Experienced in Data Modeling following the organizations standard.
• Designed DataStage jobs to populate and incrementally load the source data to the staging area, transformations, filters, lookups and necessary source-to-target data mappings to load the target using the Designer.
• Ability to use all the DataStage stages and partition mechanism efficiently.
• Parsing XML documents into relational data, and composing XML documents from relational data using XML stage.
• Excellent working knowledge of UNIX shell scripts and scheduling jobs by using tools like Control M, Maestro,
• Skybot and Autosys.
• Provided on call production support 24/7 and critical member of ETL solution team and forum.
• Maintained outstanding relationship with Business Analyst, Data Modeler, Business Users to gather information needs as per the business requirement. Experienced in working with offshore and onsite co-ordination.
• Experience with Version control tools like CVS.
• Excellent Written, Communications and Analytical skills with ability to perform independently as well as in a team.
• Self-motivated, proactive, customer focused and keens to learn new technologies.

TECHNICAL SKILLS

• IBM InfoSphere DataStage Enterprise Edition 9.1/8.5/8.0.1/8.0/7.5/7. x
• PL/SQL
• Toad
• Erwin 7.0
• SQL*Loader
• Control-M
• Autosys
• C/C++
• Korn shell
• T-SQL
• PL/SQL
• XML
• UNIX shell scripting
• Windows Power shell scripting
• Windows/2000/2003/NT/XP
• LCR/NSFR
• IBM AIX 7.1
• Lombard risk reg. report
• Oracle 8i/9i/10g/11g
• Quality Center
• MS SQL Server 7.0/2000/2003
• DB2
• Sybase
• IBM SPSS
• MS Access
• Teradata
• Pentaho
• MS Visio
• MS Office

PROFESSIONAL EXPERIENCE

Confidential, Hightstown, NJ

PL/SQL Application Developer

Responsibilities:

• Worked as a Senior Application developer for implementation partner Symphony Teleca to create new application and support existing database applications for Dodge.
• Created applications for loading Xerox file (Plans and Specifications) and different kind of services to process pdf files and finally load into Dodge Global Network.
• Created PL/SQL application by using records, collections and Bulk Collect.
• Created application to load external files by using SQL Loader and external tables.
• Wrote FTP scripts which ftp files to different vendor like Monrovia, Walmart and Xerox.
• Involved in Migration project Operation Blue Sky and moving customer face applications/database to AWS.
• Used multiple Batch scheduling tools Maestro and Skybot and wrote Korn shell scripts for automation.
• Communicate with offshore team and instruct them with the latest updates and workload distributions.
• Communicate with TCS and Cognizant team and identify/provide solutions to recurring problems.
• Involved with performance tuning and optimization of the queries.
• Provided 24/7 on calls Prod support.
• Debugged code written in PL/SQL, Unix, Perl and C languages for support purpose.

Environment: Oracle 11g, TOAD 11, Windows NT server, AIX Unix 5.2, FTP, Trivoli Workload Scheduler, Skybot, Dot Net, Informatica Power Center.

Confidential, Delaware

ETL Developer

Responsibilities:

• Worked with the various operational department like Customer care desktop, Credit Risk, IVR, Collections and Sales & services.
• Worked as a Senior Developer in multiple projects like TransUnion FICO Score file load from Stage to Operational Data Source and then to Datamart, Customer requested credit line increase, Auto Payment preventing negative balances, Customer experience project with Click Fox. Data Stage Upgrade project from 8.5 to 9.1, Customer Risk assessment project Catalyst.
• Extensive hands on experience on design and developing jobs in datastage latest versions 8.5 and 9.1.
• Worked with both Agile and Waterfall model and part of transition from Waterfall to Agile methodology.
• Experience with working CRO business team and understanding of how Credit operation works in all layer.
• Involved with Java and .NET developers while developing the ETL OLTP Application and identify the dependency.
• As part of agile team involved with task identification, work effort estimates, and work schedules for development and maintenance activities.
• Used to solve production incident problems in time-constrained situations.
• Implemented slowly changing dimension Type 1 and Type 2 by using both DataStage and PL/SQL.
• Extensively used PL/SQL Bulk Collect and FOR ALL to improve performance wherever required.
• Migrated huge amount of data from one database to another by using PL/SQL anonymous block.
• Created shell scripts for automation of work and batch processing and used to create the Control-M requirement for batch operation team.
• Implemented same functional design for different data warehouse, to implement substitute of legacy database.
• Worked with SFTP and Connect Direct and involved with File transfer team to transmission of files to/from different vendors.
• Created partitioned tables and partitioned indexes to improve the performance of the applications
• Participates in the analysis and definition of efficient, cost effective application solutions, which support client business processes and functional requirements. .
• Matching expert with Quality Stage matching concepts and methodologies.
• Conducts analysis of client business processes and functional requirements and prepares appropriate documentation to communicate and validate the information.
• Provides on-call support (24/7) as assigned on rotation basis. Ensures compliance with industry best practices.
• Performs code review. Performs defect analysis. Collaborate with Data Architect/DBA to maintain optimal reporting tables and views.
• Extract data based on business requirement and created file for vendors.
• Used to discuss Data Architect and Data modeler which kind of data modeling should be used for source table.
• Used to review existing PL/SQL or DataStage application and reply to business query.
• Good knowledge in how to handle data in Stage, Source and DataMart layer.
• Ability to convert existing Server jobs to Parallel jobs to increase performance.
• Partitioned large table into range partition techniques and used indexes on appropriate column to faster access of data.
• Used table-partitioning mechanism to store the valid record into current partition and older record in older partition.
• Ability to use Exception handling properly in PL/SQL packages and debugs the code appropriately.

Environment: PL/SQL, DataStage 9.1/8.5/8.1, Oracle 11g/10g, Toad, Control-M, Windows 2007, Quality Center, UNIX, Share point, WinSCP, WinCVS, UniCenter, Putty, SoapUI.

Confidential, Princeton, NJ

ETL Developer

Responsibilities:

• Participated in business meetings, raised the requirement gaps and document the process. Participated in design meetings and perform detail level design.
• Involved in performance tuning by rewriting the queries and modifying existing DataStage jobs.
• Worked with String processing in file level using AWK and SED.
• Used Autosys to schedule and automate job.
• Used HINTS to direct the optimizer to choose an optimum query execution plan wherever required.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL FILE package.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus
• Developed DataStage job sequences for the designed jobs using job activity, exec command, e-mail notification activities and triggers.
• Developed user defined subroutines in BASIC to implement some of the complex transformations, date conversions, code validations and calculations using different DataStage supplied functions.
• Designed DataStage jobs using different parallel job stages such as join, merge, lookup, remove duplicates, filter, dataset, lookup file set, change data capture, switch, modify, aggregator.
• Used Quality Stage to for Data Standardization to cleanse the data.
• Facilitate unit, system and user acceptance tests and fix defects by debugging and finding the root cause of the defects in timely manner.
• Wrote Unix Korn shell script for file validation and calling the PL/SQL procedures.
• Impact analysis when enhancing the existing system.
• Documented the purpose of mapping so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Also involved in ETL test plans, test scripts and validation based on design specifications for unit testing and functional testing.
• Coordinated with Release manager to migrate the components from one environment to another environment.

Environment: Oracle 11g, PL/SQL, SQL*Plus, TOAD, Erwin, Unix, Autosys, IBM DataStage, Windows XP

Confidential, Harrisburg, PA

PL/SQL Developer

Responsibilities:

• Gathered requirements from business users and analysis based on the requirements.
• Analyzed and Reviewed the Business Specification Documents.
• Extensively involved in the requirement analysis, development, writing test cases, and unit testing.
• Designed and created Database objects.
• Wrote PL/SQL procedures and packages as per the requirement.
• Wrote complex SQL queries.
• Created views for as per business requirement.
• Created indexes for faster access of the tables.
• Worked on Materialized Views and Query Rewrite.
• Solved p1 production issues and critical problem.
• Wrote script to migrate the data from one system to another system.
• Used SQL*Loader to load data from flat files (excel/text) to Oracle database.
• Used explain plan to improve the database performance.
• Extensively involved in the analysis and tuning of the Application code (SQL).
• Fine-tuned PL/SQL Procedures for better performance.
• Wrote shell scripts for scheduling jobs.
• Assisted in testing and deployment of the application.

Environment: Oracle 9i, SQL Server, PL/SQL, HP-UX, Erwin 4.1, TOAD, UNIX

Confidential

PL/SQL Developer

Responsibilities:

• Assisted in updating the logical model with all related entities, attributes and relationships between entities based on the rules provided by the business manager using Erwin.
• Interacted with business users, reporting analysts in gathering information about the business logic to populate the target tables.
• Involved in requirement gathering, analysis and study of existing systems.
• Involved in the maintenance and enhancement of the application.
• Created PL/SQL packages, functions stored procedures, cursors for Data Warehousing.
• Developed complex SQL queries for data retrieval from various database objects including tables and view
• Worked on various backend Procedures and Functions using PL/SQL.
• Created database tables and wrote database triggers applicable to business rules.
• Debugged various defects related to implementation of business logic
• Wrote UNIX shell scripts to automate the system.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target
• Worked as QA analyst occasionally as per need.
• Created documentation for the entire project level.

Environment: Oracle 8i, Erwin4.0, TOAD 7.4, PL/SQL, Windows NT server, Windows Power Shell Scripting. AIX UNIX 5.2, SQL Server