SUMMARY:

• Professional Business Analyst wif 8+ years hands on experience in Data Analysis /Business Analysis, Business Intelligence and Visualization.
• Regulatory, Commercial Lending, Capital Market, Treasury services, global payments, Retail Banking, Equities, Credit Risk, Corporate Banking and Investment Banking, Asset Management, Portfolio management industries. Very proficient wif capital market noledge, experience in valuation of equities, management of IPO's, etc. and have complete noledge on all phases of teh Software Development Life Cycle (SDLC)
• Strong noledge in overall Commercial Lending, Mortgage loan process flow,
• Experience in interacting wif Front - Office users and analyzing business processes and documenting current business challenges to accurately define business requirements and translate into functional specifications for proposed solutions.
• Spearheaded teh business process and technology implementation of teh first-ever centralized global payment data analytics and reporting process
• Manage key department business intelligence applications and data warehouse acting as teh technical liaison for data warehouse / business intelligence issue
• nowledge of various financial mathematics and Banking Industry Protocols like FIX. Skillful in creating design documents like process flow diagrams using MS Visio. Experience in creating UML based Modeling views like Activity diagrams/ Sequence diagram/ Use Case/Data Flow/ business Flow/ diagrams using MS Visio, MS Word, MS PowerPoint, MS Excel and MS Project
• Highly experienced in using Blue Print as a tool for documenting business requirements, creating diagrams, making versions of FRD, etc.
• Excellent noledge and understanding of industry standard methodologies like Iterative Software Development Life Cycle Process as per Rational Unified Process (RUP), CMM (Capability Maturity Models), Six Sigma and Rational Tools used during various phases of RUP such as Inception, Elaboration, Construction and Transition
• Worked using various methodologies such as Agile Software Development, Rapid Application Development (RAD), Joint Application Design (JAD) and Prototyping
• Knowledge of Business Intelligence, Data Warehousing, Data Modeling and Analytics concepts wif expertise in grasping transaction flows and process management
• Proficient in interacting wif users and creating process-flows for business process re-engineering.
• Strong noledge on Interest Rate Derivative Products, Options, Portfolio Management, Investments, Fixed Income Products, Asset Management, Capital Market, corporate Bonds, Zero Coupon bonds, investment banking, Capital Market (management of IPO's, FPO's, commercial credit facilities), capital markets, mortgage, loans, Disputes, Collections etc.
• Experienced in performing GAP analysis, SWOT analysis, Cost benefit analysis, Risk analysis.
• Worked on Requirement Traceability Matrix (RTM) to trace and verify if all requirements are met.
• Comprehensive noledge on Waterfall, RUP and Agile methodologies.
• Excellent analytical skills in understanding teh business process (AS-IS and TO-BE), understanding teh functional requirements and translating them to system requirement specifications.
• Experienced in conducting Joint Application Development (JAD) and Rapid Application Development (RAD) sessions. Conducted Requirement Gathering Sessions and interviewed Subject Matter Experts, gathered detailed functionality aspects of business process and updated teh information to teh requirements in an easily comprehensible format
• Extensive experience in creating business process flow diagrams, UML (Unified Modeling Language) tools to create Activity, Sequence, Use Case, Class, and Collaboration diagrams
• Developed Test Strategies, Test Plans, Test Cases, Test Scripts, test development test execution and Test Scenarios in Quality Test Professional (QTP). Extensive experience in HP Quality Center, Jira and Microsoft test center.
• In depth noledge in Agile, Scrum, Waterfall, Rational Unified Process (RUP) methodology, GxP, Use Cases, Software Development Life Cycle (SDLC) processes
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Experience in facilitating Joint Requirement Planning (JRP) sessions wif Business User Groups, conducting Joint Application Development (JAD) sessions wif IT Groups and Conflict Management wif Project team members.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Experience in Credit Analysis, Credit rating calculations and redesigning teh application
• Business Blueprint (RICEFW), Realization, Go-Live, Production Support, End-User Documentation and Training.
• TEMPHas experience in OCM (organizational change management), Go-live support, including cut-over activities
• Strong Communication and Presentation Skills substantiated in past assignments wif developers, project managers, subject-matter experts, stakeholders, system implementers, and application end-users.

TECHNICAL SKILLS:

Business Modeling Tools: Blue-print, Rational Rose Enterprise Suite, Rational Requisite Pro, MS Visio, Clear Case, Clear Quest, SharePoint 2007

Statistical Tool: Excel, Access, Bloomberg, Oracle, Oracle Fusion Middleware, MS SQL server, MS Access, Windows, SharePoint

