SUMMARY

• Senior Developer and administrator with SQL, Data Analytics and Data Reporting.
• SSRS, SSIS, SSAS
• Experience with Macros, pivot tables, spread sheets, Power Desktop and Power BI.
• Gateways, Apps, On - Premise, Cloud, Admin, Role Management
• Strong experience with creating Dashboard, and Ad-hoc reporting.
• Possess excellent interpersonal and communication skills.

• SQL Server Developer, Oracle, Teradata 2000, 2005, and 2008R2, 2012, 2016
• Database design, data mapping, and data modeling
• Tables, Views, and UDF’s, Stored Procedures, T-SQL, PL/SQL, Joins, Query's
• Hands-on writing SQL stored procedures and performance tuning. Debugging Stored procedures
• Installation, logging, and security; Replications, Subscriptions
• Coding, testing, debugging, modification, migration and implementation in SSIS
• Coding, testing, debugging, modification and implementation of Oracle/Teradata stored procedures/functions.
• Develop test cases and plans to complete the unit testing. Support QA and UAT testing.
• Review and Analyze functional requirements, mapping documents, problem solving and troubleshooting.
• SSIS Migration
• Able to work in multiple projects simultaneously.
• Production support and maintenance of applications.
• Work with multiple teams/groups to deliver effective solutions SSDT
• SSIS, SSRS and SSAS
• Data Warehouses, Data Marts
• Tabular Modeling (SSAS)
• ETL, Data Staging, Data Integration
• SSRS Development, SSRS SharePoint 2013
• Cube Development, Processing, Analysis, KPI Development
• SharePoint Designer, InfoPath, Web Parts, and workflow creation
• High availability configuration of network components and infrastructure of SSRS and SSAS.
• Enterprise configuration and change management methodology.
• Disaster Recovery and Business Continuity of SSRS and SSAS as deployed in an integrated shared infrastructure.
• Interpret technical designs and execute specified solution with limited guidance.
• Identify, define and document processes, artifacts, and methods for provisional, operational and support proficiency.
• Dashboard and Visualization with Tableau
• Analysis Services with Dimensions, Facts and Hierarchy
• Excel PowerPivot, Power BI, PerformancePoint
• Cube Development, Processing, Analysis, KPI Development .Net
• Control Flow and Error Expressions
• C#, VB
• Web Services
• XML, WSDL Validation, XAML

PROFESSIONAL EXPERIENCE

Confidential, Clemmons, NC

SQL Server Developer/DBA/SSRS, SSIS,SSAS/Epicor ERP Admin

Responsibilities:

• Created tables, views, functions and stored procedures for ERP
• Created and administered SSRS for existing ERP.
• Administered roles and user security for reports
• Created data warehouse against Shipping, Supply, A/R…
• Created cubes for Finance, A/R, and Procurement to have the ability to better forecast
• Implemented self-service reporting using Power Desktop Power BI
• Implementing Power BI integrated with SharePoint

Confidential, Rock Hill, SC

SQL Server Developer/DBA

Responsibilities:

• Optimized SQL Server and stored procedures
• Created ETL packages that imported data from FTP
• Created stored procedures that cleansed data before upload

Confidential

SQL Server DBA/Developer, SSIS, SSRS Developer

Responsibilities:

• Built Data Warehouse from all hospital main application to one central location accompanied this by developing a central reporting system for all facilities.
• Created SSRS reports from MediTech
• Reverse engineered GE Systems to utilize the gathered Oracle information and put into SQL Server
• Used Lumedix, Muse and DMS data sources to create new reporting application
• Project Manager of 3 projects for converting MOX users to Outlook and 365 Live
• Create Data Warehouse for CATH and ECHO groups using SQL Server, Data Tools, BIDS
• Created reporting for supply chain
• Created dashboards for different sites through division to do inventory and billing
• Created new reporting environment for nurses using MediTech and converting NPR reports to SSRS
• Created new ETL processes to bring all market data to one source using SSIS
• Maintain all SQL Servers instances over 120
• Created SSIS packages to capture Oracle data and import to SQL Server for centralized analysis over time zones
• Created Reporting Services for MUSE and Pharmacy
• Created alternative SQL Server applications from Crystal Reports
• Conferring with users; studying systems flow, data usage, and work processes;
• Investigating problem areas; following the software development lifecycle.
• Documents and demonstrates solutions using, flowcharts, layouts, diagrams, charts.
• Determining and designing system specifications, standards, and programming.
• Improving operations by conducting systems analysis; recommending changes in policies and procedures.
• Obtaining required information from vendors; recommending purchases; testing and approving products.
• Administered software solutions.
• Provide information by collecting, analyzing, and summarizing development and service issues.

Confidential

Consultant - Software Engineer III/SQL Server DBA/Teradata

Responsibilities:

• SQL Server daily monitoring
• Teradata ETL and process monitoring
• Created new ETL processes as needed or modified existing
• Created new moving processes with Teradata Data Mover
• Worked with SAS MDM and new implementation
• Big Data to understand customer gambling habits
• Validated data from staging to DW
• Created new SSRS reports
• Performance tuning of stored procedures and functions
• Provide information by collecting, analyzing, and summarizing development and service issues.

Confidential

Senior Database Developer/Report Developer

Responsibilities:

• Created applications for the Demand Response programs.
• Create reports, dashboards and charts for analysis of parcel data using SSRS
• Convert legacy code to SQL Server 2008R2
• Create pivot tables and spread sheets using Excel to be used with new reporting architecture

Confidential

Senior Database Developer/Data Analyst

Responsibilities:

