Resume

Sign in

Data Project

Location:
Minneapolis, Minnesota, United States
Salary:
72000
Posted:
February 16, 2018

Contact this candidate

JANICE JENSEN

**** ******** ****. #***, ********, MN 55446

P: 763-***-**** ac4h3j@r.postjobfree.com

TECHNICAL PROFICIENCIES

Applications: Salesforce, MS Office 95/97/2000/2005/2007, 2010 including Excel, Access and Word, SQL (2005 – 2012), BI and Business Objects, Stored procs and procedures; Dreamweaver, Flash, PhotoShop 5.5 and 6.0, Oracle 8i, Windows 3.0/95/98/2000/NT 4.0/XP and Windows7 and Windows 10, SAP, ASP.Net, VB.Net, BI, SharePoint, Cognos, TOPS, TIES, PCOMM, SATS, HPSD, IEX and MS.Net 4.5 and Agile.

Technologies familiar with

Altiris, Illustrator 9, Homesite, C#, ColdFusion, Quark Xpress, WinTrac. Haven’t used in many years - Freelance Graphics, WordPerfect, CA-7, CA-11, Panvalet, Lotus SmartSuite, Novell Netware, LANtastic and NetWare.

PROFESSIONAL EXPERIENCE

Apex Systems, Contract at Wells Fargo (May 15, 2017 to September 19, 2017)

Business Analyst/Compliance

Working in Corporate, assisting in writing documentation as needed, investigating applications for viability of company needs communicating with stake holders about applications usage and if they are not being used to mark them for removal from the environment

Working in Excel to create spreadsheets to keep track of application status and also merging it with other team members information to create reports for management

Working with a team to create Test Plans and Data Testing to ensure Federal regulations

Daily team meetings to discuss any problems that may arise and to keep the team aware of the progress being made, worked with all applications for the company

Rose International, Contract at Land O’Lakes (October 5, 2016 to December 30, 2016)

Business Analyst

Working in the Dairy Foods, Research and Development - Helix project. Going over product specifications, comparing Land O’Lakes specs to their manufacturing partner’s specifications. Pointing out any discrepancies, once the partners come back with updated specifications, making a note of it.

Working with both Excel and Helix to create spreadsheets of the data that has been received and the information that is found in Helix and highlighting any differences.

Attending weekly briefings noting the status of each manufacture and their products through this project

Adding and/or modifying data in Helix as necessary

Rose International, Contract at Cargill (July13, 2016 to August 11, 2016)

Excel Analyst

Working with Plant-OPS/HR Department working on an Excel workbook that had been created but didn’t work at all.

Working with Excel and Word, going over all the formulas in the Excel workbook and correcting the formulas so that they will now work properly.

Also worked on a PowerPoint presentation to teach others how to add items into the new database

Also, worked on Pivot tables, correcting those formulas, and created new tables for reporting purposes for management

Working to create Test Plans and Data Testing for data gathered and to keep track of processes

Wrote comprehensive documentation to go along with the workbook – i.e. how to add members into the spreadsheets without altering the working formulas, if the formulas stopped working – what to look for and how to correct it

Recruiters of Minnesota, Contract at Proto Labs (May 2, 2016 to May 27,2016)

Data Analyst

Working with Marketing Department to identify potential clients.

Working with Salesforce, with both Reports and Data.com to identify and categorize data that has been entered

Aided in identifying specific groups to categorize data, then going through data and putting it into the appropriate group.

JANICE JENSEN Page 2 ac4h3j@r.postjobfree.com

Robert Half Technologies Contracting at Ameriprise (October 2014 to December 2014)

Application Developer

Developed Access database converting data from Lotus Notes, this is their Stock and trade information.

Gather, organize business requirements, and analyze data gathered as well as potential solutions

Writing Test Plans and Data Testing for the application that I had created

Used ASP.Net, SQL in the background to do complex computations for buying/selling of stocks

Wrote corresponding documentation for users and for future maintenance

Dahl Consulting contracting at Cargill, Inc., (May 2014 to August 2014)

Business Analyst/Project Coordinator

Working in the Cash and Credit Management Business Unit taking care of their mission critical daily, weekly and monthly end reports. Adding in new Business units as needed into their BI/SAP (Business Objects) systems which also use Access, ASP.Net, ETL, SSIS, SSRS, VB.Net, Visio, SQL Queries, Excel and SharePoint to keep track and manipulate data. There are daily reports that need to be run out of Access and Excel, merged, then uploaded to SharePoint, then using SAP/BI I run the other time sensitive daily reports and twice a week reports as needed. I was also responsible for re-working the documentation for each process so that it is more user friendly, they are using SharePoint for that as well.

Run mission critical Daily reports using ETL to extract data, then used SSRS to create reports for management

Reset passwords for eCredit and CA$H systems along with add new members

Work on making documentation that is easy to understand and follow

Work with the BI team regarding database performance and how top better the response and speed of it

Facilitated meeting with team members and clients as needed, took meeting notes and distributed the notes afterwards.

Entegee Engineering contract at MTS Corp. (Dec 2012 – July 2013)

