OBJECTIVE

• To contribute strong background in solutions implementation and customer service, along with unique drive for excellence and success.

SUMMARY

• 8 years of MS SQL Server Development experience in Retail products, workforce management and reporting in Insurance domain with expertise in MS SQL Server 2005/2008 suite of products like SSIS, SSAS, and SSRS, in additional worked as a Web developer with Visual Studio .NET 2005/2008/2012 suits of product like ASP.NET, VB.NET.
• Experienced in supporting/handling multiple products like Workforce Management and desktop process analytics from Verint Impact 360, Knowledge management from Interdiem, Performance Reporting from ASPECT, Desktop Analytics and Behavioral analytics from Mattersight.
• Having an good understanding in the business process and technical details on the In - bound and Outbound call management systems.
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server 2005 and MS SQL Server 2008 respectively.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Expertise in Developing and Extending MS SQL Server Analysis Services 2005/2008 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2008 (SSRS).
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008.
• Strong experience in Stored Procedure/TSQL coding, Performance Tuning, and Query Optimization.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Experienced in Logical and Physical Database design & development, Data Conversion, Normalization and SQL Server Enterprise manager.
• Excellent experience in Designing, Maintaining & Tuning various RDBMS like T-SQL & MS SQL Server 2000/2005, MS Access databases and strong knowledge of SDLC principles.
• Involved in all phases of software development life cycle: design, implementation and testing.
• Basic knowledge of working and implementation of Crystal Reports, converting Crystal reports to SSRS Reports and in upgrading crystal reports 8.5/9.0/10 to XI.
• Specialized in analysing, coding, implementing and creating complex query reports using SQL Server 2000/2005/2008.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills.

TECHNICAL SKILLS

Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data Transformation Services (DTS), Visio, Cognos reporting.

Databases: MS SQL Server 2008/2005/2000 , Oracle 8i, 9i/10g, MS Access 97/2000,DB2

Languages: T-SQL, C#,VB.NET,ASP.NET

Scripting: HTML, DHTML, MDX, XML,XSLT

Operating Systems: Windows server 2003, Windows 2008 server, Windows 95/98/NT/4.0/2000,XP,Win 7

3rd Party Tools/Products: Workforce management, Scorecards, Desktop process analytics - Verint Impact 360

PROFESSIONAL EXPERIENCE

Technology Analyst - MS SQL Server Developer/SSRS/SSAS

Confidential, Northbrook, IL

Responsibilities:

• Fixed the bugs present in already existing reports.
• Developed many Tabular Reports, Matrix Reports, Drill Down Reports and Charts using SQL Server Reporting Services (SSRS).
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Deployed the generated reports directly on the client’s workstation.
• Created many multi valued parameters in the reports.
• Created many Cascaded parameters in the reports using MDX and T-SQL.
• Improved Report Performance and performed unit testing.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Created the structure of the model and cube in MS Analysis Services (2008).
• Analysed and designed software and database solutions.
• Reviewed Cube with End user and changing the cube and documentation according to their requirements.
• Defined relationships between Measure groups and Dimensions.
• Generated automatically grouping attribute members.
• Implemented the calculations to aggregate physical measures.
• Created MDX queries to retrieve data from the cube and also to display SSRS reports.
• Created reports to generate them through Email for the administrative using MDX Queries.
• Designed Cube partitioning and incremental synchronization for SSAS cubes.
• Modified existing reports according to requirements of the end users.

Confidential

Business Intelligence Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, deployment and user training.
• UI Development for the Chit and finance management
• Developed Windows Mobile component.
• Mentored a team of 4 including the implementation and support for the chit and finance management.
• Involved in writing Custom Functions to be used in other Functions.
• Understood an existing system and designed modifications to the system to support new requirements.
• Designed, developed and tested processes, which include the creation of SQL views, scripts and stored procedures.

Confidential

Software Developer

Responsibilities:

• Engaged in developing the web modules.
• Built the scripts for validation of the in the client side performance improvements.
• Developed a SCM tool for Lead marketing and management.