Project Methodology: RUP, SDLC, Agile, Scrum, Waterfall, Rational Requisite Pro, SQL, Tableau, ETL Tools (Alteryx),Mysql.

Applications/Tools: Rational Rose, MS Office, MS Project, EMR, EHR, MS Visio, Remedy, Quality Center, Snow, DOORS, SQL Server Reporting Services (2000/2005/2008 R2,2012,2014), MS Access, MS Excel

Defect Tracking Tool: Jira, Quality center

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

Programming languages: C, C++, HTML, DHTML, Visual Basics(VBA)

Operating Systems: MS-Windows, UNIX, MAS OS, LINUX, MS-Dos

Applications/Tools: MS Office, MS Project, MS Visio, JIRA, LSMW, Remedy Quality Center, Snow, DOORS

PROFESSIONAL EXPERIENCE:

Confidential New York

Business/Data Analyst

Responsibilities:

• Configures, implements, and maintains information systems/applications.
• Partners wif business leaders on research, design, build, configuration and operation of niche platforms (e.g. Financial Systems, Wealth management, Risk Systems, Treasury services, Sales Tracking Systems).
• Received commendation for building internal Web site dat consolidated various marketing programs and incentives available to qualifying customers, used in generating sales.
• Created content and designed overall look of internal and external sales and marketing brochures, data sheets, flyers and Web pages while maintaining strict branding guidelines
• Working wif Process Performance Lead to align process improvement opportunities wif associated key performance indicators (KPI) cascade model
• Well defined background in regulatory compliance wif banks and other financial industry services
• Exceptional noledge of regulations polices guidelines procedures regulations and laws governing teh banking industry such as Portfolio Management, Investments, Fixed Income Products, Asset Management, Captial Market.
• Payments operations Non- technical SME wif excellent noledge on payments applications
• Analyzed and prioritized user and business requirements as system requirements dat must be included while developing teh software. Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using teh UML methodologies.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
• Created Business Requirements Gathering sessions in teh form of questionnaires and business scenarios wif teh end users, subject matter experts (SME) and teh developers. Gathered user and business requirements through interviews, surveys and prototyping.
• Demonstrated skills in critically conducting teh GAP Analysis throughout teh projects in evaluating/ analyzing teh existing standards and policies to determine teh improvements
• Authored functional requirements based on teh needs of users. Authored a governance plan detailing teh rules and policies for teh SharePoint Project.
• Deep experience wif teh design and development of Tableau visualization solutions
• Provided 24/7 production support for Tableau users
• Generated tableau dashboards for sales wif forecast and reference lines.
• Generated tableau dashboards wif combination charts for clear understanding
• Designed, tested and implemented ETL processes using Informatica and COBOL II in migrating data from an IBM DB2 database for loading into a NCR Teradata Financial Data Warehouse
• Proposed SharePoint-based solutions to improve existing business challenges
• Assisted wif translation of auto insurance, Commercial Insurance documents to improve teh Commercial Insurance, insurance transition.
• Responsible for delivering professional and technical advice on home insurance section.
• Develop Commercial Insurance, insurance quotes for auto, house, workers compensation, make sales presentations, and close sales
• Created documents of teh use cases and created teh use case, activity, logical, component and deployment diagrams using MS Visio and Rational Rose, Data warehouse to communicate clearly wif teh development teams.
• Redesigned web services methodology for teh application while implementing reusability from different servers. Liaised wif teh technology team to derive Functional Requirements.
• To better define teh rationale for teh new process compiled Vision and Scope documents. Prepared reports for process improvements and trend analysis
• Serve as a liaison between software development and other internal teams, including product management, quality assurance and client services to ensure successful implementation.
• Responsible for Risk Analysis to detect teh risks associated wif teh development of teh new system. Additionally, formulated a Mitigation Plan to remove or reduce risks of high severity and one dat would have major financial impacts.
• Played a pivotal role in conducting Functional testing, Regression testing, Integration testing, Smoke testing and UAT (User Acceptance Testing)
• Managed databases providing extensive reports as required by regulatory bodies
• Conducted regular committee meetings to discuss compliance issues
• Responsible for supervising work activities (Development, Testing) to ensure dat they are well-performed, coordinated among team members and consistent wif teh approved work plan.
• Coordinated teh design phase wif teh architects in improving teh efficiency of teh project.
• Worked wif QA team in identifying test cases/test data and lead teh business team for UAT.
• Documented all custom and system modification. Assigned problems to appropriate software development team for fixes. Tracked problems from start to correction and test.
• Interacted wif technical team in allowing them to make a better navigational plan for teh project flow which would further make a better user interactivity tool for teh application.
• Signed off progress and completion reports which were then submitted to project management on a weekly basis.

