SQL, Excel, Visio

Akanksha Dutt

Business Analyst at PCMI Corp

Prospect Heights, IL 952-***-**** ****.**********@*****.*** Summary

Masters in Information Technology Management from Illinois Institute of Technology Experience using Oracle, Access, Linux, Excel, Peoplesoft, ADP, LexisNexis, JIRA, Sharepoint, SAS, R-programming Experience across all stages of SDLC from requirement gathering to User Acceptance Testing Liasioning and Coordinating with various stakeholders in Agile Methodology of SDLC Skills

Software Tools/Platforms: Microsoft Suite, SAS, R-Programming, Oracle SQL, Linux, Excel, Peoplesoft, ADP, LexisNexis, JIRA, Sharepoint

Design and Documentation: Technical and Functional Design Documentation SDLC: Waterfall and Agile Methodology

Soft Skills: Analytical Skills, Presentation and Communication Skills, Self Motivated and a Team Player 2016 - Current

2013 - 2014

2012 - 2013

Work History

Business Analyst

PCMI Corp

Develop and maintain detailed Business Requirements Participate in testing of technical and functional requirements Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications. Conduct 5+ levels of testing including functional, regression, user acceptance, integration and performance to verify the client’s needs are met. Facilitate monthly meetings with clients to document requirements and explore potential solutions.

Co-ordination with Clients and recording all issues using JIRA Co-ordination with offshore teams in Poland and Thialand Participate in preparation for product launches including pre and post production release testing

Business Analyst

Community Insurance Agency Inc

Working with Policy Admin Systems and analyzing the data sent by external source

(IMG)

Identify and reconcile errors in client data to ensure accurate business requirements.

Designed and modeled tables in Oracle to store policy information. Modelling was done using normal form techniques and ensured capabilities to store historical records and track changes on a policy Customer, Policy were broad categories of information that were modeled as part of this initiative.

Worked with development team to make sure the data from the admin systems were correctly populated on the tables

Performed Data Validations using SQL queries to maintain the data quality Performed manual data validations against the policy admin systems. HR Data Analyst

Maryville Academy

2009 - 2012

Handling the HRMIS on a weekly basis

Helped in setting up of a recruitment tracker and report generation Background Verification using LexisNexis

Employee database management using ADP

Coordination with hospitals for results of physical and medical tests. Coordination with DCFS in regards to 508

Business Analyst

Investors Clinic

Administration of various HR systems

Continually monitor requirements and recommend system enhancements to improve processes.

Ensuring security of HR information through established security protocol Ensures the integrity of the HR data system

Ensure compliance with data integrity protocol between HR, Payroll and Finance departments

Provides leadership and oversees employee information collection, analysis and reporting.

Audits system capabilities for accuracy, integrity, and functionality by performing system testing,

Monitoring and documenting test results, analyzing test results and documenting system discrepancies, ensure adherence to HR laws policies and practices. Recommended approach to move data to relational databases using oracle. Designed Integrated Employee Database to centralize all employee related records.

2015 - 2016

2009 - 2010

2008 - 2009

2004 - 2008

Education

Masters in Information Technology Management

Illinois Institute of Technology

Sports Management

Indian Institute of Management-Shillong, India

Masters in Business Administration

Sikkim Manipal Institute of Technology, India

Bachelor of Technology

Sikkim Manipal Institute of Technology, India

Contact this candidate