Candidates About

 

Rakesh Gupta

PMP /SCRUM MASTER /TOGAF / AWS SOLUTION ARCHITECT

 PROFILE

IT professional with 20 years of experience in Architecting , Designing and Developing Business Intelligence, ETL , Data Sciences, Data Management and Data Warehousing projects

 in various roles .Consulting and industry experience leading projects for  world’s largest businesses. Lead  and delivered multiple projects for complex and challenging Data Warehousing

ERP ,Business Intelligence , ETL projects within time and budget  using Agile methodologies . 

 

Architected , Designed and setup mission critical infrastructure for high availability and failover Scenarios to support BI , ETL and Data warehousing applications. Led the design and

development of  Enterprise wide shared services for BI ,ETL, Data warehousing , Data Marts and DevOps . Developed strategies for target state BI,Data mart , Data warehousing ,

ETL  and data patterns for the enterprise.

 

In the present role working as Architect and Lead for Business Intelligence Center of Excellence , providing thought leadership and designing , developing and delivering BI, Data mart ,

Data prep , Infrastructure projects and Support . Leading troubleshooting team for any complex production issues across all BI and data preparation tools . Hands on Proof of concepts work

with latest technologies for BI tools , Big data , Cloud and Data prep . Providing recommendations  to the management for future state tools and projects based on customer needs for in-premise,

and on cloud environments . Technical vendor evaluation and financial feasibility of future state tools for BI , Cloud and Data Prep .

 

Prolific trainer, Mentor, coach and frequent Speaker for BI , Data Warehouse , ETL , Data Preparation and Integration.

 

KEY CORE QUALIFICATIONS :

 

·           BUSINESS INTELLIGENCE/ DATA INTEGRATION SPECIALIST

·           COMPLEX DATA WAREHOUSE DESIGNS , BIG DATA LAKE , RELATIONAL / BIG DATA , MPP AND AWS SOURCES (REDSHIFT / S3 / PRESTO/SPARK/ POSTGRESS /NETEZZA)

·           AWS CLOUD ARCHITECTURE , HYBRID CLOUD AND MIGRATIONS  ,  BI / ETL PATTERNS ON CLOUD , EMR , REDSHIFT , PRESTO , KENESIS FIREHOSE

·           BIG DATA  INTEGRATION AND DEVELOPMENT ( HIVE / SPARK / PRESTO/ AVRO/ PARQUET FORMATS)

·           MISSION CRITICAL INFRASTRUCTURE DESIGN AND SETUP FOR HIGH AVAILABILITY FOR BI , DATA PREP AND DW PROJECTS

·           TOOLS - BUSINESS OBJECTS, MICROSTRATEGY, TABLEAU, SPOTFIRE, INFORMATICA, , ALTERYX , THOUGHTSPOT,NARRATIVE SCIENCES

·           INTEGRATIONS WITH SSO (SAML)  / CICD / PAM / MONITORING (DYNATRACE/TIVOLI/NETCOOL) / ELK / MOBILE / AUTOSYS

·           DESIGN , DEVELOPMENT OF SERVICES / INTERFACES USING JAVA / PYTHON/ UNIX SHELL / WINDOWS BATCH /  REST , SOAP  BASED WEB SERVICES  , SPARK

·           RESOLVING COMPLEX PRODUCTION ISSUES  FOR BI / DATA PREP TOOLS PROJECTS  IN THE ENTERPRISE

·           LEAD TEAMS RANGING FROM 5 TO 20  TEAM MEMBERS AND HANDS ON DEVELOPMENT EXPERIENCE WITH VARIOUS LANGUAGES AND TOOLS

 

 

CURRENT TECHNOLOGY FOCUS :  ETL , BI , Data Warehouse solutions in cloud ( Redshift , Glue , QuickSight , BigQuery , EMR ) , Python , Machine Learning  , DevOps Integration

CURRENT PROJECT FOCUS :

·          Costing and Project Evaluation  : Evaluating projects based on costing / Access Patterns , FR and tools for in-premise and on cloud and providing recommendations .

·          Building team for AWS : Mentoring/Coaching and building team for developing / integrating and supporting BI projects in AWS.

·          Architecture  : Architect and Design Data Migration , Ingestion / Data Processing / Data access patterns for AWS / Hybrid cloud and legacy code migration .

·          Vendors Evaluation : Technical  evaluation / costing / customer education and  support for future state tools in premise and on cloud . 

·          BI : Tableau on AWS with single sign on ( ADFS integration ) ,MicroStrategy with beanstalk (Tomcat ) on AWS  , Log file integration with  ELK and Kinesis Firehose,

·          Cloud and Big Data  : S3 integration of  tableau  using Athena and Glue , Tableau - Redshift /Presto/Spark integration ,  Tableau- Redshift tuning , PySpark - Glue / Spark/ spark ETL

·          Machine Learning  - Alteryx - Data Robot / R integration , Tableau /MicroStrategy- Python-ML /R-ML integration 

