SUMMARY

• 7+ years of experience in software development with full life cycle development (SDLC) including requirements analysis & documentation, design, development, testing and implementation of applications.
• Working experience in various database objects like Stored Procedures, Functions, Ref Cursors, Constraints, Triggers, Indexes, Views, export/Import Utilities in Oracle 12c/11g/10g/9i databases .
• Worked with CASE tools like TOAD, SQL Developer, PL/SQL Developer, SQL Navigator for writing PL/SQL programs.
• Strong work experience in various databases like Oracle, SQL, DB2 databases.
• Extensive noledge of creating Business Requirement and Technical Document.
• Solid experience in writing complex SQL queries and PL/SQL procedures to extract data from various source tables.
• Working experience in database coding and implementation with Oracle PL SQL.
• Working experience Data Extraction, Transmission and Loading (ETL).
• Working experience with Client/Server tools like SQL Server Enterprise Manager, Query Analyzer and SQL Management Studio to administer SQL Server.
• Experience in design, development, coding, and testing of various service oriented and web - based applications using Coldfusion MX/8.
• Hands-on experience in developing applications using JavaScript, JQuery,HTML XML, AJAX and CSS.
• Experience in database design and implementation with SQL Server 2008 R2. Around 2 years of working experience in design, implementation and maintenance of Relational database servers like MS SQL Server 2005, 2008 with hands on experience on writing stored procedures and triggers in SQL Server.
• Working experience in reporting and data analytical tools like Tableau and Splunk.
• Working experience with data warehousing platforms like Informatica.
• Experience in writing teh UNIX shell scripts to automate manual processes
• Experience on Operating Systems like XP/NT/ 2003/2000/98/95 and UNIX.

TECHNICAL SKILLS

Operating Systems: Windows Server 2003, Windows 95/98/NT/2000/XP, MS DOS

Frameworks: Coldfusion Fusebox, NET Framework 4.0/3.5/ 2.0, VisualStudio .NET 2010/2008/ 2005 , MVC

Languages: PL SQL, SQL,UNIX shell scripting,Java, C, C++

Tools: SQL Developer, Toad, SQL Navigator, PL SQL Developer, PUTTY(Unix/Linux Utilities),mks Integrity, Bug tracking system,Tableau desktop 8.2,Informatica Powercenter

IDE: Dreamweaver

RDBMS: Oracle 9i/10g/12c, MS SQL Server 2008 R2/2005/2000, MS Access, My SQL.

Web Technologies: ColdFusion MX7/ 8 /9, JavaScript, Ajax, jQuery, HTML, XML, CSS, IIS 6/5.1, C#

Version Control: Clear Case,PVCS, Visual Source Safe (VSS) 6.0.

UML Tools: MS Visio

PROFESSIONAL EXPERIENCE

ETL Developer

Confidential, Bethesda, MD

Responsibilities:

• Worked closely with business users to analyze teh data. Provided various analysis that were used for requirement gathering.
• Created new stored procedures as part of enhancements to projects for PL/SQL Development (functions, packages, procedures, triggers, Anonymous Block).
• Worked on translation of business requirements into data warehouse design and developed ETL logic based on requirement using Informatica PowerCenter.
• Worked with on performance optimizing complex queries.
• Developed mappings using various transformations(Joiner, Sorter, Connected Lookup, Router, Filter, Update Strategy, Expression) using Informatica.
• Involved Extensively in Triaging and resolving business impact incidents. Worked with business team to provide potential resolutions based on data analysis.
• Wrote complex SQL queries using joins and subqueries to extract data from database.
• Monitored multiple workflows in Informatica. Was responsible for maintaining and debugging any issues related to teh workflows.
• Create and Modify UNIX shell scripts to process teh source/feed files.
• Was responsible for debugging any issues that came during project migration and releases.
• Worked extensively with AWS platform for maintaining deploying debugging and maintaining teh project.
• Monitored reports and alerts using Splunk .
• Worked in a fast-paced dynamic team-oriented environment and provided on call support as needed.
• Worked extensively with business team on providing various reports on regular basis for further analysis.
• Created Knowledge Articles for smooth implementation of teh project.

Environment: Oracle PL/SQL 12c, SQL Server 2016, Splunk, Informatica,UNIX Shell Scripting, servicenow

Sr.PL SQL Developer &Analyst

Confidential, windsor, CT

Responsibilities:

• Was part of a team responsible for migrating database from SQL server to Oracle.
• Worked extensively on migrating data from another database like DB2
• Wrote new procedures for PL/SQL development (functions, packages, procedures, triggers, Anonymous Block).
• Was solely responsible for gathering requirements, developing and maintaining some of teh critical project modules.
• Wrote complex SQL queries involving multiple joins, sub queries and including use of CTEs, merge and dynamic SQL .
• Experience working with ref cursors, collections, Bulk collects.
• Monitored and maintained existing ETL packages to fix issues and bugs and troubleshooting.
• Extensively worked on tuning and optimizing complex SQL queries
• Wrote anonymous blocks and scripts to handle migration activities.
• Create/Modify SQL scripts to load data into database using SQL Loader.
• Created DDL scripts to create tables, queries for new enhancements in teh application using TOAD.
• Worked with all teh client components of informatica like Repository Manager, Designer, Workflow Manager, Workflow Monitor.
• Automated scripts for validations to match teh source data counts post migration for business users.
• Wrote multiple error handling logics in oracle to handle exceptions.
• Involved in end to end functional testing during different migration cycles.
• Worked with business team to create multiple training guides for training team.

