SUMMARY

• Around 8 years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2005/2008/2010.
• Good experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Expert in Data warehousing & OLAP technology.
• Expertize in Banking, Insurance, Finance, Retail, Healthcare sectors.
• Developed & supported various mission critical Client Server applications by handling Database requests for various application development teams involving complex business logic, functionality.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Experience in scripting T-SQL queries, complex stored procedures, user defined functions (UDF).
• Experience in Implementing Change Data Capture (CDC) on databases.
• Experience in Diagnosing and Troubleshooting performance issues in SQL Server Databases using DMV’s and DTA.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Test & Deploy code across various SDLC Environments like DEV, TEST and Production.
• Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Synchronous and Asynchronous Transformations.
• Experience in Installation, Configuration, Development, Deployment and Troubleshoot Reporting services using SSRS 2000/2005/2008/2012 across various environments.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets.
• Experience in designing Enterprise reports using SQL Server Reporting Services, generated drill down reports, drill through reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008/2012.
• Sound Knowledge in designing Parameterized and Cascaded reports.
• Experience in developing OLAP cubes using SSAS (SQL Server Analysis Services) and calculate teh metrics dat were revealed in teh functional analysis.
• Good knowledge in Cube designing and to edit various properties of a cube, including teh measure groups and measures, cube dimensions and dimension relationships, calculations.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities
• Used Various third party tools to analyze teh data in teh cube by using different features like Chart view, Decomposition Tree, Performance Maps, etc.
• Effectively maintained positive and productive working relationships in internal/external and team environments.
• Good leadership and time management skills.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2012/2008/2005/2000, MS Access 97/2003/2005, Oracle 8i/9i/10g.

Languages: T-SQL, PL/SQL, MDX, C, C++, C#, Java.

Tools: and Package: SQL Server Management studio, Enterprise Manager, Profiler, SQL Server Business Intelligence Development Studio (BIDS), DTS, SSIS, Visual Studio .NET, Visual Source Team Foundation (VSTF), TFS.

Operating Systems: Windows Vista/XP/2003/2000, Windows Server 2000/2003/2008.

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), Performance Point Server.

Application Packages: MS Office, MS Outlook (Microsoft Office Suite).

PROFESSIONAL EXPERIENCE

Confidential, Aiken, SC

SQL, SSIS, SSRS Developer

Responsibilities:

• As a member of Database and BI Reporting team, extensively worked on T-SQLs, Data loads and Reports for Land Administration & Revenue Accounting groups
• Involved in ETL Loads using SSIS/DTS Packages from various heterogeneous source systems into teh databases for Dashboard Reporting on a daily basis
• Used SQL joins, sub queries, tracing, usage of Table Variables, Temp tables etc.
• Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually
• Involved in writing stored procedures for both Online and Batch requests handling business logic and functionality of various revenue modules
• Involved in writing various DB Objects like User defined functions, Instead of triggers, Usage of Indexes for accomplishing various tasks
• Worked on analyzing and Performance tuning queries by looking at teh Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS
• Experience in Event Logging, error handling & logging Log files, File and File Groups, Security, Backup and Recovery
• Handled teh database components (Code migration, Change control) for application releases.
• Worked with Data migration utilities (Import & Export - BCP, Bulk Insert) from text to SQL Server
• Creates technical specifications, test plans and test data to support ETL processes
• Involved in Database Administration activities like Back up, Security, Migrations in teh Development servers.
• Worked on SSRS 2010/2008 to generate about 30+ reports for various user groups and developer groups.
• Has written Reports, Sub Reports, Data driven subscriptions, drill down reports using various features like Charts, graphs, filters etc.
• Created stored procedures to use as teh datasets for teh Report Design.
• Involved in generating reports for forecasting revenues based on teh historical data and used various delivery mechanisms and formats to deliver teh reports
• Configured Subscriptions and Security for all critical reports.

Environment: MS SQL Server 2010, MS SQL Server Reporting Services 2010, Windows 7, MS Office.

Confidential, Riverwoods, IL

SQL, SSIS, SSRS Developer

Responsibilities:

