SUMMARY

• Over 8 years of professional experience in SQL Server database development, Banking(Financials/ Mortgages), Medical Healthcare and Retail sectors as a SQL server Developer that includes Database Design and Development
• Hands on experience with SQL Server and T - SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models, and data integrity.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads.
• Good Knowledge of SQL Server 2012/2008R2/2008.
• Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors and SQL on databases.
• Developed complex SSIS packages using various Tasks, Containers, Data transformations like Fuzzy Lookup, For Each Loop, and for Loop Sequence Container.
• Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Enabled Logging, Database mirroring, Replication for the SSIS (ETL) packages.
• Experience in MS SQL Server configuration, performance tuning, query optimization, back-up and recovery, running Database.
• Knowledge in scripting T-SQL queries, complex stored procedures, User Defined Functions (UDF), Database triggers.
• Experienced in developing database scripts (DML/ DDL), stored procedures, views and other database objects necessary to accomplish project objectives.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Good Knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Hands on experience in designing complex reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Ability in Creating Drill down and Drill through reports with Drop down menu in SSRS.
• Working Experience on Database development for both OLTP (Batch Processing, Online Processing) &OLAP Systems (SSRS, SSIS, and SSAS) using SQL Server 2012/2008R 2/2008/2005.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Developing tools using Access, VBA, and Excel environment.
• Tableau Experience in Enterprise Environment and Tableau Administration.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.
• Expertise in creating Perspectives, Partitions and Design Aggregations in cubes using SSAS.
• Good at creating Dashboard Reports to support end users using SSAS.
• Experience throughout developing OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS and Report Builder 3.0.
• Proficient in building Star schema and Snow Flake schema depending on business requirements.
• Working Experience on Multidimensional Expressions (MDX).
• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation
• Strong in Writing User Manuals, Documentation, Proposals and also Good team player.

TECHNICAL SKILLS

Languages: C, T-SQL, PL/SQL, JavaScript, C#.

RDBMS: SQL Server 2012/2008R 2/2008/2005/2000 , 7.0, MS-Access.

Front End: MS Visual Basics 6.0.

Web Technologies: HTML, XML, JavaScript, PHP, Shell Scripting.

Version Control: Visual Source Safe, Clear Case.

SQL Server Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, Business Intelligence Development Studio, SSIS, SSAS, SSRS, Data Transformation Services.

Data Modeling: Erwin r7.3/7x/4.0, MS Office Visio 2003/2007

Operating System: Windows 2012, Windows Server 2008, Windows 95/98/2000 XP/Vista/7/8, Unix.

Methodologies: Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and Normalization.

PROFESSIONAL EXPERIENCE

Confidential, Phoenix, AZ

SQL BI Developer

Responsibilities:

• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Designing and developing new dynamic SSIS Packages to transfer data between servers, load data into Database and tuning the existing packages by using Visual Studio 2015.
• Set up ETL Jobs to run on a daily basis in SQL Server Agent using SQL Server 2014.
• Created many complex Stored Procedures/Functions and used them in SSRS Reports directly to generate reports on the fly.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS) and performance tuning of Stored Procedures and T-SQL Queries.
• Managed index statistics, Tables, Views, cursors and optimizing queries using execution plan for tuning the database. Implemented different types of constraints on tables.
• Knowledge in design and development of Tableau visualization Solutions.
• Development and assisting users in creating and modifying worksheets and data visualization dashboards by using Tableau 10.1
• Created drill down and drill up in worksheets in Tableau Dashboard.
• Developing Dashboards and preparing ad-hoc Reporting.
• Developed complex SQL queries for creating BI layer on DW for tableau reporting

Environment: Windows 7, Tableau 10.1/ 9.1, MS SQL Server 2014/2012, SSIS, SSRS, T-SQL, SharePoint Portal Server 2010, ETL, MS Office 2010/2013, Visual Studio 2015

Confidential, Rancho Cordova, CA

SQL BI Developer

Responsibilities:

• Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently by using SSRS.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Worked on EDI 835, 837 Inbound and Outbound.
• Developing and maintain EDI training manual and system documentation.
• Working on experience with permissions, Security, User/User group setup.
• Creating Extracts and scheduling them to increase performance of the dashboards.
• Monitoring User activity, server performance and user licensing.
• Designing and development of Metadata Driven SSIS packages for Data Warehouse for Data moving and Summarization in a Reporting Data Mart.
• Developing Data Mapping, Data Governance, Transformation and Cleansing rules for the Master Data Management Architecture involving OLTP, ODS and OLAP
• Designing and developing new dynamic SSIS Packages to transfer data between servers, load data into Database and tuning the existing packages
• Developing highly complex SSIS packages using various Tasks, Containers, Data transformations like Fuzzy Lookup, For Each Loop, and For Loop Sequence Container.
• Creating Database Objects like Tables, Views, Stored Procedures.
• Set up ETL Jobs using SSIS to run on a daily basis in SQL Server Agent.

Confidential, Phoenix, AZ

Sr. SQL Server SSIS/ Report Developer

Responsibilities:

• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Analyzed the source data and handled efficiently by modifying the data types.
• Worked on security configuration, setup of Sites, Workbooks, Views and Data sources in SSRS.
• Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.
• Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.
• Hands on experience with permissions, Security, User/User group setup.
• Creating Extracts and scheduling them to increase performance of the dashboards.
• Developed Word forms using VBA to conduct various surveys in order to optimize monthly report based on team usage.
• Monitoring User activity, server performance and user licensing.
• Designing and development of Metadata Driven SSIS packages for Data Warehouse for Data moving and Summarization in a Reporting Data Mart.
• Designing and Development of ETL Process(SSIS) for integrating data from sources like Excel, CSV, Flat Files, Web Services, XML Source and SQL Server.
• Designing and developed new dynamic SSIS Packages to transfer data between servers, load data into Database and tuning the existing packages
• Created Database Objects like Tables, Views, Stored Procedures.
• Set up ETL Jobs to run on a daily basis in SQL Server Agent.
• Responsible for testing of SQL Code, SSIS Packages using MS SQL Integration Services 2008.
• Responsible for Scheduling and maintaining reporting and SSIS data load Jobs.

Environment: Windows 7, Tableau 8.0/ 8.1, MS SQL Server 2012,2008R2, SSIS, SSRS, T-SQL, SharePoint Portal Server 2010, ETL, MS Office 2010/2013.

Confidential

SQL SSIS/SSRS/SSAS/Support Role

Responsibilities:

• Responsible for ETL operation using SQL Server Integration Services (SSIS) 2008/2008R2/2012 and Worked with users in training and support and also have experience in incremental data loading.
• Managed up gradation of DTS packages to SSIS packages
• Responsible for developing, monitoring and deploying SSIS 2012/2008R2/2008 packages.
• Created many complex Stored Procedures/Functions and used them in SSRS Reports directly to generate reports on the fly.
• Designed and created MDX queries to retrieve data from cubes using SSIS.
• Substantial knowledge throughout Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using SQL Server 2012/2008R2/2008.
• Worked on Active Batch V8. And also SAP CPS and Cognos.
• Created various Weekly and Monthly reports showing detailed information in SSRS.
• Created Cross-Tab, Drill-down, Parameterized and Sub-Reports using Report definition Language (RDL).
• Used DMX to create data-mining models.
• Most of my work with Issue Support Role. And also worked on BMC Remedies.
• Involved in the creation of Data Mart by taking into various business process by identifying different dimensions and facts.
• Used Active Directory for Identity management designed to provide strong authentication and authorization for internal and external websites.
• Efficiently utilized the Merge Join in SSIS and Merge statement to populate the data warehouse from a source database which provides efficient and granular level of control.
• Performed Data profiling tasks In SSIS (ETL) using the Data Profile Viewer and then clean and standardize the data as appropriate for the Databases.

Environment: MS SQL Server 2012/2008R2/2008, SQL SSIS, SQL SSRS, T-SQL, Oracle, Visual Studio 2012,Active Batch, Auto ETL Windows Server 2012, MS Office 2010. SQL Server Management Studio

Confidential, PA

SQL Server/SSAS/SSIS/SSRS Developer

Responsibilities:

• Used the SSIS to migrate databases such as Oracle and SQL Server database, flat files to centralized IT destination.
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2008/2005 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Installed and configured MySQL on Linux and Windows environments.
• Created Queries in T-SQL, Stored Procedures, Clusters and Views to store the data of clients, advisors. Worked with multivalve parameters for parameterized reports in SSRS.
• Developed VBA scripts for periodic P&L (Daily, Weekly) reports using Excel, Access (Reports, Forms).
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functionsandpackages for moving the data from staging area to data mart.
• Created DSV, Cubes, and Dimensions, DMX/MDX for SSAS Reports.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Tabular model by retrieving data and aggregates directly from a relational database system, using Direct Query mode.
• Used IBM Data stage Designer to develop jobs for extracting, cleaning, transforming and loading data into data marts/data warehouse.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Conducted the Error handling in SSIS (ETL) using the Event Handlers.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

Environment: MS SQL Server 2008R2/2008, SQL SSIS, SQL SSRS, T-SQL, Oracle, Visual Studio 2012, .NET(C#, VB), Windows Server 2012, MS Office 2010. SQL Server Management Studio, MS Excel, ERWIN

Confidential, Montgomery, AL

SQL BI Developer

Responsibilities:

• Using SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev., Test and Production Environment and extracted the data using SSIS from OLTP to OLAP.
• Developed PL/SQL triggers, procedures, functions and packages for the various interfaces.
• Generated Adhoc Tableau reports on demand for providers.
• Generated Tableau reports with Trend lines.
• Experience in Handling premium billing, commissions, capitation, and reporting by using Facets.
• Implemented data warehouse design principles and best practices for maintaining dimension and fact tables.
• Generated Parameterized Reports and cascaded Parameterized Reports.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS) and performance tuning of Stored Procedures and T-SQL Queries.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2005 and in adding calculations using MDX.
• Worked on up gradation of Database from SQL Server 2008R2 to 2012.
• 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 2005.
• Developed Report Models for building Ad hoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.

Environment: SQL Server 2005/2008/2008 R2 Enterprise Edition, T-SQL, SSRS, SSIS, SSRS, SSAS, Visual Studio 2005