PROFESSIONAL HIGHLIGHTS:

• Proven capabilities as a Database Developer/ Data Analyst, Reporting Analyst for UNIX, DOS, Windows 2000/XP, IBM Mainframe, JCL Job Control Language, Burroughs Unisys Clear-Path A series 47.1, MCP Master Control Program, COMS Communications Operating System, Dargal, Ergo, CANDI Text Editor, and WFL Work Flow Language .
• Familiar and experienced in the use of the Institute of Electrical and Electronics Engineers IEEE and Capability Maturity Model CMM Standards and guidelines, Auditor/Lead Auditor with ISO 9000 background.
• Excellent team player with the ability to lead and manage groups of skilled professionals through tough and time-sensitive assignments.
• Familiar with Change Management investigation of organizational changes in the event of major system changes such as additional patches to servers, software upgrades, etc. Also, expose to approving s and receiving approvals from the Change Management team.
• Knowledgeable of Project Management budgeting and scheduling.
• Familiar and experienced with MS Project PMBOK Project Management Body of Knowledge, NIKU, ADT, Microsoft Visio, and Metric and Modeling concepts.
• Knowledgeable of Business Intelligence working with Crystal Reports Business Objects Repository, creating Views and Universes, and OLAP reporting. All while insuring data integrity.

TECHNICAL SKILLS:

PROFESSIONAL SUMMARY:

Report Analyst

Confidential

• As a PL/SQL report developer for Blue Cross Blue Shield, creating ad-hoc reports on demand as requested.
• Oracle 11g Data Warehouse and MS Access 2013 environment, also performing:
• Data Analysis
• Created temporary tables and Updated data. using Oracle export and import features to create reports
• Created Queries using Oracle, Access, PL/SQL, MS Excel, SAS and the Data Warehouse also to create reports.
• Created Functions to return the single values of data types to obtain data descriptions.
• Created Indexes on temporary tables for optimal query performance.

Techical Support Analyst

Confidential

• Providing Password changes, Fax application monitoring, and technical support for various clients and off-shore. Using SQL Server and Oracle, My SQL, T-SQL, and Unix environment. In support of sensitive medical data for United Health Care and various other Health Care Providers.
• Hosted files and reports to websites
• Monitored Servers Storages
• Updated, Deleted, and Maintain PDF files
• Performed Problem solving, following-up, and closing request on the in-house request system.
• Monitored web-application certificates for renewal.
• Loaded zip-code .csv files each month into the Unix systems common drive for the availability all users as needed.

Programmer II

Confidential

General Motors

• As a Programmer for Milford and Pontiac Powertrain:
• Collected and translated requirements into technical specifications for the enhancements to the On-Line Data Book OLDB application and designed prototypes for each requirement.
• Collected requirements and translated to technical specification for designing the prototype for the Issue/Work Request IWR application that replaced the Yellow Book request application that will work parallel to the Online Data Book application.
• Interviewed the SMEs for both the On-Line Data Book and the Issue/Work Request applications.
• Created the Application Design documentation.
• Built and updated the interface for GM Request Test tracking application IWR Issue/Work Request and linking it to their On-Line Data Book application OLDB using SharePoint 2010 and XML.
• Started performing enhancements and upgrading the OLDB Online Line Data Book application using C .
• These tasks were being performed under Agile Methodology for General Motors Powertrain Division using Microsoft Visual C 2010, Microsoft SharePoint 2010, XML, Crystal Reports XI, and Microsoft SQL Server Database 2008 r2, added fields to tables, Created tables, Indexes, Workflows, triggers, and functions to support the application new data and functionality .
• Created tables and updated tables within the MS SQL Data warehouse T-SQL .

Consultant

Confidential

Ford Motor Company

• As a Practitioner IT for Stamping Engineering in Production Support role:
• Provides problem solving solutions.
• As a Data Analysis interfaced with various support Ford Motor Company internal IT support teams, to push software updates and enhancements in Java and other programmable software.
• Support in incident resolution, security audit and customer request fulfillment manufacturing applications within agreed time limit working with off-shore customers as well.
• Following Ford Motors SDM, Agile Methodology, Six Sigma, BMC Remedy Service Desk application and familiar with ITIL.
• Created RFP and Technical Documentation for each COTs application and created User-Documentation for applications where the documentation did exist. Supported information within the documentation by creating queries and functions using Oracle 11i PL/SQL.

Consultant

Confidential

As a Business Analyst, part of the Project Management Organization PMO , for ITC, prepared project proposals to meet budget approval for 2012and 2013.

Prepared:

• the Project Request document,the Technical Review document, and the presentation, with the help of the requesting SME's to presented to ITCs Governance Committee for the project approval while collecting the requirements for each project.
• Using SharePoint 2007 and 2010 track documents and presentations.
• Prepared other project documentation such as, Technical Requirements Documents.
• Assisted in preparing for the NERC Cyber Security audit in August, by verifying required processes and reports were in place.
• Gathered requirements for Corporate Security Application Rescue project.
• Interviewed the subject matter experts to receive complete requirements descriptions
• Tracking module approvals.
• Creating Corporate Security Application Requirements Documentation, to meet CIP compliance Federal Standards.
• Gathered requirements for Work Management System Enhancement project.

