Sr. Systems Analyst Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Siena Shacreaw

309 Partridge Drive

Waynesboro, PA 17001

(Cell) 717-658-9876

siena.shacreaw@hotmail.com

Clearance:              Active Secret

Education:             Bachelor of Science

Information Technology w/ Business

Juniata College, Huntingdon, PA

Graduated - May 2003

Master’s Certificate

Business Analysis with emphasis in IT Project Management

Villanova University – Online

August 2008 – January 2009

Experience:           

Sr. Systems Analyst/Data Architect

                                General Dyanmics, Fort Detrick, MD

May 2011 – Present

·         Created data models to reflect physical and logical database schemas

·         Created Oracle/MS Access based data dictionary for the JMAR Application

·         Performed data mapping of CUD web services between the XML result set and the physical database schema

·         Created data models for CUD web services using ERWin

o    XML Physical schema to show the physical XML element name and metadata

o    XML Logical schema to show a more business-friendly structure of the XML files

o    Database physical schema to show all tables involved in the creation of the XML result sets

·         Interfaced with development staff to ensure accuracy of maps and models

·         Reviewed UDR (Universal Data Repository) ICDs

·         Reviewed DMLSS Prime Vendor Gen IV documentation

·         Reviewed JMAR Facility Management ICD

·         Worked with Informatica B2B XML translation software

·         Reviewed CUD system ICDs

Database Developer

                                Keya Consulting, Fort Detrick, MD

October 2009 – May 2011

·         Develop databases to solve business requirements

·         Map data flows to assist in project management

·         Identify project timelines and critical paths across multiple functional areas

·         Manage existing database systems in SQL Server, MS Access and Sybase

·         Breakdown business processes and automate existing manual tasks

·         Write VB to assist in process automation

·         Analyze data from numerous source systems and find relationships

·         Write data mining routines to provide reports to upper management

·         Administer web-based accounts

·         Provide other technical support as needed

Functional Analyst 2

                                Akimeka LLC, Fort Detrick, MD

February 2009 – October 2009

·         Managed projects from the requirement gathering point through to production testing

·         Wrote complex SQL to solve business queries

·         Compiled data for JMAR project

·         Functioned as a JMAR ETL developer for JMAR interfaces

·         Reviewed JMAR application features versus specification document

·         Worked as the database expert with the netcentric proof of concept team

·         Wrote PL/SQL to develop stored procedures and packages

·         Programmed in VB to allow flexibility of procedures and data flow

·         Used Access extensively to easily query amongst multiple systems

·         Worked as a data sourcing analyst on Government deliverables

·         Tracked armed services medicine across the world

·         Held user group conference on current version of software to track armed services medical supplies

·         Worked on system sustainment

·         Developed ad hoc reports for various users when canned reports don’t fill requirements

·         Mapped new data feeds into existing data structures

·         Ensured data integrity based on business rules

·         Clearly translated business rules into requirement documents

·         Worked with developers to build Interface Control documents

Database Analyst 2

                                Manitowoc/Grove Crane Group, Shady Grove, PA

August 2007 – February 2009

·         Performed upper level analysis for Director and VP level clients

·         Collected data from multiple interfaces to write analytical reports

·         Managed multiple IT projects for the Purchasing Department

·         Worked as IS Customer Liaison to help schedule, prioritize and manage IS Requests

·         Developed databases to meet business requirements

·         Wrote VB programs for more functionality within MS Access

·         Analyzed current systems to ensure they follow business rules

·         Ensured data integrity throughout systems

·         Coordinated data cleanup exercises in Oracle, Informix, and MS Access

·         Created process to handle all Supplier Quote Requests

·         Began data scrubbing for migration to SAP

·         Began data mapping between two separate CRM systems for migration to SAP

·         Worked as the Small Business Liaison Officer to ensure our government contract program continues

·         Attended small business matchmaking events to develop relationships with suppliers

·         Developed process for handling small businesses that will pass government auditing

·         Worked in multiple locations with different systems and user groups

·         Worked across a number of departments to help with data reporting needs

·         Worked as IS Liaison between IS and Purchasing to facilitate the purchasing department requests

·         Worked with the Purchasing functional area to understand their technical needs and develop business processes

·         Worked closely with IPD/NPI teams to develop reports and programs to help track cost and margins

Programmer 2

                                Dietrich Industries, Blairsville, PA

August 2005 – August 2007

·         Developed programs with Progress V9

·         Designed and modify databases to meet the goals of business processes

·         Managed a number of large projects from planning to delivery

·         Worked with users from all levels of the organization to develop tools beneficial to the company

·         Ensured that all programming changes are recorded properly for SOX compliance

·         Built GUI’s and reports from many databases

·         Organized data from many databases to develop programs and reports

·         Worked both alone and in a team environment to meet goals of assigned projects

·         Developed company-wide product costing on over 3,500 items to develop margin analysis

·         Developed product specification documents using PDF Include within Progress to be sent to customers when they receive quote submittals

·         Wrote numerous margin reports based on product costing to help senior management make decisions on cost of our entire product line

·         Used Webspeed to develop web pages linked to our intranet

·         Used appservers within Progress to access data across multiple databases

Data Analyst

MxEnergy Inc., Annapolis Junction, MD

May 2003 – August 2005

Independent Consultant

August 2005 – January 2007

·         Worked as a part of a small IS team to maintain data in a data-intensive environment

·         Worked as migration lead and as part of multiple data migration teams

·         Member of steering committee when choosing new CRM system

·         Worked with Oracle 9i, SQL Server 2000 and MS Access to develop reports and programs

·         Wrote VBA to develop front ends for back ends to multiple platforms

·         Performed QA for CRM to ensure that specifications were met and any bugs were reported

·         Distributed tasks among 6 employees to ensure timely turnaround

·         Performed performance evaluations on 6 team members for upper management

·         Used my strong skills in SQL to ensure data integrity and provide complex reports to corporate heads

·         Developed and maintained multiple database systems

·         Wrote VBA to develop functions or modules for database manipulation

·         Assured data integrity to help keep MXEnergy running on a daily basis

·         Saved company from $5,000 to $25,000 on a weekly basis by developing auditing systems

·         Trained end users on how to use newly developed databases and features

PC Technician

Juniata College, Huntingdon, PA

August 2000 – May 2003

·         Worked troubleshooting PC and Network issues within school’s infrastructure

·         Implemented license management software to keep track of all software on college owned computers

·         Worked phone support as needed to walk users through computer and network issues

·         Utilized active directory to manage user groups, permissions, and software installs

·         Worked on major upgrade projects for the school during summer internships

Skills:                      Hard skills –Oracle 9i, Oracle 10g, Pervsasive, SQL Server 2000, SQL Server 2005, VB, MySQL, Baan, Informix, Progress V9, Webspeed,  MS Access, MS Word, MS Excel, PowerPoint, Dreamweaver, Java, C++, Discoverer, TOAD, XML, HTML, JavaScript, Data Migration, Data Integrity, Hardware setup, Hardware installation, Software installation, Network troubleshooting, Mac OS X troubleshooting

                                Soft skills – Team Leadership, Presenting, Assigning tasks, Communication (Oral and Written), Multitasking, Logical thinking, Problem solving, Organization

Awards                  Smaltz Achievement Award – May 2003 – awarded to one senior for overall career excellence

                                All-conference offensive lineman – November 2002 – awarded all conference honors

                                Ray A Kroc Youth Achievement Award – June 1999 – awarded for leadership

Download Resume Format