SUMMARY

• Over 6+ years of IT experience in development, design, support, migration from legacy systems, quality assurance of Enterprise Data Warehousing (EDW) specializing in Oracle and Microsoft SQL Server databases.
• Has experience working in various industries such as Aviation, Healthcare, Financial Services, Publishing, Logistics, and E - Commerce.
• Core SQL skills include Data wrangling, Querying, and Transformation with Microsoft SQL Server and Oracle databases.
• Excellent knowledge in Design, Dimensional modeling, Analytics, Enterprise Dashboard, Key Performance Indicators (KPIs), and Set Analysis, which helps the business reach their goal.
• Created graphically rich, dynamic, user-friendly visualizations using Tableau dashboards that have Bar Charts, Scatterplots, Geographical maps, Gantt charts, Heat Maps, Slicers, Drill-down, and Drill up.
• Developed Calculated fields, Parameter controls, Hierarchy, Groups, Sets, Dashboard actions, Filters, Annotations in Tableau.
• Experience with Master Data Management and Data governance best practices.
• Has experience working in a fast-paced environment that has changing priorities and meet critical deadlines. A good Team player who has good written and verbal communication skills.
• Experience with all phases of the software development life cycle (SDLC) and Agile project methodologies.
• Highly proficient in using T- SQL to develop complex stored procedures, triggers, user functions, user profiles, relational database models and data integrity, SQL joins, and query writing.
• Proficient in Microsoft Business Intelligence technologies like SQL Server Reporting Services (SSRS), Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS).
• Hands-on experience in performing various SSIS data transformation tasks like Data conversion, Derived Column, Lookup, Fuzzy Lookup, Conditional Split
• Experienced in performing Incremental Loads and Data cleaning using SSIS.
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, System, and User-defined Variables for SSIS Packages.
• Designed, Developed, and Maintained ETL Artifact, Data Dictionary, Business Rules, and data mapping and performed data profiling using SSIS and SQL Queries.
• Experienced in extraction & migration of data from heterogeneous data sources like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using import/export Wizard, DTS/SSIS, and Bulk Insert utilities.
• Experienced working in OLTP and OLAP System Study, developing Database Schemas in relational and dimensional modeling.
• Extensive experience in the development of Reports using SQL Server 2016/2012/2008 R2/2008/2005 Reporting Services (SSRS) and Microsoft Access and developed Custom Reports and different types of Tabular Reports, Matrix Reports, drill-down reports, and scorecards in multiple formats using multidimensional objects.
• Created various SSRS Reports involving a variety of features like Charts, Filters, Sub-Reports, Drill Down, Drill-Through, Multi-valued parameters, and also understanding of the Tablix control
• Experienced in creating Ad-hoc reports, Drill Through reports using Local and Global Variables, Expressions and Filters, Data-driven subscription reports by using Report Builder.
• Knowledge in query optimization & performance tuning, Using SQL Server Profiler, Execution Plan, Performance Monitor, and DBCC Commands.
• Experienced working on Team Foundation Server and SVN version control tools.

TECHNICAL SKILLS

Databases: SQL Server (2005/2008/2008 R2/2012), Oracle 8i/9i, Oracle 10g/9i DB2, Postgre SQL, MS Access.

Database Tools: MS SQL Server (2005/2008/2008 R2/2012), MS-Access, SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Reporting Services (SSRS)

Development skills: T-SQL, PL/SQL, SSIS/SSRS, SQL PLUS, Tableau 10, Python, SPSS, Java, JavaScript

Languages: R, Python, C#, VB.net

BI Tools: Tableau, SQL Server Reporting Services (2008/2012), SQL Server Integration Services (SSIS 2008/2012), SQL Server Analytical Services (SSAS 2008), BIDS, IBM Watson Analytics, Google Analytics, Pivot, Power Pivot

ETL Tools: SSIS (SQL Server Integration Services), WhereScape Red

Reporting Packages: Tableau, SQL Server Reporting Services, MS Excel.

Tools: /Methodologies: MS Project, SQL Profiler, Toad, TFS 2010, Agile, Jira, Waterfall.

Operating Systems: Windows XP, Windows 7, Windows 8, Win 2003/2008/2008 R2, Linux

PROFESSIONAL EXPERIENCE

SQL/BI/ Tableau Developer

Confidential, Teterboro, NJ

Responsibilities:

