SANJAY CHAKRAPANI acwezw@r.postjobfree.com

732-***-****

SUMMARY

Over 15+ years IT experience predominantly with large Companies, 7+ Years in Data

Warehousing and2+Yrs. in Big Data Consulting with results oriented driving & delivering

software solutions through continual innovation in techniques, tools & processes. Big Data

opportunity priming & solution conceptualization for true data management.

Proven skills to effectively analyse architect & coordinate execution of solution & strategies

to achieve extraordinary level of software solution that exceeds business objectives.

Understand end-user needs & the need to liaise with stakeholders.

Technically strong hands-on with very positive attitude & passion for excellence

Results-focused / customer oriented

Continuous improvement approach

Extensive technical background

Diagnostic & problem solving skills

Time management & effort prioritization

Communication & Interpersonal skills

Proactive & self-starter

Energetic & adaptive

Common sense / intuitive approach

Ability & willingness to learn

Areas of Expertise

Domain: Telecomm, Healthcare, e-Commerce, Retail & Banking

Architect / Design / Development

Requirement Analysis

Strategic Planning

Big Data Implementation

Continuous learning

Process improvements

Communication

Technical Skills

Linux/Unix, Ubuntu, Windows

Client/Server, Web, SAP, Hadoop

COBOL, Visual Basic, Java, Clipper5.2, SQL, Perl Script, HTML

Agile, V-Model

Informatica, Power Exchange, INFA BDE, Talend

Teradata 14.3, Oracle, MySQL, MS SQL, Server, Mainframe, DB2HBase, Mongo

DB, GreenPlum

Hadoop, Horton Works, YARN, Spark, Hive, Pig, Tableau

Flume, Kafka, Sqoop, Hcatalog, Nagios, HQL, Ambari, Zookeeper & Oozie

ERWIN, VISIO

Microsoft Project, Excel

Share Point

SVN, CVS, TFS

AccuRev, Tidal Job Scheduler, SAP-BW, SAP-SD, MM. HP QC

Platforms

Architecture

Languages

Methodologies

ETL Tools

Databases

Big Data

Page 2 of 9

Data Services

Design & Tools

Project Management

Content Management

Change Management

Other Tools

Page 3 of 9

EXPERIENCE

Well Care, Tampa, FL May 2015 to

Present

Projects: EIM-Data Lake

Role: Architect\ Sr.Big Data Consultant

Responsibilities:

Strategize, Architecture & Implement Solution for Enterprise Big Data on Horton

Work Platform.

Building scalable distributed data solutions using Hive, BDE and Hadoop.

Responsible for Requirement Gathering Analysis and End user Meetings, Designing

executing and updating of Implementation Plan.

Highlights of Accomplishments:

Design and develop Informatica BDE Application and Hive Queries to ingest to

Landing zone and transform the data with business logic from raw to refined zone and

to Green plum data marts for reporting layer for consumption thro Tableau.

Design Enterprise level compliant framework to rely upon all types of Data needs,

Analyse, Source and Parse the data, Replace business tool EMMA with PEGA.

Build and deploy data integration on Hadoop for

PEGA: Care, Appeals & Grievances (CAG)& Medical Management Platform (MMP) Auth

application, Members, Claims& Pharmacy Analytics.

Responsible for Design EDW Application Solutions & deployment, optimizing

processes, definition and implementation of best practices.

Working on Data science Analytics POCs on newer tech Jupyter, SeaBorn, Flink

Environment: Informatica 9.6.1 BDE, Oracle 11i,PLSQL Developer, SQL Server, Green

plum, Attunity, HDP 2.0, Hue, Hive, YARN, HBase, Python, Spark, Ambari, Tableau.

CARESOURCE, Dayton, OH OCT 2014 to May

2015

Projects: Hadoop Implementation

Role: Architect

Responsibilities:

Architect future technology goals & strategy initiative to implement Hadoop.

Technical assessment of current architecture & identify gaps.

