SUMMARY:

• Over 9 years IT experience with 9 years database development experience, 7 years Business Intelligence experience and 7 years Software Development experience.
• Expertise in Extracting, Transformation and Loading (ETL) using various tools including Bulk insert (BCP), Import/Export data, DTS packages and SQL server Integration Services (SSIS).
• Expert in Creating T - SQL code Indexes, Views, complex Triggers, effective Functions, and appropriate stored Procedures to facilitate efficient data manipulation and data consistency.
• Excellent experience of managing BI environment, which includes Business objects, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.
• Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, and Data Migration projects.
• Expert in creating Cubes and Implementation of perspectives, partitions, aggregations, roles, calculated members, calculated measures using SSAS.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings / workflows to extract data from Oracle, SQL Server and Flat File sources, legacy systems and load into various Business Entities.
• Expert in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL 2012/2008.
• Experience in stored procedure/TSQL coding, performance tuning, and query optimization.
• Experience in creating jobs, Alerts, SQL Mail Agent, Database Mails and Scheduled DTS and SSIS Packages using SQL Server Agent and enterprise scheduler Active Batch.
• Expert in database activities like database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.
• Strong ability in upgrading from MS SQL Server 2005 to MS SQL Server 2008 in various technical areas.
• Expertise in generating reports using business object such as Crystal Reports, SQL Server Reporting Services (SSRS) and Excel spreadsheet, scheduling and deploying reports on report manager.
• Expertise in Creating, Maintaining and supporting Micro strategy reports using Micro strategy Narrowcast.
• Proficiency in generating ASP.NET objects, MVC, Web Forms, Entity framework and LINQ using VB and C #.
• Experience in analytical Database Design project management software’s such as MS Project, TFS, SVN, GitHub and VSS.
• Excellent verbal/written communication skills and strong analytical abilities, and can perform well both independently and as a team player.
• Proficient in writing documentation, data warehouse artifacts and data lineage for ETL tools.

TECHNICAL SKILLS:

• MS SQL Server 2008/2005/2000
• Oracle 10g
• MS Access
• Transact-SQL(T-SQL)
• PL/SQL
• C
• C++
• HTML4.0
• XML
• ASP.NET
• VB.NET
• C#.NET
• JScript jQuery
• VBScripts
• MS SQL Server Integration Services(SSIS)
• MS SQL Server Analysis Services(SSAS)
• MS SQL Server Reporting Services(SSRS)
• SQL Profiler
• SQL Query Analyzer
• Index Tuning Wizard
• Visual Studio 2008/2005
• DTS
• ERWIN
• Crystal Reports 8.5
• MS VISIO 2003
• Trillium Software
• IIS
• Windows Server-2003/NT/XP/2000
• Windows Vista
• MS DOS
• UNIX
• BCP shell scripting
• PowerShell
• Web Forms
• ADO .NET Entity Framework
• MVC.

PROFESSIONAL EXPERIENCE:

Confidential

Sr. SQL Database/ETL Team Lead

Responsibilities:

• Actively participated in gathering business requirement from business analyst and turned it into functional and technical specifications.
• Designed, Implemented and maintained database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, DSR (Staging Database) to data warehouse.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column.
• Developed and deployed data transfers packages using SSIS, scheduled and maintained the jobs running on Servers.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization
• Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and Statements for application.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery for the data.
• Performed T-SQL tuning and optimization of queries using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008.
• Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard.

Environment: Microsoft SQL Server 2016, T-SQL, SSIS, Erwin, SQL Profiler, SSMS, Visual Studio, Team Foundation Server.

Sr. SQL Database/ETL Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Designed and developed database objects like Batch Scripts, Stored Procedures, Views, Tables and Indexes consumed at various stages of Cleansing process, Reports or Data Validation using SQL best practice standard.
• Responsible to extract data from staging to ODS, applying complex transformation and finally loading to DSS after creating Dimensional and Fact tables.
• Deploy SSIS Package into Production and used Variables to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy lookups using SSIS tasks.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures, functions, SSIS packages.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization using SQL server profiler and query execution plan.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQL Server Profiler to trace the slow running queries and the server activity.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
• Provided 7 x 24 Production support for the database and application issues.

Environment: Microsoft SQL Server 2008/2012, T-SQL, SSIS, Erwin, Windows server XP, SQL Profiler, SQL Navigator, Visual Studio 2013, GitHub, Team Foundation Server.

