PROFESSIONAL SUMMARY:

• 8+ years of experience in the field of business and data analysis supporting software solutions and analyzing business operations.
• Broad experience working on various domains such as Investment Banking, Commercial Banking and Anti Money Laundering.
• Worked in various software development environments including waterfall and agile methodologies like Scrum, Kanban, Extreme Programming.
• Certified Scrum Master.
• Strong experience in Regulatory Risk Reporting.
• Strong communication, requirement elicitation and documentation skills while maintaining professional relationships with stakeholders, Project Managers, SME’s and other staff members.
• Worked in the capacity of a Scrum Master by facilitating all scrum ceremonies, resolving Impediments and dependency issues. Proficient in data analytics - SQL querying, Ad Hoc / Canned report generation using tools like TABLEAU.
• Experience in developing relationship with Stakeholders and Gathering Requirements from them by utilizing requirement elicitation technique such as, one on one interviews, Observation, JRP, JAD, Group Discussions and Analyzing Reports
• Strong experience in all the phases of SDLC Life Cycle such as Analysis, Design, Development, Quality Assurance.
• Experience in facilitating UAT sessions and made sure to have sign off after UAT session.
• Exceptional ability and experience in Analyzing Requirements and preparing documents such as Functional Requirement Document, Business Requirement Document and System Requirement Specification.
• Extensive experience and knowledge in OOAD
• Hands on expertise in developing user stories, use cases and creating UML diagrams such as Activity Flow diagram, Sequence diagram, Use Case Diagram
• Worked closely with Architects in building Schema structures for Data Warehousing projects.
• Strong experience in understanding the gaps between AS-IS and TO-BE and converting them into Functional and Business Requirements.
• Experience in performing Business Process Analysis, involved in application redesigning and enhancements and GAP analysis, creating Business Process Models.
• Well versed in project management tools like MS-Project, JIRA, RALLY.
• Expertise in creating wireframes and mockups using VISIO.
• Experience in creating dynamic prototypes using HTML to show the dynamic functionality of application.
• Experience in using Team Foundation Server for version controlling, requirements management and project management.
• Hands on expertise with collaborative tool like SharePoint
• Well versed knowledge of SOA architecture
• Experience in facilitating scrum ceremonies such as Daily scrum meetings, Sprint planning, Sprint review, and Sprint retrospective
• Highly experienced in facilitating Scrum of Scrums to resolve dependency issues.
• Experience in maintaining Scrum Artifacts like Product Backlog, Sprint Backlog, Burn down chart and Burnup chart
• Implemented SQL scripts, stored procedures, triggers and indexes for various database operations.
• Deep technical background and solid working knowledge of Oracle Data warehouse systems.
• Strong knowledge and experience in Ralph Kimball approaches.
• Strong knowledge and experience in all loading types (SCD1, SCD2 and SCD3).
• Extensively worked on all phases of Data Warehousing project like Data Cleansing, Data modeling for data staging & Data Mart, ETL, Indexing, Quality Assurance, Data updating plan, and Data presentation to business users.
• Created Data Mapping Documents and worked with business to write transformation rules.
• Strong experience and knowledge in writing SQL queries during testing phase of the project
• Strong knowledge of SQL and extraction/ transformation/ loading (ETL) process.
• Experienced in doing Data mapping within upstream and downstream applications for financial products.
• Well versed in project management tools like MS-Project for status reporting and planning.
• Expert in conducting business reviews, walkthrough sessions and facilitated monthly and weekly meetings/reviews.

TECHNICAL SKILL STACK:

Modeling Tools: Rational RequisitePro, HPALM, UML, MS Visio, BPMN, Rational Rose, Rational Clear Case

Methodologies / Frameworks: Agile, Waterfall

Database: MS SQL Server, Oracle, MYSQL.

BI Reporting Tools: OBIEE, Power BI, Microstrategy,Tableau, EXCEL, Qlik View

ETL Tools: IBM Data stage, Informatica Power Center, SSIS

QA Testing Tools: HP QC, Load Runner, MS Test Manager 2013, Selenium

Documentation Tools: MS Office Suite, MS SharePoint 10

Data Warehousing: Data Marts, OLTP, OLAP, ROLAP, MOLAP, Oracle, Query/Reporting, Multidimensional Analysis

Project Management Tools: MS Project professional, MS Project Server, JIRA, RALLY

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Business Data Analyst

Hoover, AL

Responsibilities:

