SUMMARY:

A highly proven technology professional with 10+ years of IT experience delivering Solution Architecture for the complete lifecycle of high-availability Business Intelligence projects.

Expertise with Dimensional Data Modeling (Star /Snowflake), Data Warehousing, ETL (Extract, Transform and Loading), Data & Analytics Solutions using MicroStrategy2021, Kyvos & Google BigQuery

Expertise with MicroStrategy Architect to create re-usable schematic layer and multi-sourcing to combine data from disparate sources including Big Data. Expertise with Reports, Documents, Dashboards/Dossiers following industry best practices for Visualizations.

Expertise with MicroStrategy Command Manager, Object Manager, Integrity Manager, Transactional Services, Distribution Services, Systems Manager, Enterprise Manager.

Installation and Configuration of Intelligence/Web/Mobile Server & clustering of nodes.

Experience in leading groups of on-site and off-shore resources

Experience in Google Cloud Platform (GCP), Amazon Web Services (AWS) and VMware

Experience working in industries - Retail, Healthcare/ Pharma, Banking, Finance, Payment, Insurance, Risk Management, Telecom (Wireless), Transportation, Manufacturing.

EDUCATION: B.S. Computer Science & Engineering Bharathiar University, Tamil Nadu, India

CERTIFICATION: MicroStrategy Certified (Platinum)

1. Project Designer, 2. Document Developer, 3. Report Developer

SKILLS:

BI Tools: MicroStrategy2021, Kyvos, SAP Business Objects, Crystal Reports, IBM Cognos

Software: Google BigQuery, Oracle12C/11g, PL/SQL, SQL Plus, Microsoft SQL Server, Teradata,

SSIS, TOAD, ERwin 3.5/4.0, Python, Java, JDBC, ISS, Tomcat, JBoss

OS: RedHat/SUSE Linux, AIX, HP-UX, Windows Server, iOS, and Android

EXPERIENCE:

02/18 – 02/23 - Global Payments Inc., Atlanta GA

Senior Architect - Business Intelligence – Worldwide Data Analytics Architecture

As a Senior BI/Solution Architect, responsible for solution design for Worldwide FP&A Reporting Data Warehouse using Merchants Billing data to provide world class Data & Analytics solution using MicroStrategy, Kyvos & Google BigQuery on Google Cloud Platform (GCP). This includes Self-Service capability, reporting and data visualization; ensuring scalability, performance and availability of data for hundreds of Finance/Accounts/Marketing/Sales users in North America, Latin America, Europe, Asia-Pacific, and Oceania.

Designed the Conceptual, Logical, and Physical Data Models for the Worldwide Data Warehouse.

Architected and implemented very large-scale data warehouse solution to analyze billions of billing records of merchants at card type/charge type level transactions spanning 60 months

Designed ETL architecture and implemented working with on-site/off-shore resources, using Google BigQuery SQL to retrieve data from over 25 countries and 20+ data sources.

Streamlined data gathering process which greatly improved speed (over 300% improvement) and reliability of revenue data matching the General Ledger.

Architected and developed semantic layer infrastructure to support complicated business logics using MicroStrategy by creating attributes, facts, logical views, hierarchies and transformations.

Created hundreds of metrics both medium and complex, advanced metrics such as Level and Transformation metrics. Created multiple Intelligence Cubes with > 600 million rows.

Designed and developed Same Store, New Store and Attrition (aka) Worldwide Net Growth Index dataset/Dashboard allowing users to view Worldwide Sales/Returns volume & transactions, merchant counts, and revenue in local currency and USD by Geographic region, country, Data source, MCC, and Sales channel.

02/13 – 08/17 MicroStrategy Services Corp., Tysons Corner, VA

Senior Consultant - Professional Services, Atlanta GA

MicroStrategy Services Corp., works with businesses and help them unleash the value of Business Analytics and Mobility platform in ways that empower decision makers. As a Sr. Consultant, provided complete BI consulting services based on the MicroStrategy platform to clients including fortune 500 companies. Served in various leading roles such as Project Lead/Manager, Administrator, Architect, Data Analyst, Data Modeler, Report/Dossier/Dashboard/Document designer in Web and Mobile using iOS and Android devices.

Major Client List

USPS-United States Postal Service (Apr 2016 – Aug 2017)– Assisted in upgrade from MicroStrategy 10.2 to 10.4. Assisted in connectivity to BigData HDFS using Hortonworks HDP drivers for both DSN-less and DSN mode. Assisted in Data Visualizations using ESRI maps.

HCA-Hospital Corporation of America (Apr 2016 – Aug 2017)– Assisted in upgrade from MicroStrategy 10.1 to 10.4. Configured Enterprise Managers. Assisted in Mobile configuration and deployment using MDM infrastructure tool Air Watch. Assisted implementing of Single Sign-on SSO.

AT&T Services (Aug 2015-Mar 2016)

