Analyst

IRINA STRICKLER

*** ********* ** ▪ WESTERVILLE, OH 43081▪ 614-***-**** begin_of_the_skype_highlighting              614-***-****      end_of_the_skype_highlighting ▪ ****.*******@*****.***

Business Analyst ▪ Systems Analyst ▪ Marketing Analyst

Business Professionals with experience and success in retail ecommerce applications, systems analysis, customer support and quality assurance, demonstrated skills in analyzing B2B / B2C software functionality, understanding industry trends, and recommending most marketing software tools for existing clients and partner companies.

CORE LEADERSHIP QUALIFICATIONS

• Analytical & Quantitative Skills • Marketing Research & Analysis • Team Building / Leadership

• Strategic Research & Analysis • Risk & Operations Management • Retail Inventory Management

• Sales Forecasting & Modeling • End – User Support • Database Design & Support

TECHNICAL SKILLS

MS Project 2003 ▪ Project Server 2007 ▪ MS Office 2003/2007 ▪ MS Access 2003 ▪ Visio Flowcharting ▪ Lotus Notes Outlook 2007 Mercury Quality Center ▪ Acrobat Reader ▪ SDLC ▪ SQL Server 2005 ▪ SQL Query Analyzer ▪ SQL Analysis TOAD 9.6 • Power Point 2007 ▪ PeopleSoft 8.3 - 8.9 ▪ On-Line Business Objects

PROFESSIONAL EXPERIENCE

NATURAL RESOURCE LLC

(October 2009 – Present)

Experienced in planning, execution and analysis of quantitative & qualitative marketing research for B2B & B2C. Responsible for establishing and maintaining relationships within the business community, medical facilities & residential business owners. Review new opportunities from external sources on the special product promotions and service quality. Implemented vision & mission statements.

 Provide leadership support for new and existing entrepreneurial meeting as well as new company product introduction.

SYSTEMS ANALYST - AJILON CONSULTING AT JPMORGAN CHASE TREASURY SERVICES

(August 2009 – October 2009)

Participated in the writing use cases, perform system and regression testing, identified system changes, defect tracking issues and managed B2B & B2C Web Site functionality (WebSphere; MS Excel 2007; MS Access 2007; Mercury Quality Center; Query Analyzer 2007).

Lead the data modeling, business analysis & project management efforts. Analyzed new and existing end-user software functionality performance level.

 Generated system test scripts for different test scenarios covering all aspects of project functionality, managed QA deliverables for each new build release (SDLC; JIRA; Power Point). Performed functional, GUI, Regression, system integration, user acceptance, configuration and content testing for web-based e-commerce application.

 Review, execute and communicate final results of existing test scenarios to Project Management (Test Director, SDLC).

LEAD CHAPTER COORDINATOR AT SCIOTO RIDGE JOB NETWORKING GROUP

(December 2008 – August 2009)

Led not-for-profit educational organization offering job search training, career transition workshops, career coaching and outplacement services to experienced professionals in Columbus Ohio Metro Area.

 Increased a membership enrollment 40% within 30 days. Organized job-networking workshops, analyzed marketing campaigns, negotiate job fair’s events, along with new suggestions to advisory board and increased marketing communications & leadership for the long term viability of the organization.

QUALITY ASSURANCE ANALYST AT INFOR WEB RETAIL ECOMMERCE

(January 2008 – January 2009)

Analyzed & established system testing with business and functional specifications; liaise with developers, architects and business analysts in application design. (IBM Web Store). Resolved Retail eCommerce shopping cart cross-functional issues to ensure the highest level quality included: Monitored web site implementation activities, analyzed system changes and identified functional and user acceptance testing. (SQL Query Analyzer, SQL Server 2005, ERP Pricing) Led B2B / B2C E-Commerce Storefront Shopping Cart design walkthroughs.

 Introduced New IBM Server, verified software functionality, defect tracking, improved eCommerce shopping cart testing procedures and performed qualitative research including functional requirements for back-end of the IBM WebSphere Application.

 Created and analyzed test cases, scripts, scenarios and improved regression testing process (Excel SQL Query Analyzer). Assigned project schedule and managed Microsoft Project Server 2007 activities. Lead matrix system analysis process to identify software functionality and defect tracking issues in ERP and eCommerce IBM Web Store Applications

Business Analyst – Fast Switch Consulting at Cardinal Health

