Vipul Kamani acxo2c@r.postjobfree.com

#* **. ********** ***, **********, MA 01803

781-***-****

Background

Extensive experience in Data Management, Analysis, and Product Integration in Information technology. Worked closely with business leaders to build effective strategy to achieve long term vision and goals of the firm.

SUMMARY

Data Analyst with specific expertise in business Intelligence, CDC, ETL, and reporting tools for OLTP, Data Warehouses – in Financial Services, Bio Pharmaceuticals and Insurance.

Experience of managing Reference, Trades and Compliance Data as well as integrating products like Markit EDM, Polarlake, Actimize, LatentZero.

Developed Markit EDM data solutions to acquire data, store in EDM Data-Hub, augment vendor data, and distribute to downstream departments.

Designed MDM solution for Securities and Reference Data in Markit EDM enabling the need for business across organization to support requirements for different asset classes. Efficiently managed reference data for acquisition, management, and distribution across organization.

Successfully managed several large engagements related to business information and solution architectures that included Data Warehouses, Data Marts, OLAP, Business Intelligence (BI) tools, Service Oriented Architecture, Web Oriented Architecture.

Additional Specializations in:

-MDM Architecture, TOGAF, Data Governance, Virtualization.

SKILLS

Enterprise Architecture: J2EE, Web Services, SOA, Message Queues.

Web Servers: IBM WebSphere, Vignette, Apache, Tomcat, and IIS.

Databases: Oracle 11g, Sybase 11, UDB/DB2, SQL Server.

Products: Markit EDM, Polarlake, Actimize, Fiserv GIM, LatentZero, AssetControl, WebMethods, SAP Data Integrator, Informatica, Business Objects, Datamirror (IBM CDC), GoldenGate, Netezza.

MDMPROCESSES

July 2013-Present. Worked as Data and Business Analyst, Data Architect, Lead Developer.

Clients: KromeTechnology, State Street Global Advisors, Parallel Branch, Blue Cross Blue Shield.

Technical lead and analyst for the development of security cross reference using Markit EDM as an EDM Hub. Built Markit EDM solutions and prepared detailed specifications for data and processes to achieve mastering and accuracy of market and securities data. Developed 1000 solutions to acquire data from data providers CITI, ML, Bloomberg, and Point and compared data using data matcher as well as augment with securities data in 3000-5000 solutions and finally distribute data as XML or Flat file by developing 6000 solution for downstream customers including trading platform provided by CRD. Provided detail design documentation and design diagrams for security reference and market data. Ensure that the components are built in line with Markit EDM best practices and solution diagrams. Prepare deployment packages and apply to different environments. Collaborate with business partners to develop and implement systems and processes to ensure straight-through data processing. Conduct process improvement and re-engineering project initiatives for data acquisition, matching, mastering, construction and distribution.

Global technical lead and analyst for development of security cross-reference and pricing of futures and market data using Markit EDM. This project involved legacy systems Sybase, Oracle, and SQL Server. Developed Markit EDM solutions to acquire data from multiple vendors including Bloomberg, Reuters, Factset, MSCI, FTSE, Russell to create universal fie formats or loading files directly into repository. This involved developing solutions involving Data Porters to load data, archive files, employ rule builders, and data constructors for exception processing. Developed 1000 data solutions for different vendors for data acquisitions and used 2000- 5000 solutions for matching, data augmentation using data constructors, data matchers and finally 6000 data solution for distribution of augmented data as a flat file to Fixed Income, Equity, Performance Attribution. Produced BRDs, technical design specification by gathering requirements from data stewards for security reference involving asset classes like futures, equity, and Index.

Developed a web portal for online education using AWS. Led a global team and designed ETL and datamodel for online course using Amazon RDS for MySQL.

Involved in planning, architecture, and implementation in PMO office of multiple projects of BCBSMA in support of Affordable Care Act (ACA).

Designed Conceptual Architecture and Dataflow for Connector Projects involving 834, 820 enrolment and payment files, tax credits, and reconciliation. Involved in identifying MDM domains, consolidating plans and integrating with existing Data Warehouse.

Developed data mapping and dataflow for ACA-Reinsurance involving data extracts from DWH developed on Netezza platform.

Designed Conceptual Architecture for small business involving real time quotes and Web Services. Architected and designed an MDM solution of security reference involving isolation and segregation of data using existing tools within enterprise.

