SUMMARY

• Has over 19+ years of experience in the IT Industry as Project Manager, Business Analyst, Application Lead, Application Security Admn, Production Support Analyst and Developer. Performed in all phases of the Systems Development / Project Management Life Cycle.
• Managed and implemented midsize projects . Managed and coordinated triage of incidents & migration of changes, bug - fixes and upgrades. Performed SOX / application security audits working with PWC & external auditors. Configured and implemented application security measures compliant with company security policies.
• As Business analyst, closely worked with business owners and technical teams. Gathered and analyzed requirements, defined and documented detail specification, defined processes flows. Closely worked with technical teams in translating and developing functional code per requirements . Developed extensive test cases and performed unit /system tests . Coordinated UAT, change approvals and change migrations. Recommended, developed and implemented process improvements including security measures.
• As Project Manager efficiently worked with the business owners and technical teams. Managed and delivered Projects on time and on budget. Focused and monitored project milestones. Identified and analyzed risk factors and mitigated risk factors.

TECHNICAL SKILLS

• Strong business and data analytical skills.
• Strong Team player and interpersonal skills
• PeopleSoft Financials ( Accounts Receivables 8.0, General Ledger 8.0 Asset Management 9.0 and 9.1, Security Administration 8.0, 9.0 and 9.1)
• People Tools 8.17, 8.50 and 8.51)
• (Query Manager, DataMover, Peoplecode, App.Engine, Reports (Brio, nVison, Crystal)
• SQL, PL/SQL, Oracle SQL*Loader, Toad, SqlPlus, Sql Developer, DBParter
• Oracle SQL Procedures/Packages/Triggers/otherDatabase Objects 8.0, 8i,10g, 11g
• UNIX shell Scripts
• Autosys Scheduler Scripts (JIL scripts)
• Mainframe Focus Reports
• SOX and Application Audit Analysis
• Incident Management (IBM ManageNow, BMC Remedy and CA Technologies Service Desk)
• Resolution and Change Control Management (IBM ManageNow, BMC Remedy and CA Technologies Service Desk)
• Sharepoi nt 2016
• PVCS
• ETL
• HP ALM (Quality Center) 12.53
• CA Agile Central (Rally)

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

• Analyzed business requirements and business goals and created User Stories.
• Participated and coordinated business calls to review production issue logs and updated the Product Backlogs.
• Participated and coordinated Iteration/Sprint Planning calls and Sprint demo sessions.
• Participated in daily standup calls and provided status.
• Performed testing and validated requirements
• Created and updated help documents and training docs per enhanced functionality
• Created and published Release Notes

Confidential

Project Ma.nager/Business Analyst

Responsibilities:

• As a Project Manager, defined detail project plans, release schedules, monitored and focused on the project’s milestones and targets. Efficiently allocated resources, tasks, funds, and timelines and implemented projects following Waterfall Software Development Methodology.
• As a Business Analyst, closely worked with the business in understanding the business needs and requirements. Extensively analyzed the requirements and identified the gaps. Gathered relevant details, defined, documented, prioritized, designed, developed and implemented relevant changes closing the gaps.
• Led teams across Development, QA, Infrastructure, Release Management, Application Support and Business owners focusing on business objectives and achieving business expectations and goals.
• All process documents, processes flews, release schedule, release notes and system upgrade notifications were documented in detail and communicated to business and published regularly to the business portal.
• Defined and implemented strategy for business acquisitions and divestitures.
• Defined and implemented strategy to segregate data and decentralized the systems based on the Company’s core product groups and cloned systems per core product groups of the Company.
• Monitored and managed effectively and efficiently incidents and resolution of productions issues and bug-fixes on time without violating SLAs.
• Proactively monitored the core business batch processes and implemented mea,sures to cut down the processes time. Ensured Key data availability to business on time.
• Recommended and automated the manual processes wherever applicable.
• Closely worked and conducted weekly calls with business owners /users to understand business needs, system gaps, reviewed production issue logs, change resolutions and change migrations.
• Conducted meetings to gather, understand, review requirements design detail documents and proposals, test cases, obtain requirements sign off and freeze requirements.
• Conducted weekly status calls with the technical teams to track status and ensured development is adhered to approved requirements and on target. Ensured each and every update is thoroughly tested per each test case and available for UAT.
• Coordinated the UAT with business and obtain UAT signoff for every release.
• Raised Change requests and coordinated with Change Coordinators, business owners, application owners, release management to obtain approvals and promote the changes/updates to production environment successfully.

Production Support Lead and Security Admn

Environment: Peoplesoft Financials SP2, Tools 8.17, Financials/SCM9.1 -

Tools: 8.51, Brio Reports 8, Oracle 8i, Oracle 10g, Autosys Scheduling Tool 3.5, Unix 11.11, Web Logic 5.1 Manage Now Incident Management Tool, CA Service Desk Tool, Remedy

Responsibilities:

• Effectively and efficiently monitored system processes and batch processes and proactively resolved production issues without missing the SLAs (Service Level Agreement) and ensured system is up and running and financial transactions are posted on time without any delays.
• Performed Root cause analysis for all the Severity1 Tickets (Priority) and took measures to avoid recurrence of issues. Related fixes were thoroughly tested, validated and implemented in the production environments.
• Root causes analyses were completed complying with agreed upon SLAs (within the corporate stipulated timeline of two weeks) and presented to the Incident Manager and Business owners.
• As an Application Security Admn, developed and implemented appropriate User Access Roles for Asset Management, Purchasing and General Ledger Modules.
• Defined, developed strategy and successfully implemented Plant divestitures for Accounts Receivables and General Ledger Modules.
• Configured Master Data for Accounts Receivables.
• Configured AD (Microsoft Active Directory) user authentication functionality for financial applications.
• As a Source Code Admn, developed templates, promotion models and migration Paths for Source Code management tool (PVCS).
• Developed Production Support Procedures and Processes using CMMLevel IIIguidelines.
• Trained offshore peers to support the application.
• Extensively worked with PWC and external auditors in performing quarterly/yearly audits.
• Defined (ETL processes) data mapping elements, underling data objects, SQL data extract scripts and load procedures to extract and archive critical information from legacy systems and retain data per corporate data retention procedures/policies and decommissioned legacy systems.

Confidential

Developer and Production Support Analyst Duration

Environment: Ora.cle 8i, PVCS 6.5, DBPartner 4.1, J2EE/EJBs, JADE, SQL Worksheet

Responsibilities:

• Implemented a web-enabled product design and verification tool for engineers.
• Designed and developed Database Tables, Triggers, Procedures, Packages and established the constraints and Data Model charts.
• Extensive usage of Global temp tables both transaction and session level.
• Extensive usage of Cursors, Ref Cursors, Cursors with Parameters and loops, Varrays.
• SQL Tuning, Analyzing SQL execution plans using Explain Plan and TKPROF tools.
• Tuned critical slow running SQL statements by recommending new indexes, SQL hints re-writing the SQL statements.

Confidential

Developer/Analyst

Environment: Peoplesoft Financials 7.5, Peoplesoft Financials SP2 -Tools 8.1, nVision 8.1, Crystal Reports 8.1 and SQR Reports, UNIX, Oracle 8.1.

Responsibilities:

• Implemented 8.1 PeopleSoft General Ledger Module.
• Upgraded the existing 7.5 PeopleSoft Financial Modules - General Ledger, Accounts Payable, Purchase Order and other modules to web-enabled PeopleSoft Financial 8.x version.
• Customized SQR Processes, SQR Reports, nVision Reports Trees per 8.1.
• Created complex Queries using PeopleSoft Query Manager 8.1.
• Applied Upgrade Fixes and Patches.
• Set up ledgers for new business units.

Confidential

Business Analyst and Programmer Analyst

Environment: Ora.cle 8i, PVCS 6.5, DBPartner 4.1, J2EE/EJBs, JADE, SQL Worksheet

Responsibilities:

• Closely worked with the business in understanding the business needs and requirements. Extensively analyzed the requirements and identified the gaps, gathered relevant details, defined, documented, designed, developed and implemented relevant changes closing the gaps.
• Implemented a web-enabled product design and verification tool for engineers.
• Designed and developed Database objects like Tables, Triggers, Stored Procedures, Packages and established the constraints and Data Model Charts.
• Extensive usage of Global temp tables both transaction level and session level.
• Extensive usage of Cursors, Ref Cursors, Cursors with Parameters and loops, Varrays.
• SQL Tuning, Analyzing SQL execution plans using Explain Plan and TKPROF tools.
• Tuned critical slow running SQL statements by recommending new indexes, SQL hints re-writing the SQL statements.

Confidential

Programmer Analyst

Environment: Peoplesoft Financials 5, 7.5, SQR Reports, Ora.cle 8, Focus Reporting Tool, SQL*Loader, UNIX

Responsibilities:

• Implemented PeopleSoft Financials Asset Management, General Ledger.
• Developed records, views, panels, panel groups, menus, validations scripts based on user requirements to rollout finance systems globally.
• Developed interface processes, control reports in SQR.
• Developed a bridge program for legacy systems using PeopleSoft tools, SQR, Focus, SQL*Loader tools. Migrated data from legacy systems to PeopleSoft using PeopleSoft Import Manager, SQL*loader, PL/ SQL, and Focus Reporting Tool. Developed SHELL scripts to move data between different systems.

Programmer Analyst

Environment: SQL Windows (Gupta SQL), Oracle, Active Serter Pages, Visual Basic, CGI-BIN, MS Windows 95 UNIX.

Responsibilities:

• Designed and developed a client/server application to track corporate fleet systems, using SQL windows, Active Server Pages, CGI-BIN.
• Converted some of the SQL Windows code to Oracle stored procedures using PL/SQL.
• Designed and developed reports using SQL Windows Report Writer.