SUMMARY:

• Around 6 years of PL/ SQL Developer experience specializing in Analysis, Design, Development, Implementation and Maintenance of various applications and databases, with complete understanding of Software Development Life Cycle.
• Designed, developed and supported ETL process for Data Staging, Extraction, Transformation, and loading of Fact Tables, Data Cleansing, and Automating ETL Process.
• Expertise in leveraging SQL, PL/ SQL, SQL*Plus, TOAD and SQL*Loader utilities to perform and automate data ingestion, manipulation and supporting in - house ETL jobs.
• Expertise in creating and modifying database objects like Tables, Indexes, Views, Triggers, Synonyms, Sequences, and Materialized views using SQL and PL/ SQL.
• Experience in DML, DDL, and TCL operations
• Expert level experience on PL/ SQL that includes Cursors, Ref-cursors, Procedures, Functions and Packages, Object, Partitioned Tables, and Table Index
• Expertise in using user defined and system defined Exceptions for Error handling.
• Extensive experience in Database query tuning, Performance tuning
• Experience in creating composite data types and collections.
• Using standard practices in Data warehousing: Star Schema/Snowflake Schema, Fact and Dimensions tables and Slowly changing Dimensions
• Solid understanding of OLAP (Online Analytical Processing) concepts.
• Worked in Software Development Life Cycle (SDLC) like Agile and Waterfall methodologies.
• Experience in the Implementation of full lifecycle in Enterprise Data warehouse, Operational Data Store (ODS) and Business Data Marts with Dimensional modeling techniques.
• Analysed the backend capabilities and Implemented Push down optimization for Performance gain in Informatica.
• Experience in using tools like SQL*Loader, SQL * Plus, PL/ SQL developer and TOAD.
• Expertise in data modeling, Normalization, database design, data loading, data retrieval, and modification
• Experience in Migration and Upgrade of databases.
• Strong understanding of concepts in Data Warehouse like logical and physical database designs and dimensional modeling schemas like Star and Snowflake schema for OLAP, OLTP, ETL and Reporting.
• Good experience in UNIX shell scripting: Bash, Bourne, KSH. Good experience in leveraging UNIX utilities: sed, awk, grep for data manipulations.
• Expert in creating DDL, DML, DCL, TCL statements, Indexed Views, Constraints, Stored Procedures, Functions, Packages, Triggers, Exceptions to facilitate efficient Data Manipulations while maintaining data consistency.
• Worked with features like BULK COLLECT, MERGE, CASE and PL/ SQL Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Proficient in developing SQL queries to retrieve the data from source at session level and in transferring and retrieval of data between FTP Servers and Oracle Database.
• Expertise in handling errors using Exceptions.
• Documented Data flow diagrams, Data dictionary, and applied suitable Database normalization theory techniques to create Entity Relationship models.
• Working knowledge of Data-Modeling Techniques using Data-Modeling Tools like ERwin.
• Experience in developing forms based on Views, Tables and Procedures in Tabular and Form layouts.
• Expert in integrating the SSRS reports into web applications using Report Viewer Control, URL methods and creating data driven subscriptions to different users using Report Manager.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Hands on experience in Performance Tuning of SQL Queries & Views using EXPLAIN PLAN, SQL Trace and TKPROF utilities.
• Hands on experience working with Git, GitHub, TFS for Source Control.
• Performed Unit Testing, System Testing and UAT Testing.
• Proficiency in understanding and creating Technical Requirement Documents (TRD), Rough Order of Magnitude (ROM), Requirement Traceability Metric (RTM).
• Experience in writing Technical Design Documents and developing Unit Test Documents.
• Experienced in Agile/Scrum development environment.

TECHNICAL SKILLS:

DATAWAREHOUSING TOOL: INFORMATICA POWERCENTER 8.X/9.X/10.X

DATABASE: ORACLE 10/11g, Teradata, Oracle, SQL server, DB2.

MAINFRAME: COBOL, JCL, EZTREIVE (OLTP- CICS/FMS-VSAM), CHGMAN, FM, SPUFI, PLATINUM, DG, DTCN, ABEND-AID

