SUMMARY

• Over 8 years of extensive work experience as a SQL Server Developer and in depth proficient experience in OLTP, Operational Data Source (ODS), and Dimension Modeling, Performance Tuning, Data warehouse, OLAP and Database technologies.
• Experience in design, development, coding and testing of business and commercial applications in MSSQL Server 2014/2012/2008 R2/2008/2005, MS Access, .NET Script, Windows 2000/2003/2008.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• Over 5 years of extensive experience in T - SQL Programming in developing Stored Procedures, Views, Triggers, User defined functions, cursors, derived tables, common table expressions (CTEs) XML and Complex Queries on SQL Server 2000/2005/2008/2012/2014.
• Experience with Data Marts, Data warehousing, OLAP, Star Schema Modeling, Snow-Flake Modeling, facts, dimensions, partitions, Tables using MS Analysis Services 2014/2012/ 2008/2005.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Over 3 years of Strongexperience in SSRSdevelopment skills, experience including Tablix, Matrix, chart, graphic score card reports, sub-reports.
• Over 2 years of experience with Tableau Desktop and server. Hands on experience in development of Reports and Dashboard in Tableau.
• Experience in Tableau report developing, testing and deploying reporting solutions using Tableau Server 7.0/8.0/8.1.
• Over 4 years of experience in utilizing ETL tools, including SSIS, DTS and Data Stage and ETL Package design.
• Experience in extracting and transforming data using Import/Export wizard, Bulk Insert, Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Excellent in High Level Design of ETL SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Execute SQL Task, Data Flow Task and union all.
• Experience in some basic development of coding in VB.NET, C# while working with SSIS.
• Expert in automating process by creating jobs, and error reporting using Alerts, SQL Mail Agent, FTP,SFTP and SMTP.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Hands on experience creating service broker (RTM) objects in client server environment using sql.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Solid experience in Replication Services, Database mirroring and Log shipping to ensure high availability and up time.
• Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance.
• Exposure in using Team Foundation Server (TFS) as a source control, source repository and project tracking solution.
• Highly motivated, committed and a natural team player with capability to work independently, Strong analytical ability coupled with excellent written and verbal communication skills
• Experience in UAT/QA design/development and execution.

TECHNICAL SKILLS

Databases: MS SQL server 7.0/2000/2005/2008/2012 , Oracle, Teradata, MS Access

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

Languages: Transact- SQL, SQL,HTML, XHTML, C, XML,.NET frame work

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS.

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports, Tableau.

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler.

Data Modeling Tools: Erwin tool, Microsoft Visio 2000/2003

PROFESSIONAL EXPERIENCE

Confidential, Phoenix,AZ

SQL Developer

Responsibilities:

• Involved in full project life cycle - from analysis to production implementation and support with emphasis on identifying the source and source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data into Business intelligence database.
• Wrote complex T-SQL queries/Views to match data which came from different sources. Processed high volume data everyday using SSIS and efficient Stored Procedure.
• Scheduled a job to run the whole process of getting the zipped files from the FTP site and then unzipping, staging, transforming and finally inserting into to the reporting DW tables.
• Designed SQL SSIS Packages to extract data from various data sources such as FTP site, Excel spreadsheet, and flat files into SQL Server 2012 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks. Used Joins, Sub-queries for complex business queries involving multiple tables from different databases.
• Design and develop SSIS packages, stored procedures, configuration files, tables, views, and functions; Implemented best practices to maintain optimal performance.
• Reduced the T-SQL overhead successfully by avoiding unnecessary joins, wildcard syntax & parsing using char index, pad index within the select statement to optimize the query performance.
• Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure completeness of batch processes, scripts and processes.
• Developed complex Stored Procedures to generate various reports for tasks and notify the users involved using SSRS.
• Created multidimensional OLAP cubes and dimensions with SQL Server Analysis Services (SSAS) and queried the data with MDX script.
• Created Named Queries, Named Calculations in the DSV of an OLAP Cube.
• Performed SSAS capabilities like creating data source views, designing dimensions, fact tables, and user defined hierarchies, KPIs, Measure groups, partitions on QA and deploy them on production.
• Developed interactive data visualizations and developed automated processes for updating content used in standardized dashboards in Tableau.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Published Workbooks and Dashboards to the Tableau server.
• Scheduled the Extracts, performed deployment tasks in different environments.
• Performed troubleshooting operations on tableau server.
• Facilitated UAT (Business partners) in the areas of test planning and defect mitigation.
• Document code changes and UAT before deployment to production systems for SOX compliance.
• Managed user access via Active Directory for centralize access control.

