PROFESSIONAL SUMMARY:

• 8+ years of experience in IT industry, worked as a Senior Data Analyst having good experience on T - SQL, SQL Server, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services), Tableau,, Pentaho, QlikView HTML, CSS, XML and JScript.
• Experienced in SDLC (Software Development Life Cycle) by following Agile methodology/ Waterfall for gathering requirements, analysis, design, development, testing, debugging and deploying.
• Strong experience with Scrum methodology and well versed in writing user stories.
• Excellent knowledge of Business Intelligence and Data Warehousing with good fundamentals in Databases and Programming.
• Strong experience in Extraction, Transformation and Loading (ETL) in SQL Server database.
• Supported team in resolving SSIS, SSRS, T-SQL and ETL related issues.
• Experience in Dimensional modeling using Star Schema and Snowflake Schema and data analysis to provide Business Intelligence solutions.
• Expertise in writing T-SQL Queries using Joins, Sub queries, stored procedures, functions, triggers for building packages and Performance tuning SSIS packages and SSRS Reports.
• Expert level skills on T-SQL and query optimization and developing ETL strategies using SSIS.
• Extensive experience in architecture design of source table mappings to Extract, Transform, Load data into target environment using ETL Tool - Informatica Power Center.
• Extensive experience in Building, publishing customized interactive reports and dashboards, report scheduling using Tableau Desktop and Tableau Server.
• Experience configuring reports from different data sources using data blending
• Worked on MS SQL Server Query Engine, Execution Plan, Indexing and other performance tuning techniques.
• Strong Knowledge on creating SSIS packages using control flow tasks like Execute SQL Task, FTP, For Loop, For-each-Loop, Execute Package task, etc. and data flow tasks like Derived column, Slowly Changing Dimension, Look up, Conditional Split, OLEDB command, etc. Also, different types of sources and destinations like Oracle source, SQL, Excel, flat file, Raw, etc.
• Experience in SSIS performance tuning on Control flow, Data flow, Error handling, and Event handler, re-running of failed SSIS packages, configuring Checkpoints, troubleshooting, debugging the data flow by using Data viewers, awareness on Transactions concepts to roll back the data of SSIS packages in case of failure.
• Implementing Logging features to the existing packages to track the record counts, package status by storing it in logging DB tables with their associated column values.
• Familiar with Complex Reporting Requirements like Dashboard, Matrix, Cascading Summary, Sub reports and pass through parameters from main report to the sub reports.
• Strong knowledge in creating subscriptions on reporting services like Data Driven Subscriptions (DDS) and Static Subscriptions and enabling DDS with dynamic queries for extracting parameter values from database on runtime.
• Participating on Review and Retrospective meetings for sharing ideas to improve productivity.
• Scripting knowledge using C# or VB knowledge to work on script components for ETL purpose by replacing existing transformations or to add an additional functionality for the packages and creating SSAS cube, deploying and browsing the cubes using KPIs.
• Experience in working with multiple RDBMS including Oracle 11i/9i/8i, SQL Server and MS Access
• Working experience in using various Microsoft office products like MS Excel, MS Access, MS Visio and MS PowerPoint to create and reports and templates.
• Excellent communication skills, Client Interaction and sharing knowledge with demos.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX

Databases: MS SQL Server 2005/2008/2008 R 2/2012/2014/2016., MS Office, Visual Studio 2005/2008/2010/2012/2013/2015.

Programming Languages Business Tools: T-SQL, C, C++, C#, VB.Net, SQL, HTML 5, CSS, JScript and XML

Version Control Tools: Word, Excel, Outlook, IBM Symphony, Lotus Notes, JIRA and Clarity.

Database Tools: IBM Rational Clear-Case, SVN repository.

Data Modelling: SQL Server Management Studio.

Reporting Tools: Star Schema, Snow-Flake Schema, Fact, Dimensional

