SUMMARY

• Over 8 years of strong experience in the IT industry as a MS SQL Server Developer include experience in design, development, implementation and administration of database systems using MS - SQL Server 2012/2008R 2/2008/2005/2000 for both OLTP & Data Warehousing Systems applications with various business domains like Financial, pharmaceutical and manufacturing.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance
• Experience in Performance Tuning and Query Optimization.
• Expert in maintaining Error logging using Exceptional Handling in T-SQL and SSIS.
• Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and unattended Installation
• Good knowledge of System Development Life Cycle (SDLC).
• Expert Knowledge of Integration Services (SSIS), Analysis Services (SSAS) and Reporting Services (SSRS)
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, and Sub Reports.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Developed Drill Down, Cascading, Drill through, Sub reports and Charts using Global variables, Parameters Expressions and Functions for the Business Users
• Experienced in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Expert in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS), creating Dynamic packages for Incremental Loads.
• Worked Extensively on ETL process using SSIS package.
• Experience in enhancing and deploying the SSIS Packages from development server to production server by using package configurations
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using DTS/SSIS.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Developing reports on SSAS & SSRS on SQL Server (2000/2005). Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery, running Database Consistency Checks using DBCC.
• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2008/2005/2000.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.

TECHNICAL SKILLS

Languages: C, SQL

RDBMS: MS SQL Server 2008/2008 R2, 2005, 2000, 7.0, MS-Access

Web Technologies: HTML and XML

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, SSIS, SSRS, SSAS

Data Modeling Tool: ERWIN, Microsoft Visio

Operating System: Windows 95/98/2000/XP/NT, MS Dos and UNIX

Tools: Microsoft Visual Studio 2008, MS Office

PROFESSIONAL EXPERIENCE

Confidential, San Ramon, CA

SQL BI Developer

Responsibilities:

• Worked closely with Business Analysts and data modelers in design of logical and physical design.
• Involved in Development and Coding of SSIS packages for Wholesale Credit Data Mart.
• Involved in Data Extraction from various System of Records (SORs) like ORACLE, SQL Server, Teradata and Flat Files for the Wholesale Credit Risk Data Warehouse.
• Designed and Developed ETL Process for integrating data from sources like Excel, CSV, Flat Files, Web Services, XML Source and SQL Server.
• Created SSIS packages to extract and load data into the data mart using various transformations.
• Having good experience in implementing SSIS logging and error handling.
• Used checkpoints to implement the restart ability of the packages in SSIS
• Implemented custom logging in SSIS using event handlers and execute SQL task.
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
• Have deployed packages on different servers by using Package configurations.
• Experience in building reports through REPORT BUILDER and REPORT DESIGNER.
• Experience in creating reports using REPORT MODEL and applying row level security filters.
• Experience in designing CRYSTAL REPORTS visualizing them Exploring and delivering the reports via the web.
• Experience in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS)
• Created partitions to improve the performance of data retrieval.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.

Environment: Microsoft Windows 2008, Microsoft SQL Server 2008 and 2008 (R2), SSRS, SSIS, Auto sys, Aqua studio, PAC 2000, TFS.

Confidential, Monroeville, PA

MS SQL/ SSIS DEVELOPER

Responsibilities:

• Worked with Business Analysts and Users to understand the requirement.
• Involved in Data Extraction from various System of Records (SORs) like ORACLE, SQL Server, Teradata and Flat Files for the Data Warehouse.
• Designed and Developed ETL Process for integrating data from sources like Excel, CSV, Flat Files, Web Services, XML Source and SQL Server.
• Designed packages which utilized Tasks and Transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Utilized event handling effectively to generate audits and logs for the generated SSIS packages.
• Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
• Worked with Auto sys Software for Job Scheduling and automation.
• Created Database Objects like Tables, Views, Stored Procedures, Indexes and Triggers.
• Created complex queries which involve usage of Joins, Sub-queries, Functions, Temporary tables etc.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Created Indexes for fast retrieval of the data and used string functions for space management in database. Involved in Performance tuning and Query Optimization using execution plan.
• Extensively involved in for end-to-end testing, Data Validations and Reconciliation of the Data Loads for the Mart.
• Provided on- and off-hours support of production ETL processes for Data Mart applications
• Developed and documented source to target mapping specifications and logic for the Data Mart.
• Create Test Plans, Test Cases and logs defects
• Responsible for maintaining scripts, promotion checklist, project documentation and documentation for the ETL Process in Team Foundation Server and Visual Source Safe

