We provide IT Staff Augmentation Services!

Kronos Consultant Resume

TECHNICAL SKILLS

  • Business Intelligence and Data warehousing.
  • Project, Program and Product Management.
  • Solution Design, ETL/ELT, Data & Analytics
  • Informatica PowerCenter, Talend 6.3.1, 7.2.1, SAP BODS
  • Enterprise Data Catalog, Metadata Manager
  • Oracle PL/SQL, OBIEE, ODI, Power BI, MicroStrategy 10.4 & 2020
  • Teradata FSLDM ( Financial Service Logical Data Model )
  • Unix/Linux scripting, Python
  • Erwin
  • Atlassian JIRA, Confluence, Microsoft Project, Access, Excel
  • Azure Data Factory, SQL Data Warehouse
  • SQL Server, SSIS, SSRS
  • SAP Business Objects, SAP S/4HANA, Cognos ReportNet
  • IDQ
  • BTEQ, FAST LOAD, MLOAD, TPUMP
  • OFSAA ( Oracle Financial Services Analytical Applications )
  • IBM Health Plan Data Model (HPDM)

PROFESSIONAL EXPERIENCE

Confidential

Kronos Consultant

Responsibilities:

  • Delivery of new service pack and new platform releases for WFAN (Workforce Analytics).
  • Line management of over 50 professionals including vendor resources.
  • Planning and producing Analytics product roadmap.
  • Taking strategic business goals and turning them into a technology strategy & roadmap that lines up to an architectural approach.
  • Budget forecasting, tracking and reporting on a regular basis.
  • Formulation of data migration and governance strategies and approach.
  • Creating plan of records, SOE, running Agile ceremonies, planning poker estimations, scrums etc.
  • Running Data governance & Metadata reporting program for Workforce Analytics.
  • Evaluation of vendors and tools like Informatica Enterprise Data Catalog, Talend Data Catalog, Manta, Microstrategy Enterprise Manager etc. for metadata management initiatives taken at Kronos.
  • Managed security vulnerabilities raised by CoalFire, Checkmarx, BlackDuck etc.
  • Managing Third party audits and regulatory compliance for product.
  • Cost optimization and Infra rationalization strategies for Cloud and On premise customers.
  • Data migration from on premise to cloud for customers migrating from on premise to cloud implementations.
  • Generating trend reports on Log Analytics platform at the top of the logs data ingested on Hadoop that helped in proactively fixing issues within WorkForce Analytics product ahead of these getting reported by customers.
  • Producing product quality and delivery framework for Analytics Engineering.
  • Report on status of development, quality, operations, and system performance to management.
  • Management of departmental resources, staffing, mentoring, enhancing and maintaining a best - of-class engineering team.
  • Generating confluence and Power BI reports on Continuous Engineering and NPD progress and productivity KPIs to senior leadership.

Head of Reporting Shared Services

Confidential

Responsibilities:

  • Line management of over 60 professionals.
  • Delivery of BCBS239 material compliance and full compliance releases.
  • Formulation of data migration and governance strategies and approach.
  • BI virtualization strategy and roadmap for migration to Oracle and AWS Cloud.
  • Providing a shared reporting platform by customizing Teradata Financial Services Logical Data Model and other data models for the systems within RBS .
  • Data Integration of risk data from several Risk systems from RBS such as GRDW (Group Risk Data Warehouse), RMP MI etc.
  • Data Migration from SAP S/4HANA to Teradata EDW platform for Enterprise level reporting.
  • Mapping of GL data from SAP S/4HANA to FSLDM finance subject area.
  • Creating proposals for adding more and more customers on shared BI and ETL platforms.
  • Infrastructural and application rationalization strategies.
  • Formulating cost reduction and automation strategies.
  • Option analysis for several BI tools, technologies and design.
  • Setting up Scrum teams and managing them for Agile delivery and reporting velocity achieved to various stakeholders.
  • Vendor management to execute several projects through vendor teams.

Confidential

Head of Data Solutions

Responsibilities:

  • Setting up Data Solutions COE in Confidential and delivery planning.
  • OFSAA (Oracle Financial Services Analytical Applications) model customizations.
  • Mapping OFSAA LDM to RBSLDM ( i.e. Enterprise Data Warehouse LDM that was developed using Teradata FSLDM ).
  • Creation of customized LDM and PDM in Erwin and establishing end to end data lineage of the system in Informatica Metadata Manager.
  • Data Migration from SAP to Oracle.
  • Solution design and architecture of FIG (FiRST Inbound Gateway) for cloud based environment for FiRST strategic release sprint 1.
  • Loading data from HANA to FIG (FiRST Inbound Gateway) using SAP BODS.
  • Designing and developing intraday ETL for SGL feeds using Informatica PowerCenter to achieve near real time data processing.
  • Setting up and configuring PowerCenter environments on cloud.
  • Vendor and permanent staff management.
  • Data analysis for several source systems.
  • Managing Business Analysts and Data Modellers deliverables for FiRST.
  • Requirements gathering for Basel 3 STD RWA calculation through OFSAA engine for risk data from Group Risk Data Warehouse.
  • ETL framework to achieve intra day processing of loads.
  • Producing data contracts for various subject areas.
  • Reference Data management
  • Option analysis and design to put unstructured data on Hadoop.
  • Development of data lineage using Informatica Metadata manager.

Confidential

Release Manager

Responsibilities:

  • Identifying and agreeing on the release requirements with business teams like Customer Analytics, Risk Analytics etc.
  • Data discovery and Analysis, Cost Buffet preparations, work break down structures, Capex and Revex estimations, Project plan, resource and environment planning, risk planning etc.
  • Creation of functional specifications for the project and agreeing them with business.
  • Customizing Physical Data Model ( PDM ) for EDW that was build using Teradata FSLDM ( Financial Services Logical Data Model ) .
  • ETL solution design and Batch design.
  • Reference Data management
  • Metadata management to build end to end data lineage for the system. Informatica Metadata Manager was the tool used for same.
  • Vendor and internal resource management.
  • Code review and performance tuning.
  • Coordinating development and testing activities and project implementation.

Confidential

Data and ETL Architect

Responsibilities:

  • Requirements gathering and agreement with business teams.
  • Creation of Functional Specifications Design.
  • Producing high level Solution Design and Low level component design for the system.
  • Teradata Financial Services Logical Data Model ( FSLDM ) customization to produce required RBSLDM.
  • Creating and maintaining Physical Data Model (PDM) using ERWIN.
  • Producing data contracts for various FSLDM subject areas.
  • Volumetrics and environment sizing for Informatica, Unix and Teradata.
  • ETL Standards creation.
  • Data Modeling and Data Governance standards.
  • Data quality, cleansing and standardization with Informatica Data Quality ( IDQ )
  • ETL and batch design.
  • Reference Data design and management
  • Reviewing test strategy.
  • Informatica, Unix and Teradata Code development and review.
  • Performance tuning.
  • Implementation co-ordination and warranty support.
  • Formulating data migration strategy and design to migrate data from 200 source systems to build day0 scenario for the new platform.
  • Creating day1 strategy for the data loads as well as building rollback strategy for the system during data migration as well as for business as usual operation of the platform.

Hire Now