PROFESSIONAL SUMMARY:

• Over 8+ years of IT experience in Database Design and Development on Microsoft SQL Server 2008/2005/2000. Sound knowledge of software development life cycle (SDLC) with substantial experience with object oriented analysis and design methodologies. Possess experience in independently handling design, development, documentation and testing phases in a project environment.
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Working in Healthcare industry to create custom SSRS reports and ETL Applications to read the data from QNXT Database and loaded data to QNXT Database.
• 4 years of experience as Tableau developer and worked with different clients.
• Extensive experience in Tableau Desktop, Tableau Server in various versions of Tableau 6, Tableau 7, Tableau 8.1 and Tableau 9.2
• Proficient in Microsoft BI Tools and Tableauto generate reports and dashboards.
• Experienced with Tabular Models to speed up analysis life cycle based on different data volumes.
• Had experience in Tableau Design, Installation, Configuration, Maintenance.
• High degree of proficiency in gathering user specifications from business users and preparing detailed Business Requirement Documents (BRD’s).
• Experience of Relational Database Management systems (RDBMS) and Database design issues like normalization and de - normalization.
• Extensive experience with T-SQL, Functions, Views. Created complicated SQL procedures to meet the requirements of the systems being developed.
• Experienced in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Developed complex stored procedures and Queries for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Implemented cursors for rebuilding indexes.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in building Data Integration and Workflow Solutions for data warehousing using SQL Server Integration Service (SSIS).
• Highly skilled in creating dynamic and customized packages for ETL from various data sources using SSIS.
• Expertise in designing Data Flow task, Work Flow task and designed various SSIS Transformations like OLEDB Command, Conditional Split, Aggregate, Multicast and Derived Column.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix Reports, Tabular Reports, Charts/Graphs using SSRS in Business intelligence development studio (BIDS).
• Experience in writing Expressions in SSRS and Expert in fine tuning the reports.
• Experience in design and implement processes for deploying, managing and extracting data for reporting using SQL Reporting Services SSRS.
• Knowledge of SQL Server solutions including Log shipping, database mirroring, Replication and clustering.
• Thorough Software Development life cycle (SDLC) experience including development, designing, analysis, coding, testing and implementation
• Managed all database servers in development, staging, test and production environments.
• Delivered BI reporting solutions in Power BI, Reporting Services (SSRS) and Tableau
• Worked with internal enterprise architects and consultants, assisting in the development of current and target state enterprise data architectures.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and also worked in a technically challenging environment.

PROFESSIONAL EXPERIENCE:

Confidential, CA

Tableau/BI Developer

Responsibilities:

• Extensively worked on T-SQL for creating stored procedures, indexes and functions
• Implemented custom SSRS Reports to Internal operation team by reading data from the QNXT Database.
• Added new users and applied roles in the QNXT UI in the Development and UAT Environments.
• Created Reporting interface for Customer service team by reading the data from QNXT Claim, Claim Detail tables.
• Implemented ETL Application to load Claim Payment information to QNXT Financial tables and provided access to financial team by creating custom roles in the security management.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database
• Responsible for all the Tableau and PowerBI changes
• Ad Hoc BI Reporting using Tableau and data visualization in Tableau.
• Created Dashboards using Power BI and linked them to SSRS Reports.
• Tableau data visualization and reporting for asset location, cost, and performance.
• Designed Enterprise reports using SQL Server Reporting Services (SSRS 2008) which make use of multiple value selection in parameters pick list, cascading prompts, drill thru reports, drill down reports, matrix reports and other features of reporting service.
• Created Hive queries that helped market analysts spot emerging trends by comparing fresh data with EDW tables and historical metrics.
• Enabled speedy reviews and first mover advantages by using Oozie to automate data loading into the Hadoop Distributed File System and PIG to pre-process the data.
• Worked on SSRS 2008 to generate about 30+ reports for various user groups and developer groups .
• Managed and reviewed Hadoop log files.
• Tested raw data and executed performance scripts.
• Shared responsibility for administration of Hadoop, Hive and Pig.
• Deployed all the reports to reporting server, Excel & PDF.
• Developed Charts, Pie-Charts, Bar-graphs, series on SSRS
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML file) and then loaded the data into destination tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for designing the SSIS packages to export data of flat file source to SQL Server Database
• Involved in enhancement of existing SSIS packages.
• Good knowledge in deploying SSIS packages to various environments.
• Implemented in unit testing and created unit test document
• Supported system testing and helped the testing team in execution of SSIS Jobs.
• Used various control flow tasks like FTP, Bulk insert task, Conditional Split, Multicast, Merge task and different data flow tasks.
• Provided many supporting documentation for the project.

