SUMMARY

• 7 plus years of excellent experience with demonstrated success in the database design, development and deployment of large - scale enterprise applications.
• Experience in SQL Server Development including writing T-SQL Programming, Physical and logical Database Design, SQL server 2008 suite of products SSIS, SSRS, SSAS.
• Experience with MS SQL 2012 SSIS/SSAS/SSRS
• Strong knowledge in Great Plains, SharePoint, Scribe, Web Services, and BizTalk.
• Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration from SQL Server 2000 to SQL Server 2005 and from SQL Server 2005 to SQL Server 2008.
• Experience in SQL Server DTS and SSIS (Integration Services) package design, constructing, and deployment.
• Using Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Expert level skills in Objects creation such as Tables and Views, Table Normalization, User Defined functions, Indexes, Stored Procedures, coding, correlated sub queries, Cursors and Triggers.
• Experienced in Reorganizing database structures, Reorganize or de-fragment database table spaces, tables, and indexes
• Experience in Normalization & De-normalization of database, Performance Tuning and Query Optimization
• Good hand on experience on Joins and sub-Queries to simplify complex queries involving multiple tables.
• Hands-on experience in Wireless Devices and Outlook CRM Laptop Client.
• Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.
• Expert in implementing and planning Server Security and authentication, Database Normalization, designing and creating Indexes, Develop Queries and T-SQL Scripts in MS SQL 2000/2005/2008 .
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2005/2008.
• Developed Standard Reports, Sub Reports, Cross Tab Reports, Used various Charts and graphs like Bar Chart, Line graphs, sorting the data, defining subtotals in SSRS 2005/2008.
• Proficient in using global variables, expressions and functions for the reports.
• 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.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Migrated 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.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Experience in creating scheduling Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Followed the Microsoft recommended best practices in designing, developing, implementation and testing of the ETL using SQL Server Integration Services.
• Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert.
• Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle.
• Expert in defining calculated members, KPI’s, cubes, dimensions with SSAS 2000/2005.
• Great Knowledge in Dimensional Modeling, applying Kimball’s methodology, Star Schema/Snowflake Schemas, ODS. Experience in Performance Optimization of SSAS cubes.
• Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle.

TECHNICAL SKILLS

Databases: SQL Server 2012, SQL Server 2008, SQL Server 2005, SQL Server 2000/7, Access, Oracle 9i/10g/11g, MySql, data warehouse, DB2

Tools: Microsoft Visual Studio 2010/2008, SS Management Studio, Query Analyzer, System Performance Monitor, Event Viewer, SQL Profiler, Index Tuning Wizard, Upgrade Wizard, Databases Maintenance Plan Wizard, Data Transformation Services (DTS), VB6, VB.Net, Database Engine Tuning Advisor, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio, SQL CMD, SQL Server DBA Dashboard, Toad for Oracle, Toad for Data Analysts, COGNOS 10.2, Composite Studio 6.1, IBM Info sphere Data Stage, iSeries Navigator

Languages: T-SQL, C, HYPERLINK, PL/SQL, C# 2.0, LINQ, HTML, UML, XML, XMLA, Java script

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 9.0/8.5,OLAP.

Operating Systems: Windows Server 2000, Windows NT Server, Windows Server 2003, Windows XP, UNIX, Agile, Linux

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

Database Tools: SQL Query Analyzer, ERWIN,SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

SQL Server BI Developer

Responsibilities:

• Analyzed and designed software and database solutions.
• Used software development life cycle (SDLC) in the entire process of formal, logical steps taken.
• Worked on database planning in relation to physical and logical data architecture.
• Responsible for designing and developing Schemas using Entity Relationships, Data Modeling, Normalizing the relations, creating Tables, Views, Indexes etc.
• Designed data models. Developed physical data models and created DDL scripts to create database schema and database objects.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler and SQL Server Agent.
• Extensively used Joins, Table variables, Temp tables, CTE and sub-queries for complex queries involving multiple tables from different databases.
• Used SQL Profiler, Query Analyzer and DTA to optimize SQL queries and stored procedures.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Migrated Organization data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) Created Indexes, Constraints and Rules on database objects.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures, Cursors and triggers maintaining Referential Integrity..
• Involved in importing and exporting data from SQL server to another database by using SSIS of SQL Server using Import/Export wizard.
• Developed, deployed and monitored SSIS Packages to automate several tasks utilizing expressions, tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, OLEDB Connection, OLEDB Command and Derived Column.
• Developed Parameterized Reports, Adhoc Reports, Sub Reports and Web Reports using SQL Server Reporting Services.
• Designed and implemented reports in MS SSRS.
• Developed Tabular Reports and Chart Reports using Excel Spreadsheet.
• Used SharePoint Portal Server for document management and tracking.
• Created and explored a Data Cube by defining a data source, data source view and invoking the Cube Wizard using SSAS.
• Built effective queries for high-performance reporting and rendered them in HTML, XML, PDF and Excel formats using SSRS 2012
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Implemented and documented proactive monitoring scripts for production databases.