Confidential

Application Support Analyst

• Pursued upgrade of Recon Plus Reconciliation Application Software and MS SQL Server Database 2000 to 2008r2.
• Upgraded Recon Plus Reconciliation Application in test environment and MS SQL Server Database 2000 to 2008r2 in an test environment.
• Perform unit testing in test environment.
• Perform ETL task to the data, after the Database upgrade.
• Created an independent process to processes in conjunction of the Recon Plus Application.
• Created an Access 2003 Database that would generate an Excel spreadsheets having a pivot tables.
• Performed UAT testing for the Recon Plus Reconciliation enhancements.
• Seeking full time employment.
• Pursing certifications through New Horizons. Microsoft SQL Server Developer and DBA Certifications .

Crystal Reports Analyst

Confidential

• Supporting ASC Saleen /Ford Motor Company:
• Created Crystal Reports as requested using Crystal Report 8.5 and MAS 4.05/200. Created tables and added Indexes as need for performance.
• Modified and recreated, existing Crystal Reports for the Financial, Inventory, Sales, and Sales Order modules within the MAS Dashboard Financial system.
• Prepared for an upgrade of the MAS system and Crystal Reports to XI.
• Participated in setting up the business views and universe deployment, and created OLAP reports through the use of Store Procedures.
• Moved data from MS Access database to MS SQL 2005 database by creating packages of data and performed UAT testing and perform ETL task as needed.
• Participated in suggestions to improve work processes.

Technical Environment: Crystal Reports, MAS, MS Access 2007 PL/SQL, T-SQL, and SAS.

MS Access/ Crystal Reports Developer

Confidential

• Created reports which combine data from multiple data sources.
• Designed, created, implemented, modified, and maintained and supported existing reports.
• Worked with management and subject matter experts to help define new reporting requirements.
• Schedule and/or deliver reports based on the specified timetable Daily, Weekly, and Monthly Data Staging in a data warehouse environment.
• Created Excel spreadsheets
• Worked with internal customers to identify data parameters.
• Using Crystal Report, MS Access query and report development on DB2 Server, and Hummingbird's data-staging and data-warehouse.

Application Support Analyst

Confidential

• Supported new and existing clients in a debt collections environment using Ontario Systems software solution for collections and accounts receivables, Artiva Agency/Legal modules.
• Team player in the set- up of Ontario Systems Legal module performed data analysis and using SQL Triggers for Dialers and Store Procedures, performed UAT and Integration testing within Ontario Systems application.
• Documented new and existing processes for clients in Michigan, Ohio, and Pennsylvania.
• Created user/system documentation for processes.
• Created general Artiva proprietary scripts using Artiva Studio.
• Using SQL Server 2005 created SQL query statements and adding Indexes to tables using Artiva Workstation and Cache database.
• Created Crystal Reports X to support reporting
• Collected and analyzed requirements, and created import and export interfaces for clients.
• Introduced and set-up Microsoft Project 2005 for new and existing client projects.

Technical Environment: Artiva Studio, Crystal Reports X, Microsoft Project, OLAP, SQL 2005.

Application Support Analyst

Confidential

• Supporting the Information Technology Services Department:
• Supported the administration in creating reports on demand in Crystal Reports 8.5, created stored procedures and views using MS SQL 7.0/2000 database, SSAS ,and Visual Basic 6 for the Unicenter Service Desk application.
• Technical Environment: Crystal Reports 8.5, MS SQL 7.0/2000, SSAS, SSIS, OLAP, Unicenter Service Desk, and Visual Basic 6.
• Supporting the Building and Safety Department:
• Provided support for mapping and extracting data exporting the data in a zip files from the DB2 database to Oracle 8i database Importing data by using the SQL Loader and the insert, update, and load data commands during the implementation of the TIDEMARK Permit Plan 2000 application.
• Created reports as requested using DB2 database, XGEN, COBOL, and XGEN Designer.

Technical Environment: DB2, Oracle 8i, XGEN, COBOL, XGEN Designer, COMS, WFL, CANDI, Unisys Clear-Path A series.

• Supporting the Consumer Affairs and Building and Safety Departments:
• Served as a Liaison during the implementation and upgrade of the TIDEMARK Permit Plan 2000 vendor application.
• Tracked hardware requirements, and analyzed and monitored data conversions according to the project plan.
• Assisted in Oracle 8 database loads, Importing data by using the SQL Loader and the insert, update, and load data commands and upgrades Oracle 8, 8.5 to 9i.
• Informed and received approvals from the Change Management team for major changes to hardware, software, and business processes.
• Performed enhancements, created technical/procedures documentation, scripts and reports using VB 6.0, Crystal Reports 7.0/8.0/8.5/9.0, Oracle 8.5/ 9i, PL/SQL and MS Word.
• Created tables for Oracle 8.5 database, altered tables, assigned permissions to users, performed backups and recoveries, and created indexes.

