SUMMARY:

• Over 20 year experience collecting and disseminating information.
• Ten years developing technical solutions wif a track record of proven results.
• Diligent, punctual, and extremely well organized.
• Strong analytical, writing, and research skills.
• Conscientious and thorough wif detail.
• Equally effective working independently and in cooperation wif others.
• Created a SQL Data Warehouse for product data wif associated tools for extracting the data from production, Data Analysis, and Reporting.
• Converted entire suite of DTS packages from SQL Server 2000 database to SQL Server 2005 and tan to SQL Server 2008 SSIS packages.
• Created Travel and Expense cube in SQL Server Analysis Services for Global Dell.

TECHNICAL SKILLS

• Programming Languages
• SQL
• SQL Server 2005/2008/2012 Analysis Services (SSAS) - - 8 Years
• Online analytical processing (OLAP) Cubes
• SQL Server 2005/2008/2012 Integration Services (SSIS)-- 8 Years
• Package Development (ETL)
• Scripting
• Error Handling
• Optimization
• Deployment
• Analysis
• SQL Server 2005/2008/2012 Reporting Services (SSRS)-- 8 Years
• Formulas
• Functions
• Maps
• Cross-Tabs
• Charts
• Sub-reports
• Parameters
• Online analytical processing (OLAP) Cubes
• SQL Server Management Studio (SSMS) -- 8 Years
• Stored Procedures
• Views
• Functions
• Indexes

PROFESSIONAL EXPERIENCE

Hanger Lead Technology Solutions Developer

Confidential

Responsibilities:

• Lead developer for Inventory Valuation System Project.
• Organized team into functional areas and assigned task.
• Developed backend logic using SQL stored procedures, functions, and views.
• Developed Models, Entities, Subscription Views and Business Rules for the purpose of identification of data, and data-reconciliation issues using Microsoft Master Data Services.
• Built Reporting Services reports for the purpose of monitoring system performance.
• Interview and made recommendations for hiring of contract resources.
• Lead global team in support of MSAS and Reporting Services environments.
• Lead major initiative to replace 100+ aging servers wif new Windows Server 2014 servers.
• Moved, upgraded and tested 450+ MSAS databases/cubes from old SQL Server 2005/2008/2008R2 environment to new SQL Server 2014 environment.
• Moved, upgraded and tested 1000+ Reporting Services Reports from old SQL Server 2005/2008/2008R2 environment to new SQL Server 2014 environment.
• Upgraded old SQL Server 2008/2008R2 SSIS packages to new SQL Server 2014 packages for the purpose of processing MSAS databases/cubes on processing servers and sync on query servers.
• Worked one-on-one wif outside vendors for installation of SAS environment, testing, and follow-up troubleshooting.
• Interview and made recommendations for hiring of contract resources.

SAI People Solutions Business Systems Analyst

Confidential

Responsibilities:

• Design, implement and maintain SQL Database.
• Design, develop and test ETL procedures in MSSQL 2000/2008 databases.
• Conduct analysis of alternatives and provide recommendations for support issue resolution.
• Handle general support duties including defect resolution and moderate enhancement work.
• Management of an issue or request from initiation through its resolution - including documentation - in a timely fashion wifin a team environment.
• Perform data loads/exports to research and identify discrepancies in data. In the event of discrepancy, work closely wif the business, to ensure reports accurately report valid data.
• Conduct performance and tuning of ETL processes and technical documentation related to same.
• Work wif project team to plan a support strategy for solutions and/or enhancements to existing systems to meet current and future needs.
• Preparing and implementation of data verification and testing methods.
• Forming and executing testing strategies to ensure data quality.
• Contract developing Reporting solutions for Encore Medical, L.P., Texas Equal Access to Justice Foundation, and Field Assets Services.
• Develop Reporting solutions in SQL Server 2005 Reporting Services.
• Create moderately complex stored procedures against SQL Server 2005 Databases.
• Develop Reporting solutions in Sql Server 2005 Reporting Services.
• Create complex stored procedures against Oracle Databases.
• Develop, Manage, Debug, and Optimize Extract, Transform, and Load (ETL) packages in Microsoft SQL Server 2005 Integration Services.
• Develop, Manage, and Administer a Data Warehouse for product analysis and reporting.
• Document procedures for launching application into production.
• Create, maintain, and test Brio Reports.
• Administration and maintenance of Brio Server.
• In service training:
• Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services - MS 2793
• Oracle DB 9i/10g: Introduction to SQL
• Introduction to C# Programming wif Microsoft .NET
• Oracle Database 10g: Advanced PL/SQL Programming and Tuning
• Optimizing Oracle SQL intensive

Create PL/SQL queries for reports in PL/SQL Developer

Confidential .

Responsibilities:

