Software Configuration Analyst Resume Example Aon Hewitt

SOFTWARE CONFIGURATION ANALYST

Summary

Highly skilled Data Analyst professional bringing more than 10 years of experience in data collection, analysis and integration. Advanced knowledge of R, SQL, SAS and Python. Analytical and detail- oriented.Experience of using analysis results for product consulting. Currently pursuing BigData Analysis certification at UCSC Silicon Valley extensions.

Highlights

R Consulting skills Python HR, Payroll and benefits domain knowledge SQL Project management skills SAS Talking to larger groups with power point Hadoop Architecture presentations Data Collection Unix Data Analysis Mainframes Data Modeling ETL techniques Data Mining

Experience

Software Configuration Analyst 03/2014 to 01/2015 Aon Hewitt Lincolnshire, IL Acted as Control Account Manager and worked as a key liaison between technical teams and other business control accounts. Client and Vendor management with acceptance testing experience. Provided consulting skills to clients based on analytic reports. Provided technical leadership for a team of 8 indirect reports.Managed their day to work directly. Coordinated with systems partners to finalize designs and confirm requirements. Created detailed system interface specifications, field mapping, DDT and system process designs. Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access. Clients Implemented:American Airlines / United Airlines Merger and Tenet / Vanguard MergerKey Accomplishments: Designed and developed a parallel data integration system to an existing client to aid a merger process, without compromising on the functionality. Developed a centralized benefits administration system for a decentralized HR system Integrated HR, Payroll and Other 3rd party vendor files with Aon Total Benefits Platform. Responsible for client's data, system foundation, data model among different stakeholders. Acted as tower lead to lead a technical team of 10 analysts in a matrix organization working on multiple projects. Worked with conversion team( Informatica) team for data loads and brainstorm on creating additional data fields as benefits driver. Performed data cleansing, Integrity check, validation and auditing. Designed and developed ETL steps (Extract, Transform, Load ) between Aon system and other systems using SAS, SQL, JCL on the mainframe enviroment. Worked extensively on SAS/ODS in order to summarize and analyze the data. Used business intelligence tools like Cognos reporting tool for metrics reporting. Clients implemented: Wells Fargo, PNC Financials, Target, Phillips - Conoco Phillips spin off, Motorola Solutions, Allstate, State Farm, American Red Cross, Accenture, Eli Lilly, General Dynamics Sample Reports: Generated annual enrollment frequency statistics, billing reports, pension calculation reports, payroll deduction summary reports and reconciliation reports. Established compatibility with third party data files by developing program for modification and integration. Provided maintenance and development of participant data flows based on requirements changes. Experience of production jobs scheduling, file transmission setup, ongoing maintenance and revisions. Built application platform foundation to support benefits administration. Designed and executed regression test plans to automate the process flow based on user behavior.

Education

Masters: Information Technology Jawaharlal Nehru Technological University Hyderabad, ANDHRA PRADESH, IN Masters: Information Technology, Jawaharlal Nehru Technological University - Hyderabad, India

Bachelors: Computer Science and Engineering Nagarjuna University Guntur, IN Bachelors: Computer Science and Engineering, Nagarjuna University - Guntur, India

Accomplishments

Honored as a technical subject matter expert and served in the core Implementation/training panel for data
integration in the health and welfare domain to guide different teams, as well as coach fresh recruiters in
the offshore development center
Designed Core-TBA platform which allows to do customization for different data integration files by
reducing actual development time by 50
Worked on more than 20 client implementations over 10 years. On average 2 clients per year

Certifications

American Red Cross

Presentations

Hadoop Architecture presentations

Skills

Benefits, Clients, Hr, American Red Cross, Auditing, Billing, Business Intelligence, Coda, Cognos, Data Cleansing, Data Model, Database, Dynamics, Etl, Extract, Transform, And Load, Financials, Ibm Cognos, Informatica, Jcl, Mainframe, Metrics, Microsoft Dynamics, Motorola, Ods, Operational Data Store, Payroll, Pension Calculation, Reconciliation, Red Cross, Sas, Serial Attached Scsi, Solutions, Sql, Statistics, Vxworks, Integration, Integrator, File, Maintenance, Scheduling, Benefits Administration, Process Flow, Software Configuration, Test Plans, Acceptance Testing, Access, Account Manager, Data Integration, Liaison, Mapping, Security, Technical Leadership, Testing, Topo, User Acceptance, Vendor Management, Architecture, Collection, Data Analysis, Data Analyst, Data Collection, Data Mining, Data Modeling, Hadoop, Marketing Analysis, Offshore, Project Management, Python, Subject Matter Expert, Training, Unix

Resume Overview

Create a job alert for [job role title] at [location].

About About

Help & Support Help & Support

Languages Languages

Customer Service Customer Service

Software Configuration Analyst Resume Example

Resume Score: 85%