SUMMARY

• Expertise in Business Analysis, Data Analysis and Testing in domains such as Finance, Investment Banking, and Mortgage. Posses a combination of business, technical, project management and analytical skills.
• Over 9 years of experience in Information Technology involving Business Analysis, Data Warehouse, Reporting, Database design and Database Implementation.
• Extensive experience in investment banking, asset management, trade back office, securities, clearance and settlement, loan origination process and all related verticals.
• Expertise in design, development and analysis of front end application, middle tier and back end systems.
• Experience with Service Oriented Architecture (SOA) enhancing system by leveraging existing services or reusability of services.
• Extensive experience in Business Performance Management, Process Management, Business Process Reengineering and Gap Analysis (as is - to be) and Design Review.
• Extensive and diversified experience in implementing Software Development Life Cycle (Agile, RUP, Waterfall) process improvement with SEI-CMM levels.
• Excellent with use of MS Excel for analysis and presenting by producing charts, graphs, pivot tables, lookups.
• Proficient using MS Access for building of prototypes to effectively build and understand enterprise relational databases.
• Managed documentation of projects; Requirement Traceability Matrices (RTM), Risk Management plans, updated the requirement repository and provided status of documents to PMO team and release team.
• Extensive experience in data transformations, conversion and interface, data loading, database modeling and performance tuning.
• Designed and developed data warehouse ETL applications and data warehouse databases.
• Experience with star schema modeling and knowledge of snowflake dimensional modeling.
• Involved in entire life cycle (SDLC) of the project including providing Production Batch support.
• Conducted Joint Application Development (JAD) sessions/meetings to coordinate with everyone involved in the project.
• Comprehensive knowledge of System Configuration Management, Change Request Management, Risk Management and Version Management processes.
• Expertise in working with data management performing data analysis and gap analysis
• Experience in Rational Requisite Pro and DOORS for requirements management, ClearCase for repository management and Rational ClearQuest for change management.
• Strong visual modeling and business process modeling skills using Rational Unified Process (RUP) with tools like Rational Rose and MS Visio.
• Prepared Interface Agreement Documents and also extensively used the Data Dictionary.
• Experience with SQL, PL/SQL objects. Involved in creating Packages, writing Procedures, and Functions. Tuning using various types of Hints, Partitioning, and Indexes.
• Interacted with all levels of the project development team, from end users to Software Architects, Technical Lead, Database Administrators, and System Administrators.
• Experience with various technologies such as Oracle database, SQL*Loader, MS SQL Server and TOAD.
• Worked on integration and implementation of projects and products, database creations, modeling, calculation of object sizes, table spaces and database sizes.
• Experience with creating reports using Business Objects, Crystal Reports, SSRS, MS Access.
• Involved in database monitoring activities, capacity planning, and SQL tuning.
• Extensive experience in loading high volume data, worked extensively with data migration, data cleansing and ETL processes.
• Extensive experience with UAT and various other test efforts in a data warehouse environment like data validation, data analysis, functional testing, integration testing and system testing.
• Excellent communications skills, analytical skills, logical reasoning skills, interpersonal skills, great work ethics and a great team player.

TECHNICAL SKILLS

Modeling Methods/Tools: ERWIN, Rational Rose, MS Visio, Entity-Relationships, UML Design.

SDLC Methodologies/ Tools: Waterfall, Agile, Rational Unified Process (RUP), Enterprise Development Process, GAP Analysis and Impact Analysis, Use Cases, Business Process Analysis & Research, Requirements Gathering, JAD/RAD Sessions, Content Management, Requisite Pro, DOORS, Rational Rose, JIRA.

Project Management: MS Project (PERT, Gantt charts), OECM (Oracle) 10gR3, CMMI, MS Project Server, SWOT Analysis, CPM, WIP, Alexsys Team *2.

Reporting Tools: Crystal Report XI R2, SSRS, MS Access, Oracle Reports 9i/6i.

ETL/ Statistical Tools: Informatica, SQL *Loader, SAS, MicroStrategy, MS Excel

