Vijaya Kumar Nadendla PhD
51 Linwood Dr, Monroe, NJ
609 655 3351
609 851 6795 (C)
vnadendla@gmail.com
Objective: Looking for a contract Data Warehouse Architect / Manager position. Comfortable in taking over current (troubled / successful) projects or in starting brand new initiatives.
Professional Summary:
About fifteen Years experience building 16 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, expectations management.
Build and manage an accomplished team to build a data warehouse from concept to deployment and beyond. Able to handle onshore / offshore teams and additional management responsibilities outside data warehousing (Electronics development, web application development etc)
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 (in Experimental High energy physics analyzing billions of events). Developed an understanding of financial market data, Macro economic variable, derivatives etc to help properly design and manage financial data.
Education: Ph.D. in Physics, LSU, Baton Rouge, Louisiana, Aug 1996
Experience:
BI Consultant, Bloomberg, New York, NY Nov 06 – Current
· Redesigned and developed a multi terabyte scale data warehouse analyzing the user behaviour 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 nerwork engineers on how the data warehouse affects / influences their designs.
· Developed analysis / report using proclarity.
· Developed a 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
Sr Data Architect, American Stock Exchange, New York, NY Sept 06 – Nov 06
Got to production a very messy data warehouse storing hybrid online / floor trading data for regulatory purposes.
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.
Business: Stock Market / Regulatory; Environment: Informatica, Oracle 10g, Linuix
Founder / Architect (Part time), GFMS, Plainsboro,NJ Dec 2005 – June 2006
· Provide design, architecture and expert advice to a start up company developing a financial data warehouse and Data Mining product integrating financial market (Stocks, derivatives, bonds) data at micro (ticks, trades and orders) and macro (indexes, business cycle indicators) economic levels from numerous public and private data sources.
Provide the data warehouse data model in star schema to analyze and store the market metrics and easily calculate financial models. These include calculations and storage of historical variance – covariance metrics, calculations of implied volatility, EWMA, GARCH models of volatility, Market impact of a trade, the Greeks, theoretical Black-Scholes value of hypothetical option etc. .
Business: Finance; Environment: Informatica, Oracle 10g, Windows
Data Warehouse Architect, IDT, Newark, NJ Jan 05 – Sept 2006
· 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.
Business: Telecom, Accounting, Customer Service; Environment: Ab Initio, Oracle 10g, Linuix
Independent Contract (Part Time), DevLogics, 300 Park Avenue, New York, Aug 2005 – Dec 2005
· As an expert consultant, make a proposal for plan, strategy and architecture to acquire, manage and analyze data for a National Political Party in preparation of presidential elections of 2008.
BI Architect, WebMD, New York, NY (5/02 – Jan 05)
· 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.
· Statistical analysis of the web usage trends for profitability, risk and revenue prediction.
· Responsible for the creation and enforcement of enterprise data standards within the organization.
Setup technical and operational production processes.
Business: Health Care / Web; Environment: DTS, SQL Server, Windows, Business Objects
Independent Contractor; Harmonic Corp, PetSmart – Business Intelligence (8/00 – 05/02)
· Responsible for the market basket analysis and predictive modeling.
· Provided architecture and the technical support for construction of few terabyte-sized data repositories on Oracle and SQL Server.
· Business: Advertising, Accounting, Web Analytics, Retail; Environment: Informatica, Oracle, Unix, Business Objects
Data Mining Engineer / Application group Manager, Vasona Systems, Campbell, USA. (1/98-8/00)
· Built a 100 giga byte sized health care Data Warehouse and the data analysis system
· Provided fast near real-time access to extensive variance tracking and analysis, utilization management trends, quality and medical outcomes.
· Created and lead a team of engineers for the Data Warehouse development.
· Used segmentation and decision trees for the healthcare fraud detection.
· Business: Health Care, Web Analytics; Environment: Informatica, Oracle, Unix, Business Objects
(Company Closed)
Advisory Systems Engineer – IBM, Dallas, TX. (12/96 – 1/98)
· Built five data repositories using IBM’s tools for their clients.
· Responsible for the support of IBM’s Data Warehouse and campaign management tools.
· Business: Banking; Environment: DB2, Unix, Business Objects
(Company wide Layoffs)
DESY, Hamburg, Germany. (6/ 93 – 8/ 95)
· Responsible for managing the data acquisition systems of a billion dollar project.
