SKILLS INVENTORY:

• Project Leadership
• Client Relationship Management
• Process Improvement/Modeling
• Change Management
• RUP Methodology
• Agile Methodology
• Database Design/Implementation
• Requirements Management
• MS SQL Server Management Studio
• Harvest Time Tracking
• MS Project
• MS SQL Server Reporting Services
• Atlassian - Confluence
• MS Visual Studio
• MS SQL Server Analysis Services
• Atlassian - JIRA
• MS Visio
• MS SQL Server Management Studio
• Informatica 8.6
• Toad for Oracle
• Oracle SQL Developer

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

Business Intelligence Developer

Responsibilities:

• Resolved discrepancies via procedure and/or code updates.
• Created logical and physical data model for Store APL Exception process.
• Created ETL solution for Store APL Exception process for data import and export.
• Created stored procedures and reports for Store APL Exception process.
• Optimized queries, procedures, and indexes for performance gains.
• Implemented updates and patches via change control management.
• Performed source to target data analysis.
• Performed functional/unit testing of all code created.
• Researched, resolved and deployed system fixes and enhancements.

Confidential, Jacksonville, FL

Senior ETL Software Engineer

Responsibilities:

• Created and maintained Informatica ETL packages.
• Implemented updates and patches via change control management.
• Performed source to target data analysis.
• Performed functional/unit testing of all code created.
• Monitored daily ETL processes to ensure completion for SDR environment.
• Reviewed team code prior to migration into production environment for SDR.
• Created SQL Server stored procedures, views, indexes and functions.
• Optimized queries, procedures, and indexes for performance gains.
• Ensured data integrity, performance quality, and resolution of data load issues.
• Designed and developed extensive ETL/data manipulation stored procedures.
• Created SSIS packages as needed for ETL solution.
• Created and maintained SSRS reports.
• Designed and developed physical and logical data models.
• Developed and designed database, tables, and stored procedures to support reporting and BI infrastructure.

Confidential, Orange Park, FL

SQL Server DBA/ Database Administrator

Responsibilities:

• Managed and supported day to day operations of all databases.
• Created database standards, best practices, and streamline processes and procedures.
• Created and optimized stored procedures, views, linked server connections, and functions.
• Implemented database maintenance plans, backups, integrity checks, file cleanup, etc.
• Interpreted and validated source to target mapping documents.
• Implemented indexes and other tuning for performance gains.
• Created, tested, and maintained ETL packages, stored procedures, etc, to test and load data.
• Maintained versioning of packages utilizing VS Source Safe.
• Deployed, configured, and troubleshooting of SSIS packages running as a SQL Server Agent job.
• Ensured data integrity, performance quality, and resolution of data load issues.
• Implemented updates and patches via change control management.
• Created, tested, and maintained SQL Server Reporting Services reports.
• Designed and developed extensive ETL/data manipulation stored procedures and SSIS packages.
• Performed source to target data analysis and created data mapping documentation.
• Designed and developed physical and logical data models.
• Developed and designed database and stored procedures to support .NET UI development and implementation.
• Designed and implemented database standardization for Eligibility, Medical Claim, and Rx Claim data.
• Created and managed batch jobs and schedules using SQL Server Agent.

Confidential, Jacksonville, FL

Business Analyst

Responsibilities:

• Served as a SME for SQL, Rational Suite, and Microsoft products.
• Oversaw multi - departmental complex projects and change initiatives.
• Led team status meetings, updated documentation, and reported to management.
• Conducted/participated in quality reviews of project documentation (requirements, models, mappings, etc.).
• Reviewed, edited, and certified test scripts and results ensuring they fulfilled business requirements.
• Created and ran reports for management on data, defects, and other ad-hoc requests.
• Directed and coordinated work of other business analysts.
• Assisted with addressing post-implementation issues and problem solution.
• Designed business process rules and process modeling documents.

Business Analyst

Confidential

Responsibilities:

• Utilized RUP methodology to elicit and document detailed business requirements.
• Utilized Rational Suite to manage business requirements.
• Participated in quality reviews of project documentation (requirements, models, mappings, etc.).
• Created UML diagrams using Visio and/or Rational Rose.
• Performed data integrity analysis through data interrogation and provided reports on findings
• Analyzed and documented business processes and opportunities for improvements.
• Coordinated and led requirement sessions, meetings and discussions.