SUMMARY

• Around 7+ Years of IT experience in SQL Server with Microsoft BI (Business Intelligence) in SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Server (SSAS), SSMS (SQL Server Management Studio).
• Experience in evaluating, designing, and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC), using MS SQL Server 2012/2008/2005/2000 , SQL Server Integration, and Reporting & Analysis Services.
• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2005 and 2008.
• Good Knowledge in Complex Stored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTEs) and Views.
• Involved in creating numerous database objects like tables, indexes, constrain (Checks, Primary and Foreign Key).
• Extensive Knowledge in OLAP/OLTP environment.
• Expertise in T - SQL i.e. Data Definition Language (DDL) and Data Manipulation Language (DML)
• Experience in working with OLAP and Data warehouse application and having a good knowledge in star schema, snowflakes schema.
• Experience in all phases of Software Development Life Cycle (SDLC) aspects including Requirements Analysis, Design, Development, Testing and Deployment.
• Good Knowledge in managing Data and Transaction log files, Files Groups.
• Well experience in data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS 2005/2008).
• Experience at Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column for unstructured and redundant data.
• Experienced in Using SSIS packages (.dtsx) include ETL process.
• Experience in creating SSIS package configuration, logging, jobs, scheduling, and error handling in SSIS packages.
• Experience on evaluating existing DTS packages on SQL 2000 and upgrading them to SQL 2005/2008/2012 SSIS packages.
• Expert in handling parameterized reports in SSRS 2005/2008/2012.
• Extensive knowledge in implementing complex reports like DRILLDOWN Reports, DRILLTHROUGH Reports and PARAMETARIZED Reports Using SQL Server Reporting Server.
• Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS.
• Expert in deploying the SSRS reports using Report manager. Involved in scheduling and deploying reports and uploading files to a report server.
• Good Knowledge in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Expertise in Cube designer in Business Intelligence Development Studio to edit various properties of a cube, including measures, cube dimensions and dimension relationships, calculations.
• Good Knowledge in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Worked on many Cascaded parameters in the reports using MDX and T-SQL.
• Experienced in Database design, entity relational ship model and application oriented design.
• Worked on PL/SQL data loading and unloading.
• Developed shell script to monitor servers.
• Developed Shell Script to monitor system performance.
• Good Knowledge in writing VBA code and using macros and formulas to speed processes and maximize accuracy.
• Knowledge in converting various feeds/reports into HTML pages to view through browser using VBA.
• Very good communication skills, good interpersonal skills & desire to excel, fast learner.
• Experience in working in tight schedules, result oriented & committed to meet the goal.

TECHNICAL SKILLS

Operating Systems: Windows 98/NT/2000/XP,2003/2008 Server, Windows 7/8, Unix

Databases: MS SQL Server 7.0/2000/2005/2008/2012 , Access 97/2000/2003

Sequel Server Tools: Management Studio(SSMS), Business Intelligence Development Studio(BIDS), Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard

ETL Tools: DTS, SSIS, SSAS, SSRS

Data Modeling: FACT and Dimensions Table Modeling

Languages: T-SQL, PL/SQL, HTML, XML, .Net, ASP .Net, visual basic, C, VBA.

Packages: MS Office, MS Outlook

PROFESSIONAL EXPERIENCE

Confidential, Atlanta GA

Business Intelligence /Sr. SQL Server Developer

Responsibilities:

• Created stored procedures, functions and views.
• Wrote many complex SQL queries and created constraints to maintain data integrity.
• Implemented easy user interface by creating Views and triggers in T-SQL for facilitating consistent data entry into database.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Developed reports using efficient data retrieval techniques.
• Updated functional specification and technical design documents.
• Formatted the reports using the Global variables and expressions.
• Used SSIS and Created ETL packages for extracting data from staging tables to partitioned tables using incremental load.
• Implemented merge join, triggers (insert, delete, and update) lookup and Data conversion transformations in SSIS Environment
• Transforming and validating data using SSIS Transformations and scheduled SSIS packages.
• Implemented various SSIS tasks like Derived Column and Conditional Split on data retrieved.
• Used SQL Server Integration Services (SSIS) for extracting data from OLTP to OLAP. Performed various types of transformations for extracting large data from different data sources.
• Developed SSIS packages for converting data from different data sources like MS Access, Excel, Text files.
• Worked on SSRS Reports, Sub Reports, Data Drill-Down, and Data sorting/grouping.
• Created reports using SSRS from different sources like SQL Server and Cubes from (SSAS) Analysis Services.
• Designed and developed Fact relationships in SSAS.
• Worked in Performance Tuning, Query Optimization and running Database.
• Checked the physical and logical consistency of a database using DBCC Utilities.
• Developed and Deployed OLAP cubes, data source view in SQL Analysis Service (SSAS).
• Defined attribute properties in a Parent Child Dimensions.
• Responsible for hiding and disabling attributes hierarchies.
• Sorted attributes members based on a secondary attribute.
• Developed VBA scripts for periodic P&L (Daily, Weekly) reports using Excel, Access (Reports, Forms).
• Supported team for performance testing by extending work hours and on weekends.

