Resume

Sign in

Project Data

Location:
Tampa, Florida, United States
Posted:
December 02, 2017

Contact this candidate

Contact no: +* 813-***-****

Professional Summary

9+ years of experience in Analyzing business needs, Designing and leading technical team from concept through the release process

3+ years of experience as Business Analyst for retail domain (Nielsen- Music connect program)

2+ years of experience in Hadoop Big Data solutions – Architecting, Leading, development and testing

Extensive experience of working with different databases ( SQL Server,Oracle etc)

Designed ETL framework to work with HDFS

Appreciated for Datawarehouse design which resolved complex ETL requirement

Appreciated for Scrum master skills which improved overall team velocity

Proficient in all Phases of SDLC (Analysis, Design, Development, Testing and Deployment) and gathering user requirements and converting them into software requirement specifications

Work closely with Business clients

Worked as liaison between the Customer and the Off-shore & On-shore team

Excellent Analytical, Programming and Logical skills

Certifications

Certification - Cloudera Certified Developer for Apache Hadoop

PRINCE2

Education

Bachelor of Engineering: Cummins College Of Engineering, Pune University, India, 2005

Technical Skills

Big Data Eco System

Cloudera Distribution for Hadoop (CDH), HDFS, Hive, Impala, Sqoop, Elastic search, Spark, Kibana, Parquet

Scripting Languages

Shell Scripting, PERL

Database

ORACLE, SQL Server

Tools

SSIS (ETL Tool), Toad, DB Visualizer, Quality Central, JIRA, BitBucket, SVN

Methodologies

Waterfall, Agile

Project Domain

Retail Buy/Watch,

Banking and Financial,

Telecom – Element Management

Work Experience

Project : Connect-Music (Top revenue making product for Nielsen) Since Jul 2013

Client : Nielsen

Role : Technical Business Analyst and Scrum Master

Technologies: Hadoop(Impala, Hive,Sqoop, Elastic Search, Spark),SQL server 2014, SSIS (ETL development tool), Oracle, Shell, Java

Integrate the Scan (BUY) and Airplay (WATCH) related data and present it via Insightful reports and dashboards; so as to enable end-users to have all the information related to any Music item/Artist under one umbrella:

Legacy Data movement for BDS and Soundscan

Unification of master data

Datawarehouse Table design

DataWarehouse ETL design and development

Console for Ops usage

Interact with all the different stakeholders to get the requirement to bring the data into Enterprise Data Warehouse

Translate the requirements into architecture

Architecture & Data Governance processes

Interact with the Portfolio team and Program Team and work on Quarterly Sprint Planning and Project Releases

Manage the off-shore team to get the requirement done in Hadoop

Provide design recommendations and thought leadership to sponsors /stakeholders that improve review processes and resolve technical problems.

Recommend and decide technology solutions and perform mapping of the business requirements to systems/technical requirements to ensure they are in line with the enterprise architectural plan.

Lead in designing, specifying and selecting information system solutions

Considering functionality, data, security, integration, infrastructure and performance.

Understand the software architecture design and support development team in developing solutions accordingly

Review, interpret and respond to detailed business requirements specifications (BRS) to ensure alignment between customer expectations and current or future capability

Develop, test and implement technology solutions and report on delivery commitments to ensure solutions are implemented as expected and to agreed timeframes

Project : TNC-ADM-SD-Pune-BUY-POC-Off Sept 2012 to Jun 2013

Client : Nielsen

Role : Tech Lead

Technologies: Oracle 11g, OBIEE, Perl

RMS is the system which supports Nielsen’s business of providing its customers a reliable and the objective information on the impact of marketing and Sales programs. This system takes care of collecting, validating and analyzing the sales data.

The Current process is done using set of legacy systems which varies from country to country. This results in inconsistencies in reporting across geographies therefore Nielsen is migrating the current processes to the new platform (CIP Customer Information Platform). The migration is happening country wise and a cumbersome manual approach is being followed for the overall migration activity.

RMS migration POC initiative shall accelerate the country conversions to ensure an ongoing successful multi-year roadmap for key Buy Product Lines by geography (Region and Cross Country).

RMS migration POC will built an ODS (Operational data store) which will contain specific data from legacy factories and target Euro Factory. This ODS will serve as a validation area for migration. This POC will be used as base for future migration validation of all countries

Requirement gathering, Analysis, design and Development of business use cases.

Coordinating software development and design while serving as module lead

Following established company and department standards as best practices

Creating and updating project plans and/or task checklists for assigned projects.

Loading data into HBase tables using Java MapReduce

Loading data into Hive partitioned tables

Project : Credit Suisse Financial Banking(CMS) Jul 2010 – Jun 2012

Client : Credit Suisse

Role : Lead / Sr. Oracle DB Developer

Technologies: Oracle 10g, Unix, Perl

Client Master Service is an application currently serving Credit Suisse to maintain key information of CS clients. CMS is used in US and UK currently and will be extended to APAC. All new parties who want to do transaction through Credit Suisse in US and UK are registered in CMS application and then the data is hooked up to different third party applications after required approval. It’s a wide application ensuring compliance to various legal requirements depending on the Jurisdiction of the party.

Analysis and Development of business use cases.

Coordinating software development and design while serving as module lead

Following established company and department standards as best practices

Creating and updating project plans and/or task checklists for assigned projects.

Working as Quality–Coordinator, controlling overall quality of project deliverables.

Project : Legacy database migration to DB2 Jan 2012 – Jun 2012

Client : Credit Suisse

Role : Module Lead / Sr. Oracle DB Developer

Technologies: Perl

Database migration:

Requirement was to migrate a legacy database which was using BDAM files to corresponding DB2.

To understand and decode BDAM file structure. Using that understanding design and develop a tool which will help migrating it to DB2

Project : EDS-ABN-AMRO (NL) Sep 2008 – Mar 2009

Company : ABN-AMRO (NL)

Role : Sr. Oracle DB Developer

Technologies: Oracle 10g

ABN AMRO Access Online is an online banking application for ABN AMRO bank Netherlands. The project deals with online payments, user management, balance & Transaction Reporting. This project is on Wholesale Banking and Payment Solutions. Application consists of 3 modules:

1.User Administration

2.Online Payment Processing

3.Portal Balance & Transaction Reporting

I was part of a project called Dolly Migration. This project comprised of creation of new database as a part of RBS and ABN AMRO banks legal separation.As part of the Dolly project, all the data of the Access Online is to be migrated for ABN AMRO NL Bank and then after retention period RBS data will be deleted from ABN AMRO NL database and vice-a-versa. I was involved in this project for the designing and development of approach for identifying and deleting the data from databases.

Project : Veraz-EMS Nov 2005 – Aug 2008

Client : Veraz

Role : Oracle DB Developer

Technologies: Rational Clear case,Oracle 9i, Perl, Oracle forms 6i, Shell scripting, UNIX.

The Element Management System (EMS) is responsible for provisioning all the components of a ControlSwitch system. In addition, it proactively monitors the status of the system's elements. At the provisioning level, the EMS sets up and initializes all of the components in a Veraz ControlSwitch system.

Event relay Server (ERS) is one of the network element which is responsible to process the events generated by Event Collector in which client is interested.

Developed a feature called Any to Any release Database Migration and worked on many other features like SMS, Subscriber Manager Database designing, Local Audits Logs, Presence, Reports, Provisioning of elements etc. My work involves gathering and analyzing requirements, preparing design document, implementation, reviews, testing and support



Contact this candidate