*.* yrs. of IT experience as Business Analyst, Apps Admin & Oracle Apps DBA roles

Skilled Business Analyst with 1.5 yrs of experience in managing various global/in-house applications. Committed to in-depth evaluation, requirement gathering, designing solutions and simplifying work. Experience in various business settings with clients of various backgrounds. Working experience from technical front as Apps Admin and Oracle Apps DBA is added on advantage.

Skills:

Advisor on regulatory compliance IT solutions entailing implementations across APAC region.

Working directly with clients and stakeholders to elicit their feedback on customer satisfaction items.

SDLC Methodologies and Project Management.

PL/SQL, Toad, Oracle Apps (Version-11.5,12.0,12.1), Unix, Linux.

Extensive knowledge in Strategic Planning, Production Methods, Leadership Techniques and coordinating resources.

Microsoft Office including Excel, Word and PowerPoint.

Work Experience:

Capgemini, Mumbai

(Project - Group IT Delivery)

Business Analyst

May-2017 to Nov-2018

Accomplishments:

Served as liaison between Group IT service team and project stakeholders/clients. Successfully led initiatives for procuring new servers for better performance of applications.

Collaborated with clients for change requests in applications (handled 15 applications as Appsspoc).

Documented project proposal for capturing requirements and prepared FSD’s, BRD’s and further coordinated with technical and testing team for implementation.

Acted as engaged contributor and person responsible for inaugurating iSprint event (specifically iSprint Quiz) at India level.

Demonstrated business values of FJT (Fresher’s Journey Tool), CVE (Client Visit Experience) through Yammer user stories and analytics.

Received appreciation/nominated in wall of fame for CQL (Capgemini Query League) quiz competition along with related activities. Quiz was organized by Quality team as part of iSprint event.

Key Areas:

Coordinated with Business Groups for Global/in-house Applications (14 Applications) pertaining to Fresher’s Journey, Client Visit Experience, Requisition Allocation, Audit Tracking, Project Metrics Tracking System, Risk Assessment tool etc.

Working directly with product owners and stakeholders for publishing monthly/weekly reports based on highlights and lowlights of various applications.

Weekly tracking of Completed/In-Progress/Upcoming CRs and follow-up for closure.

Monitored escalated incidents & issues, root cause analysis and status update to Management and Concerned Business Groups.

Tracked deployment timelines for each CRs on monthly basis in different phases (i.e. Analysis, Design, Testing and Deployment).

Published reports for quarterly Audit data, monthly Reports to SDM.

Had a full-fledged functional knowledge about applications. Coordinate with technical team for (.Net and Java) applications.

Regular/Weekly catch up meeting with Business spoc to understand future requirements, share roadmap for entire year with technical team.

Monitored CR’s and incidents and bring it to closure. Prepare reports for CR tracking for entire month.

Followed-up with other teams for server Vulnerability closure, backup restore, Decommission application and other server related activities.

As an Appspoc, verified changes in non-prod environment. Follow-up with testing and design team for new requirements.

Prepared Project Charter for new projects, estimate cost and resource planning.

Managed/updated Knowledge artifacts, AOD docs for each application after change. Share docs in common placeholder for future use.

Handled “Tabcorp INTECQ Integration Phase 2 Spare Parts” from Apr-2017 to May-2017.

Key Areas:

Deployed scripts (SQL, Package and prog) and executing in UAT and Prod Environment.

Monitored the RAC environment and health check at regular intervals.

Scheduled Concurrent programs after deploying the scripts.

Prepared Cut-over sheet with timelines as per the Business Requirement.

GE Healthcare, Bangalore

(Project - Global Application Management Support)

Apps Admin

July-2015 to Apr-2017

Accomplishments:

Won award for “Above and Beyond” support for best team in Quarter.

Part of Women’s Network team in GE and part of many events.

Received award for “Outstanding performance” in Quarter for doing automations in applications.

Received various client appreciation for helping them resolving bug fixes and long pending issues.

Delicately worked for client projects and update progress on periodic basis.

Being part of various Techno-cultural events, either as participant or organizer.

Managed vendor teams from TCS and Capgemini for followup issues and fixes.

Good terms with team across different zones, who worked on similar functionalities. Maintain good balance with DBA and functional teams.

Key Areas:

Resolved tickets related to– Manage users and assign roles, provide grants, SSO login, and Performance and memory issues.

Add nodes in RAC cluster, Use of srvctl utility to configure and bounce RAC instances.

Troubleshoot of label print and scanning issues.

Monitored Concurrent Manager and fix for long pending or inactive requests.

Managed Workflow notification mailer services bounce or configure listener for stuck events.

Import and Export various database objects from one environment to another, gather stats and compile objects.

Automated daily checkout scripts for monitoring services and compose them in alert format before the business hour start.

Worked as client to manage GE applications and handle vendors from Capgemini and TCS.

Tata Consultancy Services, Bangalore

(Project - Managed System - CISCO)

Oracle Apps DBA

July-2011 to July-2015

Accomplishments:

Oracle Certified Associate for 11g.

Received appreciation for Training and Mentoring team of Freshers.

Key Areas:

Troubleshoot Applications’ R12 issues with Forms/Apache/Concurrent Programs.

Configured listeners in main clusterware and check RAC specific background processes.

Applied RDBMS patches (OPatch) and Adpatch related tasks.

Clone from RAC to Non-RAC instance.

Administered the Oracle database and applications with the AD utilities. Adautocfg, Adadmin, Adpatch, Adrelink.

Monitored ASM environment as-Bounce services, checking the disk status.

Handled tasks for Web-logic – Created Data Source, Connection Strings, Bounce Services, and Troubleshoot of Web Services.

Supported Go-Live, Transition and Monthly activities.

Education:

Master in Computer Application (MCA)

2011

Jabalpur Engineering College, RGTU

75.5%

Bachelor in Science (Computer Application)

2008

Govt. Model Science College, RGPV

78.8%

Personal Details:

Date of Birth: 03rd January 1987

Passport: J37127 (Valid till 28 Nov- 2020)

Father’s Name: Ashish Kumar Mukherjee

Language: English, Hindi & Bengali

Nationality: Indian

Contact this candidate