SUMMARY

• A Technology driven IT professional with 8 years of experience in Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, BI, Client/Server applications.
• Experience using SQL in large - scale relational database environment complex queries, across multiple databases, stored procedures, user defined functions, stored procedures and triggers.
• Expertise in writing PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Materialized Views, fine tuning of SQL Queries using Explain Plan, SQL Trace on Oracle 9i/10g/11g /12c databases.
• Strong Data Warehousing ETL experience of using Informatica 10.2/9.5 PowerCenter Client tools; Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools Informatica Server, Repository Server manager.
• Wrote DML statements (insert, update, delete) using FORALL statement to reduce loop overhead.
• Experience in gathering business requirements and converting them into functional, technical specifications and developed mapping documents to map source systems to the Data Warehouse Model.
• Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files using Informatica Power Center 9.5.
• Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
• Extensive experience in development/testing and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center v 9.x.
• Experience creating Informatica mappings to extract, transform and load data from Oracle and SQL Server Sources into Data warehouses and Data Marts.
• Perform migration of ETL code and support migration to production environment.
• Working experience in Dimensional Data modeling using Star and Snowflake schema.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Experience in Performance Tuning (sources, mappings, targets and sessions), SQL Tuning, Table Space Partitioning, creation of indexes for faster database access and better query performance.
• Database monitoring and tuning using Explain plan and oracle optimizer hints and SQL Query tuning, DBMS scheduler.
• Planned, Designed and Implemented Table Partitioning for improving performance.
• Expertise in utilizing oracle Utility tools SQL *Loader and External Tables to Load data from Flat files to Oracle Tables.
• Experience in using UTL FILE Oracle supplied package for file operations (read and write text files) in conjunction with the underlying operating system.
• Experience working in an Agile development environment.
• Excellent Analytical, Programming and Reporting skills.
• Coordinated with DBAs, QA, Release Management and external team for technical needs and to ensure the timely release of project.
• Experienced in designing report layouts in SSRS (Matrix, Drill through, Parameterized Reports).

TECHNICAL SKILLS

Programming Language: PL/SQL, SQL, C, C++, Core Java

Web Technologies: HTML, HTML5, XML

Scripting Language: Shell Script, XML, CSS, Java ScriptDatabase Oracle 10g/11g, SQL Server, Ms Access 2000.

ETL: Informatica 9.6.1, SSIS

Operating Systems: Windows 95/98/NT/XP/Vista, Windows 2007, Windows 8, UNIX, Linux

Versioning Tool: Tortoise SVN. Serena

Tools: /Utilities/IDE: Visual Studio 2008/2010, SSRS, SSIS, Oracle Warehouse Builder, SQLDeveloper, SQL Navigator, SQL*Plus, SQL*Loader, TOAD Oracle forms and reports 9i.Toad Data Modeler.

PROFESSIONAL EXPERIENCE

Confidential, Fairfax, VA

Oracle PLSQL Developer

Responsibilities:

• Involved in preparing technical documentation for development of code and process flow.
• Created/modified existing oracle processes to support new enhancements.
• Supported Bundle Visibility back end process to ensure accurate reporting for end users.
• Coordinated and supported releases with deployment teams to ensure smooth PROD deployment.
• Developed various Oracle objects like Stored Procedures, Functions, and Packages using PL/SQL as per the Design Documents.
• Data analysis for issues related to reporting data on front end reports.
• Provide fixes for productions issues dat delay daily reports.
• Involved in SQL Performance tuning using Oracle hints, threading and Parallel processing in order to get the faster output.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Developed automated processes to run at scheduled time and selected processes only using control tables.
• Extracting, Transferring and Loading the data for the Warehouse using spool and Sql * Loader.
• Analyze code for system testing and debugging, create test transactions to find, isolate and rectify issues.
• Experience in identifying performance issues, debugging and performance tuning in PLSQL packages using SQL Trace, Explain plan, Indexing, Hints, Partitioning, Profiling and Oracle Code Coverage Utilities
• UAT Support consists of coordination with program team for data availability, attendance of UAT meetings with users, attendance of UAT defect triage meetings, responding to and resolving ETL defects identified during UAT, and data capture and data refresh as needed in environment.
• Created and Modified existing functions and procedures based on business requirements.
• Worked extensively on Exception handling to trouble-shoot PL/SQL code.
• Monitor Oracle daily jobs to provide support if any of the key process fail.

Confidential, Herndon, VA

Database Analyst

Responsibilities:

• Involved in meetings with Business and Project Managers for enhancing our current process and automating the process to run Expirations/GFE Daily.
• Created/Modified stored procedures for supporting the automating process and other enhancements as per the requirements.
• Modified existing SSIS packages to support new enhancements in the process.
• Write and unit test scripts/procedures developed to satisfy requirements.
• Primary oversight for GFE process and DMI/SVI Expiration process.
• Participated in regular deployments activities and debugging and fixing production issues.
• Participate in routine status meetings and touch points for various projects.
• Integral part of the Database Development team for any database related improvements/issues.