Design technical footprint and implementation of Hadoop Data Lake.

Data Integration Tool Assessment of Pentaho, Talend with Informatica BDE

Highlights of Accomplishments:

Designed strategic architectural road map for the enterprise Hadoop Platform.

Envisioned and architected integration framework as the overall solution.

Signoff deliverables from Assessment Phase, Finalize the implementation phase.

Designed Business use cases & documented processes with data flow & diagrams.

Configure HDP 2.2, Security implementation on HDP platform. Configure Hive View

on Ambari.

Environment: Informatica 9.6.1, Teradata 14.11, HDP 2.2, HDFS, Flume, Sqoop, YARN,

Hive, Ambari, Zookeeper & Oozie

Capgemini Dec 2009 to Oct 2014 (5

Years)

Page 4 of 9

T-Mobile, Atlanta, GA Sep 2013 to Oct 2014

Projects: EDW

Role: Architect \ Sr. Consultant

Responsibilities:

Analyse, Source and Parse the web log activity data of my.t-mobile.com, identify

search activity patterns of customers before churn.

Ingest data sets like Customer usage data, event logs, and web logs to HDFS.

Implement system wide data retention and archive strategy.

Responsible for Design EDW Application Solutions & deployment, optimizing

processes, definition and implementation of best practices

Highlights of Accomplishments:

Designed and implemented Hadoop to store high volume data such as billing

Preference and Contact history, Data delivered as batch and stream as well.

Designed and implemented system wide data retention and archive strategy in legacy

EDW system to avert a multimillion dollar expansion in 2013, by saving existing

Teradata system resources.

Decreased the incremental EDW load time by removing and or reorganize EDW load

schedule by Tuning ETL jobs by employing enhanced TD functionality and

techniques

Collaborated with departments and with cross-organizational teams to implement

improvements in processes, Business Support System/Operations Support System

support. Designing, executing and updating of Implementation Plan.

Environment: Informatica 9.1, Teradata 14, Oracle 11i,SQL Server, Perl script, AccuRev,

Remedy, TIBCO CEP,HDP 2.0, Hue, Flume, Sqoop, Hive, Spark, Ambari, Tableau.

Frontier Communications, Raleigh, NC Nov 2012 to Aug 2013

Projects: EDW 2.0

Role: Tech Lead

Responsibilities:

Initiation, Design Re-design enhancement and Development.

Requirement gathering for the Data Control piece of EDW application.

Effort estimation, task allocating and tracking

Keeping track of the new requirements from the project

Mapping the requirements with the test cases in the traceability matrix document.

Highlights of Accomplishments:

Designed and developed data control reports approval from stakeholders.

Architect the ETL flow to capture the record count from the different layers staging,

EDW and Semantic layer to provide a data lineage across the layers.

Standardized testing process & procedures. Enforced processes to enable proactive

involvement in value-added activities for the organization

Developed innovative testing strategies & streamlined process with development

activities to reduce testing redundancy & risks.

Environment: Informatica 9.5.1, Teradata 14, Oracle 11i

Mylan Pharmaceuticals, Chicago, IL & Bangalore Oct 2011 to Aug

2012

Projects: EDW-SAP Integration

Role: Architect

Page 5 of 9

Responsibilities:

Architect the Enterprise EDW to Integrate with SAP.

High-level design document with the new architectural set up.

Requirements into technical solutions. Get signoff and finalize ETL technical design

Highlights of Accomplishments:

Designed & Developed 30+ mappings that extract data for Sales, Returns, Inventory,

Forecast, Contract, and Chargeback from different feeds Internal and external IMS,

Chargeback, Cardinal, McKesson, AHA. Apply business logic & load data to SAP

PSA

Awarded Customer Excellence Project Star Award in Recognition for managing

End to End implementation of the project with Successful client requirements

gathering onsite and with development to implementation.

Environment: Informatica 9.1, SAP BW, Xcelsius, SAP Business Objects 4.0, Bex Queries

