CAREER HIGHLIGHTS:

Talented Senior Business/ Analyst of 16 years diverse experience in Finance, Banking, Health care, and Insurance industries on requirement gathering, business analysis, design, testing ,project management and developing BRD, FSD, GUI Mock up, process flow, data flow and Traceability Matrix Mapping.

SKILLS:

Database tools:

Oracle 11.0, Sybase, SQLserver7.0 MYSQL Oracle 10i, PL/SQL, Sybase Stored Procedures, TOAD, MS-Access,IBM DB2,Embarcadero Rapid SQL, Erwin 8.0,Teradata 13.0, Informatica 9.0 Repository manager, Informatica Power exchanger9.0 ,IBM Datawarehouse, ErwinDataModeler 8.0, Erwin Data Navigator8.0, Teradata SQL Assistant 13.0

Tools and process :

Rational unified Process (5.1,5.5 and 2001), Scrum, Agile methodology, JUnit, DBUnit, IBM WSAD5.0, Rational Robot, Rational Real Time, Rational Rose, MS BizTalk server, EDI,Rational Requisite Pro, visual , IBM Lombardi,studio 2005 ,rational soda Rational site load Rational Quality Architect and Rational Clear Quest, JBuilder, MSVisio, Scrum , agile , Spring,J2ME, Navisys, Oracle BPM, , BMC BSM/ ITSM Suite, HQ Quality Suite, java Mobile services,Azure6.0 , Infopath, IBM SPSS, SAS, MS SQL server Report Services,Peoplesoft9.0

Frameworks :

Eclipse and Struts, .BPMN,NET, UML, AML,HIPAA, SOX, RegNMS ,Trade ,Reporting,FPML (ACT),Title 21 CFR Part 11, SEC ,21 CFR Part 820, SHO,ISO, FIX, Six Sigma, SWIFT and Capability Maturity Model (CMM). , ITIL,FIX,, Basel.

Compliance:

HIPAA, SOX, Title 21, Basel, CFR Part 11, 21 CFR Part 820, ISO, Six Sigma, and Capability Maturity Model (CMM),Dodd-Frank

Change management tools :

Rational clear case , Visual Source Safe, 6.0 PVCS, CVS

Mainframe/ Finance tools:

COBOL DB2, WebSphere, CICS, VSAM CICS Transaction Server Version 3.1, Gentran:Server, IBM WebSphere MQ5.1, BridgeStation,OpenCOBOL1 Bloomberg Tradebook,Trade Order Management Systems Schwab Portfolio Center, Bloomberg , SaaS,Professional Murex.3, IRise, UBS Equities Trading Execution Management Systems ,JIRA

Project Management tools :

MSProject 2007 and Project Insight Microsoft Office Project Professional 2007, Microsoft Office Project Server 2007, Microsoft Office Project Portfolio Server 2007 Office, Project, powerpoint, Excel,acess

MS Office /tools:

MS Project, MS Visual Basic,MS Powerpoint, MS Excel, MS Word, MS Visio, MS Access

Reporting Tools:

Report services in MS server,Avaya and oracle data ware house, Oracle Form, Crystal Reports 6.5, Business Objects 11, Cognos 6.5/7.0/8.0.,

Software Lifecycle Methods:

Joint Application Development (JAD), Rapid Prototyping and Traditional Waterfall model,RUP, BPM,scrum ,Agile

Software Development Tools & Methods:

Object Modeling Technique, Use Case Method, basic data modeling techniques, UML ,Agile , Scrum, DSDM , waterfall, CRC,

ERP tools:

People soft, people HRMS and CRM, Supply chain and Finanicials
, Supply Chain,and technical tools, Siebel, Microsoft CRM,Oracle Inventory, Oracle SCM, IBM Maximo-7.8

Requirement tools :

TIBCO iProcess,Rational Requisite pro , Tibco business studio , Mega,SODA,AXURE RPVersion 3.0,4,4, 5.6.DOORs, Rational Suite, Visio, MS office,iRise,Open Connect Comprehend, Xpedio4.0, Open Text

