Data Analyst

Harihar Iyer Telephone: 312-***-****

Email: *********@*****.***

Technology Analyst and Data Consultant specialising in Data Strategy, mapping and recording, interpreting and analysing data in a fast-paced environment. Advanced proficiency in all aspects of SQL and databases. Experienced in preparing detailed documents and reports while managing complex internal and external data analysis responsibilities.

Possessing an analytical mind and ability to understand processes in a variety of areas including database upgrade and supply chain, software development, Release Management in multiple domains such as Banking and Finance, Wealth, Government and Utilities.

Skills, Abilities and Tools

Release and Implement Mgmt.

Unix and Linux Admin

Oracle 10g

Maas360

Data Security & Backup & recovery

ITIL v3

MS-SQL v6.5, 7.0, 2008,2000

Mobile Data Management

DB2 9.1, 9.7,10.1

Stakeholder Management

MobileIron

Non Prod Env Management

Data Modelling XML, JSON & ERWIN

Jira & Sharepoint

Sybase v11.9.2, v12.5.15

AirWatch

Professional Experience

Client : Norther Trust Bank

Position : Technical Project Management April 2019 – Till Date

Responsibilities:

Structuring Technical Project performing the detailed planning for Delivery

oAs a Technical Analyst (TIR) duties involve working with the Project Manager and Tech Lead to break down the Technology task that need to be performed for Dash Boards, Configure Data

oWork on Proof of Concept with Technical Lead and Define Tech deliverables evaluates risk and recommends contingency plans.

Work on Proof of concepts with Technical Lead and Define Tech deliverables, evaluates risk and recommends contingency plan

oConduct Proof of concept for technology integration across the bank

oAdvise the business on the potential risk and deliverable of Minimum Viable Product

Work with Enterprise Architect to manage the technical strategy for Environments, Capacity Planning for (Middleware & Database)

oConfigure the new features of the product as per technical specification and requirements.

oManage waterfall and Agile delivery methodology across the programs.

Conducts workshops such as JAD, RAD, and DRP sessions

oSet up workshops with Development team and Business Analyst

oVendor Product analysis for configuration and new business rules.

Assign Technical Resources and tasks, and manages quality assurances, resolution of issues programs/project issues

