SUMMARY

• Over 12 years of experience in IT industry mainly in Design, development, implementation, testing and documentation of business applications using Oracle technologies, Analytical Databases (IBM Netezza), HP Vertica and hands on experience in Tableau and ETL tool (Informatica) and SAP Business Objects.
• Experience in working with relational databases Oracle 11g/10g/9i/6i & SQL Server 2005/2008/2012 & Sybase ASE 15.0.
• Experience in working with Analytical databases IBM Netezza 7.2.0, Vertica 7.1.
• Generated reports using Tableau, SAP Business Objects Webi 3.0.
• Experience in Application Development using Oracle Forms 10g/9i/6i, Oracle Report builder 10g/9i/6i.
• Experience in designing and developing real time, high throughput data pipelines involving AWS S3,postgres, streamsets, kafka persisting the data in elastic search.
• Experience in packaging the microservices in docker containers and deploying in DC/OS. Good understanding of Continuous Integration/ Continuous Deployment (CI/CD) process.
• Collecting and saving pipeline metrics in influx (time series database) and creating dashboards in Grafana for visualizing, monitoring and alerting on the availability and quality of the data pipelines.
• Worked on Tableau in creation of metrics, attributes, filters, reports, and dashboards. Created advanced chart types, visualizations and complex calculations to manipulate the data. Act as a Point of Contact in Data Interoperability, Analytics and BI and Production Support issue resolution. Creation of metrics, attributes, filters, reports, and dashboards.
• Knowledge of Data Modeling for RDBMS and data warehouse implementations.
• Experienced in using Oracle tools and utilities for Extraction, Transformation and Loading (ETL) like TOAD, SQL*Loader, UTL FILE and Informatica.
• Experienced in Tuning: Used AWR, ASH, ADDM and Explain plan and TKPROF for SQL/PLSQL Tuning; Used STATSPACK for performance tuning and tuning SGA, me/O distribution.
• Extensive experience in UNIX shell scripting and scheduling dbms jobs using Crontab to monitor the batch processing.
• Experienced in working in a production support team.
• Strong problem - solving, self-learning, verbal & written communication skills. Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment.

TECHNICAL SKILLS

Operating Systems: Windows 2000/XP/Vista/7/8.1/10, Mac OS, Unix, Linux

Languages: Oracle SQL, PL/SQL, T-SQL Netezza SQL (nzsql, nzload), PSQL

Scripting Languages: Linux and Unix Shell Scripting (korn, bash, C), Python

Databases: Oracle9i, 10g,11g (RAC), IBM Netezza 7.2.0, Vertica 7.1, SQL Server 2008/2012, Sybase ASE 15.0, PostgreSQL

Versioning Tools: Subversion, Clearcase, Microsoft Visual Source Safe and git

Deployment Tools: Docker, DC/OS, Jenkins CI, Artifactory

ETL Tools: Informatica, Streamsets

Job Scheduling Tools: ControlM, Cron-job

Reporting Tools: Tableau, Grafana, SAP Business Objects, Oracle Reports

File Transfer utilities: ftp, sftp, scp

Data Pipeline skills: streamsets, kafka, elasticsearch, grafana, influx

Tools: ERwin, SQL*Plus, PL/SQL Developer, TOAD Developer

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr Software Engineer

Responsibilities:

• Worked with Business Analyst and Senior Architect to understand the requirement and high level technical guidelines on implementing the requirement.
• Created Detail Design document for each requirement with data flows diagram and technical aspects of implementing the requirement. Technical aspects include SQL code, frequency of data update and assumptions made(if any).
• Built a real time dealer data warehouse (Symphony) for Caterpillar to replace the legacy application that is used for analyzing the opportunities, leads and gaps in the dealers’ business and advice the dealers.
• Symphony is built using attunity (real time replication) loading data in postgres real time which is streamed to elastic search real time by streamsets (ETL tool) through kafka.
• Symphony required mapping complex dealer data in postgres to Uptake’s target data model implemented in elastic search.
• Created Rich dashboards Using Tableau Dashboard and prepared User stories to create compelling dashboards to deliver actionable insights.
• Act as a point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Gatheird data pipeline metrics in influx as time series data and developed Grafana dashboards for alerting and monitoring on the data pipeline (availability and quality)
• Conducted code reviews with peers and assisted team members with better performance.
• Performance Tuning of SQL statements on relational databases using HINTS, INDEXES utility and EXPLAIN PLAN.
• Performed Error Handling and Debugging of bugs .
• Extensive practice with following standard deployment procedures by checking code in to source control,
• Worked on issues/tickets with QA team.
• TEMPEffectively addressed issues raised by QA team by fixing the code and logging comments in JIRA.
• Conducted deployment meetings to consolidate items across the teams

