Technical Business Solution Architect

Location:

Louisville, KY

Posted:

February 11, 2025

Contact this candidate

Resume:

Gampala Chandra Sekhar HIB

*********@*****.*** 901-***-****

Current location: Memphis, Tennessee

Objective:

Organized, detail oriented professional seeking position in a growth-oriented organization that will utilize my skills and diversified experience of Technical Business Analysis, Data Base Intelligence & Solution Architect in the domain of Manufacturing, Insurance, Banking/Finance, Health Care, Compliances, IOT, Retail, Poultry, Travel, SCM, CRM, Logistics, Asset management, Telecoms, BFSI Domain, ERP, and Web Applications.

Professional Summary:

An accomplished & Certified CBAP- Lead Technical Business & System Analyst / ERP- PMO Manager/ Scrum Manager with over 16+ years of relevant experience in gathering Technical Specifications, Data base Integration and analyzing business requirements and developing Solution specification documents.

Experienced ERP Technical Business & System analysts for Oracle, Epicor Prophet 21, SAP & Microsoft Dynamics application in Development & Implementation of Applications.

Experienced in Application API call integration by Using Json format & files. Technical & Data parameters push/Pull specifications between the application.

Worked with HIPAA EDI Transactions 837, 835, 820, 276, 277, 278 code sets testing in Health Insurance.

Worked on HRMS application implementation Like Workday, SAP SuccessFactors & Oracle HCM.

Worked on Various CRM application development & implementation like Sales force, Dynamic CRM, Kaptur CRM and Net Gen CRM.

Data Analytics & Analysis with Business intelligence tools like “Tableau & Power BI tools”.

Experienced Data designing, solution Architect, Report builder with Business intelligence tools like Tableau & Power Point.

Handling of all Software projects, IT infrastructure, Project Implementation (in house & External) & working with

CIO/Manager of Business Automation and IOT base Digitalization’s.

Building Data dashboards, Reports, Product Solution, UML & Object-oriented analysis & Design. Developing API’s

Integration Solution design & Specifications for Jason/XML base data integration.

Involved in End-to-End implementation of CRM/ERP/HRMS/Mobile Apps & BFSI Software Applications.

Experience & handling the Server Hosting Infrastructure for Application & Data base with AWS, Azure & Google Cloud servers. Monitoring the DB security, protection, Virtual configuration in cloud servers.

Domains working/ed on IT, Manufacturing, Insurance, Banking, ERP, HRM, Accounting, Agro Share Point Web application & Mobile apps, Call Center, Cargo Airline/Ship and Telecoms Domain. Major experience on Web & Mobile Apps Programs as BA/Scrum Product Owner.

Industry experience as a Business/Data Analyst with solid understanding of Business Requirements Gathering, Data warehousing, Data Modeling, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.

Experience in Handling team members, End User, Business Users, Stake holders, Project team leads and vendors.

Worked with product owner on small and medium enterprise business applications and prepared project scopes.

Solution-oriented professional Business Analyst who excels at collaborating with various project teams and interfacing with end customer/business teams to build successful solutions for clients.

Extensive experience in web technology, ERP, content management systems (CMS).

Extensive knowledge of working with marketing, sales, human resources, resource management, manufacturing, Procurement, finance (business) groups.

Excellent analytical skills for understanding business requirements, system requirements, data related requirements, business rules/processes, and detailed design of the application.

Expertise in software development life cycle (SDLC), requirement gathering, business analysis, system analysis, data analysis, risk analysis, feasibility analysis, impact analysis, gap analysis and process improvements, data modeling and mapping.

Expertise in Waterfall, RUP and Agile (Scrum, XP programming) methodologies. In-depth knowledge of designs using UML, Rational Rose, and Visio.

Experience in writing non-functional requirements, process flows, workflow diagrams, UML modeling, including use case designs, sequence, and state and activity diagrams.

