MUNWAR SHAIK
Dallas,TX
Summary
Certified Business Analyst with a proven track record enhancing asset management, risk management and operational efficiency through expert application of AGILE methodologies and advanced data analysis. Excelled in stakeholder engagement and regulatory compliance, achieving significant process optimizations. Brings a strong blend of technical proficiency in Hadoop and exceptional analytical skills to drive informed decision-making and project success. Expert on business and systems requirements, user acceptance testing and end-user training. Accomplished at leveraging past lessons to inform future decision-making. Release-planning specialist trained in advanced Excel modeling. Creative solutions architect with real-time problem-solving flexibility.
Overview
9
9
years of professional experience
Work History
Business Analyst
American Express
06.2021 - Current
- Design the Business requirement collection approach based on the project scope
- Participate in requirements analysis using a Use case driven approach and produced detailed use cases and functional specifications for all the interfaces
- Used Rational Rose and UML to produce use case models, sequence diagrams and class diagrams as part of the detailed design of interfaces
- Worked with IT teams to troubleshoot and enhance Hyperion Planning applications, ensuring business rules, calculations and integrations met the organization’s needs
- Wrote user stories & defined requirements for design and engineering teams on JIRA and Confluence
- Participated in sprint planning meetings and ongoing refinement of the product backlog
- Developing and executing SQL queries against data warehouses to support data mapping (GCP) and ad-hoc analysis
- Established and maintained traceability matrix until business requirements were signed off
- Hands on experience in creating Apache Spark RDD transformations on Data sets in the Hadoop data lake
- Facilitated budget management reporting by preparing monthly financial update reports, coordinating with other departments to secure relevant data, and verifying accuracy
- Proficient in creating visually appealing slides using design principles, color theory, and typography
- In-depth experience of capital markets, trade life cycle, various financial products and market risk concepts like VaR, Capital calculation, Sensitivities, Greeks, etc
- Managed Change control, ensuring any needed change requests were documented appropriately, routed through proper channels, and given necessary approvals
- Assisted the QA team with test case creation and maintained a dual defect tracking mechanism (JIRA and defect log) to track the status/completion of defects
- Facilitate, and manager meetings sessions with committee of SMEs from various business areas including Loan Monitoring, Asset Management, and Marketing
- Experience in working with Hadoop in Stand-alone, pseudo and distributed modes
- Develop Business Process Models in RUP to document existing and future business processes
- Perform extensive requirement analysis including data analysis and gap analysis
- Create User Documentation and conduct training classes
- Conduct user interviews and gather requirements using Rational Requisite pro
- Spearheaded a project to implement rolling forecasts, improving the organization’s ability to adjust budgets dynamically based on performance data
- Engaged in analyzing requirements, identifying various individual logical components, expressing the system design through UML diagrams
- Worked as a Lead BA from initiation to implementation contributing to planning, organizing, designing and prioritizing the features for the project
- Displayed BA skills by collaborating with multiple stakeholders to help consolidate various forms owned by different teams
- Gathered inputs and wrote requirements to better user experience
- Perform advanced data analysis to provide ad-hoc data queries in response to critical business needs using PL-SQL Oracle database
- Work closely with finance team and investment bankers to validate financial projections and deal assumptions
- Maintain and keep track of stakeholders requests for enhancements and changes using Unified Change Management tool (UCM) such as Rational ClearQuest
- Develop business requirement specification documents as well as high-level project plan
- Design and implement basic SQL queries for QA testing and report/data validation
- Translate the business needs into system requirements, communicating with the business on a broader scale and with an in-depth view
- Financial Modeling, Asset Performance Analysis, Portfolio Management, Regulatory Compliance, Stakeholder Engagement, Process Optimization
- Experienced Business Analyst specializing in asset management, with a strong background in optimizing asset portfolios, improving operational efficiency, and supporting regulatory compliance for diverse financial and physical assets
- Hands on experience in writing Map Reduce jobs on Hadoop Ecosystem using Pig Latin and creating Pig scripts to carry out essential data operations and tasks
- Successfully transforming complex data into clear, engaging charts and infographics and able to craft compelling narratives that engage audiences and communicate key messages effectively
- Good practical knowledge of current and future regulatory requirements and market risk concepts as it relates to exposure & regulatory capital reporting and to wider Market Risk management practices and procedures
- Assist the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations
- Assist with developing and maintaining quality procedures, and ensuring that appropriate documentation is in place
- Conduct User Acceptance Testing
- Developing Scripts and Tidal Jobs to schedule a bundle (group of coordinators), which consists of various Hadoop Programs using Oozie
- Worked on migrating existing mainframe data and reporting feeds to hadoop
- Go through the Budget Analyst posting you're applying to, and identify hard skills the company is looking for
- Good understanding of key risk concepts (e.g
- Traded products, VaR, stress testing, risk/limit management etc.)
- Function as the primary liaison between the business line, operations, and the technical areas throughout the project cycle
- Conduct benchmarking activities to identify best practices
- Environment: PowerBuilder, J2EE, Oracle, Hadoop, Rational Software Modeler, RUP, UML, SQL, MS-Office, MS Project, MS Visio, Test Director, Rational Rose, Requisite Pro
Business Analyst
Accenture Pvt. Ltd., India
03.2020 - 05.2021
- Company Overview: Client: Auto Owners Insurance
- Coordinated JAD sessions to understand the user requirements and also their system's implementation
- Demonstrated experience in Waterfall methodology activities for Requirements and Analysis phases
- Was Able to understand business goals and business context and translated them into technical specifications
- Demonstrated experience defining impacts of conversions, business rules, and configuration decisions on downstream systems and interfaces
- In Hadoop, HDFS, Map Reduce and Hadoop Ecosystem
- Good experience in system monitoring, development and support related activities for Hadoop and Java/J2EE Technologies
- Integrated Hadoop with Tableau and SAS analytics to provide end users analytical reports
- Supporting sensitivity analysis to see how changes in assumptions impact deal value
- Ability to train risk concepts to non-technical people
- Worked in a shared services environment with understanding of SOA
- Experienced in web services concepts and support utilities, related database utilities
- Demonstrated understanding and experience with ETL, Stored Procedures, and Queries
- Involved in gathering requirements, identifying and preparing Use Case specification documents, creating Traceability matrix and tagging it in the Rational Requisite Pro
- Creating custom templates that align with branding guidelines
- Developed Use Case diagrams, business flow diagrams, Activity State diagrams and Sequence diagrams using Rational rose so that developers and other stakeholders can understand the business process
- Identified and documented issues, risk and gaps, their descriptions, their impact and provided recommendation and alternatives to develop the application to meet the user requirements
- Developed spark applications using Scala for easy Hadoop transitions
- Exposure to Rational ClearQuest to track Project status, monitor workload and detect issues including defect submissions and enhancement requests
- Synchronized and prioritized relevant defects and enhancement/system requests based on business requirements, allowing sufficient time frame to ensure accuracy and consider deadlines
- Performed extensive data analysis and data integrity testing for loading and validation of the data set output
- Wrote standard and complex SQL queries using MS SQL Server and also in Mainframe for data validation process
- Wrote requirements for various reports to be generated and migrated
- Maintain documentation related to difficulties, complexities and anomalies that may arise during the ETL process
- Regularly followed up with Development Team to discuss discrepancies identified during testing
- Served as a liaison between the users, facilitators and the project team as a team lead
- Started learning and attending sessions on open source Big Data technologies like Hadoop and NoSQL databases
- Involved in the development of Project Plan in conjunction with the Business and IT areas
- Participated in User Acceptance Testing and Business-to-Business Transaction testing for the project
- Supported for the creation of test plans and the debugging of problems
- Client: Auto Owners Insurance
- Environment: Unix, Mainframe, Caliber, Rational Rose, Rational Requisite Pro, Rational Clear Case, UML, QTP, VB Script, MS Project, MS Office, DB2, MS SQL Server, Windows Server, Windows XP
- Developed high-quality documentation to support training efforts, helping employees fully understand new systems and procedures.
Business Analyst
Accenture Pvt. Ltd., India
09.2015 - 02.2020
- Company Overview: Client: Bristol-Myers Squibb Working through Accenture
- Was involved in the planning of the RUP iterations and documenting of the artifacts throughout the various phases of the development process
- Compiled the Vision Document and composed detailed Use Case Specification Documents in Rational Requisite Pro
- Used UML to perform Use-Case analysis to capture the dynamic aspect of the application
- Interacted with stakeholders and gathered requirements as per the business needs
- Ensured the accuracy and consistency of the data during the data loading process
- While working with various members at the management level to understand the business process and decision models, was also involved in Compiling the Vision Document and composing detailed Use Case Specification Documents in Rational Requisite Pro
- Was involved in managing the Daily Standup meetings and also ensured that quality standards were enforced as per the SME's build-release schedule
- Documented Requirement Traceability Matrix in Requisite Pro for traceability of requirements through test cases
- Developed Flowchart and process diagram using Microsoft Visio
- Was in regular contact with Business partners on the status of issues, action plans and timeframe for resolution throughout the development cycle
- Contributed in reviewing and editing of the test scripts
- Client: Bristol-Myers Squibb Working through Accenture
- Environment: RequisitePro, UML, Microsoft Office (Project, Publisher, Excel, Word, PowerPoint and Visio), Project Manager, PHP, Facets, Issue Tracker, Hyperion BI Applications, SDLC, Oracle 10g and VPN Client
- Developed high-quality documentation to support training efforts, helping employees fully understand new systems and procedures.
- Optimized workflow processes to enhance overall productivity and achieve operational excellence.
Education
Bachelor’s - computer science and technology
JNTUK
Andhra Pradesh03.2015
Skills
- AGILE
- RUP
- UML
- CMM
- ISO
- DMAIC
- Microsoft Project
- Hadoop
- JIRA
- MS-Office
- Google Cloud Platform (GCP)
- Power Point Content Management
- Microsoft SharePoint
- Pega
- Budget Management
- Documentum
- Rational Requisite Pro
- User Acceptance Testing
- Business Process Mapping
- Gap analysis
- Test case scenarios
- Risk Assessment
- Rational Suite
- Test Director
- Microsoft Visio 2007
- PVCS
- Rational Clear Case
- Oracle 9i
- Microsoft SQL Server 2005
- Windows Server 2003
- Java
- Python
- XML
- SQL
- MS-Project
- MS-Visio 2005
- MS-Excel
- Systems Analysis
- Project Management
- Microsoft Office Suite
- Requirements Gathering
- Data Analysis
Timeline
Business Analyst
American Express
06.2021 - Current
Business Analyst
Accenture Pvt. Ltd., India
03.2020 - 05.2021
Business Analyst
Accenture Pvt. Ltd., India
09.2015 - 02.2020
Bachelor’s - computer science and technology
JNTUK
Similar Profiles
Nemecio ContrerasNemecio Contreras
(Fraud Prevention) at American Express(Fraud Prevention) at American Express
Jorge Vance-GonzalezJorge Vance-Gonzalez
Travel Care Agent at American ExpressTravel Care Agent at American Express
Harshitha KomatineniHarshitha Komatineni
Software Engineer at American ExpressSoftware Engineer at American Express