We provide IT Staff Augmentation Services!

Data Management Consultant Resume Profile

4.00/5 (Submit Your Rating)

Richmond, VA

Professional Summary

I'm an experienced Technologist with over Thirteen years of experience having significant appreciation towards Data Architecture, Technology Delivery, Program/Project Management and People Management. Most of my experience is deeply rooted in Datawarehouse platforms in Banking Finance domain focusing on Data Integration, Data Aggregation, Data Acquisition strategies. I have led both large and small teams. I have also worked as individual contributor as well as Technical Leader. I have broader exposure to both traditional Waterfall as well as Agile software development methodologies. I'm a quick learner and strive continuously in learning and understanding upcoming trends as they emerge. My current interests include deep understanding of next generation data platform with Big Data using Hadoop, Advanced analytics using In-Memory computing thereby streamlining delivery management process framework.

Key Experience Summary

  • Proven track record with Technical Leadership, Program Delivery, Engagement Governance and Team Management excellence.
  • Strong background in analysis, design, development, testing, implementation and maintenance of data related applications and GUI frameworks.
  • Participated in end-to-end life-cycle implementations of various datawarehouse solutions including but not limited to Data Integration, Data Migration/Conversion, Data Quality, Data Synchronization, Master Data Management.
  • Building Technology appreciation on Big Data based Next Gen analytics Hadoop open source platforms.
  • Providing ETL Design Solutions for various requirements, working with architecture in obtaining gate-check clearance, interfacing data modelers, BSA's and Business Sponsors representing single IT point of contact.
  • Driven JAD sessions, Design Reviews, Business Assurance Testing Strategy definitions, User Acceptance Testing, Production Implementations Post Production support.
  • Defined Service Level Agreements SLA for data availability by working with Data Stake-holders
  • Built Managed Services delivery framework by evaluating various components in ETL delivery and defining generic ETL estimation model thereby optimized delivery efficiency and work throughput with increased predictability.
  • Participated in various solutions designing for Proposals with bid value upto 100MM.
  • Providing global delivery framework solutions including but not limited to Time Material, Core/Flex Capacity Management, Service Unit based Managed Services etc. depending on the nature of the requirements
  • Maintained working relationship with sourcing management team who manages Vendor relationships in creating Statement of Work, reviewing periodic rate revisions and making any contract amendments.
  • Performed as Transition Manager ensuring various components of an application gets transitioned successfully.
  • Identifying Business Development opportunities, working on RFP responses, Proposal Presentations, Statement of Work creations, Resource Fulfillments / Interviews, Contract Rate Negotiations etc.
  • Experience in managing a global team upto 100 resources spread across geographies spanning multiple engagements.
  • Efficient Project Team Management containing multi-disciplinary skill-set at various experience levels including Employees, Contractors Customer Associates.
  • Manage Customer Relationships for the Engagements at VP / Sr.Director / Director levels ensuring their Goals Objectives are being met with the planning and deliverables across various LOB's.
  • Driving strategic Monthly/Quarterly Business Reviews with Senior Leadership Team in reviewing the healthiness of Engagements.
  • Conducting Sprint Retrospectives, reviewing the effectiveness of Development, designing Quality Services System/User Acceptance Testing strategies and optimize project execution with recommendations for betterment.
  • Supporting Waterfall and true Agile based delivery solutions and participating in delivery transformation initiatives, where implementing feature driven Agile solutions.
  • Excellent Oral Written Communication Skills and tremendous Soft Skills helping towards building successful partnership with everyone.

Technical Skills

Platforms

Microsoft Windows, Red Hat Enterprise Linux 5 and 6, Hadoop Data Platform

Languages

Transact-SQL, PL/SQL, Unix Shell Scripting, C, C

Data Integration Tools

Ab-Initio, Talend, Kettle, Informatica, Microsoft SSIS / DTS

Data Acquisition Tools

Business Objects, SQL

Databases

Teradata V12.0, DB2, Microsoft SQL Server 2005 and 2008, Oracle 9i and 10g, HBase, MongoDB

Scripting Languages

VBScript, JavaScript, Perl, ASP, XML, HTML

Development Tools

Ab Initio GDE, Teradata SQL Assistant, TOAD, SQL Server Client Tools Query Analyzer, Enterprise Manager, Profiler , ErWin Data Modeler, Putty, MS Office

Software Engineering Tools

Quality Center, HP Service Manager, Version One, Jira

Business Domain

Banking and Finance, Manufacturing

Functional Specialization

Retail Bank, Core Banking, Online Banking, Loyalty Rewards, Branch Teller, Loan Originations Servicing, Fraud Management, Offer Management, Enterprise Customer Management

Project Experience

Confidential

Data Management Consultant

  • Stand-up Hadoop Data Platform for mapping clean merchant information with Credit and Debit card transactions.
  • Build solution to integrate Card and Bank transactions from TSYS and Fidelity to Bundle application using Ab-Initio ETL.
  • Evaluate various open-source technologies in defining the eco-system for Hadoop infrastructure performing various Data Integration and Analytics function.
  • Tracking sprint level backlogs and slotting stories for every sprint along with running daily stand-ups and documenting retrospectives.
  • Managing the expectations of Business stake-holders in providing periodic updates on the progress of work.
  • Provide leadership to the development team ensuring timely execution of project deliverables.

