Candidates About

 

 Nilesh Doshi

OBJECTIVE

To obtain a position where I can effectively put into practice my acquired skills and practical experience and build an enterprise wide business intelligence solution to support better decision making

 

SUMMARY

Business Intelligence Solutions architect adept at designing and implementing effective technical business solutions. Advanced levels of technical knowledge and extensive industry experience, combined with sound business vision and project management skills. Exceptional problem-solving, written and verbal communication skills, with broad understanding of technology, business and industries to provide exceptional value.

·         Business Intelligence & Data Warehousing Leader with 20 years of IT industry experience

·         Proficient at delivering complete end-to-end BI Solutions using Agile & Waterfall methodologies

·         Expertise in Dimensional modelling, Data Warehousing, Data Integration & Data Analytics

·         Experience in Finance, Mortgage, Travel, Technology Development, Non-profit, Health Care, Education, Retail & Advertising industries 

 

EDUCATION

·         M.S., Information Systems (Computer Management), University of Pune, India, 2001

·         GNIIT, Associate diploma IT, National Institute of Information Technology, India, 2000

 

CERTIFICATION

·         Microstrategy Certified Developer (MCD), 2013

·         Microstrategy Certified Engineering Principal (MCEP), 2006

·         Microstrategy Certified Narrowcast Developer (CND), 2006

 

TECHINICAL PROFICIENCES

·         Business Intelligence: Microstrategy, Tableau, Looker, Periscope, Pentaho

Specialize in Microstrategy product suite with roles - Architect, Advanced Reporting, Mobile, Dashboard Developer, Administrator, Scripting, Deployments & Performance Tuning

·         Data Integration & ETL: Informatica, Matillion, Talend, Pentaho

·         Data Modeling: Star/Snowflake using Erwin, ER Studio

·         Databases: Paraccel/Action Matrix, Oracle, DB2, Teradata, Netezza, MS SQL Server, Amazon Redshift, IBM Dashdb, PostgreSQL, DynamoDB, Sybase

·         CRM & LMS: Salesforce & Cornerstone for Salesforce platform

·         Web & Application Development: ASP .NET, J2EE, C/C++, Cold Fusion, PHP, HTML, Java scripting

 

PROFESSIONAL EXPERIENCE

 

BlueAlly Inc, Mclean VA Mar 2013 - Dec 2017

Role: Principal BI Solutions Architect | Client: Freddie Mac

 

As a principal BI solutions architect since inception lead Freddie Mac’s Data Analytics Division on SPP, Manager Series and Alchemy, a new BI platform designed for Data Analytics team that allows Servicing Division's power users and business users the flexibility of Ad hoc analytics and reporting on performance data at any level summary or lowest grain. The platforms use of Multisource to create a federated data layer, Intelligent Cubes built and refreshed incrementally, and its reliance on Visual Insight for analysis makes it a unique and customer centric experience

 

Key Achievements:

·         Principal BI Solutions architect for SPP & Manager Series an externally available application for servicers and a rich internally available data analytics environment capable of providing ad hoc reporting, analytics and data discovery

·         Principal BI Solutions architect for Alchemy a BI platform from ground-up, allowing for transitional data analytics, and telling a story-line on the movement of data forward or backward in history, across customizable intervals and at every possible drill level summary, detail or in between. This architecture visually exhibits the movement / walk based on any related attribute or dimensions across several time periods and allowed for unique data visualizations

·         Build a Suite of Metrics Libraries that show Inflows, Outflows, Stays and Inventories sliced by various dimensions for operational reporting. Extended the data analytics capabilities by developing an event-based architecture. This architecture captures snapshot of information at any monumental event defined currently and is modular and extendable to events defined in the future

·         Further enhanced the BI platform to facilitate Attribution Analysis and slicing / dicing of data by a series of attributes and dimensions

·         Used Visual Crossing, a third party Visualization Extension that provides integration between Microstrategy platform and Geospatial Map Server to assist with maps and geographic analysis of business data

·         Extensive use of Microstrategy Suite that includes Multisourcing, Datamarts, Level metrics, Intelligent Cubes, Dashboards, Scorecards, Visual Insights, complex Command Manager scripts, Integrity Manager for Baseline to Project SQL, Data comparisons and sanity checks after every release, Object Manager and Packages for several minor and major deployments, assisting and working with administrators in setting up user groups, users, privileges, ACLs, governing and project configuration settings

 

Environment:

BI Reporting: Microstrategy, SAS | Data warehouse: DB2, Paraccel/Matrix, MS SQL Server, Oracle | ETL: Informatica, Talend

 

