SUMMARY:

• System integration/Business System analysis/Data Analysis with 13+ years of experience in handling complex IT projects coupled with international experience in Business Requirement Specification, Product Demonstrations, Use Case Modelling, Solution design, Data modelling, Requirements & Traceability management and team leadership;
• Domain experience includes Banking Solutions, Mortgage, Retail, Supply chain and FMCG.
• Excellent knowledge of SDLC Life - Cycle phases and knowledge in Scrum/Agile and Waterfall methodology; Over 6 years of experience in Agile development process.
• Preparation of business and functional specifications, analysis of current and planned systems, workflow and business process documentation , Interface Documentation (ICD) , utilization of use case analysis and UML models .
• Experience in analysing (SQL) and interpreting complex large data sets from multiple data warehouses & requirement analysis of data warehousing applications and provide solution & Design to ETL (Ab initio) team
• Expertise in developing successful, scalable, reliable and efficient Risk Data Warehouse in Teradata integrating with various application (E.g. IBM-PRIME, Chordiant, TSYS, Serengeti, PEGA)
• Expertise in Business Requirement Documentation (BRD), Black box reverse engineering, Business Risk management, Change management, Knowledge management, Functional Specifications Document (FSD), High-level test plans and UAT plans and Cost benefit analysis to improve ROI of the IT projects.
• Expertise is gathering reporting requirement, providing design and Mockup data for development in Business Objects (BOBJ)
• Strong communication skills to complement requirement elicitation, requirement analysis, requirement management & communication, enterprise analysis, solution assessment & validation, status-reporting, issue escalation/remediation and stakeholder meetings
• Experience in IT Process Engineering, IT process formulation, articulation and education. Creating business process maps & models by analysing the business, organizational behaviours and standards.
• Extensive experience in Recovery Planning, Platform Management, Audit, Risk and Defect Management
• Highly adaptive and proven ability to work in a fast paced & Complex team environments.
• Implemented Six Sigma/ Lean management & modified processes to comply quality certifications like ISO.
• Identified the clients requirements & product requirements by SWOT analysis, Fish bone diagram.
• Acted as the primary POC during UAT stage, working along with end users & business reviewers.
• Experience in handling complex IT projects with demanding timelines
• Document the functional flows using MS Visio.

TECHNICAL SKILLS:

Operating Systems: Windows (7, XP, 2003,10)

Databases: Oracle, DB2, MS-Access, MySQL, Teradata

Tools: Bosh VisulRules, Actico VisualRules, ERWIN, Web-EME,MS-Word, MS-Excel, MS-PowerPoint, MS-SharePoint, Vizio, VersionOne, HP-QC, HP-ALM, Requisite-Pro, ClearCase, MS-Project, Clarity PPM, Business Object (BOBJ), Visio

Methodologies: Prototyping, Test Plan Development, Agile, Proof of Concept, Use Case, UML

Products/Applications: SAP, InfinityQs, IBM- PRIME (SAS), Chordiant, TSYS, ICMS, Casewise, Serengeti

PROFESSIONAL EXPERIENCE:

Confidential

Rule Modelling/Business Analyst/Data Analysis Lead

Responsibilities:

• Understand the current SaaS model which had limited documentation and support
• Come up with requirements for the ALSE by reengineering the SaaS code.
• Understand the 2 existing scoring methodologies calculated in SaaS and understand 2 new methodologies to be implemented.
• Create sample functionalities to capture FHFA reference file which is used in the scoring methodologies. Based on the suggestion implement the models.
• Instrumental in creating batch process where the propertied of current year acquisition are scored on daily basis.
• Created automated XML generation for sending the data from ALSE DB to Target State Data warehouse.
• Created Data load model to pull data from Target State Data Mart to ALSE DB to process batch process
• Implemented single Model methodology to work on multiple environments.
• Worked with Testing Team in creating Test Case and worked with business team in completing the UAT.

Confidential

Responsibilities:

• Led a group of 5 analysts in gathering requirement for multifamily business.
• Had inventoried all ICD from CMDB in turn to inventory all the attributes from ICD
• Based on the above inventory had to come up with data lineage between system i.e. finding the upstream and downstream impacts
• Based on Data profiling/Mining trying to standardise the data points across systems
• Created place holders for accommodating manual data points used every system other than ICD
• Consolidated 30,000+ attributes into 6000+ attributes and pushed to Data governance team standardising the business name.
• Created requirement document by application both as user and consumer to finalize the total requirement to Target State Data warehouse requirement.

Confidential

System Integrator/Business System Analyst

Responsibilities:

• Design and development of Risk Data Warehouse (RDW) on Teradata platform to support Operational Risk Management (ORM)/Enterprise Risk Management (ERM) and ILD reporting needs.
• Designed and developed a brand-new data warehouse with 250+ tables to store ORM/ERM Risk data (including Operational risks, Credit risks, Liquidity risks, Market risks etc.) and Internal Loss Data (ILD) from several sources (D3, Serengeti, ICMS, Tsys etc.)
• Created use cases, utilized UML technique to document business processes.
• Responsible for creating & updating the Interface Control Documentation (ICD) to be in line with changes in Upstream & downstream applications
• Built Couple Custom SQL reports to monitor the Loss Data and had to alert the business if the Threshold value is exceeded or any unforeseen exceptions occur
• Had to come up with Mock ups & design for Business object team(bobj) for reporting requirements including sharing the join & filter conditions.
• Responsible for creating and designing views, SQL, PL/SQL to determine the optimal access and relationship between the data objects.
• Did Data profiling/Mining for many of internal & external sources to understand the data lineage.
• Did a Black box re-engineering on Source Data when forklifted from a Sunset system.
• Responsible for requirement elicitation & documentation, impact analysis and obtaining the approvals from the required business partners.
• Played Instrumental in providing design to ETL Team for Unique ID creation and Delta processing based Source data profiling.
• Responsible for Root Cause analysis and day to day Source data rejects in ETL load to warehouse and had provided permanent resolution.
• Responsible for task prioritization; created task WBS to prioritize and assign the tasks to the team members.
• Managed and directed efforts of project leads and developers to ensure effective planning and synergy among project teams.
• Responsible for validating the Business object reports by comparing the output with SQL query output (Built based on for the report intent).
• Responsible for creating user acceptance documents and review the same with business sponsors and stakeholders.
• Worked with the project sponsor to create and maintain work pipeline and forecast for the project IT team.
• Review of system test plan and UAT test plan for ETL/Ab initio, Business Objects, Oracle & Teradata.
• Review of high-level designs for Business Objects, Oracle & Teradata
• Developed a Presentation layer to support ORM/ERM reports development using Business Objects tool and ILD reporting. Several ETL jobs are designed and developed to source data from IBM’s GRC/PRIME Open pages Oracle database and several ILD sources and load RDW tables on Teradata platform .
• 30+ complex reports (100+ fields in each report) were developed using Business objects to support ORM/ERM reporting needs.
• Responsible and accountable for understanding the ASIS process and creating the process map capturing the current and future state of the process.
• Preparing a process overview for individual processes which is simple to understand and is used to train the new person taking the responsibility in the process.
• Capture all applicable laws, regulations and policies pertain to the process and identify the current control measures around these parameters. Also suggested improvements when required.
• Maintain continuous alignment of program scope with strategic business objectives, and make recommendations to modify the program to enhance effectiveness toward the business result or strategic intent.

Confidential

Process Lead/ Business System Analyst

Responsibilities:

• Identify the high risk processes.
• Identifying the current ASIS process - Due to Confidential portfolio change policy, there was no SME available to give insight of END to END process. Current processes did not have process owner
• Understanding & outlining the applicable Laws, regulations and policies.
• Used UML models: collaboration model, sequence model, deployment model, activity model .
• No proper Control methodologies in place. So needed to capture the existing Control measured
• Many Current systems were undergoing transition.
• Many current Products were de-scoped and new products were added to the current consumer offering
• Part of project-managed large-scale initiative involving the Standardization of the current process flow and building sustainable artefacts/control measure etc. to ensure the process is effective and sustainable.
• Driving the Risk Assessment session with the business team to derive at top high risk process based on the complexity and transactional volume of the processes
• Responsible and accountable for Understanding the ASIS process and creating the process map capturing the current and future state of the process
• Prepare a Process Overview for individual process which is simple to understand and is used to train the new person taking the responsibility in the process.
• Build credibility, establish rapport, and maintain communication with all stakeholders in the project at senior management level.
• Define SIPOC and assign RACI to the Processes to ensure the ultimate success and acceptance of the process.
• Based on the VOC of the customer identify the customer and shareholders expectation and derive at improvement and control points in the current process to meet the requirements
• Capture all applicable laws, regulations and policies pertain to the process and identify the current control measures around these parameters. Also Suggest improvements when required
• Maintain continuous alignment of program scope with strategic business objectives, and make recommendations to modify the program to enhance effectiveness toward the business result or strategic intent.
• Coach, mentor and lead personnel within a team environment.

Confidential

