We provide IT Staff Augmentation Services!

Vp - Data & Analytics Resume

Nyc New, YorK

EXECUTIVE SUMMARY:

  • Solution Architect with 15+ years of experience in designing and implementing various business solutions in Data & Analytics, Enterprise Data Warehouse, MDM, Data Management & Data Integration.
  • Having expert level domain knowledge and experience in cross functional working with customers.
  • Development experience in Relational Database Management Systems (RDBMS) including 10+ years of hands - on experience in implementation of data warehouses using Teradata & Oracle Exadata.
  • Proven track record in driving discussions with senior personnel regarding trade-offs, best practices, project management and risk mitigation.
  • Currently working as Solution Architect with hands-on development and implementation of corporate applications in Data & Analytics.
  • Experienced in analyzing on-premise OLTP and EDW database environments such as Teradata, Oracle, SQL Server and analytic databases.
  • Experienced in consulting for optimal design of database environments, analyzing complex distributed production deployments, and making recommendations to optimize performance.
  • Experienced in developing innovative solutions to complex business and technology problems.
  • Experienced in evaluating and plan migrations from one database to another database.
  • Extensive hands on experience in leading large-scale full-cycle enterprise data warehousing (EDW) projects.
  • Industry leadership in the fields of database, data warehousing or data sciences.
  • Extensive hands on experience in data warehousing design, tuning and ETL/ELT process development.
  • Excellent SQL and strong hands-on scripting using shell scripts and python.
  • Good understanding of database and analytical technologies in the industry including MPP databases, NoSQL storage, Data Warehouse design, BI reporting and Dashboard development.
  • Good knowledge of Cloud Computing, AWS services such as EC2, S3, VPC and Redshift.
  • Experienced in provide the strategic thoughts about business, product, and technical challenges in an enterprise environment.
  • Experienced in establishing operational data governance across all business systems by creating a framework and working with functional leaders to define roles and responsibilities.
  • PoC experience with Hadoop/NoSQL/Columnar DB platforms, AI and Cloud enablement of Database and Analytics environments.
  • Enthusiastic in cloud technologies and practices, building data applications that utilize services such as AWS EC2 and S3.
  • Proven experience in recruiting, developing, managing and leading teams.

TECHNICAL SKILLS:

Database: Oracle Exadata, 10/11g, Sybase, MS-SQL Server 6.5/7.0/2012 , Teradata 14.0AWS Redshift, Confidential DB2

Data Mgmt Tools: Informatica 8.x/9.x/10, BODI, Confidential DataStage, Attunity, Informatica MDM, SAP MDM

BI/Reporting Tools: Tableau, QlikView, Business Objects, Cognos,OBIEE

Cloud Technologies: Amazon Web Services (AWS), EC2, S3, Redshift

Third Party/Scripting: Unix Shell Scripts, Python, Tivoli Scheduler, Control M, Erwin Data modeler, ER/Studio Data Modeler

PROFESSIONAL EXPERIENCE:

VP - Data & Analytics

Confidential, NYC, New York

Responsibilities:

  • Hands on technical lead for the analysis, development and delivery of the Inforamtica based architectures and data warehouses.
  • Designing the dimensional model for the analytics requirement.
  • Reviewing the ETL code and business logic from the team.
  • Conducting proof of concepts for Data & Analytics solutions, presenting to business, and getting buy-in for the solution.
  • Understanding data and data structure across organization.
  • Created a proposal for Supplier 360, to resolve business challenges due to duplicate vendors across organization.
  • Working with other groups (Wealth Management) in the organization and contributing to the Data & Analytics portfolio.

Sr. Solutions Architect

Confidential, Edison, NJ

Responsibilities:

  • Proposed and directed many PoC in the initial phase of project and provided insight to the right tools and technology to the customer.
  • The PoC involved identifying and providing solution for real time reporting using Attunity & Redshift on AWS platform.
  • Proposed and directed PoC on Big Data data lake using Cloudera tools for a feasible solution
  • Leading all the technology discussions with the client and provided the input which helped them choose the right tools.
  • Managed large technology development teams working offshore for Informatica, Cognos, Redshift & Attunity.
  • Directed and reviewed the logical model, physical model & semantic layer as per the requirement for CURVE. This involved enhancing GDW Supply Chain and HCCP Enterprise model.
  • Lead the data modeling discussions with the shared service platform team
  • Single point of contact for offshore India team for any technical issues.
  • Designed the ETL layer for real-time reporting in Attunity, loading data in Redshift, and Teradata for the data warehouse.
  • Resolved many complex design issues during development phase.
  • Worked directly with business in communicating and negotiating the timelines for the project.
  • Assignment of development tasks on day to day basis to the offshore team
  • Tracking the progress and updating status to the customer on regular basis.

