Career profile

678.602.8156 ● jksanjay@gmail.com

Current location: Atlanta, GA

CAREER PROFILE

Mr. Jha is a senior technology architect with Infosys Public Services and has 20+ years of experience in information technology industry. He is specializing in the data warehouse and data management space and provides technology solution leadership to large scale programs Business Intelligence, Data Warehousing, Master Data Management, Enterprise Data Architecture, ERP and Big Data. Mr. Jha has extensive experience in both public sector and commercial business areas. Some of his clients include: Department of Human Services, CareFirst, The Coca Cola Company, Fannie Mae, and Ontario Power Generation. Mr. Jha is an expert in delivering solutions in the IBM, Oracle, Informatica, SAS, and EMC technology stacks. Most recently, Mr. Jha has been focusing on new Big Data technologies like Netezza, Greenplum, Pivotal, Cloudera, and Hadoop. Mr. Jha is currently engaged in a long term assignment with District of Columbia’s Health Benefit Exchange (DC HBX).

• 
  Experience in enabling business transformation through strategic improvements in IT Operations.
  
• 
  Strategic and critical thinker in formulating innovative & long term technological solutions to reduce TCO and improve overall efficiency of business portfolios
  
• 
  Business process Architecture/ Analysis, Engineering plan and related technical roadmap to increase business relevance.
  
• 
  Design (including Data Modeling), development, and implementation of the Enterprise Data Warehouse and Marts. Resource planning for the Enterprise Data Warehouse Architecture team. Led and participated in ETL architecture and design mappings.
  
• 
  Master Data Management including Reference Data Management, and Metadata Management
  
• 
  Works closely with C-level executives to identify their needs, define business requirements, formulates and present viable solutions, and then implement those solutions.
  
• 
  Architecture, Engineering plan and technical roadmap to increase business relevance.
  
• 
  Strong Business Intelligence (BI) Road Map Development, Implementation, and Traceability skills from Business Assessment to Project Planning, Business Analysis, Design/Development to Deployment and Maintenance.
  
• 
  Data Governance - Data Stewardship, Standardization, Lineage and Profiling
  
• 
  Extensive Data Modeling experience in Relational and Dimensional techniques. Created Star schemas to meet BI business objectives.
  
• 
  Exclusively worked with Industry standard ETL tools like Informatica, Ab Initio, SSIS, and Ardent.
  
• 
  Use-case driven requirement management process and required deliverable templates (i.e. BRD, Logical Mapping/DRD, Functional requirement documents and Source System Assessments)
  
• 
  Vendor evaluation for the solutions and products. Prepared RFP and RFQ for vendors.
  
• 
  Over 10 years of experience in team building and management of both onsite and offshore team
  
• 
  At Infosys Public Services recognized as a senior leader in all areas of information management and has published many white papers and has been speaker at technology forums.
  
• 
  Participates in many data management organizations, including: DAMA International, Business Intelligence Professionals, Data Architecture Professionals, MDM Experts, MDM Interest Group, TDWI, Data Quality Association, and Hadoop Hive Group.
  

TECHNICAL EXPERIENCE

Skill	# of Years Used	Date Last Used	Experience Level
Project management	10	2014	Expert
Solution Architecture	5	2014	Expert
Data warehousing	10+	2014	Expert
RDBMS	10+	2014	Expert

SOFTWARE/ PACKAGES/ METHODOLOGY

Database:	ORACLE, DB2/UDB, Teradata, Sybase SQL Anywhere, Multi user and WATCOM SQL, SQL Server 2007, Sybase, IDMS, Netezza
Methodology:	RUP Iterative, SDLC, Use Case driven Requirement Management, Inmon, Kimbal, Entity Relationship Design, and Multi-Dimensional Modeling
Software Packages:	ErWin, System Architect, Oracle Designer, Embarcadero DB Solutions, SAP Business Warehouse, Siebel Analytics, Oracle Universal Customer Master, Informatica Power Center, IBM WebSphere DataStage, QualityStage, ProfileStage, Quest’s SQL Navigator and Toad, Oracle Products, System Architect, Business Objects, Cognos, Brio, Federated Query, IBM Initiate, IBM Big Insights Hadoop

PROFESSIONAL EXPERIENCE

INFOSYS PUBLIC SERVICES 2012-PRESENT

Mr. Jha is Senior Technology Architect within the Infosys Public Services. He manages a team of over 20+ team members. He has sold and delivered business solutions to multiple organizations. Solutions include business consulting, Big Data strategy projects, Big Data implementations, IT transformation projects, Business Intelligence, and Analytics.
Client: DC Health Benefit Exchange, Washington DC Duration: 1.2 Years

The DC HBX is implementation of Affordable Care Act for citizens, small businesses, brokers and insurers of the District of Columbia commissioned in use on Oct 1st 2013. The solution emphasizes standards-based interoperability with external data sources, including federal databases, commercial issuers (using SERFF), public reporting systems, Children’s Health Insurance Program (CHIP), and other Department of Human Services systems.

• 
  Gathered specific BI requirements for system data, KPI definition, trend analysis, forecasting, statistical analysis, and aggregation of eligibility, enrolment and health plan data such as - cost breakdowns per individual, employee (SHOP),employer, Plan data, Individual and employee financial data, Premium and CSR subsidy data, Enrolment data, Enrolee’s demographics
  