• Contract to Dell Computer Corporation supporting multi-million dollar project, performing ongoing project analysis, database improvements, quality control of data output, and overall technical resource for a team of over 100 Project Managers.
• Data import and export, and custom queries of large data sets for analysis, heavy use of MS Excel and MS Access .
• Data manipulation, data correction, and
• Custom Access database design to include table normalization and denormalization, user interface, and reports.
• Responsible for data reconciliation and integrity of data results.
• Provided data cleansing and quality verification of external customer data to reconcile against internal databases. Detect and correcting corrupt or inaccurate records from record sets to insure dat they are unambiguous, correct, and complete. Removing typos, validating and correcting values against a non list of entities insuring dat data set will be consistent wif other similar data sets in the system.
• Quality reviewed data output and provided feedback to the team individuals.
• Cross check data output against multiple teams and individuals to ensure highly accurate results in the output of analysis.
• Answered management questions on progress and project status.
• Assisted in the development of project tools and provide tool enhancement guidance.
• Gather business objectives, drive to define specific reporting needs to meet objective. Including order, service and warranty data needed for executive decision making and strong business decisions based on analysis.
• Modify existing reports to include addition of new features, additional data, re formatting.
• Automate existing reporting processes using VBA in excel and access.
• Validate and QA reporting deliverables. Conduct further investigation of any data anomalies.

Confidential

VBA Developer

Responsibilities:

• Developed and debugged complex applications using VBA code, including extensive work wif Excel and Access object properties and methods.
• Support and maintain existing Access and Excel reporting applications.
• Modified, tests, and debug complex reporting applications distributed across multiple files.
• Develop Excel data-related worksheet functions both programmatically and through worksheet formulas.
• Utilized internal or external information to resolve technical issues.
• Utilize standard structured programming concepts and system development methodologies to create professional applications.
• Analyze and comprehend complex process flows dat combine multiple Access/Excel files.
• Design and creating Access tables, forms, queries.
• Utilized T-SQL, normalization, and other key database concepts.
• Utilized ADO or DAO.
• Design, develop, test, implement and maintain reporting solutions using the Crystal Reports 9.0 environment.
• Configure reports to meet multiple business rule and system constraints. Develop test plans and evaluates results, write program specifications and code.
• Analyze, design and validate system requirements for new and/or existing reports, determine design alternatives and implement appropriate technical solution.
• Reports were written and tested against Microsoft SQL Server 2000
• Maintained an accurate, up-to-date inventory control system, receipts, lost deliveries and other transactions on a daily basis.
• Maintained a perpetual inventory system ensuring the inventory is completely counted four times annually.
• Assisted wif department administrative functions and wif paper work. Assisted in receipt of parts, verifying wif order before placing in stock.
• Assisted in other inventory control department duties such as receiving, filing, invoicing, and shipping parts orders.

Confidential

Quality Data Analyst Intern

Responsibilities:

• Collect, screen, and analyze air permit data from diverse sources.
• Use Data Transformation Services (DTS) in migrating from one database system to another. I have also used DTS tools for consolidating excel spreadsheet from different sources into a single database.
• Develop document, and monitor air permit data.
• Design, develop, test, implement and maintain reporting solutions using the Crystal Reports 9.0 environment.
• Configure reports to meet multiple business rule and system constraints. Develop test plans and evaluates results, write program specifications and code.
• Analyze, design and validate system requirements for new and/or existing reports, determine design alternatives and implement appropriate technical solution.
• Used of SQL in testing my Crystal Reports to see dat the information dat I want going into the report is correct.
• Provides systems support for the Air Permits Division on automated data processing equipment and software.
• Supports various databases, including the Title V and New Source Review Integrated Management System, using various software to establish web based computations and logic operation; and to sort, develop search criteria, and manipulate data from existing databases.
• Maintains security control over data processing software, databases, hardware, and related materials.
• Interacts wif agency and division staff to establish processing priorities and explain the capabilities and limitations of available software and hardware, and provides training and operational assistance to division staff in the utilization of software.
• Maintains procedural manuals, documentation, activity logs and reports, and distributes as needed.
• Assists in troubleshooting and solving computer-related problems and providing assistance to end users on the use and interface of systems and software applications such as databases, Web browsers.
• Supervise staff in the role as a senior officer.
• Perform all functions of a corrections officer in a large correctional facility, including care custody and control of inmate population.
• Provided pro-active counseling to inmates significantly reducing complaints and minimizing liability.
• Investigate, resolve and report situations of criminal activity and violations of facility rules.
• Supervises scout sections and squads.
• Directs tactical deployment of section and squads in combat.
• Supervise maintenance of assigned vehicles and equipment.
• Collect, reports and evaluates accuracy of intelligence information.
• Direct reconnaissance of fording sites, tunnels, and bridges.
• Direct route / area / zone reconnaissance at section level.
• Coordinate action of vehicles wif platoon and supporting elements.
• Evaluate terrain, selected routes, assembly areas, firing positions, and positions for combat operations.
• Supervise construction of hasty fortifications.
• Supervise section and squad resupply of class I, III, and V.
• Train scout section.
• Coordinate requirements for organizational maintenance.
• Conduct scout section drills.
• Served as an Operations Assistant in the squadron/battalion or higher-level staffs and as Operations NCO at troop level.