SUMMARY

• 14 plus years of extensive Software Development Life Cycle experience.
• Extensive experience in Data Analysis, Testing and Validations
• Experience in ETL process using Teradata, Informatica, Syncsort, Alteryx
• Solid Development experience with SQL/PL/SQL (procedures / functions) and Oracle Forms/Reports.
• Experience in Data Warehousing, Batch processing, Performance Tuning, Data Modeling, Explain plan, Tkprof, Sqlloader, Utl File, Import - Export utilities, and Unix Shell scripting.
• Experience in export, import and SQL*Loader utilities and worked on high volume OLTP, OLAP databases.
• Created complex functions, stored procedures, pkgs and triggers using PL/SQL.
• Created Interfaces using PL/SQL to do the data transactions between different Systems.
• Created Oracle Forms & Reports using 6i/9i/10g & Crystal Reports9/10/Business Objects XIR2/BIRT, DOMO.
• Experience in conducting Requirement and Systems Analysis, Feasibility Studies, Design Reviews, Plan Reviews, Implementation and Post Implementation surveys.
• Worked on design, development, implementation testing of applications, unit and system testing on database.
• Experience with Informatica Power Center in all phases of Analysis, Design, Development, Implementation
• Supported Data Warehousing applications using Informatica Power Center 10.x/9.x
• Experience in Star and Snowflake schema addressing Slowly Changing Dimensions (SCDs).
• Strong DBA skills and extensive experience with Unix shell scripting, unit testing, logical and physical database design, performance tuning, database security maintenance and Shell scripts for batch processing.
• Good Knowledge in AWS, Data Lake, AWS Athena, and working on Cloud Environment.
• Worked as team using Agile-Scrum Methodology to achieve the goals.

TECHNICAL SKILLS

• Sun Solaris, Linux, HP-UX, Windows NT /98 /2000/, MS-DOS
• Oracle 8i/9i/10g/11g/12c, Teradata 15, SQL Server 2005/2008, Ms Access
• P L/SQL 8i/9i/10g/11gSQL Server 2005/2008/2016 Oracle Forms & Reports 6i/9i/10g/11g Discoverer, Designer
• OBIEE, Oracle Answers, Dashboard, IBots
• SQL Server 2005 ReportsCrystal Reports 9/10, Business Objects XIR2,DOMO
• Oracle Application Server 10g, Web Logic serverOracle Apex, HRMS/Payroll (11i)
• Explain plan, TkProf,
• Informatica, Syncsort, Alteryx
• Oracle Enterprise ManagerSQL*Plus, SQL*LoaderToad 9.0,SQL Developer, Pl/Sql DeveloperInformatics, MS Visio, Subversion, Reflection
• Erwin, Unix Shell ScriptingVBA, VB 6.0, VB.Net,++, Perl, Pro*C, JavaOracle SCM, JavaScript, HTML, XML

PROFESSIONAL EXPERIENCE

Confidential - St. Louis, MO

SQL- ETL- Developer

Responsibilities:

• Worked on data analysis, Unit testing and created interfaces using SQL/PLSQL.
• Worked with different teams to review the business rules and user requirements.
• Worked with Business Analysts, Testers and Release management, etc.
• Designed and developed custom tables, procedures, and functions.
• Used Oracle Explain Plan to do the performance tuning of the SQ/PLSQL
• Worked with users and business group to create the functional requirements.
• Extensively worked with DOMO Dashboard/Reports with beast mode and drill down capabilities.
• Worked on Informatica Power Center ETL tool to load data from different sources.
• Written complex SQL to extract, transform and load data to destination tables.
• Designed and developed complex ETL mappings by making use of different transformations
• Used transformations, Joiner, Update Strategy, Connected Lookup, Expression, Router, Filter.
• Worked on Slowly Changing Dimensions Type 1, Type 2 and Type 3
• Worked on documentation for gap analysis and technical design to move data between systems.
• Extensively used ETL to load data from flat files to Oracle on Cloud environment.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Error checking and testing of the ETL procedures and programs using Informatica session log
• Testing and Debugging of Informatica Mappings, Mapplets, Sessions, Tasks, Worklets and Workflows
• Worked on data integration, data profiling, Analyzed and customized many processes by using SQL/PLSQL.

Environment: SQL/PL/SQL, Oracle 11g, Informatica PowerCenter 10x, DOMO Reports with Redshift/MySQL, AWS, Linux, Unix Shell, ALM Ticket Tracker, SQL/PL/SQL Developer, Putty, Explain Plan, SQL*Plus, Confluence, BIRT Reports (4.4)

Confidential - St. Louis, MO

SQL-ETL Developer

Responsibilities:

• Worked on data analysis and created interfaces using SQL/PLSQL.
• Worked with different teams to review the business rules and user requirements.
• Created ETL Jobs using Teradata to get data from various systems.
• Created Load tables, Dimension and Fact tables, Indexes, etc.
• Worked with Business Analysts, Testers and Release management, etc.
• Worked on data validation and testing the data quality.
• Designed and developed custom tables, views packages, procedures, and functions.
• Worked on logical database design and data modeling.
• Extensive testing done on the programs to achieve accuracy & timely processing of data.
• Worked with users and business group to create the functional requirements.
• Heavily optimized the code for high performance.
• Explain Plan, Skew Factor, collect stats, etc. were used for SQL tuning.

Environment: Teradata 15.10, Unix Shell, JIRA Ticket Tracker, SVN, TOAD, SQL, Putty, Core FTP, Explain Plan, SQL Assistant 16.20 etc.

Confidential - St. Louis, MO

SQL-ETL- Developer

Responsibilities:

• Worked on SQL/PL/SQL statements and procedures.
• Worked with different teams to review the business rules and user requirements.
• Created ETL Jobs using Informatica to get data from various systems.
• Worked with Business Analysts, Testers and Release management, etc.
• Experience in Slowly Changing Dimensions Type 1, Type 2 and Type 3
• Worked on data integration, data catalogs, data profiling.
• Designed and developed custom tables, views packages, procedures, and functions.
• Worked on logical database design and data modeling.
• Worked on mapping and technical design document
• Worked with various teams to do the gap analysis
• Used transformations, Joiner, Update Strategy, Connected Lookup, Expression, Router, Filter.
• Involved in the development of Informatica mappings and tuned for better performance.
• Worked as team using Agile Scrum methodology to achieve the goals
• Extensive testing done on the programs to achieve accuracy & timely processing of data.
• Analyzed and customized many processes and reports by using SQL/PL/SQL.
• Responsible for Performance Tuning at the Mapping Level, Session Level, Source Level and the Target Level
• Worked with users and business group to create the functional requirements.
• Heavily optimized the code for high performance.
• Used Oracle Explain Plan to do the performance tuning of the SQL.

Environment: Oracle 11g, Informatica PowerCenter 9/10, Teradata, Unix Shell, JIRA Ticket Tracker, SQL/PL/SQL Developer, Putty, Core FTP, Explain Plan, SQL*Plus, Bitbucket, Materialized Views, TOAD (11.6)