Business Analyst Resume Profile
TN
OBJECTIVE: To secure a position that will utilize my experience and training, and increase my knowledge and technical
skill sets.
SPECIAL CLASSIFICATION: Possess Government Secret Security Clearance
SKILLS:
SOFTWARE/ HARDWARE DATABASES/ OPERATING
TOOLS PLATFORMS LANGUAGES SYSTEMS
- SAP Business Objects SQL 2008 R2/2005/2000 SQL, ACCESS, SQL 2000/2005/2008
- TOAD, JURIS, SSRS, Report Builder, Oracle 8i 9i, WindowsXP/NT/2000/98
- Hyperion, McAfee, SYS 32/36, PL/SQL, CICS, UNIX,AIX,MS/DOS,
- Microsoft Access, Excel, Digital 6300, Informatica ETL , MVS, VSAM, VAX
- Winrunner, Loadrunner SQL Server PROGRESS, COBOL, ICCF, TCP/IP
- Lotus Notes, AT T 8360 C, C , SSIS SAP Data Services
- Outlook, Test Director RISC 6000, AS400 Data Integrator
EXPERIENCE:
Confidential
Database Systems Analyst
Responsible for database maintenance and support for all company operations. Responsible for all ad hoc reporting, customer invoices and KPI reporting.
Confidential
Systems Architect
Worked for a major logistics carrier to design and build a data warehouse to equip the Transportation Operations Division with a centralized data mart to meet their financial reporting, data analysis and trending needs. Responsible for a lead role in gathering requirements, database schema design, modifying stored procedures, and developing SSIS packages on a SQL 2008 R2 platform using Business Intelligence Visual Studio and SSRS / Report Builder 3.0. Trained Operations Division on database and data querying tool in Jacksonville FL.
Confidential
Systems Engineer ADE
Worked with Confidential Recruiting Command to redesign several DoD databases. Responsible for requirements gathering, legacy system analysis, database scheme design, documentation, development and implementation of new databases to satisfy the reporting and Business Intelligence needs of the Confidential Naval NRC. Designed on a SQL 2005 Server platform with SAP Business Objects, Universe Designer, Data Services DI/DQ, Web Intelligence, Crystal Reports and other tools. Responsible for the design and implementation of ETL processes using SSIS and SAP Business Objects DS/DI/DQ. Participated regularly scheduled meetings, some virtual, in collaboration with other team members to produce an Authoritative Data Environment.
Confidential
Data Analyst
Worked with existing relational databases grasp complex business rules and interpret client requests in order to extract, manipulate, format and present meaningful results. Modify and/or rewrite procedures to reproduce reports after server migration. Also, work with DBA to design and implement imports and extracts in SQL and Access 2003 used ETL tools DTS, SSIS, and WSPro ftp to monitor scheduled file transfers research, reconcile, and correct dropped records. Hands on experience using SQL and Access importing, exporting, and applying data rules demonstrate the ability to write specs for complex projects a basic understanding of web design and website security. Manage security access for web users. Create Data Repositories for migration databases.
Confidential
Programmer Analyst/ETL Specialist
Designed and wrote scripts and procedures using SQL and PL/SQL to perform ETL tasks for a new Data Warehouse. Tested database data after loading. Created Metadata Repositories.
Confidential
Business Analyst OnQ PMS Development Testing
Responsible for application testing for the OnQ PMS Development team to provide quality assurance and a defect free business tool for the Hilton Brand Hotels. Used WinRunner, LoadRunner and Test Director in system development testing. Tested software before release to Hotels Brands.
Confidential
Report Developer
Designed and developed reports using Hyperion/Brio to extract data from the SQL database and reproduce it in a series of reports.
Confidential
Data Quality Analyst
Responsible for the data integrity and timely data reporting to all clients and vendor partners. Assisted in the design of the database and data models. Assisted DBA in database management as requested in a high availability production environment. Used Oracle administration database query tools. Designed procedures to test Oracle database tables, new applications, custom client reports and data models for ERP systems to ensure data quality. Updated data warehouse using ETL tool Informatica . Monitored the loading process and accuracy of data in data warehouse. Assisted with data requests from corporate and field colleagues, liaison between JURIS Programming Dept. and Data Warehouse Dept. Developed and maintained balancing reports and procedures. Wrote scripts in SQL and PROGRESS in UNIX/AIX environment. Tested SQR reports. Previously, supported JURIS claims software. Used SQL and Access to extract and manipulate data for reporting.
Confidential
Technical Service Representative
Supported hardware systems using UNIX, RISC 6000, AS400, SYS 36, Windows 95/98 and LAN/WAN via telephone. Analyzed and resolved issues related to personal computers and associated peripherals i.e., printers, modems, and networking equipment .
Confidential
System Manager/Data Processing Specialist C
oordinated and administered all phases of data processing using MVS/VSAM and MUMPS. Upgraded and maintained all computer hardware and software. Installed new software releases. Conducted user-training sessions of entire staff.
NON - TECHNICAL EXPERIENCE:
Confidential
Terminal Trainer
Responsible for all training of all employees to achieve Corporate, District and Local training goals. Research, design and develop new training initiatives. Supervise all terminal employees and operations including loading of passengers, luggage, freight, coordinating drivers with schedules, and monitoring arrivals and departures for needed connections . Handle and resolve customer concerns/issues as well as other terminal problems. Developed training databases in Access.
Confidential
Owner/Senior Partner
- Maintained the continuity of all aspects of small business operations including designed, developed, and implemented new procedures for more efficient operation. Developed marketing strategies to increase customer base. Negotiated contracts. Acted as financial manager/planner. Hired and directed all employees and vendors for timely production.
- Completed PL/SQL test for Oracle OCA/OCP certification. Presently, I am testing for an Oracle 9i DBA OCA/OCP Certifications. I completed the Brainbench Oracle PL/SQL exam, I scored proficient 2.83 higher than 66 percent of all examinees. Also, working on SQL Server 2005 MCTS Certification.
