Design data warehouse solutions and employ diverse technologies. Develop data infrastructure to extract, organize, and facilitate authorized access to data. Identify internal and external data sources. Collaborate with stakeholders to understand their storage and organizational requirements and utilize this insight to establish and maintain robust data infrastructure. > Establish technical guidelines and methodologies to ensure cohesive system design across all architectural solutions.> Strive for ongoing enhancements in data warehouse performance, tuning, and data security measures.> Conduct analysis of current solutions to pinpoint areas for system enhancement.> Design migration plans and execute legacy data migration processes. > Facilitate data reusability across various architectures, interfaces, and among stakeholders. > Deliver a simplified and unified data model and taxonomy.> Publish and present design reports.> Collaborate with team members to achieve project milestones and meet deadlines.> Regularly audit databases to ensure quality.> Support and address customer/user inquiries.

Designed and created the database structure, including tables, relationships, indexes, and constraints, ensuring it met organizational requirements for optimal performance and scalability. Focused on performance tuning to optimize database performance through SQL query refinement, indexing strategies, and configuration adjustments while addressing performance bottlenecks to enable efficient data retrieval and manipulation.> Database Design: Designed the structure of the database, including tables, relationships, indexes, and constraints. Ensured that the database design meets the requirements of the organization, provides optimal performance, and allowed for future scalability.> Performance Tuning: Was responsible for optimizing the performance of the database by fine-tuning SQL queries, indexing strategies, and database configurations. Involved identifying and resolving performance bottlenecks to ensure efficient data retrieval and manipulation.> Backup and Recovery: Developed backup and recovery strategies to ensure the integrity and availability of data in case of hardware failures, disasters, or human errors. This involved setting up regular backups, testing recovery procedures, and implementing failover mechanisms for high availability.> Data Modeling: Worked closely with stakeholders to understand their data requirements and developed logical and physical data models that represented the organization's data accurately. Ensured data consistency, integrity, and adherence to normalization principles.> Collaboration: Collaborated with other IT teams, such as developers, system administrators, and network engineers, which ensured seamless integration of the database with other systems and applications. Also provided guidance and support to facilitate efficient data access and usage.

Designed and developed ETL/data integration processes and programs to support business-to-business data transfer for operations, involving data analysis, source-to-target data mapping, job scheduling, and development and testing of Data Quality Control, Electronic Data Interchange (EDI), and/or SQL ETL programs. Interacted with data stewards, external vendors, and business users to resolve data questions and anomalies.> Communicated with customers to obtain data requirements and perform data analysis on data provided. > Designed and implemented data integration modules for Extract/Transform/Load (ETL) functions for financial institutions and insurance companies. > Developed aggregation, monitoring, and alerting methods and modules. > Participated in the overall development process through architecture guidance, code reviews, work estimates and plan assistance. > Designed, implemented, and maintained reports, monitoring, and dashboard framework. > Investigated new technologies and advances, especially in the areas of business-to-business data exchanges including Electronic Data Interchange (EDI). > Developed reports and dashboards for the product and specific customer projects.

Database Developer responsible for the design and development of database and reporting requirements. Was also responsible for supporting customer interfaces and ETL processes. Performed configuration and analysis of components, scripts, tables, performance tuning, and data processing. > Built and optimized complex SQL queries that supported MS-SQL Server.> Built SQL reports and dashboards using SSRS (SQL Server Reporting Services) along with MS-Excel. > Strong knowledge of writing MS-SQL Server Stored procedures.> Created and/or modified ETL processes utilizing SSIS packages.> Performed ad hoc analyses and prepared reports of findings as needed.> Authored complex queries.> Optimized SQL databases for quick performance.> Documented existing processes for supportability and maintainability.> Excellent customer service skills supporting technical and business teams.

Had extensive experience as a report developer and administrator, building projects and creating reports and dashboards using MicroStrategy 9.0.1/9.3.1, Narrowcast Server, MicroStrategy Desktop, MicroStrategy Web, Office, MicroStrategy Intelligence Server, MicroStrategy Architect, SQL Server Reporting Services 2008, and Oracle Hyperion Essbase.> Supported an enterprise class application.> Communicated with end users to gather requirements, coded, maintained, tested, and debugged modifications to existing applications.> Served as technical lead on projects of basic to medium complexity.> Provided work breakdown structures, cost and resource estimates.> Led software development effort. > Managed timelines, and technical documentation.> Designed non-functional requirements into a solution design.> Communicated development status, issues, and concerns to leadership.> Led research needed to develop or modify information systems.> Troubleshooted coding/configuration.> Performed MicroStrategy software administration.> Dealt with installation issues encountered in the development or production environments. > Created and contributed to the application design.> Provided guidance and training to less experienced colleagues and business users.> Excellent interpersonal (verbal, listening, written) skills.

Led development of custom software solutions for the United States Air Force (USAF). Responsible for leading and managing all aspects of the software development lifecycle from requirements analysis to maintenance of software products delivered to the USAF.> Served as Chief Architect and Team Leader for the Reliability Centered Maintenance (RCM) software simulation tool. Integrated SQL Server, a pre-existing RCM web-based tool, and its underlying Oracle Server into a package that simulated optimum build configuration for the Air Force’s F100 engine over a seven-year period.> Led the team and served as Chief Software Architect for the Air Force’s F100 Corporate Contract Activity Tracking System (CCATS). Conducted system analysis and guided the design team in developing the system used by the USAF to evaluate contractor performance and supply availability for critical engine parts.> Led software system analysis, design, and development of the USAF’s Actuarial Lower Assembly Removal Model (ALARM) application. Extracted operational and failure data from legacy USAF systems, transforming and analyzing the data to determine usage factors, flying hours, and pipeline/transportation times.> Served as Chief Database Architect, leading the redesign of the eWorkspace and the Engine Requirements Review Board (ERRB) software applications. Redesigned both applications to enhance simplicity of use for software developers and to add scalability and robustness for end users.> Developed software documentation in support of both ALARM, CCATS, and other division projects.

As a software development professional, contributed to the success of a segment of the Dell Computers Corporation. Applied extensive experience in rapid software development to create and maintain relational databases. Provided data analysis support, leveraging a diverse skill set and experience in both software development and system administration to enhance the efficiency and performance of Dell Home Systems (DHS) Finance. > Led software development for Dell Home Systems (DHS) Finance, a $3B per year segment of Dell Computers.> Gained extensive experience in rapid software development.> Developed relational databases using Microsoft Access and SQL Server.> Led the redesign of software used to measure and report sales performance for the entire DHS organization.> Gained experience in data warehousing.> Gained experience as a Windows NT System Administrator.

Managed the global inventory of specific jet engine parts. Initiated procurement requests, terminated contracts, scheduled repairs, and managed disposal of irreparable parts. Ensured accurate stock levels, and timely distribution of materials by coordinating with suppliers to optimize costs and delivery schedules. Regular audits and inspections were conducted to maintain inventory record integrity.> Calculated future requirements to ensure timely availability of jet engine parts. > Managed jet engine parts inventory to ensure accurate stock levels, and timely distribution.> Implemented quality control measures to ensure the integrity and accuracy of inventory records, including conducting regular audits and inspections.> Assisted in procurement activities by evaluating inventory needs, preparing purchase orders, and verifying receipt of goods.> Prepared and maintained documentation related to inventory transactions, reports, and analyses.> Provided training and guidance to staff on inventory procedures, best practices, and system usage.> Investigated and resolved issues related to inventory discrepancies, and supply shortages.