• Extensively worked with business users and other stakeholders for requirement elicitation.
• Facilitated Requirement Elicitation session with Business Manager and other SME’s for gathering requirements
• Created Business Requirement Document based on the requirements that are gathered.
• Performed Data Profiling on Data Warehouse using SQL based on the requirements to make sure that requirements are feasible in doing.
• Extensively worked on identifying the data sources and data that should be used for transformation purpose.
• Created source to target data mapping document by incorporating appropriate transformation logic.
• Performed Data Cleaning by eliminating junk data from Data Sources using appropriate pseudo code.
• Facilitated Walkthrough sessions for testers and developers for describing the requirements and mapping document.
• Worked with data modelers and, assisting in the development of current and target state enterprise data architectures.
• Documented the change request which was proposed by stakeholders and performed analysis to make sure whether it is within the scope of the project.

Environment: Oracle 11g, MS Excel, MS Word, MS Outlook 2007, JIRA, Toad, Erwin, IBM Data Stage

Confidential

Senior Business Intelligence Analyst

Hopewell, NJ

Responsibilities:

• Extensively worked with business users and other stakeholders for requirement elicitation.
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures.
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.
• Facilitated requirement review sessions and JAD session with SME’s and business users to make sure requirements are feasible.
• Created Data Flow Diagrams to represent how data is flowing from each application to DataWarehouse
• Extensively worked on identifying and retrieving the data from multiple sources using SQL for decision making.
• Developed Data Models and done Data Mapping across downstream applications by working closely with Architects.
• Involved in defining the source to target data mappings, business rules and data definitions.
• Created BUS Matrix for identifying conformed dimensions.
• Was involved in decision making for implementing Star Schema or Snow Flake Schema into our Data Warehouse.
• Facilitated project meetings with Architects, tech leads and Project Managers for deciding the granularity levels for Fact table.
• Responsible for defining the functional requirement documents for each source to target interface.
• Developed processes using ETL tools using Informatica Power Center 9.6.1, SQL to support business reporting requirements.
• Created a technical Specification document to show how the project gathered data to create a new system environment in Oracle 11g
• Conducted data reverse mapping utilizing the TOAD for Oracle 11g system .
• Designed and built the Investor month-to-date Dashboard on the BI system (TABLEAU) to provide the status of investor performance in real time.
• Developed several reports in TABLEAU for the users and management for effective decision making.
• Conducted and participated in the analysis of business processes and functional requirements and in the preparation of developing a data reporting tool using TABLEAU .
• Worked as a Liaison between stakeholders and BI developers to develop Business Intelligence solutions.
• Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Documented data quality and traceability documents for each source interface.
• Resolved data discrepancy issues by facilitating meeting with developer and architects.

Environment: Oracle 10g, MS Access 2007, MS Excel 2007, MS Word 2007, MS Outlook 2007, JIRA, Toad, Erwin, Data Stage, EXCEL, EXCEL, Informatica Power Center, PowerPoint 2007, SharePoint, Safe Agile

Confidential

Senior Business Analyst

Oaks, PA

Responsibilities:

• Gathered Business requirements by conducting JRP session, One on One interview and Group sessions with Stakeholders and business Users
• Coordinated with Managers to determine appropriate risk assessment levels.
• Analyzed the existing SAM model and Regulatory reports using Observation techniques with stakeholders
• Involved in developing suppression logic for false-positive Actimize alerts which reduces the regulatory reports.
• Collaborated with the SME and interviewed the stakeholders to understand the AS IS and TO BE state of the project
• Conducted several JAD sessions and requirement workshops with the system architects, business users and development team to perform GAP Analysis
• Gathered functional and non-functional requirements in collaboration with end clients and internal project managers and created BRD and SRS
• Created detailed business scenarios and writing master use cases with the help of Rational Requisite Pro which covered step by step process of interaction between user and system
• Developed Activity diagrams, Use Case diagrams and Sequence diagrams using MS Visio environment, so development team and other stakeholders can understand business process
• Created wire frames using MS Visio Tool.
• Undertake review of existing clients within the database to ensure that their documentation was kept up-to-date and that they meet the KYC and CDD check standards, in accordance with compliance.
• Obtained a wide selection of client documentation from internal and external data sources to extract key information and validate client's identity and reputation in order that they meet KYC checks
• Conducted research, assisted and provided information to support suspicious activity reports SAR and made recommendations. Worked on various aspects of AML, Fraud prevention, KYC, Brokerage and Trading Compliance.
• Determined whether the activity seemed legitimate or not by applying various AML regulatories including the USA PATRIOT ACT, the Bank Secrecy Act and OFAC.
• Analyzed the existing customer data and understood the necessary information that needs to be captured for each existing customer and prepared missing values, anomalies for the completion of the CDD .
• Analyzed and developed a temporary tactical KYC/pre-CDD on-boarding solution to capture new regulations introduced by Patriot Act.
• Suggested several process improvements within the ratings process and suggested solution options to automate manual data entry tasks performed by Data Managers.

