SUMMARY:

• Over 9+ years of experience as a MS SQL Server Developer working on large - scale enterprise and performance critical applications.
• Strong technical knowledge in MS SQL Server development including DTS, SSIS Strong technical knowledge on SQL SERVER 2005, 2008R2, 2012 and 2014 tools for importing data, data transformation and Export in different destinations.
• Knowledge in constraints, containers, variables, parameters in SSIS and implementing variables in SSIS expressions in control flow and dynamic connection managers.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS)
• Hands on experience in MS SQL Server, Teradata, Oracle and Tableau and Power pivot.
• Extensive experience in creating complex functions, stored Procedures, views and SQL statements for applications using T-SQL, Dynamic SQL and PL/SQL.
• Use Tableau Desktop to analyze and obtain insights into large data sets.
• Create visually compelling and actionable interactive reports and dashboards.
• Possess SQL and programming knowledge to deal with data transformations and translations.
• Created complex SSIS packages to extract data from, MS Access, Oracle and Teradata sources.
• Have 2+ years of Tableau Desktop and Tableau Server experience. Extended experience of Tableau Geographical maps, drill down and drill through Actions.
• Excellent report creation skills using Microsoft Reporting Services (SSRS). Extensively used SQL Server Reporting Services and Report Builder Model to generate custom reports: Designed and created Report templates, bar graphs and pie charts based on the financial data; Wrote queries to generate reports for analysis of data; Used table control, matrix control to create cross tab reports; handled sub reports and defined query for generating drill down reports in SSRS
• Strong knowledge on different Built in transformations as conditional script, Sort, union, Union All, Merge, Merge Join, Row count, data aggregation, Data conversion, derived column, Audit, Cache transform, Lookup and Fuzzy lookup, Data mapping, Fuzzy grouping and others in SSIS.
• Customized SSRS delivery formats for Word, Excel and PDF
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in creating dashboards, scorecards and building reports using performance point server 2007.
• Experience in data warehousing dimensional modeling to define dimensions and fact tables using Star schema and Snowflake schema design.
• Extensively involved in creating attribute hierarchy on cube dimensions, calculation of measures, defining relationships between dimensions and measure group, and creation of KPIs goal/forecast which is dimension dependent.
• Experience with working on ProClarity Analytics server to analyze results produced in the Dashboard.
• SQL Server 2012 OLAP database development including KPIs, Data mining, working with changing dimensions.
• Experience in creating and maintaining security mechanisms for reports, creating repository domains using Business objects Supervisor.
• Thorough understanding of Kimball’s’ theory, KPIs, SQL 2012 Architecture.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.

TECHNICAL SKILLS:

SQL Tools: SSMS, Profiler, Erwin, MS Visio, Export & Import (DTS), MS Access, Toad for Developers, Tableau Business Intelligence/Business Analytics software

Statistical Tools: SPSS, Minitab, Microsoft Excel

Databases: MS-SQL Server 2005/2008/2012/2014, MS Access, My SQL, Oracle, Teradata

BI Tools: SSIS, SSAS, SSRS, Toad, Tableau

Languages: SQL, PL/SQL

Operating System: Windows Server/ Server 2008/server 2012/Professional/ 4.0, Win XP Prof/Standard

PROFESSIONAL EXPERIENCE:

Confidential, Lewisville, TX

SQL Server Developer/BI Developer

Responsibilities:

• Created SSIS jobs for daily, weekly and monthly data loads for Chase mortgage accounts.
• Created many SSIS packages using Import/Export Wizard. Designed many Packages using SSIS Designer by using Control Flow and Data Flow Tasks with ETL Tool.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files.
• Created date and string expressions in SSIS packages and passed them to create dynamic queries for SSIS source SQL commands.
• As part of the ETL process new stored procedures as created using MERGE command for doing insert and updates at the same time and hence increasing performance.
• Created packages using PL/SQL as per the requirement and converted Oracle stored procedures into SQL Server code or SSIS packages for pulling data from Oracle
• Used Microsoft Attunity adapters for Teradata and Oracle for optimal performance.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008 and 2012.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Involved in ETL architecture enhancements to increase the performance using query optimizer
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Created and monitored Control-M jobs for SSIS packages
• Created Database Triggers, bypassing the mutating table errors, use of row and statement level triggers for advanced auditing of changes made to a table
• Created Oracle Functions and Procedures to centralize the business logic in the database..
• Wrote SQL Loader scripts to load data into the SQL Server database from excel spreadsheets.
• Altered the existing scripts to pass the loans, which were previously failing edit checks when submitted to treasury on a daily basis.
• Used views, procedures and functions process staged data and loaded the final tables. Created tables, added columns to existing tables.
• Wrote many adhoc queries for testing the old verses new architecture data to determine if the new system could meet the requirement of minimal loan failure.
• Helped in the enhancements to increase the ease of use and efficiency for the end user depending on the client’s functionality.
• Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.

Confidential, Irving, TX

MS SQL Server/ SSRS /SSIS/SSAS Developer

Responsibilities:

• Involved in creating and resolving critical issues in reports and data for Confidential and other OEMs. These reports include Confidential Subscription Status Report and Confidential Service usage reports and several other internal and external reports.
• 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.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008, 2012 and Flat files, DB2 and Oracle.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008 and 2012.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Involved in ETL architecture enhancements to increase the performance using query optimizer
• Implemented Event Handlers and Error Handling in SSIS packages. Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Developed a Executive level dashboards using Tableau 9.0.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008 and 2012.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements. Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• 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.
• Involved in upgrading from SQL Server 2008 to SQL Server 2012.

Confidential, Plano TX

MS SQL Server/MSBI Developer/Tableau Developer

Responsibilities:

