SUMMARY

• Around 7 + years of total IT experience in the Design, Modeling, and Development, Implementation and Support of SQL Server 2005/2008/2008 R2/2012.
• Expertise in designing optimizing the various T - SQL database objects tables, views, stored procedures, user defined functions, cursors, indexes and triggers using Management Studio & SQL Profiler.
• Expert at developing ETL interfaces using SSIS, Data marts/cubes using SSAS and enterprise reports using SSRS utilizing latest versions (2005/2008/2012 ) & features.
• Experience in building Data Integration and Workflow Solutions and Extract, Transform and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Skilled in error and event handling: Precedence Constraints, Break Points, Check points and Logging.
• Designed and mapped using various SSIS Transformations like OLEDB command, Conditional Split, Aggregate, Multicast and Derived Column.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Executing SSIS Packages using C# Scripting.
• Expert in Extracting and Transforming data (ETL) from various heterogeneous sources like SQL DB and creating packages using SSIS/DTS, Import, Export Data, Bulk Insert and BCP utilities.
• Expert in automating process by creating Jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Developedvarious Web Forms and reusable business logic components in anObject orientedmanner usingC#.
• Developed OLAP Cubes using SSAS(SQL Server Analysis Services) and calculate the metrics that were revealed in the functional analysis.
• Creation of Dimensions and Cubes and Creating Hierarchies and Relationship among Dimensions and Facts.
• Designed and created website utilizingASP.Nettechnologies for the system usingADO.Net, HTML, and XMLin designing form, validating inputs and connecting to backend database.
• Used multiple transformations and integrations inSSISto meet the business requirements by collecting data from heterogeneous sources like Excel, CSV, flat file to SQL Server databases usingSSIS
• Expert in reports using Crystal Reports and SQL Server Reporting Services 2005/2008/2008 R2/2012 (SSRS).
• Extensive experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SSRS.
• Worked with report manager for deploying the reports across all the environments and sending reports through e-mails to subscribers.
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
• Experience in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SSRS.
• Experience working with Business Intelligence data visualization tools with specialization on Tableau.
• Designed and deployed reports with Drill Down, Drill Through and Drop Down menu option and Parameterized and Linked reports using Tableau.
• Implemented indexes (clustered & non-clustered) on tables and views for optimum performance tuning.
• Experience in query optimization & performance tuning.
• Experience in providing high quality application support on data integration and data management.
• Excellent written and oral communication skills with a results-oriented attitude. Good in Collecting, Analyzing and Interpreting Data in an organized way.
• Ability to grasp and apply new concepts quickly and effectively.

TECHNICAL SKILLS

Operating System: Windows XP, Windows 2000/98/95/NT, Windows Vista, Windows 7

RDBMS: MS SQL SEVER 2008R2/2010/2012, Oracle 9i, 10g

ETL Tools: ETL tool Informatica SSIS 2008R2/2012

Reporting Tools: Crystal Reports, SSRS 2008R2/2012, Tableau 7

Programming Languages: C, Unix, C++, C#

Version Control: Visual Source Safe, Team Foundation Server

PROFESSIONAL EXPERIENCE

Confidential, Dearborn, MI

SQL BI Developer (SQL Server, SSIS, SSRS)

Responsibilities:

• Interacted with different business teams to gather requirements for reporting and analysis.
• Developed the Logical and Physical Design models as per business requirements.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Created, implemented and maintained a reporting suite of over 72 standard reports while also customizing many reports to meet individual client needs.
• Responsible for generating Tabular, Parameterized (single, multi), Drill through & Drill Down, Map, Gauge, Matrix and Sub Reports in SSRS with PDF, XLS and CSV Formats.
• Responsible for designing and deployment of Reports for the End-User requests using Web Interface & SSRS.
• DevelopedHTMLpages for screen outputs and auto response emails.
• Responsible for developing Security Layers for web page security and User Authentication inC#.
• Identifying, extracting, manipulating, transforming, validating and modeling data across multiple domains within an Oracle environment.
• Developed VBA automations to provide business users with self-service recurring reports and dashboards.
• Involved in Installation, Configuration and Deployment of SSRS reports.
• Created solution driven views and dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau.
• Creating Jobs, Alerts, SQL Mail Agent, and Scheduled SSIS Packages.
• Involved in Huge data migrations, transfers using utilities such asData Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Created new Informatica environment, repositories, users, users group, granting the permissions, creating relational connections, scheduling the jobs for development and production environment.
• Planning and maintaining sufficient memory on Informatica application servers across the grid for better ETL Load performance.

