SUMMARY:

• Over 9+ years of experience in Data warehousing and Business Intelligence technologies along with around 3 years of data visualization using Tableau.
• Hands on experience on Tableau Desktop versions 9.x/10.x and Tableau Server
• Expert on Tableau reports, dashboards and publishing to the end users for executive level Business Decision.
• Expert on maintaining and managing Tableau reports and dashboards.
• Experienced in managing users, groups, sites, permissions and roles on Tableau server.
• Extensive experience in creating SQL Server projects using SQL Azure, MS SQL Server 2008/2008R 2/2012/2014/2016 .
• Extensive experience with Agile and Scrum Work Environments with Pair Programming.
• Experience in T - SQL coding (DDL, DML and DCL) and the MSBI Suite of products SSIS and SSRS.
• Involved in designing relational database model and physical implementation as per business requirement.
• Expert in data warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles using Normalization and De-Normalization techniques.
• Huge Data transfers from & to SQL Server Databases using SSIS packages.
• Proficient in Performance Tuning/Query optimization using indexes.
• Experienced in whole cycle of SQL Server Integration Services Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL purposes across different servers.
• Expert level skills in Objects creation such as Tables, Views, Table Normalization, Indexes, Stored Procedures and Triggers using T-SQL.
• Involved in heavy stored procedures coding, creating SQL scripts for data loads and upgrades for Data Migrations and Data Validations.
• Experienced in creating Package Configurations and Logging Using SSIS. Excellent knowledge of using Variables and Expressions in packages of SSIS.
• Experienced in sorting the data, defining subtotals for reports and designing report layout.
• Created ad-hoc reports.
• Designed and developed stored procedures, queries and views necessary to support SSRS reports.
• Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.
• Created large enterprise drill down and drill through reports, sub reports using charts, report parameters, dropdowns and images using SSRS.
• Deployed SSRS reports in report server.
• Experience using SVN Tortoise and GitHub as code repository tools and also familiar with Pivotal Tracker, JIRA, etc.,
• Self-knowledge in Amazon web services resources like EC2, S3, EBS, Glacier, AWS Code Deploy, Cloud Watch, Cloud Formation, SNS, Redshift, IAM, RDS, Route53 etc..
• Excellent Verbal & Written Communication skills and strong in Documentation.
• Self-motivated, diligent with the ability to quickly adapt to new environments and changes.

TECHNICAL SKILLS:

SQL Server Tools: Microsoft Visual Studio, Management Studio, SQL Profiler, DTS, SSIS, SSRS and SSAS

Reporting Tools: SSRS, Power BI and Tableau

Language: C, C++, T-SQL, ASP.NET, JAVA

Operating Systems: Windows XP, Windows 7 and UNIX/Linux

Databases: MS-SQL Server 2008/2008R 2/2012/2014/2016, Teradata, Oracle, Informix, DB2, Azure SQL

Microsoft Cloud: Azure SQL database, Azure storage, PowerShell

SDLC: Agile, Scrum and Waterfall

Front End Tools: MS Office, MS Project, MS Outlook, Microsoft Share point

Testing Tools: HP Quality Center, ALM, Jira, DevTest, Rational Functional Tester and Bugzilla

PROFESSIONAL EXPERIENCE:

Confidential,Atlanta,GA

Sr. BI Developer