• Created complex Stored Procedures, functions, tables, temp tables, views and using, T-SQL and PL/SQL.
• Created complex SSIS packages to extract data from MS Access, Oracle and Teradata sources using Attunity adapters.
• Extensively used variables and expressions to change values at runtime. Used system and user variables for logging package and task level information and displayed the status in a Java application.
• Used script task to make decisions and count rows in the source flat files before loading to SQL Server.
• Thorough understanding of performance tuning, and optimization of SQL queries. Using parallelism in SSIS and Created and Developed SSIS 2008 and 2012 Packages around the Kimball data warehouse architecture by creating fact and dimensional modeling.
• Created and used SSIS expressions, dynamic SSIS queries, used configurations, Variables, on connections managers and other properties.
• Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Developed SSIS 2012 ETL packages around the Kimball data warehouse architecture by creating fact and dimensional modeling.
• Designed ETL package using the methods for slowly changing dimensions type 1, 2, and 6.
• Created several SSIS packages using advanced transforms, lookups, fuzzy lookups, and script components(c#).
• Created test SQL scripts and provided presentation documentation for review with the business.
• Created an ETL architecture, performed advanced lookups, transformations, created slowly changing dimensions, and execution of stored procedures.
• Developed SSRS 2012 reports and dashboards for Sales solutions by creating custom SQL, parameter driven interface, and a rich user experience with bar charts, gauges, and pie charts.
• Developed dashboards using Tableau for demographic information such as population and allow users to drill into geographical objects such state and county information.
• Created objects in SSAS cubes for demographic and customer information that were accessed by excel pivot table functionality to allow us to slice customer and demographic information.
• Created Tableau reports and Dashboards to present Baystate Health care Patient and provider data. These reports reflected Patient and Provider level performance matrices like Risk Factors, PMPM Costs and Gaps in Care.
• Developed dashboards using Tableau for demographic information such as population and allow users to drill into geographical objects such state and county information using MS Access and SQL Server as Data source.
• Created objects in SSAS cubes for demographic and customer information that were accessed by excel pivot table functionality to allow us to slice customer and demographic information.
• Experienced on Tableau Admin activities, Installation of Tableau Server and Desktop, Granting access and managing extracts.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Created compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• Generated tableau dashboards for sales with forecast and reference lines.
• User Java Script API to customize the views, selects, filters, date and time.
• Generated tableau dashboards with combination charts for clear understanding.

Confidential, Pittsburgh, PA

MS SQL Server/ SSRS /SSIS/SSAS Developer/Tableau Developer

Responsibilities:

• Created complex Stored Procedures, functions, tables, temp tables, views and using T-SQL and PL/SQL.
• Created complex SSIS packages to extract data from Oracle and Teradata sources using Attunity adapters.
• Extensively used variables and expressions to change values at runtime. Used system and user variables for logging package and task level information and displayed the status in a Java application.
• Used script task to make decisions and count rows in the source flat files before loading to SQL Server.
• Thorough understanding of performance tuning, and optimization of SQL queries. Using parallelism in SSIS and decreasing the number of joins in single queries decreased the time from 72 hours to 17 minutes.
• Used SQL Server logging, flat file logging and CDC to track inserts, updates and deletes.
• Performed all aspects of database administration, including data modeling, backups and recovery.
• Extensively created new reports dashboards and modified existing reports using Tableau.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• 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.
• Used excel sheet, flat files, CSV files to generated Tableau ad hoc reports.
• Generated context filters and used performance actions while handling huge volume of data.
• Generated tableau dashboards for sales with forecast and reference lines.
• Generated tableau dashboards with combination charts for clear understanding.
• Excellent report creation skills using Microsoft Reporting Services (SSRS). Extensively used SQL Reporting Services and Report Builder Model to generate custom reports: Designed and created Report templates, bar graphs and pie charts based on the financial data; Wrote queries to generate reports for analysis of data; Used table control, matrix control to create cross tab reports; handled sub reports and defined query for generating drill down reports in SSRS.
• Extensively used T-SQL in creating and altering stored procedures, functions, views, indexes, user profiles, relational Database models, data dictionaries, and data integrity.
• Writing reports using Microsoft Reporting Services (SSRS)
• Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Designed, built and tested SSAS Cubes on SQL Server 2005.
• Created Excel workbooks to enable Cube (SSAS) access for business users.
• Process the cubes (SSAS), partitions as and when required.
• Enhanced performance using optimization techniques: normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
• Worked with development teams in the design of physical databases and in modification.
• Created packages in SSIS with error handling.
• Developed Query for generating drill down reports in SSRS 2008.Prepared AD HOC reports through report builders.
• Worked with different methods of logging in SSIS and advanced data mapping.
• Experience in creating complex SSIS packages using proper control flow and data flow elements.
• Migrated data from Oracle, Teradata, Flat files and Excel in to SQL Server using SSIS Packages.
• Have deployed packages on different servers by configuring it.
• Installed and configured SQL Server 2008/2005 in Test environment with latest service packs and migrated few databases.
• Used System tables, System Stored Procedure, DBCC commands for Database maintenance.
• Implemented computational sensitive queries Stored Procedures.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS Packages.
• Used SSIS Configurations files, parent package configuration, XML and SQL Server Configurations for SSIS packages.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS)
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
• Involved in migration from SQL Server 2000 to SQL Server 2005.
• Actively involved in Normalization (3NF) & De-normalization of database.
• Experience in installation, un-attended deployments, configuration and administration of Windows NT, 2000 and 2003 servers in very large environments.

Environment: MS SQL Server 2008 R2/2008/2005, SQL Server SSAS/SSRS/SSIS, MDX Cubes, OLAP, Microsoft Windows 2003 Advanced Server, ASP.NET, C#, ETL, Enterprise Edition, Microsoft Visual Basic 6.0, SQL OLAP.

Confidential, San Jose, CA

MS BI Developer

Responsibilities:

• Created and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Developed Logical and physical data model using ERWIN and mapped the data into database objects.
• Written different T-SQL scripts for automated execution of the tasks.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Extensively used SSIS to move data from heterogeneous data sources to SQL Server.
• Created jobs, alerts to run SSIS packages periodically. Created the automated processes for the activities such as database backup and SSIS Packages to run sequentially using SQL Server Agent job.
• Created SQL Server Profiler traces & used with Database Tuning Advisor (DTA) for optimum performance of queries.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS)
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Designing of deployment scheme for migrating SSIS package from Development to Test to UAT and Production by using the configuration files
• Scheduled and executed different automated and manual jobs once the package is executed.
• Managed the Clustered environment databases and was fixing the errors when they arose.
• Rebuilding the indexes at regular intervals for better performance.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Written complex stored procedures and functions and integrated it with the front end application.
• Created multi-dimensional cubes with different dimensions and measures in it using SSAS.
• Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.
• Prepaid user manual and technical support manual.

Environment: MS SQL-Server 2008 R2,2005, SQL Diagrams, Erwin, SSRS, SSAS, SSIS, C#, Windows 2003 Server, MS Access, T-SQL, Outlook, DTS.

Confidential, Richardson, TX

MSBI Developer

Responsibilities:

• Analyzing the FTA’s and the business requirements and building logical and physical data models.
• Creating high level design of the ETL process and data mapping.
• Creating three step ETL process to get the files from the server and load the data into database.
• Designing several ETL processes to Load data from Text or Excel Files
• Extensively used T-SQL in constructing User Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL
• Designing of SSIS Packages to get data files from FTP and SFTP Server and decrypting the PGP files, batch processing of incoming data and purging of old files
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created Packages in SSIS with error handling.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Well versed in defining/creating and handling Data Sources, Data Source views and parameterized Reports in SSRS 2005.
• Created Family of stars using dimensional modeling concepts of Degenerated dimension, Fact less fact table, Aggregate fact tables in multidimensional model.
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Worked with different methods of Logging in SSIS.
• Configured SSRS 2008 with MOSS 2007 for directly deploying the report in SharePoint 2007.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2005 to MS SQL 2008 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Created complex Stored Procedures to validate and process the incoming data.
• Generating Validation Reports to notify the client with the invalid data received.
• Used C# to merge multiple XML reports, convert XML to HTML format using XSLT files and sending Validation Report emails.
• Written Power shell scripts to purge files
• Understanding of existing DTS packages and redesigning them into SSIS packages and facilitate batch processing
• Designing of deployment scheme for migrating SSIS package from Development to Test to UAT and Production by using the configuration files
• Scheduling execution of ETL Packages using SQL Server Agent.
• Creating detail design documentation of the packages and creating release notes for each installs.

Environment: SQL Server 2008, Oracle, MS Access, Excel, Windows Server 2008, IIS, Visual Source Safe, Share point Server, Cold Fusion, Net Frame Work, ADO.Net, VB.Net, ASP.Net, XML Parsing, VB6, VB Script, Java Script and C#, SSAS, SSRS, SSIS, MDX Cubes.

Confidential, Irving TX

MS-SQL Server SSRS SSIS BI Developer

Responsibilities:

• Writing stored procedures, triggers, cursors, and views to improve the quality of application, and manage mission-critical information using T-SQL.
• Develop and support reports built with Microsoft Reporting Services on SQL 2005 SSRS.
• Created/developed/maintained the stored procedures, triggers to interpret complex business rules, history data and audit analysis.
• Designed logical/physical data models and defined primary key, foreign key using Erwin tool.
• Scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency checks and index defragmentation
• Ensure that periodic (daily, weekly and monthly) reports are delivered in a timely and accurate fashion using Reporting services SSRS.
• Using Integration Services (SSIS), built high performance Data Integration Solutions, including extraction, transformation and loading (ETL) packages for data warehousing.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Optimized performance and capacity planning of various data transformation processes related to the reports.
• Provided technical support to internal developers and external clients.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Develop and support reports built with Microsoft Reporting Services (SSRS) on SQL 2005.

Environment: SQL Server 2008/2005, SSIS, SSRS, SSAS, MDX, OLAP, DB2, ETL, Visual Studio.NET, Erwin, DB Artisan, Windows NT/2003, UNIX.