Confidential

Role : Delivery Lead

  • Design Data Management solution using Ab-Initio ETL for critical data synchronization between Active and DR systems and perform validation.
  • Build generic ETL patterns that can be leveraged for implementing dual load solutions
  • Define controls to perform Rolling Maintenance, Switch-Overs, DR Support between the two environments.
  • Establish and maintain productive working relationships with business partners and project teams.
  • Facilitate the code review process to ensure development work adheres to standards and specifications.
  • Co-ordinated Infrastructure readiness ensuring DR environments being available for implementation.

Confidential

Role : Program Lead

  • Evaluated program business requirements, translated business requirements into Functional and Non-Functional IT requirements.
  • Categorized requirements to various platforms including Analytic, Operations and Compliance.
  • Provided high level data movement solutions meeting business needs and having them reviewed/validated with architecture team.
  • Participated in Logical and Physical data modeling meeting analytic data needs towards building Information Based strategies.
  • Defined testing strategies integrating ARGO Electronic Journal transactional input, ARGO OLTP transactional input and VISION IP monitoring output.
  • Worked with vendors ARGO and VISION IP managing the business expectations on defect resolutions and new enhancements build.
  • Drove User Acceptance testing across multiple platforms integrating various business stake-holders resolving any UAT issues thereby prioritizing resolutions based on criticality.
  • Functioned as Data Implementation manager and handled 3 major production implementations.
  • Took lead in resolving Post Production issues to the level of detail that meets business needs.
  • Defined Production Support processes and successfully transitioned the application to Level 2 and Level 3 teams for BAU support.
  • Handled Scope, Schedule and Budget of the project ensuring that from data implementation standpoint we are on track.
  • Identified right set of competencies and fulfilled resources on time in order to deliver the project on agreed upon timelines.
  • Periodically monitored project healthiness ensuring the right quality of work being delivered to the program.
  • Mentored team members in defining career path based on their aspirations and setting the right Goals Objectives.

Confidential

  • ING Data Conversion / Data Integration
  • Chevy Chase Data Conversion / Data Integration
  • Loyalty Rewards calculation with TLP and Fidelity
  • Building 360 degree view of a customer
  • Retail Bank Scoring Models
  • Installment Loans CHARGER PNC Bank / PLUS ONE Fidelity
  • Digital Sales Servicing
  • National Direct Bank Analytics

Confidential

Role : Engagement Lead Development L3 Maintenance

Responsibilities

  • Work with BSA's and Business Sponsors in formulating necessary data requirements and Source to Target Mappings.
  • Develop High Level Design, validate with architecture and obtain gateway check signoff.
  • Develop Technical Design taking various design decisions into consideration.
  • Work with Developers in ensuring technical design gets translated into ETL Graphs, review the code in making sure it gets developed as per DDE Design/Development guidelines.
  • Co-ordinate with Quality Services in making sure they understand the requirement clearly in order for their validations.
  • Front-end User Acceptance Testing interfacing customers, analysts, business sponsors and Data Stewards and resolve any questions by working with respective groups.
  • Get the Production Implementation Plan developed, reviewing with IPS and EPC Unix partners
  • Co-ordinate Production Implementation and work with development team in monitoring post production processes.
  • Transition the application to Level 3 team and making sure from the supportability standpoint, all the aspects gets covered.
  • Work with business in reviewing various possible failure points, understand business criticality and have appropriate severities defined for the production failures.
  • Manage L3 team in making sure desired SLA's are being met from Incident Resolution and Break Fix standpoint.
  • Devised 24 7 support framework for providing L3 support to the enterprise ETL applications
  • Managed a global team spread across geographies from 2 to 30 resources at various point of team depending on the project size and need
  • Provided delivery management oversight for various department stake-holders in EDS
  • Created productivity accelerators that reduced development timelines thereby improving productivity

Confidential

Role : Development Lead

Responsibilities

  • Managed the back-end operations of entire T1A system.
  • Monitored the production runs, identify the performance bottlenecks and resolve them at the earliest by making sure that applications are not getting affected out of it.
  • Added new features to existing interfaces Analysis, design, development, testing implementation
  • Performed data analysis on the computed and aggregated data and answered customers queries and made sure it reaches their satisfaction levels
  • Meeting severity timelines and adhering the Service Level Agreements on any of the issue resolution processes to meet the business needs
  • Reviewing the status of interfaces during monthly meetings with Product Owners.
  • Managed a team of 2 Support consultants at onsite and 3 Support consultants at offsite
  • Analyzed ROI on migrating the entire data platform to SQL Server 2005 from 2000 and determined the benefits out of it.

Confidential

Lead Developer

Technology : Sybase 12.0, Crystal Reports, Actuate Reports, Unix

Responsibilities

  • Actuate Reports Migration Analysis
  • Active Participation in Requirement Gathering and Design Phases
  • Database Design to accommodate new reporting changes and requirements
  • Implementation using Crystal Reports
  • Performance Tuning of Reports

Confidential

Lead Developer

Technology : SQL Server 2000, DTS, Business Objects, Windows

Responsibilities

  • OLTP OLAP data modeling for the application
  • ETL Architecture Design / Development / Testing / Implementation
  • Business Objects Universe Design
  • Canned Ad-Hoc Reporting development

We'd love your feedback!