SUMMARY:

• Hands - on Tableau Dashboard/ SQL Developer with cloud computing knowledge, excellent at juggling multiple tasks and working under pressure.
• As a BI Architect consultant, I have vast experience in developing a Databases from all phases of software life cycle starting from building Business Case, Requirement Analysis, conducting Impact Analysis, Designing, develop data marts & testing application for overall functionalities. Also provided subject matter expertise to build application in Healthcare, Telecom and Insurance domains.
• Worked as a Data Intake liaison for various countries, supplying cleaned to member countries, Confidential Head Quarters using Heterogeneous data (formats include flat file, CSV, XML, Unstructured data inputs etc.) received from different sources.
• 15+ years of experience in Database Development, Implementation, Maintenance and Support on RDBMS application running on SQL Server 2000 to 2008R2, 2014.
• Have 7+ years of experience in analyzing, Design, Developing, publishing Dashboards, reports using Tableau desktop (10.4 current version).
• Extensive knowledge in Tableau features like Hierarchies, Calculated fields, Sets, Groups, Parameters and Tableau advanced functions such as LOD (Level of details) functions, FIXED, EXCLUDE, INCLUDE & Table calculations such as Rank, Index, Percent of total, Difference, Percent difference & Moving average etc.
• Have strong knowledge different type of Tableau filters such as Dataset filters, Context filters, Quick filter, Filter actions and Analytics features such as Trending using scatter plots, Forecasting, IQR features of Box plots and Histogram using bins.
• Developed dashboard using Bar graph, Pie charts, Maps (filled & symbol), Dual & Shared Axis, Box & whisker plots, Scatter plots & Heat maps etc.
• Good knowledge Tableau data manipulation using JOINS, UNION, multiple Data sources blending features and assisted team in performance tuning of dashboards using tuning options and data extraction and packaged workbook features. Involved in data cleaning using split, merge, pivot options & Data interpreter functionality.
• 4+ Years of hands on Experience as SQL SERVER DBA, which includes Performance Tuning, Query Optimization, Database Model Design and Analysis, Database Job Scheduling, Troubleshooting and Debugging, creating DDL, DML and T-SQL
• Experience in Database Development such as Creation of Databases, Tables, Views, Stored Procedures, Dynamic SQL, Triggers, Functions, XML, SQLCMD.
• Experience in Application Development, Data Modeling, Data Migration, Data Conversion and Interface & good exposure to the entire Software Development Life Cycle (SDLC).
• Expertise in developing and designing reports in SSRS using matrix and tabular design and reports using excel with direct connections to db. BIDS, experience in SSIS to perform ETL
• Involved in Performance Tuning, Monitoring and Optimization of T-SQL blocks in both Development and Production environment for SQL server database.

TECHNICAL SKILLS:

Reporting Tools: Tableau Desktop 7.0 to 10.4, & Tableau Server 10.4.0, SSRS, Power BI

Databases: IBM DB2, MS SQL Server 2000 to 2008R2, 2014, DB2, MS Access

ETL Tools: SQL Server 2000- DTS / SQL Server 2005/2008 - SSIS, BIDS, Visual Studio

Data management: Team leadership

Languages: SQL, PL/SQL, MySQL

Operating Systems: Windows NT, 2000/2008/2012 , 2014 UNIX, Mainframe (COBOL, JCL, VSAM, CICS)

AWS: Amazon Web Services, Strong verbal communication, Self-motivated

WORK HISTORY:

Tableau BI Developer

Confidential, Washington, DC

Responsibilities:

• Involved in consolidating immunization and surveillance data collected from the countries through Confidential /UNICEF JRF; cased based surveillance systems such SISVPD and NUVI
• Involved in analysis of Key Performance Indicators (KPI’s) from two main information systems: Procurement (ADPICS) and Finances (FRM).
• As part of the Development team, Design and develop innovative dashboard (like Vaccine Coverage Dashboard, Country Profile, Morbidity & Mortality etc.), Measles Rubella Performance Indicators, analytics, and reports using Tableau
• Developed a database to store and retrieve data from Joint reporting form (JRF) excel data and defined indicators based project requirements and created scripts, tables and views to access all set of indicators i.e. Coverage data, morbidity, immunization schedule, population, financing and program management indicators; and creating reports from the different JRF tables
• Perform data/systems analysis to determine best BI solution (reports, dashboards, scorecards, data cubes, etc.) using Tableau
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic
• Combined Tableau visualizations into Interactive Dashboards using filter actions, highlight actions etc., and published them to the web.
• Developed various data connections from data source to Tableau Desktop for report and dashboard development
• Developed SSIS packages using various transformations such as Conditional Split, Fuzzy Look Ups, Aggregations, and Multicasting.
• Involved in project planning, scheduling for database module with project managers.
• Created new Data source and replaced with existed Data source. Assisted team in scheduling and refreshing extracted data into Tableau Data Engine.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Effectively used data blending feature in tableau. Defined best practices for Tableau report development.
• Developed dashboards and worksheets by blending multiple data sources such as Sql Server and excel data.
• As a SQL Server DB Developer: Involved in all phases (SDLC) of this project from planning, requirement gathering, design, develop, test and implementation.
• Participated in design and analyze of business requirements and integrate all data on vaccine preventable diseases from various sources into FGL/IM Centralized database with different type of file format such as SQL server outputs, Excel and CSV files.
• Developed automated procedures to extract, transform and load (ETL) data from all required sources from countries to regional centralized database by disease using SSIS packages.
• Creating and maintaining databases, tables, views, users, logins, Indexes, check constraints, and business rules using T-SQL and responsible for performance tuning the queries, stored procedures and tables by creating indexes on the tables.
• Writing complex SQL queries using Joins, Sub queries and Functions in T-SQL to retrieve data from multiple tables using T-SQL and developed stored procedures for both backend and frontend applications.
• Involved in generating Daily/Weekly Sales & Finance trending reports using Tableau by identifying the dimensions, measures, measure values & level of details for Business Analytics & Top Executives to give an overview current Trend in Confidential purchase for member countries.

Environment: Tableau 10.4, 10.5 Desktop, MS SQL Server 2008R2/2014, SSIS, SSRS, SSAS

Sr. Sql Server Developer / DBA

Confidential, Silver Spring, MD

Responsibilities:

• Involved in writing dynamic User Stored Procedures to publish fallout metrics report in front end scripted using .NET framework/Java for user analysis and report generations.
• Worked in importing and data cleaning of data from various sources like DB2, Oracle, flat files onto SQL Server 2005 with high volume data.
• Worked Extensively with SSIS to import, export and transform (ETL) the data between the linked servers & upgrading DTS to SSIS & designed DTS Packages for importing and exporting data during migration and conversion.
• Involved in development and debugging of complex batch Transact SQL Procedures and functions.
• Developed and implemented Replication architecture to replicate data across multiple sites.
• Developed Custom Selection of reports ordering using SQL Server Reporting Services (SSRS) & wrote several stored procedures to handle large amount of data manipulation.
• Worked with the SQL Developers, to create logical and physical database design.
• Experienced with installing SQL Fail over clustering for 2 different production servers and recovering the SQL Server in Disaster recovery.
• Involved in improving SQL Server using windows performance monitor to improve the server performance and database performance using database tuning methods, also performed Query Optimizations and performance tuning for the stored procedures.
• Worked on database capacity planning and gave advice to procure system hardware.
• Created the backup schedule for production, test and development servers.
• Involved in restore operations for client requests, restore production databases and data refresh between the environments.
• Documented installation of SQL Server, Fail over cluster, service packs and security fix.
• Maintaining the backup-restore jobs schedules, code promotions and server maintenance in a real-time production and Stage environment.
• Experienced with securing SQL Server, user administration and assign the permission.
• Worked in team environment and participated in on call rotation schedule for production servers.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, T-SQL, .NET, VSS

Confidential

Associate Software Engineer

Responsibilities:

• To facilitate the monitoring of Confidential performance by providing random samples of recent customer service events captured from Confidential 's operational computer systems to external market research contractors.
• To provides information from the Confidential Data Warehouse ( Confidential ). It offers the user access to a number of databases including the FLEXCAB account level databases, the service level databases, the product level databases and MOBILES account level databases, the service level databases
• Responsibilities: Wrote Stored Procedures to handle complex calculations and wrote logic to maintain the history of entities which was also passed on to the application via Stored Procedures.
• Explored the use of User Defined Functions to encapsulate commonly used logic in the stored proc and maximized the readability of such Stored Procedures.
• Performance tuning of SQL queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using DTS and also used BCP and Bulk Insert.
• Involved in developing and designing reports in SSRS and ETL in SSIS.
• Defined Database Maintenance Plan, which was scheduled as job, which ran automatically.
• Handled development and production support, document reviews, test plan, integration of the system.
• Documented all processes and Data Flow involved in the database for future reference.
• Involved in Support & Maintenance of 9 Application & solving dockets as per SLA.

Environment: Mainframe, DB2, MS SQL Server 2000/2005, SSIS, UNIX, Windows 2000, MS Access 2000.