SUMMARY

• I am a Business System Analyst with 8+ years of diverse experience in SDLC, technology implementation in Finance & Banking, And Goal driven & object - oriented performer, with an ability to conceptualize solutions to problems and ability to build result oriented processes enabling organizations to achieve short term and long term business goals.
• Experienced in interacting with Stakeholders, User Clients and Developers, while meeting the needs and goals of each parts respectively.
• Well versed in basic and complex SQL queries to perform ETL process.
• Possess excellent knowledge of Rational Unified Process (RUP), Rational RequisitePro, Rational Rose, Rational Clear Case, Rational ClearQuest and Microsoft Project with detailed perspective of different phases and disciples like Requirements, Analysis/Design and Development.
• Created business rules, business vision document, business glossary and implementation up to functional and technical specifications.
• Well versed on SIX Sigma and LEAN SIX SIGMA Processes.
• Extensive experience in managing project requirements, which includes requirement gathering, requirement rating/analysis and requirement priority assignment.
• Experience working with users, technical teams, project managers, SMEs, as well as senior management.
• Managed project dashboards, change requests, issue escalations, resolutions and mitigations.
• Experienced in creating dashboard, Reports & Analytics using BI tools like IBM Cognos, Tableau and Japersoft & SAP Bi/BO.
• Good knowledge in SQL programming (DML, DDL, DCL, DRL) and database administrating like performance tuning; commissioning and installing new applications and setting up high availability (HA) options; disaster recovery management setup for managing risk.
• In depth knowledge of Software Development Life Cycle processes, including Waterfall, Agile, Scrum, Rational Unified Process (RUP), Spiral among various others.
• Experience in conducting Joint Application Development (JAD) and Joint Application Requirements (JAR) sessions with end users, SMEs, and stakeholders.
• Good knowledge of analyzing and conducting projects through inception to implementation with proficiency Data profiling, Data mapping, Data Governance and Data Warehousing. Also, worked on Data Migration techniques using Informatica Power Center and through traditional methodology and SQL.
• Experienced in developing BRD, SRD, and developing and maintaining artifacts in SharePoint.
• Experience in using SQL Queries and MS Excel (Hlookup, Vlookup, Macros, Pivot Tables, etc.) for Data Validation and Data Integration.
• Assisted development and reporting groups in optimizing SQL statements in varied situations for maximum performance, security, reliability and availability.
• Experience in creating Key Performance Indicators (KPI), Enterprise Risk Management, Business Continuity Planning (BCP), and Change Management.
• Experience in creating and using Requirements Traceability Matrix (RTM) through out the development process.
• Experienced in various testing systems, responsible for User Acceptance Testing (UAT), and various other test protocols such as Unit, Integration, Functional and Load testing.
• Skilled in Database Mapping, Source System Mapping, Source-to-Target Mapping.
• Experienced in Data Warehousing & Data Marts architecture (OLTP, OLAP, DOLAP, ROLAP, MOLAP, HOLAP) and experienced in ER Modeling (OLTP)
• Well versed in Start Schema & Snow Flake Schema, Dimensional Modeling, different relationships in Data Model such as Association, Generalization/Specialization and Aggregation & Composition.
• Simplified existing applications & integration architecture & built for scalability utilizing SOA as framework and Applied the "As Is" and "To Be" process designs in order to identify any potential process gaps and as well as improvement opportunities.
• Experience implementing MDM foundational programs, define metadata that provides traceability between MDM and the heritage of each data element.
• Conducted GAP analysis, SWOT analysis, Cost-benefit analysis and ROI analysis.
• Expertise in developing Test cases, Test plans and Test procedures in manual and automated test environments.
• Defects tracking prioritized outstanding defects in reporting system. Co-ordinated between development team and the management team to resolve any conflicts/defects in terms of requirements.
• Diverse experience in Banking and Financial Services
• Experience in Risk Analytics (Credit Risk, Market Risk, Operational Risk, etc.)
• Knowledge of regulatory and compliance requirements such as K-Y-C, AML, Dodd-Frank, BASEL I & BASEL II, and SOX.
• General Ledger Reconciliation, Chart of Accounts (CoA), Accounting & P&L
• Market Data and Market Pricing through Bloomberg gateway
• Extensive Knowledge of Financial Analysis, Forecasting, Valuation, Planning and Budgeting.