Environment: MS-SQL Server 2008/R2 Management studio, T-SQL, MS Excel, Windows-7, SSIS, SSRS, SSAS, Tableau, Power BI.

Confidential , Atlanta

Sr. SQL Server Developer/ SSIS/SSRS

Responsibilities:

• Creating and modifying Business Intelligence analytical reports using Tableau.
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing executive management to view current and past performance sales trends at various geographic locations
• Creating and managing schema objects such as tables, views, indexes, stored procedures and triggers and maintaining referential integrity.
• Creating different types of user-defined functions using T-SQL.
• Implementing error handling in SQL Server 2012 using the THROW function.
• Developing Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Generating several types of drill down and drill through reports using SSRS
• Developing complex SSRS reports using multiple data providers, global variables, expressions, user-defined objects, aggregate-aware objects, charts, and synchronized queries.
• Run Hadoop streaming jobs to process terabytes of XML data.
• Developed ETL framework using Python and Hive (including daily runs, error handling, and logging) to glean useful data and improve vendor negotiations.
• Create visualizations and reports for the business intelligence team, using Tableau
• Designing and implementing parameterized and cascading-parameterized reports using SSRS.
• Deploying reports, creating report schedules and subscriptions. Managing and securing reports using SSRS.
• Migrating SSRS Reports from SQL Server 2008 to SQL Server 2012.
• Building ad-hoc reports using SQL Server Reporting Services (SSRS).
• Worked on Business Intelligence standardization to create database layers with user-friendly views in SQL that can be used for development of various Tableau reports/ dashboards.
• ETL, data profiling, data quality and clean ups for SSIS packages.
• Developing C# scripting for packages using Script task.
• Creating SSIS packages to populate data from various data sources.
• Creating packages using SSIS for data extraction from flat files, Excel files and OLE DB to SQL Server.
• Configuring SSIS packages using Package Configuration Wizard to allow packages to run in different environments.
• Worked with Metadata-Driven SSIS Packages to pull the data from different sources and loaded them to the DataMart.
• Worked with project teams for upgrading SQL Server 2008 to SQL Server 2012.
• Backing up, Restoring system and other databases as per requirements.
• Scheduled those backups.
• Involved in fine tuning queries and stored procedures using SQL Profiler and Execution Plan in SQL Server.

Environment: s: MS SQL Server 2008/2012, Team Foundation Server, Microsoft Visual Studio 2008/2010, Microsoft SharePoint Server(MOSS 2007), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), T-SQL, Tableau Desktop 9.0/8.3, Tableau Server

Confidential, Atlanta

SQL Developer

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, and Functions.
• Managed index statistics, Tables, Views, cursors and optimized queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Done Performance tuning to optimize SQL queries using query analyzer and DMV.
• Tested to optimize the procedures and triggers to be used in production.
• Involved in project planning, scheduling for database module with project managers.
• Responsible for creating the reports based on the requirements using SSRS 2005.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed and deployed SSIS packages.
• Provided application support. Developed and tested Windows command files and SQL Server queries for Production database monitoring in 24/7 support.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Performed backup/restore of database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.
• Responsible for automation of maintenance jobs, locks and indexes configurations.
• Administered SQL Server security, SQL Server automatic e-mail notification.
• Managed SQL user logins, database user accounts, server roles, database roles and its permissions. Handled dead lock scenarios.
• Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.

Environment: MS SQL Server 2005/2000/7.0, DTS, Windows 2003, SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS), SQL Server Query Analyzer, Erwin, FTP Communication, MS-Visual Studio, UNIX.

Confidential

Junior SQL Server Developer

Responsibilities:

• Involved in various phases of Software Development Life Cycle (SDLC) and developed use Case diagrams,
• Object Diagrams, Class Diagrams, and Sequence diagrams to represent the detail design phase using Rational Rose
• Implement high availability through database mirroring and Merge Replication.
• Configured Log Shipping between Primary and Secondary servers.
• Created database, tables, Indexes and views.
• Created linked server between SQL servers.
• Dropped and recreated the indexes on tables for performance improvements.
• Designed DTS packages to refresh data on Development and QA/Staging.
• Wrote dynamic stored proc to create Database Roles and grant permission to roles and adding logins to specified roles.
• Involved in writing T-SQL Programming for implement Stored Procedures and Functions for different tasks.

Environment: Microsoft SQL Server 2000, Windows XP, Rational Rose.