• Created applications for the Demand Response programs.
• Analysis of data from summer events
• Convert legacy code to SQL Server 2008R2
• Source to Target mapping
• ETL to populate staging
• Gathered business requirements
• Gathered report specifications

Confidential

Data Analyst

Responsibilities:

• Captured data requirements within visual data models Designed and Developed data models (Conceptual, Logical, Physical) for Operational Data Stores, Data Warehouses, Data Marts, and Multi-Dimensional databases
• Created multi-dimensional data models for SSAS cube development using ERWIN and EA
• Aligned Hierarchies, Named Calculations, Named Queries
• Showed KPI’s and Excel MOLAP analysis in Excel
• Attached MOLAP to Excel for users to analyze data
• Participated in the design of data integration components including ETL
• Loaded and transformed data for data warehouse and data mart using SSIS.
• Developed Dimensions and Fact tables
• Consulted on report development using existing BI infrastructure
• Prepared Source to Target mapping and transformations
• Translate relational data models to Multidimensional data models for SSAS cube development
• Developed applications for use of SSRS reports and data analysis
• Created user front end using C# and VB .NET
• Rebuilt legacy applications to VS 2010
• Debugged application when users encountered problems
• Built new class modules to secure database connections
• Worked with Architects to ensure compliance with the Enterprise vision
• Consulted with ETL designers and developers, ensuring secure business rules were implemented
• Performance tuning of stored procedures and functions
• Query analysis for best functionality
• Wrote stored procedures and functions for.NET applications backend

Confidential

DBA

Responsibilities:

• Worked with accounting department to integrate the Claims Process with MAS500 SageGl;
• Mapping of Guidewire database to SQL Server for ETL of staging tables for issued and cleared checks and to create the Journal entry's that reconciled the General Ledger; created documentation and data dictionary for policy creation and HR SageGL.
• SQL programming including stored procedures, functions
• Created tables and views per user requirements
• Developed applications for use of SSRS reports and data analysis
• Created C# interface applications for reports
• Created business logic for middle tier web based applications using C# and VS Studio
• Wrote stored procedures and functions for.NET applications
• Created SSIS Packages that moved data from claims to HR for processing
• Source to target documentation
• SQL Server performance tuning
• Design or redesign query execution plans
• Replicated or databases and setting up user subscriptions
• Setup reporting for users to subscribe to published reports
• Setup reports server for SSRS
• Created the ETL process and validation
• Created UI for user to interact with reports on intranet site
• Implemented business logic for client applications using VS2008

Confidential, Richmond, VA

Senior Database Developer/Data Analyst

Responsibilities:

• Provide reports to the parties and the supervisory court on the progress of claims, funds available, administrative costs, projected completion dates, and other information.
• We were responsible for creating new stored procedures and database objects for reporting claimant information to analysis team. We also created ad-hoc queries by gather requirements for the different phases of the claimant payout.
• Gathered business requirements from attorney's
• Gathered report specifications
• SQL programming including stored procedures, functions
• Created tables and views per user requirements
• Create pivot tables and spread sheets using Excel
• Created ad-hoc query’s using MS Access
• Design query execution plans

Confidential, Richmond, VA

Systems Analyst

Responsibilities:

• Extraction of data from existing data stores and performing ad-hoc queries to determine the accuracy of the previous ETL into staging tables
• SQL Server 2008R2 Development
• Created tables, views, stored procedures and UDF's
• Developed Dimensions and Fact tables
• Loaded and transformed data for data warehouse and data mart using SSIS
• Prepared Source to Target mapping and transformations
• Created validation process for previous nightly load of data
• Created MDX queries for reports
• Processing cubes
• Scheduled reports to deliver through email

Confidential, Richmond, VA

Sr Database Developer / Data Analyst

Responsibilities:

• Gathered and analysis of data that reported mortgage delinquencies. Part of a team that created decks for graphical analysis and presentation to management
• Reconciled GL for accuracy
• MS SQL Server and SAS to perform data analysis
• Creation of database objects including tables, views, indexes and stored procedures
• Gathered data to create new algorithms to determine actions for delinquencies
• Gathered requirements for ETL and data mapping
• Liaison between IT and Under Writers
• Data extraction from MS Access and MS Excel using VB.NET
• VB and VBA for automation and verification of data before final reporting
• Reconciled delinquency data between forecasters and data marts
• Cleansed Data, Gather Data to Load into Data Marts for reporting
• Used Management Studio and SSRS to modify existing reports
• Server Agent to schedule jobs for efficient use of resources
• Updated legacy code to more modern practices as needed.
• Created and performed ad-hoc queries

Confidential, Richmond, VA

Sr Programmer Analyst

Responsibilities:

• Created new database structure that better analyzed the performance of Technical Project Managers and the utilization of an existing system for project tracking. From this analysis, new business rules were created along with metrics that saved time and expense of implementing new projects.
• .NET C#, front end code writing and implementation for SharePoint
• SQL programming including stored procedures, functions, triggers
• SSIS packages Designed Control Flow, Data Flow
• Creation of database objects including tables, views, stored procedures, and functions
• Database tuning through methods such as reviewing indexing
• Database and server configurations, and data access methods
• Setup test plans for validation and data integrity
• Analyzed data and relayed finding to management to determine escalation if needed
• Manage and implement schema and data dictionary change control.
• Created and performed ad-hoc queries
• Crystal Reports Enterprise XI
• Completed BRDs, FDDs
• Translate business requirements detailed technical documents and diagrams using Visio
• Gathered and defined requirements from PMO
• Updated legacy code to more modern practices as needed.