SQL, PL: SQL, Unix Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Reston, VA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Meeting with end users, collecting requirements and converting into technical Specification.
• Worked with business analysts to identify appropriate sources for data warehouse and prepared the Business Release Documents, documented business rules, functional and technical designs, test cases, and user guides.
• Actively involved in the Design and development of the STAR schema data model.
• Implemented slowly changing and rapidly changing dimension methodologies; created aggregate fact tables for the creation of ad-hoc reports.
• Worked with various functional experts to implement their functional knowledge into working procedures.
• Developed various database objects for front end application.
• Involved into updating procedures, functions, triggers, and packages based on the change request.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Developed application and database triggers, functions, procedures, and packages in PL/ SQL.
• Extensively used for all and bulk collect to fetch large volumes of data from table.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables.
• Extensively worked on Connected & Unconnected Lookups, Router, Expressions, Source Qualifier, Aggregator, Filter, Sequence Generator, etc.
• Created and maintained surrogate keys on the master tables to handle SCD type 2 changes effectively.
• Retrieved data from unstructured sources like xml using B2B data transformation.
• Applying constraints and writing triggers to apply the business rules. Involved in handling errors and transaction processing in the procedures.
• Extensively used Global Temporary Tables to load the required data set to increase the performance.
• Used BULK COLLECT, BULK INSERT and FORALL to decrease query execution time.
• Reproduce Oracle schema objects includes temporary tables, views, Materialized views, indexes, triggers and procedures, based on customer requirement.
• Worked on production tickets using BMC Footprints service core (version12.1).
• Developed Complex SQL queries using various Joins, Sub-Queries, Analytical and Group Functions and developed various dynamic SQL's thorough out the projects.
• Created shell scripts and updated the scripts as per the requirement.
• Loading members from monthly file into database, their processing and assigning providers based on their enrollment for SOA webserver application.
• Automation of medical files and scheduled to run every month using UNIX shell scripting.
• Created test cases and test reports and worked with QA team to validate the data and scenarios.
• Handled various exceptions to troubleshoot PL/ SQL code.

Confidential

Software Developer Engineer

Tools: - Informatica Power Center 9x, Oracle 10/11, Teradata SQL assistant, UNIX, Clear Term explorer, SNOW, Clear Quest, Win-SCP.

Roles and Responsibilities

• • Involved in Requirement gathering, business Analysis, Gap analysis and review business rules.
• • Involved in preparing ETL specifications, Performed Developer testing, Unit testing for the Informatica mappings.
• • Developed BTEQ scripts to load data into production tables
• • Used SQL overrides in source Qualifier to filter the data more effectively at the source level.
• • Applied different optimization techniques to enhance performance at various levels which includes SQL tuning, transformation optimization and auditing.
• Page 3
• • Worked in creating scripts for facilitating data transfers between mainframes and informatica/Unix servers.
• • Created WLM schedule jobs to automate run and designed required recovery/ad-hoc components.
• • Involved in developing logical and physical data models, DB2 look alike physical model structures that capture incremental and historical data.
• • Provided production support daily, Monthly and Weekly Schedule during the warranty period post implementation.
• Reviewing work products and supporting for deployments. Co-ordinate release activities.
• Project#2: Data migrations and Decommissioning projects
• Worked in multiple projects in which the plan was to retire existing regional or legacy warehouses or get rid of external vendor contracts and bring complete data into central data warehouse EDW. All reporting extracts had to be repointed to this enterprise data warehouse.

Confidential

Support and Maintenance Engineer

Tools: - JCL, COBOL, VSAM, DB2, CICS, DTCN, DG, SPUFI, CHGMAN, FN, FD, Informatica 8x/9x, Oracle SQL Developer.

Roles and Responsibilities

• Enhancing and Supporting all the Retail related applications ensuring that the system is running smooth every moment.
• Involved in preparing Functional and Technical design documents for the Requirements given.
• Involved in the Analysis, Estimation for Enhancement work - items, coding, Preparing Unit Test Plan, unit testing and documentation
• Responsible for maintaining the Quality standards in all the development and enhancement activities performed, from the stage of Analysis, preparing Design document till testing.
• Involved in development, maintenance and testing of batch programs as per business demands.
• Worked daily on issue tickets involving production issues, data issues and maintenance re-quests, Identification and solving any production or user related queries.
• Providing L3 & L2 Support- Incident/Issue Analysis and Resolutions. Supporting jobs running in production for failure resolution with tracking failure reasons and providing best resolution in timely manner.