SUMMARY

• More TEMPthan Twelve years of experience in teh Information Technology Industry as Technical services, Application support,Lead developer,Business and Programmer analyst. Experience in teh 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 teh 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.
• Experienced with deployments,Maintenance and troubleshooting applications on Microsoft Cloud infrastructure Azure.
• 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.
• 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 Server2014/2012/, DB2 8.0/7.0, UDB, MS Access and Teradata.
• Experience in Oracle database,SQLServer2014/2012,SSIS,XML,Java,VB script,Python,Unix,WebLogic, WebSphere.
• 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 Confidential all levels. Good communication and presentation skills.
• Experienced in all phases of teh 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 teh designs
• Has experience in Relational and Dimensional Data modeling, Normalization,Denormalization, Data Architecture

TECHNICAL SKILLS

Languages: SQL, SQL plus, PL/SQL

Database: Oracle 11g/10g/9i, MS SQL Server, 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, XMLWebSphere, Jboss, WebLogic application servers,splunk,IVR

Operating Systems: Unix, Solaris, Linux, Windows Server

Job Scheduler: Tivoli Workload Scheduler, Autosys.

Domain: HealthCare, Finance,Telecommunication,ERP

PROFESSIONAL EXPERIENCE

Confidential, Alpharetta, GA

Technical Analyst

Responsibilities:

• Partnered with developers to automate manual processes, saving time and money while decreasing errors.
• Experience on installing and configuring SSL certificates in web servers and enabled secured (https) transactions..
• Troubleshoot DB issues and tune SQL queries.
• Work on SQL Server objects (Tables, Views, Stored Procedures, Triggers, and Scheduled Jobs etc.) and ETL processes.
• Handle development/support of MS SQL Server Integration Services (SSIS) packages.
• Installing features and deploy applications using power shell, Visual Studio Team System(VSTS).
• As a production support performs problem tracking, diagnosis and root-cause analysis, replication, troubleshooting, and resolution for all reported issues under OTC application, Offer management tool.
• 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 teh SLA for all Business units.
• Discuss all production support aspects with application development management.
• Performed quality assurance, system integration and user acceptance testing facilitating on-time, on-budget and acclaimed “go-live” of enterprise implementations for global users
• 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 teh problem, arrange meeting, conference call etc.
• Create and maintain teh documents on confluence such as platform details, IT playbooks, escalation procedures.
• Create system flow diagram that use as an artefact for future troubleshooting and halp to resolve teh issues.
• Assists team in conducting end-to-end testing on applications and technology, to ensure that business, technical, functional requirements are being met throughout teh SDLC.
• Database Performance tuning, Writing PL/SQL Code including Packages, Procedure, trigger etc and SQL queries tuning.
• Maintain positive relationships with key stakeholders and leaders
• Plan meetings, ensure participants are prepared, capture major take-a ways, and work with executive team to ensure follow up

Environment: MS Windows, SQL Server 2014, SSIS,XML,.Net, VSTS, Tableau, Microsoft Cloud infrastructure Azure.

Confidential, Richardson, TX

Dev-Production Support

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.
• Providing 24x7 on-call supports
• Discuss all production support aspects with application development management.
• Responsible for status reporting
• Work on SQL Server objects (Tables, Views, Stored Procedures, Triggers, and Scheduled Jobs etc.) and ETL processes.
• Responsible for Installation, Configuration, Trouble-Shootings of production Issue’s
• Co-ordinate with end customer to understand teh 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 teh Business as required
• Manage relationships and coordinate work between different teams Confidential different locations
• Manages activities for building and maintaining monthly, yearly releases to teh production environment.

Environment: Unix, Oracle 11g, Cassandra (NoSQL), WebSphere 6.0,6.1 and 7.0, Web Logic Server, Java

Confidential, Atlanta, GA

Dev-Production Support

Responsibilities:

• Project Delivery Management, Integration of Business Process Management
• Working as a Project Manager and having teh responsibility for leading a team to architect and implement custom solutions for Yesmail's Enterprise clients.
• Managing teh Launch team which is deeply involved in on boarding teh 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 teh 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 teh teams' accounts
• Communications with Executive staff on client status
• Communications with Client on Data Analysis and Program Design
• Develop relations with business community and teh out sourced service providers.
• Skilled in analysing teh customer’s business requirements, and mapping them to teh 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.

Environment: UNIX, Oracle 11g, WebSphere, Web Logic Server, Java

Confidential, Marietta, GA

Dev-Production Support

Responsibilities:

• Discuss all production support aspects with application development management.
• Develop relations with business community and teh out sourced service providers.
• Arrange, assign, adjust and monitor shifts to has 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 teh 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 teh 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 teh application as well completing client day to day requests.

Environment: Unix,Oracle 11g, Websphere,Web Logic Server,Java

Confidential, Alpharetta, GA

Dev-Production Support

Responsibilities:

• Responsible for detail investigation of teh 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 teh problem, arrange meeting, conference call etc.
• Provide teh required time to Confidential &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 teh application as well completing client day to day requests.
• Working on Application issues raised by users in AOTS. dis needs Analysis through Application frontend as well DB SQL Queries.

Confidential

Dev-Production Support

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. dis 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 teh appropriate resource availability and working/leading teh deployment activity.
• Working as co-ordinator between client and team and responsible for 24X7 application availablity as well completing client day to day requests.

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

Confidential

PL/ SQL Developer

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 teh appropriate call to teh nominated carrier. It is similar to Indirect Access except that teh customer does not need to dial a special access code before each call
• CPS Gateway is teh system providing teh interface between other CPS Operators and BT systems including CSS.
• As a Technical Associate (with a team size of 10) of teh Software Group was responsible for teh follows
• Was involved in testing of above development and modifications.
• Was involved in Replatforming of teh Database from 8i to 10 g
• Was involved in creating teh databases on sun solaris 5.10
• Used teh Ittretative methodology

Confidential 

PL/ SQL Developer

Responsibilities:

• Teh Exchange Migration and teh Configuration of Command and Control (C&C) is done through teh C&C WEB screens, which need to be enhanced to Automate most of teh manual steps and make them more user friendly
• To enable any active User to run teh Migration without separate UNIX Login and Oracle Database login.
• As a Technical Associate (with a team size of 4) of teh Software Group was responsible for teh follows.-
• Database Schema Designing, Altering, Handling Database Change Requests.
• Designing and Maintaing Teh Web Based PL/Sql Screens.
• Used teh Ittretative methodology
• Used various tools like HTML, Javascript, Oracle webserver and Oracle 8.0
• Was involved in testing of above development and modifications.