SUMMARY

• Over 7 years of experience in writing SQL and PL/SQL scripts to generate the reports for the business users.
• Utilized Toad; developed and reviewed scripts to create tables, views, queries, etc.
• Designed, modeled, and implemented Data Warehouse and Data Mart tables, Indexes, Procedures and Packages.
• Designed staging tables and loaded them with fixed width and delimited source system data using SQL*Loader.
• Developed PL/SQL packages to load Data Warehouse and Data Mart tables to satisfy the user’s needs.
• Performed Unit and System Testing by developing automated test scripts via SQL.
• Experience in Designing the metadata and implementing ETL (Informatica) for the designed warehouse.
• Good Exposure to interaction with client and clear understanding of business.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing in a corporate - wide-ETL Solution using Informatica.
• Strong in developing Stored Procedures, Functions, Triggers, and packages utilizing PL/SQL.
• Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries.
• Experience in Dimensional Data Modeling using Star and Snowflake Schema.
• Extensively worked on Dimensional modeling, Data cleansing and Data staging of operational sources using ETL processes.
• Having one year of experience in AWS cloud applications.
• Hands on Experience with PostgreSQL By using Functions and stored procedures.
• Hands on experience with AWS Console and CLI on Ec2 Instances, VPC, IAM users, roles and Group Policies, Amazon S3 buckets Cloud Watch, Cloud Formation, Auto scaling, ETL process with AWS Glue and data warehouse concepts with AWS Redshift.

TECHNICAL SKILLS

Mercury Interactive: TestDirector9.0/8.0/7.5, Quality Center9.0/8.2

ETL Tools: Informatica 7.1/8.x, Data Stage 7.5

Programming/Scripting Languages: SQL, PL/SQL, XSLT, JCL, HTML, XML

Operating Systems: Windows XP/NT/2000, DOS, Mac 10.4, AIX UNIX, LINUX

Databases: Oracle 10g/9i/8i/7.3, MS SQL Server 6.5/7.0/7.5/2005 , Sybase12.0/11.0, MS Access 2005, Teradata V2R6/V2R5

Reporting Tools: Business Objects, Cognos 8.0, power BI

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

DWH/SQL Developer

Responsibilities:

• Developed Dashboards in Power BI tool.
• Designed the Power BI Model using Power BI Desktop.
• Worked on performance issue of views.
• Developed AP Invoice Import Request Set to import invoices from Excel and create them in Oracle.
• Worked on enhancement and SQL extract requests.
• Developed a report to display PO-Matched and Non-PO matched invoices.
• Worked on XML bursting to send perm close notification to vendor.
• Developed custom contract billing report for Service Contract Main Billing program.
• Worked on development of Aggregate Counter update program on a service contract.
• Developed Customer Contact PO Request Program which will load the data from csv file into staging table and create/update contact details for customer site contacts.
• Worked on building SQL queries for user stories related to AP, AR and CM Modules.
• Wrote conversion scripts using SQL, PL/SQL, stored procedures, functions and packages to migrate data to Oracle database.

Environment: Oracle 9i, 10g, 11g, PL/SQL, Forms 9i, SQL, BI Publisher, Power BI Desktop, Oracle

Confidential, Charlotte, NC

DWH/SQL Developer

Responsibilities:

• Wrote SQL, PL/SQL programs required to retrieve the data using cursors and exception handling.
• Worked on inbound and outbound interface issues.
• Created and modified PL/SQL scripts for data conversions.
• Creating indexes on tables to improve the performance by eliminating full table scan and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Troubleshooting day to day technical issues reported by users in production.
• Created data fix and then prepared GIT release.
• Customization of Packages, procedures and functions based on requirement.
• Developed Control file programs to load the legacy data into oracle staging tables.
• Developed PL/SQL package for Purchase Order data conversion.
• Improved the performance of the application by rewriting the SQL queries
• Developed and modified triggers, packages, functions and stored procedures for data conversion and PL/SQL procedures to create database objects dynamically based on user inputs.

Environment: Oracle 9i, 10g, PL/SQL, Forms 9i, Reports 6i, SQL, Oracle EBS

Confidential, Madison, NJ

SQL Developer

Responsibilities:

• Created PL/SQL procedures, triggers, views, functions.
• Gathered information about the transaction process, planning and development of the various screens.
• Responsible for designing database tables and writing SQL & PL/SQL procedures, functions.
• Developed various forms (screens) and some complex reports.
• Generated expected liability sheet containing loan no, name, amount disbursed, no of installments, gestation period.
• Written complex SQL queries for each level of data validation.
• Involved in creating both positive and negative test data to cover all business scenarios
• Experience in developing Complex Informatica mappings to extract, transfer and load the data from different sources.
• Experience in performance tuning the ETL process.
• Involved in extensive DATA validation using SQL queries
• Used SQL for Querying the DB2 database in UNIX environment
• Experience in performing System Analysis, tasks include, understanding the source systems, data flow and the data, relationship among multiple source systems etc.

Environment: Oracle 7.x, Informatica, Business Objects, Visual Café, Rational Rose, Clear Case, Clear Quest, Windows 2000, UNIX

Confidential, Reston, VA

SQL Developer

Responsibilities:

• Wrote Complex SQL to create reports directly from Oracle 9i using TOAD.
• Performance tuning of Creating Stored Procedures, functions, triggers as per requirement in Oracle 9i.
• Creating ER Diagram using ERWIN modeling tool. the long running SQL Queries.
• Installation and configuration of Cognos environment with Access manager and PPES.
• Developed Complex Reports on Product sales and Sales force activity using Impromptu.
• Created standard Reports like Monthly sales, Profit Margin by Product, employee timesheets and simple reports using Ad-hoc query.
• Created Catalogs, Hot files and snapshots based on requirements.
• Created different joins according to User requirements.
• Creating List, cross tab, chart, and sub reports using Cognos Impromptu.
• Created multi-dimensional cubes using Transformer.
• Testing and validating the data on Impromptu reports as well as Cognos Cubes.
• Created dimension views and user class views in Transformer.
• Scheduling web reports using Cognos Web Reports (Weekly, monthly etc.) and formatting the output.

Environment: Oracle 9i, Toad, Cognos Impromptu 7.0, Power Play 7.0, PowerPlay Transformer 7.0, Cognos Upfront, IWR, Erwin, Decision Stream, Windows 2000.