SUMMARY:

• Dynamic, solutions - oriented, and hands-on professional, with accomplishment-laden experience in project management, requirements definition, information technology assessments, and evaluation of highly complex data architecture and applications designs; complemented with excellent leadership skills in overseeing high-caliber onshore and offshore teams. As a data professional my pragmatic data management skills focus on best practices and principles to ensure the coherent and understandable data model and data movement for the delivery of information to end users.
• Equipped with proven expertise in leading application design and development as well as in analyzing and evaluating client needs and business requirements to come up with out-of-the-box, effective technology strategies and solutions that improve productivity, quality, and customer satisfaction.
• Armed with in-depth knowledge of information technology concepts; architecture components; project management principles, procedures, and practices; as well as various business technologies.
• Consider one of the best to assist in start-up or setup technology team’s policies and standard in development of data / ETL and databases.
• Effective in conveying technical information to present technical materials and product details to diverse audiences and end users at all levels of technical proficiency.
• A proven leader in the development and implementation of systems for identifying, cleansing, extracting, reconciling, transforming, mapping, loading, and validating legacy and converted data. Has a demonstrated strong database architect, analysis, data access design, and implementation capabilities with several Fortune 500 companies and the State of Alabama.
• Adept at business and deployment planning, needs and trend analysis, process improvement, and risk assessment.
• Involved with CMS initiatives such as Affordable Care Act Programs, provider data, Medicare (A, B, C,D and TMSIS and Medicaid.

AREAS OF EXPERTISE:

• ETL Development
• Data Integrations Project
• Database Design and Data Modeling
• Technical Support and Troubleshooting
• Information and Access Management
• Analytical Analysis/ Metric Measurements
• Vendor Negotiations
• Data Governance
• End-User Support and Management
• Project Planning and Implementation
• Big Data and Master Data Management
• Enterprise Data Warehouse
• Database Administration
• Business Intelligence (BI)

TECHNICAL ACUMEN:

Relational Databases: Oracle 10g, 11g, 11g RAC | SQL Server 2005,2008 & 2012 | MS Access | DB2

ETL Software: SQL Server Integration Service (SSIS) | SQL Server Report Service (SSRS) | DataStage | Informatica 9.1

Business Intelligence: QlikView | Micro Strategy | OBIEE | Dundas

Server Environment: Window Server 2003 | Window Server 2008 | Window Server 2008R2 | Linux

Applications: Microsoft Office Suite | Visio | Projects | Primavera and STAMP

Data Model Tool: Embarcadero Data Architect | MS Visio | SQL Developer Modeler | Toad Modeler

IDEs: Visual Studio 2005 & 2008 & 2010 | Web Expression | Dreamweaver | SQL Developer TOAD | Eclipse | AQT

UML Tools & Others: IBM Rational Collaborative Lifecycle Management (Jazz) | CaseComplete | ArgoUML

Programming Languages: VBA | VB.NET | C#.NET | SQL | T-SQL | PL/SQL | HTML | ASP

Miscellaneous: Creative Solutions Ultra Tax Suite | Peachtree | Platinum | QuickBooks | SAP | (non-profit) BlackBaun ADP | PayChex | Gorri-ReganTimekeeper | Kronos Systems

RELEVANT EXPERIENCE:

Confidential, AL

Lead Information Architect

Responsibilities:

• Interview and hire information service resources to stand-up a data team for the project.
• Account management with Prime Vendor and Client Leadership.
• Significantly improved the poorly designed ETL implementation.
• Implemented Enterprise ETL framework that runs daily in Azure environments.
• Using of third-party tools that integrated into daily operators (Octopus, Software AG and Kings Way Soft).
• Implemented data architecture that connected systems data to flow into the CRM
• Design and Implement reporting structure for file output to secure locations
• Redesign database objects to improve data integrity within the existing the legacy system.
• Working with CMS Information System framework to align the CARES project data architecture designed.

Confidential, Charlotte, NC

Senior Business Intelligence Consultant - Lead Consultant

Responsibilities:

• Significantly improved the poorly designed ETL implementation 12 to 165 running daily.
• Leveraged technical expertise in devising informative dashboard for clients to interpret business story with detailed results; established data models for target schemas; monitored and properly maintained data ETL processes; and conducted data analysis on reports.
• Conceptualized and executed process improvement for ETL processing, data warehouse design, and database architecture.
• Devised software based on vendor and third-party provided tools to guarantee their full satisfaction.
• Formulated effective testing plans for software performs error- and bug-free through all phases of testing.
• Expertly handled the valuation of business data requirements and design strategies for gathering, analyzing and storing information for end users.
• Designed strategic solution for data collection procedures, ETL scripts, and stored procedures to improve tracking and retrieval of information.
• Applied technical aptitudes in conducing Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) modeling for data retrieval.
• Structured the process of reviewing client business data for identification of key indicators in key areas of operations, risk, finance, compliance, process, and controls.
• Devised and implemented new analytical business and technology solutions in alignment with key indicators.
• Earned several accolades for demonstration of exemplary performance and professionalism.
• Rendered technical guidance and supervision to the conceptualization and execution of multiple projects.

Confidential

Senior Database Consultant

Responsibilities:

• Contributed key insights to the Data Management Team toward the successful transition of the initiate instances for development, testing, and production.
• Built and executed model for the Data Management Team on standards development along with integration of framework design model utilizing advanced tools, such as SSIS and Informatica.
• Demonstrated efficiency in designing system for capturing, reporting, and correcting errors in data.
• Displayed competency in interpreting technical specifications and/or logical and physical design into code to support new or enhancement projects.
• Pioneered the design code that reprocessed subroutines or objects with sufficient comments.
• Spearheaded the transportation of business requirements in identifying appropriate data and reporting solution.
• Formulated strategic solutions in testing plans and procedures to drive implementation; evaluated mobile device management (MDM) requirements in support to the Design and Development teams.

Confidential

Technical Solution Architect

Responsibilities:

• Configuring and Implementing SQL server Failover 2012 Project Blue Valley School, KS
• Leading SSRS integration project for Leon Schools District, FL

Confidential

Technical Solution Architect

Responsibilities:

• Leveraged technical expertise in utilizing a suite of Informatica products, from Power Center 9.x/Big data edition to B2B and data transformation modules.
• Efficiently handled the maintenance of Informatica health check; offered hands-on support to the Application Development Team with performance tuning; determined bottlenecks for long-running processes; and collaborated with database administrators for back-end support.
• Worked closely with developer to provide consultative support on standards and tool usage; while administering code migration across multiple Informatica repositories.
• Managed back-end database development to support complex ad hoc reports, enabling process and trend analysis.
• Rendered consultative advice on the development and implementation of new and revised operational and/or reporting processes.
• Initiated special projects which required a high degree of confidentiality and expert knowledge of multiple departments within the company.
• Collaboratively worked with IT analysts, clinical analysts, business analysts, and other IT professionals to evaluate and address needs of end-users through configuration of GDIT software.

Confidential

Data Architect

Responsibilities:

• Keenly evaluated and coordinated the review, development, and planning of tasks related to the client’s data state, extract-transfer-load (ETL) processing, and data architecture assessments.
• Designed assessments documentation to track client current state and future state environments, in collaboration with Confidential teams as well as clients.
• Capitalized on industry expertise in the evaluation of business requirements and identification of technical needs for data acquisition.
• Planned and organized coherent and understandable storage and movement of data during delivery of information to end-users, utilizing pragmatic data management practices and principles.
• Partnered with the organization’s IT Enterprise architects and teams to provide fundamental data services focused on enhancing end-user self-sufficiency in reporting.

Confidential, Maitland, FL

Senior Data Conversion Specialist

Responsibilities:

• Took charge of defining table/column/data type mapping, requirements definition, application development, and testing and verification of data transfers.
• Maintained constant interaction with new clients for conversion of their database, from flat files, MySQL, Access database, Oracle, and other company platforms by analyzing data and writing scripts and views.
• Played an instrumental role in overseeing data projects of new clients, as well as internal trainers and project managers for data migration project tasks.
• Optimized SQL scripts for new stored procedures for different ETL data warehouse tasks.
• Employed adeptness in supporting database backup, recovery process to DEV, functional, and performance environments.
• Dealt with the preparation of service performance reports to enable IT management access to all metrics and key performance indicators (KPIs).
• Spearheaded the development and execution of SSIS packages using SSIS 2008.
• Significantly enhanced SQL scripts/stored procedures for different ETL data warehouse tasks, which utilized for data warehouse reporting through cubes and SSRS.
• Demonstrated efficiency in the formulation of migration/conversion designs in alignment with the project's business, system, and data requirements.

Confidential, Charlotte, NC

Technical Consultant | ETL Developer

Responsibilities:

• Developed in-depth knowledge of physical database design and development including performance tuning in a SQL server environment utilizing Transact SQL Data Definition Language (DDL)/DML.
• Devised the underlying extract-transform-load (ETL) structures in tools including SSIS and Informatica that supported the new IT services reporting.
• Conceptualized technical designs for data analyst deliverables in line with life cycle methodology, individual project schedules, and data governance team activities.
• Drove strategic efforts in the creation and execution of systems used for identifying, cleansing, extracting, reconciling, transforming, mapping, loading, and validating legacy and converted data with tools SSIS.
• Initiated effective establishment of ETL packages, store procedures, configuration files, tables, views, and functions using SQL programming; while employing best practices to maintain optimal performance.
• Optimized all required data elements to logical data record to address issues through mapping logic and business rules.
• Pioneered the development of end user documentation and training materials.

Confidential, Pascagoula, MS

Quality Management Technical Database Analyst

Responsibilities:

• Managed the collection and design of business data as well as execution of root causes analysis.
• Steered a cross-functional team in data gathering, observing operations and workflow, and mapping business processes to provide recommendations for process improvement in creating global enterprise system quality assurance and quality control of Confidential .
• Served as a primary point of contact in managing internal and external client and conducting discussions concerning different groups; while establishing and maintaining consensus with stakeholders and technical teams.
• Developed business project plans and schedules, while ensuring compliance with budget limits, ranging from $200K to $1M including by classifying and documenting necessary requirements.
• Conceptualized the design of Unified Modeling Language (UML) - diagrams through the ArgoUML software for the project team for QA/QC global database; used MS Visio program in creating models and UML diagrams.
• Led the successful introduction of graphical user-interfaces in Microsoft Access, ASP, and ASP.Net; acquired knowledge in setting up the CSS web.
• Drove strategic efforts in boosting metrics that provided data for process management and indicators for future improvement opportunities in daily QM activities.
• Made substantial contribution to the successful development of business strategies toward the introduction of technology tools.