PROFESSIONAL SUMMARY:

• Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers & Cursors
• Development, implementation, administration & support of ETL processes for large - scale Data Warehouses using SSIS 2008 with various control flow, data flow tasks and store procedures for work order validation process
• Migrating SSRS Reports from SQL 2000 to SQL 2005, SQL 2008 R2 & SQL 2016
• Creating and managing fragmentation of Indexes to achieve better query performance
• Good interaction with clients, understanding Business Application, Business Data Flow and Data Relations.
• Strong hands on experience implementing data visualization, and analytics using Tableau desktop and Server
• Team player with good communication and interpersonal skills. Responsible for interacting with business partners to identify information needs and business requirements for reports.
• Ability to handle multiple tasks concurrently and meet the deadlines.
• Experience with Microsoft Power BI, DAX expressions, Power View and Power Query integrated with share point.
• Quick learner, excellent communication skills and good performer both in team and independent job environments. Never missed the deadline of any projects.

TECHNICAL SKILLS:

Languages: T- SQL

Databases: SQL Server / 2010

Analysis/Reporting Tools: SQL Server Reporting Service (SSRS), SQL Server Integrated Service (SSIS), Power BI, Tableau Desktop, Tableau Server

ETL Tools: DTS, SSIS, Data Stage

Other Software: MS Office- 2007/2003/2000

Operating Systems: Windows/ 98/ 2000/ 2003

PROFESSIONAL EXPERIENCE:

Confidential, WA

Tableau / SQL BI Developer

Responsibilities:

• Created Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers
• Wrote efficient stored procedures for the optimal performance of the system
• Designed, developed, and maintained Tableau functional reports based on user requirements.
• Monitored performance and optimized SQL queries for maximum efficiency
• Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop Down menu options and Parameters using Tableau.
• Utilized Tableau server to publish and share the reports with the business users.
• Created indexed views, and appropriate indexes to reduce the running time for complex queries
• Generated custom and parameterized reports using SSRS
• Created many calculated columns and measures using DAX in Power BI based on report requirements.
• Created reports that call sub reports in SSRS
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
• Responsible for creating datasets using T-SQL and stored procedures
• Developed custom reports and deployed them on server using Power BI
• Good Experience in Creating and implementing Mobile dashboards using Power BI.
• Expert in implementing Row level security (RLS) for user authentication in Power BI.
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals
• Used various transformation tasks to create ETL packages for data conversion
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities

Environment: MS SQL Server 2008/2005, Tableau Desktop 9.1.1, Tableau server, SQL Server Reporting Services (SSRS 2008), Business Intelligent Development Studio (BIDS), Power BI, SQL Server Integration Services (SSIS 2008), ETL, Visual Studio 2005, MS Excel.

Confidential, VA

SQL Server BI Developer

Responsibilities:

• Involved in migration from SQL Server 2005 to SQL Server 2008.
• Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI
• Responsible for creating stored-procedures, views, Unique/check constraints and indexes.
• Creating the functions and developing the procedures for implementing the application functionality at the database side for the performance improvement.
• Made project status reports using Excel and Tableau.
• Creating and Modifying the SQL Stored Procedures for validating the integrity of data.
• Provided data verification and tuned queries to define the requirements.
• Designed and developed Tableau Visualization solutions.
• Configured complex queries to meet the customer requirements as needed.
• Migrated data between databases and different servers.
• Created SSIS Packages to get the data from different sources, consolidate and merge into one single source.
• Defined best practices for Tableau report development.
• Designed and developed the packages for extracting the required data, transforming it and then exporting the data.
• Prepared Dashboards using calculations, parameters in Tableau.
• Migrated Tableau projects to Power BI projects for reporting purposes.
• Created ETL package for data conversion using various transformation tasks.
• Created report schedules on Tableau server.
• Created and assisted users in Tableau dashboard development

Environment: Tableau Server 7x, Tableau Desktop 7x, SQL Server 2005 Enterprise Edition, XML, T-SQL, SQL Server 2000, SQL Server 2005, SSIS 2005, SSRS 2005, Windows 2000 Advance Server, Windows 2003 Advance Server, MS Excel, MS Access, Visual Studio 2005, Power BI, Oracle 9i and 10g.

Confidential

SQL Server BI Developer

Responsibilities:

• Involved in developing SQL server T-SQL stored procedures through data layer.
• Developed complex SQL Queries for the application.
• Developed complex stored procedures, views, cursors, and other SQL joins and statements for the application.
• Implemented constraints on the table.
• Created DTS packages to get data from different sources, consolidate and merge into one single source.
• Creating and modifying T-SQL stored procedures for validating the integrity of the data.
• Worked with the data extraction using DTS.
• Implemented complex queries to view the results based on the business requirements.
• Migrated data from the text to the SQL Server.
• Created Views as required for the front-end developers for easier data retrieval on the web pages.
• Created Triggers to enforce data and referential integrity.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success
• Creation/ Maintenance of Indexes for fast and efficient reporting process.

Environment: SQL Server 2000/2005, T-SQL, DTS, MS Excel, MS Access 2000