Environment: SQL Server 2008, MS Server Integration services, SSRS (MS server Reporting Services), Window 2007 Server, and TFS, Auto sys, Aqua studio.

Confidential, Dublin, OH

SQL Server SSIS / SSRS Developer

Responsibilities:

• Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports OLAP reporting, dashboards, and scorecards.
• Created SSIS packages to pull data from SQL Server and exported to Excel Spreadsheets and designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments.
• Created the SSIS /DTS packages and scheduled them using Sql Server agent
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension .
• Utilized event handling effectively to generate audits and logs for the generated SSIS packages.
• Performed archiving and achieved automated processing of the raw data through the ETL process in SSIS.
• Used Vb.net and C# in Script task of SSIS 2008 Packages
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager
• Performing data transfer/migration using Export/Import and Data Transformation Services.
• Pulled data from various tables and databases to generate reports using different types of joins
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Experience in creating snapshots of static reports and configure subscription
• Developed Query for generating Drill Down and Drill Through Reports in SSRS Microsoft visual studio(MSVS)
• Designed and formatted SSRS Reports using Parameters and Expressions for the Reports.
• Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.
• Build different types of chart reports using SSRS like column chart and Pie charts.
• Created sub reports and pass through parameters from main report to the sub reports.
• Deploying and Scheduling Reports using SSRS to generate all daily, weekly,monthly and quarterly reports including current status.
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Created snapshots of reports to reduce the load on the server using SSRS 2008

Environment: Erwin, SQL Server 2008 R(2), MS Server Integration services, SSRS (MS server Reporting Services), Window 2007 Server, Crystal Reports, JIRA and TFS.

Confidential, Columbus, OH

SQL Server SSIS /SSAS Developer

Responsibilities:

• Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports, OLAP reporting, dashboards, and scorecards.
• Involved in the dimensional modeling of Data warehouse using Erwin tool
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Improved the performance of the slow running queries.
• Created appropriate Triggers to assist efficient data manipulation and data consistency
• Migrated DTS Packages of SQL Server 2005 to SQL Server 2008 as per business requirement
• Responsible for ETL Operation which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS)
• Extensively used transformations, control flow tasks, containers and event handlers.
• Used checkpoints to implement the restart ability of the packages in SSIS
• Implemented custom logging in SSIS using event handlers and execute sql task.
• Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
• Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages in visual studio(MSVS)
• Created dynamic Package Configuration of type Sql Server table.
• Good understanding in Data Marts and data warehousing concepts (OLTP & OLAP). Worked with Data mining and slowly changing dimensions
• Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access and Microsoft Visio
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Involved in Analyzing, designing, building of OLAP cubes with SSAS 2008(R2) Identified and defined Fact relationships in SSAS
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Worked on PERFORMANCE POINT SERVER to build advanced KPI’s for the cubes.
• Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases
• Involved in Optimization and Performance of queries and stored procedures using SQL Execution Plan

Environment: Erwin, SQL Server 2008R(2), MS Server Integration services, SSRS (MS server Reporting Services), MS SSAS, 2007 Server, Crystal Reports, Share Point Server 2010,VB.net.

Confidential

SQL BI DEVELOPER

Responsibilities:

• Requirement gathering - Solution design
• Actively involved in Normalization of database.
• Worked on DDL and DML operations on MS SQL Server 2000
• Involved in performance tuning (DB Tuning) and monitoring of T-SQL blocks.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data
• Created and developed data dictionary, tables, views, indexes, functions and advanced queries for databases by using Query Analyzer and SQL Server Enterprise Manager
• Performing data transfer/migration using Export/Import and Data Transformation Services.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000/2005.
• Used Try catch block, Merge and Common table expressions in T-sql
• DB Tuning And optimizing SQL Server by using performance monitor.
• Create packages, procedures, functions and triggers. Handle database performance and DB tuning.
• Created SSIS process design architecting the flow of data from various sources to target
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Data transfers between various servers using DTS.
• Creating and running DTS Packages for Import and Export of Heterogeneous Data.

Environment: SQL Server 2005, VBScript, ASP, .Net, Excel, MS Access, Visual Basic 6.0, and Windows 2000.