·          ETL /DW : Redshift using  Glue / s3 , Alteryx , Kinesis Firehose   

·          Data virtualization : Presto /Spark

 

EXPERIENCE:

 

FANNIEMAE USA ( December 2010 – Till Date)

Position: Sr. Architect  - BI Center of Excellence  and  Enterprise Data

 

In this strategic leadership role provided thought leadership to  VP’s. Helped in the creation of Center of Business Intelligence  across FannieMae.

 

Key roles :

Ø  Current Architecture of BI and  Data Prep tools  / Data marts and Data Warehouse design and strategy  

Ø  Future state architecture in AWS cloud and big data patterns , Technologies and Tools

Ø  Development / Scripting in BI tools/API's for Big data / Cloud / DevOps POC's .

Ø  Customer engagements , Presentations , Best practices  and  solving  high priority production issues

Ø  Mentoring / Coaching and Training of  team members and customers

Ø  DevOps / Automation of Enterprise wide Services   

 

Key Accomplishments:

 

·          Developed standards and best practices  for usage of various BI tools to streamline selection ,adoption , development and maintenance of BI projects.

·          Defined, developed and implemented  BI ,Data warehousing and data Mart strategy for target state FannieMae 6 container strategy.

·          Developed best practices for creation of Data Marts and Dimensional Modeling to standardize sources of data for BI tools .

·          Developed  BI usage patterns for tool selection for technical reference models for BI L1/L2/L3 reference Architecture .

·          Managed BI Tools infrastructure  for 24/7 support for Tier 0 customer support  .

·          Designed, developed and delivered BI projects with complete SDLC lifecycle using Agile methodologies  .

·          Vendor management to create maximum value for license deals for fannieMae and  vendor engagement to quickly resolve customer issues .

·          Designed , developed and delivered Data Marts for performance oriented Reporting.

·          Architecture Review Board member representing BICOE for project evaluations and  recommendations.

·          Architected , Designed and implemented FannieMae internal and external facing BI infrastructure for all BI tools with HA and site failover  providing zero downtime.  

·          Architected Proof of concept with technologies  like Hadoop , Single Sign On ,Mobile ,SAML integration  for providing new features and services to customer .

·          Visualization best practices course presentation to the enterprise to propagate  good dashboards and visualization development practices.

·          Led Integration of Tableau/ MicroStrategy with R/SAS to provide analytic capabilities to BI tools .    

·          Led selection of Data preparation and virtualization tool for Enterprise to provide  agile data preparation for consumption with BI tools.

·          Architected CICD integration with BI tools to provide Devops features with BI tools for automated deployments .

·          Led Selection of Alteryx Data Prep tool , best practices and  architecture and  configuration , installation of Alteryx for building data-prep platform from ground-up.

·          Architected Setup of MicroStrategy in cloud using Beanstalk / ec2 and Postgress for migration of MicroStrategy to AWS cloud .

·          architected Setup of Tableau in Cloud using EC2 Servers for migration of Tableau to AWS cloud  .

·          Led Scripting using AWS API's for EC2 servers management  to stop and start EC2 servers  providing large cost savings  on AWS resources .

·          Architected Password Access Management  integration of Tableau and MicroStrategy saving huge man-hours for support and customer teams .

·          Integration of BI tools with Redshift /Hive/Spark/Presto for Big data capabilities from BI tools .

 

 

 

FANNIEMAE USA ( December 2009 – December 2010)

Position:   Solutions Architect   - Infrastructure Solutions 

 

In this role provided leadership in doing proof of concepts for bringing different technology tools, architect the  infrastructure and  work with  management for the  deployments and rollouts of the new tools.

 

 

Key roles :

Ø  Architecture , Installation , configuration and enterprise support of ETL and Reporting Tools ( Informatica Power Center /Informatica Data Quality / Spotfire / MicroStrategy ) 

Ø  Vendor evaluations for ETL tools and BI Tools

Ø  Training customers and team members with the BI/ETL tools

 

Key Accomplishments:

 

·          Selected Informatica data quality tool for fannieMae by doing a POC and vendor evaluations

·          Architected the infrastructure for Informatica data quality Tool and managed its installations and delivery in record time

·          Architected the infrastructure for MicroStrategy tool and successfully rolled it out for enterprise wide usage

·          Architected the Spotfire Infrastructure and successfully rolled it out for Enterprise wide reporting

 

FANNIEMAE USA ( January 2008 – November 2009)

Position:   Senior Support architect and Administrator   -  BI Tools   

 

The department is responsible for installing and maintaining Business Objects Software for all the projects of FannieMae.The project requires Administration of about 50 business Objects Servers and production Support of about 70 projects all over the company.

 

Key Accomplishments:

 

·          Architected, designed, implemented and rolled out of  high availability and contingency BOXI R3 architecture for all the teams with 24/7 support

