SUMMARY:

• Strong prioritization skills and analytical ability to evaluate business operations and support Software Development Life Cycle (SDLC)
• Ability to gather Technical and Functional requirements from both technical and non - technical audiences using a broad array of tools and techniques.
• Experience in Logical and Physical data modeling, including relational and star schema designs based on industry patterns and best practices.
• Developed SQL and PL/SQL scripts to perform data cleansing and PL/SQL procedures to populate date and time dimensions.
• Excellent in performing GAP Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Extensive experience in Extraction, Transformation and Loading (ETL) mechanism using Ab Initio. Knowledge of full life cycle development for building a data warehouse.
• Created Data Lineages using Ab Initio Meta Data Hub.
• Experienced in interacting with vendors/clients to understand business applications by conducting Joint Application Development (JAD) sessions involving stakeholders, Subject Matter Experts (SME's), developers and end-users
• Worked closely with Stakeholders and SMEs to understand the requirements and analyzing specifications for new applications along with modification of the existing application.
• Strong domain knowledge on AML concepts in the areas of CDD, OFAC, transaction monitoring, Fraud and suspicious activity reporting.
• Strong knowledge in creating User Stories and analyzing test scenarios
• Expertise in Data Quality Processes which includes Data Mapping, Data Mining, Data Cleansing, and Data Migration.
• Understanding of Data Warehousing, Business Intelligence Reporting, analyzing Fact and Dimension Tables and using VLOOKUP
• Experience in RDMS Technologies such as MS-SQL Server, Teradata, Oracle 8i/9i and MS Access.
• Proficient in troubleshooting and debugging skills on multiple applications and systems.
• Experience working with business users as well as Senior Management.
• Assisted in the implementation of the COTS reporting tool to integrate it with existing software
• Highly proficient in documenting Business Requirements (BRD's), Functional Requirements (FRD's), Non-Functional Requirements (NFRD's), System Requirement Specifications (SRS), Process Mapping Documents and Test Cases.
• Strong knowledge of SQL, data analysis and data validation using SQL
• Extensive knowledge of GAAP financial accounting, Dodd Frank regulation, investment banking, fixed income products, financial modeling, Credit Risk Modeling and financial statements
• Deep knowledge in Normalization / De normalization techniques for optimum performance in relational and dimensional database environments.
• Created and analyzed Data sources in Tableau Server, Proficient with data Visualization using Tableau.
• Hands on experience with modeling using ERWIN in both forward and reverse engineering processes and created DDL scripts for implementing Data Modeling changes.
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary.
• Worked extensity in Entity-Relationship diagrams, Dimensional Modeling (Star Schema/ Snowflake Schema) and Data Warehousing.
• Excellent with use of MS Access for prototyping and mocking relational databases, MS Excel for analysis and presenting by producing charts, graphs, pivot tables, lookups.
• Worked on Plan view to track progress to goal, including budget and project timelines
• Assisted in developing Training Manuals, Knowledge Transfer Manuals and Training sessions.
• Team leader with proven capabilities of leadership, supervision, and training.

TECHNICAL SKILLS:

Technologies: XML, HTML, DHTML

Business Skills: Business process Analysis and Design, Gap Analysis, Impact Analysis, JAD Sessions Requirement Gathering, Use Case Modelling.

Methodologies: Agile, Scrum, Waterfall.

Management Tools: Erwin, Visual Studio, Clear Quest, Clear Case, Rational Rose, Requisite Pro, ER Studio, TOAD

Modelling Methods/Tools: Erwin Data Modeler9.6/Process Modeler 7.3.8, iRise v9.2,3, ER/Studio 9.0.1,MS Visio, Rational Rose, Rational Rose Clear Quest, UML, XML Spy, JIRA 6.4.14/6.3.15

Database: DB2, MS SQL Server, Oracle, Teradata

Operating System: Windows Vista, Windows 2000/XP/7, and MS-DOS, Mac OS X

ETL / Statistical Tools: Informatica, Data Stage, SQL, MS Excel, Oracle Data Integrator

Microsoft Tools: MS Office Suite 2013, MS SharePoint, MS Visio, MS Project, Visual Studio

PROFESSIONAL EXPERIENCE:

Confidential, Minneapolis, MN

Technical Business System Analyst

Responsibilities:

• Handled varied projects in both Personal and Commercial Insurance area
• Conducted JAD sessions with stakeholders, end users and SME, to determine the critical business processes and identification key functional requirements.
• Gathered requirement information and provided Technical Writing experience to analyze into clear documentation for executive members and staff
• Created Technical Business Rules for the Data Migration Project, which assisted the Project Management team with present and future development goals
• Utilizing MS Visio mapped the Data Migration processes to facilitate the Data Architect in creating accurate strategies.
• Created process flow diagram in MS Visio.
• Conducted timely requirement review sessions with Stakeholders and business and end users to ensure product verification.
• Retrieved Data using SQL queries and did Data Mapping and Data analysis.
• Identified the key stakeholders and the business users of the application.
• Created product roadmap for the various stages and releases thought the project lifecycle.
• Performed Data Analysis and Data validation by writing complex SQL queries using TOAD against the ORACLE database.
• Understanding the business requirements, developing design specifications for enterprise applications using Ab Initio and db2 database.
• Design, develop and Unit test Ab Initio graphs using GDE for Extraction, Transformation and • Loading of data from source to target.
• Designed and Developed Custom reports/files for client requirements in Ab initio.
• Created SQL-Loader scripts to load legacy data into Oracle staging tables and wrote SQL queries to perform Data Validation and Data Integrity testing
• Worked extensively with Data Migration, Data Cleansing, ETL Processes, and Data Mining.
• Created the best fit Physical Data Model based on discussions with DBAs and ETL developers.
• Designed and created Data Quality baseline flow diagram, which includes error handing and test plan flow data.
• Analyze business requirements and processes through document analysis (working specs/product specs, tax specs etc.), interviews, workshops, and workflow analysis.
• Created Data Lineages using Ab Initio Meta Data Hub.
• Worked directly with the Teams and other Coaches and Enterprise Scrum Masters to deliver training, coaching, and written documentation on Agile Practices, Tools, and Techniques to support the goal to produce the highest quality software and the most efficient development teams possible
• Accountable for creating and maintaining Requirements Traceability Matrix (RTM) for tracing business requirements through various phases (analyze, design up to deployment).
• Collaborate with third party vendor to implement claim functionality and actively involved in resolving any issues in pre and post deployment.

Environment: Erwin 9.6.1, Agile/Scrum, Toad, JIRA, Tableau, Ab initio V3.1, Teradata 12.0, PL/SQL, T-SQL, Quality Control, Oracle 9i/10g, Rational Rose, Metadata Hub, Visual Basics, Microsoft SQL Server 2014/2012, Microsoft Visio, Microsoft Excel,

Technical Business System Analyst

Responsibilities:

• Promoted the Agile process within the company, to include responsibility for expanding the understanding and practice of agile principles throughout the entire organization, including technology and operations teams, and the business
• Reviews use cases and other technical documents with development team to ensure business requirements are adequately reflected in technical design documents.
• Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models.
• Ensured the development teams are practicing the core agile principles of collaboration, prioritization, team accountability, and visibility
• Tracked and communicate scrum metrics including team velocity and sprint/release progress
• Identified and removed impediments, prevented distractions that interfere with the ability of the team to deliver the sprint goal.
• Coordinated with the client product owner in defining and tracking deliverables. Actively managed sprint requirement and grooming of sprint stories
• Work with development and QA teams to translate requirements into team work plans.
• Organized and facilitated release planning, daily stand-up meetings, reviews, retrospectives, and sprint planning, demos and other Scrum related meetings
• Performed status Reporting, audit support, and communication responsibilities with departmental managers within Prudential and vendor.
• Retrieved Data using SQL queries and did Data Mapping and Data analysis.
• Tracked project issues, risks and facilitated their resolution, including scope change, resource change, timeline, and any other major issues which may need to be escalated.
• Assisted team with making appropriate commitments through story selection and task definition
• Fielded questions regarding project status, dates, and task assignments - specifically for those not directly involved with the project.
• Wrote SQL, PL/SQL (Procedures/Functions/Packages/Triggers) to handle business functionality.
• Develops reports and queries using PL/SQL based development tools.
• Designed and developed database objects like Stored Procedures, Functions, Triggers, PL/SQL packages.
• Creating Data Source Connection files for connecting to the graphs in order to extract the Metadata.
• Facilitated discussion and conflict resolution empowered the teams to self-organize and improved the productivity of the teams in any way possible.
• I have designed and developed Ab Initio graphs, plans and user defined functions using GDE as per the client requirement.
• Ensured transparency of the process, showing work remaining such as tracking user story completion, sprint burn down and other relevant artifacts.
• Ensure the team strives to make each increment of potentially shippable functionality
• Worked with the product owner and vendor’s product management to facilitate investigation and development of new product features.
• Created Ab Initio graphs to build business logic to extract data from different external systems, validate, transform and load data to Teradata.
• Promoted knowledge and application of agile engineering practices and work with the team to improve practices and tools so each increment of functionality is potentially shippable.
• Participated in the development of Agile Project Management processes, and apply them consistently to assigned products.

Environment: SQL Server 2012, Erwin 8.0, Ab initio, JIRA,PL/SQL, Agile/Scrum, JIRA6.4.14, Oracle 11g, Visual Basics, QlikView, Metadata Hub, Microsoft Visio, Rational Rose, Tableau, Erwin 7.3.4., UNIX, Teradata.

Technical Business System Analyst

Responsibilities:

• Utilized the understanding of market risk concepts, methodologies and data flows to ensure timely, complete and accurate data capture for market risk reporting purposes
• Worked with the accounting team to gather requirements on GL account mapping for accurate P&L reporting
• Coordinated with Finance to ensure accurate closing prices flows through the system at the end of the day for P&L calculation.
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database.
• Worked on data modeling and produced data mapping and data definition documentation
• Supported Risk Analytics and Reporting's Market Risk Information Team
• Involved in production and distribution of market risk reports including investigation and analysis of exceptions, data integrity and methodology issues.
• Supported and complete sale and purchase of securities, debt, and other financial instruments in capital markets.
• Priced securities being bought or sold in keeping with regulatory and corporate standards and contemporaneous
• Designed Activity Diagrams, Workflow & Process Diagrams, Flowcharts and Sequence Diagrams, using UML.
• Coordinated activities between business unit and technical staff,, Provided guidance and acted as primary trainer in education of the business unit as it relates to business applications.
• Coordinated with the traders to understand requirements
• Documented business objectives and business processes.
• Used detailed knowledge of application features and functions, assessed scope and impact of business needs throughout analysis and completion of all post-production enhancement specifications.
• Used Bloomberg professional to retrieve real time data to perform analysis for pricing MFMBS and MFWL.
• Wrote SQL queries in TOAD and excel to perform testing.
• Assisted with User Acceptance Testing (UAT), developed test cases based on business requirements, functional specification and technical specification document & ensured that appropriate documentation is in place.
• Defined processes to ensure account creation and functionality were established.
• Created Test Cases, specified various test scripts, provided sample data for testing.
• Worked extensively with the QA team for designing Test Plan and develop the Test Scripts for the User Acceptance Testing.
• Documented logical, physical and dimensional data models (Data warehousing data modeling)
• Worked on Data Governance, Data Quality, and Data Integrity Coordinated with execution team to define the batch flow for data validation process.
• Elicit and maintain business requirements and align them with functional and technical requirements. Participate in design reviews and walkthroughs.
• Developed release plan and coordinated with development teams to conduct scrums for new development and enhancement of Expense Reimbursement System
• Conducted Defect Tracking and Change Control Procedures using Rational Clear Quest, and Configuration Management and Version Control using Rational Clear Case.
• Created release implementation plans.

Environment: Erwin r7.0, T-SQL, SQL Server 2005/2000, JIRA 6.3.15, Agile/Scrum, Tableau, Microsoft SQL Server, Visual Basics, Toad, Rational Rose, Windows NT, MS Visio, Informatica.

Technical Business Analyst

Responsibilities:

• Perform process analysis and document the business processes for stocks/trade, transaction reports.
• Create detailed user stories and acceptance criteria from high level requirements
• Proactively communicate with the internal and external customers to analyze informational needs
• Interacted with several Investment banks to support UAT testing for them
• Collaborate with developers, SME's to establish technical vision and analyze functional requirements
• Conducted meetings with several Investment banks to resolve their queries on Schemas
• Prepared comprehensive business and functional requirement documentation
• Modified requirements on fixed income securities which contracted with equity securities
• Participated in UAT testing for the portals of investment banks
• Created System test plan so that major functionality is tested
• Develop comprehensive test scenarios as documented in Business requirement document
• Updating unique Trade Identifier (UTI) / Unique Swap Identifier (USI) to process trade reports
• Review/Updated business requirements for Credit, Rates, Commodities, FX and ETD asset classes
• Updating and directing the defects to Risk management team according to the need & priority
• Assisted QA Team in defining Test sets, create test scenarios on HP ALM
• Perform impact analysis using spreadsheet and resolve client issues for various functionalities
• Gathered business requirements for developing Web Analytics and electronic delivery of loan purchase applications, re-finance options, and Home Equity forms via Internet including associated workflows.
• Developed project artifacts such as BRD using IBM DOORS, Data Flow, Work Flow, Process Flow, and Entity Relationship Diagrams in MS Visio.
• Worked on the consolidation of Countrywide and Confidential loans into the Countrywide Loan Economics and Accounting Reconciliation (CLEAR) system.

Environment: Rational Rose, Windows, Tableau, MS Visio, Toad, MS Excel, Oracle 8i, Microsoft SQL Server 2005/2000,Erwin r7.0.