Ramakrishna Higher secondary School

Bangalore University

Chief Architect at Bizstats.AI

San Jose, California, United States

End to End Product Architecture , design , development , automation , micro-services, define data science/ML/AI use cases -> Solutions.
Introducing new product Bizstats.AI - DWS ( Data Warehouse Searchable) <a href="https://www.bizstats.ai/product/data_warehouse_searchable.html">https://www.bizstats.ai/product/data_warehouse_searchable.html</a>

Bizstats.AI

Chief Architect

Designed & oversee development of Absolut-e BizStats AI Data Analytics platform, web-based (SaaS) decision support system (DSS) to get quick answers for the Business questions and KPIs by integrating internal and external data of structured and unstructured data, sourced from social media, public data, and competitor’s data using Big Data by applying statistical modeling to represent as information.
Architected and designed Big Data and KPIs as API solution, Big Data API solutions provide real time notifications for major events, important KPI impacts that helps to identify business opportunities and monetize analytics.
Defined ML/AI Business cases, use cases, Architected & designed data, cloud infrastructure and ML models by selecting appropriate ML algorithms to train and apply to real data to retrain as continues learning to the model. data preparation, data processing, Proper future extractions and improving model accuracy.
Collected requirements & defined efficient business Process model to easy implementations and design of adoptable EDW for different industries & clients.
-  Streamline the Development process & preparing Standards for SDLC of data warehouse implementation with Bigdata arena Hadoop, MapReduce, HDFS , HBase , HIVE ,NoSQL databases [Mongo DB , Cassendra], Cloudera Impala real time queries , PIG HL Language, Sqoop RDBMS data importer, Oozie workflow, Apache Solr, Flume distributed data collector,Apache Storm realtime process engine
- Integration of Multiple ERP Systems SAP ERP, PeopleSoft, JD Edwards, Oracle ERP Applications R12 Supply Chain, Advanced Pricing & Sales Force CRM.
Environment: Hadoop , HDFS, Hbase, HIVE,PIG, R, Python,Sqoop,Oozie, Storm, MongoDB, Cassendra, MySQL, ERWin , Google pub-sub, Google cloud store, Google bigquery, Google ML engine, Google dataflow, Google cloud storage, Google Dataproc, Redis,solr, Kubernetes,Docker, SAP ERP,Oracle-apps, Sales Force, External APIs, ML / AI engines.

Absolut-e Data Com

Founder & Chief Architect

Content Analytics , Viewership Analytics , D2Lit , NFL , OTT - Architecture & Design
Proof of value of BizStats AI Analytics platform at AT&T - Directv and CDO Solution design & data architecture for projects enterprise payment system (EPS), Single dispatch in the supply chain, Channel to package mapping, Bundles Qualification, D2Lit – EDW, C61K Client – Product introduction to EDW, Set Top box log to Data lake and designed STB log analytics, Made For Web(MFW) through Adobe Analytics to data lake, EDW in Teradata & Vertica, Encryption (FPE & EFPE) for Secure Private Information(SPI) project on to data lake and Teradata , Architected and designed Content Analytics & Viewership Analytics by sourcing 2 PB of log data. Directv-now, NFL-OTT, Vindicia billing data, viewership data designed to provide consolidate insights, Live channel schedule data design to provide view pattern insights, Designed and architect to Support to Chief Data Officer (CDO) data science group etc.

AT&T

Senior Data Architect - Bigdata BI Advanced Analytics

Proof of concept of BizStats AI Analytics platform and as Data Discovery Platform and Designed and developed over all architecture for Project Tahoe in the data access layer to enable dealers and vendors on the selling environment. Apply Data Science to get the meaningful insight from the historical data and real time in coming data from latest inquiry and order data. Provisioned recommendation on the cross selling and up-selling use cases.

VMware

Senior Data Architect

Designed and developed EDW for Supply Chain Management (SCM) subject Area to support demand planning of SAP-ECC, SAP-APO & SAP-BW & TM1. Transactions of Planning, forecasting, work orders, Inventory management, Procurement to maintain optimal quantity in stock, Shipments & reverse logistics.
Master Data management implementation for Hardware Products, Region, Dealer, Fulfil Channel & etc.

Designed and developed EDW for Active Decision Engine for Customer care to enable agents to provide prioritized offers to pitch to customers, capture responses, Customized offers to special customers based on Customer Value Score , measuring Treatments , commitments , credits & additional KPIs.
Master Data management implementation for Agents

Responsibilities:  (BI Solution Designer /DW Architect / Data Architect)
- Analysis and design of SCM Subject Area data modeling & Interface to support data exchanges
- Source System analysis, Analysis & design of ETL Mappings and ETL Specification.
- Analysis and Design of Data warehouse (Logical & physical Model using ERWin) from OLTP System to Accommodate the DSS Business Requirements.
- Design of KPIs & Smart Attributes
- Feedback to OLTP system as Closed Loop Analytics
Environment: SAP, SAP-APO, SAP-BW , TM1, ERWin , Teradata , Oracle,SQLServer,SQL, Informatica, Cognos, QlickView ,SAS, Siebel, Pega Systems , Salesforce

DIRECTV

BI Solution Designer /DW Architect / Data Architect

Designed and developed NextGen Credit Bureau Product POC and defined architecture for NextGen after evaluating the existing open source ETL products and BI products. NextGen Product is planned to implement all over the world.  The architecture focuses on the architecture to drive “develop once and deploy many” concept using metadata driven approach. That includes metadata driven code generation of Data loads, Credit reporting, rules engine components etc.

