SUMMARY

• 7+ years of experience in the field of Information Technology with proficiency in ETL design, development and Data Warehouse Implementation for Health service, Finance, Healthcare Telecommunications, B2B and Sales (POS) business sectors.
• Developed Complex Stored procedures as well as analyzing and debugging existing complex stored procedures, suggested creating Clustered and Non Clustered indexes on tables.
• Experience with SQL Server and T - SQL in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, Relational Database Models and Data Integrity in observing Business Rules.
• Extensive experience in Writing Transact SQL (T-SQL) Queries, Dynamic-queries and implementing SQL Server Indexing.
• Having strong experience in scheduling all the T-SQL jobs to run at particular times.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data profiling and other database related activities.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio and Erwin 7.2.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Strong Experience in using CTE’s, Recursive CTE where need according to the requirement.
• Experience in Creating temporary tables (Both local and global) and derived tables, executing them in context to the query.
• Experienced in Performance tuning (In database, T-SQL and Operating system levels), optimization of procedures and queries and Scheduling using SQL Server Agent.
• Strong experience in processing the transactions in SQL server (Commit and Rollback) to maintain data integrity in databases.
• Experience in designing SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert etc.
• Experienced in performing Incremental Loads and Data cleaning in SSIS.
• Expert in handling errors, logging using Event Handlers using SSIS.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression and Derived Column.
• Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• 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 SQL Server Reporting Services in Business Intelligence Development Studio (BIDS).
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Very well aware of the changes made to Configurationfiles and deploymentmodels and other changes in SQL Server 2012.
• Experience in deploying packages to Integration Services Catalog in SQL Server 2012.
• Experience in Performance Tuning in SSIS packages using Row Transformations, Block and Un-Block Transformations.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Created various SSRS Reports involving variety of features like Charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters, and also understandingofthetablixcontrol and Dashboard reporting, Share Point with Power View tool etc.
• Experience in building various types of SSRS reports like table, matrix, and chart report, web reporting by customizing URL Access.
• Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQLSQL Server

Tools: BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS, SSAS, Index Analyzer

Databases: SQL Server 2008R 2/2008/2005/2000 , MS Access

Operating Systems: Windows Server 2008R1/2008R2/2003/2000 Windows 2007/2008/ NT/95/XP, UNIX

ETL Tools: DTS, SSIS, BCP, Import/Export Wizard, BI Studio

OLAP Tools: SSAS, MS Excel

Reporting Tools: SSRS, MS Excel

Business Tools: Word, Excel, PowerPoint, Access, Outlook.

PROFESSIONAL EXPERIENCE

Confidential, Deerfield, IL

SQL Server/Business Intelligence (BI) Developer

Responsibilities:

• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Created SSIS packages to clean and load data to data warehouse.Collected business requirements from users and translated them as technical specifications and design documents for development.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file and MS Access and CSV files to data warehouse.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Worked on Complex SSRS Reports, Sub Reports, Graphing, Data Drill-Down, and Data sorting/grouping, Crystal Reports Design.
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications.
• Experienced in creating SSAS OLAP Cubes and Partitioning Cubes.
• Experienced in using Dimension Usage, Aggregations, Calculation and Perspective on a Cube.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Carry out creation of SDLCdocumentation for existing applications
• Filtered inaccurate data from legacy system using complex T-SQL statements, and implemented various constraints and triggers for data consistency.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Created checks and constraints to maintain data integrity and created Complex Stored Procedures.

Environment: MS SQL Server 2008/2012, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), BIDS and Windows 2007.

Confidential, Santa Clara, CA

SQL Server/ Business Intelligence (BI) Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC).
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors,Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clusteredindexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008 R2.
• Advised optimization of queriesby looking at Execution Plan for better tuning of the database
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files.
• Involved in daily loads (Full & Incremental) into Staging areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
• Calculated measures and dimension members using multi-dimensional expression (MDX).
• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Developed a High level dashboard using SSRS 2008 R2.
• Developed various types of complex reports like Drill Down, Drill through,Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008 R2.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.

Environment: SQL Server 2008R2/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), XML, MS Visual Source Safe and Windows Server 2003

Confidential - Columbus, OH

MS SQL Server SSIS/SSRS/SSAS/BI Developer

Responsibilities:

• Created SSIS packages to clean data from various sources (Flat File, CSV files, Excel Spreadsheets, MS Access, XML, Oracle etc.) using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc., to generate underlying data for the reports and to export cleaned data to data warehouse.
• Created Cubes and populated them with Dimensions and Facts from the Staging Database.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Created KPI Objects in line with Requirement Docs and optimized cubes for better query performance.
• Implemented Calculated Members and Actions such as URL Actions, Report Actions and Drill Through Actions in SSAS 2008.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Created ad-hoc reports, drill down, and drill through reports.
• Created functions within SSIS, SSRS using C#.
• Created and tuned stored procedures, triggers and tables and created several materialized views and UDF’s to be accessed by the new front end applications.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Environment: MS SQL Server 2008R2/2008, SSIS, SSAS, SSRS, BIDS, T-SQL, TFS, Erwin v7.2, C#.Net

Confidential, Minneapolis, MN

SQL Server Developer/SSIS Developer

Responsibilities:

• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Used to work on Installation, Configuring, Managing, Monitoring, Troubleshooting SQL Server 2008R2/2008/2005 on VM Ware Clustered and Standalone Environments.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Used ASP.Net coding and C# to call the Stored Procedures created with T-SQL
• Used XML and XSLT
• Extracted data from Txt/CSV/XML/Oracle/Sybase/DB2 to SQL server.
• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• Created SSIS packages for data Importing, Cleansing, and Parsing. Extracted, cleaned and validated.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• To generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house by using BIDS.
• Built Cubes with Multi Dimensions and made proper Hierarchy Relationships on Attributes.
• Made Partitions on Cubes with Aggregates for better Performance.
• Worked in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Prepared various Reports by using Queries and the Data existed in the Cube for Analysis Purposes of the Organization.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Extensively worked on Dimensional Modeling.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports in BIDS. Deploying and scheduling Reports using SSRS/Crystal to generate all daily, weekly, monthly and quarterly Reports including current status.
• Expert in automating process by Using SQL Server Agent in creating jobs and error report using Alerts, SQL Mail Agent and SMTP.
• Handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs, Backups and restores.
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).

Environment: MS SQL Server 2003/2005/2005 R2, BIDS, Oracle, .net, Power Designer, Microsoft Outlook, Red Gate, Team Foundation Server

Confidential, King of Prussia, PA

SQL Server/ Business Intelligence (BI) Developer

Responsibilities:

• Understanding Customer requirement via interaction and writing functional specifications.
• Involved in creation of Dimensions using Star and Snow Flake Schema.
• Developed OLAP Cubes, Dimensions, Data Source View, Partitions and Aggregations.
• Responsible for identifying and defining Data Source and Data Source Views.
• Defined attribute properties in a Parent Child Dimensions.
• Responsible for creating complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP reporting needs.
• Responsible for hiding and disabling Attributes and Attribute hierarchies.
• Knowledge in creating calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Installed, configured and maintained SQL Server Integration Services.
• Developed, Deployed and Monitored SSIS packages.
• Created packages using Integrated Services (SSIS) for data extraction from Flat files, Excel Files, OLE DB.
• Used SSRS to create reports, customized reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Created reports in SSRS according to the user requirements.
• Wrote queries for the Drill down Reports.
• Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Monitor connections, Locks and performance of SQL Server.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Incremental and full database recovery with experience of complex recovery scenarios.
• Designed, added, eliminated and maintained indexes, organized tables, recommended changes to application development team.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, SSAS, T-SQL, Windows Server 2008, Windows 7.

Confidential

SQL Developer

Responsibilities:

• Performed extensive data extraction from web and other sources and handled data preparation - missing values, formatting, transformations using SSIS.
• Handled migrations from DTS toSSIS 2005 and 2005 to 2008.
• Written Stored Procedures and SQL scripts both in SQL Server and Oracle to implement business rules for various clients.
• Designed T-SQL scripts to identify long running queries and blocking sessions.
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
• Data migration (import & export - BCP) from Text to SQL Server
• Normalization and De-Normalization of tables
• Developed Backup and Restore scripts for SQL Server 2005
• Installed and Configured SQL Server 2005 with latest service packs.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions
• Written T-SQL queries for the retrieval of the data.
• Prepared daily and weekly status reports and collaborated with other team members
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Customized the stored procedures and database triggers to meet the changing business rules.
• Implemented indexes for performance tuning.
• Data loaded into the database using SSIS 2005 from flat files.

Environment: SQL Server 2005, SQL Server 2000, Oracle 9i, Visual Basic, Excel.