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.