• Followed Agile and Scrum Methodology to implement user stories.
• Implemented highest priority features first, by asking the customer to choose the smallest feature that makes the most business sense.
• Participated in daily standups and weekly Retrospectives.
• Dynamically supported business users for given requirements and developed the reports accordingly in Tableau.
• Used LOD and Data blending for various work sheets, dashboards and visualizations in tableau.
• Designed and deployed rich visualizations with Drill Down and Drop down menu option and Parameters using Tableau.
• Scheduled extract refresh for weekly and monthly reports.
• Worked on workbook Permissions, Ownerships and User filters.
• Designed and developed standard reports, cross-tab reports.
• Worked on Power BI Dashboard to make some changes on behalf of Business requirements.
• Created various reports like Tabular reports and Matrix reports in Power BI.
• Migrated data from and to various sources SQL server 2016, flat file, excel and Json files.
• Developed pipelines in Azure data factories to extract data from Microsoft Big data Platform (Cosmos) and SQL Server.
• Build ETL’s to extract data from Microsoft Big Data platform (Cosmos), Flat files and SQL Sources.
• Created ETL’s to take data from various source systems (including COSMOS) and import into Azure Storage Blob, SQL Databases and Azure SQL Data Warehouse.
• Extensively used SSIS transformations such as Lookup, Derived column, Aggregate, Conditional split, SQL task and Send Mail task etc.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Worked on different methods of error handling and logging in SSIS.

Environment: Tableau, Power BI desktop, SQL Server 2016, SQL Server Management Studio, SSIS, T-SQL, Microsoft Visual Studio, Windows Server, Pivotal Tracker, SQL Azure database, Azure SQL datawarehouse.

Confidential,Atlanta,GA

Sr. BI Developer

• Followed Agile and Scrum Methodology to implement user stories.
• Implemented highest priority features first, by asking the customer to choose the smallest feature that makes the most business sense.
• Organized daily + Δ to identify the team daily road blocks.
• Participated in weekly Retrospectives.
• Rotated the pairs every week to share and learn code knowledge across the team.
• Worked as an ETL developer for creating an intermediate reporting database for business teams to move their reports from an existing legacy “Mincron” system to a sql server database.
• Worked on creating tables and views for the data loaded from several different source systems (like, Oracle, DB2, Teradata and some legacy flat file sources)
• Involved in meetings with business to determine the different ways to load data and, if any further transformations need to apply on the columns.
• Developed source validation data set views, by building a dataset, with data from two or more systems.
• Developed complexed Store procedures, and created Tables, Views, including indexing and SQL joins for various applications in Supply chain business team.
• Scheduled SSIS packages and store procedures using SQL Server Agent Jobs while supporting nightly job runs.
• Involved in optimizing code and improving efficiency in databases including indexing, recompiling stored procedures and performing other maintenance tasks.
• Developed Tableau work sheets and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Converted existing SSRS reports into tableau dashboards.
• Hands on experience in building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
• Involved in trouble shooting of performance issues which were associated with Tableau reports.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.
• Did POC in Power BI desktop for multiple reports.

Environment: Tableau, Power BI desktop, SQL Server 2016, SQL Server Management Studio, SSIS, Teradata, Oracle, DB2, T-SQL, Microsoft Visual Studio, Windows Server, Pivotal Tracker.

Confidential,Atlanta,GA

Sr. BI Developer

• Followed XP Methodology to implement user stories.
• Executed Bi-weekly IPM meetings to determine the scope of the next release by combining business priorities and technical estimates.
• Implemented highest priority features first, by asking the customer to choose the smallest feature that makes the most business sense.
• Continuously refactor the code while developing new features.
• Participated in weekly Retrospectives.
• Rotated the pairs every week to share and learn code knowledge across the team.
• Worked on creating tables and views loaded from several different source systems (like, Oracle, DB2, Teradata and some legacy flat file sources)
• Developed complexed Store procs, and created Tables, Views, including indexing and SQL joins for various applications for Supply chain business team.
• Scheduled SSIS packages and store procedures using SQL Server Agent Jobs while supporting nightly job runs.
• Created multiple reports in SSRS and sub-reports using drill down/drill-through mode.
• Created workbooks and dashboards in tableau.

Environment: Tableau, SQL Server 2014, SQL Server Management Studio, SSIS, SSRS, Teradata, Oracle, DB2, T-SQL, Microsoft Visual Studio, Windows Server, SharePoint, Pivotal Tracker.

Confidential,Atlanta GA

Sr. SQL Server Developer

