TECHNICAL SKILLS:

KEY SKILLS: SSRS 2005/2008, MS SQL 2005/2008,2012 SSIS, SSAS, MDX, Toad, Oracle

LANGUAGES: C#/NET, SQL, PSQL, JAVA/ANDROID, VBSCRIPT

EXPERIENCE:

Confidential, Charlotte, NC

Reports Developer

Responsibilities:

• Develop and remediate organization's Crystal reports which supports company ERP system.
• The role requires updating and/or re - writing stored procedures use in the reports.
• Use SSRS to develop enhanced business scorecard solutions against organizational fact and dimensional tables.

Confidential, Charlotte, NC

SQL Developer

Responsibilities:

• This developer role requires 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.
• Develop all required SQL Objects (tables, scalar-functions and stored procedures) in UAT before submitting to DBA for production loads
• Coordinate with external vendor(s) to create daily data feeds used in automation projects
• Create complex queries and store procedures which produce score-card reporting in SSRS and Excel outputs. Write queries which utilize left and full outer joins to capture data variances
• Utilize 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
• Develop 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 requires and develop reporting solutions utilizing the Microsoft BI stack (SSAS, SSRS) for Confidential 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 setup date dimension data for report parameter selections
• Executed system or report demos to the business users, and managed any necessary training 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, Kannapolis, NC

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 Confidential 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 2005 to 2008 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

Confidential, West Palm Beach, FL

SQL Reports Developer

Responsibilities:

• Developed, reviewed, evaluated, implemented and maintained financial/investment reports for Confidential 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

Confidential, Charlotte, NC

Contractor

Responsibilities:

• 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 limitations
• Planned and implemented Windows 2000/2003 test environment to assure infrastructure hardware and application software comply to Sarbanes - Oxley compliance framework