Installed and Configured 7 Intelligent Servers (clustered) in Dev/QA/Prod Linux environment

Deployed and configured 6 MSTR Web/3 MSTR Mobile Servers in Tomcat/Linux

Deployed and configured 16 Health/2 Master Health Agents and 2 Operations Manager

Architected and developed Schema based on Entity-Attribute-Value (EAV) Data Model using Oracle Database. Configured clusterCache and clusterCube directories

Developed datasets and Dashboard required for Production View.

Walter Reed Cancer Center (Jul 2015)- Design and Development of Mobile app for Cancer Patients Survey. Development of a web document for the doctors to view the results and recommend patients with resources in multi-media, video, podcast etc.

Developed and configured Transactional Report using Transactional Services to capture Patient’s Survey utilizing MSTR system prompt Mobile ID in iOS devices especially iPad

Created SQL Server Stored Procedures for inserting/updating data captured from the Survey

Developed Web/Mobile documents for the doctor/ the patient to view the results of the survey

Created work around to show bars in graph different colors based on the threshold levels

Created a complex SQL Server view to calculate mean, standard deviation from the Survey results for each patient.

KOHLS (May 2014-Jun 2015)– Design and Develop KOHLS’ Store Dashboard that would be used by the KOHLS’ Store, District, Region, and Territory Manager to view sales, service, credit, rewards, operations, Sales, and Payroll Forecasting of over 1200+ stores on daily basis.

As a Technical Project Lead/BI Architect for KOHL’S Store Dashboard project, responsible for Store Dashboard Architecture and requirements gathering. Coordination with GDC resources.

Developed Schema including 2000+ metrics, and 300+ Attributes, filters and prompts. Developed 30+ Intelligent Cubes to support the Store Dashboard project using MSTR 9.4.1.

Designed and developed custom security module involving LDAP system prompts. Security +1/+2 models to provide details to Store, District, Region, and Territory Managers.

Snyder’s Lance (Apr 2014) - Designed and Developed 32 Web documents/datasets to support Snyder’s Lance project for Sales Team.

Domtar (Mar 2014-Apr 2014)- Designed and Developed pixel perfect Reports and dashboards for Domtar Finance Group. Coordinated with GDC resources

Sears Holdings (Mar 2014) – Designed and Developed Web documents for emokSHA project

Bank of America (Jan 2014-Mar 2014) - MSTR Report Services documents from the existing Business Objects Reports to MicroStrategy 9.3.1. for the Risk Technology group.

Data model for the redesigned project. Created Metrics, filters, and prompts for the reports.

Developed documents (RSD), improved performance of reports by modifying the DB views

Exelon/Constellation Energy (Dec 2013) - Developed dashboards and assisted in implementing the project in Prod environment for Energy Sales Group in MSTR v9.3.0.

Ryder (Dec 2013) - Designed and Developed documents (RSD) MSTR 9.3.1 for FleetCar Project

Gentiva Health Services (May 2013-Nov 2013)

Responsible for complete Schema development in MicroStrategy 9.3.1 in cloud to support Gentiva BI Project for Gentiva’s Home Health and Hospice divisions.

Created 1500+ schema objects (attributes, transformations) and metrics. Created Intelligent cubes for daily/weekly/monthly/yearly Actual and Budget Financial and Clinical information.

Designed and developed monthly/yearly dashboards with previous and future 3 months/years along with the current information

Premier Inc., (Apr 2013-May2013) – Upgraded to 9.3.1 and Configured 2 Intelligent Servers (clustered). Deployed and configured 2 MSTR Web/1 MSTR Mobile Servers in JBoss/Linux

BCD Travels (Mar 2013- Apr 2013) – Architected and developed schema including 500+ Metrics to support BI Post & Pre-trips. Created Intelligent cubes, Storyboarding and dashboards. Designed Internationalization of data/metadata to support languages other than English

Carter’s (Feb 2013)- Participated in MicroStrategy Mobile QuickStrike and assisted Storyboarding and Planning process. Worked on Map widget using Google maps with the given latitudes and longitudes of Carter’s stores

08/08 – 02/13 Crawford and Company, Atlanta, GA

Sr. Software Engineer - Data Warehouse & BI Tech Lead

RiskTech: Claims Management System, which helps process, to manage and analyze claims and track incidents. It provides Workers Compensation, Auto, General Liability Claims and Medical and field case management.

Led Claims Reporting project and worked closely with Program Managers/business analysts.

Designed and developed Universes including creating Stored Procedure Universe.

Designed and developed complex reports using WebI and Crystal Reports 2008.

Created Business Views, LOVs, and Dynamic Cascading prompts and Dynamic Data Connections using Business View Manager (BVM) for Crystal Reports.

Created Data model using ER win for the Data Warehouse and Data Marts

Wrote Oracle PL/SQL Packages, Functions, and Stored Procedures for data loading.

Worked with offshore development/QA team for delivery of the UI Interface

