SUMMARY:

• Having 8 years of experience in gathering Business Requirements, Analysis, Design, Development, Testing and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence.
• Proficient in writing Python scripts for data Extract and data Transfer from various data sources.
• Extensive experience of 4+ years in Tableau Desktop/ Tableau Server, creating highly interactive Data Visualization Dashboards using features such as Data Blending, Extracts, Calculations, Filters, Actions, Parameters, Context Filters, Sets, Groups, Aggregate measures etc.
• Adept at Teradata RDBMS using utilities such as FastLoad, FastExport, Multiload, Tpump, Teradata SQL Assistant and BTEQ.
• Hands on Experience in automating and scheduling the jobs using UNIX shell scripting.
• Competent knowledge on Django, a high - level Python Web framework and object-oriented programming (OOP) concepts using Python and Django.
• Ample working experience in Health Care, Retail, Banking, Insurance and Technology industries.
• Domain experience includes credit cards, retail banking, lending, cross sell, campaign management, auto finance, customer intelligence, customer servicing, retail banking, channels, acquisitions, recoveries, mergers, digital & phone banking, mortgage, core banking solutions, complex data warehouse environments, data analytics, data mining and reporting.
• Worked with various DB/DW/BI technologies including Tableau, OBIEE, Micro Strategy, SSRS, Unica, Google Analytics, Alteryx, Informatica, SSIS, Teradata.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Informatica.
• Developed Entity-Relationship diagrams and modeling Transactional Databases and Data Warehouse using tools like ERWIN, ER/Studio and PowerDesigner.
• Experience in writing Sub Queries, Stored Procedures, Triggers, Cursors, and Functions on MySQL and PostgreSQL database.
• Exceptional Documentation Skills for writing Use Cases, Functional Requirement Documents and Business Process Documentation.
• Knowledge on developing, implementing and administering extract, transform and load(ETL) processes from raw file, flat file, excel and OLE DB sources.
• End to end experience in designing and deploying data visualizations and designed, deployed rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Designed Logical and Physical modeling, Dimensional modeling using Erwin in DWH.
• Performed data cleansing, data mapping, data transformation using metadata, Type1, Type2 slowly changing dimensions, SQL queries and Joins/Filters in the transformations and loaded tables into data marts and generated customized reports in DWH.
• Good exposure to WAMP (Windows, Apache, MYSQL, Python/PHP) and LAMP (Linux, Apache, MySQL, Python/PHP) Architecture.
• Being perceptive, able to learn modern technologies in short span, and motivate team members towards unfamiliar environment for new projects.

TECHNICAL SKILLS:

Languages: Teradata SQL, SQL, Python, C, C++, Java, HTML, PL/SQL, Shell Script

BI Tools: Tableau Desktop, Tableau Server

Statistical Packages: SAS 8.x 9.x (Base SAS, SAS/STAT, SAS/SQL, SAS/MACROS, SAS/GRAPH, SAS/ACCESS, SAS/ODS), SAS Enterprise Guide, SAS Information Map studio

Databases: Oracle 11/12g, SQL Server, MySQL, MS Access, IBM DB2, Teradata, Netezza, PostgreSQL

Frameworks: Django

Tools: Salesforce, Git, GitHub, ER Studio, Abinitio, SQL Assistant, ERWIN, Informatica, MDM, Teradata tools, Microstrategy, Base SAS, SSIS, SAS DM studio

Scheduling Tools: AutoSys, Control M, Drake

PROFESSIONAL EXPERIENCE:

Confidential, McLean, VA

Sr. Data Analyst

Responsibilities:

• Work with the analyst, management teams and supported them by providing deliverables based on the requirements.
• Extensively worked with Salesforce environment to get data, for reporting needs.
• Review basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Contribute to the Data transformation team as per their requirements (Source systems are being moved to AWS from Teradata).
• Delivering the reports 7 out of 13, which are owned by our team. Most of the time worked with Excel initially and migrated them to Tableau.
• Designed and developed the Universe, based on the business requirements for SB Credit card (report which shows the credit card info).
• Created and modified several database objects such as Tables, Views, Indexes, Constraints, Stored procedures, Packages, Functions and Triggers using SQL and PL/SQL.
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset sorting and merging techniques.
• Develop live reports in a drill down mode to facilitate usability and enhance user interaction.
• Facilitated the automation process for the reports - which are required to run monthly and weekly basis using python script.
• Designed and developed various analytical reports from multiple data sources by blending data in a single worksheet in Tableau Desktop and created Tree Map, Heat maps and background maps.
• Involved in generating dual-axis bar chart, Pie chart and Bubble chart with multiple measures and data blending in case of merging various sources.
• Testing dashboards, to ensure data is matching as per the business requirements and if there are any discrepancies in underlying data.
• Create reports using analyzed output data, export them to SharePoint. So that end users will have access to the reports over Internet.
• Extensively read different forms of Input files like CSV and other formats using In-file, Proc Import. And documented using SAS scripting to develop data cleaning operations.
• Based on the ad-hoc requests, create various reports and datasets(excel).
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Performed statistical data analysis, generated ad-hoc reports, tables, listings and graphs using tools such as SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL and SAS/STAT.

Environment: Windows 7, Teradata, Salesforce, AWS, MS-Excel, Tableau 8.2, Python, SASv9.4.

Confidential, Dallas, TX

Sr. Data Analyst

Responsibilities:

• Worked with the analysis teams and management teams and supported them by providing variables based on their requirements.
• Generated PL/SQL scripts for data manipulation, validation and materialized views for remote instances.
• Created large datasets by combining individual datasets using various inner and outer joins in SAS/SQL and dataset sorting and merging techniques using SAS/Base.
• Worked with the major functionalities of Business Objects like alerts, drill filter, breaks, Sorts, Ranking and calculations using the slice and dice panel.
• Designed and developed the Universe based on the business requirements.
• Worked towards optimal development of universes by removing loops using Aliases and contexts.
• Query Data from Hadoop/Hive & MySQL data sources to build visualization in Tableau.
• Extensively worked on Shell scripts for running SAS programs in batch mode on UNIX.
• SAS/STAT procedures such as UNIVARIATE, FREQ, and MEANS were used to carry out analyses and the SAS REPORT procedure is generally used to display results.
• Performed statistical data analysis, generated ad-hoc reports, tables, listings and graphs using tools such as SAS/Base, SAS/Macros, SAS/Graph, SAS/SQL and SAS/STAT.
• Developed statistical reports with Charts, Bar Charts, Boxplots, Line plots using PROC GPLOT, PROC GCHART and PROC GBARLINE.
• Extensive use of Proc freq, Proc Report and Proc Tabulate for reporting purposes.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop and created Tree Map, Heat maps and background maps.
• Involved in generating dual-axis bar chart, Pie chart and Bubble chart with multiple measures and data blending in case of merging various sources.
• Created Dashboards style of reports using Qlikview components like List Box, Slider, Buttons, Charts and Bookmarks.

Environment: Windows XP, SASv9.4, SAP Business Objects 4.0, MS SQL Server, Oracle, Teradata, MS-Excel, Tableau 8.2, Qlikview9.0 SR2.

Confidential

Sr. Data Analyst

Responsibilities:

• Worked with the team to design and develop queries in SQL Server, Management Studio 2014/2012 to verify variety of data sources for claims, policies and customer records.
• Created dashboard using parameters, sets, groups and calculations.
• Used different chart objects like Bar chart, Line chart, Combo Chart, Maps.
• Created various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on mapping the data and creating packages for the customer’s history and claims information and Extracted, Transferred and Loaded (ETL) data from Oracle, IBM DB2, Excel Spreadsheets and Flat files sources with the help of SQL Server Integration Services (SSIS) 2012.
• Worked on cleansing and maintaining the SSIS packages using multiple transformations such as Conditional Split, Derived Column, Lookup, Fuzzy Lookup and Data Conversion.
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management and Developed Test cases and performed Unit Testing.
• End to end experience in designing and deploying data visualizations using Tableau.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop. Created Tree Map, Heat maps and background maps.
• Involved in creating data blending in case of merging various sources.
• Created dashboard using parameters, sets, groups and calculations.
• Coordinated with various dependent and support teams.

Environment: Tableau, Teradata, Fast Load, Oracle, SQL, PL/SQL, SQL Developer, Unix, Netezza.

Confidential, Atlanta, GA

Sr. Data Analyst

Responsibilities:

• Performed Database testing (Data Warehouse / ETL) on ETL applications validating the data in Sources (SAP, Oracle) Targets (EDW).
• Used MDM to implement slowly changing Dimension to maintain historical data in Data Warehouse.
• Involved in Designing the DB2 process to Extract translates and load data from OLTP Oracle database system to Teradata data warehouse.
• Lead the database development, ETL and report development activities and work closely with On-shore and off-shore developers to ensure proper data flow from SAP to Teradata and is available for reporting solutions.
• Identified and documented data sources and transformation rules required to populate and maintain data warehouse content.
• Represented the development organization in the Offering Team of multiple MDM product releases.
• Created SSIS Packages for import and export of data between MS SQL Server2014 database and others like MS Excel and Flat Files.
• Experienced in Cognos Impromptu 6.0/7.0, PowerPlay 6.6/7.0 & other reporting tools.
• Solid experience with ETL tools like Ascential Data Stage (DataStage Manager, Designer, Director & DataStage Administrator) and Quality Stage.
• Experience in writing, testing, and implementation of the triggers, stored procedures, views, cursors, packages, functions at Database level and form level using PL/SQL.
• Extensively used Erwin r9.6 for Data modeling. Created Staging and Target Models for the Enterprise Data Warehouse.
• Set up match/survivorship rules and profiling the match rules results to assess the effectiveness of MDM process on data.
• Optimizes the SAS code used for calculating refunds and exceptions to payment matching reports.

Environment: Windows XP, SASv9.4, Oracle, Teradata, MS-Excel, Tableau 8.2, Qlikview9.0 SR2.

Confidential, Houston, TX

Data Analyst

Responsibilities:

• Involved in defining the whole project life cycle, following RUP methodology.
• Developed a vision plan that defined the primary goals and objectives of the project. Analyze business requirements and segregated them into high level and low level.
• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Assisted Project Manager in developing design and specification, per the requirement and information gathered during JAD sessions and other forms of information gathering methods.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Preparing dashboards using calculated fields, parameters, groups, sets and hierarchies in Tableau.
• Standardized Tableau for shared service deployment and data blending, embed functionalities in Tableau.
• Designed multiple Dashboards for CDI, helping them to convert from manual reporting.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Development users in creating and modifying worksheets and data visualization dashboards.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
• Developed Standard Operating Procedures (SOP) for Monitoring.
• Helped in designing Data-warehouses/ETL workflows required for the reporting applications.
• Actively participated in clarification meeting with the Clients.
• Involved in testing the database using complex SQL scripts and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau, Teradata, Fast Load, Oracle, SQL, PL/SQL, SQL Developer, Unix, Netezza.

Confidential

ETL Developer

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.
• Worked with the report development Manager and other team members on report requirements based on exiting reports/dashboards in Excel, timelines, testing, and technical delivery.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.
• Developed various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Worked with key business data to understand and analyze the customer data, Created Visualizations in tableau using Excel, DW and SharePoint data.
• Involved in report tuning , caching, specifying query governing thresholds, and report optimizations .
• Actively participated in clarification meeting with the Clients, Created Test Cases and documented the Test Results.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Involved in Onsite & Offshore coordination to ensure the completeness of Deliverables.

Environment: Tableau, Teradata, Teradata Administrator, S QL, PL/SQL, MS VISIO, Microsoft Office Suite.

Confidential

ETL Developer

Responsibilities:

• Responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse using SSIS.
• Used different Control Flow Tasks and Data Flow Tasks for creating SSIS Packages, Designed packages using several types of Transformations for Data Conversion, Derived Columns with Multiple Data Flow tasks.
• Involved in Extraction, Transformation and loading (ETL) process and used Informatica Power Center tools - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager and Workflow Monitor.
• Involved in Creating Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through and Drilldown Reports.
• Designed OLAP Cubes with Star schema and created Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS).
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL Joins for applications.
• Monitoring nightly ETL process from various highly different source systems. Sources included SQL based databases and Excel Files. Also, ensured that nightly backup jobs or cube processing or other ETL jobs didn't interfere with each other.
• Monitoring the scheduled SSRS and Crystal reports. Re-running the reports in case of any failures or data mismatches.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Followed agile methodology and coordinated daily scrum meetings.
• Performed data cleansing for accurate reporting. Thoroughly analyzed data and integrate different data sources to process matching functions.
• Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW).

Environment: windows XP, MS SQL Server 2005/2008, SQL Server Management Studio, MSBI (SSRS, SSAS, SSIS), MS Excel, T-SQL, ERWIN.