SUMMARY

• Over 7 years of strong experience in the IT industry as SQL Server and BI Developer in risk management, unified messaging and other domain.
• Expertise in Microsoft Business Intelligence technologies like SQL Server Integration Services SSIS
• Knowledge of SQL Server Architecture and all phases of SDLC involving Systems Analysis, Design Development and Implementation.
• Experienced in SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS , Data Transformation Services DTS and SQL Server Analysis Services SSAS .
• Conceptual understanding and working knowledge of ETL using SSIS, Data warehousing, Data marts and OLAP technologies including star schemas, snowflakes using Erwin Tool and Microsoft Visio ETL processes, dimension modeling and reporting tools.
• Experience in using Business intelligence Development Studio BIDS , GUI to design SSIS packages for Data Management applications.
• Experience in data migration from Oracle to SQL Server and other file formats like flat file and MS Excel etc.
• Knowledge of ACID properties, Database Normalization, designing and creating Indexes, Develop queries and T-SQL Scripts in MS SQL 2008/2005/2000 using Inner, Outer and Cross Joins.
• Proficient and tuning data flow task in SSIS using Profile, SSIS performance and Used Transactions in SSIS.
• Experienced in generating reports like matrix, parameterized and drill through reports using SSRS and developed stored procedures using functions to generate various kinds of reports using SSRS.
• Experience in Configuration and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases as Oracle.
• Proficient in creating, Configuring and Performance-tuning ETL workflows and SQL queries designed in DTS and MS SQL Server Integration Services SSIS .
• Expert in extracting data from Legacy Systems using SSIS ETL Tool
• Experience in ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server.
• Expert in using Bulk Copy Program, Data Transformation Services and SSIS with MS SQL Server 2000/2005/2008.
• Highly proficient in the use of T-SQL for developing complex stored procedures , triggers ,tables ,user functions, user profiles ,relational database models and data integrity, SQL joins and query writing.
• Strong analytical and problem solving skills, excellent communication and presentation skills, and a good team player.

TECHNICAL SKILLS:

Databases: SQl Server 2008, 2005 2000, MS Access 2000/2003/2007, MySQL, Oracle 9i, 10g

Database Tools: Enterprise Manager, Query Analyzer, SQL Server Profiler, DTS, SSIS, SSRS, SSAS, Business intelligence Studio

Languages: C , VB, XHTML, XML, C , T-SQL, .NET, UML

Operating Systems: Windows 2003 Enterprise, Windows NT, Windows Vista, Widows 7

Other Tools: Erwin, Microsoft Visual studio 2003/2005, Microsoft Visio, Microsoft Office, Crystal Reports

Architecture Relational DBMS, Client-Server Architecture, OLAP, OLTP

PROFESSIONAL EXPERIENCE

Confidential

Sr. MS BI Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Designed the Entity Relationship ER models and logical data LDM , physical data PDM models based upon the design documents.
• Extensively worked on full Software Development Life Cycle SDLC of the project from Database Design and Modeling to implementation and maintenance.
• Designed and Developed SSIS Staging Packages to Stage Source files to SQL Server Source Database
• Developed ETL packages with different data sources SQL Server, Flat Files, Excel source files, etc. and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services SSIS .
• Designed and Developed Complex SSIS Source to Intermediate Packages to load the data into Intermediate Databases
• Developed Complex SSIS Parent-Child Packages for different Counties with Common Source to Intermediate rules.
• SSIS Components used extensively in the project are Merge join, Derived Columns, Look UP, Conditional Split and Multicasting.
• Designed various packages using various task e.g. For Each Loop, File System Task, Execute SQL task, Execute Process Task, Execute Package Task, Send Mail Task.
• Involved in Loading Dimension with the SSIS slowly changing Dimension Wizard.
• Experience in performance tuning of SSIS Packages using row transformations.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost of the existing product databases.
• Created complex Stored Procedures for validation process for loading data from the staging area to the product database in SQL 2008.
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Deployed SSIS packages from Development to Testing Servers
• Debugging of SSIS packages.
• Experienced with SharePoint 2010 for sharing the files with the tasks issued.
• Worked on all activities related to the development, implementation and Support of ETL processes for large-scale Data Warehouses using SQL Server SSIS
• Created and developed query for Tabular and Matrix Reports using SQL Server 2008 Reports Services SSRS
• Created Drill-through reports, parameterized reports and linked reports using SSRS 2005 and 2008.
• Worked on Report generation using SQL Server Reporting Services SSRS that could be used to send information to Client.

Environment: SQL Server 2008,2008R2, T-SQL, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , VB.Net, SQL Profiler, Microsoft Access 2007,Erwin,Sharepoint 2010,Visual Studio 2008,2010.

Confidential

Sr. MS BI SSIS/SSRS /SQL Server Developer

Responsibilities:

• Creating the Data Model, Entity Relational Diagram ERD and Data Flow Diagrams DFD for the Projects.
• Creating the Architectural Approach Document AAD and Technical Design Document TDD for the Projects.
• Migrated data from Heterogeneous data Sources Excel, Flat File to centralized SQL Server databases using SQL Server Integration Services SSIS to overcome transformation constraints.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Implementing Facts and dimensions for providing views of large sets of data.
• Developed report specifications, created and modified reports using SSRS 2008.
• Worked on the dirty source data that resulted in errors.
• Actively participated in meetings and checked for the development of the project.
• Documented the project work and process.
• Writing Store Procedures and Views for the Dynamic SQL used in ETL
• Team involved in various databases including Service Center, Asset Center of Enterprise.
• Distributed reports to the users by uploading them to Report Web.
• Performed unit testing in DEV and UAT for migrating reports
• Created SSIS Packages to load data from Oracle to SQL Server
• Created different types of User-defined functions.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments
• Designed user defined hierarchies in SSAS including parent-child hierarchy.
• Created Parameterized reports, Cross-Tab reports, Drill down reports Summary reports by using SSRS.
• Developed T-SQL queries and stored procedures with multiple parameters to created data sets for reports.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed Tabular reports, Matrix reports, Drill down reports.
• Created SSIS Packages to migrate slowly changing dimensions
• Created partitions of the Analysis Services cube to improve performance.
• Created report snapshots to improve the performance of SSRS.
• Created Event Handlers for the SSIS package on Error, on Post execute.
• Used named calculations and new named query cubes to calculate values at run time.
• Worked with T-SQL, DDL, DML and DCL.
• Used Performance Point server 2007 to integrate SSRS reports.
• Designed reports and tuned them for optimal performance when using multiple parameters.
• Used Report Manager to assign roles, permissions and to create report schedules.
• Configured Reporting Services to a scale out deployment to allow concurrent users.
• Developed SQL scripts, ensured optimal performance of the queries to generate reports from various relational databases like Oracle, DB2.
• Created complex SSIS packages using various transformations.
• Used Lookups Transformation to get the data from reference data sets
• Created cubes and defined the dimensions.
• Worked on OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Dealt with huge amount of data and used SSAS in order to retrieve the data.
• Defined attribute properties in a Parent Child Dimensions.
• Used Joins to write queries that retrieve data from more than one table.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Implementing the calculations to aggregate physical measures

Environment: MS SQL Server 2008, Windows Server 2008,.NET, Enterprise manager, Query Analyzer, SSIS, SSAS, SSRS,DTS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, Share Point Portal Server 2007 MOSS 2007 , IIS 6.0, .XML, ETL, Microsoft Visio 2003, MS Visual Studio 2008.

Confidential

Role: SSIS Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Updated functional specification and technical design documents and also created new design documents
• Helped in the design of the Architecture of the Data Warehouse and helped in performance tuning of the data base.
• Designed the Entity Relationship ER models and logical data LDM , physical data PDM models based upon the design documents.
• Modeling new fields/tables in Operational Data Store ODS as per new requirements.
• Extensively worked on full Software Development Life Cycle SDLC of the project from Database Design and Modeling to implementation and maintenance.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, and Excel to SQL Server using Business Intelligence Development Studio.
• Wrote T-SQL queries, Stored Procedures and used them to build packages.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration Services SSIS .
• Involved in tuning and configuration of SSIS.
• Deployed SSIS packages from Development to Testing Servers
• Debugging of SSIS packages.
• Responsible for Import and export data from various data sources like SQL Server Databases, Flat Files, MS Access, MS Excel and other OLE DB providers achieved through Importing and Export Wizard in SSIS.
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Involved in Loading Dimension with the SSIS slowly changing Dimension Wizard.
• Worked on Data Profiling in SSIS and applied Fuzzy Lookup.
• Created Drill-through reports, parameterized reports and linked reports using SSRS 2005 and 2008.
• Created new and modify existing reports, dashboards and metrics for the client using SSRS 2008
• Developing OLAP cubes by identifying tables fact and dimension , Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services SSAS .
• Loaded RAW Files into SQL Server using SSIS.
• Running and Scheduling SSIS Packages

Environment: Windows 2003/2000, XP, SQL Server 2012, SQL Server Integration Services 2008R2, SQL Server Analysis Services, T-SQL, SQL Query Analyzer, IIS 5.0 , Visual Studio 2008, MS SSIS 2005,T-SQL, Windows Server 2000

Confidential

Role: SSIS Developer

Responsibilities:

• Worked as a database designer and developer on databases like MS SQL Server 2005 using T-SQL, stored procedures and views.
• Designed small data marts and then integrated them together to form a DataWarehouse.
• Used Erwin for designing and also wrote the technical documentation for the whole project single handed.
• Made decisions on the naming conventions to be used for the purpose of designing the data warehouse and also helped to improve the performance of the database by doing performance tuning.
• Developed complex T-SQL code for the application.
• Modified the existing database by adding the tables and relationships to the tables.
• Performed Data Cleansing is creating new tables for the loading of Data in SSIS.
• Involved in the migration of DTS packages to SSIS packages.
• Involved in performing incremental loads using SSIS packages.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Created reports that call Sub reports in SSRS
• Developed measures and dimension members using multi dimensional expression MDX to meet additional needs that were calculated from existing measures.
• Developed MDX for cube calculations and KPIs.
• Implemented the calculations to aggregate physical measures using management studio.
• Identified and defined the scoped assignments using script commands.
• Defined Referenced relationships with the measure groups and fact tables.
• Optimized long running stored procedures and Queries for effective data retrieval.

Environment: MS SQL Server 2005 Enterprise Edition, MS SSIS 2005, SSRS, DTS, T-SQL, Windows Server 2003, Microsoft Visio

Confidential

Role: SSIS Developer

Responsibilities:

• Created new tables, stored procedures for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling.
• Migrated data from different sources text based files, Excel spreadsheets, and Access to SQL Server databases using SQL Server Integration Services SSIS .
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS by SSMS.
• Responsible for report generation using SQL Server Reporting Services SSRS and Crystal Reports based on business requirements.
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server 2005 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used Bulk Copy Program and Bulk Insert to load data from different data sources to SQL Server.
• Created DTS Packages to load data from Source like Excel, ORACLE, DB2, SQL 2000, and MS Access using SSIS packages.
• Skilled in Developing SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Used tools like SQL Profiler, Performance Monitor to find out performance issues with queries or Application.

Environment: Microsoft SQL Server 2005, Visual Studio 2005, T-SQL, SQL Server Integration Services, MS Office, Word, Excel, Visio, RDBMS, VBA.

Confidential

Role: SSIS Developer

Responsibilities:

• Modified existing database by adding tables and relationships
• Created views as per the requirement of front-end developer.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Wrote complex queries and stored procedures.
• Designed and Created databases, tables, views, stored procedures and triggers.
• Created groups, roles, users and assigning access privileges to users.
• Setting up database backup and recovery procedures for production, quality and development servers.
• Monitored and scheduled existing/new jobs on production environment.
• Periodic checking of all databases with DBCC commands for maintaining data consistency and integrity.
• Coordinated with back-end programmers in writing stored procedures, implemented referential integrity by using triggers, performance and tuning.
• Tested backup and recovery strategies in a test environment before and after moved to production environment.
• Configured replication methods like snapshot, transactional and merge replications.
• Deploying database objects from development/testing environment to production environment.
• Coordinated and performed quality assurance testing for movement of database and objects from development environment to testing and production environments.
• Created logins and users as and when required with specific roles on production server.

Environment: Windows 2003/2000, XP, SQL Server 2005, T-SQL, SQL Query Analyzer, IIS 5.0 , Visual Studio 2005, VB.NET, ASP.NET.

Confidential

Role: Database Developer

Responsibilities:

• Involved in various stages like design, development and analysis.
• Created logical database model, physical database design and implemented large database models using Erwin.
• Performed database testing and Query Optimization.
• Developed database objects such as Store procedures, Functions, Triggers, and Indexes using T-SQL, SQL Analyzer and SQL Server Management Studio
• Designed SSIS packages to transfer the data from the old system to the SQL server database.
• Created views to replace old tables and created new tables with triggers to support new business needs.
• Worked on Client/Server tools like SQL Server Management Studio and Query Analyzer to Administer SQL Server.
• Imported and Exported database using SSIS.
• Created reports using SSRS.
• Wrote SQL Stored Procedures to implement business logic.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Performed Index analysis using Index Tuning Wizard for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.

Confidential

SQL Developer

Responsibilities:

• Supervised the activity of the Database for identifying the bottlenecks that are slowing down the performance of the data warehouse.
• Identified and implemented the methods to fine tune the queries, procedures and functions.
• Reviewed the executions of views and stored procedure and identified the bottle necks within the query.
• Monitored Database and Server Resources with various tools such as Performance Monitor, SQL Profiler, Stored Procedures and Database Tuning Advisor.
• Finding and Tuning Problem Queries.
• Implemented Peer to Peer Transactional Replication within the system.
• Creation of file groups for the existing Tempdb Database.
• Changing collation in the existing configurations.
• Designed Ideal disk configurations for the future Database server.
• Designed and Created Cube and report from scratch including research.
• Set up guidelines for the team for the future.
• Created reports using ProClarity and analyzed accordingly
• Worked with database performance tuning and query optimization, data integrity and statistics
• Provided documentation on current database environment and as well on the structure that needs to be modified in the future for better performance of the system.
• Advised on the question and concern they had for maintaining the database.

Environment: SQL Server 2000, T-SQL, Integration Services SSIS , Query Analyzer, SQL Profiler,

SQL Database Tuning Advisor, SQL Performance Monitor, Windows OS