SUMMARY

•* years of IT experience as a Business Analyst and Solution designer in deployment of web-based, Client-Server applications, developing business processes and system solutions for various projects from conceptualization to implementation

•Excellent technical writing skills to create Business Requirements Document (BRD), Functional Specifications Document (FSD), Nonfunctional Requirements Document and Use Cases Specifications

•Strong process modeling using UML (Use Cases, Sequence Diagrams, Activity Diagrams, etc.)

•Strong in writing SQL queries and reporting the results to the business team. Sound Knowledge of Data Warehouse/Data Mart, Data Modeling Techniques

•Strong Requirement Traceability Matrix mapping

•Excellent Team player to work in conjunction with testers (QA), developers and other team members in validation and testing of complex project scenarios and in the maintenance of Quality Standards of projects

•Excellent conceptual and working knowledge of System Development Life Cycle, RUP, OO Models and UML Methodologies

•Fluent in a broad range of technologies, including business process tools such as MS Project, Excel, Access, Visio

•Experience working in CMMI, ITIL and Six Sigma methodologies

•Have experience with various defect tracking tools: Quality Center, ClearQuest

•Experience in Requirement Analysis, JAD sessions, Business and Systems reviews and working sessions to understand the requirements and system design

•Strong database integration experience. Worked on analyzing data needs, identifying relational databases and coordinating the modeling

•Well versed in Requirements/Change Management, Impact Analysis and Gap Analysis

•Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements

•Strong Analytical and Problem Solving skills, Multi-Tasking abilities, with proven experience in utilizing people and process knowledge to assist enterprises in making critical decision

TECHNICAL SKILLS

Interface/ GUI:

TOAD GUI/Tools MS Project, Project Scheduler (PS7), Visio, MS Office (Word, Excel, PowerPoint, Access), XML & HTML Platforms Windows NT/2000, HP UNIX (UNIX Shell Scripting) Defect Tracking Quality Center (QC), Clear Quest, Defect Tracker (now Software Planner), RADAR, Testing Tools LoadRunner, Quick Test Pro (QTP)

Methodologies: Agile, RUP, SDLC, Waterfall, Scrum, Six Sigma, CMMI, ITIL other Skills Requirements Gathering & Management, Application design, development and testing, Database Design, Application Migration.

Configuration Tools: Rational ClearCase LT, Visual SourceSafe (VSS), Rational Requisite Pro

Tools: AbInitio GDE (1.12/1.13/1.14 Co>Op 2.12.18/2.13.11/2.14/3.0),ACE,BRE and Informatica,Talend DQ

OLAP Tool: Cognos, Business Objects 4.1/5.0/5.1 (Supervisor, Designer, Reports, Broadcast Agent), and Web Intelligence 2.5/2.6, SDK. RDBMS: Oracle 9i/8i/7.x, SQL Server 6.5/7, DB2 UDB, Teradata V2R5

Languages: SQL, PL/SQL, XML, C, C++, VB 6.0, Java (1.2), COBOL,

Data Modeling: Erwin 3.5.5/3.5.2/4.0,Testing Tools: Test Director 7.X, Mercury Quality Center

Operating Systems: AIX, UNIX (BSD), Mainframe TSO/ MVS, SUN Solaris & Windows NT/2000

Internet Technologies: Html 4.0, JavaScript 1.2, JSP

EXPERIENCE

Accolade, Plymouth Meeting, PA January 2015–Present

Senior Business Analyst

Project: AIM 2.0 Enterprise Data Warehouse (EDW)

EDW is for holding and managing the pharmacy/member/dependent related information. The entire picture can be seen with the information present and we are to get the person better savings as an outcome. The process to achieve this is through MDM and create golden records to have accurate information for the person.

Responsibilities:

•Designing the Architecture document by analyzing the Business requirements and Mapping documents

•Technical writing skills to create Business Requirements Document (BRD), Functional Specifications Document (FSD), Nonfunctional Requirements Document and Use Cases Specifications to facilitate efficient data mappings.

