SUMMARY

• Over Nine years of experience in analysis, design, documentation and development of custom applications using Oracle SQL and PL/SQL, working on various versions including Oracle Database 9i/10g and 11g and SQL Server.
• Winner of Sustaining Edge for Excellency in application development and proving the Single handed support for Consumer Business project during production deployment
• Having good experience in working with OLTP and OLAP databases in production and Data ware Housing Applications.
• Expertise in creating databases, users, tables, triggers, views, stored procedures, functions, Packages in Teradata database.
• Extensively worked with Teradata utilities like Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Proficient in developing and maintaining various PLSQL/Database objects like packages, functions, stored procedures, triggers, tables, Views, Materialized views, Indexes, Sequences, partitions.
• Hand on experience with ETL and MDM (Master Data Management) tool IBM Data Stage in creating jobs using the parallel processing jobs and Oracle Stored Procedures and Unix scripting.
• Hands on experience with creating jobs on Talend Open Studio.
• Experience on Logical & Physical Designing of Databases. Data Modelling, Conceptual Design & Data Architecture. Extensive use of Erwin as a modelling tool.
• Experience in developing SQL*Loader control programs and PL/SQL validation scripts for validating the data load from staging area to production
• Skilled at UNIX commands for writing scripts and batch processes
• Hand on experience with ETL tool IBM Data Stage in creating jobs using the parallel processing jobs and Oracle Stored Procedures and Unix scripting.
• Expertise with Data stage Designer to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Extensively used Parallel Job Stages like Stored Procedure, Dataset/Fileset, Aggregator, Join, Transformer, Sort, Merge, Filter, Modify, Lookup, Funnel and Pivot.
• Experience on Logical & Physical Designing of Databases. Data Modelling, Conceptual Design & Data Architecture. Extensive use of Erwin as a modelling tool.
• Adept in using Oracle Tools like SQL Developer, SQL* Plus, Toad, SQL Loader, Data Loader, SQL navigator.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
• Extensive experience in Design and Development of Interfaces or Integrations, both inbound and Outbound working on various file formats ranging from CSV, DAT, XLS, Pipe - delimited, Position- Delimited, XML
• Experienced in developing forms using Oracle Forms, and Reports using Oracle Reports 6.0/6i/9i/11g.
• Very good at Analytical and Problem solving skills
• Exposure to Waterfall and AGILE software development methodologies
• Good player in the implementation of SCRUM methodology. Created tasks and daily reports of the work status using Rally tool for Agile.
• Implementation of development tasks effectively in Sprints as per the user stories.
• Proficient in various Oracle seeded utilities like SQL*Loader, UTL File, Export/Import, External Tables, BULK for data load and files processing.
• Performed SQL tuning, DB performance enhancement tasks for the performance and speed of execution of database objects and performed dynamic SQL embedding and execution
• Experience in performance tuning and SQL optimization using (Hints, Explain Plan).
• Proficient in restructuring tables, de-normalization of tables and building Materialized views.
• Very good understanding of Object Oriented Programming and Professional GUI designer
• Good understanding of Data modeling concepts ER Diagrams, UML, Use Cases, Normalization and De-normalization of Tables.
• Strong analytical skills with ability to follow project standards and decision-making capability.
• Quick learner and possesses ability to attain a high degree of accuracy in work.
• Self-motivated, creative team player with effective communication and leadership qualities.
• Hard and Smart worker, maintain healthy relation with team and colleagues

TECHNICAL SKILLS

Languages: SQL, Oracle PL/SQL, JAVA, C, PostgreSQL, Python

ETL tools: IBM Data Stage 8.1, Data Transformation Services (DTS), Talend(basics)

Scripting Language: Java Script, Unix Shell Scripts, HTML, HTML 5, Jquery

RDBMS/DBMS: Oracle 10g/11g, SQL Server2008, Postgres, MY SQL, DB2, Teradata, Amazon-RDS

Operating systems: Windows 7/XP/2003/2000, UNIX, LINUX

Developer Tools: SQL*PLUS, SQL Developer, TOAD, for Oracle, Oracle Developer Suite(Forms and Reports), BI Publisher, PL/SQL Developer, Aquadata Studio

Data Modeling Tools/OtherTools: TOAD Data Modeler, Erwin 4.0/7.x Data Modeler, Putty, Aquadata studio Modeler, Jira, Confluence,Team Foundation Server(TFS), BitBucket for Git, Slack communicator.

Methodologies: Agile, Waterfall, SDLC.

Other skills: MS Office (Project, Publisher, Excel, Word, PowerPoint), Dream Weaver

Oracle Utilities: SQL*LOADER, UTL FILE, Export/Import, Data Pump, Golden Gate.

Ticketing systems: HP Quality Center, Service Center, ITG Request(Internal tools).

PROFESSIONAL EXPERIENCE:

Confidential, Lexington, MA

Software Engineer

Responsibilities:

• Analyze requirements to develop ad-hoc SQL statements to correct issues.
• Design performant solutions, addressing race conditions and database locks.
• Responsible for the implementation of SQL stored procedures, functions, etc.
• Troubleshoot and debug database issues to identify solutions and contribute to the maintenance of data models and database documentation.
• Present ideas and recommendations that may have an impact on existing or future systems and applications, products, services or procedures and business processes.
• Adhere to the development process and suggests improvements where appropriate.
• Responsible to produce high-quality code with minimal defects.
• Actively seek to minimize code and simplify architecture.
• Work with software engineers to optimize SQL.
• Provide mentoring and support for Junior Team members as required.
• Document findings and solutions as appropriate and required for the development and QA team.
• Work on Amazon RDS for database services like maintenance and administration.
• Used Bitbucket/Github for Git pull and push requests.
• Worked with multiple developer IDE’s like Toad, SQL Developer and Aqua data Studio.
• Crated functions on Aurora PostgreSQL database environment.
• Created entity- relationship diagrams using Lucid chart/Aquadata studio ER tools.
• Work with Devops for automation and deployments.

Environment: Oracle 12c/11g, SQL Developer, Toad, AquaData Studio, Amazon-RDS, Camunda BPMN, Jenkins, Lucid Chart, Confluence, Bitbucket-SourceTree, Docker, Devops, Amazon Auora PostgreSQL.

Confidential, Providence, RI

Programmer Analyst

Responsibilities:

• Responsible for requirement gathering, analysis, design and development of complex procedures to support the Angular code developers to create the front-end screens.
• Created methods and functions using collections especially Varrays and nested tables.
• Used dynamic SQL to process the DDL and DML statements for a set of tables.
• Worked on Oracle forms 12c to create some user screens and troubleshoot the backend code for triggers and procedures.
• Created end user documentation to go through the process and code.
• Worked on complex SQL code and packages as per the user requirements.
• Created batch processing and cron jobs for scheduling the jobs per requirements.
• Have used SQL Developer and SQL Loader to import/export data from or to the flat files
• Debugging the stored procedures using Toad/SQL developer
• Creating new partitions and partitioning the heap tables
• Worked on concepts like Context switching and Autonomous transactions.
• Created pipeline functions, Object Types and record types as per functionality.

Environment: Oracle 12c/11g, SQL Developer, Angular 2, Tortoise SVN, Linux, Oracle Forms 12C,, UNIX, PUTTY, Shell script, HP Quality Center.

Confidential, Orlando, FL

Sr. Oracle PL/SQL Developer

Responsibilities:

• Coded for Initial loading and Delta loading for continuous real-time updates.
• Responsible for implementing and maintaining the Users/schemas and databases as per the change in the architecture and design of the source/target databases.
• Written the efficient SQL, PL/SQL and the ability to tune SQL
• Used dynamic SQL to process the DDL and DML statements for a set of tables.
• Responsible for monitoring, maintaining, working on the Production support and fixing the critical issues.
• Worked on creating Procedures/Functions using Pivot, Date functions, time zones, conversions and Unpivot.
• Extensively used the MERGE operation to do the DML operations to capture and load the real time data to the Operational data services.
• Extensively supported the frontend Microstrategy developers by creating Views, Functions, procedures and other database objects.
• Coded the Change data capture mechanism to retrieve and load the data into ODS environment
• Extensively used the BULK BINDING mechanism to load and update the huge portions of data.
• Created job groups and jobs using the Tidal job scheduler
• Monitored the batch jobs and provided the on call support for the production loads.
• Used the tool Transporter to migrate the tidal jobs to multiple environments.
• Extensive experience in Data Profiling and Data analysis to identify the data relationship from multiple data sources and data marts.
• Utilized the Oracle Golden gate feature to capture the Master CDC records from the source Playbook databases.
• Worked on Operational Data warehousing and loaded the DataMarts using the dimensional and fact tables.
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures
• Responsible for scoping, technical design documentation, solution design, mentoring and instructing the Testing team members
• Worked on the process to capture relational integrity issues originating from source systems and clear them through an automated process
• Worked on performance issues and re-written the SQL code to enhance the data flow.
• Utilized the tool Solar winds Database Performance Analyzer and monitored the database performance and worked on the queries
• Extensively used the sub version Microsoft Team Foundation Server to create the branches and released many projects to QA/UAT and PROD environments.
• Created Data Flow Diagrams and Work Flow Diagrams using UML Rational tools/ MS Visio.
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions.

Environment: Oracle Database11g/12C, TOAD, SQL*Developer, PL/SQL developer, Microsoft TFS, Tidal job scheduler, Transporter, Solar winds Database Performance Analyzer, Microstrategy, Oracle Golden gate

Confidential, Charlotte,NC

Oracle Developer

Responsibilities:

• Worked on Oracle Database 11g/12c.
• Worked on retails store balancing issues for all the stores to manage the sales with the Sales auditing team.
• Written complex queries as per the requirements.
• Used dynamic SQL to process the DDL and DML statements for a set of tables.
• Provided the production support and fixed the critical errors.
• Extracted data from the databases (Oracle and SQL Server, FLAT FILES) using ETL tools to load it into a single data warehouse repository.
• Worked on Materialized views and replication support to sync the individual stores with the Sales audit databases.
• Worked on migrating the Oracle 6i forms to 12C forms.
• Used the Oracle WebLogic admin server and the node manager to start and refresh the server to run the forms.
• Worked on the time logics to create the batch files along with the refresh process whenever each store gets refreshed.
• Created standard scripts and reports to support the Tier 1 and Tier 2 support teams in case of production errors and report generations.
• Worked with the POS (Point Of Sale) team to sync the data from XSTORE to Sales Audit.
• Worked on settlement process
• Worked with the Data integration team to fetch the data from POS and other legacy databases to fetch the required data.
• Designed standardized documents and forms for project file documentation.
• Created templates for advanced project work to organize information effectively.
• Scheduled the jobs using the Tidal scheduler.
• Created Microsoft Visio diagrams to create the flow charts for the Technical specification and process documentations.
• Design flow for the development process.
• Worked with oracle Forms migration assistant to replace the obsolete code with the standard working code.
• Optimized SQL Queries by performance tuning using Explain plan, creating Indexes for reporting requirements and providing hints as of when required.
• Supported post production deployments with and code or Database related Issues.
• Worked in close proximity with business users understanding the need for extensions and acted as key player for understanding and implementation.
• Extensively involved in various phases of testing the products before migrating Production, from Unit testing through regression, UAT and performance testing.
• Expertise in Loading in multiple tables data and able to use merge statement of conditional
• Extensively used Cursors, Ref Cursors and Exceptions in developing Packaged Procedures and Functions.

Environment: Oracle Database11g, Linux oracle 6, WIN SCP, TOAD, SQL*Developer, UNIX, Forms Builder 12c, HP Quality Center, Microsoft TFS, Tidal job scheduler

Confidential, San Diego, CA

Software Engineer

Responsibilities:

• Gather and Analyze the requirements from Business team.
• Design flow for the development process.
• Worked on generating the files, creating the development layout, debugging, creating the process to generate reports.
• Help product manager(s) to document business requirements for data migration.
• Develop Oracle scripts and PL/SQL procedures
• Optimized SQL Queries by performance tuning using Explain plan, creating Indexes for reporting requirements and providing hints as of when required.
• Supported post production deployments with and code or Database related Issues.
• Worked on the outbound process using Informatica
• Worked on XML Developer’s Kit (XDK) to read and generate XML.
• Worked on complex SQL code and packages as per the user requirements.
• Created batch processing and cron jobs for scheduling the jobs per requirements.
• Have used SQL Developer and SQL Loader to import/export data from or to the flat files
• Debugging the stored procedures using Toad/SQL developer
• Implemented table and index partitioning of various tables with huge data.
• Worked with Database Administrator in creating Partition tables using by Range, Hash, List and Interval Partitioning techniques
• Detected and corrected bugs during system integration and user acceptance testing.

Environment: Oracle Database11g/12c, Linux, WIN SCP, TOAD, SQL*Developer, UNIX, HP Quality Center, Microsoft TFS, Tidal job scheduler, OTVM internal application, Waterfall SDLC model.

Confidential

Applications Developer

Responsibilities:

• Design flow for the ETL process for building up the data repository andanalyze the requirements, existing code and suggested the enhancements for business requirements
• Single handedly handled the production deployment phase of Consumer Business Billing Application project using the ITG Request deployment frame work.
• Develop and integrate Data Stage jobs
• Develop Oracle scripts and PL/SQL procedures
• Extracted data from the databases Oracle, SQL Server using Datastage to load it into a single data warehouse repository.
• Customization of code as per the user requirements.
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Followed the Scrum methodology for development of projects and implemented the development in sprints.
• Worked for the production deployment of the project by working closely with the Business team and deployment assistance team.
• Designed and developed complex ETL logic using many datastage stages including Transformer, Join, Merge, Funnel, sort, change capture, change apply & aggregator.
• Used Oracle to extract the data from source systems.
• Worked on Head, Tail and Peek stages for debugging DataStage jobs.
• Used parameter sets for easy maintenance of project specific parameters and better functionality.
• Worked on Microsoft technologies SQL Server and stored procedures
• Extensively worked with Teradata utilities like Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Responsible for developing custom PL/SQL wrappers for fixing the data issues for support team.
• Worked on TIVOLI Work Scheduler for the scheduling of batch jobs.
• Separating of tables and indexes on different locations. Reducing Disk I/O Contention etc. Applications Tuning of Database using EXPLAIN PLAN, SQL TRACE, ANALYZE, HINTS etc. Oracle query tuning and optimization
• Worked with FTP and SFTP efficiently for processing
• Involved in Concurrent Program Registration and Manual creation of Lookups.
• Also responsible for system integrity testing and user acceptance testing before final migration of the programs to the PROD instance

Environment: Oracle Database11g, IBM Info sphere Data Stage 8.5, SQL Server 2008, TOAD, SQL*Developer, UNIX, PUTTY, Shell script, HP Quality Center, RALLY, Scrum for Agile Implementation.