SUMMARY

• 8 years of experience with Microsoft SQL Server 2005/2008 and worked extensively on Integration services (SSIS), Analysis services (SSAS), and Reporting services (SSRS).
• Extensive experience on Aginity workbench 4.1.1 (Netezza), Cisco Composite 6.2 (data virtualization tool).
• Well - versed with database Installation, configuration, maintenance, monitoring, backups and recoveries.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experienced in using T-SQL for developing complex Stored Procedures, Triggers, and Functions.
• Extensive experience in creating Tables, Views, Indexes and SQL joins on query writing.
• Created, altered, maintained system roles and permissions to users on various database objects.
• Strong debugging skills and the ability to solve complex problems.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Experience in creating packages, jobs, sending alerts using SQL Mail and extended stored procedures.
• Good knowledge of System Development Life Cycle (SDLC).
• Expert in working 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.
• Migrated Organization, Orders, Adjustments, Objectives and 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.
• Skilled in using tools like Bulk Copy (BCP) and Data Transformation Services (DTS) and SSIS with MS SQL Server 2005/2008R2.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Proficient in working with data profiler.
• Adept in defining referenced relationships and calculated members in SSAS.
• Worked in developing and extending SSAS cubes, dimensions, and data source view SSAS-data mining models and deploying and processing SSAS objects.
• Experienced in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services 2008.
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters.
• Experienced in sorting the data, defining subtotals for reports and designing report layout.
• Extensive knowledge on creating reports using tablix control properties in SSRS 2008.
• Expert in handling parameterized reports in SSRS 2008.
• Ability to create table-valued functions on SSRS reporting services.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Expert in creating the MDX cubes and dimensions (SSAS), defining referenced relationships in SSAS, defining granularity within a measure group and drill through actions.
• Involved in the SSAS storage and partitions and aggregations, Calculating queries with MDX data mining models.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional Tables and Operational Data Store (ODS).
• Experience in designing data warehouse Data marts in Kimball Methodology.
• Hands on experience with Netezza tool in data warehousing.
• Expert in MS SQL Server suite of products like SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services) and SSIS (SQL Server Integration Services).
• Experience in working with VB.Net
• Good understanding of business objects web intelligence tool.
• Excellent Communication, Trouble-Shooting, Team Player, Able to Work with a new and fresh perspective on work assignments, creative and quick learner of new technological developments.

TECHNICAL SKILLS

• MS SQL Server 2005/2008/2008 R2/2012
• MS SQL Reporting Services 2008/r2
• MS SQL Server Analysis Services 2008
• MS SQL Server Integration Services 2008/r2
• MS-Access 2010
• Oracle
• DB2
• HTML
• Aginity workbench 4.1 (Netezza)
• Composite 6.2
• Java script
• Windows NT
• Windows 95/2005 Server
• Windows XP/7/8 visual basic
• C#
• Java
• Unix
• Shell script

PROFESSIONAL EXPERIENCE

Confidential, Brookfield, WI

Sr MS SQL Server BI Developer

Responsibilities:

• Gathered Requirements from the end user and involved in developing logical model and implementing requirements in SQL Server 2008R2.
• Analysis and understanding of the Business Requirements through review sessions with Business Analysts and Project team on day-to-day basis.
• Assisted the Development staff with the development and implementation of the application.
• Installation and configuration of MS SQL server 2008R2 pack.
• Responsible for managing and creating new sql server integration service packages.
• Extracted data from various (text, csv, Excel, Oracle, Sybase, Sql server) sources using Integration service.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data, Normalized tables, established joins and created indexes whenever necessary.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute Task, Email Task, Script Task and Data Flow Task.
• Created and managed SSIS package configurations.
• Extensively worked on souring fixed width files.
• Data Migration from Heterogeneous Data Sources and legacy systems (DB2, Oracle, Sybase, and SQL Server) to Aginity (4.1.1) database using Composite data virtualization (6.2) tool.
• Created View and generated Indexes, Primary Keys and Unique Keys in Composite tool.
• Scheduling SQL Server Agent jobs for daily, weekly and monthly basis and monitor failed and long running MS SQL Server jobs.
• Identified and resolved problems encountered during development and releasing the SSIS code to testing and production environment.
• Created linked servers to connect to different environments
• Built business objects reports using web intelligence.
• Built web intelligence reports using web client and rich client.
• Involved in creating reports for end users using sql server reporting services.
• Developed complex stored procedures and views to generate various drill-through reports, parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Performed DBA functions, installing, configuring and supporting database systems.
• Responsible for creating users, groups and granting permissions as needed using sql server.
• Actively involved in developing cubes from the scratch using SSAS
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• 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 r2 (SSAS).
• Production support to the project on every schedule release.

