OBJECTIVE

• Highly motivated creative and organized IT Professional with strong technical and analytical skills. Seeking a challenging position as an ETL Developer.

SUMMARY

• Ten plus years of IT experience as an Oracle PL/SQL/Datastage developer, System Analysis, Design, Development & Support of Oracle Servers 9.i, 10g, 11g and 12c in Production, Staging, Development environments
• Extensive experience in developing applications using tools like Oracle database 12c/11g/10g/9i, datastage 9.1/8, Oracle Forms 10g/9i, and Oracle Reports 10g/9i on Windows/Unix/Linux Environment.
• Experience in creating different kinds of partitions on tables for managing large tables to improve performance.
• Data loading from other databases and text files into Oracle Database using SQL*LOADER using datastage.
• Have good experience in writing PL/SQL scripts for the database objects like tables, views, procedures, functions, packages, database triggers, indexes and sequences, etc.
• Expertise in PL/SQL programming to develop stored procedures, using packages advance futures of Oracle 9i for PL/SQL programming like Varrays, Dynamic SQL, Query Optimizer, Nested Loops, External Tables, Nested Tables, LOBS, Records, Arrays and Exception Handling.
• Solid experience in performance tuning and Query Tuning (Generating Plan Table, Explain Plan, Optimizer with Hints, Analyze, Indexing strategy, SQL Trace etc).
• Extensive experience in using Cursors, Ref - cursors, Bulk Binds and Bulk Collects for processing of data.
• Experience in creating Materialized Views in data warehousing environment.
• Excellent experience in performance tuning, normalization and denormalization, partitioning of data and indexing of partitioned tables.
• Excellent experience in Control-M scheduling jobs development, modifying and supporting them in production environment.
• Knowledge in developing and supporting the scheduling jobs in TWS.
• Knowledge in Business Objects XI/6.5/5.0, BO Designer, BO Developer Suite (Broadcast Agent, Supervisor, Designer, Info View), Universe Developer, Supervisor, Web Intelligence 2.6/2.7, Crystal Reports.
• Experienced in integration of various data sources (DB2-UDB, SQL Server, PL/SQL, Oracle, Teradata, XML and MS-Access) into data staging area.
• Faced many challenging job as Backend developer written complex business logic using SQL and PL/SQL.
• Good at shell programming and setting the Crontab for all repetitive database processes in UNIX.
• Familiar with the junior DBA tasks like creating and managing table spaces, creating users, providing privileges, adding data files etc.
• Work closely with application architect, DBA to define requirements and interfaces and to implement business logic.
• Expertise in building Operational Data Store (ODS), Data Marts, and Decision Support Systems (DSS) using Multidimensional Model(Kimball and Inmon),Star and Snowflake schema design.
• Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
• Proven track record in addressing production issues like performance tuning and enhancement.
• Excellent knowledge in creating and managing Conceptual, Logical and Physical Data Models.
• Experience in dimensional and relational database design.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.
• Expert in unit testing, system integration testing, implementation, maintenance and performance tuning.
• Experience in different Scheduling tools like Control-M for automating and scheduling jobs run.
• Detail oriented with good problem solving, organizational, analysis, highly motivated and adaptive with the ability to grasp things quickly.
• Ability to work effectively and efficiently in a team and individually with excellent interpersonal, technical and communication skills.
• Have a very good knowledge in programming skills like C, C++, Python, JAVA etc.
• Worked in Agile environment.
• Analyzed and converted SAS and Java code into ETL process.

TECHNICAL SKILLS

Databases: Oracle 12, 11, 10g, 9i, Microsoft SQL Server

Business Intelligence: Micro Strategy, Business Objects 6, Crystal reports XI/8.5, Oracle developer (Forms and Reports 9i), SQL, PL/SQL, iSQL*Plus

Environment: UNIX (Sun Solaris, HP-UX, AIX), Linux, Windows 2007, 2003/2000/XP/98

Utilities: SQL Loader, Export / Import, Expdp / Impdp, Statspack

Languages: SQL, PL/SQL, Shell Programming, C, C++, Python

Tools: Oracle Enterprise Manager, TOAD 11, 10, 8.5, Putty, F-Secure Client 5.3, Hummingbird 10, CoreFTP, SmartFTP, SQL Developer 1.2.1, Navigator 5.5, PL/SQL Developer 7, ERWIN 4.14/4.0, Quality Center, CA Uni Center, ServiceNow, ServiceFirst, WinCVS, SVN, GitHub

Operating Systems: UNIX, Sun Solaris 5.8, 5.9, IBM AIX 5.2/5.3 Windows NT, Windows 95/98/2000, Windows XP, Windows Server 2003