Environment: HP Quality Center, MS Visio, SWIFT, ACH, SharePoint, HIPAA validator, Instream, BizTalk, MS office, Serena Business Mashups (Defect Management Tool), SQL, VB script.

Confidential

Business/Data Analyst

Responsibilities:

• Involved in defining teh source to target data mappings, business rules and data definitions.
• Data Analytics: Created interactive dashboards using large complex data sets to provide meaningful insights to senior management in Operational Risk Management.
• Provided analysis for teh Fraud Risk and Fraud Operational Indicators. Teh analysis provided would solidify what data is actually correct and why. Any anomalies in teh data are submitted to teh correct team for remediation.
• Wrote FRD and other supplemental documents for a data automation and integration project.
• Work wif business representatives from around teh globe to ensure teh appropriate data needed to calculate performance is available, timely, and accurate.
• Participated in creating user training manual.
• Developed advanced SQL queries to extract large quantities of data from disparate data sources based on business requirements.
• Presented/Trained business users around teh globe on new enhancements of Citi's Fraud Risk Application.
• Documented, clarified, and communicated teh requests for change requests wif teh requestor and coordinate wif teh development and testing team.
• Wrote SQL using Oracle SQL Developer to retrieving data and performing data analysis and stored procedure to automate complicated testing procedures.
• Prepare and Validate data sets using excel and Tableau functionalities to ensure optimization and data integrity.
• Worked wif teh users to do teh User Acceptance Testing (UAT).
• Gathered requirements, analyzed and wrote teh design documents.
• Worked closely wif QA team and developers to clarify/understand functionality, resolve issues and provided feedback to nail down teh bugs.
• Reviewed, analyzed, and identified indicators of potential internal, external and operational frauds.
• Facilitated meetings wif senior level management, business partners and other associates to discuss product related sign-off activity during production.
• Report optimization and maintenance on Tableau server

Environment: MS Office Tools, SQL Server, MS Visio, MS Project, MS Outlook, Data Warehousing, Share point, Requisite Pro, Rational Rose UML, Windows.

Confidential - Portland, OR

Business Analyst

Responsibilities:

• Responsible for defining teh scope and business rules of teh project, gathering business requirements, and document them textually or using models.
• Gathered Business Requirements through interviews wif Subject Matter Experts (SMEs) like medical transcripts, radiologists, physicians etc. and captured requirements using Requisite Pro.
• Interacted wif cross functional teams to facilitate gathering of business requirements
• Analyzed system to make it compliant wif Health Insurance Portability and Accountability Act (HIPAA). Teh HIPAA regulation impacts healthcare organizations dat exchange patient information electronically.
• Used teh HL7 messaging protocol to send and receive healthcare data, including patient information and various lab reports information in a standardized format in order to ensure dat teh data was universally understood and organized
• Utilized MS Project to make sure teh project deadlines are met
• Evaluated DOORS requirements management tool
• Identified, captured and documented business process requirements (functional requirement specification) and converted them into Software requirement specification Document
• Created Use Case scenarios and wrote detailed Use Cases as per teh Specifications and Requirements Analysis.
• Interacted wif users and developers to prioritize user functionality issues
• Used, Rational Unified Process (RUP) for streamlining teh team development activities.
• Created Business process Workflow Diagrams, Sequence Diagrams and Activity diagrams in Enterprise Architect

Environment: RUP, UML, Rational Requisite Pro, Enterprise Architect, MS Project, MS Office, DOORS, SQL Oracle 8i.

Confidential - Houston, TX

Business Analyst

Responsibilities:

• Manage teh Requirements (Business as well as System requirements), performed requirements analysis along wif teh creation of Use Case Scenarios. Modeling of teh business and application using Rational Unified Processing (RUP) and Unified Modeling Language (UML).
• Responsible for Gathering Requirements based on teh user requirements and specifications
• Involved in teh meeting wif Business process owners, SME (subject matter experts) and Marketing Team for Requirements gathering in Definition Stage.
• Followed teh High mark Project Methodology.
• Participated in Joint Application Development (JAD) and Rapid Application Development (RAD) sessions for communicating and managing expectations.
• Facilitated teh Customer in defining teh high-level Functional Requirements and needs.
• Gathered teh Requirements, developed Process Model and detailed Business Policies and modified teh business requirement document.
• Created use cases, activity, class diagrams and workflow process diagrams.
• Validated teh Business Requirements.
• Wrote numerous test cases based on test strategies.
• Involved in Functionality and Regression testing during teh various Phases of teh development
• Worked on creating technical documents and led Power Point/Visio presentations for teh development of financial and technical applications for teh departmental user base and for audit purpose.
• Analyzed team performance wif teh QA manager and implemented teh changes if any in order to raise teh efficiency of teh entire team.
• Participated in teh team for User Acceptance Testing.
• Increased process efficiencies across department by spearheading teh implementation of teh full lifecycle software development methodology.
• Interacting wif other teams through walkthroughs, teleconferences, meetings, etc. to resolve various issues.
• Participated in weekly meeting and discussed modification request wif management team.
• Interacted wif teh developers to report and track bugs using TestDirector.