Advanced analytical and project management skills, in-depth knowledge of various phases and methodologies of software development including SDLC, RUP project management methodology.

Extensive experience in translating complex business needs into clear and concise Business requirements documents (BRD).

Expertise in using leading industry tools like MS Visio, MS Excel, and MS PowerPoint to develop various project deliverable.

Experience in conducting Joint Application Development (JAD) sessions with end users to provide accurate statements of system requirements and a better understanding of common goals.

Exceptional ability to build productive relationships with colleagues, clients, and vendors across all functional and technical disciplines.

Excellent time management, communications, decision-making, leadership, and planning skills with the ability to learn quickly and multi-task in a fast-paced environment.

Handling & Conducting Reviews with Clients and Managers. Exposure on Data Modeling Techniques

Hand on Exposure on Software Testing Life Cycle. Having Strong exposure in preparing functional Test cases, Test case execution and RTM.

Coordinating with testing team to ensure that all requirements are tested properly. Preparation of Test Cases Based on the Use-Case Modeling. Conducting Training for End-Users.

Business Analyst with industry experience in business data modeling, software requirement analysis, process modeling, process flow and quality assurance skills using different methodologies, mainly OOA, OOAD and UML

Organized many Joint Application Developments (JAD) sessions and Joint Requirement Planning sessions (JRP), walk through, Interviews, Workshops and Rapid Application Development (RAD) sessions with end-user/clients/stake holders and the IT group.

Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.

Implementation of Agile scrum methodology for project development and training team members of Agile scrum

Depth knowledge on scrum meeting and sprint planning meeting with sprint black logs.

Handling Scrum Team & Clients in Agile methodology. Managing Sprint & scrum meeting regularly.

Preparing user stories, product backlog features & Sprint backlogs feature with product owners.

Handling Application Environments Configuration & Hierarchy management like Test server, Live Production server, Training server, Application development server.

Technical Specification in ERP application solution design & Development.

Good Experience in SharePoint, Oracle, SAP, Tableau, Power point technical system documentations.

Requirements Gathering. Use-Case Modeling/Preparation of BRD & FRD.

Proper stakeholder Interaction/Database Design: Conceptual Level, Logical Level, Physical Level.

Manual Testing & Knowledge as project manager/User Acceptance testing

Basic knowledge in java, j2ee, Html, Asp.net, C++.

Business Process Management/Requirement Elicitation/Change management/Strategic Planning/Business Case

Development/Use Case Scenarios and Application integration with Other Channels

Process Design and analysis/Feasibility and Impact Analysis/Gap Analysis/Test Plan /Team Coordination/Training

Product back logs requirement gathering, and handling teams work for sprints assigned.

Conducting sprint and scrum meetings, reviewing the sprints with stake holders and team members.

Good experience of using the Tools Like: MS-VISIO, ALM tool, JIRA Tool, Change Management tool and Share point Tool.

Good Experience on Agile Scrum, System Integration and Project management.

Worked on ERP, Web applications, Mobile (Android & IOS), Data base Migration, Application integrations development and Implementations.

Application Support & User Manual Management Trainings & SOP specifications.

Manufacturing/Retail/Ecommerce/ Omi Channels.

Banking /Finance/Air Line Cargo & Baggage Management/Pharmacy/HRM & Compliance – EHS Management/Health Care

Insurance (General, Life & Agriculture Crop Insurance)/E commerce/Construction/BFSI

Property Management system/Media & New Paper/Logistic-Transport Management-Ship Portal

Telecoms- Travel domain, Asset management, Identity Management.

Poultry Management & Food/retail Domain/Retail/POS/SCM/Logistics Transport Industry/Inventory.

Data Analysis & Design with BI tools like Tableau, QlikView & Power BI.

Education Qualification: -

(MIT) master’s in information technology (PGDIT), 2002-2004 with 82% Govt. of India, Nehru Yuva Kendra. Athma Institute of Technology.