• Working on Legacy System (Mainframe/DB2) to SAP Migration project using SAP GUI and SAP Modeler by creating s/4 Hana views to extract data from SAP to SQL server.
• Implemented data migration solution from the Legacy Access database to modern SQL Server DataMart.
• Extensively work on construction and design of data architectures, data modeling, and database design for dimension and fact tables in SQL server 2016.
• Work closely with the implementation team to gather the functional requirement and create a GAP analysis document for Mainframe/DB2 and SAP S/4 HANA.
• Create in-depth BI-Mapping and Data Dictionary documents using Tableau Designer, current data sources, and their transformation to map with SAP source data.
• Extensively use WhereScape Red for data warehousing automation to bring data from SAP S4/ Hana into the SQL server using the ELT technique.
• Design various ETL architectures using SSIS to load data from multiple data sources (Oracle, MySQL, DB2/IDMS, Excel, XML, Flat Files, S4/Hana) into target SQL DB.
• Extensively used TOAD for Oracle to analyze complex Business Object Universe data for Spares project to integrate new data into existing dimensions to drill down information for Warranty, Technical, Commercial, Aircraft Article, and Data Control.
• Work on day to day Ad-hoc reporting using complex SQL queries for data analysis using advanced SQL, CTE's, DML, and DDL.
• Developed Tableau dashboards that have Bar Charts, Scatterplots, Geographical maps, Gantt charts, Heat Maps, Slicers, Drill down, Drill up. Advanced Analysis, Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's
• Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server T- SQL stored procedures within SQL Server 2016 environment.
• Developed a data dictionary, mapping documents, business rules, and ETL artifacts by reversing the existing Access database.
• Database management and monitoring, Performance Tuning, and Solution design, both on Oracle Database 11g, 12c, and SQL servers 2012/2014/2016.
• Developed, deployed, and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Created complex Stored Procedures, User Defined functions, Triggers, Indexes, Tables, Views, SQL joins, and defined roles and privileges to implement business rules and control access to the database.
• Created Database Maintenance Plans for the Performance of SQL Server, which covers Database Integrity
• Wrote complex stored procedures to process requirements and generating records between Front End and back end.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data load, transformation, and extraction.
• Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.
• Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Created New Reports by using SSRS
• Established the relationships among the tables in the database by assigning primary keys, Foreign keys, and demonstrated the referential integrity.
• Created complex Stored Procedures, User Defined functions, Triggers, Indexes, Tables, Views, SQL joins, and defined roles and privileges to implement business rules and control access to the database.

Environment: WhereScape RED, T-SQL, MS SQL Server 2016, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Power BI, SQL Server Analysis Services (SSAS), Visual Studio 2017, OLAP, Tableau.

Data Analyst

Confidential

Responsibilities:

• Involved in translating business requirements into technical design specifications.
• Followed the different phases of the Data Warehouse development lifecycle (converting business requirements to logical design and translation to physical format).
• Developed Tableau dashboards, Bar Charts, Scatterplots, Geographical maps, Gantt charts, Heat Maps, Slicers, Drill down, Drill up. Advanced Analysis, Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, set to create a detail level summary report and Dashboard using KPI's.
• Developed T- SQL queries, scripts, and stored procedures for extracting, validating, transforming, and loading clients' data.
• Designed ETL packages to load the data from the staging server to Data marts on the Data warehouse.
• Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Lookup, Fuzzy Lookup, script task as part of ETL.
• Worked with configuring checkpoints, package logging, error logging, and event handling to redirect error rows and fix SSIS errors.
• Based on business requirements, developed Complex SQL Stored Procedures, Views, Triggers using T- SQL to implementing the business rules and transformations.
• Used SSIS to develop ETL jobs to extract, clean, transform, and load data into the data warehouse.
• Developed and tested ETL Packages using SQL Server 2016 Business Intelligence Development tools.
• Expertise in creating Partitions, Design Aggregations, Perspectives, and Cell-Level Security using SSAS.
• Designed ETL packages that utilized tasks and transformations such as Execute SQL Task Execute Process Task Send Mail Task, FTP task, Execute Package task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup, which was used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Performed data cleansing by using validation rules to eliminate dirty data using SSIS.

Environment: SQL Server 2016/2012 SSIS, SSRS, XML, Excel, Share point, Visual Studio 2010, Query Analyzer, SQL Profiler, MS office 2010, Team Foundation Server, Windows 7.

Senior SQL Developer

Confidential

Responsibilities:

• Gathered user requirements, analyzed, and designed software solutions based on the needs.
• Involved in creating Dashboard as needed using Tableau Desktop and Tableau Server.
• Installed and configured Tableau application to support redundancy and high availability.
• End to end experience in designing and deploying data visualizations using Tableau
• The building, publishing customized interactive reports and dashboards, report scheduling using the Tableau server.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Extensively used data blending, embed functionalities in Tableau.
• Created Tableau reports based on existing Excel reports
• Oversee the ETL process from JV, Lever, and in-house application. Ensure data quality and integrity.
• Develop Data Visualization and performance metrics modeling utilizing Tableau and Google Apps
• Working on generating various dashboards in Tableau server using multiple sources such as Teradata.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Effectively used data blending feature in Tableau.
• Executed and tested required queries and reports before publishing.

Environment: MS SQL Server 2008, SSAS 2008, SSRS 2008, SSIS 2008, T- SQL, Tableau, MS Access, Word, Excel, SQL Profiler