Land O'Lakes, Bangalore June2011 to Oct 2011

Projects: Unity BI (Profitability, Sales, Order, Inventory & Purchasing)

Role: Project Lead

Responsibilities:

Lead the delivery of the entire offshore development activity.

Re-Design Framework for Profitability, Sales, Order, and Inventory& Purchasing as

per the business rules.

Lead a team of 4 resources, Allocation, Track and update status to Delivery Manager

Onsite.

Highlights of Accomplishments:

Configure pre-packaged 40+ ETL, SDE and SIL mappings, sessions and workflows

using Oracle-DAC

Configured the DAC execution plans for full and incremental loads.

Awarded Spot Award - Recognition for managing End to End implementation of

project 1 month ahead of timeline.

Environment: Informatica 8.6, Oracle-DAC 10.1.3.4.1, Oracle 11i and OBIEE 10.1

Cox Communication, Bangalore Jan 2011 to May 2011

Projects: KANA Phase 3

Role: Tech Lead

Highlights of Accomplishments:

Implementation of KANA Phase 3 Changes.

Redesigned the Informatica logic to handle the new data flow as per client

requirement to include Metrics stored in the subject areas Feedback, Rating, Content,

Freshness and Search.

Implement complicated business to maintain history of changes to the subject areas.

Developed Mapping, Optimized the mappings written by others and guided team

members to write efficient and optimal code.

Environment: Informatica 8.6.1 & Oracle 11

PRAXAIR, Buffalo, NY &Bangalore Aug 2010 to Dec

2010

Projects: EDW

Role: Architect

Highlights of Accomplishments:

Page 6 of 9

Architect dimensional model for the EDW using Erwin, Created the technical design

document for different business areas.

Architect, designed, developed the POC, incorporating changes recommended,

approval from stakeholders, to get the additional business approval.

Environment: SSIS, MS SQL Server 2008, T-SQL, SSRS & Oracle 11, Erwin

Morgan Stanley, PUNE Dec 2009 to Aug 2010

Projects: GDR

Role: Offshore Lead

Highlights of Accomplishments:

GDR is the Central Repository, objective is to lift the data from Smith-Berney & shift

to Morgan Stanley Central Repository.

Used Informatica for data extraction/conversion from DB2 to Teradata.

Designed & developed various Informatica mappings to populate the data in the GDR.

Developed and implemented one time migration of Accounts, Contacts and Assets

into GDR.

Environment: HP UNIX 11i, Teradata, DB2, Informatica8.1, Synergy7.1

Consultant: Blue Star InfoTech

(2years)

Hewlett Packard, Bangalore Nov 2008 to Mar

2009

Projects: PISP

Role: Technical Analyst

Highlights of Accomplishments:

To streamline the Pricing Domain, Architect, designed and developed mapping to

extract data from ORACLE database,(PATSYl) Purchase Agreement Tracking System

automate continuous data feed & validate it.

Used Perl Scripts to automate reseller contract updates which were batched earlier.

Product updates were automated to load, which was managed manually earlier.

Environment: HP UNIX 11i, Oracle9i, UNIX Scripting, Tidal Job Scheduler

Hewlett Packard, Bangalore Oct 2007 to Oct

2008

Projects: DCC, Data Consolidation Center

Role: Technical Analyst

Highlights of Accomplishments:

Data Consolidation Center is a solution to consolidate the entire data centres

worldwide to only two data center for HP DOMAIN.

Analysing and carving out solutions to complex issues UTC time zone conversions /

data mismatch concerns.

Quality testing of reports, migration of reporting tool power analyser 4.1 to Power

Analyser 8.0

Environment: Informatica Power Center / Power Analyzer / Oracle 9i, 10g, UNIX

Hewlett Packard, Bangalore Feb 2007 to Oct

2007

Projects: HPShopping.com, Gift Card/Split Payment

Role: offshore lead.

Highlights of Accomplishments:

Page 7 of 9

Gift Card / Split Payment: HP initiated the new feature Sale of Gift card through its

