PROFESSIONAL SUMMARY:

• 6+ years of strong IT experience in Database Design, Development and business intelligence of Microsoft SQL Server 2012/2008/2005 with various business domains like Banking, Insurance and Health care.
• Sound knowledge of software development life cycle (SDLC ) with substantial experience with object oriented analysis and design methodologies.
• Exceptional hands on working knowledge with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Extensive Data Warehousing experience in Business Requirement Analysis, Design, Development, Testing, Implementations, Loading, Maintenance, Enhancements of Data warehouse, and ODS systems using Informatica 9.x/8.x, Oracle 11g/10g, DB2, SQL Server, Teradata, PL/SQL, and well versed with Data Warehousing Architecture Technology, Operational Data Store, and Dimensional Data Modeling.
• Expertise in Data Warehouse Modeling with SQL Server Analysis Services (SSAS ).
• Expertise in creation and deployment of dimensions, partitions, aggregation and cubes on SSAS.
• Very good knowledge in scheduling and deploying reports on report manger.
• Created reports that have been defined by business architect and generated canned reports in a Crystal format of Crystal Reports.
• Worked on predefined, developed stored procedures for automation and scheduling in crystal reports.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Expertise in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using SSIS.
• Experience in enhancing and deploying the SSIS Packages  from development server to production server.
• Experience in TOAD v9.5 for developing and managing PL/SQL scripts.
• Good Hand on Resolving complex issues and Error Handling in SSIS .
• Created cluster index and non - clusterindex on tables and disable them before inserts and enable when inserts completed.
• Expertise in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services. 
• Very good knowledge of MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands. 
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Implemented complex business logic with User-Defined-Functions, Indexed Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP. 
• Expert inT-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD. 
• Developed and implemented the application code in Oracle PL/SQL and T-SQL.
• Ability to work in-groups as well as independently with minimal supervision.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

• MS SQL Server
• MS Access
• Transact-SQL
• PL/SQL
• C
• C++
• XML
• SQL Server Integration Service (SSIS)
• Teradata
• SQL Server Reporting Service (SSRS)
• SQL Server Analysis Services (SSAS)
• SQL Profiler
• SQL Query Analyzer
• Informatica Power Center
• Oracle 9i/10g/
• Teradata 13/14.1
• BizTalk server 2006
• Microsoft Visio
• Erwin
• MS Office.
• RDBMS
• TFS
• MS SQL Server Index Tuning Wizard
• Visual Studio
• VB.NET
• DTS SQL Developer
• Crystal Reports 8.5
• Cold Fusion.

WORK EXPERIENCE:

Confidential, Alpharetta, GA

Sr. ETL/MSBI Developer

Responsibilities:

• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation. 
• Worked on Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services. 
• Created packages in SSIS with error handling. 
• Worked with different methods of logging in SSIS. 
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse. 
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema. 
• Filtered data from Transient Stage to EDW by using complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity. 
• Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD. 
• Maintaining jobs for data messaging from development server to test server for generating daily reports.
• Used data conversion tasks in SSIS to load the data from flat file to SQL Server database. 
• MS SQL Server Configuration, Performance Tuning, Client-Server Connectivity, Query Optimization, Database Maintenance Plans and Database Consistency Checking DBCC commands. 
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services cubes& Reporting Services. 
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Developed, monitored and deployed SSIS packages. 
• Created document for Self-Service Deployment and Execution process for SSIS packages. 
• Constructed OLTP and OLAP Databases. 
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs. 
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures. 
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS. 
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: SQL Server 2008/2012, Windows Server, SSIS, SSAS,SSRS,Excel, T-SQL, PL/SQL, MS Access, Team foundation server(TFS), Mainframe VSAM & Flat Files, Power BI

Confidential, Alpharetta, GA

Sr. SSIS/MSBI Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, Oracle DB, and SQL). 
• Performed Loading operation of historical data using full load and incremental load into Enterprise Data Warehouse. 
• 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. 
• Developed Custom Logging so user can know when a row is inserted in custom logging table by every SSIS package that executes. 
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 as SSIS Packages. 
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages. 
• Filtered data from Transient Stage to EDW by using complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity. 
• Used For each loop container, Sequence Container, Script task, Expressions, Execute SQL task, Send Mail Task, Package Execution task to achieve business needs. 
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database. 
• Design and develop dynamic advanced T-SQL, PL/SQL, MDX query, stored procedures, XML, user defined functions, parameters, views, tables, triggers, indexes, constraints,SSIS packages, SSAS Cubes, SQL Server Agent jobs, deployment scripts and installation instructions for enterprise data warehouse and applications. 
• Created and modified various Stored Procedures used in the application using T-SQL. 
• 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. 
• Wrote complex Expressions and Calculations for SSRS reports with Conditional Formatting. 
• Created Project Expense Statements in all Data Marts and other Financial Reports using SSRS.

Environment: SQL Server 2008/2005, Windows Server, SSIS, SSRS,SSAS and TFS

Confidential, Boston, MA

SQL Server Developer

Responsibilities:

• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS. 
• Created SSIS process design architecting the flow of data from various sources to target. 
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases. 
• Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments. 
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources. 
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers. 
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis. 
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance. 
• Responsible for scheduling the subscription reports with the subscription report wizard. 
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports. 

Confidential, Richmond, VA

ETL/ MSBI Developer

Responsibilities:

• Involved in complete SDLC life cycle. 
• Extract, Transform and Load source data into respective target tables to build the required data marts. 
• Understand user requirements and Data Model defined and developed by the business analysts and data architects. 
• Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis. 
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards. 
• Implemented different types of constraints on tables. 
• Designed and applied entity and attributes description and definition for the models. 
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases. 
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler. . 
• Responsible for gathering business requirements to create business user reports. 
• Developed optimal stored procedures and queries to create data sets for reports. 
• Created SSRS Reports on the top of the cube using some MDX queries. 
• Responsible for scheduling the subscription reports with the subscription report wizard. 
• Migrating COGNOS reports to SSRS. 
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports. 
• Developed SSAS Cubes, partitions, aggregation from scratch with Star Schema. 
• Performed unit and system testing, troubleshooting and bug fixing in Prod and QA environments.