Environment: MS SQL Server 2008R2, SQL Server Integration Services (SSIS) 2008R2, SQL Server Reporting Services (SSRS) 2008R2, Report Builder 3.0, T-SQL, MS Office, Windows 7

Confidential, Tucson, AZ

SQL BI Developer (SSIS, SSRS)

Responsibilities:

• Designed SSIS Packages to handle data migration (ETL Processes) from transaction system to dimensional model.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Created the Staging tables and extensively used various SSIS transformations for successfully migrated old data from legacy system into SQL Server using SSIS Packages.
• Generated reports using SSRS. Identified the Data Source and defined them to build the Data Source Views, used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
• Identifying, extracting, manipulating, transforming, validating and modeling data across multiple domains within an Oracle environment.
• Developed VBA automations to provide business users with self-service recurring reports and dashboards.
• Utilized remoting andthreading techniquesinC#for load balancing and asynchronous processing.
• Responsible for UI Design usingASP.NETControls,WEB USERControls, Custom Controls,HTML, JAVASCRIPT, andCSS
• Worked on Database design and reporting. Experience working with Tableau, development of dashboards and publishing the reports.
• Configuring Report Model for developing ad-hoc reports by the end-users.
• Uploading reports on to the report manager and organized them into folders.
• Responsible for scheduling the subscription reports with the subscription report wizard. Deployed the generated reports directly on the client’s workstation.
• Using Query Optimization and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
• Creating Views and Indexed Views to reduce database complexities for the reports.
• Enhancing and deploying the SSIS Packages from development server to production server.

Environment: MS SQL Server 2008R2, .NET Framework 3.5, SQL Server Integration Services (SSIS) 2008R2, SQL Server Reporting Services (SSRS) 2008R2, Report Builder 3.0, Tableau 7, T-SQL, MS Office, Windows 7.

Confidential, Jacksonville, FL

SQL Server SSIS/SSRS Developer

Responsibilities:

• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases.
• Transferred Data Base From SQL Server 2005 to SQL Server 2008 by Backup Technique.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
• Responsible for conceptual, logical and physical design with a significant effort towards application using ERWIN.
• Performed activities like analyzing and improving the architecture of databases, creation and indexing of the tables.
• Extensively used SSIS transformations such as Slow Changing Dimension, Lookup, Conditional split, Sort, Merge Join, Aggregate, and Execute SQL task etc.
• GeneratedSub-Reports,Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Identifying, extracting, manipulating, transforming, validating and modeling data across multiple domains within an Oracle environment.
• Developed VBA automations to provide business users with self-service recurring reports and dashboards.
• Created reports to retrieve data usingStored Proceduresthat accept parameters.
• Generated reports using SSRS. Identified the Data Source and defined them to build the Data Source Views.
• Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
• Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
• Scheduled the monthly/weekly/daily reports to run automatically. Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.

Environment: MS SQL Server 2008, .NET Framework 3.5, SQL Server Integration Services (SSIS) 2008, SQL Server Reporting Services (SSRS) 2008, T-SQL, Erwin Data modeler, MS Office, Windows Vista.

Confidential, Atlanta

SQL Server Developer/BI Developer

Responsibilities:

• Developed T-SQL Queries and procedures for processing business logic in the database.
• Used SSIS, building high performance data integration solutions, including extraction, transformation, and load (ETL) packages for data warehousing.
• Involved in Creation of Dimensions using Star and Snowflake Schema.
• Scheduled the SSIS packages and Jobs.
• Used Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server which covers database Integrity Checks, Update Database Statistics and Re-indexing.
• Transformation Services, Crystal Reports.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
• Identifying, extracting, manipulating, transforming, validating and modeling data across multiple domains within an Oracle environment.
• Developed VBA automations to provide business users with self-service recurring reports and dashboards.
• Data Transfers between various servers using BCP and Managing Disk space on NT systems.
• Designed different kinds of Transactions for the application.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Extensive testing on the performance of the stored procedures.

Environment: SQL Server 2008 R2, Transact-SQL, Excel, Windows 2000 Server.

Confidential

SQL Developer

Responsibilities:

• Used highly complex TSQL queries and SQL Scripts to perform efficient data load based on complex business rules and produced results for users.
• Involved in logical & physical design, development and testing of the system.
• Developed complex T-SQLcode for the application.
• Worked as adeveloperin creating complex Stored Procedures, triggers, cursors, tables, views and otherSQLjoins and statements for applications.
• DevelopedSQLServer Stored procedures to extract data from database.
• Implemented constraints on tables.
• Managed historical data from various heterogeneous data sources like Excel, Fixed Width Flat Files, and Access
• MaintainedSQLScript for creation of Database Objects.