Led a team for researching security and roles of users, reverse engineered dataflows.

Designed dataflow for equities, options for homegrown trading system and Calypso.

Parexel International

Feb 2012-Nov 2012 Enterprise Data Architect

Responsible for ETL infrastructure, Product Architecture and Development in existing Data Warehouse for additional subjects involving clinical trials.

-Technical lead and developer for data migrations of clinical trials in Enterprise Data Warehouse using ETL processes. Responsible for all aspects of data engineering, developing data marts, semantic layers, business and client requests as well as reporting needs for developing additional data sets in EDM. Architected and Designed integration of MDM vendor product in a multi-domain EDM. Designed and Developed physical and logical Datamodels for clinical sites, and trials.

-Architected and developed Web Services to populate ESB using JMS in XML.

Fidelity Investments (1996-2011)

Jan 2010- Dec 2011 Solution Architect/Enterprise Data Management

Global technical lead and architect for development of MDM solution of Security reference from existing data warehouse in legacy systems involving Sybase, Oracle, SQL Server, and AS400.

-Designed Data Architecture for security reference involving different asset classes like equity, fixed income, and derivatives. Produced architecture definition document including data flow, and process flow diagrams.

-Developed POC, Implemented Vendor product integration of Polarlake. Developed polarlake circuits for extracting reference data in XML, implemented division specific rules.

-Architected and implemented a solution involving IBM CDC and home grown replication product to do data migrations for instruments and financial metadata from legacy platform into MDM repositories. Saved firm $500K by utilizing existing infrastructure components.

-Architected and implemented PolarLake and GoldenGate integration with MDM Database for reference data distributing real time updates.

-Managed and configured GoldenGate subscriptions working closely with Infrastructure DBAs, designed data subscription involving ESB and JMS queue.

-Responsible for engaging equity and fixed income, promoting enterprise data model, developed semantic layer, identifying Data Model Gaps and integrating with DWH developed on Netezza.

June 2006- June 2009 Business Systems Analyst/Compliance

Responsible for product architecture, systems/business analysis, development and product integration to help the firm realize efficiencies within the Compliance and Regulatory reporting group. Specific projects include:

Global Employee Trade Monitoring: This project involved Integration of vendor product Actimize with an OLTP system and developing a pre trade module. The project involved design, development and analysis of global holidays, and securities using rules of employees, and trades. Saved $1.3M on implementation by utilizing existing platforms.

-Analyzed SEC regulations for all instruments implementing business and technical requirements and reverse engineering existing processes, analyzed reference and trade data, developed mappings, and programs.

-Integrated vendor product Actimize for POC and Production release into existing DW using API and Actimize case manager. Implemented Fidelity compliance rules by modifying SQL programs.

-Developed CDC subscriptions for market trades, Informatica Mappings for global holidays and researched securities traded to comply with SEC regulations.

Data Sync: The project played key role in providing workflow and queues in an OLAP system to effectively manage accounts and trades. Reduced resource demand by 50%.

-Designed and developed physical and logical data models. Interfaced with a generic interface of loading feed files, wrote scripts and stored procedures to load data using Informatica.

Pyramis Global Compliance: The system provides global compliance for Institutional trades for pensions, endowments and foundations.

-Researched equities, bonds for Institutions making sure the trades are within the compliance. Provided employee trades by using LatentZero APIs. Wrote programs in Java to monitor trades.

Nov 1999-May 2006 Systems Analyst/Shared Information Management

Responsible for product integration, design and development in shared data management group.

Security Management System: Integrated security API developed by vendor CyberArk to manage feed files across organization. Saved firm $2M versus alternative options.

Order Management System: Developed a generic system in C++/Java for fixed income and equity trades involving stocks, bonds and options involving Tibco/RV messages.

Global Fund Holdings: This project-involved development of an OLAP platform, which provided holdings, NAV, and pricing. Integrated Fiserv GIM vendor product for calculation of holdings.

June 1996- Oct 1999 Software Engineer

Fidelity Online Xpress+: Project involved development work for an in house product on windows.

Smart Storage Inc. (May 1993-May 1996) Software Engineer Network CD-ROM: This project involved porting of a product on various platforms to provide CD-ROMs as a drive letter on a network.

Education: UMASS Lowell, M.S, Master of Computer Science, 1993.

Contact this candidate