SUMMARY

• Around 15+ years of It Experience in Development, Enhancement, Maintains, Production support, Data Modeling, PLSQL Programming, Architecture, Reporting, Unix Shell Scripting, Informatica, Reporting Including Business Requirements, System requirements gathering of Enterprise Data Warehouses of Health care, oil and gas, Inventory, online transaction, finance, Entertainment domains.
• Strong technical hands - on experience in Oracle 19c/12c,11g/9i databases, Informatica power center 8.x, 7.x, 6.x, SQL Server 20012,2006,2008.
• Expertise in designing and developing Informatica Mappings from varied transformation logic using filter, expression, rank, router, aggregation, joiner, lookup and update strategy.
• Experience in Extraction, Transformation and Loading of data from heterogenous sources systems like flat files, Excel, XML, oracle, SQL Server.
• Experience in Data Modeling using Dimensional Data Modeling, Star/Snowflake Schema Modeling, FACT And Dimensional tables, Physical and logical data modeling, using Erwin.
• Expertise in Documentation skills like specifications documents and technical documentations, Use Cases, Class Diagrams, Collaboration Diagrams, Sequence Diagrams, Deployment diagrams, Activity Diagrams etc.
• Extensive experience in Oracle Back-end (server-side) PL/SQL Development i.e., Packages, Stored Procedures, Functions & Triggers using SQL Developer and Toad as development tools.
• Extensive experience in developing applications using tools like oracle Forms 9i/6i, Oracle Reports
• Having Strong experience in features of PL/SQL like collections, nest table, ref cursors, materialize views and dynamic SQL.
• Having Strong experience in table/index partitioning and data purging techniques.
• Integration of Different Applications with JSON, XML and Web Services.
• Extensively used Attributes like %TYPE and %ROWTYPE data types
• Extensively used Oracle Joins- Inner Join, Left Outer Join, Right Outer Join, Full Outer Join
• Performed regular SQL performance tuning, fixed common SQL performance issues, like inefficient indexing and unoptimized SQL queries
• Extensive experience in using the Oracle system packages UTL FILE, UTL MAIL and UTL SMP.
• Developed, scheduled Microsoft SSIS packages to extract Data from remote systems
• Extract the data from different data sources using Python Scripting
• Developed Applications using Core Java, J2EE, Python
• Strong knowledge and experience in Unix/Linux Shell Scripting, Cron jobs
• Extensively involved in all the phases of SDLC (Software Development Life Cycle).
• Well versed with Agile Project Management System (KANBAN) and JIRA.
• Active contribution to application lifecycle including maintenance, release management, critical bug fixing and ensure error free delivery of the software solution.

TECHNICAL SKILLS

Data Modeling Tools: ER/Studio 2016, 9.7/9.5/8.5, Erwin r 9.7/7.5.8/4.1.4 , Power Designer 12.1, Rational Rose, and Visio 2016/2013

Database Systems: Oracle (19c/11c/10g/9i/8i), SQL Server (2005,2008,2014,2019)

Development Tools: SQL*Plus, SQL Developer, TOAD 9.6/11/12/16, Shell Scripting, Cron Jobs, PLSQL Developer, Oracle Forms & Reports, Python 1.4/1.5

Software Engineering: UML using Visio

Office Applications: MS Office Professional Plus 2016/2013/2010/2007 (Word, Excel, PowerPoint)

Configuration Management: Visual Source Safe and Concurrent Version Control, Git

Operating Systems: Windows 95/98/2000/XP, Linux, AIX

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, North Carolina

Lead Data Warehouse ETL Developer/ Lead PLSQL Developer

Responsibilities:

• Design and Implementation of ETL Pipelines & ETL Feeds.
• Used various transformations like expression, union, joiner, source qualifier, aggregator, sequence generator, router, store procedure, lookup transformations.
• Shell scripting done to move data from Unix environment to Oracle database
• Designed and deployed workflows in shell scripts to periodical update of products feeds.
• Understanding business data of the facility and developing query and reporting specifications
• Designed, deployed, configured, and maintained SQL and PL-SQL solutions
• Schedules corn jobs to automate the feed loads.
• Performed regular SQL performance tuning, fixed common SQL performance issues, like inefficient
• Develop mappings with XML as target and formatting the target data according to the requirement.
• Work with various data sources--relational, flat file (fix width, delimitate) and XML.
• Create functional and technical mapping specifications and documentation for QA team.
• Maintained data integrity during extraction, manipulation, processing, analysis and storage.
• Maintained repository objects, services and scripts from development environment to production environment.
• Wrote queries, and stored procedures and followed company reporting and analytical needs
• Developed and maintained complex data storage structure and provide support to data warehouse functions
• Performed regular SQL performance tuning, fixing common SQL performance issues, like inefficient indexing and unoptimized SQL queries
• Developed documentation process to maintain international and existing business data
• Creating data flow diagrams and constructing data decomposition diagrams
• Designing, testing, implementing, and maintaining physical and relational databases
• Coordinating with systems analysts and designers for storing and deleting data

