We provide IT Staff Augmentation Services!

Business Intelligence Developer Resume

2.00 Rating

Jacksonville, FL

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.

We'd love your feedback!