ROHAN WAGHMARE

** ****** ***** aczw7m@r.postjobfree.com

Edison, NJ,08817 US Citizen 732-***-****(C)

PROJECT MANAGER/BUSINESS ANALYST/TECHNICAL PROJECT MANAGER

Trading & Investment Accounting Systems Professional

~ Core professional competencies ~

Equities

Fixed Income

Bloomberg Trading System

McGregor Trading System

Chase / State Street Custodian

Interactive Data

Derivatives and Futures

Real Estate

Compliance

Risk Management Analytics

Security Pricing & Reference Data

Portfolio Analytics & Ratings

Risk Profiler & Perform

Project Planning & Scope Management

Standard & Poor’s

Intex

Markit

CAMRA Accounting System

PAM- Real Estate Accounting

Bloomberg & Star Compliance

Project Monitoring & Control

Business Inteligency / Data Warehousing

Bloomberg & Star Compliance

Trade Processing and Order Management

Tableau Analytic reporting

Application case owner

Infrastructure Refresh Project

Project Management and Stake holder relationship

Project Resource Management

Peformance Reviews

REPRESENTATIVE ACHIEVEMENTS:

Managed Investment Database Rewrite (Scope $3M) – Migration from PowerBuilder to .Net and MS SQL server 2000 to 2005/2008 with Data Normalization

Implementation of PAM for Mortgages & integration with PeopleSoft (Scope $2 M)

Saved $1M annually with Implementation of Bloomberg Securities reference data and compliance.

Saved $5M with design and implementation of in-house Application to record Structured Loan trading instrument with transaction & holdings at tranche level.

Career Synopsis & Key Achievements

ARCH INSURANCE GROUP 04/2016 – 12/2016

Owner: PolicyWriter – Out of Shell Application for Recording & Managing Insurance Policies with different raiders

Environment: .Net 4.0/3.5 / C#, WCF, Oracle 10, TFS, MS Project Management Tools, Erwin, Toad, Visio, ServiceNow

Project Manager/Business Analyst– Jersey City, NJ

Policywriter Canopy Raider line migration project

Project Management – Monitored and controlled project to completion by coordinating

Daily meetings, maintaining issue & risk register logs, RBS & Project plan, Status updates.

Implemented Agile XP Programing to facilitate pair to pair coding and improve team

Communication.

Business Analyst - Elicited with stakeholders to gather business requirements and streamlined those

Requirements into BRD, FRD, Use cases, Flowchart, Activity sequence diagrams, prepared test plan

And test case to facilitated UAT testing.

Property & Casualty Access migration project

Project Manager / Architect / Business Analyst – Managed, Modeled and migrated Property & Casualty Access Database Application to SQL Server (2008) DataMart.

GUARDIAN LIFE INSURANCE COMPANY 12/2005 – Feb 2016

4th Largest Mutual Insurance Company in America, Fortune 500 Company

Owner: Investment Database – Integrated repository of securities, analytics, entity, pricing compliance rules, risk analytics

Environment: .Net 4.0/3.5 / C#, WCF, Infragistics 9, SQL Server (2012/2008/2005/2000), Apigee Web Services, Erwin 7.1, Rational Clear Quest, Visual Source Safe, TFS, Change man DS, Primavera, Clarity, MS project Management Tools

Technical Project Manager/Project Lead/BA – New York, NY

Investment Database Application Rewrite Project from PB to .Net C#

Conducted and Participated in RFE, RFQ, Vendor selection process, Project costing, Documenting Project Charter, Project Management Plan, WBS, Project initiation & scope, Project Closure & lesson learned documentation.

Managed Onshore/Offshore Resources utilizing Agile Scrum methodology, Daily Stand-up meetings, Approving Change request. Monitored & controlled project deliverables & milestones start to finish by managing resource, cost, quality & time and communicate effectively Project Status & Risk to stake holder.

On-going development of UI screens & MIS reports using .net, C#, WCF & infragastics.

Investment Database Data warehouse Project

Drove the strategic vision, architectural design and creation of a centralized data warehouse. Responsible for the scope, plan, budget, staffing requirements, server selection, software selection, database designs, capacity planning and security levels. Successfully delivered the department data warehouse on time and on budget using waterfall methodology.

Designed Conceptual, logical & physical data models with Star Schema, Created Data Dictionary, Conducted Data profiling & Analysis.

Introduced and contributed to development of SSIS packages & SSRS reports for ETL load processes & reporting needs.

Other IDB Projects

Business Continuity Planning and Successful Disaster Recovery implementation

Elicited with stake holders to gather requirement’s and streamline business needs into functional, business requirements, POC, Technical Design Documents (TDD). Created Test Plan & test case to facilitated UAT testing

