SUMMARY

• Over 7 years of experience in IT as Sr. BI Developer/Database Developer/ Database Designer.
• Extensive experience in MS SQL Server 2012RTM/ 2008/2005/2000 with Business Intelligence (SSRS, SSIS and SSAS).
• Good working knowledge with RDBMS (SQL Server 2008/2005/2000 , Oracle 10g/9i, Sybase).
• Expertise in data models, data flows and data dictionaries.
• Good knowledge on Normalization and De - Normalization techniques.
• Experience in scripting in SQL Server - Stored Procedures, Reverse Stored procedures, Triggers, User-defined Functions (UDF’s) and Views.
• Experience in tuning Stored Procedures, T-SQL Queries, and SSIS Packages.
• Experience in designing and implementing Backup and Recovery strategies.
• Experience in writing T-SQL extended stored procedures, calling external dynamic link libraries which are written in C#.Net and VB.Net.
• Worked on complex DTS Active Script Tasks transformation in the process of migrating DTS to SSIS Packages.
• Implementing and Trouble-shooting of Transactional Replication model in SQL Server 2000/2005/2008.
• 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.
• 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, Block and Unblock Transformations
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expertise in creating various Parameterized, Linked, Drill-through, Drill-down and Ad-hoc reports.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Expertise in upgrading or migrating Analysis Services.
• Proficient in building Star schema and Snow Flake schema depending on business requirements.
• Proficient in working with Multidimensional Expressions (MDX).
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, roles and creating hierarchies using SSAS.
• Expertise in creating Cell Level Security in cubes using SSAS.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Ability to learn quickly and work in a team and as an individual with minimal supervision.
• Testing and Integration of the application modules.
• Extensively worked on Team Foundation Server (TFS),Visual Source Safe, Tortoise Subversion.
• Creating and working with Work Items and Batch Files using TFS Environment.

TECHNICAL SKILLS

RDBMS: SQL Server 2005/2008/2012 , Oracle 9i, Oracle10g, MS Access, Sybase and DB2

Database Tools: SQL Server Management Studio, MS Access, Query Editor

Programming Languages: T-SQL, PL SQL, C#, .Net, VB.Net and HTML

Reporting Tools: Crystal Reports XI/X, SQL Server Reporting Services

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services

BI Tool: Cognos, Business Objects, SSIS, SSAS and SSRS

Data Modeling: ER-Win 4.0, MS Visio 5.0

Operating Systems: Windows Server 2000/2003/2008 , Windows NT 4.0, Windows XP/98/95, MS DOS, Linux, UNIX and Mac

PROFESSIONAL EXPERIENCE

Confidential, Camp Hill, PA

SQL BI Developer

Responsibilities:

• Responsible for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
• Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
• Develop GUI interfaces using Open Database Connectivity (ODBC) to connect to Oracle and Sybase Relational Database Management Systems (RDBMS).
• Managing physical database design & creation; devising strategies for backups, recovery & fine-tuning.
• Tuning SQL statements and rendering support for MS SQL tool-sets and utilities.
• Extensively worked with PAC2000 to raise and solve a ticket.
• Extensively worked with Autosys tool to run the scheduled jobs and packages.
• Responsible for every month releases and production support.
• Working with Aqua Studio, to connect to different data sources like Oracle, Teradata and test the source data.
• Extensively working with off shore team and coordinating the workflow as per everyday Project Status.
• Modifying database programs to increase processing performance, referred to as Performance tuning.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Consulting with DBA's, programmers, and analysts to make changes to the data base management system.
• RobustSSISpackages with row counts, verifications, notifications, security, runs on test and production servers, ftp, compress txt files, indexing, table constraints.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005.
• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Created reports with Analysis Services Cube as the data source using SSRS.
• Ability to define and develop Report Structure withdata definition, report layout and report definition language.
• Extensive experience in creating several reports such asdrill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reportsusingSQL Server Reporting Services.
• Excellent inrendering reports, managing subscriptions,creating reports with report builder, report snapshot and report cache.
• Experience in scheduling and deployment of reports and uploading files to a report server catalog from the report manger.
• Experience inSharePoint & Performance Point Servers.