• Attended daily stand up meetings to know the status of user stories.
• Participated in brain storming sessions.
• Participated in weekly demos and weekly retrospectives.
• Created SSIS packages with complex transformations to move data from different source systems to SQL server.
• Used aggregation, conditional split and derived column transformations to create SSIS package.
• Experience in Microsoft Visual C# in script component of SSIS.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Developed stored procedures, triggers, views, cursors using T-SQL.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Loaded the data into SQL server data base using bulk import and export features.
• Involved in optimizing code and improving efficiency in databases and performing other maintenance tasks.
• Developed, monitored and deployed SSIS packages.
• Created configuration files to deploy the SSIS packages across all environments.

Environment: SQL Server 2012, SSIS, OLTP, OLAP, T-SQL, Informix, DB2, Windows Server, Jira

Confidential,Columbus,OH

SQL Server Developer

• Actively participated in gathering of User Requirement and System Specification.
• Created new database logical and physical design to fit new business requirement and implemented new design into Oracle data base.
• Successfully migrated old data from legacy system into Oracle using SSIS Packages.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Documentation of all the processes involved in maintaining the database for future reference.
• Actively participated in User Acceptance Testing, and debugging of the system.
• Developed Store procedure and Triggers in T-SQL.
• Worked with SSIS. 50 packages are transferred to some flat file and some to the Oracle from SQL server.
• Created user defined functions and common table expressions.
• Worked with Oracle DBA to create database objects like Table, View, Roles and Indexes in Oracle.
• Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer.
• Fine tuned database objects and server to ensure efficient data retrieval.
• Reviewed and fine tuned stored procedures and triggers before production migration.

Environment: SQL Server 2012, SSIS (SQL Server Integration Services), Business Intelligent Studio, Enterprise Manager, Oracle 10i, Excel, Windows server, HP ALM.

Confidential

SQL Server Developer

• Installed and Configured SQL Server 2012 successfully
• Actively participated in gathering of User Requirement and System Specification.
• Created new database logical and physical design to fit new business requirement and implemented new design into SQL server data base.
• Involved in ER diagrams (logical design) and mapping the data into database objects
• Actively involved in Normalization (3NF) & De-normalization of database
• Login and User Management: Adding logins, roles, groups to MS SQL Server and maintaining proper security procedures.
• Scheduled Jobs and Alerts using SQL Server Agent
• Worked closely on database tuning, performance planning, backup planning and database administration
• Capacity planning in estimating and sizing of tables
• Coded Triggers and Stored Procedures
• Created SSIS Packages using SSIS Designer to populate data into Tables.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers

Environment: SQL Server 2012 Enterprise Edition, T-SQL, Enterprise manager, SSIS, Quality Center.

Confidential

SQL Server Developer

• Created new database logical and physical design to fit new business requirement and implemented new design into SQL server data base.
• Installed and Configured SQL Server 2008R2 successfully
• Participated in gathering of User Requirement and System Specification.
• Worked closely on database tuning, performance planning, backup planning and database administration
• Capacity planning in estimating and sizing of tables.
• Created SSIS Packages using different transformations to populate data into Tables.
• Created Database Objects - Tables, Indexes, Views, Stored Procedures and User defined functions according to the requirements of the project.
• Performance tuning to optimize SQL queries using query analyzer.
• Optimized query performance by creating indexes.
• Wrote complex T-SQL queries for retrieval of data.
• Configured, deployed and monitored SSIS packages.

Environment: Windows XP, MS SQL Server 2008R2, SSIS, Java, Quality Center.

Confidential

ETL Developer

• Actively participated in gathering of User Requirement and System Specification.
• Responsible for SQL server installation
• Cretaed Data base and objects like Tables, Views, Indexes, Triggers, Stored Procedures.
• Created complex quiries for data transformation using business logic.
• Created SSIS packages with error handling using control and dataflow elements.
• Scheduled SSIS packages and Jobs.

Environment: Windows XP, MS SQL Server 2008, SSIS, Quality Center.