SQL Database Developer/Administrator

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation for the Project data collected.
• Helped in translating business requirements into technical design specifications and preparing high-level documentation for the Database Design and Database Objects.
• Wrote various complex queries for data analysis based on the business requirement and created data profiling report for data discovery.
• Created Views to reduce database complexities for different kinds of users, created and implemented User Defined Functions and Stored Procedures for reporting purpose.
• Designed high level ETL Architecture for overall data transfer from the Source Server to the Enterprise Services Warehouse using SSIS 2012.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column.
• Created Error and Performance Reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Thorough understanding of SSIS package and project deployment and dynamic package configuration using SSIS catalog.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.
• Created Partitions, Calculated Members, Schema and File Groups for fact tables and cubes
• Created high quality reports, dashboards and analytics using Micro Strategy (MSTR) to meet the needs of various business clients.
• Maintain and support Micro strategy reports to facilitate automatic scheduled processing using Micro strategy Narrowcast.
• Created and Scheduled Sub-Reports, Drilldown-Reports, Summary Reports, Parameterized Reports and Ad Hoc reports for viewing and analysis purpose using SSRS.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the SSRS report according to the requirement.
• Used conditional formatting to change the behavior of the SSRS report depending upon the requirements.
• Created Database Maintenance Plans for the performance of SQL Server which covers Database Integrity checks, update database Statistics and Re-indexing.
• Involved in data analysis and data manipulation in traditional DW environment and Hadoop HDFS eco system such as Hive and impala, sqoop, spark.

Environment: Hardware/Software: Microsoft SQL Server 2012/ 2008R2, SSMS, SSIS, SSAS, SSRS, BIDS, Oracle 10g, MSTR, T-SQL, PL/SQL, Microsoft Visual Studio.Net 2008, ASP.NET,3.5, VB.NET, .NET Framework 3.5, Windows XP, Office 2007, Shell Scripting, Hive, Impala, hue Browser, HDFS, UNIX, Sqoop.

SQL Server Developer

Responsibilities:

• Responsible for Data mapping and data dictionary document: from Staging/Data warehouse/Report-Data mart.
• Created SSIS package to extract, transform and load data into the Data warehouse and Report-Data mart.
• Created SSIS package to load data from Flat File to Flat File and Flat File to Data warehouse and Report-Data mart using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Experienced working with Trillium Software to create data profiling report for business user to validate business requirements and data quality.
• Created persistence lookup (reference data) using SSIS cache for optimal performance.
• Created VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Created complex store procedure for handling late arrival scenarios using set base update.
• Created complex script to load operational data to Support Direct Mail and Email Campaigns.
• Developed XML objects using SQL Server XML features such as RAW, Auto and explicit mode.
• Implemented various cubes Facts and Dimensions and created KPI Objects in line with Requirement Documents.
• Calculated measures and dimension members using MDX, mathematical formulas and user defined functions.
• Defined referential relationships with the measure groups and fact tables.
• Implemented perspectives, partitions, aggregations, roles, calculated members, calculated measures.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Created/Updated Stored Procedures, Triggers, Functions, Cursor, Views, and Indexes with extensive use of T-SQL.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server.
• Developed reports using business object such as crystal reports and SSRS.
• Created Tabular reports, Cross Tabs, Drill down, Charts, Functions and Maps using SSRS.
• Customized reports by adding Filters, Calculations, Prompts, Summaries and Functions.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Responsible for maintain documentation for ETL mappings and business logic.

Environment: Hardware/Software: Microsoft SQL Server 2005, SSMS, SSIS, SSAS, SSRS, BIDS, Oracle 10g, T-SQL, PL/SQL, Crystal Reporting Services v10, Microsoft Visual Studio.Net 2005, ASP.NET,3.5, VB.NET, .NET Framework 3.5, Windows XP, Office 2003

MS SQL Server /SSIS/SSRS Developer

Responsibilities:

• Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package task etc. to load underlying data in to the tables from Excel file and CSV file.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, Stored Procedures, functions, views and triggers.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Created business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, OLAP analysis and Reporting tools.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2005.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2005.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2005.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2005.

Environment: SQL Server 2005, ETL/SQL Server Integration Services (SSIS), Management Studio, MS SQL Query Analyzer, SQL Profiler, Database Tuning Advisor, SSRS and SSAS.

SQL Server Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, and SQL 2000).
• Created Configurations to make package portable and created Event handlers for handling package error.
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Designed Cubes with star schema in SSAS and Executing Analysis Services Processing Task in SSIS for processing cubes in packages.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Created Project Expense Statements in all Data marts and other Financial Reports using SSRS. Developed yearly and quarterly company expense reports.
• Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.
• Tuning SQL query for better performance using SQL Profiler.
• Actively supported business users for change requests.
• Documented all work, so user can easily understand the flow of process.

Environment: ASP.NET2.0, ADO.NET, Microsoft Visual Studio.NET, IIS V5.1, HTML, SQL Server 2000, SSIS,SSRS,TSQL, Query Analyzer, SQL Profiler,.NET Framework 2.0, and Windows 2003 server.