Manager Data

SUMMARY

Accomplished well-rounded and versatile analyst with a track record of

delivering strategic IT solutions.

Hadoop skills summary:

Data storage and analysis in Hadoop, orchestration of Hadoop jobs, and

integration between Hadoop and RDBMS;

Cloudera certified Apache Hadoop developer (May 2013)

Data Management experience:

All aspects information management and phases of the information

lifecycle - acquisition, analysis, storage, strategy,

architecture/modeling, database design, maintenance, data quality,

governance, data reconciliation/balancing, data correction, archival,

security, metadata management, master data management, reference data

management, data transformation, data integration.

Specialties:

Data integration design, process/job orchestration, researching and

architecting solutions including completing proof of concepts and

prototyping, reverse engineering applications, system development.

Website: http://hadooped.blogspot.com

SKILLS

Hadoop Stack

Core Skills HDFS, Classic Map Reduce (Java and Streaming), Hive, Pig, Oozie,

Sqoop, Hue;

Hadoop Cloudera Hadoop (CDH 4.x); Cloudera Manager for (basic)

distribution administration

Integration Sqoop- Import and export of data between mysql and HDFS, and

mysql and Hive tables; Scheduling of sqoop jobs;

Orchestratio Oozie- Created workflows, bundle Jobs, coordinator jobs, sub

n workflows; SLA tracking and automated email notification; Actions

-hdfs, email, Java MapReduce, Java Main, Pig, Hive, Sqoop;

Running Oozie jobs through Java (Oozie Java API) and CLI;

Coordinator jobs that time driven, and data availability driven;

Oozie web console;

Languages/Technologies/Methodologies

Languages RDBMS Scripting Web & major Desktop

standards Applications

OOP: C#.Net, Oracle 11gR2, Shell scripting ASP.Net, HTML, Windows Forms

VB.Net, C++, SQL, PL/SQL, (OS-Unix, JavaScript, CSS, Applications

Java, SQLServer 2005, Linux), Windows XML, JSON

T-SQL, scripting

Other: Python Datawarehousing

ETL/EAI Orchestration/M BI/Reporting Version Control Software

onitoring engineering

Sqoop, Sql Oozie Sql Server PVCS, TFS UML-Visio,

Server IBM Tivoli Reporting Rational Rose

Integration Scheduler Services 2005,

Services 2005, Splunk Business

working Objects

knowledge of

TIBCO and

Informatica,

Methodologies RUP, Iterative, Operating Unix - CentOS, Solaris

Agile Systems

Analysis

. Adept at requirements elicitation, anticipating user needs, understanding

the business, problem solving, graphical representation using Visio,

blueprinting solutions, UML modeling using Rational Rose and Visio;

Strong documentation, organizational, presentation and communication

skills;

Architecture/Design:

. Strong reverse engineering skills; Adept at researching and architecting

solutions, at software detail design; Experienced presenting technical

solutions, drafting new project proposals, developing and presenting

proof of concepts, acquiring funding, negotiating with vendors, assisting

with technical planning of project.

Application Development

. Full life-cycle development: Experienced with multiple full lifecycle

development of web and desktop applications, reporting applications - all

phases including reverse engineering and re-engineering, requirements,

architecture, design, development, testing, deployment, support;

Other

. Experienced training teams and end users; experienced transitioning

application support to operations teams

. Adept at managing multiple priorities; Strong starter skills;

WORK EXPERIENCE

Technical Lead for implementation of Splunk, for Operational Intelligence

Allstate Investments; Investment Technology; Jan 2013 - March 2013

About the project

The project involves implementing Splunk for managing availability of - a)

data, by tracking data transmission across integration paths, b)

applications, and c) infrastructure, with the goal to provide an

exceptional customer experience.

Responsibilities:

Defining vision, solution architecture, sizing, licensing, working through

licensing, contract and infrastructure needs, SOW to hire Splunk

professional services, defining detail design and managing overall delivery