Environment: Oracle PL/SQL, DB2, SQL Server 2016,UNIX Shell Scripting,Informatica

PL SQL Developer

Confidential -Smithfield, RI

Responsibilities:

• Analyze all business requirements and document all technical specifications.
• Created and maintained PL SQL scripts and stored procedures
• Designed and Developed application using packages, stored procedures and functions to manipulate teh database and to apply teh business logic according to teh user specifications.
• Wrote complex SQL queries using joins and subqueries to retrieve data from database.
• Worked on performance tuning using various PL SQL tuning techniques for query optimizations.
• Support all day to day activities related to database like data consolidation, data migration scripting
• Involved in continuous enhancements and fixing of production issues. Generated server-side PL/SQL scripts for data manipulation and validations.
• Experience working with bulk collections in PL SQL objects
• Created and modified Unix scripts to migrate files.
• Worked on SQL*Loader to load data from flat flies obtained from various sources
• Generate Reports based on day-to-day activities.
• Handled errors using exception handling extensively.
• Conduct unit testing according to teh business requirements.
• Involved in writing Test cases documents.
• Worked under tight schedules for successful development and implementation.

Environment: Oracle PL/SQL,UNIX

PL SQL Developer

Confidential

Responsibilities:

• Analyze all business requirements and document all technical specifications.
• Designed and Developed packages, stored procedures and functions to manipulate teh database and to apply teh business logic according to teh user specifications.
• Wrote complex SQL queries using joins and subqueries to retrieve data from database.
• Involved in continuous enhancements and fixing of production issues. Generated server-side PL/SQL scripts for data manipulation and validations.
• Created scripts to create new tables, views, queries for new enhancements using TOAD
• Worked on SLA’S to meet teh business requirements.
• Created indexes and sequences on table during deployments to production.
• Involved in preparing documents for program change specification and program specification for teh various changes that need to be done in teh existing project.
• Conduct unit testing according to teh business requirements.
• Write Test cases.
• Worked under tight schedules for successful development and implementation.s
• Design and Develop tableau visualization solutions
• Created worksheets and dashboards.
• Used Multiple measures like individual axes, multiple axes and dual axes.
• Prepare dashboards using calculations, parameters in tableau.

Environment: Oracle PL/SQL, UNIX,AUTOSYS, Tableau.

Confidential

Responsibilities:

• Developed and enhanced teh application based on change Requests using coldfusion, PL SQL, server-side JavaScript. worked on module to support and maintain application.
• Worked on SLA’S to meet teh business requirements.
• Created stored procedures and functions to manipulate teh database and to apply through business logic according to user specifications.
• Used HTML, JavaScript and embedded PL/SQL coding within those languages.
• Used JavaScript for client- side scripts to interact with user.
• Created scripts to create new tables, views, queries for new enhancements using TOAD.
• Created indexes and sequences on table during deployments to production.
• Involved in data loading using SQL developer by calling scripts to load teh batch data into teh tables.
• Support all day to day activities related to database like data consolidation, data migration scripting.
• Responsible for performance tuning activities in teh project.
• Monior and fix teh scheduling jobs periodically using CA workload .
• Generate reports on day today basis for teh all teh data that is being loaded in teh tables.
• Conduct unit testing according to teh business requirements.
• Involved in preparing documents for test cases and program change specification for teh various changes that need to be done in teh existing project.

Environment: Oracle PL/SQL, UNIX,Tableau,jQuery, Ajax, XML, JavaScript, CSS, ColdFusion.

Application Developer

Confidential

Responsibilities:

• Worked on module to support and maintain application in a Health care domain.
• Experience working in Agile methodology.
• Worked on bug fixes based on teh change requirements.
• Used Dynamic HTML (DHTML) and JavaScript in teh application to create and manipulate HTML elements.
• Used JavaScript for client- side scripts and to interact with user
• Used jquery for simplifying HTML document traversing, event handling and validations.
• Conduct unit testing.
• Involved in Scrum calls and Report t a scrum master on day today activities and bug fixes.

Environment: JavaScript, Jquery, HTML, Ajax, XML,Oracle PL SQL, Coldfusion. CSS.

Software Developer

Confidential

Responsibilities:

• Actively participated in gathering requirements from client, analyzing and preparing design document.
• Implemented Graphs and Charts (like Bar Charts, Pie Charts, Line Graphs and Stacked Graphs) according to energy measurements available in Database.
• Implemented Compliance Report using SQL Server Reporting Services (SSRS).
• Using jQuery implemented selection criteria to generate Graphs.
• Created Stored Procedures to manipulate teh database and to apply teh business logic according to teh user specifications.
• Provided Role management to differentiate information according to user’s role.
• Implemented Administrator module to manage facilities, locations, regions, and meters (Gas, Water, and Electricity).
• Implemented Data exporting functionality to export data to Excel and PDF.
• Used Dynamic HTML (DHTML) and JavaScript in teh application to create and manipulate HTML elements.
• Implemented functionality to maintain logs of transactions to or from Database in two ways (i) Storing logs in database (ii) Storing logs in text files.
• Performed Unit Testing and Integration Testing on teh modules according to teh requirements and development standards.
• Worked with teh testing team for resolving bugs.

Environment: ColdFusion, jQuery, Ajax, XML, MS SQL Server 2005, JavaScript, CSS.