Tools: and Technologies: MS SQL Server 2000 (DTS), MS SQL Server 2005/2008, SQL Integration Services (SSIS), MS SQL Server 2008, Ms Access2007, Office2007, Windows Server 2003.

Confidential, Seattle, WA

SQL/SSIS/SSRS Developer

Responsibilities:

• Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports which take longer time in execution with SQL Server 2012RTM.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support.
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products
• Conducted peer design and code reviews and extensive documentation of standards, best practices, and ETL procedures.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS) and DataStage and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.
• Implementation of MS SQL Server 20012RTM Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Maintained the database schema in source code control.
• Designing, testing and implementing relational databases, including a full understanding of SQL scripting, using MS SQL Server including data-analysis skills.
• Extensively worked Team Foundation Server (TFS).
• Creating Drops for development and sync with SE team (off shore) for testing.
• Using icpac for drops and co-ordination with developers.
• Extensively worked with MS Build and Deployments using Team Foundation Server.
• Extensively working with off shore team and coordinating the workflow as per everyday Project Status.
• Modifying database programs to increase processing performance, referred to as Performance tuning.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Consulting with DBA's, programmers, and analysts to make changes to the data base management system.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• RobustSSISpackages with row counts, verifications, notifications, security, runs on test and production servers, ftp, compress txt files, indexing, constraints
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005.
• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Deployed all the reports to reporting server, SharePoint, Excel and PDF.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance in SSRS
• Performed Report Testing and Verification as per Internal Reporting system requirements.
• Provided Documentation support on SSRS 2008 as assigned.
• Provided 24/7 Support for Production, Development & Test Servers of MS SQL Servers.

Tools: and Technologies: MS SQL Server 2005/2008, MS SQL Server 2012RTM, SQL Integration Services (SSIS), SQL Reporting Services (SSRS) MS SQL Server 2008, Ms Access2007, Office2007

Confidential

SQL/DTS/SSIS/ SSAS/SSRS Developer

Responsibilities:

• Developing T-SQL extended stored procedures, calling external dynamic link libraries which are written in C#.Net
• Developed, deployed, and monitored SSIS Packages including upgrading DTS to SSIS.
• Worked on complex DTS Active Script Task transformation in the process of migrating DTS to SSIS Packages.
• Migrating DTS packages to DTSX using DTSX-change.
• Involved in XML Development and XML File Parsing in SSIS and SSRS.
• Developed the PL/SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency SSAS and SSIS.
• Created automated stored procedures for day end operations using SQL Server agent.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard in SSAS and SSIS.
• Implemented failure alerts using email in SSIS.
• Involved in Object Oriented Design (UML, activity diagrams, Use cases and Object Modeling).
• Created and used extended stored procedure in SSAS.
• Snapshot Replication was been used to synchronize the data between their Different Stores.
• Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard in SSIS.
• Involved in SQL Server Mirroring and Database optimization.
• Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS, SSAS.
• Created jobs, alerts to run SSAS, SSRS packages periodically.
• Created the automated processes for the activities such as database backup processes and SSAS, SSRS Packages run sequentially using SQL Server Agent job.
• Created and Designed Data Source and Data Source Views Using SQL Server Analysis Services 2008 (SSAS).
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS).
• Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Designed logical/physical data models and defined primary key, foreign key using Erwin tool
• Developed Query for generating drill down reports in SSRS 2008. Prepared AD HOC reports through report builders.
• Created Windows Logins and privileges to User Accounts/Groups and objects.
• Used DBCC commands to troubleshoot issues related to database consistency.

Tools: and Technologies: MS SQL Server 2000 (DTS), MS SQL Server 2005/2008, SQL Integration Services (SSIS), MS SQL Server 2008, Ms Access2007, Office2007, Windows Server 2003.