of the Splunk implementation, defining plan for transitioning support to

operations team, planning operational readiness activities.

Accomplishments:

Architected a solution to provide a holistic view of data integration

status (from source through hops to destination), at a record level, near

real-time; Reviewed several tool/technology combinations and recommended

Splunk; Led a POC of the solution proposed; Transitioned knowledge to the

architecture and development teams;

Technical Lead Designer for Application Integration, Data Team

Allstate Investments; Investment Technology; May 2011-Dec 2012

About the project

BIS is a multi-year initiative with a budget of over 50 million, to replace

approximately 120 vendor/home-grown applications with under 20 best of

breed investment applications; Includes implementation of Blackrock's

Aladdin as trade order management system and risk analytics platform, Eagle

Pace as Ref data/MDM/Hub ODS and Eagle's Message Center as API for

integration into PACE, implementation of a new warehouse product and a

performance measurement application; Includes implementation of a new EAI

based data integration architecture with TIBCO EMS as integration platform,

implementation of over 300 data interfaces, near real-time and batch;

Includes integration of the hub with multiple downstream subscribers

including the investment accounting system and the data warehouse; Includes

decommissioning of legacy applications;

Architecture and Design

- Contributed to the design of the TIBCO EMS based Data Integration

application (DIA)

- Contributed to design of the DIA framework services - selection of

services from the Allstate Enterprise, as well as enhancements to the

same; Includes an Events Driven Router, a monitoring, logging and

alerting service, a file transfer service, a cryptography service, a

scheduler service;

- Contributed to defining integration patterns to use, defining

requirements for monitoring the DIA infrastructure;

- Led a proof of concept (POC) of intra-day integration with Eagle PACE

(Ref data/Master data/ODS), identified aspects of the product, that

needed customization for intra-day integration; This helped with

planning the development effort;

- Comprehensive understanding of vendor interfaces and best practices -

BlackRock Aladdin and Eagle PACE, responsible for ensuring integration

with vendor hosted solutions, adhered to Allstate Enterprise security

standards;

- Defined integration processes, activities and tasks, defined ones to

run in parallel versus sequential, synchronous versus asynchronous,

defined critical path activities;

- Defined data transformation strategy and strategy for maintaining and

publishing code sets, including domain value translations;

- Defined naming conventions for file-based integration, Designed

message metadata to support identification of source, data entity,

asset type, intra-day or end of day data, daily versus month-end,

delta versus full refresh - content/context based message routing;

Designed message metadata to support record count-level

reconciliation;

- Designed integration orchestration, SLA monitoring and alerting,

design for activity logging, monitoring, alerting;

- Defined data exception management strategy in consultation with the

business;

- Designed outstanding data exception reports for the data stewards to

support data quality improvement efforts;

- Designed message routing rules based on requirements of data

subscribers;

- Analyzed and optimized processes to support meeting E2E integration

SLA defined by the business;

- Defined reprocessing strategy and corresponding design;

- Designed integration to be event-driven; Designed orchestration of

Investment end-of-day batch; Designed handling of holidays or lack of

activity;

- Successfully defended the application integration architecture to the

Enterprise architecture audit team;

Technical Documentation

- Created blueprints of the architecture and design - solution

architecture diagrams, UML (2.2) sequence diagrams, UML state, and UML

activity diagrams, data flow diagrams and detailed application

integration design documentation; Created a message catalog Wiki;

Operational Readiness

- Facilitated workshops to brainstorm and document, all possible failure

scenarios across the integration landscape from an infrastructure,

application and data perspective, symptoms, monitoring and alerting

available (or gaps in the same), escalation process, solution for

fixing/reprocessing, SLAs, OLAs;

- Defined monitoring and escalation process/contacts to be notified;

Recognition

- High performance award from IT senior management

- High performance award from peers

- Recognition by IT senior management as a role model in Investment

Technology for Employee Value Proposition, an initiative encouraging

individuals to own and take charge of their career

- Appreciation from the Allstate Chief Technology Officer for