(BCA) bachelor’s in computers. 1999-2002 with 72%, Osmania University.

Methodologies and Tools Web application Languages

Databases Operating Systems ERP Applications Cloud Servers

API integration

SDLC, RUP, Rational Rose, MS Visio, MS Office, Agile Scrum, Tableau 2023.1. Share point 2010, Java, Asp.Net, Web Services

Visual Basic 6, HTML, Java, c, j2ee, java script, xml, C, C++

Microsoft Access, Oracle 8i, SAP, SQL, Active Directory, Power Bi 2.109.1021. Microsoft Windows 95/98/NT/2000, XP

Open Bravo, SAP, Oracle, MS Dynamic Cloud Base ERP application AWS, Azure, & Goole Servers

Json format & Files

1.CSM- Certified Scrum Master from Scrum Alliance.

2.CBAP-Certified Business analyst Professional from IIBA.

3.PMP- Certified Project Manager Professional

Professional Experience

Client Name: - NTT Global Sep 2024 to till Date

Role: - Lead Scrum-PMO Manager

Domain: - HRMS/CRM/ERP (SAP & Oracle)/ Retail/Banking/Workday-Oracle HCM & SAP SuccessFactors HRMS

Project Name: - Cloud and AI-Based SaaS for Career Acceleration and Talent Management

This project endeavors to create a Cloud and AI-based Software as a Service (SaaS) solution tailored for job seekers, offering career acceleration tools and talent management solutions for employers. By leveraging advanced technologies and a robust technical stack, our platform aims to redefine the job search and talent acquisition landscape.

Technologies and Tools

The project will utilize the following technologies and tools:

Languages and Scripting: Java, Groovy, SQL, Python, JavaScript, jQuery, backbone.js

Frameworks: Hibernate, Spring MVC, CDI, Spring Boot

Web Services: REST API, SOAP • Applications: IntelliJ IDE, Eclipse

Application Server: WebSphere, Tomcat

Operating Systems: Windows, UNIX, Linux

Database Systems: SQL Server, MySQL

Version control, project management and issue tracking: JIRA, GIT, SVN • Jenkins: For continuous integration and automated builds.

Responsibilities & Roles: -

Gathered and Technical documented business requirements for existing and future business systems.

Acted as a liaison between business staff and technical staff to articulate needs, issues, and concerns.

Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including JIRA, Erwin, JAD sessions, MS PowerPoints.

Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.

Prepared the Documentation like -BRD/FRD/SRS/DRD/Use cases/Scope/ Gap analysis/ API integrations.

Designed the System process flow and Data Modeling with PowerPoint tools for dash boards and reports.

Created surrogate key tables & RTM to map the required dimensions & requirements for development.

Developed Requirement Gathering Strategies and Project Implementation Scope & Plans.

Ensured that all Lines of Business specifications were consistent in form and function to the development team.

Ensured that project requirements are properly tracked and documented.

Used MS-Visio for flow-charting, Use- Case process model and architectural design of the application.

Successfully conducted JAD sessions, which helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project.

Tracked UAT issues/bugs and prepared reports.

Capture and Formulation of Business Rules and delivery of Business Rules Templates.

Creation of UML Diagrams including Context, Business Rules Flow, and Class Diagrams

Created Business process workflow diagrams using Visio.

Created requirements analysis and design phase artifacts using, MS Visio to create DFDs, ER diagrams, Use Case, Activity/State chart, Sequence, Collaboration and Deployment Diagrams.

Involved in Increment Model base Project Implementation & Development for different Module of business applications.

Involved in SDLC, STLC & UAT process of ERP application implementation.

Prepared required Policy documentation for ERP user controls and User Manual specifications.

Implemented “MOSCOW” techniques for Business & system features finalization for implementations.

Prepared Mock-up design and worked with U1/UX team for form design and customizations.

Worked on Logic controls and configuration in ERP application with Development team.