·          Designed, developed and implemented a Common scheduling software for all the projects across Fannie Mae

·          Designed, developed and implemented   a Corporate Reporting Center web site for all users of Fannie Mae which provides connectivity to all   business Objects Servers

·          Designed ,developed and implemented  automated password change project for all reporting applications  

 

FANNIEMAE USA ( January 2007 – Decemeber 2008)

Position:   Lead   -  SIR  data Warehouse /Data Mart / Reports  

 

The project required design and development of Data warehouse to load data from transaction database .The data warehouse size was 2 TB . The reporting environment included Business Objects Universes for adhoc reporting and Crystal for Batch reporting.

 

Key Accomplishments:

 

·          Lead a team of developers to deliver 70+ reports successfully on time

·          Designed, installed and supported mission critical high redundancy business objects infrastructure

·          Integrated reporting architecture with CM deployment and batch environment using Business Objects API’s using java and web services

 

FANNIEMAE USA ( January 2005 – Decemeber 2006)

Position:   Lead    - Restatement data Warehouse /Data Mart / Reports  

 

The project required design and development of reporting Architecture.

The reporting environment includes Business Objects for adhoc reporting and Crystal for Batch reporting for whole loan and GFAS accounting projects.

 

Key Accomplishments:

 

·          Successfully lead a team of 6 developers and delivered data marts and reports on schedule.

·          Designed and developed Java integration programs for automating the scheduling of reports through Autosys scheduler and deploying reports using Business Objects API’s.

 

FANNIEMAE USA ( January 2002 – Decemeber 2005)

Position:  Reporting Architect   - Core Project    

 

The project was a BI project in business Objects and Actuate . My key deliverables were reporting architecture and administration. Integrating with web, performance tuning, Clustering, Load balancing and fail over design, Weblogic administration

 

Key Accomplishments:

 

·          Designed, developed and implemented reporting architecture for Actuate/Crystal and Business Objects reporting, Cluster configuration, Fail over and load balancing configuration, Performance tuning, Integrating Business objects and Actuate with the web portal of the company using JSP.

·          Integrated BI tools with performance monitoring tools Topaz, sysedge, Tivoli.

·          Prototyped, benchmarked reports and improved report performance   

 

CONSULTING  PROJECTS ( 1998 - 2002 )

 

ELDERHOSTEL USA ( Octobet 2001 – Jun  2002)

Position:   Actuate Developer   

Marriott Hotels Bethesda , MD ,USA ( Jun-2001 – Sep-2002)

Position:   Lead Actuate Reporting 

Concert communications , VA , USA ( Jun- 2000 – Jun-2001)

Position:   Actuate Reporting 

LEHMAN BROTHERS , NY , USA  ( Mar-2000 – Jun-2000)

Position:   Consultant Actuate Reporting 

AYB , MD ,USA   ( Nov-1999 – Mar-2000)

Position:   Lead Reporting  

RMIC , Winston Salem , NC ,USA   ( August -1999 – October-1999)

Position:  Actuate Reporting  

FREDDIE MAC , VA ,USA   ( January -1999 – July-1999)

Position:  Actuate Consultant Reporting  

VWR Scientific products , PA  ,USA   ( Jun -1998 – Dec-1998)

Position:  Actuate Consultant Reporting  

 

BHARAT HEAVY ELECTRICALS LIMITED , INDIA    ( Feb -1988 – Jun-1998)

Position:  Deputy Manager ( Systems)    

System analysis, Design, Development, and testing and implementation. Development of views, stored procedures, forms, reports, transferring legacy data from mainframes with sql-loader, training of users, network installation

 

Key roles :

Ø  Main Frame administrator ( ICL mainframes ) 

Ø  Design / Development of Oracle / ProC / ProCobol / FoxPro based projects .

 

Key Projects :

 

Projects:  Bill of Material system, On-line Inventory System, Production Planning System for CIM ,Library Management System, Purchase Billing System, Book Section JV System,

Work Order Monitoring System, Customer Complaint System, Purchase & Stores of Kasturba Hospital, Inventory Control and Priced Stores Ledger System

 

DEGREE AND PROFESSIONAL CERTIFICATIONS  :

 

·          BACHELOR OF ENGINEERING  (MECHANICAL) , NIT  BHOPAL -1985

·          PMP -- 2008     ( No: 519488 )

·          SCRUM MASTER -- 2010     ( No: 000075896 )

·          SIX SIGMA GREEN BELT -- 2012

·          ITIL FOUNDATION  -- 2014

·          TOGAF -- 2015  ( No : 100820)

·          AWS CERTIFIED SOLUTIONS ARCHITECT ASSOCIATE - 2017  

·          AWS TECHNICAL ESSENTIALS course from Global knowledge

·          ARCHITECTING ON AWS course from Global knowledge

·          MIT -- INTERNET OF THINGS ROADMAP TO A CONNECTED WORLD - 2017