outstanding technical documentation

- Technical delivery lead responsibility for the bank loan integration

project, a multi-million dollar initiative scheduled for 2013

Technical Delivery Lead for External Money Manager Integration

Allstate Investments; Investment Technology; 2010-2012

Responsibilities: Project leadership, business analysis, architecture,

detail design and delivery of new external money manager integration

projects?

Accomplishments - 2010/2011: Architected a reusable integration framework

that supported expedited on-boarding of new external equity money managers;

successfully led an extremely time-critical, business impacting, high-risk,

complex and challenging integration of a new external money equity manager,

on the new framework developed; successfully led yet another new external

equity manager integration at ten percent of the implementation cost of the

first manager; initiated on-boarding of two new external fund managers; for

each money manager, established SLAs and OLAs, transitioned work done to

the support team; received high performance awards from the business and IT

leadership teams.

Accomplishments - 2011/2012: Researched and documented integration with

SWIFT network, and associated costs; and also using an infomediary; Defined

solution architecture of integration with infomediary; Presented the

architecture to infomediary selected;

Technical Team Lead (Manager), Middle Office suite of applications

Allstate Investments; Investment Technology; 2010

Responsibilities: Managing a suite of applications with a team of five

resources. Was accountable for enhancements, stability and availability of

several critical applications, and associated batch jobs, including the

investment pricing application and performance application.

Accomplishments: Streamlined the team, set aggressive training goals and

had the team cross-trained, transformed the team culture from operating in

(knowledge) silos to being versatile and collaborative, improved team

throughput, closed documentation gaps by having all applications documented

- this expedited on-boarding and improved speed to productivity of new

resources, facilitated guaranteed on-site support for the user group,

provided structure and empowerment to the team to operate independent of a

team lead;

Technical Consultant, Real Estate suite of applications

Allstate Investments; Investment Technology; 2008-2010

Responsibilities: New development, enhancements, stability and availability

of several .Net (Web and Windows forms, Sql Server 2005, SSRS), and batch

jobs (SSIS), including the Mortgage Loan Data Mart.?

Key accomplishments:?1) Developed an Insurance Maintenance Module in .Net

to capture insurance information of properties underlying the commercial

mortgage loans to supplement a gap in the Loan Management System (LMS-

SS&C). Received an award from the end user for contribution.? 2) Developed

a module to integrate data from the risk analytics application, MIRA into

the Loan Management System (LMS-SS&C). This involved implementing several

complex algorithms, agile development, and delivery within a short period

to a very demanding user group. Received a high performance award from the

end user. 3) Developed a module to support accuracy of GAAP book value in

the Mortgage Loan Data Mart, that involved extracting and integrating data

from the accounting journal entry system;

Application and Architecture Analyst, Master Customer Database

Unisys; Sales and Marketing IT; 2000-2007

Core responsibilities: Reverse engineering legacy applications in

UML/Rational Rose, business analysis, architecture, design, development and

support of applications in .Net and Oracle, training and transition of

support to offshore team, coordinating offshore development and support.

Responsible for stability and availability of systems and batch jobs;

- Lead developer of Meetings and Events Registration System (ASP/Oracle)? -

2000

- Developer of the Business Objects universe, WebI and full client reports

for the Marketing Data Mart?-2004

- Lead developer of the Customer Information Base application (.Net/Oracle

- web and windows forms)?

Accomplishments:?1) Growth, from an entry level programmer to an

applications and architecture senior analyst?through multiple promotions 2)

Platinum award and cash award from the end user/client group for

outstanding contribution

EDUCATION

Master of Science in Computer Information Systems; April 2001, Eastern

Michigan University

Bachelor of Science with major in Computer Information Systems; April 1999,

Eastern Michigan University

RECOMMENDATIONS - On linked in - Anagha Khanolkar (Greater Chicago Area)

AVAILABILITY - Within two weeks of offer

IMMIGRATION STATUS - Permanent resident

Contact this candidate