• Created complex Stored Procedures, views, Triggers, Tables and other SQL joins.
• Maintained data integrity by performing validation checks.
• Fine-tuned database objects and server to ensure efficient data retrieval.
• Developed Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues.
• Actively supported business users for change in requests.
• Used tools such as Bulk Copy Program (BCP) and Data Transformation Services (DTS) to transform teh raw data in to organized data ware house.
• Developed ETL packages using multiple data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded teh data into destination tables by performing different kinds of transformations using SSIS transformations.
• Scheduled teh jobs to streamline and automate cumbersome repeated tasks.
• Extensively used various SSIS control flow tasks like Loop Containers, FTP, Bulk insert task, Transfer job task etc. and different data flow tasks like Derived Column, Fuzzy lookup, merge join, Multicast, data conversion etc.
• Developed stored procedures to transform teh data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created SQL server Reports using SSRS 2010.
• Involved in writing Query for generating drill down reports, identified and worked with teh parameters to generate parameterized reports along with dat extensively used global variables, expressions and functions.
• Created reports dat included formatting options such as Grouping and Sorting.
• Generated various reports with drill through, calculated members, and dropdowns from teh cubes by connecting to Analysis server using Excel.
• Analyzed reports and fixed bugs in stored procedures on teh ongoing database operations, as needed, to resolve business problems.
• Responsible for deploying teh generated reports directly on client’s work stations.

Environment: MS SQL Server 2010, MS SQL Server Reporting Services 2010, MS SQL Server Integration Services 2010 Windows 7, MS Office.

Confidential, Northbrook, IL

SQL/ SSIS /SSRS Developer

Responsibilities:

• Gathered business requirements, definition and design of teh data sourcing and data flows, data quality analysis, working in conjunction with teh data warehouse architect on teh development of logical data models.
• Maintained data integrity by performing validation checks.
• Optimized queries, tuned and monitored server performance.
• Involved in Fine tuning of database objects and server to ensure efficient data retrieval.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads.
• Imported data from various sources into a staging area, merges teh data into teh OLTP data model, and presents it to all levels of teh over-600 users.
• Developed SSIS solution for developing a full-fledged data warehouse solution
• Developed, monitored and deployed SSIS packages.
• Assisted in migrating de normalized report DB into a Star Schema design.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Responsible for creating teh reports basing on teh requirements using SSRS 2005.
• Defined teh report layout.
• Identified teh database tables for defining teh queries for teh reports.
• Identified and defined teh Datasets for teh report generation.
• Wrote teh queries for teh drill down reports and cascaded reports.
• Identified and added teh report parameters.
• Deployed teh generated reports on to teh server.
• Formatted teh reports using teh Global variables and expressions.

Environment: MS SQL Server 2008, MS SQL Server Reporting Services 2005, MS SQL Server Integration Services 2005 Windows Vista, MS Office.

Confidential, Pittsburgh, PA

SQL Developer/ SSIS/SSAS Developer

Responsibilities:

• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Constructed OLTP and OLAP Databases.
• Worked on all activities related to teh development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS.
• Created SSIS process design architecting teh flow of data from various sources to target.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Configured XML config files (.dtsconfig files) to change properties of packages dynamically.
• Configured packages event logs.
• Created ETL SSIS packages both design and code to process data to target databases.
• Fine-tuned DML, DDL scripts with lock hints for performance boost.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on teh OLAP reporting needs.
• Used highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
• Created standard ActiveX template routines for transformation of data.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• Extensively used TSQL to manipulate and architect to produce results for users.
• Used multiple join statements to retrieve data from multiple several tables.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Created stored procedures, views, triggers, user defined functions to in corporate teh flow of business and called various stored procedures from DTS to make teh flow of DTS effective.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: MS SQL Server 2005, MS Analysis Services 2005, MS Office, Import & Export Data, Windows XP.

Confidential

SQL Developer/ SSAS Developer

Responsibilities:

• Gathered Requirements from teh end user and checking teh structure of teh schema.
• Reviewed cube, changed teh cube and documentation according to teh requirement based on product valuation and revenue opportunities.
• Updated functional specification and technical design documents.
• Created SQL server Analysis Projects using MS SQL Server 2005.
• Created teh data source views for security reasons.
• Involved in defining Referenced Relationships with teh measure groups and fact tables.
• Defined Granularity within a measure group and drill through actions.
• Implemented teh calculations to aggregate physical measures.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Responsible for scheduling teh jobs to streamline and automate cumbersome repeated tasks.
• Designed and implemented stored procedures and triggers for automating tasks.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, views and other SQL joins and statements for applications.

Environment: MS SQL Server 2000, MS SQL Server 2005, MS SSAS, SSIS, MS Access.

Confidential

MS SQL Server Developer

Responsibilities:

• Interacted extensively with Business Users and gathered information and requirements.
• Developed backup restore scripts for SQL Server as needed.
• Upgraded to latest version from MS SQL Server 7.0 to 2000.
• Penned various stored procedures for teh purpose of application development.
• Tuned SQL statements and Stored Procedures.
• Held responsibility for disaster recovery and database maintenance plan.
• Performed replication of data.
• Performed data conversion from Text File into SQL Server Table.
• Maintained Data Integrity Validation.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Made sales team work easy in placing and distributing orders.

Environment: MS SQL Server 2005, SSIS 2005, Windows XP.