SUMMARY

• Over 10 years of experience in the IT industry as a SQL Server developer with specialized skills in SSRS, SSIS and SSAS.
• Very Strong SQL Server 2000/2005/2008 and 2012 developer and Admin skills including writing stored procedures, user - defined functions, triggers and views.
• Strong transact-SQL query writing skills and SQL Server Admin skills including SQL Server Installation, backup, high availability SQL Server solutions, including replication, log shipping, database mirroring.
• Very strong hands on experience with SSRS, developed several types of complex reports using SSRS (ad-hoc, drill-down, pivot, tabular, etc.).Created interactive reports with SSRS, using the report parameters, query parameters, filters and expressions and performed extensive trouble shooting by cross checking the report layouts, datasets, stored procedures.
• Extensive experience with SQL Server Integration Services (SSIS), developed several types of SSIS packages, Logging, SQL Mail, Check Point, Custom Control Flow, Variables Deploying, resolving complex issues and Error Handling in SSIS.
• Good Knowledge of Software Methodologies and Software development Life Cycle.
• Extensive experience with SQL Server Analysis Services (SSAS) that delivers online analytical processing (OLAP) and data mining functionality for business intelligence applications, created multi-dimensional cubes and reports using OLAP Services and Multidimensional Expression (MDX) queries.
• Developed data warehouses using data modeling techniques like dimensional data modeling, star schema modeling and snow-flake modeling thorough understanding of normalization /de-normalization and database design methodology.
• SQL Server Admin skills including SQL Server Installation, backup, high availability SQL Server solutions, including replication, log shipping, database mirroring.

TECHNICAL SKILLS

• Windows 98/NT/2000/XP 2003 Servers
• UNIX
• MS SQL Server 2000/2005/2008
• MS Access
• Oracle
• SQL Enterprise Manager
• SQL Profiler
• DTS Import/Export
• Backup Server
• Replication Server
• MS OLAP Services
• SQL Server Management Studio
• SQL Server Business Intelligence Development Studio (BIDS)
• DTS
• SQL Server Reporting Services (SSRS)
• SQL Server Integration Services (SSIS)
• SQL Server Analysis Services (SSAS)
• Transact SQL (T-SQL)
• PL/SQL
• HTML
• XML
• ASP.Net
• Microsoft Office Suite
• Windows Server 2003
• Tableau desktop 8.1/8.2 tableau server 8.1/8.2

PROFESSIONAL EXPERIENCE

Confidential, Baltimore, MD

Sr. ETL/Report Developer

Responsibilities:

• Involved in gathering reporting requirements from business team and users.
• Identified and defined the datasets for report generation.
• Created interactive reports with SQL Server Reporting Services (SSRS), using the report parameters, query parameters, filters and expressions.
• Created stored procedures and T-SQL scripts for reports.
• Created subscriptions to deliver the reports to business users.
• Created ad-hoc reports, drill-down, dash board and parameterized reports.
• Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.
• Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Designing, Deploying and maintaining high level complex ETL processes using SQL Server 2008 Integrations services (SSIS 2008) to perform daily and weekly loads to enterprise Data Warehouse.
• Troubleshooting, Optimizing the SSIS - ETL processes while implementing highest level of portability with Package configurations and environment variables.
• Created various types of reports like drill down, Parameterized, Conditional, Table, Matrix, Chart, and Sub Reports.
• Created daily, weekly and monthly SSRS dashboard reports for sales and profit analysis.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Created interactive excel reports for business using power pivot and power view 2013.
• Worked closely with end users, testers, business people and product managers in identifying and resolving the production on demand data issues
• Created and scheduled SQL Agent jobs to run SSIS packages.

Confidential, Minneapolis, MN

Sr. SSRS Developer/Tableau Developer

Responsibilities:

• Created DB2 SQL scripts for Reports.
• Created functional and technical specifications for projects.
• Involved in gathering reporting requirements from business team and users.
• Identified and defined the datasets for report generation.
• Created interactive reports with SQL Server Reporting Services (SSRS), using the report parameters, query parameters, filters and expressions.
• Developed several complex reports using SSRS.
• Designed and implemented reports security.
• Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
• Created sheet selector to accommodate multiple chart types in a single dashboard by using parameters.
• Using Multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Extensively used calculated fields for different logics for Trend, Extended price calculations for the different cost types.
• Foundefficientways to make tables and graphs which were visually easy to understand and Confidential the same time maintaining the accuracy of the core information content.
• Created ad-hoc reports, drill-down reports and parameterized reports.
• Deployed reports to report manager.
• Created documentation and trained end users on using report manager.