oManage (SQM (Software Quality Assurance) testers for the Project

oConduct defects resolutions meetings and ensure the project issues are reported and resolved in timely manner.

Technology status reviews and reporting, development of standards, change control, customer support, and compliance with all polices and procedure

oEnsure to follow the NT Weekly Technology Reporting standard for reporting

oProject and Programs communication workshop for release cycled.

Manage multiple projects execution and handover to business for moderate or large project on time and within budget - 10% of time spend on duty.

oConduct regular DB design and Java/SQL code walk through with Tech teams.

oBuild to infrastructure specification provided by vendor recommendation with Middleware Team

oWork with Infrastructure manager to ensure enough capacity for expanding data volume & Performance

Manage waterfall and Agile delivery methodology across the programs

oWork with SCRUM Master to develop sprint sessions

oUpdate waterfall projects plan for complex data migration projects

Implementations and configuration of SmartStream Recs 2.7/Premium 2.5

oDeployment of Vendor Packages in Controlled Environment

oDesign Dashboard from Enhancement to Customization of the Vended product features

oMeasure Data Quality and Accuracy to establish Data Integrity for Bus Operations.

oCustomize security (Roles/Authentications) of Reconcilers across the Banks.

oFinal Productions Implementation planning and support TLM Release for data migration.

Client : Optus, Sydney

Position : Technical Analyst Aug 2017 – March 2019

Responsibilities:

Manage and support MDM Solutions such as AirWatch, MobileIron, MaaS360

Experience in developing design requirements for an expansive mobile device management (MDM) system, including mobile configuration management,

remote device control, auditing, critical file backup, wiping, data synchronization, firmware updates, diagnostics, security, network usage,

mobile asset tracking and management, device provisioning, software installation, policy application, logging, and reporting, GPS tracking and breadcrumb mapping,

and geofencing.

Design and create reports within management software for strategic decision making (licensing, patch/vulnerability, asset intelligence, fleet health, etc.)

Create and maintain thorough documentation for all endpoint solutions, code, configurations and processes.

Act as an escalation point for complex technical issues

Software management with VPP/Google Play

Endpoint configuration management (Group policy object /GPO) experience

Provision new devices with DEP/KNOX

Client : ATO – Australian Tax Office,

Position : Data Analyst April 2016 – July 2017

Responsibilities:

Analyse, Profile and systematically present the data for Business and management team understanding.

Working alongside teams within the business, Solution team or the Technical team to establish business needs.

Managing master data, including creation, updates, and deletion.

Managing users and user roles.

Provide quality assurance of imported data, working with quality assurance analyst if necessary.

Processing confidential data and information according to guidelines.

Documenting the data mapping rules for migration.

Defining new data collection and analysis processes

Client : TAC – Victoria Work Cover Authority, Australia

Position : Support Analyst Jun 2011 – Mar 2016

Responsibilities:

Work closely with other data and analytics team members to optimize the company’s data systems

Build data and analytics tools that will offer deeper insight into the pipeline, allowing for critical discoveries surrounding key performance indicators and customer activity

Always angle for greater efficiency across all of our company data systems.

Create & deploy applications within a cloud environment

Assist support and manage application servers

AWS RDS cloud infrastructure related support such as snapshot, backup, Point-in-Time Recovery (PITR), CloudWatch metrics analysis, Database Troubleshooting, Performance Tuning etc.

Support all database engines including DB2, Sybase, Oracle, Apache Cassandra and SQL server for any kind of issues, especially AWS infrastructure related, DMS (Database Migration Service) providing advice for performance tuning.

Plan, design, and implement application database code objects, such as stored procedures and views.

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Develop new processes to facilitate import and normalization, including data file for counterparties.

Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.

Responsible for the upkeep of the database schemas and contents.

Involved in all aspects of implementation including preparation of delivery schedules, change, issue and risk management and hands on implementation plan.

Extensive exposure to manage Disaster recovery rehearsals.

Scope:

Migrate DB2 v9.1 to v9.7 - Production, PREPROD, Integration and Test

Set up HA (using Witness Server) and Mirroring

DB2 FIX Pack Upgrade for AIX and Linux servers

Tangible Achievements:

Designed and set up “Disaster Recovery “ on premises

Designed High Availability feature sets (Witness Server) to reduce down time while patching & scheduled implementations

Set mirroring for effective data back management

Other Projects:

Client : Merrill Lynch – Bank of America (BOA), India, New York,

Position : Database Support Administrator Jul 2005 - Feb 2011

Employer : American Insurance Group Disaster Recovery Center

Position : Database Administrator Sep 1998 - Jun 2005

Education / Professional Development

Diploma in Hardware Engineering - 2001

Diploma in Networking Centred Computing and System Management - 1998

Bachelor of Commerce – 1996

Certification

IBM Certified Database Administrator (DB2 10.1 for Linux UNIX and Windows) 2013

IBM Certified Database Associate (DB2 10.1 Fundamental) 2012

IBM Certified System Administrator (Informix 11.70) 2012

IBM Certified Database Associate (Informix 11.70 Fundamentals) 2012

Sybase Adaptive Server Enterprise Administrator Professional 12. 2010

Mobile Iron Access Administration 2018

Mobile Iron Cloud Intermediate R51 2018

Mobile Iron Cloud Fundamentals R55 2018

Mobile Iron Support Specialist Intermediate v9.7 2018

Mobile Iron Core Intermediate v9.5 2018

Mobile Iron Core Fundamental v9.5 2018

SVC-16A - Apple Service Fundamentals Exam 2017

MAC-16A - ACMT 2016 Mac Service Certification 2017

Contact this candidate