• Hanu-VBA-REPORTING-AND-ANALYTICS.doc
  • " ↑Download Resume 🡁

    Description

    HANUMANTHARAYAPPA Y H

    E-mail  :             reach2hanu@gmail.com

    Mobile  :             +91 9108127731/+91 8660576012

     

    Summary

     

    Engineer (Information Science) with 9.5 years’ experience in fields like Development, Risk Analytics, Service Management, PMO and Reporting fields with Strong VBA Coding knowledge.

     

    ·                Proficient in Advanced Excel, Reporting & Dashboards.

    ·                Proficient in VBA, Macros and SQL Technologies.

    ·                Good Exposure to business intelligence tools like SSIS, SSRS, Tableau, Power BI and QlikView.

    ·                Intermediate knowledge on Service Management Skills like Incident, Change, Problem,

    Asset and Configuration management modules.

    ·                Quick at adopting new technologies and absorbing business functionalities.

    ·                Worked on Datacenter Migration activities (Discovery and analysis, planning and execution).

    ·                Worked with DTM, Device42, CMDB, HPSM9, Service Now, Remedy Tools.

    ·                Experience in Automation with interlinking between different applications like Excel, Access,

    SQL server, Power Point etc. by using ADO Technology, VBA, ODBC, OLEDB and SQL Query.

    ·                Worked as PMO (Scheduling, Capacity and Demand Management, Training, billing etc.

    ·                Worked on Dashboard Designing, Automation reports, Data Analysis, Implementation on

    Existing dashboard and generating adhoc reports based on client’s requirements in Excel,

    PPT, MSBI, Net reflector tools.

    ·                Works with different clients closely across US, UK, Singapore and Canada of different

    domains like BFS, Health Care, Aviation and brewing industry throughout career.

    ·                Exceptionally lead the team of 5 members to achieve organizational tasks, Motivate plan

    track and backed team in critical time, possesses seasoned abilities with identification of

    operational issues and methods to achieve delivery timelines set by the management with

    accuracy and efficiency.

    ·                Trained new joiners on VBA, Excel and other project related activities.

    ·                Can work efficiently in a group, as well as individual and take up responsibilities.

    ·                Certified in ITIL Foundation 2011.

     

    Professional Objective
    Determined efforts, enthusiasm and willingness to learn are motto through which I want to excel and obtain a good position with continuous self-development.

     

    Educational Qualification
    ·       B E in Information Science under VTU from Malnad college of Engineering.

     

     

    Work Experience
    1

    Organization                              : Honeywell under payroll of Magna InfoTech.

    Role                                                  : Project Analyst

    Span                                                 : From April 2019  to till date(As Contractor)

     

    2

    Organization                              : DELL EMC under payroll of Experis IT ltd.

    Role                                                  : Team Lead(Data Center Migrations)

    Span                                                 : From October – 2018 to Feb-2019(As Contractor)

     

    3

    Organization                              : DXC Technology

    Role                                                  : SVC info Developer II(C# (Windows), SQL and VBA)

    Span                                                : From August – 2016 to March-2017(As Contractor)

    March-2017 to April-2018 (Permanent)

     

    4

    Organization                              : HSBC

    Role                                                  : Risk Analyst – Analytics (Information Management)

    Span                                                 : From April-2015 to July – 2016

     

    5

    Organization                              : Accenture Services India Ltd

    Role                                                  : IT Operations Analyst (Reporting)

    Span                                                 : From May-2013 to Jan-2015 as Permanent Employee

    Before Sep-2011 to April 2013 as contractor under

    PMR Management & Consulting Payroll

     

    6

    Organization                              : Delta Infra Limited

    Organization                              : MIS Executive

    Span                                                 : From Mar-2011 to Sep-2011

     

    7

    Organization                              : S S Power Systems

    Organization                              : MIS Executive

    Span                                                 : From Aug-2009 to Feb-2011

     

     

     

     

     

     

    Technical Expertise
    Programming Language       :            C, C#, C++, SQL, VBA, ASP.NET MVC, Base SAS, Power BI

    Tools                                              :           BMC Remedy, HP Service Manager, SharePoint, GBI.

    Database                                      :           SQL Server 2012. MYSQL.

    Microsoft office                        :           Word/Excel/Power Point/Outlook/Access/Visio 2010.

    Other Skills                                 :           SQL basics queries, Dashboard/Template Creation

    Task Scheduling and SQL Job Scheduling, Web creation using MVC Framework, Entity framework and Web API

     

    Work Experience (Current Org.)

    Domain: SPS (Safety and Productivity Solutions)

    JOB PROFILE:

    ·       Develop project strategy plans based on logical framework approaches

    ·                Active research to design new projects and to prepare and present new ideas to   improve current processes which impact the business

    ·       Analyze statistical data, market trends and legislation relevant to projects

    ·       Maintain project timeframes, objectives and communications

    ·       Create and manage documentation and reports for projects

    ·       Identify the goals and requirements of each project

    ·       Verify data and information and analyze it to suit the direction of a project

    ·       Track, forecast and report on project progress including metrics and challenges

    ·                Automate reports using VBA when reports are streamlined and create a MOR for leadership for discussing health of project and their revenue.

    ·                Analyzing insights of data and provide adhoc reports as per stake holder requirement using Tableau and Power BI Tools.

     

    Work Experience (Previous Org.)

    Domain: Data Center Migrations

    JOB PROFILE:

    ·       Premigration planning – Evaluate the data being moved for stability.

    ·       Project initiation – Identify and brief key stakeholders.

    ·                Landscape analysis – Establish a robust data quality rules management process and brief the business on the goals of the project, including shutting down legacy systems.

    ·                Solution design – Determine what data to move, and the quality of that data before and after the move.

    ·                Build & test – Code the migration logic and test the migration with a mirror of the production environment.

    ·                Execute & validate – Demonstrate that the migration has complied with   requirements and that the data moved is viable for business use.

    ·       Decommission & monitor – Shut down and dispose of old systems.

     

     

     

    Work Experience (Previous Org.)

    Domain: Aviation.

    JOB PROFILE:

    ·       As a Senior Software engineer worked with Client SME’s of US to understand the business requirement of each end user’s applications (built in C#, SQL) and based on the understanding created a set of techno-functional documents for respective applications.

     

    ·       Worked with GPS team, create applications as per the RUD, support their applications and technical issues, enhancing existing applications to meet optimization and efficiency.

    Generate monthly and Quarterly billing files for airline and non-airline partners.

     

    ·       Created and maintained user guides and documents for all developed applications. Developed and maintained SSIS packages across multiple data sources. Create SQL jobs to run the applications at scheduled time and generate reports automatically in the client’s server location to reduce human intervention. Developed executive dashboards in Excel enabling them to measure the performance of the business with analytical capabilities.

     

    ·       Interacting with the client directly to answer their queries and understanding the business concept to develop new campaign.

     

    Domain: Brewing Industry.

    JOB PROFILE:

    ·       Worked with clients directly to understand their operational and technical issues.

    ·       Monitor the agalysis jobs in UC4 tool and respond quickly to fix P1, P2, P3 and P4 tickets. Fix tickets within TAT.

    ·       Interacting with the client directly to answer their queries and understanding the business concept to develop new campaign.

    ·       Approve change requests within the maintenance window and do FPC, health checks once change implementation is completed to ensure the smooth run of applications.

    ·       Provide on-call support to client to resolve any operational issues.

     

     

    Work Experience (Previous Org.)

     

    Domain: Banking and Financial Services.

    JOB PROFILE:

    ·       Understanding business requirement from different country level manger and designing prototype dashboard for client’s primary approval before moving to development phase.

     

    ·       Coordinate and compile stress test results and develop analysis to communicate with wider HSBC group, including Group, Regional and site Risk Strategy.

    ·       Build Tools to fulfill the needs of Retail, Mortgage, Reconciliation for RWA and Non-RWA.

    ·       Develop new tools and Enhance existing tools for Actuals and MI based on requirements using VBA through requirement identification, Validation & Sign-off, Build & Unit Test, UAT, Rework, Retest/Sign-off and Live Submission support process.

    ·       Provide trainings to campus hires and lateral hires on VBA to educate and understand them to work effectively.

    ·       Effectively manage a high volume process supporting Group, Region and Site with its internal and external stress testing needs.

    ·       Ensure the timeliness, accuracy and reasonableness of results produced by the process.

     

    Work Experience (Previous Org.)

    Collate data from various tools and teams and update the same in excel sheet for dashboard.
    Reports are submitted to client on daily, weekly, monthly, quarterly & yearly in the form of Excel, Word & PowerPoint.
    Service Level Agreement (SLA) Reports
    Operational & Key Measurement reports
    Monthly Service Reports for clients signoff
    ATM and Branch outage Reports
    Automated several report to avoid time consuming using VBA Macros.
    Producing Daily Dashboard PPT to the Leads for their feedback on the Performance.
    Back up for Change & Configuration management
    §  Report and Agenda for CAB Meeting

    §  Monthly SLA Reports

    §  Update the new CI in CMDB

    §  Coordinate & assisting change implementers and different team members.

    §  Email notification for CAB Approved change Records

    ·       Automated several report to avoid time consuming using VBA Macros

     

    Work Experience (Previous org.)

    VALIDATION TOOL

    Team Member           : 2

    Technologies              : ACCESS, EXCEL, VBA

    Duration                       : 30 Days

    Intent: This tool is responsible for the validation of quality of the data before submitting into Stress Testing template. It imports the data from excel and access to validate the data for different kind of checks likely Range Check, Type check, Enumerations check, Business rule checks. If any of these fails, all failed and warning checks will be appeared in the Dashboard sheet along with line numbers and the reason for failing. This tool is used to validate the data of 60 different countries, 4 different regions and group level.

     

    MI TOOL

    Team Member           : 2

    Technologies              : EXCEL, VBA

    Duration                       : 30 Days

    Intent: This tool gives the management summary with high level description. Senior Level managers used this tool across the globe. It takes two excel files as input, one for current quarter and another one is for previous quarter. It gives the difference between two quarters financial metrics. If the threshold is <1% then business leads need to give proper business justification else it considers as that metrics failed. This data used for validate and verifying stress testing is met for UK, US and Hong Kong for stress testing needs. This tool is used to validate the data of 60 different countries, 4 different regions and group level.

     

     

     

    RECONCILATION TOOL

    Team Member           : 2

    Technologies              : EXCEL, VBA

    Duration                       : 30 Days

    Intent: This tool is used to map and verify our bank metrics with standard PRA (Stress Testing) metrics. If all are matching with PRA metrics then Stress test is passed else need to give detailed standard information and reason behind the failure.

     

    SLA DASHBOARDS

    Team Member           : 3

    Technologies              : EXCEL, VBA

    Duration                       : 45 Days

    Intent: These Dashboards are build according to the requirements of clients. There are total 32 dashboards are built on different services. All the metrics are properly validated, trends and graphs are also added. Once we import the excel file. All the metrics are auto populated. Advanced formulas and conditional formatting are written on excel cells.

     

    Trainings
    ü  Training on MSBI SSIS in GITS Academy. Bangalore

    ü  Training on ITSM tools and Advanced Excel with Macros

    ü  Training taken on Base SAS in HSBC.

    ü  Training taken on MVC, Entity Framework, Web API and Angular JS in Pragim.

     

    Interests & Extra Curricular Activities
    ü  Nature Photography and Playing Cricket.

     

     

    Personal Profile
    Date of Birth                             :             03/03/1987

    Passport Details                     :

    Number                         :             R4663907

    Expiry Date                 :             13/09/2027

    Languages known                  :             Kannada, English, Hindi (read, speak and write).

    Permanent address               :             # 11, Kambadakallu, Yennegere, Solur Hobli

    Magadi Taluk, Ramanagaram Dist. PIN-562127

     

    Place:               Bengaluru

     

    Date:                                                                                             (HANUMANTHARAYAPPA Y H)

    Skills

    • VBA; Advanced Excel; Reporting and Analysis