Post Job Free

Resume

Sign in

Data Manager

Location:
Katy, TX
Posted:
April 08, 2020

Contact this candidate

Resume:

https://www.linkedin.com/in/sreekumar-valappil-b**65710/

Sreekumar Valappil

Katy, Texas - 77494, Ph: 832-***-****

US Green Card, adcp0q@r.postjobfree.com

Experience Summary: Management

o Executive presentations to VPs, Directors in global fortune companies. o Proposed new ideas, analytical solutions, applications, got approval to deliver. o Representing Halliburton at PPDM Conferences, Energy conference on product sales booths. o Managed direct reporting of a global offshore and onshore team (China, India, Russia, Pakistan). o Managed vendors of Top 5 consulting companies and onshore vendors. o Analyzed and recommended visualization software from top vendors. o Delivered solutions in the cloud, hybrid and on-premising service solutions in AWS. o Directed reports ranging from 4 to 20 developers with 30 member teams. o Prepared presentations for gate and cadence meetings, global trainings. o Prepared roadmaps, new ideas, ROIs, presented to business and executive stakeholders. o Projected charters, resource, cost & time estimates, scope, story, backlogs, milestones, sprints. o Managed multiple projects in agile, waterfall methods using scrums, sprint, and iterations o Managed scrum development teams of onshore and offshore consisting: o Application/Product developers, Business analysts, Product specialists. o DBAs, DI/ETL Developers, visualization developers, Scada Developers. o QA, Dev/Ops, and release management teams, UX specialists o Managing from procurement to installation of Scada systems at various sites.

o Managed resource employee/contractor/intern hiring and disbursing. o Managed large scale data migration during mergers and client engagements. o Managed support change management ticket systems, issues and client issues, and enhancements. o Defined Scada digital playbook and communication topology workflows. o Defined Data Governance, visualization standards, Documentation of products. o Created Risk Matrix and Register and mitigation strategies o Created and delivered global training to sales to support people on the products as well as on installations of products and environment

o Managed user guides, training manuals, CI/CD and support client engagements. Technical Summary:

o Data Governance, stewardship, Data and warehouse modeling using Erwin, Toad and reverse engineering and ensured data quality and policies

o Coordinated with the data science team for predictive analytics and provide data engineering support o Led Data migration with SQL Server/Postgres/Oracle and PI Historians and Scada ignition systems. o Implemented Enterprise ETL/Database /Data warehouse Architecture for Halliburton products. o Designed Data virtualization and federation on cross-platform database software including EDM/EDT, ARIES, PDM Landmark products.

o Established data security and end-point security using encryption, familiar with key cloak authentication o Created dashboards using Pentaho analytics and Spot-fire, Chart.js, SSRS and high charts and intermediate expertise in Power bi and Tableau

o Data modeling, Virtualization, and federation using eclipse and teiid technologies. o Designed cubes in Mondrian schema workbench dimensions, measures, and KPIs. o Familiar with Hadoop, Hive, Scala SQL and big data technologies o Designed Data Flow charts and Process flow charts https://www.linkedin.com/in/sreekumar-valappil-b4965710/ o Visualization and dashboard with Tableau, PowerBI and Tibco-Spotfire, High charts, eCharts o Expertise: SQL complex queries, joins, pivot and unpivots, procedures, triggers o Knowledge in Snowflake, MongoDb, YiDb, Postgres, and Alteryx, Open Right Angle. Realtime/IoT:

Installed and configured Ignition SCADA systems and configured PLC Tags o Managed application to configure Dell Edge Devices to get real-time data and get data stored in AWS hosted in Rabbit MQ

o Load the data to SCADA OSA PI databases connected via apache virtualization o Installed and configured of Ignition Scada Realtime applications o Consumed the data from Scada systems via virtualized views to web pages Employment Summary

Waste Management: Houston, Texas Role: Tech. Project Manager : Oct 2019 to Mar 2020 Handled 3 projects as a technical project manager. 1. Automation and Digitization of Landfill: Three pilot sites POC went live for 4 months from procurement, facilitation to implementation.