•Planning Test Cases & Scripts based on the URD for directing, tracking and outlining needs during a project SDLC

•Produce complete data mappings and data conversion, carried out regular triage meetings to recognize and provide resolution for critical defects.

•Document detailed UAT and QA test plans during the deployment phase.

•Involved in System Testing for the modules, Creating Bug Reports and providing alternate design specs, Making Test Coverage, Test Cycle Strategy and writing and Executing Test Plans, Making comparative reports on actual and expected results and creating Test Reports

•Became well versed in Root Cause Analysis Characterization of Dashboard Reports in Cognos

•Knowledge of various operational sources like Oracle, Sql Server, Teradata, Netezza. Proficient in Operations Hand off guide & perform GAP analysis.

•Created, maintained and evolved documentation for change management process

•Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.

•Worked with POS systems for Simplifications and visualization of the data.

•Data modeling under different schemas like Star Schema and Snow Flake Schema

•Implemented the approved suggestions and modified the current process flows

•Created Requirement Traceability Matrix to make sure the current project requirements are being met

•Developed test cases and participated in UAT (User Acceptance Testing)

•Use ETL tools like Informatica, Talend for mapping the source to target data in alignment with the documented business rules

•Multiple graphs were built to unload all the data needed from different source databases by configuring the dbc file in the Input Table component, load to Hadoop and profiling using Talend DQ

•Developed a number of Ab Initio Graphs based on technical design documents using various Ab Initio Components like partition by round robin, partition by key, rollup, sort, scanning, dedupsort, reformat, join, merge, gather, concatenate components.

•Developing Korn Shell scripts to automate file manipulation and data loading Procedures. Check Out existing applications in UNIX in order to perform the necessary modifications.

•Great customer interfacing skills and customer orientation, Self-motivated, result-oriented and desire for constant learning

•Testing various software used for data processing, Involved in System Testing for the modules

•Creating Bug Reports and providing alternate design specs, Making Test Coverage and Test Cycle Strategy

Environment: Remedy, Tech Events, MS - Office, SQL, Windows, Ab Initio GDE, Informatica, Shell Scripting, PL/SQL, Teradata V12, DB2 Mainframe, Cognos 8.4, Teradata SQL Assistant V12, and Netezza

Catamaran, Philadelphia, PA June 2013–December 2014

Senior Business Analyst/Solution Designer

Project: Enterprise Data Warehouse (EDW/MDM)

EDW is for holding and managing the pharmacy and member related information. Whenever a person purchases a medicine from a pharmacy, he has to pay minimum liable amount (co-pay) as per the medical plan. If the person pays more than this amount then there will be a refund of the extra amount. Otherwise if the person pays less than co-pay amount then a bill will be generated and accordingly the person has to pay the remaining.

Responsibilities:

•Designing the Architecture document by analyzing the Business requirements and Mapping documents

•Technical writing skills to create Business Requirements Document (BRD), Functional Specifications Document (FSD), Nonfunctional Requirements Document and Use Cases Specifications to facilitate efficient data mappings.

•Planning Test Cases & Scripts based on the URD for directing, tracking and outlining needs during a project SDLC

•Produce complete data mappings and data conversion, carried out regular triage meetings to recognize and provide resolution for critical defects.

•Document detailed UAT and QA test plans during the deployment phase.

•Involved in System Testing for the modules, Creating Bug Reports and providing alternate design specs, Making Test Coverage, Test Cycle Strategy and writing and Executing Test Plans, Making comparative reports on actual and expected results and creating Test Reports

•Became well versed in Root Cause Analysis Characterization of Dashboard Reports in Cognos

•Knowledge of various operational sources like Oracle, Sql Server, Teradata, Netezza. Proficient in Operations Hand off guide & perform GAP analysis.

•Created, maintained and evolved documentation for change management process

•Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.

•Data modeling under different schemas like Star Schema and Snow Flake Schema

•Implemented the approved suggestions and modified the current process flows

