Ssrs Report Developer Resume
Atlanta, GA
SUMMARY
- 7 Years of Total IT Exp., in the Business Requirements Analysis, Application Design, Development and Implementations of web Based Applications.
- Excellent working experience in domains Banking,Health Care, Automation and Financial services
- Excellent experience in developing Custom Reports, different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
- Extensively used Report Wizard, Report Builder for developing and deploying reports in SSRS.
- ExtensiveSQL Server database experience and good knowledge in scripting stored procedures, triggers and user - defined functions in T-SQL.
- Knowledge on different reporting tools (SSRS, Crystal Reports)
- Expert experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
- Created custom and standard reports using Crystal Reports.
- Developed parameterized crystal reports existing reports for presentations using cross-tab reports, running totals and alerting.
TECHNICAL SKILLS
Databases: SQL Server 2000/2005/2008/ R2, Oracle 8i/9i/10g, DB2
Microsoft BI tools: SSRS Report Designer, Report Builder and PowerPivot
Languages: T-SQL, C#, Visual Basic.NET
Operating Systems: Windows 98/XP/Vista, Windows Server 2000/2003
Other tools: Query Analyzer, SQL Profiler, Visio, XML, XSD, DTD, DHTML, Microsoft Office Suite, Microsoft Visual Source Safe, Microsoft Visual Studio, ADO.NET, Crystal Reports
PROFESSIONAL EXPERIENCE
Confidential, Atlanta, GA
SSRS Report Developer
Responsibilities:
- Design Reports using Business Intelligence Management Studio
- Data Transfer from Ms-access to SqlServer using SSIS
- Create stored procedures and functions using SQL server 2005
- Create DAL for database interaction
- Employ validation controls to validate input pages
- Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
- Applied knowledge of Normalization and De-Normalization techniques.
- Writing queries to createstored procedures, User Defined Functions, Views, Triggers
- Using all kinds of SQL ServerConstraints(Primary Keys, Foreign Keys, Defaults, Check, Unique etc).
- Writing ComplexT-SQLQueries, Sub queries, Co-related sub queries and Dynamic SQL queries.
- Performance tuningof Stored Procedures and T-SQL Queries.
Environment: C#.NET, ASP.NET 2005, SSRS, SSIS, MS SQL Server 2005, IIS7, Windows 2003 Server
Confidential, Valley Forge, PA
SSRS Report Developer
Responsibilities:
- Gathered the report development and designed the specifications document
- Data Transfer from Ms-access to SqlServer using SSIS
- Create stored procedures and functions using SQL server 2005
- Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, Joins and other T-SQL code to implement business rules
- Using all kinds of SQL ServerConstraints(Primary Keys, Foreign Keys, Defaults, Check, Unique etc).
- Created parameterized reports and adhoc reports using Report builder for theclients.
- Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users.
- Coordinating post-implementation events such as testing.
Environment: C#.NET, ASP.NET 2005, SSRS, SSIS, MS SQL Server 2005, IIS7, Windows 2003
Confidential, Indianapolis, IN
SSRS Developer
Responsibilities:
- Gathered the report development and designed the specifications document
- Create stored procedures and functions using SQL server 2005
- Develop reports using Crystal Reports, sub reports using formulas
- Create DAL for database interaction
- Validate the reports by comparing results with the Database
Environment: C#.NET, ASP.NET 2005, Crystal Reports, MS SQL Server 2005, IIS7, Windows 2003 Server
Confidential
SSRS Developer
Responsibilities:
- Design Reports using Business Intelligence Management Studio
- Data Transfer from Ms-access to SqlServer using SSIS
- Create stored procedures and functions using SQL server 2005
- Create DAL for database interaction
- Coordinating post-implementation events such as testing
- Client Interaction
Environment: C#.NET, ASP.NET 2005, SSRS, SSIS, MS SQL Server 2005, IIS7, Windows 2003 Server
Confidential
SSRS Developer
Responsibilities:
- Gathered the report development and designed the specifications document
- Create stored procedures and functions using SQL server 2005
- Develop reports using Crystal Reports, sub reports using formulas
- Create DAL for database interaction
- Developed parameterized crystal reports existing reports for presentations using cross-tab reports, running totals and alerting.
- Validate the reports by comparing results with the Database
Environment: C#.NET, ASP.NET 2005, Crystal Reports, MS SQL Server 2005, IIS7, Windows 2003 Server