Environment: PostgreSQL, Tableau, Kafka, Elastic Search, Attunity, Python, Docker, DC/OS, streamsets, Grafana, influx, airflow, GIT Source Control

Confidential, Chicago, IL

Sr Database Developer

Responsibilities:

• Worked with Business Analyst and Senior Architect to understand the requirement and high level technical guidelines on implementing the requirement.
• Created Detail Design document for each requirement with data flows diagram and technical aspects of implementing the requirement. Technical aspects include SQL code, frequency of data update and assumptions made(if any).
• Used ELT methodology to transform ODS data and load into fact tables in Vertica.
• Created complex scripts using VSQL Scripts.
• Loaded data into Data Mart in Netezza.
• Created several Functions, Procedures, Packages and Triggers as per the business requirements.
• Developed Complex SQL queries using various joins and analytical functions for calculations on ODS data.
• Created database objects like Tables, Indexes, Sequences and Materialized Views.
• Conducted code reviews with peers and assisted team members with better performance.
• Worked on Informatica Mapping Designer & Workflow Monitor for mapping data across heterogeneous databases.
• To get data from other systems wrote SQL loader and PL-SQL scripts.
• Performance Tuning of SQL statements on relational databases using HINTS, INDEXES utility and EXPLAIN PLAN.
• Performance Tuning on Analytical database by restricting data movements across different SPU’s overwriting certain system parameters, matching data types when used in join conditions, using UDF functions.
• Performed Error Handling and Debugging of bugs in PL/SQL programs.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Transformed TABLEAU into a managed service offering for consumption to make decisions..
• Extensive practice with following standard deployment procedures by checking code in to source control, listing deployment items in change request, supporting with deployment
• Helped with Periodic database Refresh/CLONING from production to Development and QA environments, maintaining database standards, Reviews, Documentation.
• Worked on issues/tickets with QA team.
• TEMPEffectively addressed issues raised by QA team by fixing the code and logging comments in JIRA.
• Worked on call rotation for Production support.
• Conducted deployment meetings to consolidate items across the teams

Environment: IBM Netezza 7.2.0, Vertica 7.1, SQL Server 2008/2012 standard and Enterprise editions. Informatica Power Center 9.6.1/9.5, SQL Developer, Aginity, Dbeaver, GIT source control, BMC remedy.

Confidential, Oakton, VA

Sr Database Developer

Responsibilities:

• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Worked on Sybase ASE 15 to Oracle 11g database migration project. Worked on development of project called Third Party Transport (3PT) and also involved in enhancements and customization of existing CIS application as per business requirements.
• Extensively used Oracle Migration Workbench tool to convert T-SQL Scripts to PL/SQL scripts in Sybase to Oracle migration project.
• Generated Reports using SAP Business Objects Webi.
• Worked on several enhancement projects which are based on Agile methodology.
• Fixing the code errors/bugs in the stored procedures, functions, packages, triggers which caused during migration of Sybase to Oracle scripts using oracle migration workbench tool.
• Involved in the creation of the technical specification (HLD/AD) document based the functional requirements for various projects.
• Created several Functions, Procedures, Packages and Triggers according to the Clients requirements in further enhancement projects.
• Written Stored Procedures to perform Validation and Loading of invoice data and to move invoice data from staging tables into master tables.
• Extensively used Refcursors, Global temporary table, PL/SQL Collections for accessing complex data resulted from joining of large number of tables.
• Tuning the performance of SQL statements using HINTS, INDEXES and procedures using TKPROF utility and EXPLAIN PLAN. Developed a set of views to fine tune the performance tuning process.
• Performed Error Handling and Debugging of bugs in PL/SQL programs.
• Written several procedures, this uses explicit cursors to select data and exception handlers to raise errors.
• Developed Complex SQL queries using various joins and also extensively used various dynamic SQL’s in stored procedures and functions.
• Created database objects like Tables, Indexes, Sequences and Views.
• Responsible for writing and modifying shell scripts in UNIX.
• Developed UNIX scripts to process and load the data in the incoming files. Created CTL files to load the data into Oracle database using SQL Loader.
• Extensive UNIX shell scripting being done to make procedure calls to the database and trapping the return codes from the shell scripts to no if the called procedure ran successfully.
• Wrote the Shell script to call SQL loader and PL-SQL scripts and to get the data from other systems and to & from our server to other server via FTP, Connect Direct.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process, maintained the batch processes using the Shell scripts.
• Optimization of SQL queries using TRACE FILE, TKPROF, EXPLAIN PLAN.
• Involved in developing analytical SQL queries for reports using various grouping sets, analytical functions, pivoting, cross-tabs, etc.
• Extensively used new features in 11g like RESULT CACHE to improve the performance of functions and DBMS PARALLEL EXECUTE to optimize the data intensive DML statements by dividing the tasks into smaller chunks.
• Periodic database Refresh/CLONING from production to Development and QA environments, maintaining database standards, Reviews, Documentation.
• Created SQL*plus reports as per client's various needs.
• Unit testing the developed code by creating test tables and by exporting/importing required data from higher environments to meet all the test scenarios.
• Rectification of errors reported during System Test and User Acceptance test.
• Analysis of customer reported issues, which could be a code issue, data fix issue, performance issue, setup issue, functional issue using AOTS Remedy Ticketing System.
• Worked on production issues/tickets with production support team.