• 
  Coordinated between the DWH team and the Business to define report deliverables, issues, questions, needs, trends, and timing
  
• 
  Translated business requirements and expectations to the technical team and manage the requirements traceability to ensure business demands are met.
  
• 
  Designed (data modelling) and define the staging area, extension of DWH, Data Marts for the specific subject area.
  
• 
  Reviewed and generated the Technical Documentation like Source System Analysis, data traceability, Process and Data flow diagrams, Conceptual models, Logical and Physical Data models
  

Technologies: Oracle 11g Databases, SFDC, SoapUI, OSDB, JDeveloper, Informatica, Business Objects, Xcelsius, RHEL 5.5, Data Modeling / Architecture Tools (ERwin 7)
Client: CareFirst, Baltimore, MD Duration: 6 Months

• 
  Architected solutions for enhancement of existing CareFirst BCBS-Patient-Cantered Medical Home (PCMH) solution which attempts to bring down the cost and improve the quality by getting the patient history and quality measure scores.
  
• 
  Worked to design and define the staging area, extension of DWH, Data Marts for the specific subject area.
  

Technologies: Oracle 11g Database, Tibco, Business Objects, RHEL 5.5, Data Modeling / Architecture Tools (ERwin 7)

Intercall Inc., Atlanta, GA 2009 - 2012

Provide guidance to software development teams on the use and purpose of data. Direct a team of ten DBAs/developers/analysts in the daily operations of the corporate data warehouse.

• 
  Data warehouse Architectural Initiative- Achieved first-ever multi-dimensional enterprise-wide financial data warehouse with consolidated data from multiple sales representative’s offices, product management and usage mediation systems enabling timely fact-based decision-making with annualized savings of $2.3 M.
  
• 
  Technical Leadership- Lead a $225,000 initiative to replace an in-house developed Rate Change Management Tool by adding a customized UI in Sales Force (SFDC) as required by Sales Reps using abstraction layers to expose various services integrated with the defined approval workflow logic in BPM. Solution improved audit trail and reduced the rate change time from a week to 2 days with remote flexibility to sales representatives for rate negotiation.
  
• 
  Cost Saving Measures- Replaced Shareplex Replication solution by Oracle’s Transportable Tablespace Solution (TTS) and saved $500,000 on annual license cost.
  

Technologies: Oracle 10g, Oracle 11g Databases, SFDC, SoapUI, OSDB, JDeveloper, Optim, SAP Data Services, Data Federator, Business Objects, Xcelsius, RHEL 5.5, ERwin 7

Schwan’s Food Services, Marshall, MN 2008 – 2009

Plant Maintenance System

Solution Architecture, Requirement Gathering, Project Management

• 
  Managed six-person team to prototype design the SAP Plant Maintenance System for Sanitation Order Types at Schwan’s Salina Location.
  
• 
  The pilot project on completion was expected to serve as template for other bakery plants and the location had potential savings of nearly $200,000 annually in labor and supplies.
  
• 
  Automated material item’s master data transfer from SAP R/3 transaction system to Schwan’s warehouses using Electronic Data Interchange (EDI) allowed Distribution Services to integrate, process and audit freight data from existing and future business units.
  

Technologies: SAP R/3, BW 3.5/BI 7, BEx Analyzer, SAP Plant Maintenance (PM), SAP FI

The Coca Cola Company, Atlanta, GA 2007 - 2008

Transportation Management System (TMS)

Requirement Gathering, Solution Architecture, Client Engagement

• 
  Provided program management leadership and architected solution to replace an aging transportation management, with Order, Billing, Delivery, Shipment and Planning data sourcing from ERP and complex TCCC planning systems.
  
• 
  The model project was the first BI 7 implementation within TCCC with all deliverables in scope, on time, 100% error free resulting in annual savings of nearly $500K.
  

Technologies: SAP R/3, BW 3.5/BI 7, Teradata, BEx Analyzer, SCM, FI, COPA, Business Objects

Fannie Mae, Reston, VA 2005 – 2007

Restatement Project

Release Management, Project Management, Environment Configuration

• 
  Led the Release Management Team of 20+ members to meet the requirements to restate their financial statements for previous 5 years with controlled execution in FAS91, FAS46, SCBSL, Securities and Impairments business areas.
  
• 
  Proactive planning with 24x7 tracking and reporting on progress of controlled code changes reduced the deployment time by nearly 30% and met Sarbanes Oxley compliance by ensuring that designed execution process segregated roles and duties with 100% traceability of login footprints.
  

Technologies: Veritas, Tripware, IBM Rational ClearCase, ClearQuest

Other progressive career growth experiences from 1990-2005

Ontario Power Generation, Canada 2004 - 2005

CGI, Canada 2003

Hydro One, Toronto, Canada 2000 - 2003

Mastech, Montreal, Canada 1997 - 2000

Tata Steel, India 1990 - 1997

EDUCATION

Masters in Business Management (MBA) - XLRI, India

Degree in Mechanical Engineering - BIT Sindri, India
CERTIFICATIONS

Project Management Professional (PMP)

Oracle 9i, 8i and 8 Certified Professional (OCP) – DBA

IBM Certified Advanced Technical Expert - DB2 Data Replication and Database Administration