On-Line e-commerce B2B web site for different holiday seasons.

Developed several mappings / transformation to load Retail sales into RETAIL fact.

Worked on different sources such an oracle, SAP R/3 and flat files.

Performance tuning of mappings and SQL statements to facilitate daily load of data.

Quality Analysis of the features of Gift Card & Split payment to load retail sales.

Environment: Informatica Power Center 6.1 / UNIX / Power Analyzer / Oracle 9i

Consulting: Bangalore Feb 2006 Jan 2007

Consulting for a start-up company, customer engagement solutions to financial

Institutions and hospitality sector, Using digital signage technology to deliver

Business interactive messages.

Digital Classrooms for educational Institutions to make learning visually interactive.

Hewlett Packard: Software Engineer II, Bangalore Jul 2002 to Jan 2006 (4 Years)

Hewlett Packard, Bangalore Jul 2004 to Jan

2006

Projects: Train/Funnel Process

Role: Software Engineer II

Highlights of Accomplishments:

This is an ongoing process / effort to debug data concerns / issues in production

Did enhancements to meet business requirements for pre-existing projects.

Create mapping / workaround to fix the reported issue.

Create Perl script to automate manual effort.

Environment: Informatica Power Center 6.1 / UNIX / Power Analyzer 4.5 / Oracle 9i

Hewlett Packard, Bangalore Jul 2002 to Jul

2004

Projects: Middleware Replacement

Role: Software Engineer II

Highlights of Accomplishments:

Middleware Replacement is a HP mandatory initiative to migrate the middleware

infrastructure to be more reliable efficient, cost effective, superior, cutting edge

technology, replacing see beyond (eGate and Ican) interfaces with BEA WLI.

Analyze system requirements & functional specifications & understand business rules

of hpshopping.com web application. Use test director to develop test plan and write

test cases.

Technical Training, Train the Trainer for Application Support for HP Consumer

Products Computers, Desk Jet& Photo smart Printer.

Awarded Train the Trainer award during 2003

Environment: Apache Web Server, JAVA, BEA web logic, Broad Vision, Oracle9i,

SAP SD, SAP MM, TIBCO, See beyond 4.1.2, Win Runner, PVCS.

Vision Computers Inc. Bangalore & Atlanta Apr 1999 to Mar 2002 (3

Yrs)

Role: Technical Lead

Highlights of Accomplishments:

Design and implement network for SME organization

Page 8 of 9

Servers with RAID configuration, Rack mount installations of windows.

Network Projects including planning and implementation.

Manage a team; provide resolutions to technical escalation on network & OS issues.

Environment: Web Server, JAVA, Windows NT, Windows 2000, Novel Netware

Kinfotech Pvt Ltd. Bangalore Apr 1998 to Mar 1999

Role: Software Engineer

Highlights of Accomplishments:

Installation, maintenance and support activities for Products like Dr. Solomon and

McAfee Security products for Windows, NOVELL and NETWARE Environment.

Design and implementation of security policies.

Environment: WinNT, NOVELL NETWARE 3.x, 4.x, McAfee Security Products.

Grand Prix Software Solutions, Bangalore Oct 1996 to Apr

1998

Role: Software Engineer

Highlights of Accomplishments:

Developed user-friendly applications Billing & Store management for Kamath &

Shanbaug Group of hotels South Indian Restaurants.

Environment: Clipper 5.2 on Novell Netware.

Ark Technologies, Bangalore Jan 1996 to Sep 1996

Role: Software Engineer

Highlights of Accomplishments:

Development for Airways Courier Management system and Point of Sale. Features

like consignment status, customer details and payroll. Inventory, sales and Purchase.

Involved in Design and Requirement Analysis.

Environment: Clipper 5.2 on Novell Netware.

EDUCATION

MSc- IT, Kuvempu University, Bangalore

MBA - IT, Sikkim Manipal University, Sikkim

BSc, Bangalore University

Page 9 of 9

Contact this candidate