SUMMARY:

• Knowledge of complete software development life cycle ( SDLC ) including Requirement Analysis, Requirement, Gathering, Design, Development, Implementation and Testing and Development experience.
• Expertise in writing T - SQL queries, Involved in Transformation and Loading ( SSIS ), reporting services ( SSRS ) for creating different types of reports and analysis services ( SSAS ) for design and developing complex cubes also Proficient in Resolving Complex Issues and Error Handling in SQL queries, SSRS and SSIS. Experience of developing reports using Tableau.
• Develop a deep understanding of specific area of the business and the key metrics that drive performance query data to analyze, monitor and investigate trends.
• Knowledge of working as Data Analyst, Data Governance, Data Lineage, Metadata, Data Auditing and overall data quality management also on Data Migration.
• Well versed with the knowledge of RDBMS, EDW, OLTP & OLAP systems.
• Strong ETL data validation/Testing developed using SSIS/ETL environments also developed and designed ETL Test Cases, scenarios and scripts to ensure quality data ware house/ BI applications. Strong experience on T-SQL Bulk Insert and Bulk Copy program.
• Expertise in creating indexed views, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation to maintain data consistency.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, strong troubleshooting and problem-solving skills. Strong ability to prioritize multiple tasks. Excellent communication skills, proactive, self-managing and teamwork spirits. Participated in AGILE iterative development methodology.

TECHNICAL SKILLS:

DBMS/RDBMS: MS-SQL Server 2016,2012,2008R2

ETL: SQL Server Integration Services (SSIS), SQL Server Import/Export wizard

Report Tools: SQL Server Reporting Services (SSRS), Tableau, Power View

Data Modeling: SQL Server Analysis Services (SSAS)

Languages: T-SQL, XML, C#

Operating System’s: Windows server 2013/2008/XP/Vista, Windows 7/8

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio

Office Tools: MS Word, PowerPoint, Excel, Visio

PROFESSIONAL EXPERIENCE:

Confidential, Richardson, TX

Data Analyst / Tableau Developer

Responsibilities:

• Assist in pulling data from multiple databases, compile data into one readable format and move into an internal client tool. Searching for irregularities on the data, auditing data to ensure quality and correctness, then report any data issues to clients and work to provide feedback on the solution. Reporting and analytical help to dissect and resolve the issue(s).
• Performed the process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, informing conclusions, and supporting decision-making. Test and validate database views and other work products created by the data team.
• Writing complex T-SQL queries, Utilizing Tableau reports and Utilized different MS Excel Functions like transfer knowledge of data, Find and Replace, Concatenation, Filter and Sort, If Error, Logical Functions, Conditional Formatting, remove duplicates, creating Macros and pivot tables for data analysis.
• Single point of contact between clients, data scientists and data engineers to support data libraries to a higher maturity level.
• Performed data exploration using Tableau report Prep to identify and document any issues with the data. Identified all the transformations requirements to be performed for every data load so that it can be absorbed by Tableau.
• Strong knowledge on Tableau Develop, Design and Support Interactive Tableau dashboards

Environment: MS SQL Server 2016, Tableau, Teradata, MS Word/Excel/PowerPoint, AGILE.

Confidential, Plano, TX

SQL Developer /Data Analyst

Responsibilities:

• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Defaults and complex T-SQL queries including T-SQL Bulk Insert and Bulk Copy Program. Creating Tableau dashboard reports, working with developers, creating business intelligence reports and visualizations.
• Strong knowledge on Tableau Develop, Design and Support Interactive Tableau dashboards .
• Performed the process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.
• Involved in the team that migrate the data from Teradata and SQL Server to snowflake.
• Experience in writing Teradata SQL Scripts for loading data to a hierarchical data model.
• Strong experience in Creating Database Objects such as Tables, Views, Functions, Stored Procedures, Indexes, Triggers, Cursors in Teradata.
• Created Metadata, created Data Lineage and overall Data Quality Management. Performed data validation by utilizing Python and experience on Data Governance,
• Troubleshooting and Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and utilizing SQL Profiling, execution plan, database engine tuning advisor.