Business/Applications Analyst

Worked on legacy Routine Maintenance reporting system, starting with Excel maintenance, and then progressed into creating the database in Access 2010 along with both VB.Net and SQL queries for greater flexibility. Worked with Project Managers to create reports for capturing data from the Field Service Engineers while they are onsite doing Routine Maintenance. Created reports for an accurate account of maintenance requests and history. Contract was extended, then successfully completed. Software also used: VB.Net, ETL, SSRS, HTML and SDLC.

Gather, organize business requirements, and analyze data gathered as well as potential solutions

Using ETL to extract data, then used SSRS to create reports for management

Coordinating with different departments the specific documents that Field Engineers are using, creating identical reports in Access

Used Agile for product lifecycle management.

Review and confer with management and users about format, distribution, and purpose, and to identify problems and improvements.

INT Technologies contract at Wells Fargo (October 2010 to August 2011)

Application Analyst/Project Coordinator

Utilizing Microsoft Excel and Access to create and maintain a database of packaged applications for their companywide Windows 7 project. Identifying the Line of Business (LOB) and when possible, the user contact for each program listed in the packaging database. Utilizing a virtual machine, determining if the application will be migrated to the Windows 7 platform, or if the application can be retired from the environment.

Coordinated with different departments to identify software to determine certification requirements prior to migration from Windows XP to Windows 7.

Facilitated meeting with team members and clients as needed, took meeting notes and distributed the notes afterwards.

Used ETL for data extraction, and Agile for product lifecycle management.

Designed, developed, and updated an Access database with a VBA/SQL background to track all outgoing emails and responses, improve reporting, and verification of version and viability of applications.

Perform technical review of applications submitted for packaging for Windows 7.

Demonstrated knowledge and experience working in an Agile development environment

Identify and document business requirements and manage project scope

Capture initial business request information and formulate solution direction

JANICE JENSEN Page 3 ac4h3j@r.postjobfree.com

UnitedHealth Group IT (July 2006 – April 2010)

Support Analyst – January 2009 –April 2010

Applied dynamic strategic planning, prioritization, and project management skills toward consistently achieving critical deadlines while maintaining high quality standards. Maintained full accountability for providing detailed support to the Help Desk in Security and Ticket status.

Optimized operations by diligently troubleshooting and resolving needs, including resetting passwords and facilitating team building events.

Diligently sought to achieve and surpass sales and performance goals.

Software used: Access, Visio, Agile, Excel, VB.Net, ASP.Net, Project, Visual Basic, SDLC, IEA, HPSD, ServiceWare, User SharePoint, Client lookup tool, SATS, Pass lock, PCOMM, TIES, TOPS

Sr. Business Analyst/Project Manager - (July 2006 – December 2008)

Proficiently directed all aspects of software compliance, with accountability for conducting comprehensive and detailed investigations of different applications. Strategically planned and coordinated workloads/schedules for optimal productivity and efficiency. Demonstrated strong communication and leadership skills in effectively negotiating with vendors and developing proficiencies in various applications and specifications. Using Altiris, tracked and monitored mapping licensing and titles to ensure accuracy, as well as to verify current version on hand is the latest version. Used a dashboard equivalent product. Used Access 2007 along with both VB.Net and SQL queries for greater flexibility.

Coordinated with a diverse range of different departments to identify software to determine certification requirements prior to migration into the UHG environment. Address and resolve project conflicts

Using ETL to extract data, then used SSRS to create reports for management

Experience with Agile software development methodologies.

Facilitated meeting with team members and clients as needed, took meeting notes and distributed the notes afterwards.

Demonstrated ability to solve complex business and data design issues from an enterprise perspective

Knowledge of business analysis and requirements utilizing processes such as use cases and BPM

Designed, developed, and updated an EXCEL database to track all outgoing emails and response to improve reporting, and verify compliance.

Used Agile for product lifecycle management.

Worked with other département Project Managers regarding new company acquisitions to ensure that software/ hardware needed for the new employees to function in their roles is UHG approved. Coordinating software packaging as needed and/or hardware upgrades as needed.

Gather, organize information, and analyze data gathered and potential solutions

Utilized PowerPoint, creating internal displays for projects and Visio for timeframes.

Review and confer with management and users about format, distribution, and purpose, and to identify problems and improvements.

PERSONAL DEVELOPMENT

Since 2015 I have been working on my own business – I design custom jewelry using natural stones, semi-precious stones and Swarovski crystal with gold and silver findings. I’ve been working on my own website – BaublesbyJan.com. I’ve had it published previously, currently I’m re-doing the site to include other craft work, also for photos to include in the website. I am also taking Microsoft classes that are offered – like Azure and cloud applications.

EDUCATION

B.A., Art, Renaissance Art History- University of Minnesota, Duluth

AA. Commercial Art and Graphics – University of Minnesota

PROFESSIONAL CERTIFICATIONS

Certificate of Computer Programming and Computer Operations, Control Data Institute

Certified Internet Webmaster, New Horizon’s Computer Learning Center

Completed coursework for Project Management certification Feb. 2014



Contact this candidate