* ***** ** ********** ** a Business Analyst/Business System Analyst in industry domains including Banking, Financial, Insurance, and Retail.
Skilled Business Analyst in PMO environment who leads projects to successful completion and acts as liaison between business users and technical development teams to bridge gaps.
Strong understanding of financial valuation concepts and various capital market instruments and processes including Equities, Fixed Income, Foreign Exchange, Derivative (OTC) & Back-Office operations, Basel III, Dodd-Frank Act and Comprehensive Capital Analysis and Review (CCAR). and experienced in Black Rock Alladin, Bloomberg, Reuters.
Well versed with Investment banking (Equity trading, Future's market, Forex market), Commercial Banking and Retail banking (Mortgage, Student loans, Credit and Debit cards).
Working knowledge of Amazon Web Services (AWS) and Cloud Data Management.
Exceptional problem-solving and communication, with in depth understanding of Big Data Application, Databases, Enterprise Architecture and Cloud technologies. Enjoy getting hands-on development experiences.
Proficient in designing placeholders for ads and integrate with ad-exchanges. Shopping carts, site themes and payment gateways in CMS like Drupal, Joomla, ATG and self-hosted websites.
Extensive experience in project management best practices, processes, & methodologies including Waterfall, Agile, SCRUM, and Rational Unified Process (RUP).
Worked in Agile environment and involved in sprint planning meetings.
Worked with star and snow flake schemas to create fact and dimension tables.
Participated in Scrum meetings to handle unpredicted changes and effectively deliver the product with in the given deadline.
Experience with the Atlassian JIRA and Confluence.
Experience in understanding Stored Procedures, Stored Functions, Database Triggers, and Packages using PL/SQL.
Good understanding of Data Warehousing concepts including Data Marts.
Strong Understanding of Data Modeling and Business Process Modeling.
Worked on the development of dashboard reports for the Key Performance Indicators (KPI) for the top management.
Mastered the ability to design and deploy rich graphic visualizations with Drill Down and Drop-Down menu option and parameterized using Tableau Desktop.
Having experience in performing VLOOKUP’s, HLookup’s, Power pivot and Pivot table in MS-Excel.
Experience in working under Agile (Scrum) and waterfall models of software development life cycle.
Experience in consulting with business clients, creating Tableau dashboard reports, collaborating with developer teams, using data visualization tools, and using the Tableau platform to create business intelligence visualizations.
Excellent skills in performing Gap Analysis, Feasibility Analysis, Knowledge with BABOK standards and methods, Strengths, Weakness, Opportunities, Threats (SWOT) Analysis to check the compatibility of the existing system infrastructure and server technology with new Business Requirements.
Proficient in executing Test Plans, providing Test Data, conducting unit test, documenting test cases and in Manual Testing - Functional, Database, Black Box, Positive-Negative, and Regression testing.
Experience in writing User manual, conducting functional walkthroughs, and in performing extensive User Acceptance Testing (UAT).
Ability to manage multiple, concurrent projects, activities and tasks under time constraints.
Business Analysis Skills
Scope Initiation, Business Proposals, Requirements Definition, Problem Resolution, Structured Walkthrough, Workflow Analysis, Gap Analysis, Design Review, Business Process Management, Product Management, Business Impact and Risk Analysis, Gate Review, Confirmations, Post-Implementation Review, Defect Management, Data Analysis, Data Reconciliation, Data Governance and Data Management.
Project Management Skills
Change Management, Client Relationship building, Risk Management, Strategic Planning and Reporting, Technical Writing, Budget Planning & Cost control, Vendor Management, Strategic Change Management, Onsite-Offshore Management, Virtual team Management.
Testing Tools (QA)
HP ALM, HP Quality Center/Test Director, HP Performance Center/Load Runner
Business Process Modeling
UML/ Use Case Diagrams, Class Diagrams, Object Diagrams, Package Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Communication Diagrams, Component Diagrams, Deployment Diagrams, Process Flow, ER Diagrams and Data Flow Diagrams (DFD)
Oracle 11g, 10g, Oracle 9i, Oracle 8i and Rainstor file system, NoSQL (Mongo DB)
Windows XP/Vista/7/8/10, MAC OS X
MS Office - Word, Excel, Outlook, PowerPoint, Visio, Project
Microsoft Live meeting, WebEx Products, SharePoint
Informatica 10.1 (PowerCenter/PowerMart)
Reporting & Data Visualization Tools
Business Objects, Crystal Reports, Cognos, Tableau
Amazon Web Services (AWS), Actimize (AML), JIRA, Bloomberg, IBM Rational Rose, Smart Draw
P.F. Chang’s China Bistro, Scottsdale – AZ Nov 2018 to Present Senior Business System Analyst/Data Analyst
P.F. Chang is one of the fastest growing restaurant chain having 200+ restaurants in US and 100+ Global. In P.F.Chang I am working as a Business System Analyst and Data Analyst where my project is to enhance their Inventory Management System manual to automatic.
Involved in gathering requirements, interacted with business heads to overview business process and create the work flow for the proposed systems/applications.
Working closely with a Project Team implementing AWS Cloud Based Inventory Management Solution.
Worked in cross functional teams including Infrastructure Team, Supply Chain, Marketing and Development.
Facilitated requirements gathering sessions, review meetings and project status calls with vendors and stakeholders to refine the requirements for open and pending issues.
Created the process flow diagram with help of using MS Visio tool.
Created As-Is and To-Be processes related to inventory project.
Created a SharePoint site to house all technical and user documentation.
Working closely with Business and IT for documentation (BRD, FRD, FSD, Change Request, Mapping, WorkFlows) of requirements.
Helped create human resources SharePoint sites to track training status, roadblocks, and CRQ (Change Requests).
Write Use Cases and functional specifications to enable design and solution.
Developed Traceability Matrix for maintaining/updating current and new system requirements using MS Excel.
Work with the Development and QA teams for documentation of Test Scripts.
Create UAT test scenarios, test cases and coordinated UAT efforts.
Prepare AS IS and TO BE system process diagrams, data mapping documents, business rules documents, Data Dictionary and function specification document.
Perform Impact analysis using Informatica Metadata Manager by extracting data lineage information for Data Structures (source/target/target definition), Fields and multiple power center Repositories.
Prepared test Data and performed Data Testing using the SQL queries in TOAD.
Work on Advanced Excel for Data Mapping and Data Analysis Reports.
Conducting daily standup meetings.
Created security diagram for the infrastructure team.
Developed the TERD document for the security purposes that interact with our network.
Responsible for controlling the inventory related process.
Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.
Create Technical specifications documents based on the functional design document for the ETL coding to build the data mart.
Perform Data Profiling and Data Quality; Created data trace map and data quality mapping documents.
Use ERwin for data modeling.
Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center.
Work on daily basis with lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic.
Create visually impactful dashboards in Excel and Power-BI for data reporting by using pivot tables, VLOOKUP, Index-Matching and power-BI tool.
Work on exporting reports in multiple formats including MS Word, Excel, CSV and PDF.
Transamerica - Cedar Rapids, IA Jan 2018 to Oct 2018 Business System Analyst
Working as a business system analyst with Insurance team as a member of Actuarial (Modernization) team. Currently the project involved making enhancements to user facing applications done by assessing system capabilities and interdependencies to define business solutions.
Created Business Requirements Document, Functional Requirements Document for the project.
Gather project requirements in collaboration with Business SME’s and stakeholders.
Developed UML Use Case diagrams for faster and more efficient communication with stakeholders, by utilizing MS Visio.
Conducting JAD sessions with the team.
Designed application components in an AGILE (Kanban) environment utilizing a test driven development (TDD) approach.
Created and maintained project tasks and schedules.
Performed data profiling in the source systems that are required for New Customer Engagement (NCE) Data mart.
Manipulated, cleansed & processed data using Excel, Access and SQL.
Responsible for loading, extracting and validation of client data.
Analyzed raw data and developed recommendations.
Wrote SQL scripts to manipulate data for data loads and extracts.
Involved in defining the source to target data mappings, business rules, business, and data definitions. Responsible for defining the key identifiers for each mapping/interface.
Responsible for defining the functional requirement documents (FRD) for each source to target interface.
Coordinated with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
Documented data quality and traceability documents for each source interface.
Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions.
Involved in Data warehouse and Data mart design. Experience with various ETL, data warehousing tools and concepts.
Worked with internal architects, data warehouse developers by assisting in the development of current and target state data architectures.
Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
Also worked on some impact of low quality and/or missing data on the performance of data warehouse client. Identified design flaws in the data warehouse.
Create ad hoc reports with SQL, perform daily and weekly report generation and maintenance procedures.
Develop the ad hoc reports for business people.
Worked on JIRA for continuous update with project schedules, quality, issues and managing resources.
Used JIRA for reporting and defect tracking, also followed up with the development team to verify defect fixes and updated defect status also documented all the bugs.
Conducting daily stand-ups.
Assisted and directly involved with QA team in creation of Test Cases and tests implementations.
Creative and maintaining positive and productive team environments and with integrative thinking skills.
Environment: Oracle10 & 11g, MS-Office, Enterprise Architect, Informatica, ER Studio, XML, Informatica.
Capital One Financial Corporation – Dallas, TX Feb 2017 to Dec 2017
Business Analyst/Data Analyst
Capital One Financial Corporation is a bank holding company specializing in credit cards, auto loans, banking and savings accounts headquartered in McLean, Virginia. Capital One is ranked 10th on the list of largest banks in the United States by assets. The bank has 755 branches including 30 café style locations  and 2,000 ATMs. It is ranked 98th on the Fortune 500, 17th on Fortune's 100 Best Companies to Work For list, and conducts business in the United States, Canada, and the United Kingdom.
This project deals with enhancement of NICE Actimize solutions for the Anti-Money Laundering (AML) Transaction Monitoring System which enables end-to-end coverage for the detection, scoring, alerting, workflow processing, and reporting of suspicious activity. The project is focused on the preparation of CTR (Currency Transaction Report) and SAR (Suspicious Activity Report) as per the AML compliance laws using the NICE Actimize software.
Assist in the administration and review of Client Risk Scoring, Client Identification, Client Onboarding, identifying Key Risk Indicators(KRI) and KYC documentation oversight/management requirements.
Thorough understanding of various modules of AML including Watch List Filtering, Suspicious Activity Monitoring, CTR, CDD, and EDD.
Prepare Business & Functional requirement documents for securities reporting application using standard SDLC templates in MS Word.
Maintain SDLC standards by documenting Project Request Document, Project Planning Document, BRD, FRD, Scope Document, RISK Scorecard, and Planning Phase End Metrics.
Use AML tool Actimize to generate reports through collecting data from various databases to automate the whole process of CTR, transaction monitoring.
Create High Level Design Document, Test Plan & Test Case Document, UAT testing and Release Plan.
Conduct full analysis/Investigations on all types of accounts from Low to High Risk countries/clients for client data like Retail and Institutional Clients during the client onboarding.
Eliciting Trade Surviellance rules and constantly engaging/holding meetings with teams for upto date rule structure.
Assist in creating of Trade Surviellance and creating strategic frameworks compiling with pre-trade, post-trade rules.
Monitored transactions, detecting insider trading and market abuse, complying with complex regulations and provided Trade Surviellance solutions using NICE Actimize.
KYC Doc review during Client onboarding. Understand risk factors.
Monitoring and scenario analysis of payment sources/channels and wire transfers.
SAM Profiling models for transactions. Stand alone and Unusual behavior analysis.
Prepare the report publishing frequencies and the media in which it shall be published (SharePoint), also prepare the document for filing frequency and filing format of the SARs, CTRs to the regulatory agencies and internal systems which adhere to AML principles and procedures.
Study the existing KYC/CIP system and prepared the test data for the CDD/EDD based on the inputs.
Performed vlookup, hlookup, If Else statement, conditional formatting and VBA macros.
Fully assisted with SIT.
Train team members after creating workflow rules of specific situations and how to act on such cases.
Accenture – Chicago-IL May 2016 to Jan 2017 Business Analyst
Accenture is in the process of transforming their entire digital, technology, management experience, implementing new solutions to remove inefficiencies and allow the company to remain on the cutting edge of software and technology. As the BA at Chicago Office, I have been assigned duties to the Browse Services Team, Checkout/OMS team, and provide support to various initiatives that leverage third party companies.
Managed Agile framework artifacts such as: Product Backlog, Sprint Backlog, Created User Stories.
Facilitate scrum ceremonies (sprint planning, retrospectives, daily stand-ups, etc.).
Worked with Product Owner to identify the user stories and then elaborate stories.
Communicate with other management, developers, product managers and support specialists on product issues.
Gathered and Business and Functional Requirements (BRD, FRD), during JAD sessions.
Interacted with the stakeholders, developers, Project Manager and SME have to formulate Business Processes.
Worked with marketing team for revenue generation aspects and finding target audience.
Prioritizing requirements along with product owner in backlog which adds the most value, and is a stable and viable product.
Worked in Cross Functional team environment, served as a liaison between SME's, Project Manager, and stakeholders to ensure accuracy in the SFDC implementation and other business requirement.
Developed Customer portal to implement Web-to-lead functionality and enable lead capturing in real time and implemented and automation products with marketing automation techniques.
Created new report types, new reports and dashboards to monitor and issue regular key productivity indicator reports and chart.
Created Email Templates and letterheads and used them in workflow Email alerts.
Worked on Process flows, Wireframes and Mockups for the application.
Configured/Created Profiles, Roles, and Permission Sets, Sharing Settings, Custom settings for the organization and setting up Field-level, Object-level security rules for the application.
Performed Unit testing, Integration testing, Bulk testing, Staging and User Acceptance Test in Full Sand box.
Documented the entire process starting from Requirement document to end user training document.
Developed attitude and capability to handle multiple projects at the same time including Onsite/Offsite co-ordination and also with offshore teams.
Helped in conducting Gap Analysis (GAP), User Acceptance Testing (UAT), and System Integration testing.
Designed Escalation rules, Automatic case generation and their escalation to call center representative, and generated email alerts for quick issue resolution.
MDM managed information about products, with a focus on data required to market and sell products.
Provided in-depth analysis to resolve production and application issues.
Provided a concrete explanation of resolutions to issues, inquiries and requests.
Verified the Business Scenarios on new builds to allow extended testing by the QA team.
After deployment of the product giving end user proper training on how to consume the product.
Training other staff member on how the process would work by creating pipeline, and building process builder and process visualize.
Involved in creating dashboards, reports as needed using Tableau Desktop and Server.
Created users, groups, projects, data connection settings as Tableau Admin.
Managed multiple cross functional teams across the country.
Worked closely with users to understand KPI, gather and document reporting, analysis and data requirements.
Analyzed requirements for various reports, dashboards and created them using Tableau desktop server.
Used Performance recording on Desktop and on Tableau Server and Tuned the Performance of Dashboards.
Involved with Developer and QA team as pairing party during Sprints in Agile environment.
Used user stories to define and explain requirements to development team in the Agile environment.
Tracked and communicated project status to all levels of leadership and project teams.
Prioritized and managed multiple projects to ensure projects are on track and all gates are met.
Collaborated with development, architecture and stakeholders to deliver quality products.
Experience with SAP information steward and Data Services.
Adnig Technologies Pvt. Ltd – India May 2012 to Nov 2015 Business Analyst
The Adnig Data Team is responsible for the Toyota Data file delivery process. The Toyota process uses Informatica technology and is one of the cornerstone technology offerings of Adnig Advisor Services (AS). The projects involved creating various business programs, web application development, and various database projects.
Projects were implemented on the Waterfall framework.
Created waterfall framework artifacts such as: BRD, FRD, use case and use case diagrams and process flow diagrams.
Functioned as the primary liaison between the business client, operations, and technical areas throughout the project life cycle.
Capturing the requirements in RTM.
Maintaining the Requirement Traceability Matrix (RTM).
Coordinated in setting up the development, test, production and contingency environment.
Communicated and reported to managers from all levels and aspects of the business.
Worked with Team Leads in various departments to gather information on workflows to provide a comprehensive overview for current and future projects and processes.
Extracted data from SQL server into temporary tables to cleanup and standardize column entries for re-importing into new SQL data structures thereby improving performance and efficiency.
Worked with the QA team to test the website and reviewed their notes Analyzed XML Queries to Publish data to downstream users from MDM.
Wrote SQL queries to extract related data from transaction record database for OLAP purpose.
Designed the ETL processes using Informatica to load data from Oracle, Flat Files, XML Files to target Oracle Data Warehouse database.
Apply medical necessity guidelines, determine coverage, complete eligibility coverage, and apply all cost containment measures to assist in the claim adjudication process.
Working in the Enterprise Business Intelligence Services group, analyzing issues and new requests for the Enterprise Data Warehouse.
EDUCATION AND CERTIFICATIONS
Bachelor of Science (B.S.) Computer Science Engineering from Maharshi Dayanand University, India.