Professional Summary:

More than Ten years of experience in the Information Technology Industry as Technical services, Lead developer, Business and programmer analyst. Experience in the analysis, design, development, implementation and management of full life cycle commercial applications.

Experience creating business requirements documents and other application related systems for new and existing process improvements.

Expertise in process improvement practices, Capture requirements to meet the deadline.

Expertise in project management methodologies.

Expertised in leading various technology desciplines (project management,development,QA, production support)

Excellent experience in dealing with issues related to Performance tuning, backup recovery and other oracle database related activities.

Skilful problem solver with excellent analytical skills.

Earned several accolades due to exemplary work performance. Take initiatives designed to advance continuous improvement, competitive advantage and profitable growth. Lead business process and workflow mapping/analysis using data capture and modeling technologies, methods and tools. Analyze business, user and technical requirements for proposed SAS, web-based and system solutions.

Has good experience in tools like UNIX Shell Scripting, TOAD, XML, SQL Navigator

Expertise in developing Data Conversions/Migration from Legacy System of various sources (flat files, Oracle, Non Oracle Database) to Oracle system Using SQL LOADER, External table and Calling Appropriate Interface tables and API’s.

Wrote complex batch process in PL/SQL for huge data.

Experience in Data flow Diagram, ER Diagrams using Oracle Designer.

Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.

Experienced in all phases of the System Development Life Cycle (SDLC) and Development Methodologies/Guidelines.

Accomplished in working with users/upper-level management in translating their business needs into logical systems designs, as well as working in a technical capacity to implement the designs

Have experience in Relational and Dimensional Data modeling, Normalization,Denormalization, Data Architecture

Highly flexible and a proven performer in managing multiple task demands and delivering results on time. Ability to work independently, and within a team with responsibly within team, with focus on dedication and commitment.

Technical Skills:

Languages

SQL, SQL plus, PL/SQL

RDBMS

Oracle 11g/10g/9i, MS SQL Server 2000,MYSQL

Oracle tools

Oracle Forms11g/10g/9i/6i, Oracle Reports11g/10g/9i/6i

Case tools

ERwin 7.3, E/R Studio,ETL, Oracle Designer 10g/9i/6i,

ERP

Implement ERP (Modules : Purchase, Inventory,Finance,Sales)

Others Tools /Technologies

TOAD, SQL Developer, SQL Navigator, SQL Loader, Oracle expdp/ impdp,oracle data pump, ODBC, FTP,VSS, Ultra Edit, XML,

WebSphere, Jboss, WebLogic application servers,splunk,IVR

Operating Systems

Unix, Solaris, Linux, Windows Server

Job Scheduler

Tivoli Workload Scheduler, Autosys.

Domain

HealthCare, Finance,Telecommunication,ERP

Educational & Professional Training Certifications:

Post Graduate Diploma in Software Oracle 8, Developer 2000(forms 5.0, Reports 3.), Electronic Research &

Development Center of India.

Bachelor of Engineering in Mechanical Engineering, Kolhapur University, India.

Professional Experience:

Interactive communications Alpharetta, GA March 2015 – Till Date

Technical Analyst

Application Support-IHA

Enables InComm Merchants to accept OTC card based payment method at the point of sale for Over the Counter medicine, medical supplies covered by Medicare or Medicaid program.

Roles & Responsibilities:

Partnered with developers to automate manual processes, saving time and money while decreasing errors.

Prioritize issues raised and resolve.

Log issue tickets timely. Work closely with external resources and vendors supporting business activities for inbound and outbound data through real time and batch interfaces. Perform daily production issues and resolve accordingly with in the SLA for all Business units.

Extensive testing ETL experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects.

Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.

experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Exchange, Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.

Performed quality assurance, system integration and user acceptance testing facilitating on-time, on-budget and acclaimed “go-live” of enterprise implementations for global users

As a production support performs problem tracking, diagnosis and root-cause analysis, replication, troubleshooting, and resolution for all reported issues.

Responds to issues in a timely manner by receiving and investigating incidents or issue tickets

Capture requirements and perform detail level analysis and provide input to developing long-term fix.

Consult with end users to assist in determining current operating procedures

Co-ordinate with end customer to understand the problem, arrange meeting, conference call etc.

Create and maintain the documents on confluence such as platform details, IT playbooks, escalation procedures.

Create system flow diagram that use as an artefact for future troubleshooting and help to resolve the issues.

Assists team in conducting end-to-end testing on applications and technology, to ensure that business, technical, functional requirements are being met throughout the SDLC.

Database Performance tuning, Writing PL/SQL Code including Packages, Procedure, trigger etc and SQL queries tuning.

AT&T, Richardson, TX January 2014 – February 2015

Project Manager-(Prodution Support)

Roles & Responsibilities:

Project management, scheduling of deliveries, tracking.

Prioritize issues raised and resolve it accordingly.

Analytical Problem-solver, able to anticipate issues and create new systems that streamline operations, resolves concerns and improves efficiency.