Environment: MS SQL Server 2016, SNOWFLAKE, Tableau, Teradata, Python, AGILE.

Confidential

SQL Developer/Tableau Developer /Data Analyst

Responsibilities:

• Performed the process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.
• Creating Tableau dashboard reports, working with developers, creating business intelligence reports and visualizations.
• Strong knowledge on Tableau Develop, Design and Support Interactive Tableau dashboards .
• Involved in writing complex queries, stored procedures, batch scripts, triggers, functions, joins and views using T-SQL.
• Participated in all phases of the ARCU (Advanced Reporting for Credit Union) -2018 Release. Created multiple custom reports, modified reports, find the bugs and enhanced the performance of the report, Created new reports.
• Created complex ad-hoc reports, sub reports, linked reports, charts, drill through/drilldown reports and created large number of report models for users to create their own reports.
• Worked in Microsoft Reporting Service (SSRS), created new reports and dashboard and troubleshoot the existing reports.
• Implemented SSIS (ETL) to extract and transform data from different RDBMS, flat files.
• Organized Error and Event Handling by giving Precedence Constraints, Break Points, Logging also Created SQL server configurations for SSIS packages
• Performed various Data Transformations using conditional split, data conversion, derived columns and lookups to source data to transfer data in a format as per organization needs.
• Created SSIS Packages to perform filtering operations and automated it to import the data on daily basis from the sources to SQL Server to load the data.

Environment: MS SQL Server 2016, Report builder 2012, Integration Services (SSIS), Reporting services (SSRS), Tableau, Microsoft Excel, AGILE.

Confidential, Carrollton, TX

SQL Developer/ Data Analyst / Tableau Developer

Responsibilities:

• Experience on creating, modifying, troubleshooting and using various complex stored procedure, User defined functions, triggers, Functions, views, Transactions, joins, Cursors, Indexes, T-SQL queries which have utilized for SSRS, SSIS and SSAS.
• Created complex SSIS packages included a variety of transformations/ tasks, Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast and Data Conversion. Strong experience on T-SQL Bulk Insert and Bulk Copy program.
• Extract transform and load (ETL) the data from several data sources to Data Warehouse also responsible for enhancements, maintenance and monitoring of the data warehouse on SQL Server and the perform daily ETL Process.
• Created C# scripts to massaging, scrubbing and cleansing of legacy data in staging area.
• Analyzed Queries and boost the performance necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler. Reduced and obliterated unnecessary joins and indexes.
• Worked in EDW, involving in daily loads (full & incremental) into staging and ODS areas, troubleshooting process, Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel and Access to SQL.
• Worked with users and business analysts to design and develop SSRS reports and dashboards using tabular, matrix, gauges, Chart and drill down reports as well as interactive reports according to business requirements.
• Performed the process of inspecting, cleansing, transforming, and modeling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.
• Creating Tableau dashboard reports, working with developers, creating business intelligence reports and visualizations.

Environment: MS SQL Server 2012, Reporting services (SSRS), Integration Services (SSIS), Microsoft Excel, AGILE.

Confidential, Brookfield, WI

SQL Server /SSIS/SSRS Developer

Responsibilities:

• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statement.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins, created indexes and utilizing SQL Profiling, execution plan, database engine tuning advisor.
• Designed, developed, modified and deployed SSRS reports that include; parameterized reports, snapshot reports cached reports, drill down reports, drill through reports, linked reports, click-through reports, Sub Reports also Processed and generated manual reports for the end business users on a daily, weekly, and monthly basis.
• Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different kinds of transformations like lookup transformations, merge joins, fuzzy look ups, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.
• Designed and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema and snowflake schema.
• Designing a data structure with multiple facts and dimension tables to hold the source data to be used for building new reports with SSRS.
• Worked in EDW, involving in daily loads (full & incremental) into staging and ODS areas, troubleshooting process, Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, Excel and Access to SQL.

Environment: MS SQL Server 2012/2008, Reporting services (SSRS), Integration Services (SSIS), Analysis Services (SSAS), T-SQL, MS Excel, AGILE.