We provide IT Staff Augmentation Services!

Reports Developer Resume

Charlotte, NC

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

Hire Now