We provide IT Staff Augmentation Services!

Sql Server  Developer  Resume

Birmingham, Al

Professional Summary

  • Dedicated IT professional with over 6 years of progressive experience in Business Intelligence Applications development, Database Design and Development with MS SQL Server 2005/2008/2008 R2 Suite.
  • Expert in creating varieties of Reports using SSRS 2008 R2/2008/2005 including drill down, cross tab, matrix style layouts, parameterized reports, performance issues handling, Sub Reports, Ad-hoc Reporting framework design.
  • Deep understanding of Information Technology Software Development Life Cycle (SDLC) methodology and project management principles.
  • Extensive experience in MS SQL Server 2008 R2/2008/2005 with Business Intelligence (SSRS, SSIS).
  • Experience in building Data Integration and Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
  • Knowledge in SQL Server 2008 Configuration, Installation and Migration from SQL Server 2005

Professional Experience

Confidential

Birmingham, AL

Data Analyst and Reports Developer

  • Interact with business users to gather the reporting requirements.
  • Analyze data and check for data integrity.
  • Coordinate with data team to fix the data issues.
  • Develop and maintain reports in SSRS and Report Builder 3.0.
  • Perform unit testing and assist users with UAT.
  • Maintain documentation for internal use.
  • Responsible for training end users on how to use reports.
  • Production deployment of reports, granting access permissions to users and maintaining report manager on administrative level.
  • Schedule the reports to deliver them to end users via emails and File share.
  • Assisting Business Analysts with testing data during the application upgrade process.

Environment: Microsoft SQL Server 2008, SSRS, SQL Server Management Studio, Toad, Maximo, Remedy.

Confidential

West Des Moines, IA
SSRS Reports Developer

  • Migrated reports to use the new Salesforce data warehouse.
  • Worked with Business Analysts and end-users to analyze the requirements and gather data for the development of the reports.
  • Developed drill down, drill through, tabular, matrix and parameterized reports with complicated data sets.
  • Developed complicated parameterized reports with cascading parameters, multi-value parameters and passing parameters to drill though reports.
  • Performed conditional formatting in reports to support the customer needs (Ex: Converting order amounts to Functional currency, displaying columns based on the parameter selection, displaying report data based on the user role hierarchy).
  • Developed reports in SSRS to replace the manual reports.
  • Maintained existing reports and addressed production support break-fix tasks in a timely manner.
  • Performed Unit testing and supported QA team to get the UAT on reports.
  • Wrote complex Oracle PL/SQL queries to support the reporting needs.

Environment: Microsoft SQL Server 2008, SSRS, SQL Server Management Studio, Oracle SQL developer, Siebel, Sales force, Zuora, JIRA.

Confidential

West Des Moines, IA

  • Worked with Home Mortgage Business Intelligence management team, co- workers and Collections management team to identify refine or review data or report needs.
  • Performed Requirement Gathering, Analysis and implementation of SSRS reports.
  • Developed and maintained tables, queries, stored procedures and views to support business needs and reporting requirements.
  • Created SSIS packages to extract data from various source systems like Oracle and DB2.
  • Provided support to maintain the existing reports, software issue investigation, defect analysis and provided timely corrective actions.
  • Created complex stored procedures using dynamic SQL and CTE.
  • Created Ad-hoc reports and provided the result sets in excel sheets for user convenience.
  • Generated daily, weekly and monthly based reports to designated managers and clients.
  • Applied conditional formatting in SSRS to highlight key areas in the report data.
  • Optimized the performance of various SQL queries, stored procedures, CTEs and views.

Environment: Microsoft SQL Server 2005/2008, SSRS, SSIS, SQL Server Management Studio, Report Builder 3.0, DB2, Oracle, JIRA, TFS, YOM(You Owe Me).

Confidential

Philadelphia, PA
SQL Server Report Developer

  • Performed Analysis, Requirement gathering, designing Technical specifications, development, deploying and testing.
  • Designed and developed reports in SQL Server 2008 R2
  • Installed and Configured SQL Server Reporting Services 2008 r2.
  • Developed complex Reports involving Sub Reports, Matrix / Tabular Reports, Chart/Graph Reports, Parameterized reports, Cross-Tab reports, Drill down reports and Summary reports by using SSRS.
  • Created Reports in SSRS with different type of properties including Chart controls, filters, Interactive sorting, SQL parameters.
  • Administered Report Server to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
  • Created Stored Procedures and Views and datasets in TSQL.
  • Responsible for back up and restoration of SQL Reporting Service.
  • Created Report Snapshots to improve the performance of SSRS.
  • Applied conditional formatting in SSRS to highlight key areas in the report data.
  • Scheduled daily, weekly and monthly based reports to designated managers and clients.

Environment: Microsoft SQL Server 2008 / 2008 R2, SSRS, SQL Server Management Studio, Report Builder 3.0.

Confidential

Richfield, OH
SQL Server Developer

  • Performed Analysis, Requirement gathering, developing technical specification, development, deploying and testing.
  • Installed, configured SSRS and troubleshoot reporting services issues maintaining reporting site security.
  • Developed complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs and deployed them to Report Server for business users.
  • Implemented row level and data level security for reports developed in SSRS.
  • Defined Indexes, Views, Constraints, and Triggers to implement business rules.
  • Identified Facts, Dimensions, and Hierarchies of the business model.
  • Designed and developed SSIS Packages to extract data from various data sources such as Access
    database, Excel spreadsheet and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Used SSIS to create ETL packages to validate, extract, transform and load data
    to Data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.

Environment: Microsoft SQL Server 2005/ 2008, SSRS, SSIS, SQL Server Management Studio.

Confidential

Philadelphia, PA
SQL / Reports Developer

  • Actively supported business users for change requests.
  • Created several tables, views, triggers, stored procedures, indexes based upon the functional specifications.
  • Responsible for making weekly backup databases by using SQL Server 2005 and restore these databases in different server.
  • Gauged the effectiveness and efficiency of existing reporting systems.
  • Developed drill down, drill through, linked, tabular, matrix and chart reports.
  • Developed and implemented strategies for improving and further leveraging existing reports in order to transfer / convert to SQL Server Reporting Service.
  • Administered interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
  • Involved in installation, configuration, security, maintenance and restoration of SSRS on Windows Server 2003.
  • Designed, developed and deployed reports in MS SQL Server environment using SSRS-2005.

Environment: MS SQL Server 2000 / 2005, SSIS, SSRS, SQL Profiler, Management Studio, BIDS, Access.

Confidential

Hyderabad, India
Jr. SQL Server DBA/Developer

  • Involved in requirements gathering, analysis, design and development.
  • Migrated data from SQL Server 7.0 to SQL Server 2000 successfully.
  • Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User defined data types and Functions.
  • Tuned SQL statements (Using Indexes) and Involved in tuning the database.
  • Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
  • Created Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
  • Responsible for General Database Administration, Query Performance Tuning.
  • Creating reports and hosting it in the web for the users.

Environment: SQL Server 2000, T-SQL, SQL Server 2000 Reporting Service, VSS, Windows 2000 Server, Enterprise Manager, Query Analyzer, SQL Profiler.

Hire Now