EXPERIENCE SUMMAERY:

• Confidential has 11+years of experience in Software Development, Application Maintenance, DevOps Operations, Enhancement and Production Support for Projects in domains such asBanking&Finance, Insurance&Annuities, Energy&Utility, Confidential
• alth Care and Communicationwith all the stages of Software Development Life Cycle:Requirements gathering, Analysis, Design, Coding, Testing, Implementation, Maintenance and Support.
• Confidential is an Oracle Certified Professionalwith technical expertise in SQL Query Generation, PL/SQL programming, Report Generation, Batch Job Creation, Package, Procedure, Function, Triggers, Scripting Feed files and Sql Loader scriptingand Shell scripting using Unix and AWK.
• Alexhas a sound knowledge of batch scheduling tools such asTivoli Work Scheduler 8.6, Appworx8.0and AutomicUC4both in Adminstration and Development. From BRD (Business Requirement Document) to End User Manual, Confidential has prepared documents for all stages in SDLC.
• Confidential hasextensively worked on End Of Day Store (EODS) database model where Delta & Full Files of Accounts, Balance, Position and Transactions areloaded, processed and Exposed todifferent financial Application using Oracle 11g, Unix, Mainframe, DB2and COBAL.
• Confidential has successfully designed and implemented various Oracle projects and highly appreciated by the Clients for hisproject co - ordination and communication skills.
• Confidential knowledge inEDI (Electronic Data Interchange) transactions for Energy & Utility domain and the ability tosupport the Business customers 24/7 has been highly appreciated by the Client. Confidential has also worked in Banking, Retail, Healthcare, Insurance, Educational & E-commerce projects.
• Confidential has expertise in writing Use cases and drawing Process flow diagrams.
• Has an excellent programming and analytical skills. Has experience in Database design using Oracle 12c, 11g/ 10g/9i, SQL Server 2014/2012/2008and MS Access97/ 2000.
• Actively involved in Project Leadership and Client Coordination ensuring development progress, and Mentoring junior team membersin client projects. Has expertise in Agile & Waterfall Methodologies.

TECHNICAL SKILLS:

Operating Systems: Windows / Linux

Database: Oracle 12c, 11/10g, MS-SQL Server 2014 DB2, MS-Access Oracle SQL, Oracle 11g Advanced PL/SQL Programming, UC4 9.0 Scripting, Appworx 8.0, DB2, COBAL, MS SQL Server, T-SQL, Shell Scripting, AWK Scripting

Reporting Tools: Oracle Reports, Crystal Reports and tableau

Programming Environment: Oracle Developer, Sql Navigator, Toad, AppworxApplication Manager, Automic UC4, Oracle Form Builder, Oracle Report Builder, T2COM Transaction Transporter, DB2 and COBAL.

Tools: Ralley, JIRA, Remedy, ITRC, Brouha, tableau, Toad, SQL, Developer, Tivoli Workload Scheduler, WinSCP, Putty, Appworx, ManangeNow, Salesforce, Clarity,ServiceNow, HP Quality Center, IQNavigater,SnagIt, Araxis Merge, SharePoint, IBM Lotus Notes, Visio, X1 Rapid Discovery, Worksite, iManage, UCM, Ultraseek

Version Control Systems: Serena Version Manager, VSS, TFS,WinCVS

PROFESSIONAL EXPERIENCE

Confidential

Programmer Analyst Sr

Responsibilities:

• Amisys surround Code customization and developer using Oracle PL/SQL.
• Batch job creation and schedule automation using UC4 and Appworx.
• Job workflow Development using UC4 Scripting and UC4 objects.
• Analysis and Bugfixing of dail y issues.
• On Call Production Support Daily BAU Technical Tasks
• Preparation of Project documents such as BRD, FRD, Design Doc, Test Doc, User and Support Manual.
• Process change, Enhancement and New project requirement gathering, Analysis, Design, Coding and Implementation.
• Performance Tuning, Code review, Test case preparation and Testing with Business users.
• Performance Tuning of Amisys Mirror Load Process.

Confidential

Project Lead

Responsibilities:

• Production Support of daily Batch Jobs.
• Daily BAU Technical Tasks
• Batch Error Validation, Reporting, Root cause Analysis
• Process change, Enhancement and New project requirement gathering, Analysis, Design, Coding and Implementation.
• Software Development Life Cycle - Processing new Product Data Files into EODS.
• DevelopingUnix Scripts, AWK Scripts, Oracle Package with Functions and Stored Procs.
• Creating and configuring new Scheduled jobs in Tivoli Workload Scheduler.
• Coordinating between the Business users, Client and the Offshore team.
• Performance Tuning, Code review, Test case preparation and Testing with Business users.
• Writing Sql queries to generate customized reports as per Business requirement.
• Data Migration and coordinating with DBA, Data Architect
• Creating Change Management Request. Representing Field CAB for CMR approvals.
• Training and knowledge transfer to the junior members at offshore.
• Creating Visio design documents and presenting them to Clients with Pros & Corns of different approaches to solution.
• Documentation &Coordination between different Cross commits (ETL, Mainframe, Source File and Project Teams)

Confidential

Systems Analyst

Responsibilities:

• Maintaining the daily transactions of EDI application and ensuring that a response transaction is sent to the Retail Providers for all the transactions received.
• Managing and coordinating between the Business users, Client and the Offshore team on a daily basis.
• Process change, Enhancement and New project requirement gathering, Analysis, Design, Coding and Implementation done by the offshore team.
• Performance Tuning, Code review, Test case preparation and Testing with Business users.
• On call Production Support and daily data repairs as required by the Business Team.
• Performing Market Test between TDSP and Retail Electric Providers.
• Writing Sql queries to generate customized reports as per Business requirement.
• Generating daily audit reports for transaction monitoring and maintenance.
• Data cleansinganddata migration.
• Running oracle batch job/ chains using Appworx Application Manager.
• Monitoring and maintaining data file transaction using T2COM Transaction Transporter.
• Manually processing the failed transaction and resending them to the Retail Providers.
• Digital Certificate Installation
• Training and knowledge transfer to the junior members at offshore.

Confidential

Tech Lead

Responsibilities:

• Participated in the study of the functional requirements of the application and was involved in analysis, design, coding, integration, and unit testing of different modules of PrIME.
• Has taken the project from mission critical at the start to steady state in a year.
• Has created new packages and fine tuned existing once based on the business needs and standards.
• Has delivered numerous oracle Trackers and Value-Adds successfully while collaborating with the onsite coordinators on a daily basis.
• Has led a group of five for a new enhancement in the project and was awarded ‘The Star Performer’ in the project.
• Has successfully guided and accomplished major enhancements such as FINRA, DST, Morgan Stanley migration, Agent Renewal that helped the client save $1.8m, Just In Time and Letter Dialogue system that helped the client save $2.0m per year.
• Responsible for thequality processes of the project as per organizational standards and has extensive knowledge about the quality tools that are used in Cognizant like Etracker, Qsmart.
• Responsible for giving both application specific and technology specific Knowledge Transfer to the new members of the project.
• Has prepared monthly Dashboards, Resource Loading Document, Weekly status report etc., for Confidential project.
• Has prepared Oracle Technical Journals and circulated them within the account.
• Confidential has handled numerous training sessions for both in house and for Entry Level Trainees at the organizational level. About 100 hours of Confidential trainings were rated as ‘Excellent’ by the Cognizant Academy.

Confidential

Associate Programmer

Responsibilities:

• Confidential has shouldered the main responsibility of client interaction and maintenance of the CSDS application.
• Participated in the study of the functional requirements of the application and was involved in analysis, design, coding, integration, and unit testing of different modules of CSDS.
• Confidential has done new product and data validation, cleansing and migration.
• Responsible for the quality processes of the project as per organizational the standards.
• Responsible for giving both application specific and technology specific Knowledge Transfer to the new members of the project.
• Confidential has built and fine tunedSQLqueries & Pl/Sql blocks for the project.
• Confidential has designed project presentation document for a new client and was well appreciated.

Confidential

Programmer Analyst

Responsibilities:

• Worked on Oracle Forms, Reports customization programming for Finance and Order Management modules in Oracle Application.
• Confidential has written interfacepackages in Oracle 9i, and developed scripts using sql loader.
• Confidential has been part of the data migration team and successfully completed major transition data after due business validation.
• Confidential has prepared project process documents and have trained new members into the project.

Confidential

Programmer Analyst

Responsibilities:

• Confidential had also been a Research Associate doingonlinemarket research and building profiles of executives like Board Members, CEOs and VPs for wide range of companies.
• Confidential was maintaining the Human Resource database management system that builds job profiles for various placement requirements.
• Confidential has done data cleansing and data migration using Oracle Sqland MS Sql
• Has good knowledge of MS Excel work sheet preparationdocumentation and presentation.

Confidential

Network Adminstrator

Responsibilities:

• Upgrading OS from Win 95 to Win 2000
• Daily maintenance and administration of the Computer Lab
• Teaching computer science in Matriculation and Technical Schools
• Imparting computer science to students from rural villages.