Upside Travel, Washington, DC Mar 2017 – Jul 2017

Role: Data Architect - Data Engineering / Management

 

Worked for Upside’s Data Engineering and Data Management team which designs, implements, and supports the OLTP app database, the ETL data streams, and data lake/data warehouse.  We ingest, store, and analyze ~3.5TB of new raw air/hotel inventory per day for use with our travel decision engine.  Along with the inventory data we collect marketing data, web app data, mobile data, and log data from multiple internal and external sources.  We then integrate all this data into an easily accessible data platform for analytics.

 

Key Achievements:

·         Designed and built Upside’s data warehouse first utilizing AWS Redshift and then expanding into a data lake / warehouse model utilizing AWS S3 Parquet files with Athena and Spectrum on top.  This data lake is the platform for all data needs from basic BI, to our advanced analytics

·         Utilize AWS Kinesis/Firehose for transporting our near real-time data sources

·         Use a combination of Matillion, and Python for data ETL into and out of the data lake.

·         Built a dimensionally modeled layer in the data warehouse for use with our main BI tools, Looker, Periscope, and Tableau.

 

Environment:

BI Reporting: Tableau, Looker, Periscope | Data warehouse: Amazon Redshift, Snowflake | ETL: Matillion

 

Irvine Technology Corporation, Rockville MD Aug 2008 – Mar 2013

AllSourcePPS, Rockville MD Jul 2015 - Sep 2015

Role: Principal Business Intelligence & Data Warehousing Architect | Client: AARP

 

At AARP, a leading non-profit organization played an active role in transforming the analytics capabilities from a single rudimentary application into a world class enterprise system that has been recognized with numerous internal and external best practices awards and accolades.

 

As an enterprise data architect facilitated and build a BI reporting environment and a structured data warehouse for volunteer management and information system. Volunteer management system was being transformed from a legacy Java application into a Customer Relationship Management system using Salesforce and Learning Management System Cornerstone for Salesforce platform.

 

Project(s): Email Reporting, Hard Card Transactions, Contact Center, Direct Mail Effort Based Reporting, Campaign Marketing for Acquisitions, Membership, Communication, Advertising Sales, Finance, Human Resources, Mail and Print Services Dashboard, CIO Dashboard, Volunteer Management BI

 

Key Achievements:

·         Design and develop several projects and integrated them into the core enterprise-wide Data Warehouse and Business Intelligence Solution. Ensure compatibility of new modules to the core design, objects & reports

·         Designed several Type 2 dimensions and modeled it for ad hoc reporting capabilities

·         Instrumental contribution in each phase of BI to provide complete end-to-end BI solutions

·         Authored ETL Specifications, and assisted in developing ETL mappings in Informatica

·         Dimensional Modeling, Building Schema Objects (Attributes, Facts & Hierarchies) using Architect

·         Building Application Objects (Metrics, Prompts, Filters, Custom Groups, Consolidations and Reporting)

·         Building Intelligent Cubes, Documents & Dynamic Dashboards

·         Building Visual Insight Analytics & Microstrategy Mobile compatible Reports and Dashboard

·         Demonstrating BI Capabilities, End User Training and Support for Advance Web Professional Users

·         Created and analyzed Enterprise Manager Reports to report usage, prompt selections by users, frequently executed reports to advice any performance enhancements like creation of cubes

 

Awards:

·         ITS Transformation Spirit Award, an internal IT departmental team award nominated by business for transforming the reporting environment and providing ad hoc reporting BI capabilities

·         Microstrategy Dashboard Competition Awards (2010 and 2012)

 

Environment:

BI Reporting: Microstrategy v9.x, 8.x | Data warehouse: Appliance Netezza (IBM), Oracle, DB2, MS SQL Server and several structured text/CSV/Excel/delimited flat files | Modeling: ER Studio, Visio | ETL: Informatica PowerCenter 9.x/8.x/7.1 and PowerExchange 9.x/8.x | CRM Salesforce & LMS Cornerstone for Salesforce platform)

 

 

IMC, Inc. Jan 2005 – Aug 2008, Reston VA

Role: Technical Lead Consultant | Client:  National Institute on Drug Abuse (NIDA)

 

Project(s): Small Business Innovative Research (SBIR) Engagement and Executive Information System (EIS)

 

