Data Tableau

Sandeep Reddy

phone: +1-437-***-****

E-mail: adclcu@r.postjobfree.com

Over 7+ years of IT experience in all phases of Software Development Life Cycle (SDLC) such as planning, analysis, design, implementation, testing of Cloudera, SQL SERVER & SQL Server Business Intelligence Tools - SAS, SSIS, SSRS, Tableau, Crystal Reports in domains like Finance, Banking & Retail

Highlights of Skills

Hands on experience in understanding of Business Requirements, Relational and Dimensional Database Modeling, Data Warehouse designing (Star and Snowflake Schemas), OLTP and OLAP

Worked on cloud integration of Oracle server database into Cloudera using Pyspark – built test cases to ensure data validation on Hive/Impala GUI

Experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SAS Visual Analytics, SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP

Highly proficient in integration of data from different sources like SQL Server, Oracle,SAS, TeraData, Excel and Flat Files into Enterprise Data Warehouse (EDW)

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages and experienced in dynamic integration packages weather deploying with configuration catalog or file type configuring in SSIS 2012

Wide experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations

Experienced in developing and modifying cubes using SAS Data Management and transform to downstream

Experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS) in both Multidimensional and Tabular Versions

Experience in Database Backup, Recovery, investigating and applying necessary SAS Database Service packs, hot fixes and Security Patches

Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio, and Tableau

Experience in designing and developing Drill through and Drill down reports SSRS and Tableau

Extensive experience on Business analysis and Enterprise reporting solutions delivery using Tableau, Crystal Reports, Crystal Enterprise

Expertise in Developing custom Reports, utilizing formulas, setting up parameters for some dynamic reporting, creating sub- Reports, incorporating the use of graphs

Created and maintained numerous Tableau Dashboards including financial and operational Reports.

Highly proficient in use of T-SQL for developing complex stored procedures, indexed views triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing

Worked on various tasks and transformations like Execute SQL Task, conditional split, Script Component, FTP Task, Script Task and Lookup while loading the data into Destination

Experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication

Excellent interpersonal skills and communication skills and ready to take challenges with proven ability

Technical Skills

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Reporting Services. SQL Server Integration Services, SQL Server Analysis Service (SSAS), TOAD, SAS Database Admin

ETL Tool: SQL Server Integration Service (SSIS), SAS

Reporting Tool: SQL Server Reporting Services (SSRS), Crystal Reports, Qlikview, Tableau

Database: MS SQL Server 2005/2008/2012/2014, Oracle, DB2, TeraData, Oracle, Hadoop – Cloudera, SAS

Programming: SQL, T-SQL, PL-SQL, Pyspark, Python

Web Technologies: HTML, DHTML, XML, XSL

Operating Systems: Windows Server 2012, Windows 2008 R2, Advanced Server, Windows XP, Windows Vista, Windows 7, UNIX

Other Tools : MS Office Suite (Microsoft Word, Power Point, MS Visio), ERWIN, Team Foundation Server (TFS), GIT, JIRA, QC

WORK EXPEREINECE – SAS, SPARK, Cloud TABLEAU

Client: Home Equity Bank March 2019 to Current

Role: PySpark, Hadoop – BI Engineer

Project: The Enterprise Data Warehouse was built to implement a centralized the database that collects and organizes and stores data from different operational systems, integrate and historical data for the purpose of end user reporting. The various business patterns can be analyzed using the different business dimensions. The project involves sales data from various channels like Distributors, Websites, and Independent Representatives. The sales data for the products is collected from different databases and placed into a centralized database.

Responsibilities:

Effective use of Agile development process using Scrum Methodologies by daily stand-up meeting, maintain the project dashboard using TFS

Designed database architecture to fetch and ingest data using Pyspark and load it into cloudera Hadoop

Created Pyspark codes and user defined functions to perform Pivot Transformation, Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc

Automated the ETL of data from 3 different databases (Oracle, MySql and Excel) to merge different functional data, validated them through test cases in Hive/Impala GUI for data accuracy

Ensured the effective usage of cloud memory (Hadoop – HDFS) and performance by effective query tuning in Pyspark and triggering automated jobs to balance load

Extensively worked on Setting up the Send Mail task on Start, Complete, and Failure of .dtsx package that includes writing the logic to show up the results in the email to quickly verify the cause of the failure in Cloudera

Designed and executed packages which include direction of data flow, Column Mapping, Data dictionary and Metadata Flat file source and Flat file destination, OLEDB Source and OLEDB Destination using Pyspark

Created package configuration in XML and used to deploy packages into Pyspark environment, Identified

Issues that occur during the package execution by redirecting the rows from source component to error output

Developed various Pyspark user defined functions to refresh process and ongoing daily updates from database to Cloudera and scheduled jobs using Oozie workflows

Implemented triggers and stored procedures and enforced business rules via checks and constraints

To generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse

Created Cloud Maintenance Plans for the Performance of Cloudera, which covers Database Integrity

Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.

Involved in developing, testing, and writing programs and reports in SAS according to specifications as required.

Transferred and Migrated Data from one platform to another to be used for further analysis.

Created Parameterized reports and Linked reports with thorough knowledge of report serving architecture (Table, chart and matrix report) by using Tableau

Designing and Deployment of Business reports in Tableau (showcasing revenue, ARPU and transactional data) to derive insight and drive business decisions

Created and maintained tableau extract files, built worksheets and dashboards to configure drill down and drill through reports

Configured Tableau Actions and Parameters to facilitate business deep dive and corelate data across functions in the organization

