SUMMARY:

• Extensive experience as SQL Server/SSIS/.NET/ Tableau/HANA/ BODS/ Microsoft Business Intelligence applications developer specialized as an ETL Developer with expertise in HANA views and HANA SQL, Tableau development, SQL Server, SQL Server Integration.
• 11 Years of SQL Serverdevelopment and administration/SSIS experience.
• Proficient in using complex T - SQL/SQL Queries for Analysis.
• Highly proficient in developing and debugging complex stored procedures, triggers, indexes, CTEs, UDFs, user profiles, relational database models, data integrity, SQL joins and query writing.
• Experience in using Activity Monitor, Profiler, Table Hints, Linked Server, OpenQuery.
• Hands on experience on SSRS (MS SQL Reporting Services 2008) and Windows Powershellscripting.
• Experience in SQL Administration activities such as user security, database space management(mdfs and ldfs), Backups and Recovery, HA/DR.
• Developed SQL Server procedures to handle the business requirements for Sales, HR, Finance, Data Center, Customer Analytics and IT.
• Assisted in designing SQL Server framework for bringing in new tables along with data using odbc from Mysql Database to SQL Server Database, using SSIS and SQL Server.
• Experience in developing and maintaining SQL Server Agent Jobs for SSIS packages and SQL Stored Procedures.
• Tableau Experience in Enterprise Environment, as a Developer and Analyst
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts,Bubbles, Histograms, Bullets, Heat maps and Highlight tables
• Tableau experience includes technical support, troubleshooting, report design and monitoring of system usage.
• End to end experience in designing and deploying data visualizations using Tableau
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• More than 2 years of experience on .NET (Asp.NET / VB.NET/ C#.NET).
• High quality experience in creation of HANA information views, procedures and HANA SQL
• Experience in creation of BODS batch jobs, workflows, data flows.
• High quality experience in ETL designing and development using Microsoft Business Intelligence and Tableau.
• Having basic working knowledge of SharePoint.
• Extensive experience in different types of SSRS Reports, Tabular Forms, Matrix cross Tab report form, conditional, List items, Charts and Sub reports.
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services.
• Experience in configuration of Report server and Scheduling in Report manager.
• Good knowledge of SSAS (MS SQL Analytical Services2008).
• Good Understanding in Data Warehouse concepts such as Star Schema, Snowflake Schema, OLTP, OLAP and Multi-dimensional Models for query and analysis.
• Experience in Package Configuration, Logging and Deployment on various Environments.
• Experience as offshore and onsite coordinator
• Experience in Client interaction, Requirements gathering, analysis, Effort Estimation. Code analysis, Design, Code change and testing for the requirements, resolving production issues
• Experience in using version controls such as VSS, Subversion, TFS
• Good knowledge of software engineering concepts, techniques and development methodologies
• Good Analytical and problem solving skills

TECHNICAL SKILLS:

Tools: and Packages: SQL Server Management studio, SSIS, Tableau, HANA, SSRS, SSAS, Business Objects Data Services, DTS, VSS, Hadoop development, Microsoft Visual Source Safe, Crystal Reports and SharePoint, TFS

Relational Databases: SQL Server 2012/2008R 2/2008/2005/2000, MS Access, Oracle and MySQL

Languages: T-SQL, PL/SQL, PowerShell, VB.Net, ASP.Net and C#.NET

Operating Systems: Windows 98/NT/2000/XP, Windows Server 2003/2008, UNIX, LINUX

Web Technologies: REST Services, Web Services, JavaScript, JSON, HTML, XML, XSL and Ajax

PROFESSIONAL EXPERIENCE:

Confidential, Santa Clara, CA

SSIS, SQL Server, BODS, Tableau, HANA

Responsibilities:

• Migrated various database objects from SQL Server to HANA.Tableau reports are delivered on top of the existing SQL Server tables as well as on the created HANA calculation views.
• Interacting with business stakeholders to understand their decision making parameters, analyzing the available data to build Tableau dashboards and managing the delivery.
• Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project &business stakeholders throughout the project life cycle.
• Mainly dealt with sales and networking team to analyze the sales which lead to the increase and decreasein the sales region by region.
• GeneratedTableaudashboards with combination charts for clear understanding.
• Created the calculated fields, quick filters, parameters, sets and context filters on existing filters.
• Developed List, Cross Tab, Chart and Drill Through Reports
• Have written .NET code in SSIS Script task using odbc.
• Have worked on logging the above process of extraction in a log file.
• Scheduling the SSIS packages using SQL Server agent
• Have developed the same mechanism of using odbc to load tables to SAP HANA from Mysql as poc.
• Developed SSIS packages and SQL Procedures to load excel data to SQL Server on top of which reporting is done.
• Have written PowerShell scripts and scheduled windows tasks to download excel attachments from an email and load the data into SQL Server.
• DBA activities such as monitoring SQL Server DB, backups, space management, resource utilization etc.
• Have used Activity monitor and have written SQL Scripts to manage SQL jobs and check for failures.
• Have written code in SSIS script task to design HTML based reports (record counts) which are sent as email body and attachment.
• Have written SQL to monitor space of different SQL Server Databases and email when the space falls below certain threshold.
• Developed various HANA calculation views, Attribute views and Analytical views.
• Developed HANA procedures and functions.
• Developed HANA views based on graphical as well as SQL script.
• Dealt with various possible bottlenecks that arise while migrating Database tables and views from SQL Server to HANA.
• Worked on building BODS jobs to load data from cloud source to HANA and SQL Server.
• Developed various Packages with Exception Handling and explicit Transaction Mechanism.
• Configured variables and used the variables throughout SSIS project
• Developed reports based on the data migrated and according to the client requirement
• Has involved in writing the SQL server stored procedures, views, triggers and queries
• Involved in Unit testing, Assembly testing and bug fixing in SSIS packages
• Monitoring SQL Server for space issues, monitoring SQL Agent Jobs and minor Database Administration tasks like restore, backup etc.
• Have written scripts to automate the restore of .dmp files to Postgres, then to SQL Server using linked Server.
• Have created SQL agent Jobs to take differential and full backups.
• Have managed security, users and logins in SQL Server.

Environment: SQL Server 2012, SSIS, Tableau Desktop 9.0/8.2, HANA, BODS, Powershell, Postgres.

Confidential, CA

BI/ETL Consultant

Responsibilities:

• Developed various SSIS Packages using Framework based on the requirements and functionality.
• Developed Tableau visualizations to support ad-hoc analyses.
• Created Tableau worksheet and dashboards which involves Schema Import Implementing the business logic by customization.
• Created and assisted users in Tableau dashboard development.
• Developed Packages which reads all the customers data based on the REST response.
• Developed various Packages with Exception Handling and explicit Transaction Mechanism.
• Configured variables and used the variables throughout SSIS project.
• Event handlers are developed to generate the stage, insert, update, error, ignore count of records in the report. Frame work will generate the migration staging report.
• Involved in Unit testing, Assembly testing and bug fixing in SSIS packages.
• Designed and developed reports such asDrill down, Drill Through

Environment: SQL Server,Tableau7/8, SSIS, SSRS, SAP HANA and BODS

Confidential

Sr. Software Engineer (MSBI)

Responsibilities:

• Development of packages according to the ETL specifications for the staging area & Warehouse data loading using SQL Server Integration Services.
• Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, Conditional Split, Pivot, Union and Execute SQL Task to load data into Database.
• Implementing slowly changing dimensions to maintaining Historical data in required dimension table.
• Written the Stored Procedures and functions.
• Involved in the performance Tuning.
• Unit tested the packages.
• Creating Logging to manage the packages and Scheduling ETL packages from SQL server agent Jobs.

Environment: SQL server2005/2008, SSISand VSS

Confidential

Software Engineer, SQL Server, .NET

Responsibilities:

• Has worked on oracle 10g database concepts and handled the coding part using vb.net using Ajax toolkit.

Environment: Asp .Net2005, Oracle 10g, VSS

Confidential, Memphis, TN

Software Engineer, SQL Server, .NET

Responsibilities:

• Interacting with the client in gathering requirements. Handled the database designing. Has done coding in asp.net with vb.net as coding language using Ajax.

Environment: Asp. Net2005; SQL Server 2000, VSS