At IMC, a leading IT consulting company, worked as a Lead Consultant in developing Business Intelligence Solutions for SBIR and EIS. NIDA supports research to identify the genes, how they are expressed, and how that expression influenced by environmental factors creates an “addiction phenotype.” SBIR Engagement involved Analysis Modules written as multiple JAVA processes making API calls to Bio conductor packages and R Project; and EIS was developed as a customized solution integrating R Analysis results with Microstrategy’s web-based decision support system

 

Key Achievements:

·         Requirements gathering, documentation, analysis, defining ETL Specifications, Data Modeling

·         Design, develop and implemented Business Intelligence (BI) systems in business areas of Clinical Trials, Safety, Efficacy and Finance

·         Design and implement dimensional model for data warehousing

·         Project planning and management, mentoring, status reporting, architectural design, development, implementation and technical documentation.

·         Design and develop Microstrategy objects, reports, dashboards, documents and end-user applications for the Executive Information System (EIS) in all the five business areas (CTSM, Enrollment, Safety, Efficacy and Financial Data Mart - FDM).

·         Performing major Microstrategy upgrades from 7.2.4 to 8.0.1

·         Replicated customization and maintained development, test and production environments.

·         Testing and validating source system data to the data warehouse data.

·         Created Microstrategy Configuration, Schema and Application objects including advance metrics, complex reports, Intelligent Cubes, Report Service Documents and Flash/Flex-based Dashboards. 

·         Develop ad hoc interfaces.

·         Utilize various Microstrategy reporting tools to deliver insights to targeted audiences (e.g., Narrowcast, Web Reporter, Web Analyst, Web Professional, Report Services, and Portal SDK).

·         Developed web application CFML, HTML, XML, XSL and Java scripting, ASP, ASP .NET, Java, JSP

 

Environment:

BI Reporting: Microstrategy v8, 7 | Data warehouse: Oracle |Source System: Oracle, SQL Server and several structured text/CSV/Excel/delimited flat files | Modeling: Embarcadero ER Studio v9, 8, Visio

 

IMC, Inc. Jun 2001 – Dec 2004 Reston, VA & McLean, VA

Role: Senior Developer | Clients: National Institute on Drug Abuse (NIDA), 2 Leading National Banks and private sector companies

 

Project(s): CTPS, SAETRS, Web solutions for leading banks and private sector companies

 

At IMC, a leading IT consulting company, worked as a Senior Developer in providing several web based application development solutions. CTPS is a web application used to track relevant information about NIDA-sponsored clinical research projects. Through CTPS, information about NIDA clinical projects and studies is available to help them manage their research portfolio and to respond to requests for information about drug abuse research in clinical settings. Serious Adverse Event Tracking and Reporting System (SAETRS) provides Principal Investigators, Study Coordinators, Site Directors, Medical Monitors and NIDA personnel a tool to document, track, and report serious adverse events that occur in any NIDA-sponsored clinical study.

 

Other applications included web solution for leading banks, private sector companies, Bug Tracking System, Submission Setup and XML Generation applications for data load processes.

 

Responsibilities: Provided analysis, design, development, testing, implementation and support. CTPS underwent major releases during this time. CTPS team used RUP design with Rational tool suite. Participated in designing v3.0 data model, as well as training peers on this model. Redesigned SAETRS data model and developed the application. Responsible for all CTPS activities related to sending study data to National Library of Medicine (NLM) and acted as a liaison for any data or technical issues. Also responsible for CTPS release and testing when the application was undergoing maintenance, and introduced periodic service packs

 

Intrinsic Management Consultant, Pvt. Ltd. Pune, India Aug 1998 to Jun 2001

Role: Project Leader, Senior Developer, Programmer Analyst.

Project(s): India Properties, eGreenCoffee

Responsibilities: Managed a series of development and managerial tasks in support of developing e -commerce web solutions.  These applications included communication with proprietary systems, authentication, personalization, scalability and user-friendly interface modules. These applications were developed using Java, VB and C++. Used scripting languages like ASP, JSP, ColdFusion, Java scripting, HTML, DHTML, CSS, XML and XSL. The back-ends include Oracle, Sybase, and Microsoft SQL Server

 

Drishti Computer Services Mumbai, India May 1998 to Aug 1998

Role: Programmer Analyst

Responsibilities: Worked on creating an intranet application for a client using HTML, JavaScript and Active Server Pages. Created graphics as part of web designing for the same application

 

TRAINING

·         Essentials of Project Management, 2008

·         Microstrategy Advanced Administration and Narrowcast Development, 2006

·         Microstrategy Core and Advance Courses, 2005-2006

·         Microstrategy Web SDK, 2005-2006

·         Microsoft .NET, 2004

·         Learning Java, 2000