Prepared the Bug Tracking and TEST Cases for QC team.

Worked on Data integration and analysis by Integration with Tableau tool for creating the Dash Boards and reports.

Prepared Technical specification Interfaces and Data Base structure for reports.

Configured the SharePoint & Active directory for Controlling user access controls.

Handling Project Development, Data base, Deployment, and support configuration teams.

Prepared API integration Data parameter documentation and design.

Prepared Sql queries, Data base Management, Business intelligence tools like Tableau, Power Bi, IT infrastructure management, Process Flow charts using MS visio & UML Diagrams.

E-R Diagrams, DFD and Design & develop Business process Flow Charts.

Prepared Scope and Technical documentation of API integrations, JASON format & POST man tool.

Client: Medica, Minneapolis, MN (Worked remote) Sep 2023 to Aug 2024

Role: Lead Business & System Analyst/PMO Manager

TPLA – Third Party Liability (Data Mapping) This application enables to extend the capabilities of existing systems to validate customer details and running through the EDI messaging processes, can also be used for billing calculations from doctor’s office to end customers.

Responsibilities:

Worked with the business users and with different levels of management to identify requirements, use cases and to develop functional specifications.

Defining, documenting, and testing system enhancements.

Identified, researched, investigated, analyzed, defined and documented business processes

Wrote Technical/Functional specifications documenting all TPLA requirements and modifications

Interacted with business heads to finalize the Business Requirements for the application.

Analyzing EDI files and creating the documents as reference material for dev team.

Collaborated with UX/UI designers to design intuitive interfaces for accessing product, while maintaining consistency with PDM system interfaces.

Designed and developed RESTful APIs using Postman and Swagger for efficient communication between different applications.

Created data mapping documents for the movement of data from production databases to the warehouse

Worked closely with Business, QA, and Developers to design functionality that meets the needs of the Business.

Follow up with queries and questions regarding defects that have been logged to ensure their respective solution is in place moving forward in the project.

Participated in JAD sessions with our technical team along with the carrier’s technical team to build the new System Design for the crosswalk project in accordance with the Health Care Reform Act

Involved in Daily Scrum meetings.

Extensively tested ANSI X12 270 and 271 for Eligibility and Coverage Inquiry and Response also Tested ANSI X12 276 and 277 for Claims status Inquiry and Response.

Conducted functional and integration testing of APIs using Postman and Swagger to ensure their compatibility and reliability.

Identified actors and use cases for Care management and utilization management from the requirements and prepared Use Cases Diagrams, Business Process Flow, Activity Diagrams and Workflow Diagrams to understand the interaction between actor and the system using MS Visio.

Worked on EDI transactions: 270, 271, 834, 835, and 837 (P.I.D) to identify key data set elements for designated record set.

Extensively worked in Data Requirement Analysis and Data Mapping for ETL process.

Used JIRA for tracking defects and managing the project. Documented User Stories and facilitated Story Point discussions to analyze the level of effort on project specification.

Created JIRA workflows including project workflows, field configurations, notification schemes, etc. in JIRA.

Worked closely with cross-functional teams, including marketing, sales, IT, and product management, to ensure that both OMNI channel strategies and PDM system enhancements align with business objectives.