Environment: Oracle 11g, Sybase ASE 15.0, SQL, PL/SQL, T-SQL, Toad 11.6.1, SQL Developer, SQL*Plus, AOTS Remedy 7.5, SQL*LOADER, WinSCP, Putty, UNIX Shell Scripting, SAP Business Objects Webi 3.0.

Confidential

Team Lead

Responsibilities: -

• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Identification of the database objects required for supporting the business requirements like tables, views, indexes, stored procedures, functions, database triggers, and synonyms.
• Translating business rules into procedures, packages, database triggers and functions using PL/SQL.
• Wrote complex SQL queries for reports and PL/SQL code for report triggers Before/after for validation of user input.
• Individually responsible to work out the User Interface (UI) and designed templates and setup forms for the data entry and for data retrieval in Forms 10g.
• Wrote code for Form-level, Block-level and Item-level validation of data in Oracle Forms using PL/SQL.
• Designed master detail reports in Oracle Reports 10g to meet the requirements of end users.
• Developed basic user interfaces & screen designs with Oracle Forms developer
• Used Materialized view to create a Monthly Snapshot from the Filed Reporting.
• Involved in writing complex procedures using Oracle 10g features like Bulk collect, FORALL loop, Collection Type, Object Type & Autonomous transactions.
• Used Collections like variable arrays, nested tables.
• Worked with performance tuning issues of SQL queries.
• Involved in the development of Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Data migration from Flat Files have been uploaded into Staging Tables using SQL* Loader.
• Written Shell Scripts for automation of some daily tasks which were scheduled in Autosys.

Confidential

Oracle Developer

Responsibilities:

• Worked in all aspects of Software Development Life Cycle (SDLC).
• A detailed study of user requirements and system requirements. Translated requirements and functional designs into technical designs.
• Developed triggers, packages, procedures and functions using PL/SQL.
• Created database objects like Tables, Views, Indexes using Oracle tool - SQL Developer, Toad.
• Used Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Involved in performance tuning across the huge database having million’s of records in multiple tables.
• Creating custom Oracle reports and modules using PL/SQL extensions.
• Troubleshoot and debug system and/or data errors.
• Documented all PL/SQL procedures and user guide for different processes followed.
• Involved in installation of Oracle 10g and also migration from Oracle 9i to Oracle 10g.
• Worked with Business users closely to get the requirements for adhoc requests.
• Developed Dynamic SQL and Shell scripts.
• Developed shell scripts to send notifications after the process of data creation is complete.
• Write UNIX scripts to upload data from text files (and control files) to the database using SQL*Loader.
• Performed certain DBA duties like creating users and giving grant options
• Responsible for analyzing, designing and coding of the applications by utilizing the Perl.
• Wrote Shell scripts to generate success or failure notification to on call production support.
• Written UNIX shell scripts to automate the execution of PL/SQL procedures, packages and have them run automatically in cron tab.

Environment: Oracle 11g/10g/9i, PL/SQL, TOAD, SQL Developer, Shell scripting(Bourne and Korn), Unix Editors Vi,, Putty, WinSCP, SQL*loader, AIX 5.6, Windows XP.