Environment: SQL Server 2005/2008, Business Intelligence Studio (SSAS, SSIS, SSRS), Cognos 8.4.1(Framework Manager, Query studio, Report Studio, Transformer, Analysis Studio) Cognos 10.1.1(Framework Manager, Report Studio, Business insight, Query Studio, Business Insight Advanced, Analysis Studio) Windows XP, Data stage, DB2 Database. Cognos 7.4 and 7.5 Tools(Power Play, Transformer, Power Play Web, Report Administration, Access Manager, Upfront). Business Objects. IBM Rational Clear Quest.

Confidential, Phoenix, AZ

SQL BI DEVELOPER

Responsibilities:

• Involved in Installation and Configuration of MS SQL Server 2008.
• Created Database Objects like Stored Procedures, Triggers and User Defined Functions (UDF) for this project.
• Created SSIS packages to pull data from SQL Server and exported to flat files, CSV files and Excel Spreadsheets and vice versa.
• Involved in tuning of SQL scripts using stored procedures and functions.
• Generated back up file for data base using Back up Database task in SSIS.
• Involved in maintenance and administration of SSIS by creating Jobs, alerts and schedule SSIS packages.
• Experience in creating and managing linked servers.
• Generated scripts to back up and restore data bases.
• Managed the imports and exports for the data bases and troubleshoot load failures.
• Created SSIS packages to unzip files and move them to folders dynamically based on the file names.
• Created Views to maintain security of customer data.
• Created Indexes to get the high level performance.
• Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
• Created ETL packages with different data sources and loaded the data into destination tables by performing complex transformations using SSIS packages.
• Designed SSIS packages for synchronizing the data between two different servers.
• Created and Scheduled jobs for various tasks and also was responsible for maintaining jobs.
• Used various advanced SSIS functionalities like complex joins, conditional splitting, column conversions for better performance during package execution.
• Created SSIS Packages to migrate slowly changing dimensions.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created Ad-hoc reports and cascading reports for historical data using SSRS..
• Developed and Scheduled SSIS Packages for loading Facts and Dimensions.
• Created Partition table for very large database for good performance.
• Configured mail profile for sending automatic mails to respective people when job is failed or succeed.
• Created partition function, schema and file groups for fact tables.
• Created Drill Down and Drill Through Reports in SSRS.
• Automated the execution of SSRS reports using Subscriptions and Data-Driven Subscriptions.
• Involved in the post deployment maintenance of canned reports and cubes.
• Involved in the design, development and maintenance of different cubes using SSAS

Environment: MS SQL Server 2012/2005/2008 , SSAS, SSIS,SQL Server Reporting Services 2005/2008, Oracle, SSIS, Erwin, VB.Net, C#,ASP.NET Windows XP / NT / 2000/2003, MS Office 2003/2007.

Confidential, Windsor, CT

SQL BI DEVELOPER

Responsibilities:

• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design,
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development
• Developed OLAP Cubes using SQL Analysis Services (SSAS).
• Involved in creating Named calculations and named queries.
• Created Dimensions with the cube wizard and also individually.
• Refreshing the cube to get the latest information updated.
• Created SSIS packages to Oracle and other SQL Server instances.
• Created Triggers and Stored Procedures to capture updated and deleted data from OLTP systems.
• Deployment of Cubes to the production server.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Created Global variables, expressions and functions to generate dynamic reports.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Created Packages
• For the data warehouse Analysis services and develops the different reports for the analysis.
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Created SSIS packages using control flow and data flow elements.
• Configured packages to deploy them to different environments.
• Designed dashboards for different reports like charts, matrix, Data bar in SSRS.
• Build database queries and test cases for the testing team to test the reports
• Created Sub-Reports, Drilldown-Reports, and Cross Tab reports using MS SQL Reporting Services (SSRS).
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.