Others: MS Office (Word, Excel, PowerPoint, Access), UML, MS Visio, Adobe Acrobat Reader/Writer.

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Managed and resolved design issues during development.
• Involved in creating database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Used Cursors both implicit and explicit to capture many rows within a PL/SQL block, and applied business rules on them.
• Involved in application tuning of database by defining the suitable indexes.
• Optimized and enhanced the existing procedures and SQL statements for the better performance using ANALYZE, DBMS STATS, STATSPACK, EXPLAIN PLAN, SQL TRACE and TKPROF to tune SQL queries.
• Used procedures and triggers to load data from the source database to data warehouse database.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool DataStage (Ver 9.1/8.5/7), designing and developing jobs using DataStage Designer, Data Stage Manager, DataStage Director and DataStage Debugger.
• Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.
• Excellent in using highly scalable parallel processing Infrastructure using DataStage Parallel Extender.
• Efficient in incorporation of various data sources such as Oracle, MS SQL Server, and DB2, Sybase, XML and Flat files into the staging area.
• Experience in Mapping Server/parallel Jobs in DataStage to populate tables in Data warehouse and Data marts.
• Active participation in decision making and QA meetings and regularly interacted with the Business Analysts &development team to gain a better understanding of the Business Process, Requirements & Design.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database.
• Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, Applied transform logics to extracted data and Loaded into Data Warehouse Databases.
• Created Datastage jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Sample, Surrogate Key, Column Generator, Row Generator, Etc.
• Extensively worked with Join, Look up (Normal and Sparse) and Merge stages.
• Extensively worked with sequential file, dataset, file set and look up file set stages.
• Extensively used Parallel Stages like Row Generator, Column Generator, Head, and Peek for development and de-bugging purposes.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.
• Developed complex store procedures using input/output parameters, cursors, views, triggers and complex queries using temp tables and joins.
• Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
• Creation of jobs sequences.
• Maintained Data Warehouse by loading dimensions and facts as part of project. Also worked for different enhancements in FACT tables.
• Used shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool.
• Coordinate with team members and administer all onsite and offshore work packages.
• Analyze performance and monitor work with capacity planning.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Participated in Daily status meetings.
• Developed Test Plan that included the scope of the release, entrance and exit criteria and overall test strategy. Created detailed Test Cases and Test sets and executed them manually.
• Gathering process information, business model and requirements
• Prepared ETL mapping and Low Level Design Documents for Policy and Consumer Conversion
• Designed the Target Schema definition and Extraction, Transformation and Loading (ETL) using Data stage.
• Used before and after job Sub Routines for auditing purpose
• Used Shared Containers and created reusable components for local and shared use in the ETL process.
• Imported and exported repositories across DataStage projects.
• Performed data analysis, data processing and cleansing through Error files and Log files.
• Used Data Stage Director Run Time engine to schedule and execute developed jobs and job sequences and use Log events to monitor job progress and performance.
• Troubleshot jobs using DataStage Debugger.
• Worked on performance tuning and enhancement of DataStage job transformations.
• Maintained the defects involved for proper documentation using Quality Control.
• Use to resolve all the QA defects related to design and documentation.
• Involved in 24/7 production support and was responsible for ETL process in production environment
• Wrote SQL*Loader script file for reading data from text file and loading into oracle table.
• Experience in designing, developing, testing, deploying, and modifying end-user reports using Oracle Reports.
• Created database triggers to implement and enforce data integrity and security.
• Exposure to full life cycle of product development starting from requirement analysis to deployment and maintenance.
• Familiar with the use E-R modeling to reverse engineer DB structures / schemas using ERWIN.

Environment: Oracle Database 10g, Oracle Forms 10g, Oracle Reports 10g, SQL*Loader, Toad, SQL Developer, Unix, Windows XP, Business Objects XI R2, Crystal Reports XI, Web Intelligence Release 2.

Confidential

Oracle Database ETL Developer

Responsibilities:

• Involved in requirement analysis and understanding of business analysis.
• Maintained the data integrity and security using integrity constraints and database triggers
• Developed Stored Program Units in the Form of Packages, Functions, Triggers and Procedures for implementing the database intensive business rules.
• Used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Dynamic SQL.
• Optimizing database performance by analyzing database objects, generating statistics, creating indexes, creating materialized views, using HINTS, Explain Plan and STATSPACK etc.
• Worked with tera bytes of database and involved in doing Table Partitioning and Sub partitioning on tables to improve the performance.
• Used PLSQL Records, Collections (Nested Tables and Varrays) in complex backend packages.
• Developed UNIX shell scripts with embedded SQL*Loader, Expdp / Impdp calls and PL/SQL statements to extract data from the legacy application in the form of flat files and load the extracted data into the new application.
• Used Export/Import utility for backup purpose and transferring data from one database to another.
• Used Wrappers for data security which encrypts the PL/SQL code (hide the customer information).
• Defining database Job Schedule programs for routine bases activities using DBMS JOB and PL/SQL.
• Analyzed the data that is received as a flat file from the agents for data organization and tune the data in such a way that it is understandable.
• Extracting data from Flat files, Oracle sources and transforming it in accordance with the Business logic mentioned by the client.
• Loading data into test warehouse for the business analyst to perform QA testing using SQL Loader utility.
• Helped in mapping the data that is stored in the Data warehouse from various agents and sources.
• Using the crontab in Unix and scheduler in Windows for automatic Tasks (Analyzing tables, loading tables, Import/Export).
• Created database link to create materialized views to maintain copies of remote data on the local node.
• Collaborated with business users, business analysts and project managers to translate the business requirements into technical specifications.
• Involved in analysis of physical Data Model for ETL mapping and the process flow diagrams.
• Responsible for creating High Level Design (HLD) and Application Interface Design (LLD) documents
• Responsible in designing the schema with a special focus on User Interface Design
• Responsible for conceptualizing and generating the need for Data Warehousing solutions as applicable to billing systems
• Evaluated the Consistency and integrity of the model and repository
• Used DataStage Parallel Extender for parallel processing of data extraction and transformation.
• Used Integrity & Parallel Extender for cleansing the data and performance improvement
• Extensively used almost all of the transforms of DataStage for various types of Date Conversions
• Created partition primary indexes and secondary indexes for query performance in db2.
• Responsible for Tuning the DataStage Repository and Jobs for optimum performance
• Extensively used Integritys existing wizards to remove duplicates
• Parsed, Matched and removed duplicate records using Integritys built-in wizards
• Scheduled and monitored automated weekly jobs
• Performed the Unit testing of individual modules and their integration testing
• Debugged and sorted out the errors and problems encountered in the production environment
• Performed daily production support of the Production Data Warehouse.

Environment: Oracle Database 9i, Oracle Forms 6i, Oracle Reports 6i, SQL*Loader, Toad, Unix, Windows XP, Business Objects XI R2/6.5.1, Crystal Reports 8.5, Web Intelligence.

Confidential, Bloomington, IL

Oracle Developer

Responsibilities:

• Implementation, Maintenance and Trouble shooting of the project.
• Involved in various stages of SDLC like Requirement gathering, high level design, low-level design, Coding, Testing, Quality assurance Documentation, Implementation and Project Planning.
• Wrote complex SQL queries to retrieve information from the databases depending on user requirement.
• Wrote scripts to validate data while migrating from trading application to the operational data store.
• Involved in creating database objects such as tables, views, synonyms, indexes, sequences and database links as well as custom packages tailored to business requirements.
• Used Oracle Enterprise Manager for managing parameters in the database.
• Use of EXPLAIN PLAN, ANALYZE, HINTS to tune queries for better performance and also extensive Usage of Indexes.
• Assisting other developers for the application performance tuning and verifying the TKPROF.
• Extensively used Cursors and Ref Cursors in order to generate various reports.
• Used cursors, exception handling, throwing exceptions, and nested loops, and also used the pragma exception init in order to associate our own created error messages with the error codes.
• Used Dynamic SQL for Query Optimization and by using this dynamic sql it increases the performance and also to perform error detection and cleanup.
• Performed the data validation using the database triggers.
• Loaded data sets from or to Oracle Databases using several kinds of tools such as SQL*Loader, Toad and External table Facility.
• Worked with different FTP clients for loading data from the windows environment to the Solaris environment.
• Involved in Analysis, design, testing, debugging phases of the System.
• Created simple, complex create joins, calculated items and conditions.
• Analyzed the tables and indexes using SQL and PL/SQL scripts.
• Monitored existing code and doing performance tuning if necessary.
• Wrote database triggers for audit and data validation.
• Creation of users, roles, schemas, tables, indexes etc.
• Planning of logical database and physical layout.
• Wrote procedures and functions using PL/SQL
• Prepared Monthly and Weekly Status Reports.
• Testing, implementation and documentation.
• Automating data loading, extraction, report generation using UNIX shell scripting.

Environment: Oracle 8.1.7/9.2.0.1 , Oracle Forms and Reports (6i), SQL NAVIGATOR, PL/SQL, Shell Scripts, Windows XP/2000, Redhat LINUX 2.0/3.0,TOAD, Oracle Enterprise Manager (OEM), Business Objects 6.5/5.1,Crystal Reports.