at Fortress Investment Group
Greater New York City Area
at Fortress Investment Group
Greater New York City Area
• More than fifteen Years experience building about two dozen data warehouses and in quantitative data analysis.
• Hands on in design and development with / without ETL tools (Informatica, Ab Initio, Business Objects, SSIS, SSAS, Proclarity) at expert developer level without being a tool jockey.
• Developed a big picture view of the data warehouse encompassing purpose and vision, data, Data model design, database design, ETL, impact on design of infrastructure, life cycle, and expectations management.
• Interface with executive sponsors and serve as the primary point of contact to establish project plans, work breakdown structures, milestones, deliverables, status reports and risk assessments.
• Provide hands on leadership and direction to the development of a Data management and business intelligence competency including architecture and standards at multi terabyte scale. Establish a roadmap for the above.
• Proper mathematical and statistical data analysis and model building background. Developed an understanding of financial market data, Macro economic variable, derivatives etc to help properly design and manage financial data.
Financial, Web, Retail, Health Care, Scientific, Marketing
(Public Company; FIG; Venture Capital & Private Equity industry)
September 2009 — Present (3 months)
Working an settling up a Profit and Loss analysis solution using SSAS, Excel and SQL Server. 100% accuracy and ease of use is of primary concern in this project NOT volume.
(Privately Held; Hospital & Health Care industry)
March 2009 — September 2009 (7 months)
MedAssurant brings an end-to-end medical informatics solution including
* Comparative Effectiveness Analyses
* Research, Development & Clinical Trial Support
* Business Intelligence
* Custom Datasets & Registries for marketing research, disease management analysis, fraud and abuse surveillance etc
(Public Company; 10,001 or more employees; UNH; Insurance industry)
March 2007 — July 2008 (1 year 5 months)
• Worked with the business leaders to set up Governance, Data Definitions, develop a Road Map, set expectations, and anticipate future needs.
• Influenced the Development, QA, Business Groups and Operations to consider the analytical agenda up front by working with respective groups and providing technical expertise and experience where needed. Worked with the respective groups to sell these concepts to their management.
• Took over and provided development assistance to above groups in specific cases – Data Architecture for IT, Data QA for QA, Campaign Management for Marketing etc.
(Privately Held; 5001-10,000 employees; Financial Services industry)
November 2006 — March 2007 (5 months)
• Redesigned and developed a multi terabyte scale data warehouse analyzing the user behavior on Bloomberg terminals using SSIS and SSAS.
• Advocated, mentored and educated the various groups in the company responsible for data warehouse from source application developers to hardware and network engineers on how the data warehouse affects / influences their designs.
• Developed analysis / report using proclarity to identify abuse patterns for management.
• Developed an internal tutorial / Introductory Document to train rest of the group in MDX.
• Developed and presented BI strategy for upper management.
Business: Finance; Environment: SSIS, SSAS, Proclarity, MDX, SQL Server
(Privately Held; 501-1000 employees; Financial Services industry)
September 2006 — November 2006 (3 months)
• Got to production a very messy data warehouse storing hybrid online / floor trading data for regulatory purposes. This was a troubled data warehouse with strict deadlines that needed to be met. Hence, the strategy is to get the data warehouse to work.
• The data warehouse size is over 20 Terabytes in size. For legacy reasons this data warehouse has over 150 dimensions and about 50 fact tables. Proper redesign is not an option.
• Devised and developed solutions to manpower intensive problems and innumerable bugs the above design implied.
• Devised an ETL process that handled the above without a staging environment.
(Public Company; Information Technology and Services industry)
November 2005 — September 2006 (11 months)
• Plan and implement the strategy & methodology to replace the current ad hoc stovepipe data marts and databases in the company with an 8-terabyte-enterprise wide data warehouse.
• Responsible for the creation and enforcement of enterprise data standards within the organization.
• Mandate includes team creation, Software evaluation and purchase mentor and advocate data warehousing and data architecture within the company.
• Took the company from RFI and POCs (Informatica, Data Stage and Ab Initio) to tool selection and company wide implementation. Responsible for the architecture for data management using Ab Initio.
(Public Company; 5001-10,000 employees; Information Technology and Services industry)
2002 — 2004 (2 years )
• Responsible for the technical and data architecture in the development of a 2-terabyte sized Data Warehouse and the data analysis framework using SQL Server and analysis services.
• Developed logical and physical data models for the integration of data from disparate corporate environments. Developed multidimensional data structures for efficient data access.
(Privately Held; 11-50 employees; Marketing and Advertising industry)
2000 — 2001 (1 year )
This data warehouse stored data from multiple online and offline data sources –e.g. from newspaper ads to websites for a unified view of campaigns. Informatica on UNIX, ORACLE, ErWin, SQL
phd , physics , 1991 — 1996
math, Physics, Cricket, Quiz
50 + Published papers as primary and secondary author