PROFESSIONAL SUMMARY:

• Over 8+ years of IT experience as a MS SQL Server Developer specializing in database design, development and administration of Business Intelligence Solutions using SSIS (SQL Server Integration Services), Informatica, Tableau Tools.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as (SSIS).
• Extensive experience in developing and deploying SSIS packages.
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• Hands on experience in migrating DTS packages to Integration Services Packages.
• Good understanding of ETL, Dimensional Data Modeling, Slowly Changing Dimensions (SCD) and DW.
• Experience in data warehouse development with Analysis services (SSAS) and Reporting Services (SSRS).
• Strong knowledge in database design features including ER Diagrams, normalization, tables, Temporary tables, constraints, keys, data dictionaries, and data integrity.
• Extensive experience in developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Indexes, CTE's, Joins and Sub queries with T - SQL.
• Experience in different type of reports including Tabular forms, Matrix (Cross /tab Report) form, Conditional, Drill down, Top N, Summary, List items, Charts and Sub Reports.
• Responsible for creating SQL datasets, multiple kinds of reports and dashboards for Power BI.
• Experience in administrating the created reports and assigning permission to the valid users.
• Experience in developing Custom Reports and different types of Tabular, Matrix, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Experience in tuning the reports that includes modifying and testing the required TSQL.
• Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports.
• Good knowledge of Report Builder 3.0 and QlikView.
• Designed SSAS Cube and developed MDX queries for Analysis.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.

TECHNICAL SKILLS:

Database: MS SQL Server 2014/ 2012/2008/2005, MS Access, Oracle 11g/10g

Programming Languages: T-SQL, PL/SQL, C, HTML, DHTML, XML, VB.NET, C#.Net

Framework: Microsoft .Net Framework 4.0/3.5/3.0

ETL / Reporting Tools: SQL Server Integration Services (SSIS), SSRS, Data Transformation Services (DTS), Informatica, Tableau, Power BI, Report Builder 3.0

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development studio, Enterprise Manager, SQL Profiler, Query Analyzer, Import & Export (DTS)

Database Tools: SQL Server Management Studio, SQL Developer, Toad

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash, QlikView

Operating Systems: Windows 2008, 2003R2, 2003, 2000 Advanced Server, Windows XP, Windows Vista, Windows 7

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

BI SSIS/SSRS Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
• Created complex SSIS packages using appropriate control and data flow elements with SSIS Standards like error handling, logging and working with package config files.
• Designed and implemented several complex reports.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using crystal Reports.
• Created Dashboards using SSRS.
• Created databases, tables, and fields for data entry, performing database capacity planning.
• Enhanced and deployed the SSIS packages from development server to production server and scheduled jobs.
• Supported the production team when issues rose in the packages.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, T-SQL.

SQL MSBI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Identified the dimension, fact tables and designed the data warehouse using star schema.
• Created volatile tables and partitioning the tables and Responsible for supporting existing projects.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Created Data-driven Packages in SSIS as part of Referral Process.
• Identified Data Source and Data Source Views CUSTOM Mappings for ETL.
• Developed, deployed and monitored SSIS Packages for new ETL Processes.
• Migrated data from Heterogeneous Data Sources to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports. Used cascaded parameters to generate a report from two different Data Sets.
• Developed Reports for business end users using Report Builder with updating Statistics.

Environment:: SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server BusinessIntelligence Development Studio (SSIS, SSRS), T-SQL, C#, .Net framework, XML.

Informatica Developer

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica Power Center 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.

Environment: Informatica Power Center 8.6.1, Oracle 10g/ 9i, MS-SQL Server, Toad, HP QC and MS Office.

Tableau Developer

Responsibilities:

• Created line charts to display trends over a period of time for application usage and tied it with bar charts to show revenue growth.
• API data was extracted by DBA that was put into SQL Server or Flat Fileand I was plugging that data into Tableau from either flat file or SQLServer.
• Extracting the data tables using custom generated queries from Excel files, Access / SQL database and providing exacted data as an inputto Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts.
• Created SQL Queries for testing the tableau Dashboards.
• Designed and developed reports such as Drill down, Drill Through and send the reports directly to the respective E-mails using Subscriptions
• Optimized queries by looking at Execution Plan for better tuning of the database.
• Developed internal and external performance management dashboards

Environment: MS SQL Server 2000, Tableau, Windows MS Office.

SQL DEVELOPER

Responsibilities:

• Involved in different stages of Project Life Cycle.
• Created new Databases, tables, established relationship among tables in a database.
• Created stored procedures and functions to support efficient data storage and manipulation.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Created and Scheduled DTS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Scheduled Jobs using SQL Server Agent.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Created different user level groups, and assigned appropriate permission level to the database.
• Preparation of project documentation.

Environment: SQL Server 2000/2005, DTS, MS Access, MS EXCEL, T-SQL, Windows 2000 server