SUMMARY

• Over 9 years of solid IT working experience in in the database design, development and deployment of large - scale enterprise applications.
• Proficient in SQL Server 2012/2008/2005/2000 TSQL and BI products like SSIS/SSAS/ SSRS
• Vast experience on database development in OLTP (TSQL) and OLAP(SSIS, SSRS and SSAS)
• Experience in report writing using SSRS and creating various types of reports like Drill Down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports
• Experience in writing expressions in SSRS and Expert in fine tuning the reports
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users like VP, AVP, CD, Coach, Lead, SA, SR, Office Clerk
• Experience in extracting, transforming and loading data using DTS/SSIS, and Import Export Wizard
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS)
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages
• Expert in creating SSAS cubes and creating dashboards in PPS (Performance Point Server) using Business Modeler
• Creating Static Reports using MDX queries and creating MDX Base Report Definition
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Functions, Cursors and Indexes using T-SQL.
• Experience in using T-SQL in SQL Server 2000/2005 and 2008 platforms
• Experience in Performance Tuning and Query Optimization
• Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts and SSRS Reports with PPS

TECHNICAL SKILLS

Relational Databases: SQL Server 2012/2008R 2/2008/2005/2000/7.0 , Oracle 11g, 10g, 9i, 8.0, MS Access, DB2, SQL*PLUS

Operating Systems: UNIX, Windows 2000/2003/2008 Server, Windows NT, XP

Languages: C, C++, PL/SQL, Java, VB 6.0 and T-SQL

Web Technologies: ASP.NET, VB.NET, Web Services, HTML, DHTML, Java ScriptVBScript, IIS 4.0, IIS 5.0, Application Server

Other Tools: VERITAS, IDERA, Crystal Reports, Test Director

PROFESSIONAL EXPERIENCE

Confidential, NJ

SQL Developer with C#.Net

Responsibilities:

• Installation and configuration of SQL Server 2008.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports, Linked Reports, Reports using stored procedures using Sql Server Reporting Services 2008.
• Experience in creating Adhoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Involved in scheduling, creating snapshots and subscriptions for the reports. (SSRS 2005/2008).
• Designed and developed packages for data warehouse using Integration services (SSIS) SQL Server 2005/2008.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Regular responsibilities for updating and staging the dimensional databases as well as rebuild the Dimensions and cubes in Analysis Services.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy exact lookups using SSIS tasks.
• Imported data from text files and excel spread sheets into SQL Server 2005 database using SSIS package.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Experience in Planning and Monitoring reports in Performance Point Server.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, Performance Point Server 2007,C/C++.

Confidential, KS

Sr. SQL BI (SSIS/SSRS) Developer

Responsibilities:

• Performed all SDLC phases related to extraction, transform, and loading (ETL) processes by using SQL Server Integration Services (SSIS) and SQL Server stored procedures in MS SQL Server 2005 and 2008 environments
• Developed complex canned reports using SQL Server 2012/2008 Reporting Services (SSRS)
• Created and maintained data flow diagrams for existing and future ETL processes
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL
• Created and maintained detailed source-to-target ETL mapping specifications
• Participated in on-call support rotation for nightly ETL batch cycles
• Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency; and resolve other technical problems
• Developed highly optimizedstored procedures, functions, and database views
• Translated business requirements intoBIapplication designs and solutions
• Involved in performance monitoring, tuning and capacity planning
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Analyzed the existing tool and participated in meetings with the business users to gather Requirements and design goals of data warehouse
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
• Have written Reports, Sub Reports, drill down reports using various features like Charts, graphs, filters, parameters, indicators, gauges, spark lines
• Created stored procedures to be used as datasets for the Report Design
• Involved in generating reports for Forecasting Revenues based on the historical data and used various delivery mechanisms and formats to deliver Reports

Environment: MS SQL Server 2008/2012, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Microsoft Visual source Safe, Toad Data Modeler, SSRS.

Confidential, Chicago, IL

SSIS /SSAS Developer with ASP.Net and C#.Net

Responsibilities:

• Installation and configuration of SQL Server Reporting Services (SSRS) 2005.
• Experience in creating Tabular reports, Matrix reports, chart reports, List reports, Parameterized reports, Sub reports, Adhoc reports through Report Builder.
• Involved in creating report models and applying row level security filters for report model.
• Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Played a major role in production support of SSAS (cube refresh), SSIS jobs.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Experience in writing complex MDX queries for calculated members and measure groups.
• Creating Advanced KPI’s for the cubes using ProClarity (SSAS).
• Involved in taking backups of SSAS database and restoring them when needed.
• Experience in building Reports on Analysis Services cubes.
• Writing Shell scripts for system maintenance and automation of server.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Extract Transform Load (ETL) development using SQL Server 2005 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc to sql using SSIS.
• Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc using SSIS.
• Enhancing and deploying the SSIS Packages from development server to production server. Prototyped and Demonstrated a Performance Point Server and SharePoint 2007 (MOSS) Portal Solution.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS).
• Involved in Change Management and creating Autosys jobs.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005 Enterprise Edition, .Net 3.5,SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, ProClarity Server, XML, MS PowerPoint, MS Project, MS Access 2003 & UNIX, Shell Scripting, Oracle, Crystal Reports.

Confidential, CA

SQL Server BI developer (SSIS/SSRS/SSAS)

Responsibilities:

• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems
• Extract Transform and Load (ETL) source data into respective target tables to build the required data marts
• Created ETL packages to load data from Oracle to SQL Server using various transformations in SSIS
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views)
• SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL
• Identified the dimension, fact tables and designed the data warehouse using star schema
• Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS)
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling
• Used SQLCMD to write Stored Procedures in command line utility and it uses OLEDB to execute T-SQL batches
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Defined appropriate measure groups and KPIs & deployed cubes
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS)
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS
• Created T-SQL Functions, Cursors, views, indexes, stored procedures and triggers

Environment: SQL Server 2005/2008, Windows 2000/2003, Microsoft office 2003,XML,T-SQL, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), MDX, SQL Profiler, MS Excel 2003, Visual Studio 2005,.NET Frame Work 1.0,SharePoint 2007.

Confidential

SQL Developer

Responsibilities:

• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Package Jobs
• Performed cost benefit analysis of different ETL packages (SSIS) to determine the optimal process
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description
• Responsible for Data migration from SQL Server 2000 to SQL Server 2005 Databases
• Developed an automated report subscription process using SSRS
• Applied conditional formatting in SSRS to highlight key areas in the report data
• Used Report Builder to do Ad-hoc Reporting
• Created report links to refer to other reports in a particular report
• Resolved any deadlocks issues with the Databases/Servers on a timely basis
• Handled Underwriting and pricing of renewal accounts within underwriting authority for Property Casualty, General Liability, Business, Automobile, Umbrella Liability, Crime and Workers Compensation
• Assisted (via remote) with payroll, tax, and account processing
• Imported and exported data into MS Access databases and Debugged VBA scripts linked to said databases
• Created multiple hierarchical aggregates for faster performance
• Installed SQL server 2000 on Windows 20003 servers and involved in Physical and logical Database Design using Erwin tool
• Created database objects like tables, users, roles, stored procedures, triggers
• Worked on solving issues by doing data recovery in existing database
• Used various formatting techniques like interactive sorting, grouping to created user friendly reports

Environment: SQL Server 2005, Windows 2000/2003,MS Access 2000/2003,T-SQL,Windows 2000 Advanced Server, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services.

Confidential

SQL Server Developer

Responsibilities:

• Actively participated and interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views)
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle 8i
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Created reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Deployed the SSRS reports in Microsoft share point portal server MOSS 2007
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML
• Involved in deployment of SSRS reports on the SharePoint Portal
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Wrote stored procedures to get the fields required for the reports
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports

Environment: SQL Server, 64 bit edition of SQL server 2000), DTS, Crystal Reports, Microsoft Business Intelligence Development Studio, VB Scripts, SQL Queries, Stored Procedures, Office, Excel, SSRS, SSIS, ERWIN.