EXPERIENCE SUMMARY:

• 11+ years of IT experience in Banking & Financial and Healthcare Projects playing distinct roles such as Project Lead, Tech Analyst and Software Developer
• Strong customer interaction skills and good hands - on knowledge in Project Management, IT Architecture, Requirement gathering, Analysis, Estimation, and Capacity Planning
• Experienced to translate business requirements and analytical needs into technical solutions and prepare Business to Technical Delivery Cost-Resource plans
• Highly skilled and have shown eminence in handling multiple projects through all phases of a Software Life Cycle - Requirements Analysis, Design, Build and Testing / Support Waterfall & Agile - Scrum
• Strong knowledge and working experience in Oracle PL/SQL queries and concepts, Key, Joins, Packages, Procedures, Functions, Triggers, REF Cursors, Materialized Views, Bulk Collection, Global Temporary Tables, Exception Handling, External Tables, Data Loading, Database modeling, XML Handling and Experience in performance tuning
• Strong experience in supporting front-end applications like .NET and Java based with Oracle Database backend
• Start to end hands-on experience in Data Modeling, Complex Data Analysis, Data Migration and Distribution and Project Management
• Strong technical experience in a variety of Reporting Tools like - Business Objects, Crystal Reports, Tableau creating Dashboard / Reports and in Scheduling tool - Control M
• Have hands-on working experience in ETL process using Informatica and good working knowledge of SAP, Amazon Web Services (AWS) - S3, EC2
• Involved in the analysis and resolution of several Ad-hoc Production Requests and provided support to the products in Live-Production environment and huge databases with active data flow

TECHNICAL SKILLS:

Databases & Tools: Oracle 12c / 11g / 10g, SQL Developer, TOAD, SQL*Plus, SQL Loader, Control-M V8.0, ER/Studio, Quality Center, Unix, MS Office Suite, Tableau, AWS S3, EC2, Crystal Reports 10/XI, Business Objects Enterprise XI (Designer, Desk-I, Infoview, Crystal Management Console), MicroStrategy 10, TFS, Informatica, SAP

EXPERIENCE:

Confidential, Minneapolis, MN

Senior Developer

Responsibilities:

• Collaborate with business to determine appropriate requirements and management methods including but not limited to use cases, user stories, customer journeys and storyboards.
• Collaborate with client lead to convert the Business Requirement Document into Functional Specification document that act as the guidelines during the design phase.
• Translate business requirements into use cases to be developed into a web environment and service-based technologies
• Use client input / feedback to solve complex business problems, simply business processes and add value to the current project model
• Utilizing established programming standards and policies to perform programming/system design, development, coding, testing and implementation of the Org specific code.
• Transforming complex business logic into Oracle Database design and developing it using Packages, Stored Procedures, User Defined Functions, and Views.
• Prepare of Technical Design Documents for Reports and ETL Processes using PLSQL and and Objects creation such as Tables, Views, and User created
• Providing support and working on Data Types, Index Optimization, Stored Procedures, Cursors, Triggers and Performance tuning, Query Optimization, and Partitioning.
• Handling the Migration of Data from Excel, Flat files etc… Performing operations like Extracting, Transforming and Loading of data using PL/SQL procedures and functions.
• Providing support to an existing system in Oracle database the tasks is troubleshooting, root cause analysis and enhancements. Support programs written in PL/SQL, UNIX during development, test, and warranty period.
• Perform Unit and internal QA testing for the developed application. This includes unit-testing, system testing and integrated testing. Providing maintenance and production support for various applications

Confidential, Chicago, IL

Project Lead / Senior Developer

Responsibilities:

• Worked as the Onshore Project Lead and System Architect
• Designed Database model for the project and prepared the data flow architecture
• Coordinated with Clients in Requirements gathering, Analysis, Estimation and Capacity Planning
• Prepared the High Level -Technical Design Document for offshore team to proceed with the Code Development
• Coordinated with Data Base Administrators in creation of New Oracle 11g database and porting components from an Oracle 10g Database
• Experienced in working with Control-M Jobs and Unix Scripts
• Involved in the optimization of various SQL and PL/SQL Indexes, Hints and other basic tuning techniques
• Involved in creating and maintaining Partitioned Tables and Indexes
• Worked collaboratively with various Business Stakeholders to gather their analytics requirements, conceptualize and build Tableau reports based on the requirements
• Involved in Dashboard generation and distribution to End Customers on Weekly and Monthly basis
• Prepared Pseudo code for initiating the design model as per the standards
• Maintained data purity throughout all level of the database
• Responsible for Design & Code review for the development work like PL/SQL program units, procedures, functions and packages
• Coordinated with Offshore Team for clarifications on requirements & understanding, effort estimation & consolidating the deliverables for managing the UAT Sign-off.
• Reviewed and prepared Unit Test Plan & Results
• Served as the Scrum Master and Developer in separate occasions of the project

Confidential, Tampa, FL

On-shore Lead / Senior Developer

Responsibilities:

• Worked as the Onshore Project Lead for the Ucard Offshore Development Team
• Involved in the Database Modeling & Impact Analysis for the requirements given.
• Coordinated with Clients in Requirements gathering, Analysis, Estimation and Capacity Planning
• Prepared the High Level -Technical Design Document for offshore team to proceed with the Code Development
• Prepared Pseudo code for initiating the design model as per the standards
• Maintain data purity throughout all level of the database
• Responsible for Design & Code review for the development work like PL/SQL program units, procedures, functions, and packages for the complex scheduled crystal reports.
• Coordinate with Offshore Team for clarifications on requirements & understanding, effort estimation & consolidating the deliverables for managing the UAT Sign-off.
• Reviewed Unit Test Plan & Results
• Delegated the task to the Team and preparing the checklist for the same.
• Experience to deal with huge databases.
• Involved in the optimization of various SQL and PL/SQL Indexes, Hints and other basic tuning techniques
• Implemented Exception Blocks and used Pragmas in stored procedures as part of fine tuning them.
• Involved in creating and maintaining Partitioned Tables and Indexes
• Involved in Data Migration between different level of database
• Made use of the REF CURSORS in stored procedures for report generation

Confidential, Tampa, FL

On-shore Lead / Senior Developer

Responsibilities:

• Senior Development Team Member for the Onshore Development Team
• Involved in the Database Modeling & Impact Analysis for the requirements given.
• Coordinated with Clients in Requirements gathering, Analysis, Estimation and Capacity Planning
• Prepared the High Level -Technical Design Document for offshore team to proceed with the Code Development
• Involved in creating Pseudo code documents for writing stored procedures.
• Involved in implementing business logic with Oracle Stored Procedures, Functions and Triggers using PL/SQL.
• Implemented Exception Blocks in stored procedures as part of fine tuning them
• Performed thorough Design & Code review for the development work like PL/SQL program units, procedures, functions, and packages for the complex scheduled crystal reports.
• Coordinate with Offshore Team for clarifications on requirements & understanding, effort estimation & consolidating the deliverables for managing the UAT Sign-off.
• Reviewed Unit Test Plan & Results
• Delegated the task to the Team and preparing the checklist for the same.
• Participated in the daily status call with the offshore team to work in sync with the team on their understanding level by each individual item.
• Involved in comparing Production data with Test data for identifying and cleaning corrupted data
• Involved in Creating Indexes and Materialized Views for better performance

Confidential, New York, NY

Senior Developer

Responsibilities:

• Played a vital role in the Requirement analysis & gathering, Capacity planning, Estimation, Client Approvals, Design, Reviews, Testing and development for new reporting components.
• Conducted offshore team knowledge sharing sessions over the new requirements of an enterprise release.
• Reviewed the functional and technical designs of the requirements directly with Clients and track the approval for the same.
• Conducted bi-weekly Code Review and Unit Testing status updates meetings with an offshore team to meet and maintain the product standards.
• Done testing and debugging of all Crystal report, Business Object and Oracle Components to evaluate the performance and to check whether the code is meeting the business requirement.
• Was responsible for migrations of the code from Development environment to QA, QA to UAT and UAT to Production environment.
• Was responsible for SQL tuning and optimization using AWRs and Explain Plans.
• Involved the Development of a new reporting module from the scratch and in the maintenance of an existing application.
• Coordinated cross team impacts and supported dependent teams in report generations.
• Worked with the External WEBi team in Reporting BO Universe migrations and maintenance.
• Worked with the DBAs in Monthly database refresh process which involves pumping transactional tables & data across databases. Also coordinated with DBA in creating and managing table, indexes, table spaces, triggers, db links and privileges and validating the Job executions.
• Maintained consistent accuracy in Monthly BO Dashboard report generations which is circulated to higher level LOBs directly every month.
• Played a significant role in the successful implementation of Oracle Upgrade from 9i to 10g.
• Carried out Defect Analysis and fixing of bugs raised by the Users.
• Generated reports based on the adhoc user requests using Crystal reports / BO / WEBi - Rich client.
• Involved in Development Change request and proactively addressing Client’s needs.
• Involved in the analysis and solving of several Adhoc Production Request / issues
• Experienced in working with jobs and scheduling
• Involved in Data Migrations between different Databases
• Made use of the REF CURSORS in stored procedures for report generation
• Exposure to .NET ASP team needs and analyzing the cross team impacts to frame the Reporting Front End Application

Confidential

Junior Developer

Responsibilities:

• Played a vital role in the development, implementation, and support of 6 enterprise project releases
• Actively involved in documenting the Functional and the Technical specifications.
• Ensured the hygiene of all lower environment databases on continuous support.
• Addressed Level 3 issues on priority basis.
• Was awarded as the Star Performer for an Enterprise Release.
• Handled training sessions for the Entry Level Trainees on Crystal reports and Oracle.
• Provided updates daily to Onshore Team and JPMorgan Reporting manager about the status of daily activities, key issues and about the environment up-time.
• Conducted Offshore cross team impact knowledge sharing sessions of an ER.
• Worked on reports covered a vast logic of using the formula columns, summary columns, grouping as per the requirement of the user.
• Worked closely with the .NET Development team in designing and development of the Front-end reporting layouts and schedule processing for few Reports