TECHNICAL SKILLS

SDLC Methodologies: Waterfall, Agile (Scrum), Rational Unified Process (RUP).

ETL Tools: Informatica 9.5/8/7 (All Suites), DataStage 9.1/8 (Enterprise Edition), IBM Data manager 10.2/9, Teradata Utilities: BTEQ, Fast Load, Fast Export, Multi-Load.

Languages: SQL, .Net, C#, C++, JAVA, UML, XML, HTML, PL/SQL, JSP, NODE.JS

RDBMS: Teradata 13.10/V12/V2R6/V2R5, Oracle 11g/10g/9i/8i, SQL Server 2012/2008/2005 , MS Access.

Reporting Tools: Business Objects 6.5/5, SQLServerReporting Services, Crystal Reports, Cognos Planning Analyst-Contributor-BI suite 10.1.1/9/8.

Business Tools: MS Word, MS Excel, MS Power Point, MS Visio, IBM Rational 6.1, JIRA, Rational Requisite Pro, MS Project, MS Share Point 2007/2010/2013.

Business Intelligence: IBM Cognos 8.4, Cognos (Analysis Studio, Quert Studio), Tableau, OBIEE 11g.

DB Tools: SQL*Plus, QTP 8.2, Test Director, JSC, Toad 8.5, SQL Navigator, Control M, Autosys, Teradata Viewpoint.

Data Modeling: Logical/Physical/Dimensional, Star/Snowflake, Erwin 4.1/3.5,MS Visio.

Data Warehousing: Data Marts, OLTP, OLAP, ROLAP, DOLAP, MOLAP, HOLAP, Query/Reporting, Multidimensional Analysis, Data Mining, Drill Down/Roll Up, MDM

Financial and Financial modeling: Equities, Fixed Income, securities, foreign exchange, bonds and derivatives, insurance, mutual funds and check processing, trading & risk environment, credit, interest rates, equity, foreign exchange, treasuries and Mortgage concept.

PROFESSIONAL EXPERIENCE

Confidential, Durham NC

Lead System Analyst / Scrum Master

Responsibilities:

• Participated actively in the enhancement of OLTX for front office applications.
• Acted as a domain modeler to model the web services.
• Developed good knowledge of portfolio management, various types of accounts, Options, Margins, Balances, Positions, Statements, Accounts & Customer features, Credit Cards, Online Trading, and Asset Management.
• Designed and implemented web services to support the front-end capability to provide a better user experience for customer to manage their investment portfolio.
• Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Facilitated JAD Sessions with users, developers, and database design team to deal with backend synchronization issues.
• Created Use-Case Models to depict Actors and Users in various Business Processes.
• Responsible for numerous decisions in respect to business policies, procedures, methods for implementation.
• Defined the business requirement and document to ensure a better implementation process.
• Worked with developers hand in hand to make sure the business requirements are met and satisfied.
• Created various types of reports/sub-reports and drilldown like standard and cross tab reports with bar chart, pie chart and line-chart graph representation reports using UML diagrams. Provided walkthroughs of the domain model.
• Performed Data Analysis, Data Mining, and Data Mapping to ensure a robust web service.
• Used SQL queries to perform analysis of the consumed data from respective backend and designed the conceptual, logical and physical data model.
• Exposed to Data Warehousing and Data Marts architecture
• Worked on SOA environment to connect the system to arbitrary number of services.
• Reverse engineered the existing front end application to enhance the technology from JSP to JS using Node.
• Ran performance test using Jmeter to analyze the root cause of performance issue
• Focused mainly as a team player to ensure the team is fully aware of the project and ensure transparency.
• Involved in multiple level of testing the application to ensure a robust platform for customers.
• Made important decisions to solve adhoc problems and meet the expected release date.
• Acted as a Scrum Master/Project facilitator to remove any impediments.
• Acted as a Team Lead for a team of 5 to 7 and made sure the requirements are delivered on time.
• Created data flow diagram in conjunction with the development, infrastructure, and network teams containing instructions for maintaining the Application.