Environment: SQL Server 2014, T-SQL, SSIS, SSRS, SSAS, Tableau Desktop 9.x/8.x, Tableau Server 9.x/8.x, UAT, Microsoft Excel.

Confidential, White Plains, NY

MSBI Developer

Responsibilities:

• Creating data blending in case of merging two different datasets using tableau.
• Modeled all the dashboards with appropriate filters for comprehensive analysis by portfolio, application and employee roles, timestamps and location
• Published Workbooks by creating user filters so dat only appropriate teams could view it.
• Created functional requirement specifications and supporting documents for business systems. Experience in database design process and data modeling process for Billing Method using Erwin.
• Created custom date time calculations and macros in the reports.
• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
• ScheduledComplex Stored Proceduresusing SQL Server Agent.
• Monitored and modified Performance using execution plans and Index tuning.
• Involved in project planning, also schedule for database module with project managers.
• Responsible for writingT-SQLcode for creatingcursor and handling data validations.
• Designed and Developed Database Objects like Tables,Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for the project.
• Developed, tested and implementedReferential Integrity rulesand regulations through constraints, triggers and views, partitioned views.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Created SSIS Packages user data from the Flat files on monthly and weekly basis.
• Created Database objects - views, and functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Defined constraints, rules and defaults and developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Based on the requirements created Functional design documents and Technical design specification documents for ETL Process.
• Designed, developed Informatica mappings, enabling the extract, transport and loading of the data into target tables.
• Created Workflow, Worklets and Tasks to schedule the loads at required frequency using Workflow Manager.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Created complex mappings using Aggregator, Expression, Joiner transformations.
• Designed and developed process to handle high volumes of data and high volumes of data loading in a given load intervals.
• Created views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
• Assisted and supported issues related to the queries and database systems.
• Involved in rebuilding the indexes at regular intervals for better performance.
• Designed SSIS packages to load data from different sources Text files, Excel to staging and staging to Data warehouse.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status
• Created datasets, data source and involved in deploying the reports in to the report server.
• Created SSIS packages using script task by C#.
• Created reports using SQL Server 2005(SSRS) and integrated into the web front end.
• Involved in generating Matrix reports, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Created Drill reports which give all the details of various transactions like closed transactions, pending approvals, and summary of transactions and scheduled dis report to run on quarterly basis using SSRS (Reporting services).
• Worked on Performance tuning, and optimization of procedures and queries.
• Created ad-hoc queries from SQL Server databases for custom reporting needs. Worked on querying data and creating on-demand reports using Report Builder in SSRS.
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Expertise in Developing and Extending SSAS Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake Schema

Environment: SQL Server 2005, T-SQL, SSIS, SSRS, SSAS, Informatica 9.1, Tableau, Tableau Server 8.0/8.1, VB.NET, ADO.NET, Microsoft Excel, Microsoft PowerPoint.

Confidential, Albany, NY

SQL Developer

Responsibilities:

• Used Informatica Workflow Manager to create, schedule, execute and monitor sessions, work lets and workflows.
• Created new mappings according to business rules to extract data from different sources, transform and load target databases.
• Debugged the failed mappings and fixed them.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• Defects were tracked, reviewed and analyzed.
• Modified the mappings according to the new changes and implemented the persistent cache in several mappings for better performance.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and Load the Data from various Databases and into Siemens servers using SQL Server Integration Services (SSIS).
• Used Script task component and established iterative load for faster retrieval & to improve performance.
• Used different transformations like lookup, condition split, and row count Transformation, Derived Column, Data Conversion etc.
• Written T-SQL Stored Procedures and queries for accessing Data from Teradata Database.
• Used advance features of T-SQL to design and tune T-SQL to interface with the databases and other applications in the most efficient manner.
• Created Stored Procedures for package Initialization and end package information to update the package log table.
• Prepared technical documentation for every stored procedure and updated those stored procedures with new data elements.
• Designed & Developed Type 2 Slowly Changing Dimensions in order to maintain the historical changes for the business purposes.
• Worked on the Existing (legacy) SSIS packages and modified the same packages to match it for different sources for integration.
• Experience in managing and automating control flow, data flow, events and logging programmatically using Microsoft .NET framework for SSIS packages
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Advanced extensible reporting skills using SQL Server 2014/2012 Reporting Services (SSRS).
• Developed Drill Down, Drill through, Cross tab reports, Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2014/2012.
• Consulted on Tableau server performance enhancements; upgrades from version 8.0 to 8.1.5 and server reconfiguration based on workbook complexity and data extraction.
• Customized the Tableau landing page with site listing as icons and descriptions
• Constructed the reports page for internal strategy group with standardized custom right and left side sections within Tableau