Environment: SQL Server 2005/2008, Business Intelligence Studio (SSAS, SSIS, SSRS), T SQL, Erwin, MDX, Oracle 10g, MS Excel.

Confidential, Milwaukee, WI

SQL Server BI Developer

Responsibilities:

• Installation of MS SQL enterprise servers on test and development boxes.
• Designed and Created databases, tables, views, stored procedures and triggers.
• Created groups, roles, users and assigning access privileges to users.
• Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Monitored and scheduled existing/new jobs on production environment.
• Optimizing Database Queries for performance enhancements and Writing T-SQL Views and triggers.
• Worked to tune the SQL queries using SQL Profiler.
• Tested backup and recovery strategies in a test environment before and after moved to production environment.
• Extensive use of Stored Procedures. Created new stored procedures and modifying existing ones.
• Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services (SSIS).
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• 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.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
• Developed optimal stored procedures and queries to create data sets for reports.
• Designed and implemented stylish report layouts.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Played a Content Manager role on report server.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Designed SSAS cube to hold summary data for Target dashboards.
• Developed Cube with Star Schema.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: MS SQL Server 2005, MS SQL Server 2000, Windows 2003 Server, T-SQL, SSIS, SSRS,SSAS, ASP .Net, VB.net.

Confidential

SQL Server Developer

Responsibilities:

• Developed SSIS packages to conduct simple and complex transformations, and executed these packages using the execution package.
• 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.
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services 2005/2008.
• Designed and deployed Reports with Drop Down menu option and Linked reports.
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Wrote complex Stored Procedures, coding and triggers to capture updated and deleted data from OLTP systems.
• Experienced in implementation of strong referential integrity and auditing by the use of triggers.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and Oracle
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse
• Created new cubes and modified existing cubes using SSAS 2008 to make data available for the decision makers.
• Deployed and processed SSIS Packages and SSRS Reports weekly to update information (As per business logic) by using SQL Server Agent and windows Scheduler.
• Created jobs, alerts to run SSIS, SSRS packages periodically. Created the automated processes for the activities such as database backup processes and SSIS, SSRS Packages run sequentially using SQL Server Agent job and windows Scheduler.
• Migrated and recreated existing Dimensions and Cubes using Star schema on 2005 Server to achieve the efficiency of SQL Server Analysis (SSAS).
• Worked with Transactional and Snap-shot Fact-Tables.
• Used MDX expressions to define calculated members in cubes to calculate values at run time.
• Created copies of operational Databases using the Import/Export Wizard.
• Monitored the performance of Database objects using Performance Monitor that ships with SQL Server 2005/2008.
• Developed Triggers to raise events on executing insert, delete and update stored procedures.
• Optimized existing stored procedures to achieve improved performance
• Used MDX scripting for querying OLAP cubes.
• Developed advanced correlated and un-correlated sub-queries in T-SQL to develop complex reports.
• Developed Cross-Tabbed and Sub-Reports in SSRS 2005/2008.
• Generated reports using the Crystal Reports and Reporting Services 2005/2008Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2005/2008.
• Developed XML tags to structure data and improve the data migration process.
• ETL process was documented for future references.
• Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment
• Created OLAP CUBEs using SQL Server Analysis Services (SSAS).
• Designed user defined hierarchies in SSAS including parent-child hierarchy.
• Created complex SSIS packages using various transformations.

Environment: MS SQL Server 2000/2005/2008 , Windows Server 2003, 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

SQL Server Developer

Responsibilities:

• Installed SQL Server 2005 and Configured to the database.
• Wrote stored procedures, triggers, and constraints to ensure data integrity, data consistency and to meet the business rules. Tuned SQL statements and Stored procedures.
• Converted various SQL statements into stored procedures thereby reducing the number of database accesses.
• Performed data validation and aggregation.
• Performed query optimization and checked performance tuning.
• Used query analyzer to optimize queries.
• Created the Cubes and Dimensions.
• Created complex SSIS packages using proper control and data flow elements with error handling.
• Responsible for gathering/refining requirements from the customer for developing reports.
• Created SQL Server Reports using SSRS 2005.
• Identified the Data Source and defining them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS 2005.
• 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.

Environment: SQL Server, SSIS, SSRS, Query Analyzer, Enterprise Manager, Windows, SQL Profiler, T-SQL.