PROFESSIONAL SUMMARY:

• Over 9 years of extensive experience in Database Solutions and BI Solutions using Microsoft Technologies
• Extensive experience in Design, Development, Implementation of Database systems using MSSQL 2000/2005/2008 R2/2012/2014 for OLTP systems and Microsoft BI for OLAP systems.
• Experience in database programming in writing T - SQL Stored procedures, Triggers, Constraints (Primary Key, Foreign Key, Unique) Indexes and Batch Scripts using various DDL and DML commands.
• Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS.
• Strong analytical, presentation, problem solving and inter-personal communication skills and excellent adaptability to new technologies
• Organizing meeting with the SME’s of the dependent systems when changes are done for the existing system.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities
• Experience in integration of various data sources like SQL Server, Oracle, DB2 UDB EEE and Flat Files.
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle and DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, and BCP & Bulk Insert utilities.
• Experience in conversion of packages from legacy systems (DTS to SSIS) and migrating, deploying the packages across Dev/UAT/Prod environments.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Experienced in building MDX queries and DMX (Data Mining Expression) queries for Analysis Services & Reporting Services.
• Expertise in generating reports using SQL Server Reporting Services and MS Excel spreadsheets.
• Experienced in developing reports on SSAS & SSRS on SQL Server ( 2000/20 ). Sound Experience and understanding of SSAS, OLAP cube and Architecture
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2005/2008/2012/2014 ), use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting services.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Excellent skills in Designing and Development of applications using SQL, PL/SQL, Oracle Database 8i/ 9i/10g,11i, Oracle Forms 6i/9i & Reports 6i/9i, Developer 2000.
• Ability to export reports and query results to MS Excel, PDF, HTML, etc.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau
• Deployed the reports and Scheduled Reports for the use of end users and customers
• Technically hands-on commercially experience mainly with full range of BI Skills with Tableau 7x, Tableau Desktop, Tableau Server and Tableau Public.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Excellent analytical/Communication Skills, Team Play and very much result Oriented.

TECHNICAL SKILLS:

MS: DOS, Windows 95/98/NT 4.0/XP/2000/2003 Server/Vista/7, Unix, Solaris 9/10, Red Hat Linux Enterprise 4/5

RDBM/Databases: Microsoft SQL Server 2014/2012/2008/2005, MS-Access 97/2000/2003, Oracle 10g/9i/8i, Sybase Server, SQL, PL/SQL, MS SQL, SQL*Plus, Teradata V2R5, IBM DB2 UDB 8.2/8.0, MS Visual Source Safe 2005.

SQL, T: SQL, PL/SQL Dynamic SQL, MDX, SQL*Plus 3.3/8.0, HTML, XML, DHTML, C, C++,VB Script, Shell Scripting, C# .NET,VB .NET, ASP .NET, ADO .NET, Visual Studio, XML, HTTP, ActiveX, MS Access, Lotus notes.

Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inman Methodologies, MSX, MS Access, MS Project.

Data Design Tools: ER/Studio, ERWIN, MS Visio.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Tableau Desktop 7, 8.1 & 9,Tableau Server 7, 8.1 & 9, Visual Studio, Crystal Reports, Cognos, Hyperion.

Tools: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Tableau, Visual Studio.Net, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS), Crystal Reports 9.0, Pipeline Tools - (Route Load Express, Express Loader, Data Exchange, Risk Analysis) Facility Manager, Facility Maintenance, SQL Server Data Tools.

Version Control And Configurations: Visual SourceSafe 6.0/2005, Serena PVCS, Visual Studio Team Foundation Server (VSTS), Clear Quest, Clarizen, Lotus Notes.

PROFESSIONAL EXPERIENCE:

Confidential - Houston, TX

SQL BI Developer

Responsibilities:

• Involved in Framework development for ETL Implementation and support for the Analytics and Reporting needs for various customers
• Defined business priorities for the user stories by logically analyzing each user story in the perspective of impact on the business so that the most critical issues will be addressed first.
• Development, Enhancements & Implementation of existing SQL Stored Procedure’s based on new requirements.
• Involved in writing Complex Queries, heavy stored procedures, Views, Triggers, Functions using T-SQL
• Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views.
• Worked with developers to design and test extensions to the Oracle Applications, primarily in developing additional reports, alerts, workflow and interfaces.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different types of transformations using SSIS/DTS packages.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints.
• Designed the SSIS packages using various control flow tasks such as Execute SQL Task, Data Flow Task, Sequence Container.
• Deployed Packages to File System and SQL Server and scheduled them using SQL Server Agent.
• Used various control flow tasks like Execute SQL Task, Execute Process Task, File System Task, Data Flow Task etc. and also used containers like For Loop, For Each and Sequence Containers and Transformations such as Fuzzy Lookup, Merge etc.
• Improved data load performance by analyzing database design and query plans.
• Designed, developed and deployed new reports and enhancements to existing Reports, for various applications as assigned using SSRS 2008/2008 R2.
• Created reports for daily, weekly, monthly reports for Business Users for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand information.
• Creating and maintaining various subscriptions in the Report Manager for the reports.
• Created Schedules and Extracted the data into Tableau Data Engine.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Environment: SQL Server 2012/2014, Visual Studio, SSDT, Business Intelligence Development Studio (BIDS), MS Office, MS Access, SharePoint, MS Visio, SQL Server Integration Services (SSIS), SSRS, SQL Server Agent, Tableau Desktop 7, 8.1 & 9,Tableau Server 7, 8.1 & 9, TFS, TOAD, Oracle SQL Developer