Environment: Windows 7, Microsoft Project 2000, MS Visio, UNIX, Java, HTML, Oracle, Web Logic, IIS, and Test Director.

Confidential

Data Analyst

Responsibilities:

• Documenting data requirements and performing data analysis, wif a clear understanding of differences between business data and metadata
• Worked wif SAS as an ETL tool to extract and load teh data into Teradata table from excel data sources.
• Lead teh Data Correction and validation process by using data utilities to fix teh mismatches between different shared business operating systems.
• Extensive data mining of different attributes involved in business tables and providing consolidated analysis reports, resolutions on a time to time basis
• Reviewed Stored Procedures for reports and wrote test queries against teh source system (SQL Server) to match teh results wif teh actual report against teh Data mart.
• Interpreted complex data mapping and data integration between two or more applications in a producer/consumer construct.
• Created DDL scripts for implementing Data Modeling changes. Designed Star and Snowflake Data Models for Enterprise Data Warehouse using ERWIN.
• Creating and maintaining Logical Data Model (LDM) and Physical Data Model (PDM) for all entities, attributes, data relationships, primary and foreign key structures, allowed values, codes, business rules, glossary terms.
• Validated Data to check for teh proper conversion of teh data. Data Cleansing to identify bad data and clean teh data. Data profiling for accuracy, completeness, consistency.
• Involved in Data Reconciliation Process while testing loaded data wif user reports.
• Developing and writing SQL or similar codes to perform data analysis utilizing concepts such as joins/associations wif teh ability to document data mapping derivations & transformations.
• Root cause analysis of data discrepancies between different business system looking at Business rules, data model and provide teh analysis to development/bug fix team.
• Lead teh Data Correction and validation process by using data utilities to fix teh mismatches between different shared business operating systems.

Environment: Data Stage, DB2, Sybase, TOAD, SQL Server, TSYS Mainframe, ERWIN, SQL, PL/SQL, UNIX, Shell Scripting, XML, XSLT.

Confidential

Data Analyst

Responsibilities:

• Experience in migration of AS400, Oracle to SQL Server 2012 using Informatica 9.6
• Performed detailed Data Analysis to identify KPIs for partners and managers
• Participated in many sessions wif BOAS and business stakeholders to identify Data Cleansing Rules and Transformation Rules to optimize statistical efficiency and Data Quality
• Built Data Dictionary for required fields of Legacy Systems (Source Systems) for better understanding of teh business terms.
• Involved in source to target(MDM) Data Mapping sessions wif IBM as they master teh target.
• Implemented Data Standards at each project level based on ISO standards (Oasis-XNAL, ISO - 3166(Country Codes), ISO 639(Language), ISO 5218(Rationality), Code -1 + (Address), ITU & NANP(Telephone))
• Re-designed crucial tables for business in MDM based on latest requirements
• Implemented key tables into de-normalized data models for teh better understanding for teh Business Stake holders
• Experience in Informatica data quality and analytics tools
• Experience in handling XML operations
• Created a high-level industry standard, generalized data model to convert it into logical and physical model at later stages of teh project using Erwin and Visio
• Used Reverse Engineering to connect to existing database and create graphical representation (E-R diagram)
• Utilized Erwin's reverse engineering and target database schema conversion process.
• Strong SQL programming skills include writing stored procedures, Functions, Triggers etc.
• Strong documentation skills include authoring Traceability Matrix, Quality Requirements, Data dictionary and ETL Requirements
• Well versed wif teh use of graphs, charts, Excel and statistical tables to objectively present teh analysis results for quick and easy reference
• Performed Statistical Analysis(Profiling) and building of score cards for business data using Informatica IDQ.

Environment: SQL SERVER BI 2012, Toad for Oracle 11.6, CA Erwin Data Modeler 9.6, Informatica Developer 9.6, Informatica Analyst, TERADATA, M.S Office 2013, Altova, XML Spy, Altova Map Force, MS Visio 2013.