SUMMARY

• Over 7+ years of development experience as an PL/SQL Developer and Developer in Analysis, Design and Implementation of Business Applications using Oracle Relational Database Management System (RDBMS).
• Strong experience in translating business requirements into creation of Database Objects.
• Strong experience in writing Complex Database Objects like Stored Procedures, Functions, Cursors, Triggers and Database Administration.
• Strong experience in SDLC including Water fall and Agile Scrum environments in Data Migration projects.
• Experience in working with large and complex Data Warehouse systems.
• Experience in Loading and validating ETL data into the reporting data warehouse.
• Experience with ETL processing Data warehousing methodologies and processes using PL/SQL.
• Experience in Client Server application development using Oracle 11g/10g/9i, PL/SQL, SQL*PLUS, TOADAND SQL DEVELOPER.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and process flow.
• Experience in working all the stages of Data Migration.
• Worked extensively on Ref Cursor, External Tables and Global Temporary Tables.
• Experience in Dynamic SQL, Exception handling and Analytical Functions.
• Experience in database development and hands on experience working on various database activities like Tables, Views, indexes, sequences, materialized views, nested tables, types, Bulk Collect Functions, Procedures, Packages and Triggers.
• Excellent expertise in writing different types of SQL queries like Sub queries, Hierarchical and co related sub queries along with set operators.
• Extensive usage of Oracle collections and standard API's like DBMS LOB, UTL FILE etc. for business logic in user defined API's.
• Expertise in dealing with complex data models and object relational database mapping, while producing complex reports.
• Good Exposure to UNIX shell scripting.
• Proficient with PL/SQL object types, Oracle Parallel Queries, Materialized Views, Bulk Collects, Regular Expressions, FORALL, Merge, Multiple Table Inserts, Global Temporary tables, Collections, DBMS packages and exception handling
• Expertise in RDBMS software installation, database server builds, applying patches.
• Analyzed all informational requirements of new or production systems and developed database specifications.
• Worked closely with all Application/Development Teams that used Control - M Scheduling.
• Hands on experience in Data migration (ETL) across different databases via SQL scripts.
• Experience in project planning, scheduling, system design, white board sessions, impac analysis, code development, code review, system test plan, system testing, solution demonstration to stakeholders and post production support.
• Experience in requirement gathering, gap-analysis and solution design.
• Writing efficient SQL queries for data retrieval.
• Knowledge of Oracle Applications R12GL, Inventory, OM, AP, AR, PO modules.
• Expertise in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables and Dynamic SQL, Collections and Exception handling.
• Extensive experience in Performance Tuning of SQL queries & Views using Explain Plan, SQL Trace and TKPROF utilities
• Expertise in developing PL/SQL Stored Procedures, Packages, Functions, Triggers, Indexes, PowerShell scripting, Performance Tuning.
• Hands-on experience working with source control using Git and Github.
• Implemented SQL*Loader to load data into tables and also used Dbms Utility package.
• Experienced in Performance Tuning and analyzing using TKPROF, SQL Trace, and Explain Plan.
• Performed unit testing, system testing and UAT testing.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Excellent Knowledge in analyzing Data ware house by building cubes using SQL Server Analysis Services (SSAS).

TECHNICAL SKILLS

RDBMS: MS-SQL Server 2012/2008 R 2/2008/2005/2000 , MS Access, DB2,Oracle 9i/10g

SQL Server Tools: (SSMS)SQL Server Management Studio 2012/2014/2016 , SSIS, SSRS, SSAS, SQL Profiler, DTS, SQL Server Business Intelligence Development Studio, Power BI

Tools: Microsoft Visual Studio 2010/2008, Share Point Server 2007, Microsoft Project Server 2007.

Reporting Tools: SSRS (SQL Server Reporting Services), Tableau, Crystal reports

ETL Tools: SSIS (SQL Server Integration Services), DTS, BCP (Bulk Copy Program)

OLAP Tools: SQL Server Analysis Services 2012/2008/2005

Operating System: Windows 95/2000/2003/ XP/VISTA/7/8/8.1, LINUX, UNIX, Windows Server 2003/2007.

Business Tools: Office 2000/2003/2007/2010/2013/2016 (Word, PowerPoint, Excel, Project), Xcelsius

Web Development Tool: HTML, XML

Architecture: Relational DBMS, Client-Server Architecture, OLAP and OLTP

Methodologies: Agile, Waterfall

PROFESSIONAL EXPERIENCE

Confidential, MI

Sr. PL / SQL Developer

Responsibilities:

• Designed high performance mappings by using iterative variable logic in Expression Transformation.
• Performed unit and integrated testing.
• Worked with DBAs closely to optimize and distribute workflow across multiple networked CPU nodes.
• Involved in automation of batch processing to run Informatica Workflows using Autosys.
• Identify source systems, connectivity, and captured data using CDC techniques, tables, and fields, ensure data suitability for mapping.
• Developed complex mappings with transformations like lookup, Union, router, aggregator, expression, update strategy and joiner confirming to the business rules and documented.
• Implemented error handlings in mappings.
• Worked with the Business analysts and the DBA for requirements gathering, business analysis, testing, metrics and project coordination.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and Customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used Bash script for database connectivity using DBI which connects to backend database drivers.
• Developed UNIX Shell scripts to run various utilities & wrote UNIX Cron jobs for the scheduled batch processes.
• Created Shell Scripts and used Crontab in UNIX environment for scheduling routine tasks.
• Implemented High availability using Golden Gate Replication. Implanted Bi-directional replication using golden gate.
• Involved in designing ER diagram using VISIO, to set the logical and physical relationships of database.
• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
• Created Perl Scripts using DBI/DBD for data extraction.
• Used various CPAN Perl modules to enhance the functionality
• Wrote C++ scripts for Unit tester.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Creating and enhancing daily, monthly, yearly jobs using Perl and UNIX shell Scripting.
• Used Swing Concepts in Java Front End Forms are designed.
• Used Oracle JDeveloper Database tools to write triggers and procedures, Function.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF and AUTOTRACE.
• Used Bash script for database connectivity using DBI which connects to backend database drivers.
• Developed UNIX Shell scripts to run various utilities & wrote UNIX Cron jobs for the scheduled batch processes.
• Created Shell Scripts and used Crontab in UNIX environment for scheduling routine tasks.
• Used Toad for creating PL/SQL (trigger, sequence, stored procedure).
• Develop and manage moderate to complex PL/ SQL applications including - performance tuning with indexing, analyzing and SQL trace with reports; native compilation; Highly Complex Procedures, Triggers, Materialized Views; Bulk Collects, Bulk loads etc.

Environment: Flat files, Oracle 10g/9i RAC, Putty, Windows XP professional, Erwin 4.0, Toad, Tivoli, Unix scripting, Win SCP Oracle 10g, 11g, Java and XML, Java using JDBC, C/C++ using OCI. UNIX (Solaris), Informatica Power center 8.5

Confidential, Atlanta, GA

Senior PL / SQL Developer

Responsibilities:

• Involved in development, maintenance of Triggers, Joins, Cursors and Views.
• Developed procedures, functions and packages to implements the system's business logic using PL/SQL.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views in Development and Production environment in PL/SQL and SQL*Plus.
• Involved in maintaining and writing several PL/SQL Stored procedures and SQL queries for populating the daily and historical tables.
• Installed and configured OEM Grid control and intensively used Diagnostic & tuning packs along with AWR & ADDM reports.
• Created Shell scripts to access data and setup runtime environment, and to run Oracle Stored Procedures, Packages.
• Developed UNIX Shell Scripts, customized and developed Oracle Forms and Oracle Reports using Oracle Forms 9i/10g and Reports 9i/10g.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Extensively used various SSIS control flow tasks like Loop Containers, SQL Server Agent jobs, Script, FTP, Web service task, Bulk insert task, Transfer job task, etc. and different data flow tasks like Conditional split, Derived Column, Fuzzy lookup, merge join, Multicast, Union all, data conversion etc.
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like DTS, SSIS, BCP, BULK INSERT etc.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Worked with different methods of logging in SSIS.
• Experience in creating Table Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services2008 and SSRS 2012.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Optimized the performance using PL/SQL table types and record types.
• Worked on SQL and PL/SQL programming for ODI and oracle.
• Played a key role in designing the dimensional modeling of star schema for the enterprise data ware house of ODS.
• Participate in upgrading Oracle database (s) and Oracle Warehouse Builder to Version 11.2.0.4
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL)
• Built custom forms using Oracle Forms 9i/10g Builder to fulfill the business requirements of the client.
• Wrote SQL queries to developed test data for use during test execution.
• Wrote complex PL/SQL queries and performed data analysis. Worked extensively on performance tuning. Modified and enhanced the existing systems to in corporate new functionality and to optimize them for performance
• Modified and developed custom Oracle Forms and Reports as per client requirements using Oracle Reports builder 10g and Oracle Forms builder 10g respectively
• Worked on data migration and data conversion from the SQL server, DB2 to Oracle using Informatica and Oracle Data Integrator (ODI)
• Interacted with the data modelers and business analysts to understand the requirements and the impact of the ETL on the business
• Extracted data from flat files, DB2, SQL and Oracle to build an operation data source and applied business logic to load the data into the global data warehouse
• Perform Inbound Interface by creating Temporary tables, then Validate data and then Load into Interface Tables by using SQL Loader.

Environment: Oracle 10g / 11g/12c, SQL, PL/SQL, SQL*PLUS, SQL*Loader, Oracle Forms 9i/10g, Reports 9i/10g, CVS, TOAD, UNIX, Shell scripting, HP PPM, Oracle Warehouse Builder 11.2.0.2, Subversion (SVN), CVS, Perl.

Confidential, Boise, ID

PL/SQL Developer

Responsibilities:

• Worked on various kinds of transformations like Expression, Aggregator, Stored Procedure, Lookup, Filter, Joiner, Rank, Router and Update Strategy
• Designed and developed Informatica mappings and sessions based on the business user requirements and business rules to load data from source flat files and Oracle tables to target tables
• Tuned the Informatica mappings for optimal load performance
• Prepared migration documents to move the mappings from development to testing and then to production repositories
• Managed tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and scheduled workflow
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Have deployed packages on different servers by configuring it.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Created the environment for Staging area, loading the Staging area with data from multiple sources
• Developed data conversion/quality/cleansing rules and executed data cleansing activities such as data
• Consolidated, standardized and matched Trillium for the unstructured flat file data
• Developed reusable mappings and transformations
• Analyzed the business process workflow and assisted with the development of ETL procedures for moving data from Source to Target Systems
• Used SQL server SSIS tools to build high performance data integration solutions including Extraction, Transformation and Load packages for data warehousing. Extracted data from the XML file and loaded it into the database
• Designed and developed Oracle Forms and Reports generated up to 60 reports
• Monitored Sessions using the Workflow monitor, which were scheduled, running, completed or failed. Debugged mappings for failed sessions.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day. Used standard packages like UTL FILE, DMBS SQL, and PL/SQL collections and used BULK binding involved in writing database procedures, Functions and Packages for Front End Module
• Used principles of Normalization to improve the performance. Involved in ETL codes using PL/SQL in order to meet the requirements for Extract, Transformation, cleansing and loading the data from Source to Target data structures
• Involved in continuous enhancements and fixing production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams. Developed UNIX shell scripts to automate repetitive database processes

Environment: Java, Oracle 10g/11g, PL/SQL Developer, SQL*LOADER, Informatica, HTML, SSIS, TOAD, XML and UNIX shell scripting

Confidential

PL/SQL Developer

Responsibilities:

• Developed Stored Procedures, Functions, Packages and SQL Scripts using PL/SQL.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Used Tortoise SVN version control for changing the codes.
• Created SQL plus reports as per client's various needs, and developed business objects.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Defining processes for each department or service request category and building them in Right Now CX.
• Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.
• Used Ref cursors and Collections for accessing complex data resulted from joining of large number of tables in PL/SQL blocks and even have experience with exception handling.
• Developed SQL and PL/SQL scripts to transfer tables across the schemas and databases.
• Performed SQL and PL/SQL Performance tuning and Application Tuning using various tools like TKPROF, AUTOTRACE and DBMS SQLTUNE.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL Loader.
• Wrote conversion scripts using SQL, PL/SQL, Stored Procedures, Functions and Packages to migrate the data from the SQL server database to Oracle database
• Performed database administration of all database objects including Tables, Clusters, Indexes, Views, Sequence Packages and Procedures
• Implemented 11g and upgraded the existing database from Oracle 9i to Oracle 11g
• Performance tuned the Oracle databases and user applications
• Used SQL Loader as an ETL tool to load data into the Staging Tables
• Used DTS packages as an ETL tool for migrating data from the SQL Server 2000 to Oracle 10g
• Improved the performance of the application by rewriting the SQL queries
• Worked on various levels of SDLC (Software Development Life Cycle) including system analysis, high level design, coding and testing.
• Developed UNIX Shell scripts to automate table creation, execute procedures.
• Worked with java developers to repair and enhance current base of PL/SQL packages to fix production issues and build new functionality and improve processing time through code optimizations and indexes.
• Used ORACLE SQL DEVELOPER for creating PL/SQL (trigger, sequence, stored procedure).

Environment: Oracle 9i/10g, 11g, Json, Reports 9i, Oracle Right Now CX Console, SQL, PL/SQL, TOAD, SQL*Loader, Visual Basic 6, UNIX, UNIX Shell script, MS, Oracle Development Suite.

Confidential

Jr. PL/SQL Developer

Responsibilities:

• Developed PL/SQL Packages, Procedures and Functions accordance with Business Requirements for loading data into database tables.
• Created SQL*Loader scripts to load data into temporary staging tables.
• Worked on BULK COLLECT for bulk loading the data into various transaction tables.
• Created Views by joining multiple cash flow tables to show output as report to the user.
• Used File Handling in Oracle to read and write into files associated with the modules.
• Tuned pre-existing PL/ SQL programs for better performance.
• Used import export utilities such as UTL FILE for data transfer between tables and flat files.
• Worked with built-in Oracle standard Packages like DBMS SQL, DBMS JOBS and DBMS OUTPUT.
• Created multiple automated reports and dashboards sourced from data warehouse using Tableau/SSRS.
• Involved in Development of End - to - End Application from Data Transfer to Report Generation for User Analysis.
• Created multiple automated reports and dashboards sourced from data warehouse using Tableau/SSRS.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Performed SQL and PL/SQL query tuning and optimization using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Developed UNIX Shell scripts to automate various periodically repetitive database processes.

Environment: Oracle 9i, PL/SQL, UNIX, HTML, SQL *LOADER, SQL*PLUS, SQL, Tableau, WINDOWS XP.