Environment: Cloudera Hadoop, Pyspark, Python, SAS,MS SQL Server 2014, T SQL, JIRA, Oracle Server, Tableau

Client: All State Insurance -- SAS/TABLEAU USA July 2017 to March 2019

Role: BI Developer – (ETL – SAS & UI – Tableau)

Project This project consisted mainly on migrating data from different sources into one centralized Microsoft SQL Server Relational Database using SAS to ensure data integrity and avoid duplicates. Data Loading occurred on a regular basis based on documents provided by vendors and information generated by customer claims. This allowed users to analyze the riskier and costly places and create new products to tailor the needs of specific regions and customers.

Responsibilities:

Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.

Develop and analyse KPIs to design fact and dimension data to derive insights that influence business decision making

Created aggregations, grouping, configuration of formulae using SAS modeler/developer

Created algorithms that help in deriving insight from data to understand the Insurance claim correlation using SAS COB and scripting

Created standard user defined procedures in SAS to Automate and streamline the scripting process in ETL and business reporting

Worked in conjunction with business to develop, test and implement new enhancement in BI dashboarding

Documenting steps taken, and proofing/crosschecking results

Written complex queries and stored procedures to fulfill the enhancement requirements of data base migration project.

Performance tuned some of SAS queries and stored procedures using SQL server Profiler.

Designed and developed different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, Drill down reports.

Defined parameters for parameterized reports and implemented cascading of the parameters.

Involved in project planning also schedule for database module with project managers

Designed and implemented the warehouse data model, dimension, fact and summary tables.

Tuned SQL statements (e.g: - Using Indexes) and Stored Procedures.

Visualizing the data available to represent the business views which are used for business review sessions

Updating and calculating the KPIs in Tableau Extracts to avoid delays in performance and enhance efficiency

Environment: MS SQL Server, SAS, Tableau

Client: Whirlpool, U. K July 2016 to April 2017

Role: SAS Developer

Project: The purpose of this project was to test and record the information from various kinds of materials. Extracted data from multiple sources and loaded them into target Data warehouse using SSIS, and generated multiple reports using SAS

Responsibilities

Wrote SAS queries, user defined functions using joins, sub queries and correlated sub queries to retrieve data from the database.

Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.

Created/Updated database objects like tables, views, stored procedures, function, packages.

Created views in SAS to facilitate easy user interface implementation and KPI calculation and graphical representation

Implemented complex business requirement in backend using efficient SAS stored procedures and flexible functions, and facilitated easy implementation to the front-end application

Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.

Worked with Project Manager and IT Analyst to understand business rules and to discuss gap analysis

Generated Drill down, Drill through, Matrix Reports, parameterized reports using SSIS

Involved in table and index partitioning for performance and manageability.

Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.

Helped create process logging and new monitoring tools, integrity reports, and mapping tools.

Involved in setting up SAS logging and scheduling for periodic Backups with backup devices, database maintenance plans and recovery

Environment: MS SQL Server 2012, SSIS, SSRS, SSAS, SAS, Erwin 9.0, Windows NT 3.5 Server

Client: Western Union, India Jun2011 – Dec2015

Role: SQL DEVELOPER/SSIS/SSRS/SSAS

Project: Money Transfer will enable customers to send money to individuals, Banks, Organizations in other countries. Web Service application to do Prepaid Card registration, Recharge, Send and Pay transactions and many more. Western union will abide to all the compliance rules of every country during every transaction. Western Union maintain database to know all their customers and their transactions information

Responsibilities:

Extracting and Loading data into SQL Server Database using SSIS

Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database

Modified, organized, and reloaded legacy data to new tables. Also work on partitioning tables to improve database objects' efficiency

Worked on Requirements Elicitation, Gap Analysis, Requirements Documentation

Created ETL packages (.dtsx files) to validate, extract, transform and load data to Data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases

Designed Aggregations, created groups, KPIs, and pre-calculating measures, in SSAS

Involved in calculating measures and dimension members using multidimensional expression (MDX), mathematical formulas, and user-defined functions

Designed MDX queries in accessing cubes and hands-on experience in query structuring, performance optimization.

Used DTS, T-SQL, scripts, stored procedures and views to run routine reports

Worked on MS SQL Server tasks such as data loading, batch jobs, DTS, and Indexes

Performed Unit Testing, managed and monitored system utilization, designed stored procedures and triggers

Involved in Implementation of database design and administration of SQL based database

Creating and importing source/target tables from respective databases

Modify Reports content and export Reports in multiple formats (Excel, .CSV, tab separated, .PDF, .RPT etc) based on user input

Setting up of Crystal Enterprise for distribution of Reports

Expertise in front-end Business Warehouse components (BEx Analyzer, Query Designer) for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, and Web application designer

Scheduling daily, weekly, monthly Reports in Crystal Enterprise to run at a particular time

Distributing Reports by e-mail, FTP or via web access

Developed SQL scripts, Stored Procedures, functions and Views

Developed Database Triggers to enforce Data integrity and additional Referential Integrity

Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting so create reports that draw content from a variety of data sources

Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports

Developed reports and deployed them on server using SQL Server Reporting Services (SSRS)

Create parameterized Reports using Charts, Cross-Tab and Sub-report types.

Environment: MS SQL Server 2008 R2/2012, SSIS, SSRS, SSAS, Crystal Reports, MS Access,Windows Server 2008, Query Analyzer, Power-Bi

Education:

BIRMINGHAM CITY UNIVERSITY, Birmingham, England June ‘16

Master of Science in International Business in Management

JAWAHARLAL NEHRU TECHNOLOGICAL UNIVERSITY, Hyderabad, India May ‘11

Bachelor of Technology,

Contact this candidate