Confidential, Minneapolis, MN

Senior ETL Developer

Responsibilities:

• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.
• Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.
• Designing SSIS Packages using several transformations to perform Data profiling, Data Cleansing and Data Transformation.
• Created SSIS Packages using Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Row Count, Script Task, Data Flow Task and Variables to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, XML files and CSV files.
• Developed error and event handling using precedence Constraints, Break Points and check points.
• Created Informatica mappings and work flows.
• Documented the whole design of ETL Process using Visio tool.
• Create Control-M jobs to schedule Informatica Workflows, Batch scripts and SSIS packages.
• Used SQL profiler and query analyzer to optimize queries and stored procedures.

Confidential, Atlanta, GA

Sr. SQL Server BI Developer

Responsibilities:

• Involved in gathering requirements from business team and users.
• Created interactive reports with SQL Server Reporting Services (SSRS), using the report parameters, query parameters, filters and expressions.
• Created ad-hoc reports, drill-down reports, pivot and tabular reports.
• Worked with SQL Server Analysis Services (SSAS) that delivers online analytical processing (OLAP) and data mining functionality for business intelligence applications.
• Defined and processed the facts, dimensions, and cubes using Analysis Services.
• Involved in generating multi-dimensional cubes and reports using Analysis services
• Automated cubes process using Analysis Services Processing Task.
• Created Partitions, Aggregations and Attribute Hierarchies to improve the cubes performance
• Formatted the reports using global variables and expressions.
• Involved in generating multi-dimensional cubes and reports using OLAP services.
• Used SQL profiler and query analyzer to optimize report queries and stored procedures.

Confidential, Minneapolis, MN

Sr. SQL Server BI Developer

Responsibilities:

• Involved in gathering requirements from business team and users.
• Worked with SQL Server Analysis Services (SSAS) that delivers online analytical processing (OLAP) and data mining functionality for business intelligence applications.
• Defined and processed the facts, dimensions and cubes using MS OLAP.
• Involved in generating multi-dimensional cubes and reports using OLAP services
• Created Partitions, Aggregations and Attribute Hierarchies to improve the cubes performance
• Identified and defined the datasets for report generation.
• Formatted the reports using global variables and expressions.
• Troubleshot reports by cross checking the report layouts, datasets, stored procedures and SQL Server Integration Services (SSIS) packages.
• Involved in multiple transformations and integrations in SSIS to meet the business requirements by collecting data from heterogeneous sources to SQL Server databases using SSIS.
• SSIS packages, Logging, SQL Mail, Check Point, Custom Control Flow, Variables Deploying, resolving complex issues and Error Handling in SSIS.
• Experience with import/export, BCP and bulk insert tools.
• Involved in generating multi-dimensional cubes and reports using OLAP services.
• Created interactive reports with SQL Server Reporting Services (SSRS), using the report parameters, query parameters, filters and expressions.
• Created ad-hoc reports, drill-down reports, pivot and tabular, multi-tab worksheet reports.
• Used SQL profiler and query execution plan to optimize SSIS package queries and stored procedures.

Confidential, San Ramon, CA

SQL Server BI Developer

Responsibilities:

• Installed and configured SQL Server 2005/2008 on Windows environment.
• Created stored procedures, triggers, views, and functions for the application.
• Wrote T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries and stored procedures.
• Identified and defined the datasets for report generation.
• Troubleshot reports by cross checking the report layouts, datasets, stored procedures and SQL Server Integration Services (SSIS) packages.
• Created interactive reports with SQL Server Reporting Services (SSRS), using the report parameters, query parameters, filters and expressions.
• Gained experience with report manager, report builder and report security.
• Developed several complex reports using SSRS.
• Created ad-hoc reports, drill-down reports, pivot and tabular reports.
• Experience in building Data Integration and Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS)
• Proficient in upgrading from DTS to SSIS packages, Logging, SQL Mail, Check Point, Custom Control Flow, Auditing, Variables Deploying, resolving complex issues and Error Handling in SSIS.
• Data conversions from legacy systems to SQL server.
• Used multiple transformations and integrations in SSIS to meet the business requirements by collecting data from heterogeneous sources like Excel, CSV, Oracle, flat file, Text Format Data to SQL Server databases using SSIS
• Used SQL profiler and query analyzer to optimize SSIS package queries and stored procedures.
• Created SSIS packages for transferring data from various data sources like Oracle, MS Access, Excel, *.txt file, *.CSV files.
• Worked with off-shore developers.

Confidential, Atlanta, GA

SSIS/SSRS Developer

Responsibilities:

• Involved in the data warehouse project to enable management to better leverage information collected within current operational systems to help in their decision making process. In first phase, through a formal prioritization effort identified key analytical subject areas. In the second phase, developed ETL system, transformed legacy data base in SQL Server 2000 DTS to SQL Server 2005 SSIS packages and generated Reports in SSRS.
• Responsible for creating reports based on the requirements using SSRS 2005.
• Identified and defined the datasets for report generation.
• Wrote queries for drill-down reports and defined report layouts.
• Identified and included report parameters.
• Formatted the reports using global variables and expressions.
• Created SSIS packages for transferring the data from different systems.
• Created SSIS packages for transferring data from various data sources like Oracle, MS Access, Excel, *.txt file, *.csv files.
• Created interactive reports with SSRS, using the report parameters, query parameters, filters and expressions.
• Gained expertise in creating reports of all types in SSRS, such as ad hoc reports, drill-down reports, pivot and tabular reports.
• Upgraded SQL Server 2000 DTS packages to SSIS for uploading various formats of files and databases to MS SQL Server 2005 using SQL Server Integration Services (SSIS).
• Used SSIS and bulk insert task to transfer data in and out of the server.
• Created tables, views, indexes, and user defined functions.
• Optimized query performance by creating indexes.
• Involved in performance tuning of TSQL queries and stored procedures.
• Developed complex stored procedures to create various reports.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.

Confidential, Boston, MA

MS SQL Server DBA/Developer

Responsibilities:

• Involved in installing and configuring of SQL Server 2000/2005.
• Maintained Security, Roles and Privileges to users.
• Involved in Database Design, Development, Implementation, ETL and Reporting services in SQL Server 2005/2008.
• Implemented Database Mirroring for High availability solution.
• Used DBCC commands for checking database consistency and fixing data corruption in user databases.
• Creating databases and logins with permissions in SQL server 2005/2008 as per the developer’s request.
• Created Linked Servers between SQL server 2000/2005 and Oracle servers in the environment.
• Monitor backup jobs daily and run the jobs manually in case of failure depending upon the necessity.
• Created and scheduled jobs to setup log shipping between production servers.
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Designed ETL packages for different data sources (SQL Server, Flat Files, and XMLs etc).

Confidential

MS SQL Server DBA

Responsibilities:

• Installed SQL server on development, test and production servers in Windows environment and ensured all servers were up-to-date with latest Service Packs, hot fixes.
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans for better performance and proper use of Indexes to enhance the performance of individual queries and enhance the Stored Procedures
• Worked on call 24/7 Support on weekly basis to maintain multiple SQL instances
• Implement high availability through database mirroring and Merge Replication.
• Import / Export using DTS and BCP utility.
• Setting up DR sites using log-shipping and Wrote dynamic stored procedures for moving Databases from production server to DR server.
• Setting up Replication using Dynamic scripts and solving problems.
• Propping up the new schema changes and additional new features on Development, Staging/QA and Production servers.
• Wrote dynamic stored procedures to create Database Roles and grant permission to roles and adding logins to specified roles
• Designed new schema for data partition and created Partition views for better performance.
• Involved in writing T-SQL Programming for implement Stored Procedures and Functions
• Performance Tuning, Analyze, tuning and optimizing for SQL Server Application by using performance monitor. Assist the SQL Developers in SQL tuning.
• Created updatable partitioned views in SQL Server for better response times