2. Consolidation of Electronic Forms: required gathering, conduct interviews, pre-selection criteria, research vendors, vendor negotiations, demos to stakeholders and initial budget plan 3. Digitization Landfill Grading of Materials: an inhouse web application hosted in AWS ec2 instance. Developed in Python, Django with camera handlings in Salient servers, Pilot projects went live for 2 sites, Lead 2 onshore developers and 1QA resource and managed internal stakeholder expectation. Halliburton: Houston, Texas, Role: Product Owner / Data Architect : Jul 2013 to Jul 2019 1. Managed a global team(4 to 20) to deliver analytical solution product in hydrocarbon accounting 2. Develop Product roadmap, Product backlogs, milesstones, sprint, scrum 3. Managed SDLC from project charters to training and implementation at a global scale 4. Engaged with clients for estimates and delivered along with sales and support team 5. Provided technical architecture for projects, products and real-time data flow 6. Data virtualization, mapping, integration, ETL of various clients and public govt. data available. Sogeti-CapGemini: Houston, Texas Role: Manager / Data Mirgaton Delivery : May 2008 to July 2013 1. Managed Advanced planning module at Mens warehouse, which details clothing productline supply chain life cycle. Engaged as Technical BA with manging ETL and an offshore team. 2. Architect, development and implement various BI applications at clients that includes top oil and gas companies such as NOV, Schlumberger, Transocean

3. Data Integration for Risk grade matrix, data mapping and ETL for Amegy bank and Bank of America data warehouse

4. Data Migration and reporting from Openlink RightAngle 5. Provide consultancy on Data Architeture and Data governence and data quality Igate Mastech : Baton Rouge, LA Role: Data Migration Lead : Apr 2006 to May 2008 1. Architect/ Lead Data migraion of 40-50 years of legacy data from AS400/Cobol system to SQL Server 2. Employee and employer contribution and actuary reporting from various govt orgs in LA 3. Enterprise ETL Archtiecture that can define business of retirement systems 4. Implement Data Integration, validation rules, qualityc checks and migration using SSIS United Toll Systems(Transcore): Wetumpka, AL Role: Database Lead : Mar 2005 to Apr 2006 1. Data Modeling of inventory module for toll industry 2. Data Migration of various road side and plaza data to centralised system and reporting Cyberthink/Compsys: New York Role: Developer/Programmer Analyst : July 2002 to Feb 2005 https://www.linkedin.com/in/sreekumar-valappil-b4965710/ Skill Set Software Level Last Used Certified

Executive Presentation Power Point, Excel, Word Expert Current Product-Project

Management

MS Project, Jira, TFS, Agile,

Waterfall, Scrum

Advanced Current PMP (2010-13)

Global Team

Management

MS Team Slack, Skype,

WebEx, Camtasia

Current

Industrial Automation Scada (OSAPI & Ignition) Intermediate Current Inductive university(course)

Business Intelligence Pentaho Business Analytics

(cubes via Mondrian schema),

SSAS

Advanced July - 19 Pentaho BI

Certified - 2014

Visualization and

Reporting

SSRS, Tibco Spotfire,

PowerBI, Tableau, Highcharts,

Pentaho

Expert –

Advanced

July - 19 Udemy courses –

PowerBI,

Tableau

Database /Data

warehouse

SQL Server (2000-17), Oracle

9- 12C, Postgres, Teiid,

Mongodb (YiDb), Snowflake

Advanced Current MS SQL Server

Oracle

Application

Development

.Net, Angular/Node,

SharePoint, Microservices,

API, Rabbit MQ, VBA

Intermediate 2017

Scripting JavaScript, VbScript, Python,

R

Basic 2017

Environment Windows, Linux, AWS, Azure,

On-premise

Intermediate Current

Data Integration/ETL SSIS, SQL Loader, Pentaho,

Alteryx, Right Angle

Advanced 2019 SSIS Certified -

2011

Performance Tuning Profiler, DMV,

Dyna Trace

Advanced 2019

CI/CD - Continuous

Integration/deployment

TFS, GitHub, Jenkins Intermediate Current

Verticals:

Energy Services - Halliburton, Transocean, National Oil Well Varco (NOV), Schlumberger & Koch Business. Banking Services – Amegy Bank (Zion Bank), Bank of America. Environment Services – Waste Management.

Retirement Systems – Louisiana State retirement systems Toll Industry: United Toll Systems.

Supply chain: Men’s warehouse, Entenmann’s.

Real Estate: Coldwell Banker



Contact this candidate