Environment: Microsoft SQL Server, T-SQL,SSIS, SQL Server Management Studio, Visual Studio,MS Office, Jira, GIT Lab.

Confidential, Birmingham AL

Oracle PL/SQL/ ETL Developer

Responsibilities:

• Involved in the meetings with Line of Business for requirements gathering and modified procedures according to the business requirements.
• Created and used Materialized views and DB links for remote instances to retrieve data from other databases.
• Modified views, procedures and data objects to support data migration from new application (Cadence).
• Involved in preparing technical documentation for development of code and process flow.
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages using PL/SQL as per the Design Documents.
• Created Tables, Synonyms, Sequences, Used Database trigger for making history of insertion, updating, deletion and all kind of Audit Routines Enforced Database Integrity using primary keys and foreign keys.
• Involved in SQL Performance tuning using Oracle hints and Parallels in order to get the faster output.
• Used advanced Bulk techniques (FOR ALL, BULK COLLECT) to improve performance.
• Extracting, Transferring and Loading the data for the Warehouse using spool and Sql * Loader.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Developed Complex transformations, Mapplets using Informatica to Extract, Transform and load data into DataMart’s, Enterprise Data warehouse (EDW).
• Implemented/Recreated our data transformation logic dat is spread out over different stored procedures into a set of workflows in Informatica Power center using Informatica transformations for RRM DataMart like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Prepared migration document to move the mappings from development to Test/Prod repositories.
• Analyze design data models and develop high level design (HLD) / solution specification document (SSD) for ETL (Extract Transform Load) outbound feed.
• Implemented Type 2 Dimension mappings to capture historical data.
• Created UNIX scripts to run ETL jobs through CTRL M.
• Created maintenance packages to support automating some tasks in the ETL process like Truncating/Creating partitions, Running Statistics, Etc.
• Created UTEST oracle package to automate few test cases to validate the data loaded after each load process.
• Experienced in the use of Agile approaches, including Extreme Programming, Test-Driven Development and Scrum.
• Analyze code for system testing and debugging, create test transactions to find, isolate and rectify issues.
• Experience in identifying performance issues, debugging and performance tuning in PLSQL packages using SQL Trace, Explain plan, Indexing, Hints, Partitioning, Profiling and Oracle Code Coverage Utilities.
• Developed ETL rules using Wolters Kluwers OneSumX financial toll for risk and regulatory reporting.
• UAT Support consists of coordination with program team for data availability, attendance of UAT meetings with users, attendance of UAT defect triage meetings, responding to and resolving ETL defects identified during UAT, and data capture and data refresh as needed in environment.
• Created and Modified existing functions and procedures based on business requirements.
• Worked extensively on Exception handling to trouble-shoot PL/SQL code.

Environment: Oracle 12c/11g, SQL, PL/SQL, Oracle SQL Developer, Unix Shell scripts, Sql*Loader, TOAD, Toad Data Modeler, Informatica 9.5, Windows, Serena, OneSumX.

Confidential, Virginia Beach VA

Oracle PL/SQL Developer

Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application.
• Created PL/SQL stored procedures, functions and packages in Oracle for SSRS Reports.
• Created SQL*Loader control files for loading the data from flat files to staging area tables.
• Developed SSIS packages to create an Extract file (Text File).
• Developed SQL scripts to create database objects like tables, views and sequences.
• Used SQL*Loader to load bulk data from various flat files.
• Developed SQL and PL/ SQL scripts for migration of data between databases.
• Using SSRS created well-formed reports and web-based reports for health-related applications and transactions.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Tune SQL statements using hints for maximum efficiency and performance, create and maintain/modify PL/SQL packages, mentor others with the creation of complex SQL statements, perform data modeling and create/maintain and modify complex database triggers and data migration scripts.
• Developed scripts to write the results of a query to a text file using Oracle SPOOL command.
• Created/Maintained/Scheduled Jobs using TIDAL to run the scripts remotely.
• Proactively tuned SQL queries and performed refinement of the database design to leading significant improvement of system response time and efficiency.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, DBMS PROFILER, etc.
• Developed UNIX shell scripts in VI Editor with embedded SQL*Loader 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.
• Excellent trouble shooting, debugging and error trapping skills.

Environment: Oracle 11g/10g, SSRS, SSIS, TES(Tidal Enterprise Scheduler),Facets 5.01, Microsoft SQL Server 2012, PL/SQL, Oracle SQL Developer, Unix Shell scripts, SQL Plus, Sql*Loader, Informatica, TOAD, Windows.

Confidential

Web Programmer Student Employee

Responsibilities:

• Studied user requirements and converted them into formal Functional specifications while interfacing with the client.
• Created scripts to insert data into Microsoft SQL Server database from phpMyAdmin.
• Exported data to various formats CSV and SQL from phpMyAdmin web interface.
• Transforming stored data into any format using a set of predefined functions, like display-ing BLOB data as image or download-link
• Documented the process for exporting data to CSV and SQL formats from phpMyAdmin.

Environment: Microsoft SQL Server, SSIS, SQL Developer, Microsoft Office, phpMyAdmin.