PROFILE

• Provides business intelligence solutions on reporting with visualization, data integration and feeds, data analytics, data encryption/decryption, scheduled secured data push/pull between in-house and hosted applications/data, GPS data crunching, and data migration. Has proven ability to manage internal BI projects with service providers by utilizing tools to architect and schedule processes, encrypt/decrypt feeds, and securely push/pull feeds. With proven success in a high demand environment, managing and delivering simultaneous multiple projects, in spite of technical issues. Effectively interacts with all levels of management of both corporate and vendors.
• Efficiently administers and manages SQL Server instances and databases. Hardens SQL Server instances by heightening security, designing disaster recovery, high availability, resolving disk space issues, performance tuning, and implementing best practices. Mentors junior DBAs. Works and consults with a wide array of industries including manufacturing, insurance, tax revenue and accounting, consulting, telecommunications, transportation, retail, inventory, etc. for companies including Intel, GE, JP Morgan Chase, TRW, Sprint, and iGate, among others.

TECHNICAL SKILLS / KEYWORDS

PROFESSIONAL EXPERIENCE

Confidential

• SQL DBA/BI Architect SQL2012/2008R2, VS2008/2010, iDashboard, SQL Monitoring/Performance Tools, PGP
• Transform/harden SQL Server instances/databases by implementing best practices and excellent documentation.
• Manage SQL data operations and database administration of SQL Server instances/dbs and mentor junior DBAs.
• Manage backup, disaster recovery, data security, high availability, and mirror/cluster/failover.
• Design/Create automated disaster recovery tests saving significant man-hours every month.
• Monitor SQL Server/databases and resolve performance/IO issues. Create PowerShell scripts for checking servers.
• Improve SQL performance tuning as much as 400 . Optimize/design data models, and SP/SQL scripts.
• Redesign db objects to improve SQL queries as much as over 2000 and lower index size as low as 20 .
• Fully integrate disparate systems with SQL Jobs/PGP-encryption/FTPS with vendors saving 100's of hours/month.
• Migrate legacy data and develop data mapping/ETL validation. Interpolate GPS data/improve GPS data quality.
• Design/Create dashboards/reports utilizing various data presentations/visualization saving 100's of hours/month.
• Manage development of SSRS and Crystal Reports using stored procedures and SOX-compliant.
• Design forms including business rules, approvals, recipients, workflows, and integration to existing systems.

Confidential

• SQL DBA-BI/Web Consultant SQL2008R2/VS2008, C /VB/ASP.NET, ComponentOne, SSRS/SSAS/SSIS/SSMS
• Designed data models created stored procedures and SQL scripts. Implement performance and index tuning.
• Managed and implemented creative solutions to integrate data between systems and improve GPS data quality.
• Developed data mapping and ETL validation. Interpolated available GPS data to fill missing location info.
• Migrated Access db to SQL2008 R2. Scrubbed data to improve data quality, and addressed data integrity.
• Designed/Created complex financial/inventory reports with subqueries, SP, and parameters.
• Created webpages using VB/C .NET and with ComponentOne for more robust functionality.

Confidential

• QA Consultant Web/DB2/UDB Query Analyzed and validated data/content, business requirements, functional req, and specifications.
• Designed/created test requirements, test cases, test sets, and test data.
• Verified SQL queries pulled correct result sets. Improved query for better performance.
• Created reusable components saving 100's of man-hours. Ensured TS E2E/Use Case scenarios succeeded.

Confidential

SQL DBA /QA Manager

• Administered Oracle/SQL dbs SQL optimization/performance tuning resolved issues/incidents quicker than SLA.
• Managed HP AssetCenter AC QA team created testing processes leveraging team efficiency to 200 .
• Created /Administered SharePoint intranet to increase productivity and enhance team collaboration and doc mgt.
• Developed data integration of new/legacy systems and MicroStrategy reports that improved team collaboration.
• Analyzed complex network infrastructure data from HP Discovery, validated data quality, and created mgt reports.
• Deployed/Configured AC system and Oracle 10g client on users. Improved AC Dev/Test/Breakfix/Training config.

Project Manager/ SQL DBA

• Managed, directed, and led systems analysts to support 10 Customer Life Cycle applications.
• Planned/directed activities. Engaged fix agents to resolve priority issues, analyze root cause and reduce downtime.
• Administered Oracle/SQL dbs SQL optimization/performance tuning resolved issues/incidents quicker than SLA.
• Improved/streamlined processes by 367 developing PL/SQL and DTS jobs/stored procedures.
• Designed and created management reports Oracle, VBA/VBScript, MicroStrategy, Excel for VP/project director.

Confidential

Data Warehousing Lead Analyst/ DBA

• Responsible for successful daily data warehouse database transactions Informatica, Oracle, DB2, SAP . Ensured the project completed on time and within budget.
• Designed and developed data models, updated schema and tables to resolve quality issues on data integrity, accuracy, and consistency. Performed SQL optimization/performance tuning. Was off-shore technical resource.
• Created stored procedures to process calculations and stage tables which improve efficiency by 200 .
• Designed architecture and reusable components that improved development by 300 .
• Developed ETL data mapping/validation, and complex transformation logic. Maintained Unix Shell scripting.
• Collaborated JAD sessions to gather, verify, and analyze req, design prototype, storyboards, dev, gap analysis.
• Participated in reviews for design, build, security, and product-readiness which ensured timely product release.

Technical Lead/Sr. Software Engineer

• Key player to complete CDC project implemented nationwide Use Case-driven req't and led project migration.
• Architected reports engine to improve performance by 300 and reduce report components to 80 .
• Redesigned surveillance data model to improve report generation efficiency by at least 500 .
• Developed modules for Taxpayer ID, Accounting and Returns Processing which reduced tax processing time.
• Designed and documented test plans, suites and cases for unit and integration testing which improved quality.

Confidential

Systems Analyst/Programmer

• Developed base objects and enhanced Intel PB Application Framework which increased efficiency by 130 .
• Collaborated to gather, verify, and analyze requirements, prototype design, development, and gap analysis.
• Developed applications for the Purchasing and Payroll departments.

FREELANCE SYSTEM ADMIN

• System Admin/Support Overland Park, KS Chicago, IL San Jose / San Francisco / Sacramento / Elk Grove, CA Wichita, KS Vancouver, BC - Windows XP/Vista/7, Unix-Zorin OS 4, IE 8, FireFox 4, PCAnywhere, RDP
• Troubleshoot and fix windows/printer/internet problems of laptops/desktops thru remote connection/issues.
• Diagnose bottleneck and tuneup/optimize performance of HD, RAM, CPU, and network.
• Install, configure, and manage Windows Server, utilities, malware/spyware/etc tools for home network and PCs.
• Install/configure SQL Databases, install/setup Wireless LAN, Development/Network/PC tools and utilities.
• Image HD/BackUp Data, and rescue crashed HD, and salvage data.
• Assemble/Configure AMD X4 / Intel i7 Windows 7 Pro machines

VOLUNTEER DB CONSULTANT

• SQL DBA/BI Designer-Developer Telos Orphan Care, Overland Park, KS SQL Server
• Design/Create Microsoft Dynamics CRM Reports and enhance SSRS Reports.