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.
• OLTP Experience:
• 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.
• ETL,SSRS and OLAP Experience:
• Integration Services (SSIS):
• 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.
• Reporting Services (SSRS):
• 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.
• Analysis Services (SSAS):
• Experience in developing OLAP cubes using SSAS (SQL Server Analysis Services) and calculate the metrics that were revealed in the functional analysis.
• Good knowledge in Cube designing and to edit various properties of a cube, including the 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 the data in the 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: SQL Server Management studio, Enterprise Manager, ProfilerSQL Server Business Intelligence Development Studio (BIDS), DTS, SSISVisual 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).

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 the 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 the 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 the 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 the Development servers.
• Worked on SSRS 2010/2008 to generate about 30+ reports for various user groups and developer groups.
• Have written Reports, Sub Reports, Data driven subscriptions, drill down reports using various features like Charts, graphs, filters etc.
• Created stored procedures to use as the 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 the 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, River woods, 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 the 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 the data into destination tables by performing different kinds of transformations using SSIS transformations.
• Scheduled the 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 the 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 the parameters to generate parameterized reports along with that extensively used global variables, expressions and functions.
• Created reports that included formatting options such as Grouping and Sorting.
• Generated various reports with drill through, calculated members, and dropdowns from the cubes by connecting to Analysis server using Excel.
• Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Responsible for deploying the 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 the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the 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 the data into the OLTP data model, and presents it to all levels of the 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 the reports basing on the requirements using SSRS 2005.
• Defined the report layout.
• Identified the database tables for defining the queries for the reports.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports and cascaded reports.
• Identified and added the report parameters.
• Deployed the generated reports on to the server.
• Formatted the reports using the 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 the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS.
• Created SSIS process design architecting the 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 the 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 the flow of business and called various stored procedures from DTS to make the 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 the end user and checking the structure of the schema.
• Reviewed cube, changed the cube and documentation according to the 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 the data source views for security reasons.
• Involved in defining d Relationships with the measure groups and fact tables.
• Defined Granularity within a measure group and drill through actions.
• Implemented the calculations to aggregate physical measures.
• Created calculated measures and dimension members using multi-dimensional expression (MDX).
• Responsible for scheduling the 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 the 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.