Environment: MS SQL Server 2012, MS Integration Services 2012,SSRS, MS Access, Import & Export Data, Windows XP, SSMS (SQL Server Management Studio)

Confidential, Miami FL

SSIS/SSRS/SQL Server Developer

Responsibilities:

• Designed and Created Huge Stored Procedures, User Defined Functions, Views and Implemented the Error handling in Stored Procedures and SQL Objects and also altered existing stored procedures, triggers, views, indexes depending on the requirement.
• Created complex Stored Procedures, triggers, tables, views and other SQL joins and statements for applications.
• Created DDL, DML scripts for creating database objects.
• Maintained SSIS packages and scheduling jobs, alerting.
• Designed many SSIS Configuration files that were used to pass parameters from outside the Business Intelligence Development Studio (BIDS) into the packages using XML files.
• Created ETL packages using SSIS/DTS for extracting data from staging tables and also data from different for loading Text files, Excel and Flat files to SQL Server.
• Developed and deployed SSIS packages.
• Implemented Incremental data load concepts for maintaining records history.
• Defined the report layout in SSRS.
• Created Ad-Hoc Reports Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Implemented various reports like drill through, drill down, parameterized reportsfor generating multiple enterprise reports from SQL Server Database (OLTP) and from SQL Server Analysis Database (OLAP).
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Generated Reports using Global Variables, Expressions based on the requirements.
• Worked on comprehensive backup and Disaster recovery Strategies for SQL Servers.
• Developed MDX queries for SSAS 2008 and SSRS 2008.
• Created MDX queries to extract data from the Data Mart.
• Created MDX queries to retrieve data from the cube and also to display SSRS reports.
• Developed Access/VBA programs to convert Excel data into XML format and fed to Web Development team.

Environment: SSMS(SQL Server Management Studio), MS SQL Server 2008, MS SQL Server Integration / Analysis/Reporting Services 2008, OLTP, MS Access.

Confidential, Chicago IL

SSIS/SSRS/SSAS/SQL Server Developer

Responsibilities:

• Implemented constraints on tables. Database tuning and performance planning.
• Created new database objects like Stored Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Implemented the concepts of Incremental Data Load and Slowly Changing Dimensions for updating and maintaining the history of the records.
• Deployed the created SSIS packages in Development and Testing environments.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all and etc.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services.
• Generated various reports with drilldowns, drill throughs, calculated members, and dropdowns from the cubes by connecting to Analysis server and SQL Server from SSRS.
• Used various report items like tables, sub report and charts to develop the reports in SSRS and upload into Report Manager.
• Proficiently created Reports based on the requirements using SSRS 2005, 2008.
• Created Ad-Hoc Reports Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Involved in generating SSRS reports for Forecasting Revenues based on the historical data.
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS).
• Preparing the reports for the day-to-day as well as weekly/monthly purposes.

Environment: SSMS (SQL Server Management Studio), Microsoft SQL Server 2005 Enterprise Edition, SQL Server Integrating Services (SSIS), SSRS, Visual Studio 2005.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Worked with all database objects, including tables, clusters, indexes, views, and procedures.
• Created databases, tables, relationships, constraints.
• Coded the SQL Server stored procedures for the enhancements.
• Wrote SQL Queries, views, Stored Procedures for the interaction of transferring data to and from screens to the backend, at optimum performance.
• Enhancement involved implementation of SQL Server with the usage of Stored Procedures.
• Maintained the client's policies and customer databases and tuning of the database instances.
• Created new databases for users as required. Checking the alert logs daily for errors.
• Creating and maintaining roles and profiles for security and limited access of data. Design and implementation of Backup & Recovery strategies.
• Tuning and optimization of the stored procedures.
• Planning & organizing the work structure, configuration, risk and delivery management.

Environment: SSMS (SQL Server Management Studio), SQL Server 2008/2005, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, SQL Profiler, Visual Studio 2005, MS Visio.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Involved in the entire System study, analysis and Design.
• Installation, configuration of MS SQL Server 2000 for development and testing purpose.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins.
• Involved in developing database objects such as triggers, constraints, indexes and views.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
• Used T-SQL to build dynamic stored procedures.
• Created database objects like tables, user defined functions and cursors using DDL, DML statements.
• Involved implementing Disaster Recovery for minimal downtime using different types of database backups, restore, and replication.

Environment: SSMS (SQL Server Management Studio), MS SQLServer2000, MS Access, Query Analyzer, DTS, BCP, SQL Profiler, Import & Export Data, Windows 2000 Server.