Sql Developer Project Manager

Rakiem Jones

Phone: 914-***-****

Email: ************@*****.***

LinkedIn: https://www.linkedin.com/in/rakiem-jones-a3b1237/

Professional Skills

Working in the IT Industry since 2006

Working with ETL Design in SSIS, Report Design and Development in SSRS since 2016

Extensive background in technical support and customer service

Excellent communication and teaching skills

Database experience in MS SQL Server 20012/2017 (Triggers, Constraints, Stored Procedures, Functions, Views, Packages)

Database Technology & Technical Skills

Microsoft SQL Server 2012-2017, T-SQL, SQL Server Reporting Services (SSRS) Administration & Automation,

Log shipping, Triggers, Constraints, Stored Procedures, Functions, Views, Packages

Career Accomplishments

Created 45 SSIS packages

Created 85 SSRS Reports

Active volunteer and member of Professional Association of SQL Server (PASS)

Notable Projects & Accomplishments

Assumed direction of project to successfully upgrade from SQL Server 2008R2 to SQL Server 2014, including migration from Failover Cluster Instances to Availability Groups

Planned & executed performance tuning on production report server to reduce average CPU from 25% to 10%, allowing company to delay hardware upgrade by two years

Created internal enterprise-scale SSRS environment that included separate development & production sites with self-service deployment mechanism

Experience

Bi Developer (Contract), Ingenious Med, Atlanta, GA Jan 2020 – Present

Build new SQL reports, automate current reports and processes

Acquire new data, and design the appropriate data structures and data flows using T-SQL

Fine tune SSIS packages and redesign existing packages to optimize performance

Conduct analysis, design, coding, testing, implementation, and document creation for small projects, and assisted with the same for larger projects

Participate as Agile Development team member executing multiple tasks, providing statuses, and supporting team members in product delivery

Support the QA team in a UAT apart from unit testing his/her development

Support both internal and external customers

Team Foundation Server experience

Agile methodology experience

SQL / ETL / Bi Developer (Contract) Entegreat Incorporated, Birmingham, AL Feb 2018 – Jan 2020

Debugged existing SSIS packages and database objects to improve performance

Designed and implemented Control flows and functions for SQL Server and SSIS

Created Drill Down, Cascading, Parameterized, Drill Through, Sub Reports and Charts, Tabular/Matrix, Conditional Reports

Coordinated with clients and system partners on reports designs and requirements

Focal support contact for other teams with interfaces to database related objects

Business Intelligence (BI)

SQL Developer, Old Castle Materials Incorporated, Norcross, GA Dec 2016 – Jan 2018

Supported databases for internally-developed applications for broker/dealer-RIA with over $100B AUM

Designing, Coding, and Developing in SQL Server Environment

Developed dynamic SQL Queries, Stored Procedures, Functions, Triggers

Created and updated tables, Temp Tables, Table Variables

Designed SSIS packages for cross-functional teams requirements

Troubleshot underperforming Stored Procedures and older queries to improve overall system performance

Debugged/Analyzed SQL queries to improve performance

EMR Analyst II, Emory-Adventist Hospital (Closed), Smyrna, GA Dec 2014 – Nov 2016

Managed Consumer Electronics portfolio of product services opportunities

Expertise in Training on Governmental Quality Measures: PCMH, PQRS

Develop report inquiries to assist in NCQA/PCMH certification process

Manage data dictionaries, cross mapping, preference lists and documentation templates

Collaborate with internal/external resources to analyze and resolve issues

Built user profiles, EMR template, configure roles/privileges

Go Live / EMR Implementation Analyst, First Fusion, Duluth, GA Aug 2013 – Nov 2014

Full Implementation and Support upgrade from Centricity 9.5 to 9.8

Data Migration support from Cerner

Carryout responsibilities within each phase of the project life cycle tailoring the system, testing, implementation, and go-live

Interact with providers to analyze workflow and related processes/requirements

ERP Implementation Project Manager, Preferred Display Inc, Clifton, NJ Sep 2006 – Sep 2013

Implemented to ERP Systems from planning and organizing to project completion

Plan, organize, prioritize, and manage multiple work efforts across application teams

Establish and oversee effective issue resolution, change control, and risk management processes

Develop and deliver effective presentations to senior management to communicate project updates and support effective decision making

Manage and track the project progress against the project plan

Knowledge of both theoretical and practical aspects of project management

Education

Iona College New Rochelle, NY Sep 1999 – May 2003

BBA Information Technology Management for Business

Contact this candidate