We provide IT Staff Augmentation Services!

Senior Um/pm Technical Analyst Resume

3.00/5 (Submit Your Rating)

KEY SKILLS
Strong analytical ability; excellent communication, interpersonal and leadership skills; excellent organizational ability, initiative, time management and prioritization capabilities; demonstrated abilities to expand knowledge base to maintain currency with industry developments and apply new technologies to provide premium business solutions based.

TECHNOLOGIES
Lawson 8.0.2 running on UNIX, Lawson MS-Add-Ins, Business Objects 5.1.3, Business Objects XI-R2, Business Objects Supervisor, Business Objects Designer, ZABO, Crystal Reports 8.5, SQL Query Analyzer 8.0, TOAD, SAP, FTP, ETL, Payformance Check printing system, Symbol handheld terminals, Oracle, IMS SQL, FoxPro, Paradox, PL/1, C++, DEC mini, IBM VMS mainframe, Novell network, Windows NT, Lotus Notes, MS-Excel, MS-Access, SSIS, SSRS.

EDUCATION
Master of Business Administration (Graduate with honors)
BS - Computer Information Science (Graduate with distinction)

PROFESSIONAL EXPERIENCE

Confidential,TX 2008-07/31/2009
Senior UM/PM Technical Analyst
· Create SQL code used for data analysis, data extraction, and distribution.
· Created SQL code working on the Teradata financial system for government reporting.
· Coordinated and maintained FTP accounts.
· Combining internal and external data sources to provide outreach reports targeting individuals with treatable medical conditions.
· Using ETL I refreshed databases received from FTP accounts onto the SQL server.
· Create, modify, and maintain Business Objects reports detailing patient data.
· Participated in user requirements gathering and documentation.
· Provided our clients (both internal and external) with their technology deliverables..
· Took responsibility for the accuracy and quality of the work performed and took ownership of all assigned projects.
· Utilized MS SQL 2005 SSIS and SSRS tools for ETL and reporting.

Confidential,Irving, TX 2003-01/31/2008 (Laid off)
Technology Analyst II/Data Warehouse Specialist I
· Creating and scheduled Business Objects reports published for corporate use by Commercial
Loan Groups.
· Creating and maintaining Crystal Reports.
· Utilizing SQL Query Analyzer for data analysis, compliance reporting, and ETL.
· Managing users via Supervisor.
· Enhancing universes via Designer.
· Training users on Business Objects.
· Document data flows in accordance with data governance guidelines.
· Enhance and maintain the Commercial Data Mart.
· Collect and translate user requirements into project plans.


Confidential,Detroit, MI 2002 – 2003
Systems Development Specialist Materials Resource Management
· Systems conversion implementation of Lawson.
· Designed, tested, implemented, and trained inventory depot strategy in use on Lawson.
· Production support for depots and par locations implementation, monitoring, and maintenance.
· Developed, tested, and trained handheld terminal system to count and replenish hospital units.
· Identified and coordinated linking of requisition and purchase order universes for Business
Objects reporting.
· Created Business Objects reports published for corporate use by Accounts Payable,
Purchasing, and Logistics.
· Developed check print layout, interface mapping from Lawson to Payformance, and end user
training to use system.

Confidential,Detroit, MI 1995 – 2002
Project Manager -- Financial Systems
· Populated and validated Oracle Corporate financial database system.
· Documented the database read routines, sorting routines, variables, dimensions, formulas.
· Programmed, tested, debugged, and validated programs used to populate and aggregate the
a new database system.
· Coordinated departmental training of Oracle Express Analyzer.
· Developed business requirements documentation during conversion to SAP.
· Business Analyst of four source system interfaces during the conversion to SAP.
· Audited and monitored system for data integrity.
· Production support for monthly EIS reporting.

Confidential,Lansing, MI 1990 -1995
System Analyst/Programmer
· Developed a financial information database for analyzing aggregated Medicare metrics.
· Designed and programmed a database for Market Penetration reporting.
· Analyzed PL/1 programs residing on an IBM 3090 computer system used to validate hospital
inpatient data.
· Documented program functionality, data transfer, and storage media requirements
· Presented a business proposal that eliminated time shared computing costs.
· Designed a database on the fixed record layout, programmed data parsing routines to populate
the database, and programmed queries to report validation statistics.
· Successful implementation of business proposal through procurement of additional equipment
and development of pc based systems.
· Performed system backups and data transfers from an IBM AS400.
· Received a recognition award for outstanding performance and financial savings.

HONORS AND ACTIVITIES
Upsilon Pi Epsilon computing honors society, Internet #1 & #2, Novell LAN Administration #1 & #2, Team captain for Walk for Diabetes, Volunteer at Detroit Festival of Arts, Fort Worth Art Festival, member of the Community Emergency Response Team CERT.

We'd love your feedback!