Environment: Microsoft SQL Server 2014/2012, SSIS, SSRS, Informatica 9.1, Tableau, Tableau server, Crystal Reports, SQL Server Report server, Visual Studio 2010, SSMS (Sql Server Management Studio),T- SQL, Oracle 10g,Windows 7,Siebel,SAP, .NET Framework, C#2008, Erwin.

Confidential, Chicago, IL

SSIS /SSRS/TSQL Developer

Responsibilities:

• Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.
• Worked on the Reports module of the project as a developer on MS SQL Server 2008/2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Worked on SSIS Script component using Visual Basic Applications, VB.NET and C#.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and Migration with SQL server Export Utility.
• Use DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Created Dashboards and reporting services web parts using Moss 2007.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Data Migration - Migrated and converted data to be sent across different servers and databases to accomplish database mirroring. dis involved setting up automated Unix Shell Scripts to extract and massage data from Informix and Oracle databases into text files. These text files were then FTP’ed to destination servers where another automated process was executed to load the text files into the desired target tables
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create 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 reports from OLAP, sub reports, bar charts and matrix reports using SSRS
• Wrote stored procedures to get the fields required for the reports.
• Created datasets using stored procedures and reports using multi value parameters
• Created sub reports, bar charts and matrix reports.
• Deployed the SSRS reports in Microsoft office share point portal server MOSS 2007.
• Worked on DTS/SSIS for transferring data from Heterogeneous Database (Access database and xml format data) to SQL Server.
• Created Cubes and used basic MDX to retrieve the result set for Calculations.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.

Environment: SQL Server 2005/2008, T-SQL, SQL Server Integration Services, Tableau 7.0,Tableau server, Crystal reports, VB.NET, ASP.NET, .NETFramework2.0, C#, SQLProfiler, Access 2003, Agile methodologies, Visual Studio 2005, Microsoft office 2007 Visual Team Foundation Server (TFS).

Confidential, Boston, MA

Database Consultant

Responsibilities:

• Created an automated ETL summary report which consists of the summary information for all the loading activities done for day and month
• Created system for capturing, reporting, and correcting error data.
• Provide on-call support to production system to resolve any issues.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Gather requirements and design of data warehouse and data mart entities
• Defined the logging process for all the packages, populated it with entries like inserted record, updated record and error record
• Implemented the lookup transform extensively to populate the unmatched entries to dimension table
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads
• Implemented the error threshold using precedence constraints and variables in SSIS packages using business rules as reference
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 changes.
• Train and manage developers, advising other groups in organization on SSIS development, data warehouse development, and ETL development best practices.
• Extensively worked with SSAS for processing different cubes
• Conduct code walkthroughs and review peer code and documentation.
• Worked on different file formats(fixed width, ragged right and delimited data sets)
• Work with developers, DBAs, and systems support personnel in elevating and automating successful code to production.

Environment: SQL Server 2005, Microsoft Business Intelligence Development Studio, T-SQL, SSIS, SSAS, SSRS, ERWIN

Confidential

SQL Server Developer/DBA

Responsibilities:

• Gatheird requirements to identify and create database objects such as tables, views, triggers and indexes.
• Involved in Normalization of the database and bringing it to 3NF.
• Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.
• Created ER diagrams using Visio.
• Created Views to enforce security and data customization.
• Created Non-Clustered indexes to improve query performance and query optimization.
• Involved in the performance tuning and optimization of T-SQL queries.
• Responsible for Data migration from SQL Server 2000 to SQL Server 2005 Databases.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Developed user requested reports using Crystal Reports and Excel.
• Created Drill down and Drill through reports using Crystal Reports

Environment: SQL Server 2000/2005, Windows XP/2000, Crystal Reports, Excel.