Environment: MS Project, JAVA, SharePoint 2013, Web Services (WS02), Agile (SCRUM & SOS), XML, JSON, Jmeter, Splunk, JS, UML, Eclipse, Intel JDK, BPR, SOAP UI, JIRA, SQL, AEM

Confidential, Oaks PA

Business Systems Analyst

Responsibilities:

• Studying business functions and system capabilities to determine operational objective, provide design support for the development of business intelligence solutions. Redesigned the core of the Options pricing/trading system.
• Participated actively in the enhancement of Calypso for front office applications.
• Worked on Sales Incentive Program to improve costumer experience and relationship
• Designed and defined the conceptual, logical, and physical model for review with Product Owners and SMEs’.
• Performance GAP Analysis to identify the AS-IS state of the data structure and propose TO-BE design to optimize database performance.
• Designed and implemented Portfolio Risk Management Analysis System to automate hedging of various investment portfolios.
• Participated as a team member and Scrum Master in various Agile projects.
• Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements.
• Identified the requirements of the stakeholders and created Business Requirement Document (BRD) and Functional Requirement Document (FRD).
• Facilitated JAD Sessions with users, developers, and database design team to deal with backend synchronization issues.
• Created Use-Case Models to depict Actors and Use-Cases in various Business Processes.
• Performed SQL reverse engineering to find out the E-R diagrams for documentation purposes. Responsible for numerous decisions in respect to business policies, procedures, methods for implementation.
• Developed EXCEL models for Portfolio Risk and Return Analysis, as a basis for complex trading packages designed by programmers.
• Created various types of reports/sub-reports and drilldown like standard and cross tab reports with bar chart, pie chart and line-chart graph representation reports using Crystal Reports. Provided walkthroughs of the Reporting feature.
• Performed Data Analysis, Data Mapping & ETL to generate Crystal Reports.
• Also acted as a data steward for master data management (MDM) to maintain single source of truth and for data accuracy and conformity.
• Involved in identifyingthe ADHOC scenarios.
• Extracted financial data from Bloomberg to a spreadsheet for analytics purpose.
• Created deployment flowchart in conjunction with the development, infrastructure, and network teams containing instructions for maintaining the Application.

Environment: MS Project, Visual Studio, C#, BPMN, EA, Crystal Reports, SharePoint 2013, Web Services, Calypso, MS SQL Server, Agile, TFS, HTML, XML, SQL, ETL, BPR, IBM Cognos, AEM.

Confidential, Hopewell, NJ

Business Systems Analyst

Responsibilities:

• Worked with the business users to define business requirements and develop user specification documents.
• Conducted user interviews, gathered and analyzed the requirements Requisite Pro.
• Designed and developed Use Cases, Activity Diagrams and Sequence Diagrams using UML tools.
• Identified, investigated, analyzed, defined and documented business processes.
• Worked on Sales Incentive Program to improve customer relationship and experience.
• Implemented Electronic Payment Solutions to enable online payment transactions
• Conducted workflow, process flow and GAP Analysis to derive requirements for existing systems enhancements
• Created technical documentation like Detailed Design Specification and Software requirements Specification.
• Collaborated with the QA team to ensure adequate testing of software both before and after completion, maintained quality procedures, and ensured that appropriate documentation is in place.
• Met with business stakeholders to gain consensus on new product functionality.
• Defined reference data to query data based on unique identity key.
• Redefined the business process management when new product is added for reference data management.
• Prioritized new features and functionality based on business needs.
• Identified and documented best practices for the product offering.
• Involved in performing stress test for CCAR to ensure sufficient capital to continue operations.
• Designed the Test Plan, Test Cases, and Test Scripts for all processes and Web Services and delivered the XML Schema.
• Orchestrated the SOA principle with architects and implemented the synchronized logical process.
• Defined the business activity, XML messages & dimensions that I want to monitor.
• Went through SLA (Service Level Agreement) and created Stub Data.
• Extensive experience in ETL process consisting of data transformation, sourcing, mapping, conversion and loading of source system to target system.
• Performed Data Analysis & Data Mapping to generate Crystal Reports
• Running reports and perform Data Analysis and come up with business decisions (Risk Analysis).
• Worked on Data Modeling (Conceptual & Logical), suggested name changes for entity & attributes.
• Identified Entities, properties of Entities, types of Attributes and Keys.
• Suggested Surrogate Key and Star Schema.
• Worked on Data Warehousing & Data Mart architectures.
• Hand it over to DA to complete the logical data model (Identify SK, CK, PK, AK) apply normalization (to eliminate anomalies) then test the Data Model.
• Test the system whether the mentioned features are bug free along with QA.

Environment: MS Visio, MS Projects, Share Point 2010, SOA, AJAX/Java Script, Oracle 9i, HTML, XML, Rational Rose, PHP, ETL, SQL, CARR

Confidential

Data Analyst

Responsibilities:

• Involved in designing of the system with the system architecture and the development team, supporting the technical team in the product development and delivery process and translated the business requirements into Functional Specification Document (FSD).
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs, and ensured that none of the critical requirements go unnoticed.
• Monitored client expectations and skillfully negotiated with clients through client involvement and all types of communication with the client’s team throughout the lifecycle of the project.
• Interacted with the Subject Matter Experts (SMEs) and stakeholders to get a better understanding of client’s business processes.
• Followed UML based methodology using Rational Rose for creating Business Cases and Use Case Models after assessing the status and scope of the project and implementing technology based solutions that will meet their strategic business processes needs.
• Provided continuous support to the development team in order to make sure that business requirements are being converted into a desired software product
• Identified Use Cases from the requirements and wrote Use Case Specifications document.
• Linked business processes to organizational objectives, identifying opportunities for business process improvement and involved in the performance of cost/benefit analysis.
• Reported status to project management and project owners on a weekly and monthly basis.
• Used MS Project 2000 for status reporting and project planning.
• Involved in the periodically held JAD sessions for the purpose of project updates as well as involved in the weekly meetings to discuss the current project status.
• Actively involved in developing, executing and coordinating functional and user acceptance testing (UAT).

Environment: ASP.Net, VB.Net, SQL, PL SQL, MS SQL Server, JSP, XML, MS Visual Basic, MS Office Suite, MS Visio, Win Runner, Test Director, Oracle 8i/9i/10g, Windows XP/NT, MS Project.

Confidential

Business Analyst

Responsibilities:

• Responsible for creating and reviewing business requirements, functional specifications, project schedules, documentation and test plans related to commercial lending
• Worked extensively with SMEs in understanding and documenting their requirements. Worked with all levels of client staff in the process of solution definition
• Assisted with product evaluation, product customization and system integration. Conducted GAP analysis around the identification of business rules, business and system process flows, user administration, requirements and assumptions
• Designed and developed Use Cases, Use Case Diagrams and Activity Diagrams using UML
• Supported testing, Test Cases in HP Quality center that would test various Test scenarios
• Authored business requirements documents with the business users. Extracted, discussed, and refined business requirements from business users and team members.
• Involved in documentation during various phases of development life cycle.
• Coordinated activities between business unit and technical staff, developed new methods, policies, and procedures to meet the business needs, as well as acted as primary trainer in educating the business units, related to business applications.
• Performed UAT on business requirements, technical specifications and product knowledge.