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 teh 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 teh 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 teh 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 teh 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 teh implementation of SCRUM methodology. Created tasks and daily reports of teh work status using Rally tool for Agile.
• Implementation of development tasks effectively in Sprints as per teh 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 teh 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 teh implementation of SQL stored procedures, functions, etc.
• Troubleshoot and debug database issues to identify solutions and contribute to teh maintenance of data models and database documentation.
• Present ideas and recommendations dat may have an impact on existing or future systems and applications, products, services or procedures and business processes.
• Adhere to teh 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 teh 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 teh Angular code developers to create teh front-end screens.
• Created methods and functions using collections especially Varrays and nested tables.
• Used dynamic SQL to process teh DDL and DML statements for a set of tables.
• Worked on Oracle forms 12c to create some user screens and troubleshoot teh backend code for triggers and procedures.
• Created end user documentation to go through teh process and code.
• Worked on complex SQL code and packages as per teh user requirements.
• Created batch processing and cron jobs for scheduling teh jobs per requirements.
• Have used SQL Developer and SQL Loader to import/export data from or to teh flat files
• Debugging teh stored procedures using Toad/SQL developer
• Creating new partitions and partitioning teh 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 teh Users/schemas and databases as per teh change in teh architecture and design of teh source/target databases.
• Written teh efficient SQL, PL/SQL and teh ability to tune SQL
• Used dynamic SQL to process teh DDL and DML statements for a set of tables.
• Responsible for monitoring, maintaining, working on teh Production support and fixing teh critical issues.
• Worked on creating Procedures/Functions using Pivot, Date functions, time zones, conversions and Unpivot.
• Extensively used teh MERGE operation to do teh DML operations to capture and load teh real time data to teh Operational data services.
• Extensively supported teh frontend Microstrategy developers by creating Views, Functions, procedures and other database objects.
• Coded teh Change data capture mechanism to retrieve and load teh data into ODS environment
• Extensively used teh BULK BINDING mechanism to load and update teh huge portions of data.
• Created job groups and jobs using teh Tidal job scheduler
• Monitored teh batch jobs and provided teh on call support for teh production loads.
• Used teh tool Transporter to migrate teh tidal jobs to multiple environments.
• Extensive experience in Data Profiling and Data analysis to identify teh data relationship from multiple data sources and data marts.
• Utilized teh Oracle Golden gate feature to capture teh Master CDC records from teh source Playbook databases.
• Worked on Operational Data warehousing and loaded teh DataMarts using teh 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 teh Testing team members
• Worked on teh process to capture relational integrity issues originating from source systems and clear them through an automated process
• Worked on performance issues and re-written teh SQL code to enhance teh data flow.
• Utilized teh tool Solar winds Database Performance Analyzer and monitored teh database performance and worked on teh queries
• Extensively used teh sub version Microsoft Team Foundation Server to create teh 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 teh stores to manage teh sales with teh Sales auditing team.
• Written complex queries as per teh requirements.
• Used dynamic SQL to process teh DDL and DML statements for a set of tables.
• Provided teh production support and fixed teh critical errors.
• Extracted data from teh 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 teh individual stores with teh Sales audit databases.
• Worked on migrating teh Oracle 6i forms to 12C forms.
• Used teh Oracle WebLogic admin server and teh node manager to start and refresh teh server to run teh forms.
• Worked on teh time logics to create teh batch files along with teh refresh process whenever each store gets refreshed.
• Created standard scripts and reports to support teh Tier 1 and Tier 2 support teams in case of production errors and report generations.
• Worked with teh POS (Point Of Sale) team to sync teh data from XSTORE to Sales Audit.
• Worked on settlement process
• Worked with teh Data integration team to fetch teh data from POS and other legacy databases to fetch teh required data.
• Designed standardized documents and forms for project file documentation.
• Created templates for advanced project work to organize information effectively.
• Scheduled teh jobs using teh Tidal scheduler.
• Created Microsoft Visio diagrams to create teh flow charts for teh Technical specification and process documentations.
• Design flow for teh development process.
• Worked with oracle Forms migration assistant to replace teh obsolete code with teh 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 teh need for extensions and acted as key player for understanding and implementation.
• Extensively involved in various phases of testing teh 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 teh requirements from Business team.
• Design flow for teh development process.
• Worked on generating teh files, creating teh development layout, debugging, creating teh 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 teh 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 teh user requirements.
• Created batch processing and cron jobs for scheduling teh jobs per requirements.
• Have used SQL Developer and SQL Loader to import/export data from or to teh flat files
• Debugging teh 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 teh ETL process for building up teh data repository andanalyze teh requirements, existing code and suggested teh enhancements for business requirements
• Single handedly handled teh production deployment phase of Consumer Business Billing Application project using teh ITG Request deployment frame work.
• Develop and integrate Data Stage jobs
• Develop Oracle scripts and PL/SQL procedures
• Extracted data from teh databases Oracle, SQL Server using Datastage to load it into a single data warehouse repository.
• Customization of code as per teh user requirements.
• Wrote, tested and implemented Teradata Fastload, Multiload and Bteq scripts, DML and DDL.
• Followed teh Scrum methodology for development of projects and implemented teh development in sprints.
• Worked for teh production deployment of teh project by working closely with teh 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 teh 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 teh data issues for support team.
• Worked on TIVOLI Work Scheduler for teh scheduling of batch jobs.
• Separating of tables and indexes on different locations. Reducing Disk me/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 teh programs to teh 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.