SKILL:

• SSDT 2014, MS SQL 2005/2008,2012,2016, SSIS, SSAS, Crystal Reports, Languages C#/NET, SQL, PSQL, JAVA/ANDROID, VBSCRIPT

PROFESSIONAL EXPERIENCE:

Confidential - Charlotte, NC

SQL Develoepr

Responsibilities:

• Assist BIS team with migrating SSRS reports to new reporting server platform. Over 200+ SSRS reports were migrated, retired or converted to Tableau
• Develop SSIS packages to extract and load trading floor data for deployment DEV and UAT environments. Utilize lookup, data conversion and derived transformations within data flow
• Setup and configure package configuration model for deployments
• Schedule AutoSys jobs from the SSIS packages created in DEV and UAT
• Develop/Enhance Microstrategy reports and datasets
• Create stored procedures and SQL jobs to automate internal data extraction processes
• Investigate reporting stored procedures to improve execution time. Examine SQL execution plans and used techniques such as temp tables, CTEs, and non-clustered index creation to aide in performance improvement

Confidential - CHARLOTTE, NC

SQL/ETL Developer

Responsibilities:

• Executed daily ETL automation tasks for the balance sheet management group. Utilize T-SQL, SSIS to extract, transform and load balance sheet source data from internal bank customers
• Designed SSIS packages to extract,load text file data using Openrowset BULK command
• Created format files, mapping text files with appropriate data types and table columns
• Developed stored procedure scripts to perform data backtesting and data regression comparisons
• Developed Powershell/F# scripts to automate code/scripts promotion from development to SIT/UAT environments.
• Implemented TFS 2015r repository to manage source control

Confidential - CHARLOTTE, NC

Reports Developer

Responsibilities:

• Developed and remediated organization's Crystal reports which supports company ERP system.. The role required updating and/or re-writing stored procedures use in the reports. Used SSRS to develop enhanced business scorecard solutions against organizational fact and dimensional tables.
• Designed SSRS reports sourced by star-schema database

Confidential

SQL Developer

Responsibilities:

• This developer role required 40% SQL Development, 30% SSIS design/integration and 30% SSRS Reporting
• Contracted by Confidential ’s Residential Valuation Services (RVS) to develop and automation several manual departmental processes using SQL and SSIS integration tools.
• Developed all required SQL Objects (tables, scalar-functions and stored procedures) in UAT before submitting to DBA for production loads
• Coordinated with external vendors) to create daily data feeds used in automation projects
• Created complex queries and stored procedures which produce scorecard reporting in SSRS and Excel outputs. Write queries which utilize left and full outer joins to capture data variances
• Utilized C# script task within SSIS to provide customization data feed imports, reporting exports and email communication
• SQL Cross apply, SQL WHILE looping and Rank() are just a few DML syntax used daily to capture data for reporting purposes
• Developed project-plan to convey projects milestones and flag potential stop-gaps in the development life-cycle

Confidential - CHARLOTTE, NC

Reporting Writer / SQL Developer

Responsibilities:

• Gathered requirements and developed reporting solutions utilizing the Microsoft BI stack (SSAS, SSRS) for Bank America customer-based
• Utilized Excel 2010 pivot-table feature to extract and report contract resource forecast data for business reporting users
• Demonstrated high proficiency with designing summary-detail based SSRS reporting solutions using SSAS cube. Used BIDS 2008 R2 develop and manage MDX SQL queries for report generation. This role occasionally required integration of Vb scripts to accurately set up date dimension data for report parameter selections
• Executed system or report demos to the business users, and managed any necessary needs
• Performed SSIS package conversion and testing for the bank's contract resource application and database migrations. Proficient with integrating data transformation techniques to map Excel tab-delimited data to SQL

Confidential - CHARLOTTE, NC

SSRS Reports Developer

Responsibilities:

• Developed, managed and supported complex financial reports based upon SSRS and Microsoft Dynamics CRM 2011. Role requires working closely with business analysts, interpreting functional requirements and developing reports.
• Integrated SSRS Charting tools within reports for banks Wholesale group.
• Assisted QA team with assuring reports passed SIT and UAT environments prior to production deployment. Devised test scenarios in development\QA environment.

Confidential

Reporting Business Intelligence Developer

Responsibilities:

• Analyzed, developed T-SQL report queries to be embedded with in SSRS reports behavioral health provider network
• Performed report conversions from Crystals Reporting to SSRS
• Performed weekly data extracts from data Cube using MS SQL server tools

Confidential - CHARLOTTE, NC

Reporting Business Intelligence Developer

Responsibilities:

• Developed and implemented SSRS reporting solutions for Duke Energy's Nuclear Division
• Demonstrated proficiency with developing SSRS reports using techniques as embedded SQL, stored procedures, temporary tables and cursor functions
• Was responsible for supporting over fifteen-hundred SSRS 2008 reports
• Performed SSRS report conversion from R2 release, assisting NIT Business Consultant devise NIT Workplace procedures / reporting standards and converting legacy Business Object reports to SSRS 2008R2

Confidential - CHARLOTTE, NC

GangNet Database Admin

Responsibilities:

• Implemented and maintained statewide GangNet database for Confidential Department
• Performed maintenance on SQL server software including upgrades, general maintenance, security and performance tuning. Created and executed SQL SSIS packages to import user information into GangNet database
• Set up replication to Central GangNet database in concert with Vendor, State, and Eastern Node resources
• Successfully developed, implemented and maintained C#/NET application (GangNet User Management) to manage statewide user information
• Developed, reviewed, evaluated, implemented and maintained financial/investment reports for Mutual Service Corporation using MS SQL Reporting Services 2000/2005
• Ensured report designs adhered to company and departmental standards
• Implemented SQL linked Server connection to DB2 database, converting existing legacy reports to SQL 2005 Reporting Server standards

Confidential . - CHARLOTTE, NC

System Analyst

Responsibilities:

• Preformed various tasks using SQL 2005 for Survey and Engineering business client. Developed custom billing reports using reporting services
• Reconfigured business client s HP NAS device to better utilize existing storage capacities. Implemented and supported multi-office Sonicwall VPN network. Troubleshoot and resolve connectivity issues
• Developed VB /WMI scripts to automate event log archiving process for 2003 servers. Migrated Windows 2003 domain controller from physical to virtual using Virtual Server 2005
• SUMMIT PROPERTIES, INC. - CHARLOTTE, NC
• Effectively implemented network testing environment to valid new applications prior to deploying in production
• Implemented secondary Exchange server 2003 to overcome existing mail server storage and performance limitationsPlanned and implemented Windows 2000/2003 test environment to assure infrastructure hardware and application software comply to Sarbanes - Oxley compliance framework
• Accurately applied database hot-fixes, indexed database tables, coordinated application downtime, and performed database backup/recovery
• Setup Windows 2000 DHCP scopes and TCP/IP addressing for corporate workstations.

Confidential

Sr. Systems Engineer

Responsibilities:

• Managed over 50 Compaq rack-mounted windows servers
• Procured over a half-million dollars in computer infrastructure hardware for MES project, keeping cost under budget
• Implemented 784GB Compaq/HP EMA/ESA 12000 fiber-channel SAN solution for MES project
• Created RAID sets and LUNS for servers participating in SAN. Backed up and restored local server data to SAN array
• Oversaw networking infrastructure hardware
• Performed weekly data exports of pay-by-phone application, bulk-copying data into MS SQL tables

Confidential

Network Administrator

Responsibilities:

• Administered eight Novell networks
• Provided top-notch computer support to Mecklenburg County Commissioners Office, Internal Audit and Finance departments
• Identified problems, defined solutions.