Above 18 years of strong IT experience in Databases/Data Warehouse/ Applications Architecture, Design, development, Build and Release. Application Development: Development of stand-alone applications, client/server, n-tier, component based, messaging, middleware/data transition, intra/internet, enterprise and knowledge based/expert systems. Functional Expertise: Functional expertise in the area of Insurance , Finance , Health Care, Biotech, Online Gaming, Retail and Asset Management for both B2B and B2C environments.
Skills
ROI-Attacks everything with drive and energy with an eye on the company’s strategic plan
Agile mindset and processes
Results driven orientation.
Budgeting- Investment Priorities, and Execution.
Strategic thinking for advancing the Enterprise.
Leading teams -Mentoring, skill development and retention
Governance creation and establishment.
Collaboration-Building & Adapting
Platform / Technology SKILLS
Big Data Tech- Building Data Lakes and Self-Service Analytical Capabilities
Data Governance- Metadata management, Business Glossary , Skill set Development
Continuous Improvement and Development
DevOps
Nidhi Khetrapal: RESUME
Work History
Principal Analytics Engineer Architect, 06/2019 - Current PPR, CoStar Group – City, STATE,
CoStar/PPR Analytics and Forecasting platform: Responsible for Design and development of PPR analytics and Forecasting platform for commercial real estate markets.
Devised and implemented various algorithms by combining Rents, Vacancy rates and key attributes of nearby property properties.
PPR forcasting platform:.
Responsible for Design and development of PPR analytics and Forecasting platform for commercial real estate markets.
Devised and implemented various algorithms by combining Rents, Vacancy rates and key attributes of nearby property properties.
Costar Analytics platofrm:.
Costar suite develpment.
Apartment.com.
Lender.
Senior Data Warehouse Manager and Architect: Turbine, 06/2014 - 06/2019 Warner Brothers Entertainment Group – City, STATE,
Business Intelligence/Business Impact: Implemented the first company-wide data warehouse utilizing Microsoft BI as the solution platform, providing business insight into daily operations with well-defined structured automatically delivered metrics.
It integrates various subject matter data (Profit & Loss, MTM, Exposure, Cash Flows, Impact, Counterparties, etc.) from Turbine billing application and Turbine gaming applications.
The analysis spreads across Financials, Revenue Performance, Fraud detection, Email campaigning, Customer support, Player Conversion and Player behavior data.
BI Evangelist and WB platform: Acted as a key evangelist while promoting BI platform/culture across multiple departments within Turbine.
Not only it helps providing useful insights when launching Free to Play version of our games but also turned out to be a key selling component in the WB buy out process.
Architecture improvements: Identified and encapsulated into enterprise level services multiple BI hooks, db/application standards and other IT specific functionalities.
Lead the design and development of KPI data mart to standardize Turbine's business analysis and dash boarding.
Lead the design, development and help my team to build a Revenue data mart to do end to end analyses across various sources of revenue and in depth analysis of Subscriptions, points and item sales.
Implemented and rolled-out a framework of generic Web Services to support data operations, the framework is being enriched and optimized on on-going basis.
WBNET/Future BI Architecture: Did a full blown evaluation of next generation DW platform technologies in the market.
Selected Vertica after a thorough investigation looking at Warner's future BI needs.
Completed a POC to measure performance and big data handling.
Did a POC to evaluate high volume trickle loading and bulk capabilities within Vertica.
This will further help direct integration of applications with scalable mpp Vertica infrastructure.
Developed a complete understanding of nosql open source technologies like Hadoop/pig/hive, mapreduce and mongodb to facilitate integration with Agora and establish industry standard data structures.
Developed an ETL code to extract data form Agora's nosql database.
This was further used to extract data for Mortal Kombat as well as helped MK in analysis of their game.
Evaluated various high speed data transfer technologies in the market and selected Aspera to handle big data transfers between Agora and Turbine.
This can also be used to do other high volume data transfer needs.
WB/Turbine Finance Integration: Designed and developed a complete WB Revenue recognition, reconciliation and amortization application.
The application pulls data from 15 different payment processors, reconcile it against Turbine internal systems and further integrate the data against WB SAP based system.
Process Improvement: Executed a comprehensive process reengineering initiative and re-mapping applications flows by working with Game designers and various application stakeholders to standardize the data flow to Data Warehouse.
CRM Turnaround: Successfully upgraded and re-implemented Email campaign system using BlueHornet.
Further measured effectiveness of Marketing campaigns allowed fine-tuning targeted Marketing campaigns and campaigns effectiveness improvement by significant amount across all player segments.
Data Warehouse Architect and Consultant, 01/2004 - 01/2005 Trinity Pharmaceutical Solutions – City, STATE,
Responsible for successfully leading the implementation of multiple CRM solutions to leading clients in Pharmaceutical, Healthcare, Biotech and high tech sectors.
Areas of expertise include sales force automation.
Allergan Pharmaceuticals - Managed Market Data resource (MMDR):: MMDR is an enterprise data warehouse (EDW) solution designed to enable Pharmaceuticals companies to easily obtain relevant, accurate and up-to-date information about prescribers, managed care organizations, wholesalers, distributors and consumers.
It involves cleansing of IMS data feeds using Fuzzy methods in c# and analytical functionality to do slicing and dicing of data.
Astellas - Developed an intelligent reporting and analysis mechanism on ILink Healthcare software.
This would help driving decisions in preventive care, health plans, providers, physician practices, clinics, hospice facilities and ancillary care providers.
Technology enablers include Business Intelligence (BI) suite, Microsoft Health Vault, Executive dashboards using Office Business Applications (OBA), SharePoint, Service Oriented Architecture (SOA), Electronic Medical Records (EMR), Change Capture, Outcome Analysis tools, HIPAA compliance and consulting, BizTalk HL7 Accelerator, Automated Clinical Forms and Medical Device Interface System.
IT executive responsible for the overall status of information systems and technology solutions, applications development, project planning, budgeting and operations.
Lead and mentor a team of 20 people offshore and onsite and help executing multiple projects at the same time.
Leadership and Offshore development: Spearheaded strict business case and project approval methodology resulting in $20M projects delivered on schedule 42% under assigned budget.
Revenue Generation / Process Improvement: Raised revenue of 10 million over a period of 3 years by independently developing and prototyping products for various high profile clients like Meryl Lynch, Boeing, Bank of America etc.
Interfaces / Integration: Worked with leading research organizations like Xerox PARC and Xerox Europe Research center to incorporate some of their research products into Xerox Service based model.
Education
Courses in Statistics and Data Mining.
Citizen of United States of America: , Expected in 2011 - - , GPA:
Bachelor Of Technology: Computer Engineering, Expected in 1999 - National Institute of Technology - Hamirpur, GPA: NIT’s formerly REC’s are one of the top Engineering Schools in
Accomplishments
Used Patterns and Practices, Patterns, Agile Modeling, Microsoft Solutions Framework and Rational Unified Process.
Initiative: Sparks new initiatives that provide cumulative positive effect and builds morale along the way; eventually reduces operational costs through transparency and consensus.
Metrics Driven: Ability to establish governance models for implementing the change by using clear metrics, resources, financials, consensus, and political realities.
Cross-disciplined: Knowledge of information, application, technology, and business architectures.
Ability to work with stakeholders and bring consensus across.
Data Modeling: Transactional (OLTP), Data Warehouse and Data Mart (OLAP) schema design and construction.
Data Hygiene: Implementation of Metadata Repositories, Maintaining Data Quality, Data profiling, Data Cleanup procedures, Data Standards and Data Governance program using various platforms like SQL Server, Oracle, Netezza and Vertica.
Data Integration: Design and tune ETL mappings and sessions, code and document scripts, autosys jobs for data warehouse processes using SSIS, Informatica, DMXPress.
Data Analysis: Dimensional modeling, Star schemas and Cubes development using SSAS and Cognos.
Performance optimization, Hardware tuning and clustering of cubes.
Database Performance: Monitor, tune and analyze db performance and allocate server resources to achieve optimum db performance.
Reporting solutions: General reporting methodologies like bursting, Cross tabs, charts, metadata, drill-downs/ through and cubes with tools like SSRS, Proclarity, Cognos, Sharepoint , Microstrategy, Performance Point and QlickView.
Dashboard Solutions: Dashboard reporting and current business methodologies including Balanced Scorecard, KPI definition and ISO implementation.
Quantitative Solutions: Combining Statistics, Financial and economic modeling techniques to provide data-driven analytical services for a range of business challenges using tools like SAS and SPSS.
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
resume Strength
Formatting
Personalization
Strong Summary
Target Job
Resume Overview
School Attended
National Institute of Technology
Job Titles Held:
Principal Analytics Engineer Architect
Senior Data Warehouse Manager and Architect: Turbine
Data Warehouse Architect and Consultant
Implementation Manager, Application Architect
Degrees
Courses in Statistics and Data Mining.
Citizen of United States of America