Environment: Oracle 19c, Python 1.5/1.6, Informatica PowerCenter 9.0x/9.5, AIX, Git, DevOps, AIX, Toad for Oracle, Jira, Windows, XP, XML, Excel, Access, Visio

Confidential, Dallas, TX

Lead Data warehouse ETL Developer/ Lead PLSQL Developer

Responsibilities:

• Design and Implementation of ETL Pipelines & ETL Feeds.
• Developed Informatica Mappings from varied transformation logic using filter, expression, rank, router, aggregation, joiner, lookup and update strategy
• Shell scripting done to move data from Unix environment to Oracle database
• Create functional and technical mapping specifications and documentation for QA team.
• Maintained data integrity during extraction, manipulation, processing, analysis and storage.
• Performed regular SQL performance tuning, fixed common SQL performance issues, like inefficient
• Maintained repository objects, services and scripts from development environment to production environment.
• Wrote queries, and stored procedures and followed company reporting and analytical needs
• Developed documentation process to maintain international and existing business data
• Designed, deployed, configured, and maintained SQL and PL-SQL solutions
• Designed and deployed workflows in shell scripts to periodical update of products feeds.
• Developed and maintained complex data storage structure and provide support to data warehouse functions
• Designing, testing, implementing, and maintaining physical and relational databases
• Coordinating with systems analysts and designers for storing and deleting data

Environment: Oracle 12c, Informatica PowerCenter 9.0x/9.5, SQL Server 2000/2005/2008 , Informatica Power center 8.1, Erwin 7.5.8, Windows 7, XML, Excel, Visio

Confidential

ETL/Lead PL/SQL Developer /Data Analyst

Responsibilities:

• Developed Informatica Mappings from varied transformation logic using filter, expression, rank, router, aggregation, joiner, lookup and update strategy
• Designed and deployed workflows in shell scripts to periodical update of products feeds.
• Wrote queries, and stored procedures and followed company reporting and analytical needs
• Developed and maintained complex data storage structure and provide support to data warehouse functions
• Developed documentation process to maintain international and existing business data
• Creating data flow diagrams and constructing data decomposition diagrams
• Designing, testing, implementing, and maintaining physical and relational databases
• Coordinating with systems analysts and designers for storing and deleting data

Environment: Oracle 12c, Oracle PL SQL, Informatica Power center, Data Warehouse, Java Web services

Confidential

Senior System Analyst / Senior Oracle Developer

Responsibilities:

• Preparation of Documents Use Cases, Class Diagrams, Collaboration Diagrams, Component.
• Diagram, Sequence Diagram, Deployment diagram, Activity Diagrams etc.…
• Development of applications using the forms 6i/9i and reports 6i/9i on Oracle 11g.
• Development of complex reports to meet the user requirement by using oracle Reports 6i/9i
• Creating Tables, Views, Materialized Views, Global temporary tables.
• Coding of Procedure and Packages in PL/SQL developer.
• Integrating Procedures with Cursors.
• Created triggers, functions as per the Client specification.
• Involving in integration of modules, unit testing and system testing.
• Maintenance of the Implemented system, attending the critical Errors.
• Developed Application using Oracle system packages UTL FILE, UTL MAIL, UTL SMP etc.

Environment: Oracle 11g, PL/SQL, Forms 6i, Reports 6i, Windows XP, Windows 10 and MS Visio

Confidential

Oracle Developer

Responsibilities:

• Preparation of Documents Use Cases, Class Diagrams, Collaboration Diagrams, Component.
• Diagram, Sequence Diagram, Deployment diagram, Activity Diagrams etc.
• Performing code reviews with analysts and application architects.
• Development of applications using the forms 6i/9i and reports 6i/9i on Oracle 11g.
• Development of unit and system test plans.
• Development of complex reports to meet the user requirement by using oracle Reports 6i/9i
• Creating Tables, Views, Materialized Views, Global temporary tables.
• Coding of Procedure and Packages in PL/SQL developer.