SUMMARY

• 8 years of experience in the IT industry as a SQL Server Developer/Business Intelligence Developer.
• Experienced in all phases of project life cycle starting from business requirement gathering, analysis, design, implementation, testing, and production.
• Expertise in the installation, development, implementation and maintenance of SQL Server 2005/2008/2008 R2/2012 including the MS SQL Server suite of products like SSAS, SSIS, SSRS.
• Highly proficient in migrating data from heterogeneous and legacy systems to SQL Server using Microsoft SSIS 2005/2008/2008 R2/2012.
• Highly proficient in all aspects of database implementation including development, normalization, de - normalization and performance tuning.
• Proficient in developing Stored Procedures, Views, Functions, Triggers, XML and complex queries on SQL Server 2005/2008/2008 R2/2012 and Oracle 8i/9i/10g.
• Proficient in Database performance optimization, debugging and tuning using the query analyzer, SQL Profiler and SQL Server Debugger.
• Expert in creation of Extract, Transform and Load (ETL) processes for large-scale Data Warehouses and SQL programming skills
• Expert in creation of complex SSIS packages that utilize script components, loops, Expressions, variables, constraints, error handling and logging and transformations like look-up and merge join.
• Expert in creating reports using SQL Server Reporting Services (SSRS), sourcing OLAP cubes and data warehouses.
• Proficient in creating Standard, Cross Tab, Drilldown, Sub-reports, OLAP, On-demand sub reports and Chart Reports, ad-hoc reports using SSRS. Well versed with design and development of ad-hoc reports.
• Proficient in developing Ad-hoc reports using Data Flow Diagrams, Process Models, ER diagrams, Dimensional Data Models.
• Extremely motivated, well organized and strong team player with an ability to adapt to new technologies quickly.

TECHNICAL SKILLS

• MS SQL Server 2005/2008/2008 R2/2012
• Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• SQL Server Integration Services (SSIS)
• MS SQL AZURE
• ASP.NET
• VB.NET
• C#.NET
• ADO.NET
• Oracle 8i/9i/10g
• PL/SQL
• Oracle BI Publisher
• Windows NT/2000 Server/XP/Server 2008/7
• VB.NET
• MS Share Point
• VISIO
• HTML
• XML
• XSL
• Java script
• VB Script
• Visual Studio 2008/2010/2012
• PHP.

PROFESSIONAL EXPERIENCE

Confidential, Parsippany, NJ

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from system users.
• Efficiently involved in developing physical and logical design of database, incorporating new business requirements, and implemented the new design into SQL Server 2008.
• Created new tables, written stored procedures for Application Developers and some user defined functions, indexes, views etc.
• Designed ETL process to load data from different sources like text file, excel or various database. Performing migration of the data from text file or database to staging and from staging to data warehouse.
• Designed expense report with the use of the fact and dimension table model. Also, designed the aggregate table for the usage summary reports.
• Defined parent and child relationship by using common table expression.
• Using a slowly changing dimension to load the data in to DW and maintain the historical data. Using different control such as for loop container, lookup, merge, union all.
• Responsible for the design of the SSIS package for the updated expense amount from OLTP database.
• Maintained nightly and weekly data loads by scheduling the corresponding ETL job in SQL Server Agent.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server.
• Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
• Optimized queries and did performance tuning using various MS SQL Server tools such as SQL Profiler, SQL Performance Monitor and execution Plan and Index Tuning wizard.

Environment: SSIS, MS SQL Server 2008, Windows server 2003/2008, ASP.NET, VB.NET, C#.NET,ADO.NET, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS Access, MS Excel, SQL Server Business Intelligent Development Studio

Confidential, NYC, NY

MS SQL Developer/ SSRS/ SSIS Developer

Responsibilities:

• Developed Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Developed and deployed data transfers, scheduled packages using SSIS, also maintained the jobs running on Servers.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Created Ad-Hoc Reports, Sub-reports, Drill-down reports, Drill-through reports, Chart reports, Summary reports and Parameterized reports in SSRS.
• Identified various facts and dimensions from the source system and business requirements to be used for the data warehouse.
• Created the Multi-dimensional data models such as Star Schemas and Snow Flake Schema for developing Cube.
• Created OLAP cubes on top of the data warehouse basing various fact and dimension tables for analysis purposes using SQL Server Analysis Services (SSAS) 2005/2008/2008 R2.

Environment: Windows XP/2003 Enterprise Edition, MS SQL Server 2005/2008R2, ASP.NET, VB.NET, C#.NET,ADO.NET, Excel, Visual Studio, TFS, VBScript, Database Engine Tuning Advisor, Profiler, SQL Server Management Studio, Reporting Services Configuration, SSIS, SSRS.

Confidential, Parsippany, NJ

MS SQL Server Developer/Business Intelligence Developer

Responsibilities:

• Gathered requirements from the end users, discussed business rules, created functional and technical specification documents and the highly critical design documents.
• Designed, developed and deployed new packages in the SSIS environment to facilitate loading data from legacy systems and other diverse sources into staging.
• Designed the ETL architecture, analyzed and stream lined the flow of data from the Topspeed database into SQL Server 2008 R2.
• Installed and configured the appropriate drivers, Microsoft SQL Server 2008 R2 and all the other suite of products such as SSIS, SSAS, SSRS 2008/2008R2.
• Created complex Stored Procedures/T-SQL code involving complex joins, CTEs, Correlated sub queries, views and functions to check for the integrity and consistency of the data, to enhance performance and migrate data to the Target Staging Database.
• Developed Visual Basic scripts in SSIS to achieve complex functionality that would facilitate the profiling as well as the loading of the Target Staging Database tables.

Environment: Microsoft SQL Server 2008/2005/2000 , DTS, SSIS, SSAS, SSRS, Microsoft SharePoint, Microsoft Visio Professional 2005. VB.NET

Confidential

Programmer

Responsibilities:

• Designed DTS Packages to transfer data between servers, load data into database, archive data file from different DBMS using SQL Enterprise Manager/SSMS on SQL Server 2005 environment, and deploy the data; scheduled the jobs to do these tasks periodically.
• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency checks and index defragmentation.
• Set up database backup and recovery strategies.
• Maintained all records of project status and followed changes as per control procedures.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: MS SQL Server 2005 Enterprise, Windows Enterprise Server 2003, .NET, Microsoft Visual Studio 2003/2005, T-SQL