Technical Environment: Visual Basic 6.0, Crystal Reports, Oracle 9i, PL/SQL, OLAP, MS Word, and Microsoft Project 98

• Supporting the Public Works Department:
• Supported their web application using Visual Studio, Crystal Reports 9.0, and as a SQL Server Developer, created Stored Procedures and Views, SSAS, SSIS, perform UAT and integration testing, and Microsoft SQL Server 2000/2005. This application sat on HP server.
• Built and modified screens and reports using HTML, XML, XSLT.
• Created tables for Microsoft SQL database, altered tables, assigned permissions to users, performed backup's and recoveries, and created indexes.
• Technical Environment: Visual Studio, Crystal Reports 9.0, SQL Stored Procedures/Views, SSAS, SSIS, Visual Studio , .Net, Visual Source Safe, OLAP, HTML, XML, XSLT, and Microsoft SQL Server Developer 2000/2005, Microsoft Project 98
• Supporting the Planning and Development Department:
• Supported their web application using DreamWeaver 2000, Crystal Reports 8.5, SQL Stored Procedures and Views, SSAS SSIS, SSRS, and Microsoft SQL 2003 Server.
• Built and modified screens and reports using HTML, XML, XSLT.

Technical Environment: DreamWeaver 2000, HTML, XML, XSLT, Crystal Reports 8.5, SQL Stored Procedures/ Views, SSAS, SSIS, SSRS, Visual Source Safe Microsoft SQL 2003 Server Database, HP server, and SAS.

• Supporting the Administrative Hearings Department:
• Supported their web application using DreamWeaver 2000, Crystal Reports 8.5, SQL Stored Procedures and Views, SSAS, SSIS, and Microsoft SQL 2003 Server.
• Built and modified screens and reports.

Technical Environment: DreamWeaver 2000, Crystal Reports 8.5, SQL Stored Procedures/ Views, SSAS, SSIS, Visual Studio, Visual Source Safe, and Microsoft SQL 2003 Server

• Supporting the Municipal Parking Department:
• Supported their web application using Visual Studio, Crystal Reports 9.0, SQL Stored Procedures and Views, SSIS, SSAS, and Microsoft PL/SQL.
• Built and modified screens and reports.
• Prepared data mapping, data loads, analysis, connectivity, and implementation of the Meter Maid's hand-held devices.
• Created system and user documentation for the future implementation of the DPD Detroit Police Department lean hand-held device.
• Created tables for Microsoft SQL 2003 Server, altered tables, assigned permissions to users, performed backups and recoveries, and created indexes.

Technical Environment: Visual Studio, Crystal Reports 9.0, Stored Procedures/ Views, SSAS, SSIS, Visual Studio, .Net, and Visual Source Safe.

• Supporting the Finance/Treasury Department:
• Served as System Administrator on the Centralized Unclaimed Escheat system. Escheated unclaimed property files annually and semi-annually to the State of Michigan, using XGEN, XGEN Designer, DMSII, COMS, WFL, CANDI, Unisys Clear-Path A series, Oracle 9i, Cypress, and electronic data exchange.
• Documented, maintained and enhanced the application test models/online application, security measures and retention dates, and modified and created new files. Maintained communication with clients to make changes in requirements specifications and changes to the business process.
• Built and modified screens and reports, online applications, processes and other documents per service request specifications using COBOL 74, XGEN and XGEN Designer DMS II and DB2.
• Generated internal service requests and document enhancements to applications and interfaces.
• Maintained application testing models.
• Monitored data conversion based on system specification and change management, and recommended effective programming strategies.
• Maintained team morale through communication, one-on-one interaction and coaching and mentoring.

Technical Environment: XGEN, XGEN Designer, DMS II, COMS, WFL, CANDI, Unisys Clear-Path A series, Oracle 9i, Cypress, EDI, COBOL 74, DB2

• Supporting the Law Department on the Departmental Re-Engineering Project:
• Analyzed and documented procedures pertaining to the Legal Edge software application for the present and future training purposes.
• Interviewed and analyzed each division's business processes, and made suggestions for efficient and effective work processes using Microsoft Visio.
• Created tables for Microsoft Access database, altered tables, assigned permissions to users, performed backups and recoveries, and created indexes.
• Team player in the set- up and launch of an EDI process between Legal Edge for exchange of data between the City of Detroit and the court systems using SQL Triggers and Stored Procedures.

Technical Environment: Legal Edge, Visio, Microsoft Access, Microsoft Project 98

• Supporting the Mayor's Office:
• Collected, interpreted, analyzed and organized data utilizing IMS, DMS II and DB2 databases.
• Consulted with various departments necessary to prepare requirements and specification documents for the Empowerment Zone project.

Technical Environment: IMS, DMS II, DB2