Databases: Oracle 8/9i/10g, MS SQL Server 00/ 05, MS-Access 00/ 03/ 07, DB2Sybase.

Web/App Servers: Web Logic, WebSphere, Java Web Server, Tomcat, Apache, IIS 5.0.

Quality Assurance: QA Process Cycle, Test Director, Remedy, Quality Center, QTP.

Operating Systems: MS Windows 98, 00/XP/ NT/ Vista, UNIX, Linux,.

Languages: SQL, PL/SQL, Java, C++, VBA, HTML, XML, CSS, ColdFusion, JavaScript, Perl, J2EE, .Net.

Others: MS Office (Word, Excel, PowerPoint, Outlook), plsqldev, TOAD, SQL Server Management Studio, SQL*Plus, SQL Navigator, Doc Share, SharePoint.

PROFESSIONAL EXPERIENCE

Confidential, OH

Solution Lead and Business Analyst

Responsibilities:

• Ensure the MDM Enhancements, Claims transformation solution to integrate with MDM, Confidential Sales Solution (NSS) and Farm Bureau integration is in line with the Business Intelligence analysis results and recommendations.
• Partnering with the ECIF Project Business Lead in defining and documenting the project scope, business goals, processes and practices to provide input to solution requirements and responsible for all business decisions across the project.
• Directing all activities related to solution requirements definition (functional, non-functional and information requirements) and documenting (e.g., business context diagram, event list, business process models, use cases, business rules, etc.) the requirements in IBM Rational RequisitePro and Solution Requirements Document (SRD).
• Coordinating all activities related to translating business needs to system functional, non-functional and information requirements.
• Facilitating Joint Application Development (JAD) requirements sessions with the NRS and NW Bank business partners and Architects.
• Working with user interface designers, Online Service designers (MDM Service/XML) to drive consistency in design and approach for meeting all solution requirements documented in Functional Specification Requirements document (FSD).
• To create workflow analysis document using Function Point Analysis (FPA) methodology and Analysis Class Diagram (ACD) technique.
• Directing Quality Assurance Efforts for requirements and Traceability through requirements traceability verification matrix (RTM) document and supporting risk based testing.
• Executing "design activities" such as designing the system reports, logical data design, physical data model, data mapping, data translation and transformation based on business rules between the NRS, NW Bank and Farm Bureau data sources and the ECIF MDM DB2 database structure using Informatica based Extract, Transform and Load (ETL) technique.
• Ensuring the overall integrity and consistency of the solution requirements across projects for a particular release by coordinating with the release leads.
• To test, verify and approve the new MDM solution using tools like IBM Mainframe, IBM DB2, IBM OPTIM, WinSQL and working with the Quality Assurance (QA) and testing teams to ensure that the solution is working as per the requirements and to deliver quality solution to the Client using IBM Quality Management System (QMS) process.
• Faced lots of challenges in coordinating and gathering the business requirements from different business teams, Security & compliance, Data Governance etc to come to a common conclusion of consolidating different lines of business data for the Duplicate Suspect Processing and Customer data into ECIF using MDM. It was much more complex to implement this solution in Informatica ETL, IBM Infosphere MDM, IBM Mainframe & DB2 as these are new rules that are very critical for this project.
• Defining the solution itself is very complex because of the various security implications involved, security standards, Legal and Data Governance requirements, Technical limitations, Customer experience, Cost & timeline. In specific, the data mapping between the source system to the ECIF was very challenging, where there were 'N' number of roles with Bank, but ECIF can handle only a handful, Data Cleansing, Address Standardization process etc.

Environment: IBM Mainframe, IBM DB2, IBM InfoSphere Master Data Management (MDM) Server database for DB2 on Z/OS, IBM Optim, Informatica - ETL, Enterprise Solution Delivery methodology (ESDm), Agile methodology, IBM Rational ClearQuest/RequisitePro, WinSQL., Insurance Application Architecture (IAA), Banking Industry Framework.

Confidential, Manhattan, NY