•Created Requirement Traceability Matrix to make sure the current project requirements are being met

•Developed test cases and participated in UAT (User Acceptance Testing)

•Use ETL tools like Informatica,Talend for mapping the source to target data in alignment with the documented business rules

•Worked with POS as a source system.

•Multiple graphs were built to unload all the data needed from different source databases by configuring the dbc file in the Input Table component

•Developed a number of Ab Initio Graphs based on technical design documents using various Ab Initio Components like partition by round robin, partition by key, rollup, sort, scanning, dedupsort, reformat, join, merge, gather, concatenate components.

•Developing Korn Shell scripts to automate file manipulation and data loading Procedures. Check Out existing applications in UNIX in order to perform the necessary modifications.

•Great customer interfacing skills and customer orientation, Self-motivated, result-oriented and desire for constant learning

•Testing various software used for data processing, Involved in System Testing for the modules

•Creating Bug Reports and providing alternate design specs, Making Test Coverage and Test Cycle Strategy

Environment: Remedy, Tech Events, MS - Office, SQL, Windows, Ab Initio GDE, Informatica, Shell Scripting, PL/SQL, Teradata V12, DB2 Mainframe, Cognos 8.4, Teradata SQL Assistant V12, and Netezza

Kaiser Permanente, Pasadena, CA January 2012– May 2013

Senior Business Analyst

Project: Pharmacy Transactional Data Store (PTDS)

PTDS (Pharmacy Transactional Data Store) is for holding and managing the pharmacy related information for the members coming under Kaiser Health Plan. Whenever a person purchases a medicine from a pharmacy, he has to pay minimum liable amount (co-pay) as per the medical insurance plan under which he/ she is coming. If the person pays more than this amount then there will be a refund of the extra amount. Otherwise if the person pays less than co-pay amount then a bill will be generated and accordingly the person has to pay the remaining. There is a matching procedure also to do a matching between different kind of sources and the best one is picked up and sent to the other systems. After receiving the information the external system will send an acknowledgement

Responsibilities:

•Designed the Architecture document by Analyzing the Business requirements and Mapping documents

•Replicate operational tables into staging tables, transform and load data into warehouse tables using Ab Initio GDE and responsible for automating the ETL process, Filtered out header and trailer records to implement source balancing on the graphs to generate control-balancing reports and to create system log

•Collected useful requirements to design the user approval and entitlement executive system.

•Planned Test Cases & -Scripts based on the URD. Utilized Quality Center for directing, tracking and outlining needs during a project SDLC

•Sr. analyst on the data migration projects to combine client information from the distributed policy resource systems into Enterprise Customer Info File. Produced complete data mappings and data conversion Carried out regular triage meetings to recognize and determine critical testing faults

•Performed JAD sessions to collect needs for Credit Suisse Mortgage Backed Security order management systems

•Described Business laws for the universal Compliance Engine, the Credit Suisse proprietary trade compliance engines

•Formed detailed UAT and QA test plans, managed system testing and preserving testing documentation, Helped QA analysts and technical heads with troubleshooting and fault resolution.

•Involved in System Integration Testing (SIT) and User Acceptance Testing (UAT). Testing various software used for data processing

•Involved in System Testing for the modules, Creating Bug Reports and providing alternate design specs, Making Test Coverage, Test Cycle Strategy and writing and Executing Test Plans, Making comparative reports on actual and expected results and creating Test Reports

•Became well - Versed in Root Cause Analysis Characterization of Incident Reports

•Ensured integrity of incident data thru Weekly scrubbing session

•Prepared Data for Weekly Operations Meeting using IT Metrics Values

•Actively participated in daily meetings and discussed about the SEV calls and Action Items

•Actively participated in International Maintenance Meeting

•Assisted Call Managers with overall management of SEV calls to ensure resources are properly engaged and incident resolution is occurring.

•Worked as a Data Steward for the MDM functionality.

•Created on - call escalation tickets using Remedy