Analyzed API (SOAP and REST API's); validated XML, identified enhancement features.

Understood the detailing of Medicare/Medicaid Claims processes from Admin/Provider/Payer side which were later part of the training program to vendors.

Conducting weekly project core team meetings, updating meeting agendas and notes on the project SharePoint site

Created SQL tables with referential integrity, constraints and developed queries using SQL, SQL*PLUS and PL/SQL.

Review several API requests and responses using trace tool and Ready API for writing specifications for new projects doing Gap analysis of tables and fields to add to API's.

Conducted team meetings and JAD sessions with the SMEs, stakeholders and other management teams.

Writing test plans and defining test cases involving GUI Testing and Prototype Testing, Regression Testing and User Acceptance Testing (UAT).

Maintained data quality by Data Analysis, Data Profiling (row/column level, statistics, pattern, etc.), Data Validation, reviewing logs and repository tables and making sure there are no duplicates, bad data, rejections, empty data in null columns, etc.

Triage requests and troubleshoot issues; report defects/bugs for development teams

Client Name: - MS Agarwal Foundries Pvt Ltd Dec 2022- Sep 2023

Role: - Lead Business Application Head /PM/ERP solution Architect.

Domain: - Manufacturing/Retail/E-commerce/Logistic/Health & Environment.

Project Name/1: - Lighthouse -Oracle ERP application Implementation & Development.

Project Name/2: - Focus & Sales Force CRM application Development and Integration.

Project Name/3: - Supply Chain Management & Logistics Management-Fretron-TMS application Implementation.

Project Name/4: - Machine Learning & AI tools for Document Validation (Amazon). Speech to Text AI tool implementation. Project Name/5: - Cloud Server Migrations & Business Application-SOP policies Implementation

Project Name/6: - SharePoint Intranet Portal Development.

Project Name/7: - Compliance Tracking application (Deloitte) & EHS Application. Project Name/8: - HRMS application (Adrenalin Max)

Project Name/9: - Digital Signature Platform Integration (EMudhra). Project Name/10: - Ecommerce Portal & Mobile App Development.

Role Activities:

PMO Lead for business application development & Integration.

Vendor & Stakeholder analysis Management.

Handling Development & Support team for Various Projects.

Software implementation & technical Specifications documentation

Business Solution Process finalization with KPMG Group.

Preparing Project Scope, Designing Data Base Model, Cloud Hosting structure, Vendor Management.

Business intelligence (Power Point & Tableau) tool configuration and development business dashboards/ reports.

Object Orient Analysis & Design the System & Workflow Management by UML Diagrams.

System & Business process flow finalization and discussion with Key Stakeholders.

Handling Cloud infrastructure & data security Management.

Responsibilities:

Gathered and Technical documented business requirements for existing and future business systems.

Acted as a liaison between business staff and technical staff to articulate needs, issues, and concerns.

Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including JIRA, Erwin, JAD sessions, MS PowerPoints.

Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.

Prepared the Documentation like -BRD/FRD/SRS/DRD/Use cases/Scope/ Gap analysis/ API integrations.

Designed the System process flow and Data Modeling with PowerPoint tools for dash boards and reports.

Created surrogate key tables & RTM to map the required dimensions & requirements for development.

Client: Prayagh Nutri Products Pvt Ltd Hyderabad June 2022 to Dec 2022

Lead ERP Technical Business System-ERP oracle-PMO Manager & Solution Architect.

Project Name: - Microsoft Dynamic 365 CRM- Business Central Application.

Microsoft Dynamic 365 ERP application is under implementation to steam line Prayag Nutri Products business process like Finance & Accounts Management, Sales Management, Purchase, Inventory, Production, Dispatch, Planning, SCM, Reports & Dash Boards. ERP enables the end user to maintain accounting transactions and inventory transactions with reports according to their business transactions. ERP application Integrated with CRM, Omni Channels & PowerPoint tools for Data migration and Data base reports.

Domain: - Manufacturing/Retail/E-commerce.

Environment: - Microsoft Dynamic Cloud ERP/ BI Tool/MY SQL/Azure Cloud Server/SharePoint/MSOffice- 365/JIRA/Dot.net/Agile Scrum Methodology/STLC/SDLC/MS-VISIO/JIRA/Active Directory/Post-Man Tool. Version: - Microsoft Dynamics 365 Version-10.0.24.

Project/2: -Oracle ERP Cloud Implementation & Development- Ebiz frame

Project/3: -HRONE (HRMS Application Development).

Project/4: - Business Intelligence- Tableau Tool.