We provide IT Staff Augmentation Services!

Product Developer (sql Server/ssis/ssrs Developer) Resume

SUMMARY

  • A Microsoft Certified Professional with around 5 years of total IT experience in the Design, Modeling, Development, Implementation and Support of SQL Server 2005/2008/2008 R2.
  • Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008.
  • Experience in using temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
  • Expertise in writing T - SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
  • Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
  • Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
  • Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
  • Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
  • Experience in Microsoft Visual C# in script component of SSIS.
  • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
  • Experience in creating configuration files to deploy the SSIS packages across all environments.
  • Worked with report manager for deploying the reports across all the environments.
  • Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
  • Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
  • Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008.
  • Developed Word merge reports in MS Word.
  • Ability to handle Multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
  • Good ability to quickly grasp and master new concepts and technologies.

TECHNICAL SKILLS

Operating Systems: Win 2000/NT/2003/2008 server.

RDBMS: MS SQL SERVER 2008/2005/2000 , MS Access.

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005, Query Editor, Reporting Server, MS-Access, ETL Tools Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS).

Reporting Tools: Crystal Reports XI/X, MS SQL Server Reporting Services (SSRS).

BI Tools: MS SQL Business Intelligence, Business Objects.

Programming Languages: VB.Net, C#.Net, Asp.Net, HTML and XML.

PROFESSIONAL EXPERIENCE

Confidential

Product Developer (SQL Server/SSIS/SSRS Developer)

Responsibilities:

  • Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).
  • Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
  • Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
  • Worked on formatting SSRS reports using the Global variables and expressions.
  • Created parameterized reports, Drill down and Drill through reports using SSRS.
  • Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
  • Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
  • Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
  • Prepared the complete data mapping for all the migrated jobs using SSIS.
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Developing ASP.net pages for front, creating services
  • Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
  • Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: SQL Server 2008/2005, SQL Integration Services (SSIS), Business Intelligence Development Studio, Visual Studio 2008/2005, OLE DB

Confidential

Product Developer

Responsibilities:

  • Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).
  • Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
  • Prepared the complete data mapping and Report Definitions for the project which involved around 10 reports.
  • Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
  • Worked on formatting SSRS reports using the Global variables and expressions.
  • Created parameterized reports, Drill down and Drill through reports using SSRS.
  • Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
  • Conducting training sessions to new employee of SSRS.

Confidential

Programmer.

Responsibilities:

  • Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).
  • Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
  • Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
  • Customize the crystal reports as per client’s requirements.
  • Fixed data issues.
  • Designing & developing stored procedures, functions, triggers & indexes etc database objects.
  • Tuned SQL queries and procedures for better performance.
  • Developing crystal reports, Excel reports, HTML/ASP pages for front end reporting & supportive data entry screens
  • Involved in the client and account manager call.
  • Conducting training sessions to new employee of crystal reports, coding guidelines.

Hire Now