Environment: MS SQL server 2008r2, SSIS, BIDS, Business Objects, SSRS, ETL, OLAP, Oracle 9i, Oracle 10g, SQL Server Agent, SSAS, MS Visual Basics 6, Sybase, DB2, C#, Aginity workbench 4.1 (Netezza), Composite 6.2

Confidential, Monroe, LA

Sr. MS SQL Server SSIS/SSAS/SSRS Developer

Responsibilities:

• Installation SQL Server 2008 with the latest service packs.
• Migrated Database from SQL Server by using side by side migration.
• Wrote T-SQL complex queries for creating stored procedures, joins, and functions.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Worked with moving data from Oracle to SQL server 2005 and migrated the PL/SQL code to SSIS packages.
• Created new database/tables to put in the extracted data and rebuild the relationship.
• Created logging for ETL load at package level and task level to log number of records processed by each Package and each task in a package using SSIS.
• Involved in migration of DTS Packages to SSIS Packages.
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute Task, Email Task, and Data Flow Task.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Created and managed Package Configurations, Logging, Event Handlers, System and User-defined Variables for SSIS Packages.
• Configured and run the data profiling task in SSIS to analyze the column relationships.
• Created various Weekly and Monthly reports showing detailed information of the claims filed, Dealers information, Warranty Information.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Reported all events and requirements through established SSRS reporting mechanisms.
• Administrated the created Reports by assigning permission to the valid user for executing the reports.
• Created cubes and defined the dimensions.
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schemas for developing Cubes using MDX.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Responsible for Understanding the world scope data feed, help design the target schema and develop an ingestion feed process using SSIS.
• Developed Slowly Changing Dimension (SCD) type2 to create a new dimension record to define a change.
• Created database objects using Netezza appliance.
• Creation and maintenance of Databases, creating Roles and managing user permissions, resolving Blocks and deadlocks.
• Created indexes, Constraints and rules on database objects.
• Transformed the complex business logic and calculations into coding.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Helped Development Team in deploying and testing the application, which uses SQL Server as a database.

Environment: SQL server 2008, Windows 2005, SSIS, SSAS, SSRS, VSS, SQL Diagnostic Manager, ETL, OLAP, OLTP, Oracle, SQL Server Agent, MS Visual Basics 6, VB.Net, Netezza

Confidential, Bridgeton, MO

MS SQL Server BI Developer

Responsibilities:

• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2008 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.
• Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005/2008.
• Deployed SSIS packages and Reports to Production Servers.
• Upgraded databases from SQL Server 2005 to SQL Server 2008.
• Responsible for ETL operation using SQL Server Integration Services (SSIS).
• Created DTS package to export and import data from SQL Server to Access, text and EXCEL files.
• Responsible in upgrading SQL Server software to new versions and applying service packs and hot fixes and unattended Installations.
• Worked as a developer in creating complex Stored Procedures, Triggers, and Functions.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Migrated data from the MS Access database using SSIS Packages.
• Performance tuning to optimize SQL queries using query analyzer and DMV.
• Tested to optimize the procedures and triggers to be used in production.
• Responsible for creating the reports based on the requirements using SSRS 2008.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Created Datawarehourse Cubes in SQL Server Analysis Service (SSAS).
• Applied Slowly Changing Dimension (type1, type2, type3) concept to the changing data based on the requirement.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Performed backup/restore of database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Responsible for gathering/refining requirements from the customer for developing reports.
• Worked on Netezza appliance in creating databases and the objects.
• Actively involved designing the logical and physical architecture for company’s database.
• Identified the Data Source and defining them to build the Data Source Views.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Involved in integration of the front end with the SQL Server backend.
• Develop several custom MDX calculated dimension members to support related calculations between balance sheet and income statement accounts.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Identified the Data Source and defining them to build the Data Source Views.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.

Environment: SQL Server 2008/2005/2000 , SSIS, MDX, SQL Server Reporting Services, MS Access & Excel, Oracle, Microsoft Business Intelligence Development Studio(BIDS), Netezza, VB.Net

Confidential, Lake Mary, FL

MS SQL Server SSIS /SSRS Developer

Responsibilities:

• Installed and configured SQL Server 2008 successfully on Windows Server 2005.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• In charge of converting data using SQL Server 2008 using SSIS.
• Deployed SSIS packages and Reports to Production Servers.
• Upgraded databases from SQL Server 2005 to SQL Server 2008.
• Migrated data using ETL Tool in SSIS.
• Worked on Migration of packages from DTS using SQL Server Reporting Service(SSIS).
• Migrated data from different sources including flat files, MySQL, MS Access, Oracle 8i/9i to SQL Server 2008 by using SSIS.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS.
• Generated database monitering and data validation reports using SQL Server Reporting Service (SSRS).
• Designed and developed MS SQL Server Reporting Services (SSRS) under SQL Server 2005 and SQL Server 2008.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Responsible for creating the reports using the SQL server reporting services and maintained them.
• Used the various parameter passing techniques to create input for reporting parameters.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Maintained system monitoring jobs and provide high availability support.
• Created partition table for very large database for good performance.
• Performing DBA functions, installing, configuring and supporting database systems.
• Created various Weekly and Monthly reports showing detailed information of the claims filed, Dealers information, Warranty Information.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications
• Assisted the front end application developers with their queries.
• Developed packages which detect the incoming rows for changes of existing records by using slowly Changing Dimension transformation.
• Created Datawarehourse Cubes in SQL Server Analysis Service (SSAS).
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Responsible for defining the complete Data Warehouse architecture (e.g. ODS, ETL process)
• Involved in developing logical and physical modeling of the database using Erwin.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Designed and developed OLAP using MS SQL Server Analysis Services.

Environment: MS SQL Server 2008, MS SQL Server 2005, MS SQL Server Reporting Services, MS SQL Server Integration Services, SSAS 2008, Oracle, C#, VB.NET, OLAP, DTS/SSIS,BIDS

Confidential, Denver, CO

MS SQL Server Developer

Responsibilities:

• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Performed all aspects of database administration, including data modeling, backups andrecovery.
• Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.
• Created databases, tables, Indexes and views.
• Dropped and recreated the indexes on tables for performance improvements.
• 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.
• Used Common Table Expressions (CTE) in writing a recursive queries.
• Used CTE’s when referencing a table multiple times in same query.
• Created and schedule SSIS packages to load the data from Financial Management system to data staging environment and then to Data Warehouse.
• Followed the Microsoft recommended best practices in designing, developing, implementing and testing of the ETL using DTS,SQL Server Integration Services(SSIS).
• Built various packages in SSIS to load the data coming from various interfaces like Orders, Adjustments, and Objectives.
• Used multiple transformations in DTS to meet the business requirements by collecting data from various sources.
• Experience in query optimization & performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Developed a vast number of users interactive SQL Server Reports using Reporting Services and SSRS.
• Created stored procedures to build the Fact Tables in the data mart for Multi-Dimensional analysis.
• Scheduled and maintained daily and monthly loads of Orders, Objectives and Adjustments data through jobs, tasks, and alerts.
• Developed backup restore scripts for SQL Server as needed.
• 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.

Environment: MS SQL Server 2008, MS SQL Server 2005, T-SQL, Win NT v4, Win 2005, SSRS, SSIS, OLTP, OLAP, Analysis Services, Oracle, MS-EXCEL, SQL Loader.

Confidential

MS SQL Server Developer

Responsibilities:

• Designed and created SQL Database, tables, indexes, and views based on user requirements.
• Created User Defined Functions, cursors, and Triggers.
• Created & used stored procedures for database transactions in SQL Server.
• Created tables, views, clustered & non-clustered index, user defined data types and functions.
• Developed stored procedures and views for managing efficient data retrieval.
• Wrote various Stored procedures for the purpose of application development
• Developed backup & restore scripts for SQL Server as needed.
• Created joins and sub-queries for complex queries involving multiple tables.
• Used multiple join statements to retrieve data from multiple tables.
• Used database consistency checks using DBCC utilities.
• Generated Reports into Excel Spreadsheet form from SQL server6.5/7.0 using Reporting Services.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Designed the Forms & created Reports using Form Builder & Report Builder in Developer 2000.
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Worked in enhancing the bug/issue tracking system used by the entire team, to produce flexible reporting with respect to the life cycle of an issue.

Environment: MS SQL SERVER 2000/2005, Microsoft Business Intelligence Development Studio (BIDS), DTS-2000, OLTP, OLAP, SSIS-2005, Report builder, SSAS, XML, MS-EXCEL SQL Server Profiler