SUMMARY

• Around 6 years of PL/ SQL Developer experience specializing in Analysis, Design, Development, Implementation and Maintenance of various applications and databases, wif 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 teh Implementation of full lifecycle in Enterprise Data warehouse, Operational Data Store (ODS) and Business Data Marts wif Dimensional modeling techniques.
• Analysed teh 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 wif 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 teh 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 teh 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 wif 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 wif 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: DATAWAREHOUSING TOOL: INFORMATICA POWERCENTER 8.X/9.X/10.X

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

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

OTHER PROGRAMMING: SQL, PL- SQL, Unix Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, Reston, VA

Sr. Oracle PL/SQL Developer

Responsibilities:

• Meeting wif end users, collecting requirements and converting into technical Specification.
• Worked wif business analysts to identify appropriate sources for data warehouse and prepared teh Business Release Documents, documented business rules, functional and technical designs, test cases, and user guides.
• Actively involved in teh Design and development of teh STAR schema data model.
• Implemented slowly changing and rapidly changing dimension methodologies; created aggregate fact tables for teh creation of ad-hoc reports.
• Worked wif 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 teh 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 teh master tables to handle SCD type 2 changes TEMPeffectively.
• Retrieved data from unstructured sources like xml using B2B data transformation.
• Applying constraints and writing triggers to apply teh business rules. Involved in handling errors and transaction processing in teh procedures.
• Extensively used Global Temporary Tables to load teh required data set to increase teh 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 teh projects.
• Created shell scripts and updated teh scripts as per teh 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 wif QA team to validate teh 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.

Responsibilities:

• Involved in Requirement gathering, business Analysis, Gap analysis and review business rules.
• Involved in preparing ETL specifications, Performed Developer testing, Unit testing for teh Informatica mappings.
• Developed BTEQ scripts to load data into production tables
• Used SQL overrides in source Qualifier to filter teh data more TEMPeffectively at teh source level.
• Applied different optimization techniques to enhance performance at various levels which includes SQL tuning, transformation optimization and auditing.

Confidential

Tools: - Informatica Power Center 9x, Teradata, Teradata SQL assistant, UNIX, Clear Term explorer, SNOW, Clear Quest.

Responsibilities:

• Implemented complex business rules in Informatica by creating re - usable/non-reusable transformations, robust mappings, mapplets, sessions and workflows
• Coordinating wif business clients, supporting teh application and implementing teh process as per specifications provided.
• Performing requirement gathering and analysis, estimation, work in take, preparing schedules, design and development, testing and deployment of application enhancements.
• Created complex SCD type 1 & type 2 mappings using dynamic lookup, Joiner, Router, Union, Expression and Update Strategy Transformations.
• Extensively used Change data capture concept in Informatica to capture teh changes in teh data warehouse.
• Working on Dimension as well as Fact tables, developed mappings and loaded data on to teh relational database.
• Designed data feeds to load Teradata tables from flat files, using BTEQ and other Teradata utilities.
• Working wif DBA to build physical and logical data models.

Confidential

Support and Maintenance Engineer

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

Responsibilities:

• Enhancing and Supporting all teh Retail related applications ensuring that teh system is running smooth every moment.
• Involved in preparing Functional and Technical design documents for teh Requirements given.
• Involved in teh Analysis, Estimation for Enhancement work - items, coding, Preparing Unit Test Plan, unit testing and documentation
• Responsible for maintaining teh Quality standards in all teh development and enhancement activities performed, from teh 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 wif tracking failure reasons and providing best resolution in timely manner.