Managed and successfully collaborated / implemented Infrastructure & software improvement projects by migrating and testing new servers, Laptops, applications and migrating databases to newer versions.

SDLC life cycle adherence with System Documentation for FRD, SRD, DDD, TDD, Data Flowchart, Prototypes, Gap Analysis, Traceability matrix.

Drove & collaborated in migration of Bloomberg (TOMS) trade data to Bloomberg AIMS gateway with securities reference data feed, Drove the strategic vision, architectural design of Major integration efforts for 20+ vendor application and CAMRA Accounting systems. Design and Implementation of PAM for mortgages collateral insurance & payment, G/L and P&L reconciliation data using SDK Module and reports

Successfully implemented Trade risk Application’s Risk profiler, Perform and big data visualization Analytic tool Tableau.

Design and implemented solutions for Trade issue Allocations, OFAC for Counter party trading and to mitigate risk and avoid dealing with Counter terrorist parties. Star Compliance for Fraud Detection and Prevention of Insider trading and Malpractices.

INNOVATION BUSINESS SOLUTIONS 10/2002 – 11/2005

Software Consulting Services

Senior Software Engineer – IDB Database & Investment accounting systems

Environment: PB (9.02/8/6.5) with PFC; SQL SERVER (2000/7.0), Power Designer

GUARDIAN LIFE INSURANCE COMPANY

Business Analyst & Programmer - Securities pricing feed from Bloomberg, Interactive Data (IDC), Muller

Design & Development – SQL based compliance rule engine to enable traders to perform Pre & Post trade compliance checks, Integration of Analytic data feeds from Yield book, Barclays(Lehman), Credit & LiquidtyRisk Research Automation.

DELOITTE CONSULTANCY 11/2001 –10/2002

Software Consulting Services

Technical Lead Developer - Children’s Electronic Social Service Information Project

Environment: PB 7.08, 8.0 EAS Server (JAGUAR 3.5), DB2, RDBMS, Install Shield 5.5, Power Designer

CHESSIE, MD

Process Automation for records management for Case referrals, Investigations, Case history, Placements

3 Tier Architecture using PB, JAGUAR & IBM DB2

Vendor relationships, Government liaisons, Statutory Audit requirements

INFINITY BUSINESS SOLUTIONS 10/1998–10/2001

Software Consulting Services

Senior Application Developer

Environment: PB5.0, Pro* C, Sybase 11.5, Lotus Notes, Install Shield 5.5, Power Designer, ASP, HTML, CORBA

Trust Company of West, California - Project Lead / Developer

Integration of repository of Securities, Analytics, Entity, Credit Rating - TAZ

Orange County Superior Court, California - Senior Developer

Mainframe replacement with New n-tier Client / Server environment - CMS

OTHERS 03/1994–10/1998

Boston Management Consultancy, Mumbai India (09/1997-10/1998) – Project Lead /

Analyst

Ideal Software Solutions, India (03/1994 -08/1997) – Senior Application Programmer

Education ~ TECHNICAL SKILLS

Bachelors in Commerce– Bombay University; India (1992)

Diploma in Software Engineering– NIIT (1994)

Net, C-#, WPF, WCF Training (2005)

Project Management Training (2010), Yellow Belt in Six Sigma (2014)

~~ ~~ ~~ ~~

RDBMS:

MS SQL Server (2012/2008/ 2005/07)/2000, SYBASE ASE (Adaptive Server Enterprise) /11.5/9.0/4.0 /5.0 –

SQL & I-SQL),

IBM DB2 7.1, Oracle (8.0/7.0/6.0/5.0) P-SQL

Languages:

.NET, C-sharp, PowerBuilder, UNIX, C, SQL, Windows, C++, Java, HTML, XML

Tools:

E-R Win 3.5/7.1, Power Designer, Visio, Mervant PVCS, TFS, Rational ClearQuest, Apigee Web Services, Clarity, Primavera. MS project, Excel, Word, One-note, SharePoint, SSIS, SSRS, ServiceNow, Dimesions, Changeman

O/S & Hardware :

UNIX (Shell scripting in Korn shell, C shell), Windows 95, /NT 4.0/ XP Professional, 2003, 2008,

UNIX based IBM, SUN Solaris, Citrix, and PC’s

Others:

Watcom SQL, Dbase, Foxpro, FoxBASE, Clipper, SQl Anywhere, Pervasive SQL, Rapid SQL, Toad,

FTP, SFTP, API

Knowledgeable Language & Tools:

Hadoop, HiveQL, Cloudera, Informatica power center, JIRA

Contact this candidate