Environment: SAP Business Objects XI3.1, Crystal Reports 2008, IBM Cognos10, SSIS, Tomcat, Oracle 11g, PL/SQL

08/04 – 07/08 ALLTEL CORP, Alpharetta, GA

Technical Lead – Data Warehouse Consultant

As Technical Lead, led BI project to support Data Warehouse project using data from VIRTUOSO II customer’s call details. Developed Asyncs for VII batch processing using C, Pro*C and wrote Oracle Packages, Functions, and Stored Procedures using SunOS 5.9, Oracle 10g, PL/SQL, SQL Plus, Pro*C & C. Wrote UNIX shell scripts for VII Onlines, Batch processing and scheduling. Coordinated Onsite/Offsite project teams and assisted the team members.

11/03 – 07/04

CERTEGY INC., St. Petersburg, FL

Sr. Systems Consultant

As Sr Systems Consultant, developed multi-threaded C and Pro*C programs involving TCP and UDP sockets for Fraud Case Prevention application. Created Advanced Queuing (AQ) using DBMS_AQ, DBMS_AQADM packages; processed XML messages using the Oracle standard DBMS_XMLDOM, DBMS_XMLPARSER packages using tru64, Oracle 9i, PL/SQL, Pro*C/C++ & C

10/00 – 09/03 Johnson & Johnson Vision Care Inc., Jacksonville, FL

Sr. Systems Consultant

As Sr. Systems Consultant/Tech Lead, designed, developed and supported interface programs using UDP sockets in C, ESQL/C and Pro*C for Shop Floor System (PDI). Wrote UNIX shell scripts and scheduled Cron jobs. Developed Oracle Packages, Functions, Stored Procedures, and Triggers

using SunOS 5.5.1, HP-UX, Informix 5.1, Crystal Reports XI, Oracle 9i, PL/SQL, ESQL/C, Pro*C & C

07/98 – 09/00 NEXGENIX INC., Jacksonville, FL

Major Client List

Filmson.COM, Santa Monica, CA (Mar 2000–Sep 2000) - As Senior Associate/Tech Lead responsible for Data Modelling, development of Web pages, Packages, Stored Procedures for Filmson.com, using Oracle8i 8.1.7, Erwin 3.5/4.0, Oracle Intermedia, PL/SQL, Vignette StoryServer5

Health First Inc., Melbourne, FL (Jan 2000–Feb 2000) - Installed, configured and implemented Interwoven TeamSite 4.0 for Health First’s Intranet

H&R Block, New York, NY (Oct 1999–Dec 1999) - Installed, configured and implemented Interwoven TeamSite 4.0

Johnson & Johnson Vision Care Inc., Jacksonville, FL (Jul 1998 – Sep 1999)

As Senior Consultant/Tech Lead, redesigned Database from HP–Allbase to Oracle7 using Erwin 3.5/4.0 for PDI from CIM. Created Packages, Functions, Procedures & Triggers. Developed Forms and Reports in Oracle. Developed interface programs to support communication between Host and Client systems using UDP sockets in C, Pro*C and ESQL/C. Wrote UNIX shell scripts and scheduled Cron jobs using

SCO UNIX R3.2, SunOS 5.5.1, HP-UX, Oracle 7.3.4, PL/SQL, Developer/2000, ESQL/C, Pro*C & C

CSX TRANSPORTATION INC., Jacksonville, FL (Apr 1998–Jun 1998) -As Data Warehouse Consultant developed various scripts for ETL process in PL/SQL and reports using Crystal Reports from DSISYS, an existing Oracle Data Warehouse which was used by Sales and Marketing departments using Oracle 7.3, PL/SQL, SQL Plus, Crystal Reports5, SunOS 5.5

OLSTEN HEALTH SERVICES, Dallas Fort Worth, TX (Aug 1997 – Mar 1998) - As a Software Consultant, Designed and developed various Reports using Crystal Reports. Wrote Packages, Stored Procedures, Functions, and Triggers using Oracle 7.3, PL/SQL, SQL Plus, Crystal Reports5

07/96 – 05/97 TOMAX TECHNOLOGIES INC., Salt Lake City, UT

Software Consultant

As a Software Consultant, designed and developed various Forms and Reports for different modules, wrote Packages, Stored Procedures, Functions for Retail.Net using Oracle 7.3, Developer/2000, PL/SQL, HTML, JavaScript, SCO UNIX, AIX

11/94 – 06/96 PRAGATI COMPUTERS PVT. LTD., Chennai, TN, India

Programmer/Analyst

Responsible for design and development of data entry screens & reports for financial and transport Benefit Fund and Transport companies using Oracle 7.1, Forms 4.0, ReportWriter 2.2 and PL/SQL.

06/93 – 11/94 AEGIS SYSTEMS, Coimbatore, TN, India

Trainee/Programmer

Responsible for design and development of data entry screens for Banking System, an in-house package using Oracle 7.0, Forms and ReportWriter

Contact this candidate