Testing Tools:

Win runner, Load runner, Test Director, QTP ,Siik test, Rational Suite Mercury Quality center , bugzilla, rational quality architect, rational robot ,SoapUI

Document Imaging/collaboration tools:

: Captive, Input Accel, Scan Manager, Kodak Capture Software, Awis, ROSS, XP ,IBM filenet ,EMCLive link.7/9.5 documentum Microsoft Office Document Imaging, IRIS capture pro,DigiTech suites

GIS :

ArcGIS Desktop, ArcGIS server , ArcIMS, ArcSDE, ArcGIS Desktop Tools, ArcGIS Server.

PROFESSIONAL CERTIFCATIONS:

• PMI certified Project Management Professional (PMP)
• Peoplesoft certified consultant
• Six Sigma certified Green Belt

EDUCATIONAL QUALIFICATIONS:

• Bachelor of Technology (BTech)
• Master of Business Administration (MBA) in Finance Management

PROFESSIONAL TRAINING:

• Rational Training on Object Orientated Analysis And Design Using UML,Rational Training on Rational Unified Process RUP(5.1,5.5 and 2001),PMI Training on project management ,Six sigma trained green belt, People soft on Technical tools, HRMS and CRM, Supply chain and Finanicials

PROFESSIONAL EXPERIENCE:

Confidential,New York

Senior Business/Data Analyst
Feb, 2011- Till now

Project: PECOSOvertime
The objective of the overtime system is tofacilitateovertime encumbrance, uthorization/approval, Over Time Code (OTC) generation, OT expense monitoring, FLSA OT cap-waiver management and OT journal-entry processes.The system implements business rules based on DOHMH OT policy, HR policy, citywide compensation rules, collective bargaining agreements, FLSA requirements, OLR requirements and Payroll/OBA requirements.The system features the ability to quickly review overtime commitments and expenditures.Open balances for OT authorizations are maintained at the initiative and employee levels.With this system, staff from division, bureau, Payroll Office and OBA can enforce overtime polices, track overtime effectively, manage cap-waivers and process OT journal-entrie