Environment: Erwin, Agile/Scrum, Rally, Nice Actimize AML,TFS, Selenium, Oracle, Java, MS Project, MS VISIO, SharePoint, Rational Requisite Pro, XML Spy HPQC, DB2

Confidential

Senior Business Data Analyst

Santa Clara, CA

Responsibilities:

• Primary point of contact working with stakeholders to understand their systems, AS-IS process and business needs. Worked as a trusted advisor to identify opportunities for new insights, analytics and reporting solutions.
• Prepared Business Requirement Documents (BRD), Mapping Document based on the gathered requirements.
• Conducted Data analysis to answer specific business questions asked by clients and/or support teams; use data to establish facts and draw valid conclusions
• Manipulate data to make it usable for analysis by summarizing data points, creating new metrics, and addressing data quality issues
• Maintained data integrity during extraction, transformation and loading of data into data warehouse
• Engage in requirements and gap workshops with clients for identifying the data sources and data needed for analysis
• Designed and implemented data integration modules for ETL functions.
• Analyzed the bottlenecks between the feed arrival time of the upstream applications and the formal SLAs and analyzed its impact on the downstream applications.
• Analyzed and Designed the Data Mart model using Star Schema model with Facts and Dimension Tables
• Used TOAD for writing SQL queries to perform data analysis.
• Developed several reports in Crystal reports and Excel for end users.
• Developed Test Cases, Facilitated UAT, compiled results, reviewed and discussed with Business Owners to provide signoff for the Clarity Reports.
• Developed user guides for stakeholder training purpose.
• Helped stakeholders to interpret and understand data in Business Intelligence reports
• Documented Requirement Traceability Matrix (RTM) in Requisite Pro through test cases.
• Conducted ETL testing process for data quality, data validations, data duplication and data count.

Environment: Erwin, Waterfall, Informatica Power Center, Crystal Reports, Oracle 10g, PL/SQL, Visio2003, Visual Basic, MS Office Suite, QTP, UNIX.

Confidential

Junior Business Intelligence Analyst

Responsibilities:

• Extensively worked with Project Manager to determine the best practices for requirement gathering.
• Gathered, documented and managed business requirements.
• Created documents such as Business Requirement Document, Mapping Document
• Identified several data sources to extract
• Responsible for creating source to target data mapping
• Contributed in performing ETL testing such as Data Count testing and Data Validation Testing.
• Worked closely with ETL Architects to build schema structures for Data Warehouse
• Conducted user interviews, one to one sessions with the managers and critical users, and organized JAD Session at both in-house and client locations
• Worked with UI analysis team to create prototypes to be presented to the Business team.
• Assisted in building business analysis process model using MS Visio.
• Developed timelines for project delivery and managed projects and resources for successful completion.

Environment: RUP, Requisite Pro, MS Project, UML, Windows, Informatica Power center, MicroStrategy, ErWin

Confidential

Junior Business Analyst

Responsibilities:

• Researched and assessed client systems and business processes.
• Explored all aspects of the claim processing lifecycle, starting from identifying a claim to its closure.
• Used MS Word document for requirement gathering.
• Worked intensively on various phases in the project lifecycle to design the system in such a way that the high risk claims could be easily identified and monitored.
• Participated in preparing basis for Project Vision documentation.
• Involved in walkthroughs with business team, architects and developers to refine the requirements.
• Generated use-case diagrams using UML.
• Implemented Traceability Matrix and User Requirement Specification Document (URS) to verify the functionality.
• Streamlined clerical work processes and mapped to the automated system
• Involved with the Software Quality Assurance (SQA) Team to develop Test plans.

Environment: MS Visio, UML, Oracle, SQL, MS Office and Windows 2000.

Confidential

Junior Business Analyst

Responsibilities:

• Worked as business analyst to support the re-design of the Mortgage Asset Management System. Extensively involved in the development of Reporting Data Warehousing System.
• Analyzed business needs, created and developed new centralized back office system for specific area including mortgage and lending.
• Wrote technical papers, gathered technical requirements, and compiled them to help the design the system.
• Formulated logical statements of business requirements research and evaluated alternative solutions to recommend the most efficient and cost effective solution for system design.
• Established a business analysis methodology around the RUP (Rational Unified Process).
• Analyzed existing systems logic difficulties and revised them as the needed.
• Assisted in building a business analysis process model using Rational Rose and Visio.
• Designed and developed use cases, activity diagrams, sequence diagrams, and OOD using UML.
• Gathered and documented business requirements

Environment: MS Visio, UML, SQL Server, SQL, MS Office and Windows 2000