Ensure End to End Deliveries.

Discuss all production support aspects with application development management.

Offshore – onshore model

Responsible for status reporting

Responsible for Installation, Configuration, Trouble-Shootings of production Issue’s

Co-ordinate with end customer to understand the problem, arrange meeting, conference call etc.

Responsible for Installation, Configuration, Trouble-Shooting, Code deployment

Communicate all key project plans, commitments, and changes including requirements, QA plans, schedule, and scope changes

Communicate release details and schedules to the Business as required

Manage relationships and coordinate work between different teams at different locations

Manages activities for building and maintaining monthly, yearly releases to the production environment.

Infogroup Inc. Atlanta, GA September 2013 – January 2014

Technical Project Manager

Roles & Responsibilities:

Project Delivery Management, Integration of Business Process Management

Working as a Project Manager and having the responsibility for leading a team to architect and implement custom solutions for Yesmail's Enterprise clients.

Managing the Launch team which is deeply involved in on boarding the clients to Yesmail Platform and product

Focus includes having leadership and technical skills to act as a point of escalation and make technical decisions based on organizational standards and guidelines.

Supervising the work of team members to insure that engineering efforts produce high quality, low maintenance, and scalable solutions for all clients.

Responsible for designing solutions and supervising projects and to keep abreast of technical skills and technology coding standards. Implementing solutions on an ongoing and as-needed basis. Additional responsibilities include writing formal engineering specifications and developing time estimates for implementation. Good experience in Agile base projects using JIRA based systems.

Provide day to day assistance to onsite, offshore engineers, and production developers to support the teams' accounts

Communications with Executive staff on client status

Communications with Client on Data Analysis and Program Design

Develop relations with business community and the out sourced service providers.

Skilled in analysing the customer’s business requirements, and mapping them to the processes, database solutions and products that are being implemented.

Interact with infrastructure, release management, change management and application teams.

Prioritize issues raised and resolve it accordingly.

Analytical Problem-solver, able to anticipate issues and create new systems that streamline operations, resolve concerns and improve efficiency.

Ensure End to End Deliveries.

Managing multiple projects for various customers utilizing Software Development methodology.

Responsible for Installation, Configuration, Trouble-Shootings of production Issue’s

Handling Database Performance tuning, Writing/Debugging PL/SQL Code including Packages, Procedure, trigger, SQL Queries etc.

First Data, Marietta, GA October 2012 – September 2013

Manager Project -Development &Production Support

Project : First Data Mobile Banking.

Roles & Responsibilities

Discuss all production support aspects with application development management.

Develop relations with business community and the out sourced service providers.

Arrange, assign, adjust and monitor shifts to have full operational coverage.

Interact with infrastructure, release management, change management, QA, DBA and application teams.

Prioritize issues raised and resolve it accordingly.

Allocate resources to resolve problems/incidents.

Responsible for detail investigation of the issue reported.

Capture requirements and perform detail level analysis.

Consult with end users to assist in determining current operating procedures

Co-ordinate with end customer to understand the problem, arrange meeting, conference call etc.

Responsible for Installation, Configuration, Trouble-Shootings of production Issue’s

Handling Database Performance tuning, Writing/Debugging PL/SQL Code including Packages, Procedure, trigger, SQL Queries etc.

Working as co-ordinator between client and team, also responsible for 24X7 application availability of the application as well completing client day to day requests.

AT&T, Alpharetta, GA January 2010 – October 2012

Production Support

Roles & Responsibilities:

Responsible for detail investigation of the issue reported.

Capture requirements and perform detail level analysis.

Consult with end users to assist in determining current operating procedures

Co-ordinate with end customer to understand the problem, arrange meeting, conference call etc.

Provide the required time to AT&T application users to code SQL, UNIX, Perl, UNIX scripting, PL/SQL program.

Responsible for Installation, Configuration, Trouble-Shooting, Optimization, SQL Tuning and Maintenance of Oracle Databases on windows and UNIX Platform

Handling Database Performance tuning, Writing/Debugging PL/SQL Code including Packages, Procedure, trigger, SQL Queries etc.

Working as co-ordinator between client and team, also responsible for 24X7 application availability of the application as well completing client day to day requests.

Working on Application issues raised by users in AOTS. This needs Analysis through Application frontend as well DB SQL Queries.

Tech Mahindra Noida, India December 2007 – January 2010

Production Support

Client Name: AT&T USA.

Roles & Responsibilities

Provide 24X7 Environment, Production and Application Support (MDE,PDTS, Optical, CATALYST)

As a Team Lead and on-site co-ordinator (with a team size of 10) and responsible for

Database Performance tuning, Writing PL/SQL Code including Packages, Procedure, trigger etc and SQL queries tuning.

Debug Application Environment issues in UNIX environment.

Working on Application issues raised by users in AOTS. This needs Analysis through Application frontend as well DB SQL Queries.