Project: FIPS (Financial Invoice and Payment System)
The goal of FIPS to track all the invoices of the agencies and process payments by eliminating the duplication of data entry, overcoming concurrent users limitations and prevent fraudulent activities by incorporating full audit trail and replaces all the standalone applications such as Financial invoice tracking system (FITS) ,Administrative invoice tracking system (AIRS) , Miscellaneous Payment Tracking System((MPTS), Miscellaneous Voucher transmitter (MVT), Procurement requisition tracking system(PRTS)and Voucher Processing Log (VPL).

Accomplishments:

Facilitated requirement gathering using various methods (Prototyping, and Use Case Formulation, etc.) to solicit requirements from user groups.
Prepared Project plan, Create WBS, Prioritize tasks, Task allocation and Issue resolution for the project and managed Development , UAT and ` testing team
Accomplished database design and modeling through data flow diagrams at enterprise, conceptual, logical and also part of physical design team.

• Converted business requirements into data mapping, data requirement, ETL processing rules and verified data models consistency and documented GAP analysis and data profiling of the source systems.
• Developed AS IS current data sources for the main sources, level s systems , mainframes, access , flat files , Navistar files , report sources, Heterogeneous Data Sources, Mainframe Sources, Flat Files,XML Sources,Web Log Sources andERP System Sources
• Developed logical/domain data model for the sources , hierarchy , relationships and data dictionary
• Performed data pulls from various sources and data analysis and preparing support data and checking data consistency and automated reporting packages.
• Interfaced with DW and other project team for solving data issues and identification and applied SQL Data mining techniques and Basel II requirements.
• Analyzed requirements for, Heath OEM, Retail, child Care, Subscriber Analytics, Finance, Marketing, and Revenues, invoices, finance and payment and chase payment gateway Accomplished SQL queries and data modeling for reporting and data manipulations and designing reports and validate systems against functional specifications.

Responsible for managing requirements, development, testing, and implementation based application by:

• Formulating business requirements, use cases, user interfaces
• Formulating use cases.
• Performed scenarios based test scripts and execution
• Responsible for the gap analysis of features and functionality contained in the candidate system against the business requirements
• Accomplished data mining/statistical analysis through applying techniques such as linear and non-linear decision tree analysis, content and predication regressing models, discovering groups and structures clustering ,regression function models, feature comparison and selection process modeling, data detection, data segmentation for child, parent, subsidy , attorney and payments
• Responsible for tracking, reporting and analyzing data and making strategy recommendations for adoption campaigns.

Confidential,Virginia
Senior Business/Data Analyst
Feb 2010- Feb, 2011
Project: CAPRI (Capital Market Allocation Profitability and Reporting Initiative)

The goal of Capital Allocation Profitability and Reporting Initiative (CAPRI) is to facilitate corporate goals for evaluating business segment enabling more effective management of business lines , Tax,Accountingview and repot profit on book break split ,Treasury, set and track risk adjusted economical capital Single Family, Capital Market , and Sub-ledger systems implementation solutions integrating desktop and Data warehouse .

• Documented BRD FSD, Use cases , UI Mockup, User guide , test cases and test scripts
• Gathered requirements to develop project vision and scope document, project glossary, rationale for each requirement, control changes to requirement and prioritizing the Basel II requirements through JAD
• Wrote SQL queries for reporting and data manipulations validated technical designs created by IT developers against functional specifications.
• Aligned with Business/Dev/QA/Architects/Data Modeler/SME/ on requirement gathering sessions to define high level design and low level design for the project usage and conducted code reviews and performed unit testing and fixes and requirement validations
• Handled HIPPA Messaging interface data Requirement for Address, Distributed transaction, Transaction item, Transaction state, Claims payload, Attachment payload, Date of service, National provider idenfier,Medical Records for various states such as for 270, 271,276,834,835,277 and 278
• Converted business requirements into data mapping, data requirement, ETL processing rules and verified data models consistency and documented GAP analysis and data profiling of the source systems.
• Developed AS IS current data sources for the main sources, level s systems , mainframes, access , flat files , Navistar files , report sources, Heterogeneous Data Sources, Mainframe Sources, Flat Files,XML Sources,Web Log Sources Ander System Sources
• Developed logical/domain data model for the sources , hierarchy , relationships and data dictionary Responsible for tracking, reporting and analyzing data and making strategy recommendations for housing loan campaigns.
• Interfaced with DW and other project team for solving data issues and identification and applied SQL Data mining techniques.
• Analyzed requirements for, Heath OEM, Retail, child Care, Subscriber Analytics, Finance, Marketing, and Revenues, invoices, finance and payment and chase payment gateway Performed Functional, UI testing integration with Fannie Mae External Libraries , CUSIP Libraries

And deep analysis of Reports

• Performed business Analysis , validation and testing in SQL across Dev, UAT , iota , Consumer and beginning Balance Environment and updates in Data Model
• Performed Data validation and testing for Clean Run , Mock Run and End to End Run , EPF call and State message confirmation Testing and validation Load Specification and Report specifications of Validating Requirements and Producing Test Scenarios and Created Testing artifacts (Test design, Test scripts, and Test implementation)
• Contact person for with Trading, Sales, Finance, and Technology teams to assist with day to day business needs
• Applied Change request/bug fixes for existing functionalities
• Prepared Project plan, Create WBS, Prioritize tasks, Task allocation and Issue resolution for the project and managed Development , UAT and testing team to senior management

Confidential,CT
Senior Business /Data Analyst
Jan, 2009- Jan, 2010
Project: UBSDTP Collateral Inventory and Consumption suite
The Goal of UBS DTP inventory is to track, remediate, of inventory of UBS customer investment bank portfolios across UBS group, product realization, CMDB, ISAC, GETIT, Securities Program management, portfolio optimization, benefit realization, scheduling, remediation and packaging. The Goal of consumption is track the consumption Settlement in real-time electronic trading andFinancial Planning and MI Reporting
Accomplishments:
Facilitated JAD sessions using various methods (Prototyping, User Story and Use Case Formulation, etc.) to solicit requirements from business partners and other groups.
Performed data pulls from various sources and data analysis and preparing support data and checking data consistency and automated reporting packages.
` Web based application to support the enrollment and fulfillment of a mortgage equity accelerator product by:

• Formulating business requirements for BASEL
• Formulating system requirements.
• Formulated test plan and created inventory of test cases, work flows and support procedures
• Attaining sign-off for deliverable documents.
• Reviewed and signed-off on Technical requirements.
• Track issues till closure
• Contact person for with Trading, Sales, Finance, and Technology teams to assist with day to day business needs
• Managed testing efforts, monitored status, and reported up to management and business sponsor.
• Created and managed maintenance and enhancement release schedule.
• Data analysis and data validation of the applications

Confidential,New York
Senior Business/ Data Analyst
Dec, 2007- Dec, 2008
Project: CSCL Emergency Call System.
It is a City of New York DCP program to upgrade multiple components of the City’s emergency communications GIS environment, information technology, and other aligned elements of global emergency communications .This project implements a centrally maintained database of street, address, common place and additional location data to support public safety dispatching and existing City usages of street centerline and addresses.
Accomplishments:

• Documented BRD FSD, Use cases , UI Mockup, User guide , test cases and test scripts
• Wrote SQL queries for reporting and data manipulations validated technical designs created by IT developers against functional specifications.
• Created data models with entity-relationship-attribute and star schema with Kimball methodologies
  Integrating the sub system Subsystems of ETL Extracting Data, Cleaning and Conforming Data, Delivering Data for Presentation, normalization and de-normalizations Metadata and External Data, arching external data and Managing the ETL Environment for Data Mining, Data Mart, OLAP
• Developed data flow analysis, data analysis of feasibility study of ER models for database design for Sybase.
• Created data models with entity-relationship-attribute and star schema ,Integrating the sub system Subsystems of ETL Extracting Data, Cleaning and Conforming Data, Delivering Data for Presentation, normalization and de-normalizations Metadata and External Data, arching external data and Managing the ETL Environment and formulating Conceptual ,Interim and prototypes

Confidential,NY
Senior Business /Data Analyst
Jan, 2007 –Dec, 2007
Project: Annuity suite
Accomplishments:

• Documented BRD FSD, Use cases , UI Mockup, User guide , test cases and test scripts
• Prepared Project plan, Create WBS, Prioritize tasks, Task allocation and Issue resolution for the project and managed Development , UAT and testing team

Wrote SQL queries for reporting and data manipulations validated technical designs created by IT developers against functional specifications.

• Formalized business requirements into system requirements for implementation by development groups. Converted business requirements into data mapping , data requirement ETL processing rules and verified data models consistency and documented GAP analysis and data profiling of the source systems
• Add Changes to the DB model
• Responsible for production support of web based Mortgage Loan Application system.
• Act as SME for downstream systems.
• Accomplished data mining/statistical analysis through applying techniques Basel factors.

PROFESSIONAL EXPERIENCE (From 1994 to 2007)

Confidential,NC (Apr. 2003 – Dec. 05) / Business Analyst /Project: Fidelity Fixed Income Securities lending platform.
Confidential,New York, NY (Dec. 2000 – Mar. 2003)/Business System Analyst /Project: Mortgage Trading System.
Confidential,Charlotte, NC (Aug. 1999 – Nov. 2000)/Business Analyst /Project: Fixed income Risk Management System
Confidential,Charlotte, NC (Apr. 1997 – Jul. 1999) Business Analyst /Project: Net Booker
Confidential,CA (Jan. 1994 - Mar, 1997) / Business Analyst /Project: People soft Incident management/ Senior Business Analyst