ETL Tools: SQL Reporting Service (SSRS), Tableau, Pentaho and QlikView.

MS Tools: SSIS, Pentaho Data Integration

PROFESSIONAL EXPERIENCE:

Confidential, Texas

Sr. ETL and Tableau Developer

Responsibilities:

• Worked closely with Business Analysts for requirement gathering, designing and creating work flow.
• Interacting with Coordinator/Team for the clarifications on daily calls and updating Status on weekly scrum calls.
• Database development and Data analysis on Stored procedures, Triggers and Functions.
• Developed complex  Tableau Dashboard reports  by gathering requirement on direct interactions with  Business/Operation  teams.
• Created and managed Tableau sites, projects, and workbooks, groups, data views, data sources and data connections
• Established Tableau security, back-up and restore process.
• Maintained and scheduled of Tableau Data Extracts using Tableau Server and the Tableau Command Utility.
• Maintained development process for developing ETL Packages and reports as per the norms like Gathering requirements, Design, Development, Code review, Unit Testing, Peer Review and Review before releasing to QA.
• Designed packages Using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Execute Package Task, File System Task, FTP Task, Script Task, Send Mail Task and Data Flow Task.
• Extracted data from sources and transformed the data using different transformations like data conversion, derived column, look up, Conditional Split, Aggregate, Union all, Row Count and merge join transformations.
• Created Event Handlers for the Packages Using Event Handler Tab for Error Handling and Logging purpose.
• Created Transactions in packages to roll back the whole process in case of package fails.
• Created Configurations to change the package properties dynamically and preparing deployment documents before releasing to production.
• Creating SQL agent jobs after successful development of ETL packages and SQL codes.
• Good T-SQL Programming techniques in query optimization and performance tuning.
• Maintained log information in SQL table for tracking Errors, Counts and recording package execution status by capturing the record counts and Execution processes.
• Used SSRS to create reports, customized Reports, on-demand reports.
• Designed Different Types of reports like Drill Down, Drill Through, Sub Reports, Parameterized Reports, Sort prompts, Cascading parameters reports and Multi Value Parameters.
• Experienced in nested Grouping, sorting columns and writing expressions per the business requirements.
• Developed Report Models and Ad-Hoc Reports using Report Builder. Scheduled Reports by using Static subscriptions either Email delivery or Windows File Share by weekly and Monthly basis as per the Client Requirements.
• Developed SQL scripts to migrate data for legacy systems to SQL server.
• Performed DBA tasks through Enterprise Manager, Query Analyzer, Import Export wizard.

Environment: Tableau Desktop 9.x, Tableau server, Business Intelligence Development Studio, Microsoft Office Excel, C#/VB.net, XML, MS SQL Server 2014/2012/2008 R2, SSIS, SSRS, Query Analyzer, SQL Profiler, Windows Server 2008 Standard and SVN Repository.

Confidential

Tableau Admin/ Tableau Developer

Responsibilities:

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create a detail level summary report and dashboard using KPI's.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Designed dashboard templates as per the requirement and dashboard content which includes complex tabular reports.
• Utilized capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations.
• Involved in migrating client's reports from excel (static) based solution to an interactive service.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Installed Tableau Server 8.0 in Dev, QA, UAT and Prod environments.
• Installed patches on the server and documented upgrade plan from Tableau 8.0 to 8.1
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Created incremental refreshes for data sources on Tableau server.
• Developed report level logic as per the requirement and DB constraints, creating POC for client approvals.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Involved in license management SLA's with Tableau support.
• Worked on scheduling the extracts and setting up the permissions.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.

Environment: Tableau Desktop 8.x, Tableau server / Administrator, Tableau drive, SQL developer, SQL 2012, Oracle 11g, DB2, JavaScript API, Microsoft Excel 2007, MS Access, Windows 2007 server, Microsoft office 2007.

Confidential

Sr SQL Developer

Responsibilities:

• Developed procedures, functions, packages.
• Identified, managed and resolved testing issues promptly, which led the team to achieve and surpass project milestones.
• Ensured that team members created defects that were well documented.
• Using PL/SQL Tables and Records in transaction processing using the Oracle feature Bulk Copy and Bulk Collect.
• Implemented the Case Statement Logic in SQL statements to reduce the PL/SQL code using Oracles 9i feature.
• Extensively used IMP and EXP for data transfer from source systems to the new application.
• Implemented the concept of Clusters to reduce the time of Data retrieval.
• Implemented Materialized view for faster processing.
• Involved in writing Unix Shell scripts for loading data using SQL*Loader. The control files for the tables were created and automated through UNIX shell scripts to perform data load into Oracle.
• Worked with the Clear case to track versions release control, to assign bugs to relevant developers and update status across the lifecycle.
• Analyzed the Design, Development, Testing and Maintenance
• Wrote PL/SQL Stored Procedures, Functions, and Packages.
• Created Database tables with complex constraints applicable to the business rules.
• Performed SQL Tuning within applications for optimized database access.
• Optimized database code using EXPLAIN PLAN
• Created oracle objects (Tables, Views, Indexes)
• Worked on Compiling, troubleshooting and maintaining stored procedures.

Environment: Oracle 9i/10g/11g, Oracle Data Integrator (ODI), Rapid SQL 7.6.4, SQL Server Management Studio 2008, PL/SQL, TOAD, SQL developer, SQL * Loader, SQL, UNIX shell scripting, MS Excel, Tidal Service.

Confidential

ETL & SQL Developer

Responsibilities:

• Analysis of the specifications provided by the client.
• Experienced in SQL joins, SQL stored procedures, views and performance tuning for better running of queries.
• Created Packages by using Data flow task extract data from one or more sources that can be databases, files in the file systems, Excel, transform source data, standardize, cleanse, convert data types, conform, fix data. Load into one or more destinations those SQL server databases.
• Worked on Control Flow Tasks, Containers, Connection Managers, and Created extensively run and SQL Statements for each row in a data flow by using OLEDB Command transformations and applied aggregate function such as Avg, Sum, Min, Max to column values by using Aggregate Transformation
• Designed, Managed and Published various reports using SQL Server Reporting Services 2005
• Created different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items and Sub reports
• Created Cascading (Collapsed), Printable, interacted reports (drill-down and sorting functionality)
• Created and designed reports based on query parameters and Report parameters
• Unit Testing on Reports, Packages and deploying reports and SSIS packages into testing boxes

Environment: .Net Framework3.0, ASP.NET, VB.NET, Business Intelligence Development Studio, Microsoft Office Excel, MS Access, XML, MS SQL Server 2008/2005, SSIS, SSRS, Windows 2003 server.

Confidential

SQL Developer

Responsibilities:

• Worked closely with on-site and offshore teams for requirement gathering, designing workflow.
• Designed packages Using Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Execute Package Task, File System Task, FTP Task, Script Task, Send Mail Task and Data Flow Task.
• Extracted data from sources and transformed the data using different transformations like data conversion, derived column, look up, Conditional Split, Aggregate, Union all, Row Count and merge join transformations.
• Created Event Handlers for the Packages Using Event Handler Tab for Error Handling and Logging purpose and configured error Output for transformations in Data Flow, created event handlers and Provide checkpoints in SSIS packages.
• Created Transactions in packages to roll back the whole process in case of package fails.
• Extensive experienced with trouble shooting, debugging on packages by using Data viewers.
• Created Configurations to change the package properties dynamically.
• As per the requirements reports has been developed in the form of Matrix, Table and Chart using SQL Server 2008 Reporting Services.

Environment: Business Intelligence Development Studio, Microsoft Office Excel, C#/VB.net, XML, MS SQL Server 2010/2008, SSIS, SSRS, Windows 2008 server and IBM Rational Clear-Case.