•Conducted weekly scrubbing sessions to finalize the impacts and root cause,

•Reported weekly system performance metrics (R3

•Created, maintained and evolved documentation for change management process

•Updated Weekly Operational report on OneNote tool

•Updated the Root Cause Analysis report every week on ITSEV

•Used Remedy tool for Root Cause Analysis

Environment: Remedy, Tech Events, MS - Office, SQL, Windows, Ab Initio GDE 1.13.13/1.14.38, Co>Op system 2.13.1/2.14,3.0 EME, Shell Scripting, PL/SQL, Teradata V12, DB2 Mainframe, Informatica 8.4,Cognos 8.4, Teradata SQL Assistant V12

Wells Fargo, San Francisco, CA May 2011–December 2011

Designer /Senior Business Analyst

Wells Fargo is one of the leading banks, where I was part of a team, which processed all the transactional and experimental data from different operational systems. The project is a complete data warehouse lifecycle project.

Responsibilities:

•Designing the Target Schema definition and Extraction, Transformation and Loading (ETL) using abinito designing and developing packages to create Summary tables. Mapping Data Items from Source Systems to the Target System from the XML. Used the abinitio to develop processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database.

•Expertise with analytical reporting using Advanced Excel features like Pivot tables and charts

•Designing and developing Universes for reporting generation from different databases.

•Attended training programs and mentored team-members for an observed increase in performance, Strong analytical, pattern detection and problem solving abilities.

•Developing Korn Shell scripts to automate file manipulation and data loading Procedures. Check Out existing applications in UNIX in order to perform the necessary modifications.

•Great customer interfacing skills and customer orientation, Self-motivated, result-oriented and desire for constant learning

•Testing various software used for data processing, Involved in System Testing for the modules

•Creating Bug Reports and providing alternate design specs, Making Test Coverage and Test Cycle Strategy

•Writing and Executing Test Plans, Making comparative reports on actual and expected results, Creating Test Reports. Developed a project plan using Microsoft Project based on details contained in the HL BRS and also a project plan to schedule and assign work and manage the project.

•Worked closely with project managers, business users to formalize a business idea and define requirements.

•Interacted with the business users and division supervisors to gather the requirements

•Gathered requirements for building a current business process that hosted day to day trading activities of various commercial recordings divisions

•Developed functional documents like Mail and Receipting, New Filings, Status and Copies business requirement specifications

•Analyze gathered requirements data, verify requirements and create business requirement specifications (BRS)

•Created process flow diagrams using Visio

•Conducted JAD and brain storming sessions with the business users and stakeholders

•Conducted meetings with all the division supervisors to ensure that all the requirements are met

•Implemented the approved suggestions and modified the current process flows

•Created Requirement Traceability Matrix to make sure the current project requirements are being met

•Developed test cases and participated in UAT (User Acceptance Testing)

Environment: Test Cases, JAD, Quality Center, SQL, XML, Ab Initio GDE 1.13.4,FTP, MS-Office, Windows, Rational Rose, FileNet, MicroFiche, Windows, AIX UNIX 5.2, Visio, Teradata, Oracle, Microsoft Office (Access, Word, Excel and PowerPoint); Crystal Reports

JP Morgan Chase, Columbus, Ohio February 2010 – May 2011

Senior Business Analyst

Client Sub Ledger - A business ledger that hosted client's daily transactions, security positions and cash balances. It was a$2.7M project with multiple phases of release. This service was earlier provided by Broadridge (ADP). Building this ledger reduced dependencies on third party systems and will save millions of dollars to the company over years. Affirmations - An in-house tool was built to communicate with front office, back office and external parties such as ADP and DTC (clearing house) to assist in settlements and clearings of equity securities for Prime Brokerage clients. It was a complex system built with different matching capabilities and ability to process millions of messages in milliseconds. Buy-In - Buy-In relates to post settlement date activities. A service was built to get away from a manual costly process to an automated cost efficient process for sending buy-in requests to DTC, leading to higher accuracy and saving on man power.

Responsibilities:

•Worked closely with project managers, business users and developers to formalize a business idea and define re requirements using rational requisite pro

•Analyze gathered requirements data, verify requirements and create functional specifications (FRD/FRS)

•Gathered requirements for building a sub-ledger that hosted day to day trading activities of various hedge fund clients and assist in reporting and accounting

•Mapped data between Sybase to Sybase, Sybase to Oracle databases to assist in analysis and development phases of Client Sub Ledger project.

•Followed CMMI to improve the quality of process outputs and reduce defects

•Queried relational databases using SQL on a daily basis to resolve operational issues and assist business and IT in better understanding of business requirements. Gathered requirements for creating "Affirmation Engine" that would assist in matching trades and confirm and straight through processing (STP) for the clients

•Expertise in Business Process Modeling and Use Case Modeling using Unified Modeling Language (UML) and Rational Rose tool.

•Created Requirement Traceability Matrix to make sure the current project requirements are being met.

•Work with Development and QA teams to transition business requirements into QA test cases and assist in UAT

•Acted a project manager/business analyst for the Buy-In project and build a new application using service oriented architecture (SOA) and XML to assist the Stock-Borrow Loan team in sending Buy-In requests to DTC for post settlement date clearings

•Managed enhancements and defects promptly to assist the operations in resolving issues

Environment: Use Cases, SQL, UML, JAD, Quality Center, Java, XML, FTP, MS-Office, Windows, Rational Rose, Rational Requisite Pro, Windows, HTTP, Six Sigma

Travelers Insurance, St Paul, MN September 2009 – February 2010

Senior Business System Analyst

The EOS Program delivered a common online servicing platform, merging the various servicing platforms that existed. This project includes Process redesign and Integration across multiple channels for account reconciliation since transactions are spread across multiple systems.

Responsibilities:

•Followed ITIL methodology to improve the quality and reduce defects

•Interacted with multiple cross-functional teams ensuring that all business requirements are captured correctly and report progress to all levels in the organization

•Performed analysis of business rules, business and system process flows, user administration to be used for the new merged platform

•Supported Unit Testing and System Integration Testing (SIT)

•Developed Requirement Traceability Matrix to record the relationship of the requirements to the design, development, testing and release of the software

•Executed SQL queries on relational databases to create daily reports

•Used Rational Rose for Use case modeling.

•Responsible for developing Business Requirement and Functional Requirement Document and documenting the requirements in Mercury Quality Center

•Acting as a liaison between the technical, business, testing groups to provide them with required specifications/documentation and to resolve any issues in between

•Worked with the User experience team to design the GUI for the application

•Partner with the LOBs to understand strategic goals, and identify technology components to enable business results

•Identified, researched, defined and documented user problems and automated/manual business processes.

•Actively solicit, analyze, prioritize and negotiate customer requirements from scope definition through detailed system requirements

•Perform root cause analysis, develop solution options, and influence the organization to adopt recommended solutions/trade offs

Environment: Ab Initio GDE 1.13.13/1.14.38, Co>Op system 2.13.1/2.14, 3.0 EME, Shell Scripting, PL/SQL, Teradata V12, DB2 Mainframe, Informatica 8.4,Cognos 8.4, Teradata SQL Assistant V12.0

First American CREDCO, NY September 2008 – August 2009

Data Quality Analyst

Project: Credit Risk Evaluator

The Credit Risk Evaluator Project is an integrated customer - controlled platform for credit risk management. It is a powerful tool for measuring and monitoring and managing credit risk, thereby offering a broad range of analytical Capabilities and user control. The platform enabled institutions to estimate and stress credit risk measures and rating estimates by using scorecards/models.

Responsibilities:

•Involved in understanding the reporting requirements and re-engineering the existing regulatory reporting process through consolidating regional databases into a global database

•Involved in understanding of Credit Risk management for the application

•Communicated the implementation of the new calculation framework of Risk Weight Asset under Basel II

•Was responsible for creating and reviewing business requirements, functional specifications, project schedules and other documentation

•Created UseCase models using Rational Rose

•Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.

•Executed SQL queries for Data analysis, completeness and accuracy

•Worked extensively with risk and portfolio managers in calculation of risk parameters (PD, LGD and EAD) based on Standard, FIRB, and AIRB approach

•Facilitated collection of requirements and preparation of business requirement documents (BRD) and function specification documents (FSD) in support of risk underwriting strategies for execution by the IT group

•Conducted monthly application review meetings with the operations groups to understand better the impact

•Requirement gathering, Business Process flow development, and Business Analysis

•Created Effective Use cases and Integrated High level Use case Scenarios in the Project and identification of Basic/Alternative flows

•Involved in the UAT for the application process

•Assisted in development of Test Plans and assisted QA team in System testing to ensure the new system satisfy all User requirements

•Collaborated with project manager in tracking and managing project development process following RUP based SDLC methodologies

Environment: MS-Office, JAD, UML, SQL, Data Analysis, Credit Risk Management, RUP, SDLC, Use Cases, Quality Center, HTTP

Discover, Chicago, IL Jan 2008– Aug 2008

Data Warehouse Consultant

Responsibilities:

•Actively participated in the Design Committee meetings for building the system and enhancing the same.

•Worked with the Business Users to translate the requirement documents into technical design documents and participated in Designing and implementing the processes using Ab Initio, SQL and Shell scripts.

•Replicate operational tables into staging tables, transform and load data into warehouse tables using Ab Initio GDE and responsible for automating the ETL process, Filtered out header and trailer records to implement source balancing on the graphs to generate control-balancing reports and to create system log

•Multiple graphs were built to unload all the data needed from different source databases by configuring the dbc file in the Input Table component

•Developed a number of Ab Initio Graphs based on technical design documents using various Ab Initio Components like partition by round robin, partition by key, rollup, sort, scanning, dedupsort, reformat, join, merge, gather, concatenate components.

•Also used components like running program and running sql components to run UNIX and SQL commands in Ab initio. Also used the components like filter by expression, partition by expression, replicate, partition by key and sort Components

•Working with Departition Components like Gather, Interleave in order to de-partition and Repartition the data from Multi File accordingly.

•Performing transformations of source data with Transform components like Join, Match Sorted, Dedup Sorted, Reformat, Filter-by- Expression.

•Create Summary tables using Rollup, Scan.

•Developed Wrappers using Korn Shell Scripting to call Ab Initio scripts. Worked with Informatica Power Center Mappings.

•Used Data Parallelism, Pipeline Parallelism and Component Parallelism in Graphs, where huge data files are partitioned into multi-files and each segment is processed simultaneously.

•Developed Unix Korn shell wrapper scripts to accept parameters and scheduled the processes using Tivoli Work Scheduler (TWS)

•Involved in System Integration Testing (SIT) and User Acceptance Testing (UAT).

•Working as a Project Leader for a team size of Four members at Onsite and seven members from offshore.

•Worked together with team members in identifying the common functionality across various processes, and hence designed and developed Common Components.

•Followed standard ETL practices in designing the system by leveraging the Common Unloads and using delta files processing approach in place of repetitive unload of data from same set of tables.

•Involved in Up gradation of Ab Initio Co>Op system and GDE software to versions 2.14 and 1.14 respectively.

•Developed various utilities to perform regular maintenance work like Migrating data from one database to another, Converting the data provided in the excel sheets to Ab Initio readable format and load the same to the respective static Mapping lookup tables.

•Extensively used Awk, Sed and Grep scripts in periodic monitoring of the Production executions.

Environment: Ab Initio GDE 1.13.13/1.14.38, Co>Op system 2.13.1/2.14,3.0 EME, Shell Scripting, PL/SQL, Teradata V12, DB2 Mainframe, Informatica 8.4,Cognos 8.4, Teradata SQL Assistant V12.0

Contact this candidate