SUMMARY

• Over 7 Years of IT Experience in SQL Server 2005/2008/2012 with specialized skills in BI Suite SSIS, SSAS and SSRS. Experience in database design, installation, configuration, performance tuning, optimization, backup, recovery, Software Development Life Cycle (SDLC) Concepts and proven ability to normalize tables up to Third Normal Form in SQL Server
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements Extensive experience in using Query Analyzer, Report Analyzer, SQL Server Profiler, SQL Server Management Studio (SSMS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS), Crystal reports knowledge on ETL tools like Informatica, Data stage.
• Well - organized and highly-motivated professional with excellent analytical and troubleshooting skills. Ability to work on multiple tasks in a fast paced environment independently and in a team
• Expertise in writing complex T-SQL (DDL, DML, DCL & TCL) queries, Stored Procedures, User Defined Functions (UDF's), Database Triggers and Exception Handlers
• Expert in various ETL tools such as Data Transformation Service (DTS), IMPORT/EXPORT, SSIS, Bulk Insert and BCP.
• Expertise in Normalization and De-Normalization techniques for both OLTP and OLAP systems
• Debugging Stored Procedures, Views, User Defined Functions and Triggers Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads
• Strong understanding of RDBMS concepts as well as Data Modeling Concepts.
• Conversion of DTS packages to SSIS packages and Interfacing Legacy components within SSIS for complex transformations and logic
• Experienced in extraction & migration of data from heterogeneous data sources like Excel, MS Access, Sybase, DB2 to MS SQL Server by using import/export Wizard, DTS/SSIS, BCP and Bulk Insert utilities
• Experience in creating jobs, Alerts and schedule SSIS Packages using SQL Server Agent and in scheduling and monitoring ETL processes using DTS Exec utilities and batch files
• Experience in performance tuning of SSIS packages by using Row Transformations, Block and Unblock Transformations
• Knowledge in creating dimensions, fact tables, KPI’s
• Expert in creating cubes using SSAS and familiar with upgrading or migrating Analysis Services
• Querying and manipulating multidimensional cube data through MDX Scripting.
• Extensive knowledge in Designing, Developing and deploying various kinds of reports
• Extensive experience in the development of Reports using SQL Server 2000/2005/2008 Reporting Services (SSRS) and Microsoft Access and developed Custom Report and different types of Tabular Reports, Matrix Reports, drilldown reports and score cards in multiple formats using multi - dimensional objects.
• Experienced in creating dashboards, scorecards and analyze the results produced in the dashboard and Integration of SSRS Reports with SharePoint Server (MOSS)

TECHNICAL SKILLS

Operating System: Windows Server 7/2003/XP/, Macintosh

Databases: MS SQL Server 2012/2008/2005 , MS Access, Oracle

Programming Languages: SQL, T-SQL, MDX, C,C#,Java,Vb.net

Business Tools: MS Office, MS Visio

Database Tools: SQL Server Enterprise Manager, SQL Query Analyzer, Index Tuning Wizard, DTS, Import/Export Wizard, SQL Server Management Studio, SSIS, SSAS, SSRS, Report Analyzer

Reporting Tools: Reporting Services (SSRS), Crystal Reports, Report Analyzer

ETL Tools: DTS, SSIS, Informatica

Data Modeling Tools: Erwin, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

MSBI Developer

Responsibilities:

• Creating application Schema (Database, Tables, Views and Indexes) and implemented various SQL, Transact-SQL statements, stored procedures and UDF (User Defined Functions) according to the requirements of the project.
• Involved in Backend Database programming, SSRS, Extract, Transfer and Loading (ETL), creating and working with SSIS packages
• Used Inner joins, Outer joins and other Complex joins for data retrieval from complex tables
• Experience in writing various script tasks using C# language and VB.NET.
• Actively participated in gathering requirements from business users to create new database objects.
• Performed Installation and Configuration of SQL Server 2005 and SQL Server 2008
• Enhanced the Query performance using Cluster and Non Clustered indexes
• Developed SSIS packages, created Stored Procedures, Triggers, Views and Functions for the Application
• Used various transformations in SSIS like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Responsible for Code debugging or syntactic issue resolution
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application
• Using SSAS for data mining and created reports from the OLAP cubes using SSRS
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users like VP, AVP, CD, Coach, Lead, SA, SR, Office Clerk
• Deployed the generated reports on the server
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Improved the performance by reducing the usage of the cursors.
• Migrated data from legacy system (flat files, mainframe data, Oracle, Excel spreadsheets, and Db2 data) to SQL Server databases using DTS, SQL Server Integration Services (SSIS) to overcome the transformation constraints
• Used DTSX change tool for migrating DTS packages to SSIS.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Deployed SSRS reports in share point for web based access for multiple end users
• Helped the application developers on writing T-SQL queries.
• Generated reports from SSRS (SQL server reporting services) and SSAS.
• Expertise in creating and supporting in OLAP Cubes
• Expert in creating Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Wrote test conditions and test scripts for all the stored procedures.
• Resolved issues for mission critical of high usage of system CPU, Disk, Deadlocks issue and Transaction per/sec, Memory

Environment: SQL Server 2005/2008/2012 , T-SQL, SQL Server Integration Services (SSIS), SSRS, DTS, MS Excel, MS Access, Crystal Reports, Oracle, Windows XP

Confidential, Westchester, IL

MS BI Developer

Responsibilities:

• Analyzed specifications provided by the client.
• Monitored the data warehouse system to maintain periodic data.
• Developed SQL queries to Insert, Update and Delete data in Database.
• Used Temporary tables, Table variablesandCommon Table Expressions (CTE)depending on the requirement.
• Managed and created and altered Databases, Tables, Views, Indexes and Constraints with business rules usingT-SQL.
• Created complex Stored Procedures, Triggers and User Defined Functions to support the front-end application.
• Migrated data from SQL server 2000 to SQL server 2005 and worked with implementing data mapping, cap analysis to migrate hybrid environment
• Created report models for the ad-hoc reporting of the end users using Report Builder.
• Worked onPerformance tuning,query optimizationandexecution planof queries for better performance.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Flat file, Excel, CSV, DB2, Oracle.
• Implemented the concepts ofIncremental Data Load, Slowly Changing Dimensionsfor updating and maintaining the history of the records.
• Conducted and automated theETLoperations toExtractdata from multiple data sources, transforminconsistent and missing data to consistent and reliable data, and finallyloadit into theMulti-dimensional data warehouse.
• Extensively used SSIS forTransformations, Aggregations and Lookups.
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task and different data flow tasks.
• Defined Relationships betweenDimensions and Measure Groupslike Fact Relationship,Many-to-Many Relationship, and Dimension Granularity within a Measure Group.
• Designed and DevelopedKPIs, Aggregations and Cube Partitions.
• Generated Named calculations and named queries.
• Deployment of Cubes to the production server.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Designed and developed reports based on client specifications.
• Successfully resolved various SQL Server problems which demand in-depth knowledge of SQL Server architecture, connectivity, replication, backup/restore, database corruption, security, programming etc.
• Generated Monthly and quarterly Reports in the form of bar chart reports for the management using different techniques like Drill down, Tabular reports, Matrix reports, List reports, Parameterized, Pie charts, Graphs, Linked Reports, Drill Through using Expressions, Global variables and Functions. Deployed SSRS reports inShare pointfor web based access for multiple end user.
• Generated Ad-Hoc reports as per the client requirements using Report Builder.

Environment: SQL Server 2005/2008/2012 , SSIS, SSAS, SSRS, Windows Server 2003, C#.Net, VB.Net, MS Access 2007/2003, SQL Profiler.

Confidential, Beaverton, OR

MS BI Developer

Responsibilities:

• Created new Stored Procedures, functions and database triggers according to the complex business logic.
• Migrated Organization Orders, Adjustments, Objectives and Callidus data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints
• Using the Update Statistics in the case of change in Indexed Columns for optimized performance
• Performed the query tuning to optimize the procedures and triggers to be used in production.
• Used multiple transformations in SSIS to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks.
• Created ETL packages with different 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 SQL Server Integration Services (SSIS).
• Performed the Migration the Existing DTS packages to the SSIS Batch jobs.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with report parameters and performed Parameterizedand cascading parameterized reports using SSRS.
• Developed logical and physical data models using Erwin.
• Scheduled and Maintained jobs for data messaging from development server to test server for generating daily reports
• Developed and executed SSIS packages to extract and populate the data from the various data sources.
• Created and managed the databases in development environment.
• Developed User-Defined Functions to implement the Custom Business Logic

Environment: SQL Server 2008/2005, SSIS, SSRS, Windows server 2003, C#.Net, VB.Net, MS Access 2003, Erwin.

Confidential

SQL Server Developer

Responsibilities:

• Migrated access objects to SQL Server 7.0.
• Implemented the database for production and marketing purpose.
• Created tables, indexes and constraints.
• Designed data models using Erwin.
• Planned, created and normalized the tables for the project.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using SSIS.
• Expert in using BCP and Bulk Insert, FTP Task.
• Used different kinds of SQL Joins to join more than 10 tables.
• Experience in loading and maintaining Data Warehouses and Data marts using Informatics.
• Created Triggers, Stored procedures for implementing the business logic. Administered of all SQL server database objects, logins, users and permissions in each registered server.
• Managed Database files, transaction log and estimated space requirements. Managed ongoing activities like importing and exporting, backup and recovery.
• Configured and monitored database application.
• Designed and implemented several complex reports and administration modules.
• Defined stored procedures for module integrity and application.
• Wrote database triggers in T-SQL to check the referential integrity of the database

Environment: SQL Server 2005/2000, T-SQL, Excel, Windows 2000/2003