SUMMARY

• MS SQL Server Developer 2012/2008R 2/2008/2005/2000 with 8+ years of IT experience in various Industry verticals like Health Care, Finance, Insurance and Service. Maintained positive communications and working relationships at all business levels.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Experience in analytical Database Design and Data Modeling skills using MS Visio and ERWIN.
• Expert in ETL - Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning ETL workflows designed in DTS for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Expert in developing and modifying multi-dimensional cubes using MS SQL Server Analysis Services (SSAS).
• Hands on experience in implementing Key Performance Indicator (KPI) Objects and partitions in SSAS 2012/2008R2/2008/2005
• Experienced in developing and modifying cubes using SSAS and transform into pivot table.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2012/2008r 2/2008/2005.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS)
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages
• Efficient in up gradation and migration from MS SQL Server 2005 to MS SQL Server 2008
• Hands on experience in production/staging/test/development database administrative: Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Quick learner, excellent communication skills and good performer both in team and independent job environments. Never missed the deadline of any projects.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R 2/2008/2005/2000
• MS SQL Server 2008/2005 Analysis Services (SSAS)
• MS SQL Server Integration Service (SSIS)
• MS SQL Server Reporting Services (SSRS)
• Business Intelligence Development Studio (BIDS)
• BCP
• SQL Profiler
• Enterprise manager
• Management studio
• Microsoft Access 2000
• ERWIN 4.0/4.1/4.2/7.2
• Microsoft Visio 10.0/11.0
• T-SQL
• ASP.NET
• C#
• VB.Net
• HTML
• XML
• XSL
• Oracle 11g/10g
• Crystal Reports 8.5/9/10/11
• TFS
• Visual source safe 2005
• MS office 2007/2003
• Windows 2008/2003/2000 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation
• UNIX
• Perl
• VBScript
• JavaScript
• Dream Weaver CS4
• Web Updater II
• SSH Tectia
• Web Ex.

PROFESSIONAL EXPERIENCE

Confidential, NJ

MS SQL Server/SSIS/SSRS/ BI Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Involved in Planning, Defining and Designing database using Erwin on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2012.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database objects like stored procedures, functions, tables, views.
• Configured the report viewing security for various users at various levels using Report Manager.

Confidential, San Antonio TX

SQL Server / SSIS/SSRS/SSAS Developer

Responsibilities:

• Worked with business stakeholders, application developers, productionteams and across functional units to identify business needs and discuss solution options.
• Worked in the Agile methodology using Scrum which has its primary focus on the management part of the software development, dividing the whole development period into small iterations (of thirty days) called "sprints."
• Used Visual Intercept Manager, the premiere bug tracking system for the Microsoft development environment, which is project oriented, scalable and optimized.
• Developed and deployed SSIS packages for ETL fromOLTP and various sources to staging and staging toData warehouseusingLookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimensionand more. Performed ETL mappings using MS SQL Server IntegrationServices.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures,function, packages.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Responsible for creating cubes and dimensions using MS SQL Server Analysis Services (SSAS).
• Created business critical KPIs using MS SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• Developed and delivered dynamic reporting solutions using MS SQL Server 2008 Reporting Services (SSRS).
• Involved in monitoring and tuning report performance by analyzing the execution plan of the report.
• Generated Drill down, Drill through, Adhoc, Matrix Reports, parameterized reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports at branch and bank level.
• Involved in table and indexpartitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensuredatabase optimization.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Helped create process logging and new monitoringtools, integrity reports, and mapping tools.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.

Confidential, Fairfield NJ

MS SQL Server Developer/ SSIS / SSAS Developer

Responsibilities:

• Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
• Successfully installed and configured MS SQL Server2008R2 on the development server.
• Automated the migration of data from Flat file to MS SQL Server 2008R2 DB using Microsoft SQL Server Migration Assistant (SSMA).
• Generated assessment reports to analyze the scope and complexity of the migration projects.
• Designed a new schema design for the data warehouse using dimensional modeling and developed it using the Erwin tool.
• Migrated the entire schema as well as data into MS SQL Server 2008R2 and also validated the migration process to ensure that it has been successfully migrated.
• Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.
• Performed various transformations like conditional split, sorting and included data about the environment using the audit transformation.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional expression (MDX) to access them.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Defined referential relationships with the measure groups and fact tables.
• Generated automatically grouping attribute members and implemented the calculations to aggregate physical measures.
• Defined granularity within measure group and drill through actions.
• Created cube reports that can be browsed at summary level and can be drilled down to the detail level.
• Defined the browsing perspectives and browsing translations since most transactions were online.
• Documented the development work and production release for future reference.

Confidential, Dublin OH

MS SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in all the phases of SDLC.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of Constraints and Triggers for Data Consistency.
• Used Stored Procedures for updating Servers.
• Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Ware House.
• Developed, deployed and monitored SSIS Packages. Involved in creating log files for SSIS packages.
• Created SSIS Package configurations for executing in different environments.
• Enabled Check points in SSIS package. Created break points in order to view the status of data, variables and over all status of SSIS package.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Developed and Deployed different types of Reports like List, Matrix, and Chart and Sub Reports etc.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created/ Maintained clustered/ non clustered Indexes for fast and efficient reporting process.
• Used SSRS to create interactive reports with an ability to drill down into details.
• Create OLAP cubes with SSAS based on multidimensional database with star schema or snow flake schema
• Created named set and named calculations to create derived data and calculated field and calculations in the KPI.
• Extensively involved in the SSAS storage and partitions and Aggregations, Calculation of queries with MDX, developing reports using MDX and T-SQL.
• Created MDX script for representing Cube Calculation using SSAS.

Confidential, Jacksonville FL

MS SQL Server/ SSRS/SSIS/BI Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect used (Kimball’s approach)on the development of logical data models.
• Installed and configured MS SQL Server 2005 along with Visual Studio on a network domain system.
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Designed and implemented complex SSIS package to migrate data from multiple data sources (Teradata) for data analyzing, deploying and dynamic configuring of SSIS packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to CDW with the help of SSIS.
• Created OLAP cubes and dimensions for the analysis of student’s registrations in specific areas using SSAS.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services 2005.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2005.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in MS SQL Server 2005 with the use of the Query Analyzer and Database Engine Tuning Wizard.
• Established backup and recovery of MS SQL server 2005 by using SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Used Visual Source Safe (VSS) for version control.

Confidential, Philadelphia PA

Jr. SQL Developer

Responsibilities:

• Defined and designed the data sourcing and data flows, data quality analysis.
• Identified the data source and defined them to build the data source views.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used SQL Server Agent to automate the SSIS 2005 package execution.
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2005 and then created reports using this data using SSRS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2005.
• Tested and managed the SSIS 2005 and SSIS 2005 packages and was responsible for its security.
• Created business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Developed and designed cubes with dimensions, Measures and calculated members.
• Developed reports using efficient data retrieval techniques and tested the reports.
• Created Cross-Tab, Drill-down and Sub-Report using SSRS 2005.