Sr. Managing Consultant

Confidential, Richmond, VA

Responsibilities:

  • Worked closely with customer during initial phase of RFP to understand the entire Data & Analytics landscape.
  • Understanding the gaps and pain points in existing platform.
  • Provided future state architecture.
  • Setup the new team for the account, grown the team of 50 resources.
  • Worked in the capacity of Delivery Project Executive, managing entire account for this initiative.

Environment: Data & Analytics, Informatica, Teradata, UNIX Shell Scripts

Sr. Technologist & Technology Manager

Confidential

Responsibilities:

  • Analysis, design and development of Data Integration components using Informatica and Oracle Exadata.
  • Performing code review of the team
  • Demand and Scope Management for various projects
  • Capacity Planning
  • Effort estimation for the change requests
  • Working with business/BA and providing the solution from analysis to delivery.
  • Working with multiple teams, coordinating with them as we source data from multiple source systems.
  • Working towards Scale 2020
  • Commitment to the change requests
  • Providing innovative solutions to the user's requirements
  • Improving user experience by adding value through more optimal and high performance solutions.
  • High availability across the globe to support the Data warehouse solutions.
  • Providing technical leadership to the team in all the phases of the SDLC

Environment: Data Modeling, ETL, Informatica 9, LINUX, BO, Shell Scripts, Oracle Exadata, 11g, PL/SQL

Principal Software Consultant

Confidential

Responsibilities:

  • Working closely with customer for the Data Integration Requirement gathering and analysis.
  • Proposing the solution to the data integration requirements, working with different stakeholders to have the approval and funding in place before starting the development work.
  • Define data integration model
  • Provide insight to the data modelers for better understanding of the data transformation patterns.
  • Working closely with SMEs at client site to understand the business logics.
  • Managing onsite delivery and offshore team
  • Leading a team of Informatica developers, assigning the daily task.
  • Designing the data integration solution
  • Developing ETL using Informatica and Oracle 10g.
  • Updating client on daily status / progress
  • SPOC for all the client requirements and end to end solution.
Technical Lead

Confidential

Responsibilities:

  • Requirement Analysis for Confidential countries.
  • New rollouts for Financial Data warehouse as per business requirement in Confidential .
  • Communicating and coordinating with users across Confidential
  • Providing requirement analysis and design documents to the development team.
  • Providing the inputs to the development team for any new enhancement.
  • Closely working with country users while conducting and supervising the UAT cycle.
  • Assigning the task to the team and monitoring the progress.
  • Updating the weekly status to the Management.
  • Helping the development team in Oracle 10g migration.
  • Making sure the quality deliveries to the client on time.
  • Getting the sign-off from users for any new enhancement/development after full cycle of UAT.
  • Conducting for new team members.
  • Code review and Production migration supervision.
  • Monitoring Daily and month end process for Confidential closing on 5th BD.
  • Providing the quick solutions during any technical or functional issue.
  • Working with Business team for any new Management plan for the future.
  • Mentoring and grooming the new members in the team.
  • Adding values to the Project by providing innovative ideas to reduce the cost and to improve the efficiency.

Technical Lead

Confidential

Responsibilities:

  • Analysis, Design & Development of DW modules/projects
  • Team management & Resource allocation
  • Code reviews
  • Quality assurance
  • Onshore communication
  • Working with DBA, Business analyst, and Data Modeler to provide the accurate view of the data and to propose the design
  • Helping team throughout the life cycle of the project through technical leadership
  • Monitoring the daily jobs
  • Design and development of ETL mappings, sessions and workflows.
  • Work estimation and allocation for new ETL requirements.
  • Responsible for building and leading the Data warehouse team onsite, also onsite coordinator for offshore team.

Hire Now