Sr. Business Analyst/ Data Analyst

Responsibilities:

• Acquired in depth knowledge on Securities back office operation through processing (STP) platform for end-to-end automation of trade settlement such as - trade processing, settlement, position management.
• Gathered and identified business requirements from the business stakeholders, users, SMEs and translated into FRD, BRD, and system specifications. Interact with all levels of project development team.
• Produced Functional Specifications for large trading systems. Reviewed and analyzed the entire Batch Jobs schedule and provide the analysis to the Technology support team to meet the goal.
• Assisted the project manager in creating detailed project plan and scheduling and tracking project timeline using MS Project.
• Used SAS to automate the process of analyzing the data by combining structured data and unstructured text.
• Prepared a package of Process Flow diagrams to document the existing system and used Rational Rose UML notations for Object Oriented Design and Documentation.
• Worked on Data Modeling including creating of Conceptual and Logical Models using ERWIN.
• Analyzed business processes and created process maps. Wrote standard and complex SQL Queries to perform Data Validation, Analysis and Data Mapping of Sybase and DB2 data.
• Wrote the UI Documentation and Report Specification for all executive summary and detail level reports.
• Worked with Capability Maturity Model as a guide to monitor the growth of all the processes throughout the project.
• Used SAS to obtain a dedicated GUI for profiling data to identify and repair source system issues while retaining the business rules for use in other ETL processes.
• Used MS Visio to represent system under development in a graphical form by defining use case diagrams, activity diagrams and workflow diagrams.
• Created Data Flow Diagrams and Process flow diagrams for various load components like FTP Load, SQL Loader Load, ETL process and various other processes that required transformation.
• Analyzed the business specifications and identifying the source data needed for EUC.
• Assisted in dimensional logical model and physical model as per business requirements.
• Drafted Data warehouse bus matrix identifying conformed dimensions across subject areas.
• Designed data staging area and created High level ETL design to meet the data requirements.
• Developed mappings & mapplets to load NTAPS data into NCDI DWH target table / staging area from various sources using transformations like Source Qualifier, Expression, Lookup, Aggregator, Update Strategy, Router, Sorter, Sequence, Joiner and Filter.
• Used SAS to do cleansing of database through a variety of techniques, including standardization, transformation and rationalization, while maintaining an accurate audit trail.
• Created and maintained various folders, Users, Short-cuts using Informatica.
• Created the workflows by including various sessions, mappings, event wait, timer, source and target connections using Power Center Workflow manager and monitor.
• Automated the process for scheduling the jobs using Informatica Scheduler and from UNIX command line.
• Resolved bugs in existing mapping by analyzing the code using debugger.
• Validated the data by creating data validation scripts to verify the loading process.
• Performed data analysis and processing by selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects, which are grouped into classes for convenience and business intelligence reporting.
• Assisted test lead and testers understanding business process and helped them for successful completion of Unit Testing, Regression Testing and Functional Testing.
• Played a key role in UAT and validating the source to target data mapping.
• Composed a Disaster Recovery Document (DRD).
• Conducted training sessions for the end users and documented various training manuals.

Environment: Informatica 7.1, Business Objects XI R2, Requisite Pro, ClearCase, ClearQuest, Oracle 10g/9i, Sql Server 2005, DB2, Putty, ERWIN, TOAD, Java, Unix, SAS, Windows XP, Peoplesoft GL, NTAPS, Xenos.

Confidential, Jersey City, NJ

Sr. Business Analyst/ Data Analyst

Responsibilities:

• Gathered Report Requirements, analyzed existing Business Objects Report data and worked with Developers to implement Universes by adding objects, editing joins mapping the existing objects with renamed tables.
• Convened with Stakeholders/ SMEs to define system scope, identify problems, and resolve issues to ensure a stable and accurate solution.
• Identified and analyzed key processes for Global Markets and Asset management businesses, executed the results by performing extensive research and conducting client interviews.
• Performed reviews for the financial processes at Investment Banking and Asset Management divisions. In addition, analyzed relevant business processes and supporting applications for trade capture, risk management, clearance and settlement, etc.
• Documented and translated the requirements into and Business Requirements Document (BRD) and Technical Requirement Document (TRD).
• Documented and updated the Interface Specification Document (ISD) to keep up with the changing environment.
• Used Statistical Analysis Software (SAS) to obtain the hierarchical clustering of multivariate data or distance data; disjoint clustering of large data sets; nonparametric clustering with hypothesis tests for the number of clusters.
• Conducted JAD Sessions with the subject matter experts, stakeholders and other management teams in the finalization of the User Requirements.
• Documented Use Case scenarios in various functional areas and also designed UML Models that provided a view of the requirements.
• Produced functional specifications and led weekly meetings to discuss requirements and implementation issues.
• Used Statistical Analysis Software (SAS) to dramatically shorten model development time for both business analysts and statisticians by building more models faster with an easy-to-use GUI.
• Responsible for identifying gaps in the software between core functionality and user defined requirements and developed, updated, maintained Data Mapping Document and tracked the RTM for various implementations.
• Ensured WMR PR and CR functionalities, delivered by the development team, are as specified by the business group in the Business Requirements, Functional Specifications, and Technical Specification Documents.
• Used SAS to provide easy access to source systems, create target structures, import and export metadata, and build and execute ETL process flows.
• Developed and performed business data validation and integrity checks on the key data flows during various stages using SQL.
• Designed and developed ETL technical requirements for CRC account adapters (WMR and Hearsay), holdings, product prices, hedge fund and private equity product prices from functional requirements.
• Developed mappings, workflows to extract data from various sources like XML files, DB2, flat files to reporting data store and staging area to analyze the data as part of input analysis.
• Worked on Input analysis to determine the quality of source systems and SLA requirements.
• Analyzed data extensively using MS Excel and MS Access.
• Developed mappings using normalizer, aggregator, lookup, web services and xml components using Informatica 8.1.
• Collaborated with Developers to schedule ETL process and workflows in Autosys.
• Worked on data cleansing, validations, de-duplication, enumeration, transformation, error handling for various modules of CRC Accounts, Product prices, Hedge Fund prices, Private equity prices, and Hearsay accounts.
• Worked with BO consultants to develop universes and reports for Performance Review using Business Objects XI R2.
• Worked on unix scripts for request and response mechanisms from various source systems CRC (Client Reporting Configuration), TMS (Transaction management System), ADP, RDS (Reporting Data Store).

Environment: Informatica Power Center 8.1, Requesite Pro, SAS, Agile, ClearCase, ClearQuest, Business Objects XI R2, Crystal Report XI, DB2, Sun Solaris 5.8, Java, XML, plsqldev, Autosys.

Confidential, Frederick, MD

Sr. Business/Data Analyst

Responsibilities:

• Gathered System Requirements on Mortgage Servicing, Loan Processing Engine, Payment Processing Calculations for Applying P&I Payments Accounting and generation of control reports and assisted in verifying data from other databases.
• Assisted project manager with the creation of project plan covering Project Schedule, Assignment of tasks, Risk management Plan and Test Strategy.
• Conducted multiple one on one and brainstorming sessions with the SME’s to understand the as-is process and gather business requirements.
• Created as-is data flow and work flow diagrams and to-be data flow and work flow diagrams and conducted walkthrough sessions for these diagrams to make sure that the business and SME’s were on the same page.
• Used SAS to create ETL processes that are reusable, easily modified and have embedded data quality processing.
• Worked with the SME’s, and baseline team to redesign the business process.
• Worked on the functionality of Credit Risk, Operational risk and regulatory exposure that were all integrate to the Single-Family system to provide access to total exposure by customer for decision making, while using Loan documentation packages and performed functional testing on these.
• Created Business use case model, business use case specification, supplementary GUI requirements, reporting requirements and non functional requirements to capture all the business requirements. Used DOORS or requirements and documents management.
• Created Use Case model, Sequence Diagram, activity diagrams in UML using rational rose.
• Managed all requirements and traceability between requirements, design, SIT test cases and UAT test cases using DOORS.
• Participated in developing ETL’s for Data extraction, Data transformation and loading.
• Created Source to Target mappings and ETL jobs using Informatica.
• Collaborated with architect to build logical and physical database models using ERWIN.
• Created Data Flow Diagrams and Process Flow Diagrams for various load components like FTP Load, SQL Loader Load, ETL process and various other processes that required transformation.
• Played a pivotal role in conducting Functional testing, Regression testing, and User Acceptance Testing (UAT).
• Created UAT test plan and conducted a walkthrough session to make sure all other teams (Development, SIT, Deployment, SME and Baseline) understood their roles and effort.
• Created test cases and test scripts for user acceptance testing and maintained them in Test Manager and created traceability to Doors.
• Conducted UAT and made sure all identified defects and enhancements were logged into in-house Access tool (Defect Enhancement Tracking System- DETS).
• Coordinated and prioritized outstanding defects and enhancement identified during UAT, and escalated the same if necessary to achieve the deadline.
• Overlooked the project binder and approvals log and ensured that all approvals and signoffs were attained as per schedule and met with the guidelines laid down by SOX.
• Ensured that changes in business process have strong controls and meet the reporting requirements of Aegis’s internal audit, and SOX.
• Lead the baseline and SME training.
• Created the Service level agreement to meet all current business requirements and anticipated future enhancements.
• Worked as an active member of Change Control Board (CCB) to ensure that varied changes either cosmetic or configuration change requests submitted by the test team are logged, cross environment impact is assessed and cross environment migrations are managed.

Environment: Oracle 8i/9i, MS Suite, SQL, Toad, Informatica, ERWIN, Rational Rose, Win Runner, DOORS, MS Access (DETS), ClearCase, SAS.

Confidential, Shelton, CT

Business Analyst

Responsibilities:

• Involved in requirement gathering, analysis of the requirements from the business owners and users.
• Interacted with users for verifying user requirements, managing change control process, updating existing documentation. Posted the meeting minutes in the company Wiki page for access by the offshore team.
• Created RTM (Requirements traceability matrix) mapping Requirements to Design Artifacts to SIT Cases to UAT Cases.
• Performed Requirements Management that involved change control, version control and Requirement status tracking.
• Analyzed Requirements to generate Use Case Model, Activity Diagrams, Process Flow Diagrams and Class Diagrams.
• Drilled into existent SOA services to leverage maximum application/ software reusability.
• Maintained SOA standards, worked with SOA meta- model, SOA governance and SOA reference architecture for the loan processing engine.
• Conducted data Analysis, data validation using advanced SQL queries.
• Gathered requirement for different financial analysis reports, ad hoc and what if analysis reports using Business Objects 5.1 Reporter.
• Formatted the Reports as per the Report requirements using Business Objects, which allows the users to analyze the data.
• Monitored, load tested and reported on the GECF Business objects Cluster environment supporting more than 1000 users.
• Actively Involved in General Ledger Reconciliation. Wrote SQL queries against Oracle database for report validation of the Accounts Receivable and Accounts Payable tables.
• Worked closely with BO Reporter to develop ad-hoc complex AP/AR/GL reports for users using Web intelligence 2.7.2/6.1a
• Helped develop full client reports using drill down, slice and dice, cross tab, and pivot table using Business Objects and published using Broadcast Agent.
• Responsible for the completion of projects within specified time and budget dealing with financials, project work flow, change management and dealing with vendor relationships.
• Involved in Configuration Management, Requirement management and analysis.
• Created process documents, reporting specs and templates, training material and slideshow presentations for the application development teams and managements.
• Involved in UAT, test plans, documentation of test reports etc.

Environment: Agile, JIRA, Wiki Page, Requisite Pro, SOA, Business Objects 5.1.6/6.1a, Web Intelligence 2.7.2/6.1a, Oracle 8.1.7, IIS.