The Architecture & design have been evaluated by Forrester and provided the feedback of “Excellent Architecture & Design to support core & customization of NextGen Credit Bureau Product to implement all over the world”
By Mike Gualtieri, Senior Analyst [<a href="http://www.forrester.com/rb/analyst/mike_gualtieri">http://www.forrester.com/rb/analyst/mike_gualtieri</a>]

Responsibilities:  (BI/ETL/Data Architect)
- Analysis and design of NextGen Product metadata driven Technical POC
- Defined architecture for the NextGen Product
- Design Strategy on Change Data Capture (CDC), Master Data Management, Process router, handling different input files from different sources etc.
- Design of uninterrupted credit reporting while data is loading in 1000 TPS.

Environment: DB2, SQL, MongoDB, Pentaho (PDI), Linux, rules engine,Java,ERWin,Amazon-EC2,SAS

Experian

BI / ETL- Data Architect

Responsibilities:
- Streamline the Development process & finalized the Extraction Transformation loading process to generic framework using Unix Shell script.
- Requirement analysis and prepared detailed functional specification.
- Source System analysis, Analysis & design of ETL Mappings and ETL Specification.
- Analysis and Design of Datawarehouse (Logical & physical Model using ERWin) from OLTP System to Accommodate the DSS Business Requirement.
- Performance tuning and efficient joins to adopt with the functional requirements and required summarizations
- Workflow of each Reference & transaction information.
- Validation against Primary Factory with new build system.

IMS Health

Sr. EDW Architect / Data Architect

Largest ERP implementation of enterprise One (JD Edwards), responsible for designing Datawarehouse of the Gypsum Division of Sales & Marketing, Manufacturing and Finance Datamarts and manage the Business team, ETL Team & Reports team. The datawarehouse & multiple datamarts are designed for getting decision support reports for VP , directors, sales executives, managers, customer analysis and comparisons of targeted revenue, actual revenue statistics, KPI’s, dashboard HTML reports & Documents.

Lafarge

BI Architect

Information Architect / Enterprise Datawarehouse Architect
Largest ERP implementation of enterprise One (JD Edwards), responsible for designing Datawarehouse of the Gypsum Division of Sales & Marketing, Manufacturing and Finance Datamarts and manage the Business team, ETL Team & Reports team. The datawarehouse & multiple datamarts are designed for getting decision support reports for VP , directors, sales executives, managers, customer analysis and comparisons of targeted revenue, actual revenue statistics, KPI’s, dashboard HTML reports & Documents.

Architect

Largest e-commerce data warehouse eBay has with 15 Tb size. Ebay site has an advertisement tracker by different vendors such as Mediaplex , Double Click , Site Email & Kanna connect. These are all the advertisement used for marketing as well as promoting the ebay products. The datamart is built to the higher level management to analyze and promote the Marketing creatives. Developed a combined datawarehouse to analyze from all of the datamarts with respect to User analyze, Sent email, bounced email by ISP, bounce reason, User age group analyze, Ad impressions, Clicks, Click Thru Rates GMV & the revenue generated by these creatives. Simplify Stores is another Subject area to integrate with the datawarehouse to enable the High level business users to do the analysis on the Store owners, subscription, listings, listings, Rev Rollup based on Country.

eBay Inc

JD Edwards-One World ERP package has all the built in Inventory control, Manufacturing, Sales & Marketing, Order processing system & all the employee details are in people soft (HR management). Combination of both OLTP systems needs to be designed to have data warehouse (OLAP) & data marts.
Environment: Oracle 9i, Informatica ETL tool, MicroStrategy7i, Windows-2000, ER Win, SQL, PL/SQL

Temple Inland

Client: State of Georgia –DHR -USA (ISIS)   Jun-2003 to Aug-2003
ISIS – (Investigative Services Information System) is a system for the DHR- Commissioner, Director, Chief of Investigator to track/analysis/Forecast/trend analysis on the existing cases. Automate ETL process to generate Fraud Alert system from EBT-Citibank data mart based on defined Trafficking patterns and rules and Customers eligibility, benefit & Budget information from SUCCESS System.
Client: State of Florida –AWI -USA (Decision Support System)                                         Oct-2002 to Jun-2003
OSMIS-Data warehouse is a system for the high level users to track/analysis/Forecast/trend analysis. OSMIS Application consists of 6 modules, to integrate all these modules consolidated through data warehouse to make decisions, Forecasting, budgeting and reporting to Federal Government. The Financial module modified and extended to meet additional reporting and data requirements of OSMIS-DSS.

HCL Technologies

System Architect

MP Composer is Configuration management applications to configure the MP Pricer. It Capabilities consist of Item Catalog, Pricing catalog, manageability, segmentation and analysis. Trend analysis, Forecasting, drill down capability across hierarchies (Data Mining) against OLAP.
Web based Intranet solution to do the internal file sharing, Menu level access, creating new menu levels and Customer contact info database maintenance. Those are secured by authentication based on user role and authorization. This project is basically to prove that technology selection , frame work development for the future Product development.

Revenue Technologies

Sr. Software Engg / System Architect

We developed an automated process for the data interaction from mainframe old system to new database system with minimal user interaction by using Unix shell script as core component. It consists of cleaning process by C program, Old to new system mapping with business rules, validations, business process configured through MQ Series Integrator and oracle stored procedure to complete the total System integration. After Population of data to OLTP System, designed ETL Process to load data to the newly created data marts, which is part of Rate Setting 2 Datawarehouse.

Srini Centhala

Srini Centhala