Confidential - Houston, TX

SQL BI Developer

Responsibilities:

• Worked with various departments customers in interfacing various systems and processes for Data extractions, ETL, Analytics and reporting needs
• Designed and created databases, DB Objects based on the business requirements.
• Involved in creation of new database, planning the location of data, index and transaction log files on the disks.
• Created complex Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements to maintained referential integrity and implemented complex business logic.
• Designed Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Used joins and sub queries to simplify complex queries involving multiple tables.
• Provided technical support to move databases from development to test and production for multiple applications.
• Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).
• Loading the Fact and Dimension tables.
• Querying, creating stored procedures and writing complex queries and T-SQL Joins to address various reporting operations and also random data requests.
• Created Drill-through reports, parameterized reports and linked reports using SSRS and were integrated in the Performance point server.
• Generating various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using SQL Server Reporting Services (SSRS) for various in-house users and also for various users
• Created interactive reports for sorting, different parameterized reports which consist of report criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Developing products by determining what competitors are doing, risk assessments, ratings assessments, pricing and coverage.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Involved in User communication for requirement gathering and Change control and code control policies and procedures.
• Involved in creating dashboards and reports in Tableau 7.0.
• Administered user, user groups, and scheduled instances for reports in Tableau. Installed patches on server and documented upgrade plan form Tableau 6.1 to Tableau 7.0
• Created report schedules on Tableau server.
• Created and assisted users in Tableau dashboard development
• Defined best practices for Tableau report development.

Environment: MS SQL Server 2005/2008R2/2012, T-SQL, MS Excel, Windows 2003/2008/XP, Visio, ER Studio, SQL, T-SQL, Data modeling, DTS (Data Transformation Services), SSMS (SQL SERVER Management Studio),SSIS 2008/2012,SSRS, Tableau Server 7.0, Tableau Desktop 7.0,DBArtisan,RapidSQL,Oracle11G,TOAD,PL/SQL

Confidential

SQL DBA/BI Developer

Responsibilities:

• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Creating dashboards for different departments.
• Bulk data migration using SSIS from flat files.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.

Environment: MS SQL Server 2000/2005/2008, T-SQL, MS Excel, Windows 2003/2008/XP, Visio, ER Studio, SQL, T-SQL, Data modeling, IDERA, LiteSpeed, SVN(Tortoise SubVersion), WinMerge, DTS (Data Transformation Services), SSMS (SQL SERVER Management Studio).

Confidential

SQL/SSIS/SSAS/SSRS (BI) Developer

Responsibilities:

• Actively participated in supporting and enhancing logical design of the system to in corporate changing business and user requirements.
• Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones.
• Accomplished the task of converting DTS packages from 2000 to 2005/2008 by using SSIS tasks in SSMS,BIDS and troubleshoot the conversion process
• Involved in database design process and data modeling process using diagrams and Visio.
• Created Joins, Views, Stored Procedures, Functions and Triggers and also scripted Sub Queries using T-SQL involving multiple numbers of tables.
• Studied existing OLTP system(s) and Created Facts, Dimensions and Star Schema representation for the Data Mart.
• Developed SSIS Packages to populate Data Mart from various types of sources files (EXCEL, Access, Flat files, CSVs, OLEDB Sources).
• Handled SSIS packages for Logging, error handling, complex transformations, Deployment and production support.
• Worked on SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints
• Created cubes using respective fact and dimension tables, performed processing and deployed the cubes to SQL server analysis services database.
• Involved in adding KPI’s, Calculated Aggregates, Actions and Partitions.
• Created Ad Hoc reports by building models in Report Builder using SSRS 2005/2008 Model Designer and Report Builder
• Designed various reports using different reporting features such as group by, drilldowns, drill through etc.
• Created parameters (multivalue, hidden, default etc...) for the required fields using the report designer in order to see the dropdowns in the end report.
• Used various types of report layout options like charts (bars, lines, pie etc...), images, graphs, sub reports, hyperlinks etc to make them more attractive and understandable.
• Created Pivot Tables and Pivot Charts in MS Excel.
• Experienced in building MDX queries and DMX (Data Mining Expression) queries for Analysis Services & Reporting Services.
• Reporting OLAP cubes built with Microsoft Analysis Services using SharePoint as a front end tool.

Environment: s: SQL Server 2000/20 R2,T-SQL, BIDS(Business Intelligence Development Studio), Windows2003,SSIS(SQL Server Integration Services), SSRS(SQL Server Reporting Services), SSAS (SQL Server Analysis Services), DTS (Data Transformation Services), Visio, Share point Products and Technologies WSSV3, MDX, DMX, MS Excel, Oracle and TOAD.

Confidential

MS SQL Developer

Responsibilities:

• Designed, implemented and administrated SQL Server 2000 databases.
• Implemented Constraints (Primary Key, Foreign Key, Default, Unique, Check and Not Null/Null) and fine tune Indexes on Tables.
• Create and Modify Stored Procedures, Triggers, Views according to the business.
• Developed various reports to validate the data between source and the target systems.
• Design of ETL processes to transfer customer related data from MS Access, excel to SQL Server.
• Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Experience in Database Backup, Recovery and Disaster Recovery procedures
• Managed the security of the servers (Logins and Users).

Environment: SQL Server 2000, SQL Profiler, Data Transformation Services, and T-SQL.