Project Coordinator/Business Systems Analyst/Process Analyst

Responsibilities:

• As it was an enterprise wide initiative, the platforms/systems & interfaces that were impacted were more than initially identified, so requirements and dependencies changed often.
• Many legacy systems did not have proper system/ functionality documentation or SME support, so it was tough to understand the existing system and to predict changes required based on the new vision.
• High resource and time crunch, as many platforms were interdependent to deliver its functionality with in the organization's ambitious timeline.
• Closely involved with enterprise risk office and compliance team, to make sure that the identified changes are implemented as per the regulatory and organizational guidelines.
• Created use cases, utilized UML technique to document business processes.
• Had to come up with Mock ups & design for Business object team for reporting requirements including sharing the join & filter conditions.
• Part of project-managed large-scale initiatives involving the transition of programs to new platforms and the merger of disparate systems from acquired client companies.
• Responsible for creating and designing views, SQL, PL/SQL to determine the optimal access and relationship between the data objects.
• Did Data profiling/Mining for many of internal sources to understand the data lineage.
• Did a Black box re-engineering on COTS product Data and played instrumental in creating home developed replacement system.
• Responsible and accountable for the coordinated management of multiple related projects directed toward strategic business and other organizational objectives.
• Responsible for creating data mapping & data model diagrams among various database tables to generate the required analysis snapshot reports in Business Objects.
• Build credibility, establish rapport, and maintain communication with stakeholders at multiple levels, including those external to the organization.
• Define and initiate projects based on VOC, and assign RACI & FMEA to the projects, while working to ensure the ultimate success and acceptance of the program.
• Maintain continuous alignment of program scope with strategic business objectives, and make recommendations to modify the program to enhance effectiveness toward the business result or strategic intent.
• Coach, mentor and lead personnel within a team environment.
• Present periodic dashboard reports on the current program, future opportunities and customer (Internal & External) issues.

Confidential

Business Analyst/ SAP MM Consultant

Responsibilities:

• Managed relationships with established key accounts and developed new accounts.
• Created internal processes & procedures to ensure delivering account specific commitments.
• Collaborate with senior management and sales teams on project development, pre-sales meetings with clients, and definition of enterprise architecture.
• Improving the process & transparency in projects by creating SIPOC with Project team members.
• Conducted annual customer perception survey and implement action plan to improve KPIs.
• Lead development of requirements, data models, and all documentation throughout project lifecycles.
• Ensured continuous improvement in the process by Initiating Kaizen activities across the projects
• Involved in Specification, Design, Development and Reviews.
• Understanding functional and technical effects of segregation of company codes on SAP System.
• Responsible for providing consulting solutions to the Business Users and doing customer specific development.
• Provide Consulting expertise in understanding the As-Is process, identifying Gaps and Opportunities, and making recommendations.
• Familiar in using Various SIX SIGMA tool Fish bone diagram/Histogram/business process mapping/Pareto Analysis
• Interview SMEs to understand the current process
• Identify systems involved and understand system interaction
• Prepare Process Flow diagrams
• Prepare Project Charter
• Help build Business Case for the project
• Coordinate and hold meetings with stakeholders
• Participate with Business to understand Business Needs
• Provide Consulting expertise in developing and documenting Business Needs.
• Analysed various Demand planning & supply software
• Concepts like ship to store (depot), Kanban System, JIT. Reorder level Calculation were derived and implemented in various systems for complete transparency across space
• Two Partnering Successfully established through understanding the requirements from the existing client accounts and generated revenue.
• Played a role in developing “Sustainable water Solution” and “ITPO” (which integrated to ERP) solutions.
• Played a major role in Global Supply Chain Integration for Cargill foods by implementing various MES Roll out at various sites & coordinate with the SAP up gradation vendor for integration, testing, training & developing customized reports.

Confidential

SAP Logistics Execution Consultant

Responsibilities:

• Received the “Performer of the year” award among 2000 employees.
• Mapped business processes, analysed initiative, event, exception, and change management controls, and assessed waste, gaps, and redundancies that created time
• Requirements Management and Traceability
• Develop Business and Functional Requirements
• Testing supervision
• Functional Testing
• User Training
• Assessed root causes, not symptoms, of waste and non-value added activities.
• Defined Six Sigma and LEAN end-to-end management processes that could continuously re-evaluate and quickly improve company organization, with prioritization of business unit initiatives and corporate wide alignment.

Confidential

Senior Executive

Responsibilities:

• Got promoted to independently manage the strategic sourcing of many product groups within one year of joining.
• Successfully performed design validation and manufacturing feasibility of new products.