Post Job Free

Resume

Sign in

Experienced Technical/Data Analyst

Location:
McKinney, TX, 75071
Salary:
65000
Posted:
January 20, 2012

Contact this candidate

Resume:

Elena Isayenko

_______________________________________________________________________________________________________________

Tel. : 214-***-**** Email: tfqaau@r.postjobfree.com

SUMMARY

Technical Analyst/Developer with 8+ years experience in Reporting, Data Analytics, Project Management, Process Improvement and Automation. Experienced in various industries: Finance, Banking, Supply Chain Management, Contract Labour/Purchasing, Investor Services, Technical Accounting, Administration, Business Analytics, Insurance, Operations, IT/Software, and Customer Service. Strong interpersonal, presentation, documentation, communication and writing skills, exceptional attention to detail, strong analytical and problem solving skills. Top Skills are:

• Business Reporting and Advanced Analytics • Project Management

• Data Mining and Data Analysis • Process Improvement and Automation

• MS Office Reporting, emphasis on Excel and Access • SDLC, Business Requirements

• VBA scripting • Process Documentation, Instruction Manual Writing

• Dashboards, KPIs, Savings Calculations and Reporting • Financial Reporting

TECHNICAL SKILLS

• RDBMS (Relational Database Management) • Strong VBA for MS Office 1997-2007

• SQL Server 2005, MySQL • Extensive experience in MS Office Suite (1997-2007)

• Business Objects, Crystal Reports, Monarch Pro • VBA Scripting for WRQ Reflections

• Advanced SQL • PeopleSoft (beginner)

• SQL for Oracle (PL/SQL Developer, Oracle Developer) • HTML, CSS, Front Page, PHP

PROFESSIONAL EXPERIENCE

SCOR GLOBAL LIFE RE US. - Plano, Texas 2008 - Present

Data Administration and Analysis / Technical Data Analyst

Objective:

• Review and analyze existing processes, suggest possibilities for improvement by automation

• Develop new tools (reporting and automation) for Data Analysis and Settlements teams

• Provide coaching, mentoring, and training to other team members on how to use the tools available to them to do their job more efficiently and with faster turnaround

• Utilize Business Objects and SQL Server 2005 tools for advanced executive reporting and dashboard calculations

• Lead and manage small scale projects from beginning to end (SDLC)

Accomplishments:

• Developed, modified and improved numerous existing MS Access databases; reduced processing time and accuracy by at least 50% on various top accounts

• Automated monthly reporting processes on various accounts – from manual calculation of financial data and technical accounting in Excel – to a few clicks in MS Access

• Provided suggestions about various tools the department or company could utilize to cut processing time and improve accuracy

ELECTRONIC DATA SYSTEMS (EDS, AN HP COMPANY) - Plano, Texas 2005 - 2008

Supply Chain Management (Contract Labour) / Technical Database Reporting Analyst

Objective:

• Support EDS Supply Chain Management (SCM) category as a reporting resource due to lack of reporting structure in existing purchasing tool (SQL Server database)

• Continually analyze existing applications and business processes in order to identify opportunities for improvement and automation

• Integrating data from multiple sources into unified reports.

• Produce complex reports using data from various sources, often where data does not match

• Provide coaching, mentoring, and training to other team members, assisted with learning the tools available to them to do their job better and faster.

Accomplishments:

• Developed MS Access based tool for departmental use: tracking Resource Manager performance, exceptions logging, shortcuts for faster data lookups, user-friendly layout. Implementation of this tool resulted in 20% time reduction in daily processing, which enabled the team to move on from reactive to pro-active mode, reduce turn-around time, and greatly improve customer service

• Developed Time to Fill, Supplier Scorecard, Cost Savings and Performance Metrics reporting packages to analyze time to fill an open contract labor request and resource manager performance, supplier performance, category spend and savings. These reports were used to identify gaps in business processes and improve performance

• Automated processing of NMCI Finance accrual report saving 3 business days a month of manual work

• Completed urgent ad-hoc reporting requests for various levels of management within required timeframes and with 95% accuracy

• Successfully transitioned all reporting to a new purchasing tool (Oracle database)

JPMORGAN CHASE BANK, N.A. - Dallas, Texas 2004 - 2005

Institutional Trust Services (Dallas MIS) / MIS Analyst

Objective:

Develop MS Office solutions for ITS Operations to increase efficiency and productivity, reduce error rate and processing time on various manual tasks.

Accomplishments:

• Rebuilt numerous existing databases for Securities Settlements Group: improved processing time, efficiency and accuracy by 20%-60%

• Took over responsibility for and automated issuing monthly Insight Report for senior management. Reduced preparation time by at least 50% each month

• Automated Balance Sheet Report (analysis of aged balances for senior management). Reduction in processing time: from 5 business days each month to 5-8 hours in total (which represents 80% time reduction); and reduction in a possibility of manual error by at least 50%

Responsibilities:

• Develop Access databases upon client request within requested time period

• Produce scripts using Reflections to scrape data from mainframe into Access database for further data analysis (also familiar with Foxtrot)

• Analyze data with Monarch (versions : 6.0, 7.0, Pro)

• Visit various ITS departments regularly, review department functions, analyze processes, make suggestions on improvement and automation, create business requirements / proposal, meeting with clients , develop solution(s), test solution(s), train staff, implement solution(s) into production, support solution during it's lifetime

• Support ITS Operations : produce ad-hoc solutions and/or scripts, ad-hoc reports within requested timeline

• Produce monthly MIS reports for senior management timely and accurately

JPMORGAN CHASE BANK, N.A. - Dallas, Texas 2000 - 2004

Investor Services / Sr. Securities Analyst

Accomplishments:

• Developed MS Access database for tracking, processing and complete reference on Canadian securities. This improvement reduced processing time by 40% due to automation and reduced errors/exceptions occurring in less than 5% of all payments and significantly reduced risk exposure for the Bank

• Developed various MS Access databases for the team to automate manual processes, reduce error rate and enable data backup

• Prepared complete step-by-step procedures for processing Canadian securities in order to partially automate manual processes as well as to ensure easy and fast training of the staff with minimal errors. This reference contributed to smooth training of three people and assured seamless transition into live processing with less than 5% occurrence of errors

• Participated in a project with Risk Management team to conduct an audit for the Equity group for year 2001. Also conducted an audit of Canadian reclaims and exemption letters.

• Made a significant contribution that allowed the department to be able to meet and maintain performance goals defined by upper management for 2004, contributing greatly to the continual reduction in the quantity and age of exceptions allowed in order to bring accuracy of payments to 100%

BANC ONE & CO, N.A. - Dallas, Texas 1999 - 2000

Account Analysis / Account Specialist

• Analysis of bank accounts for commercial customers nationally

• Information research

• Transaction and balance adjustments

• Daily and monthly reports

• Verification of system updates and maintenance

• General ledger adjustments

• Research and problem solve analysis issues

• Review, prepare and mail out of special handling analysis statements

EDUCATION

Bachelors in Finance and Credit

National Economic University of Kiev - Ukraine, Crimea Region, Simferopol

LANGUAGES

Languages Proficiency Level

English Fluent - Full Knowledge

Russian Fluent - Full Knowledge



Contact this candidate