Taking care of Application deployment activities that includes Opening Change ticket in AOTS, get that approved, ensuring the appropriate resource availability and working/leading the deployment activity.

Working as co-ordinator between client and team and responsible for 24X7 application availablity as well completing client day to day requests.

Enviornment: Unix, Oracle, Weblogic 10.3, Java, PL/SQL, Toad

Tech Mahindra Noida, India January 2007 – December 2007

Development and Pl/sql consultant

Project Roles & Responsibilities:

Carrier Pre Select Gateway: Carrier Pre-Selection allows BT customers to 'pre-select' an alternative carrier for some of their call types, call types being National, International or 'All Calls'. BT's network will automatically route the appropriate call to the nominated carrier. It is similar to Indirect Access except that the customer does not need to dial a special access code before each call

CPS Gateway is the system providing the interface between other CPS Operators and BT systems including CSS.

As a Technical Associate (with a team size of 10) of the Software Group was responsible for the follows

Was involved in testing of above development and modifications.

Was involved in Replatforming of the Database from 8i to 10 g

Was involved in creating the databases on sun solaris 5.10

Used the Ittretative methodology

Tech Mahindra Pune, India July 2006 – January 2007

Pl/ Sql consultant

Roles & Responsibilities:

The Exchange Migration and the Configuration of Command and Control (C&C) is done through the C&C WEB screens, which need to be enhanced to Automate most of the manual steps and make them more user friendly

To enable any active User to run the Migration without separate UNIX Login and Oracle Database login.

As a Technical Associate (with a team size of 4) of the Software Group was responsible for the follows.-

Database Schema Designing, Altering, Handling Database Change Requests.

Designing and Maintaing The Web Based PL/Sql Screens.

Used the Ittretative methodology

Used various tools like HTML, Javascript, Oracle webserver and Oracle 8.0

Was involved in testing of above development and modifications.

Tech Mahindra Pune, India October 2005 – July 2006

Pl/SQl Developer

Project - (Revolution Analytics)

Revolution deals with Small & Medium enterprises. Revolution takes care of MIS requirements of different Business segments of BT like BT Openworld (BT’s Broadband Services). The reporting is done on various subject areas like Assets, Orders, Service Requests, and Activities etc. Analytics extract’s data from Siebel OLTP using Informatica to populate OLAP and uses Analytics Dashboards to presents the reports. The project encompasses all the phases of a SDLC and have been executed with a combination of requirements capture at onsite followed by development and delivery from offshore. The development will be carried out in phases with the objective of providing useful analytical reports for all the important business functions implemented in Revolution.

As a Technical Associate (with a team size of 8) of the Software Group was responsible for the follows.-

Database Schema Designing, Altering, Handling Database Change Requests.

Handling and Devlop Mappings in Informatica

Henkel Teroson India Limited,Gurgaon India November 2002 – September 2005

ERP Developer

Project (MAKESS 5.0.0) Roles & Responsibilities:

Analysis, Design, Support & Enhancement for Henkel Teroson India Limited at Gurgaon, India (MAKESS 5.0.0)

Henkel Teroson India Ltd. is involved in the Sealants Manufacturing at 7 units. The Prime Focus in the Inventory, Sales, Purchases, Production, Finance,. The plan is to inter-linking with other units. The project has started with Inventory & Purchase, Sales modules transactions.

As a Sr. Software Engineer (with a team size of 10) of the Information System Group was responsible for the follows

Analysis, Quality, Schedule, Risks, Coordination, Client Communication, Development, Technical Client Support.

Support for Request or Issue Raised By all Respective Clients.

QA Handling with SCM for all Support Projects.

Bringing the entire project offshore and offsite.

Reducing the large number of outstanding faults when the project was initially taken over.

Building up a very strong customer support and communication structure.

Data Porting, Script Generation, Data Migration.

Environment: MS Windows, MAKESS 5.0.0, D2K 5, Oracle 8.1.7, Report 3.0 With SQL Files, SQL Loader.

Eastern Software Systems,India July 2000 – November 2002

Roles & Responsibilities:

Analysis, Design, Support & Enhancement for AIMA, MMTCL, WEEKENDER, AVON CYCLES at India (Ebizframe 6.0.0)

This Product includes extensively in SRS, design, development and customization of Inventory/ Purchase/ Sales/ production/ planning/ Maintenance/ modules. We used the web enabled ERP package called Ebizframe from ESS. Extensive Reports were created for all the modules using SQL and Oracle Reports.

As a Software Specialist (with a team size of 8) of the Software Group was responsible for the follows –

Database Schema Designing, Altering, Handling Database Change Requests.

Analysis, Quality, Schedule, Risks, Coordination, Client Communication, Development, Technical Client Support.

Data Porting, Script Generation, Data Migration.

Environment: MS Windows, Ebizframe 6.0.0, D2K 5, Oracle 8.1.7, Report 3.0 with SQL Files, SQL Loader.

Contact this candidate