(October 2005 – July 2007)

 Increased system integration functionality by 25%, improved data quality, conducted external customer satisfaction reports, systems analysis and designed financial progress reports for project management and financial group.

 Launched new process of identifying ‘flag’ data inconsistencies, improved existing data integration methods, designed metrics scorecard analysis and increased workflow project completion by 40% (Excel 2000; Access; Visio 2007). Created new business process to ensure the existing system aligned end-user expectations (SQL 2000, Mercury Test Director).

 Performed financial data analysis, analyzed system integration functionality, provided system-generated quarterly and monthly financial reports, designed and implemented the balance score card analysis. (SQL Server 2005; Mercury Test Director).

 Initiated PeopleSoft v8.80 cross-training with department of finance, implemented elements that streamline process and improved financial reporting capabilities. Informed employees of PeopleSoft v9.0 Training Sessions.

Business Analyst – Kelly IT Consulting at Bank One GTI

(January 2000 – October 2005)

Analyze new functionality for wireless paging system. Presented wireless system workflow analysis to Global Technology Infrastructure. Introduce new wireless paging system process to secure wireless technologies. (Excel VBA, Visio, PL/SQL). Reduce data cost processing time by 30%, prevented loss of financial data and duplication during migration JPMC & Bank One.

 Increased 70 of wireless paging system functionality managed monthly financial reports including: financial statements, cost analysis, reconciliation and scheduling (Mercury Query Analyzer, PeopleSoft 8.9, SAP FI/FO, OBO 6.0, MS. Access 2003).

 Designed Access Database for Bank One/JPMC merger companies, created SQL queries, forms, reports, macros, improved monthly financial reporting process, enhanced AP / AR with new financial functions that reduced monthly processing time by 40%. Designed new requirements gathering process to provide project cost benefits analysis. (Excel 2003; Visio; Power Point)

 Integrated worldwide wireless paging systems functionality. Analyzed system functionality and explained new client specifications to internal users. Provide training in areas of wireless technology paging system process. Executed system-testing procedures and facilitated the implementation of new functionality for wireless connections between US / UK & Germany (Excel 2003, Access 2000).

Financial Analyst at Anthem Life Insurance Financial Services

Analyzed and review client requirements for G/L conversion to PeopleSoft 8.4. Participate in the full financial software migration life-cycle (CICS, PeopleSoft 8.3). Improved the existing reconciliation process by defining new requirements gathering for AP / AR functions.

 Participated in the migration of CICS JCL and COBOL to a People Soft 8.4 (G/L, A/ R, AP, P/M, P/O). Analyzed and reconciled PeopleSoft G/L; AR; AP including fixed assets, depreciations, journal entries, and generated monthly balance sheets (Excel 2000; Access 2000 / SQL Query Analyzer). Improved financial data system functionality migration within CICS Mainframe & PeopleSoft v8.4 G/L.

Financial Analyst at AEP Accounting & Finance

Optimized financial reporting operations including; accounts reconciliation; month-end closing; cost; financial analysis and systems. Analyzed, designed and improved new system process analysis between multiple projects. Skills Used: (SQL Query Analyzer)

 Increased financial reporting productivity level by 70%. Analyzed and created money-pool reconciliation process to identify gaps and inconsistencies with timeline of financial reporting submission. Provided financial support analysis for functional side of the business. Skills Used: (SAP FI / FO; Access 2000/ Excel /ODBC)

 Upgraded the existing MS Access Database and improved monthly financial reporting analysis process by developing new SQL Queries, Forms, Reports and Macros. Skills Used: (SQL Server 2000; MS Access 2000; MS Project 2003)

 Established operating metrics and dashboard reports to identify monthly variances and trends between budgets. Analyzed detailed assets; liabilities and created quarterly forecast analysis (Access 2000/SQL Server 2000). Compiled quarterly financial budget analysis using integrated links to PeopleSoft 8.3 - 8.4 A/R; A/P.

 Created analysis and ad-hoc reports for annual budgets and YTD expenses. Produced and enhanced stored procedures and ad hoc queries in SQL. Compiled consolidated financial statements and generated ad-hoc reporting. Prepared financial and income statements at the month-end closing. (SAP R/3; SAP Business Objects; DB2)

 Reduced the risks associated with project future cost, implemented change management plan to identify cost savings initiatives, maintained daily operations projects, prepared monthly expenditures and created quarterly financial reports. (PeopleSoft 8.4; Business Objects 6.0; FICO).

EDUCATION

Devry University, Columbus, Ohio

B.S. in Business Administration / Information Systems, 2004

Russian Institute of Technology, St. Petersburg, Russia

B. S. in Accounting/Finance 1993 (Honor Graduate 4.0)

Contact this candidate