
AVIJIT CHATTOPADHYAY
- Business Analyst
- Philadelphia, PA
- Member Since Mar 04, 2023
Avijit Chattopadhyay
Qualifications for Application Business Analyst
Strategic IT Business Analysis │ Application Delivery │ Project Management │ Resource Allocation
Functional / Technical Design │ Requirements Gathering │ Test Scripts │ UAT │ Work Prioritization
Data Migration │ Application Upgrade │ Control Change Management │ Multidisciplinary Team Building
SQL Queries │ Application Decommissioning Processes │ High-Volume Ticket Management │ Problem Resolution
Highly Accomplished Business Analyst who makes decisions to reflect positively on globally based IT operations in alignment with a company’s vision, value, and goals, and who offers solutions-centric critical thinking for insightful, change-oriented results. Visionary Professional who rises above integrated applications challenges to achieve winning outcomes, including quickly adapting to evolving multi-site scenarios. Excellent Communicator who develops synergistic relationships with cross-geographical business and business technology professionals and clients, and who leads peers by example and with ethics and integrity to optimize IT operations success.
Professional Synopsis
XSELL Staffing (Client – Independence Blue CRoss Blue Shield.), philadelphia, pa 2017 – 2018
Enterprise Data Warehouse Application
Business Support Analyst (Oct 2017 – May 2018)
Worked on projects involving unification of Data Marts involving various call center applications and Consumer Data Research.
ü Successfully led Unification of the Data Marts.
Accenture (Client – Pfizer, Inc.), New York, NY 2008 – 2017
HR Data Warehouse Application
Business Support Analyst Lead (Jan 2017 – Aug 2017)
Capitalize on the opportunity to lead a Data Migration Team within the HR Data Warehouse Application upgrade.
ü Successfully led integration with upstream and downstream applications encompassing Data Analysis, Source-to-Target Mapping, Data Lineage Document Creation, and Data Profiling for Completeness.
Revenue Management System Application
Business Analyst (2016)
Strategically steered a details-focused Development Team for Interface Solutions of a Revenue Management System, including handling data verification of SQL queries and development of design documents for critical impact analysis, business requirements, and functional and technical design to meet and / or exceed core goals.
ü Comprehensively developed test scripts and conducted User Acceptance Testing (UAT).
ü Spearheaded application data enhancements involving design of Oracle PL / SQL procedures.
Application Data Migration & Decommissioning
Business Analyst (2012 – 2015)
Contributed sharp analytical abilities as the single point-of-contact among business and business technology leadership onshore while mentoring and managing a results-centric team of limited resources in the global, multi-market migration to SAP Financial. Expertly performed data mapping between source and target application.
ü Promoted efficient application decommissioning processes.
ü Led migration to SAP Financial ERP for both U.S. and Japan markets.
Ariba eProcurement
On-Site Support Lead (2010 – 2011)
Led targeted on-site initiatives within this client-facing role delivering solutions-focused coordination between offshore team and onsite client application owner. Liaised among a top-performing team to support various Java-based interfaces between Ariba eProcurement and additional upstream and / or downstream applications.
ü Successfully lead team managing the application in 100+ countries.
ü Seamlessly handled high-volume tickets and problem resolution.
Avijit Chattopadhyay
Page Two │ (908) 812-4738 │ avijitrupa3@gmail.com
Professional Synopsis (continued)
Accenture (Client – Pfizer, Inc.), New York, NY (continued) 2008 – 2017
Computron Financial Package
Application Techno-Functional Lead (2008 – 2010)
Played a vital role in serving as Module Lead of purchasing, accounts payable, and general ledger processes for this comprehensive Unix / Oracle-based financial application heavily batched to allow access to online transactions through VB and Java front-ends. Collaborated with business teams to understand process issues and application bugs, and actively worked with the application vendor to provide prompt and resourceful solutions.
ü Coordinated and led key application support efforts across all functional modules.
ü Ensured seamless application initiatives for a 31-member onshore and offshore team.
ü Co-designed, built, deployed, and supported numerous inbound / outbound interfaces.
ü Continually monitored change management processes to ensure ongoing strict compliance.
Education
Jadavpur University, Kolkata, India
Bachelor of Science in Electrical Engineering (Honors Graduate)
Technical Summary
Software: Unix │ Unix Scripts │ C │ Oracle │ Teradata | SQL │ PL / SQL
Oracle Procedure / Functions / Package │ TOAD │ Computron
AutoSys / UC4 Batch Solutions │ Informatica ETL │ Ariba │ Java │ SAP │ VB.Net
Microsoft Office (Word, Excel, PowerPoint) │ Microsoft Project │ Microsoft Access │ Visio
Functional: Code Migration Management │ Source to Target Mapping
Full SDLC │ Data Analysis │ Impact Analysis │ Business Requirements
Functional & Technical Design │ Test Scripts Development & Execution
P2P │ R2R │ O2C │ Fixed Assets │ Consolidation & Reconciliation Processes
Data Lineage Documentation │ Use Cases │ Requirements Traceability Matrix
Excellent Professional References Provided Upon Request