SUMMARY

• Data Analyst & System Analysis (8+ Years) and BI reporting (3+ Years)
• 8+ Years of client facing experience working as Data & System Analyst with IT/business architects and preparing various documentations like Business Requirement Document (BRD), Functional Requirement Document (FRD) / System Requirement Specification(SRS), Source to Target Mapping Document (STTM), Requirement Traceability Matrix(RTM) and other client specific documents.
• Have extensive experience in Data integration and data
• 8+ years of experience building architecture for ETL process with sources varying from COBOL files, flat files, excel files, XML, web services and databases like (Teradata, Oracle, SQL server) utilizing Ab Initio 3.0+ and SAS.
• Over 3 years of Tableau Experience in enterprise environment including report / dashboard design, development, maintenance and support using various versions (9.x/8.x/7.x) of Tableau Desktop and Tableau Server
• Extensive hands on experience handling high volume data and producing POC documents using HADOOP (Hive/MongoDB) and Cloudera (AWS/Waterline) technologies.
• Hands on experience in designing and creating reports using SAS Web Report Studio and QlikView.
• Practical experience using Predictive data analytics with SAS for trend and pattern analysis
• Extensively worked on Tableau 9.x (Desktop, Server, Mobile, and Public) and SAP Business Objects
• Expertise in BI/Data Warehousing concepts, designs, and project implementations.
• Highly Proficient in Agile, Scrum and Waterfall Software Development Life Cycle (SDLC
• Strong understanding of Data Warehouse concepts, Star Schema, Snowflake Schema, Business Process Analysis, Physical and Logical data modeling.
• Strong experience in Business and Data Analysis which includes Data Profiling, Data Migration, Data mapping, data transformation, and Metadata Management Services.
• Good in system analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features.
• Worked extensively on designing Canonical, Conceptual, Logical and Physical data modeling using ERwin, Power Designer and ER Studio in several projects in both OLAP and OLTP applications. .
• Worked with MySQL, Oracle, Excel, MS SQL Server databases.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center 7.1
• Good experience with data visualization tools Tableau and Qlikview.
• Expert in creating Calculations (LOD, Cube Calculations, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Extensive experience in using Tableau (Desktop/ Server), Teradata, Business Objects Enterprise, Business Objects Data Integrator, SQL Server.
• Experience in developing code to build MDM Tables.
• Expertise in performance tuning of loading the OLTP Transactions and integration of the data into Data Warehouse (EDW) and Data Marts.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Hands on experience using query tools like SQL Developer, PLSQL developer, Teradata SQL Assistant, and Query man. .
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics in Teradata.
• Good knowledge in Unix Shell scripting.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel Power View.
• Expertise in What - If Analysis using Excel, Power Pivot Reports and Drill Through Dashboards.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
• Worked on OLAP Data warehouses, Modeling, Design, cube development including KPIs, working with slowly changing dimensions.
• Used various R Package for Predictive Analysis and Data Manipulation.
• Used PowerBI along with R to create various Reports.
• Experience in Various data mining techniques and algorithms.

TECHNICAL SKILLS

Databases & OS: SQL Server 2012/2008/2005 , Oracle, DB2 UDB 8.0, MySQL, MySQL Workbench, Sybase, MS Access, UNIX, Windows 8/7/XP/NT,RUP, UML, CMM, Waterfall, Agile, Sybase Power Designer, Joint Application Development (JAD), Unified Modeling Language (UML), Object Oriented Analysis and Design (OOAD)

Business Areas: Telecom, Financial, Healthcare, Insurance, Sales and Marketing, Mortgage.

Tools: ERWIN 4.0/7.0, PL/SQL, INFORMATICA Power Center 8.x/7.x, Power Designer, BUSINESS OBJECTS XI, ER Studio, Oracle Designer, ERWIN, Sharepoint 2003, Visual Studio, Tableau, Qlikview, JIRA, Confluence, Rally, Rational Rose, Ms. Visio, Ms. Project, Ms. Office

Languages: C#, C, C++, PL/SQL, Transact-SQL, XML, XSLT, Java, Perl, Python, PHP, HTML. Methodologies

BI Tools: Essbase Studio, Smart view, Tableau 10.0, Workspace for Hyperion, SSMS (SSRS, SSIS), PowerBI, Power Pivot, Power View, MS Office, Microsoft Visual Studio

Web Technologies: ASP.NET, Silverlight, AJAX, JQuery, Java Script, HTML, CSS

Distributed Technologies: .NET Remoting, WCF, Web Services (SOAP, REST), LINQ

Databases: SQL Server 2000/2005/2008 , Oracle 9i/10g, MS Access SQL *Loader, Oracle 1g,11g, SQL Server 2008, SQL Developer, SQL and PL/SQL (Function, Procedure & packages), R Programming, MSBI (SSRS and SSIS)

Reporting Tools: SQL Server Reporting Services, Crystal Reports 9.0

Testing Tools: NUnit, Visual Studio Team System

Version Control: Visual Source Safe(VSS), Team Foundation Server(TFS)

Other Software & Tools: Net Beans, JCreator, Visual Logic, Microsoft Office, Data Dashboard & Reports, Microsoft Visio 2010, Microsoft Expression Web, Notepad ++, JDeveloper.

Spreadsheet Analysis: VLOOKUP, data table, Data Dashboard slicers, Pivot Table, power pivot, Line-Sparkline, Column Sparkline and Win-loss Sparkline, “what if” scenario

PROFESSIONAL EXPERIENCE

Confidential, Naperville, IL

Tableau/Data Analyst

Responsibilities:

• Interacted with business users to gather report requirements and provided various mock-up reports to finalize the requirements. Played a key role in converting business requirements to functional requirement Designed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML filesetc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for Migrating the SSIS packages from 20012 to 2014
• Developed system flow and data flow diagrams for the proposed system.
• Designed conceptual and logical data models.
• Identified objects and relationships and how those all fit together as logical entities, these are then translated into physical design using the forward engineering in ERwin tool.
• Worked with data compliance teams, Data governance team to maintain data models, Metadata, Data Dictionaries; define source fields and its definitions
• Developed test plans and test cases for QA Unit Testing, System Testing and Enterprise testing.
• Managed the project in breaking down the existing EDW to manageable data marts.
• Generated SQL scripts and implemented the relevant databases with related properties from keys, constraints, indexes & sequences.
• Assigned tasks among development team, monitored and tracked progress of project following Agile methodology.
• Conducted user interviews, gathered requirements, analysed the requirements by using Rational Rose, Visio and Requisite pro - RTC
• Implemented the various Tableau functions, Tableau extracts, parameters, conditional formatting, color coding to the dashboards and reports in Tableau Desktop.
• Publishing data sources and dashboards from Tableau desktop to the Tableau server with the user management, security, content restriction, authentication, and authorization.
• Responsible for development and testing of conversion programs for importing data from text files into Oracle database utilizing PERL shell scripts & SQL*Loader.
• Tested Performance & Accuracy related queries under SQL Server and Teradata.

Environment: Tableau 9.2, SQL Server, Teradata, DB2 Erwin 8.2, SQL*PLUS, MS Office, Enterprise Data Warehouse Architecture, Agile, Rational Clear QuestASP.NET, VB.NET, IIS 5.0, ADO.NET, JavaScript, HTML, CSS, Oracle 9i,Visual Studio .NET 2005, XSL: FO Crystal Reports.NET, Windows XP.

Confidential, Salt Lake City, UT

Tableau/Data Analyst

Responsibilities:

• Data Modeling-Conceptual, logical and physical Modeling for OLAP systems.
• ER Modeling - Developed Entity Relationship Diagrams (ERD
• Identifying the business processes and preparing aggregate tables for Dimensional Models.
• Developing Snowflake Schemas by normalizing the dimension tables as appropriate.
• Business Rules implementation in the Database using Constraints & Triggers.
• Dimensional Data Modeling to deliver Multi-Dimensional STAR schemas.
• Requirements & Business Process Analysis and conducted Gap analysis of different reports and utilized Agile scrum methodology to configure the development process
• Responsible for performing data analysis using Tableau to reflect customer’s core applications and knowledge base
• Responsible for installation and configuration of Tableau Enterprise Business Intelligence software
• Responsible for Tableau server implementation including maintenance of sites, users, groups and projects
• Design & Implementation of Data Mart; DBA coordination; DDL & DML Generation & usage.
• Metadata & Data Dictionary Management; Data Profiling; Data Mapping.
• Supporting and managing RDBMS and designing SQL Server RDBMS architecture concepts, Usage of System catalogues on Query Analyzer, Space management including File groups.
• Applied Data Governance rules and gathered requirements and prepared different types of documents depending on internal and external stakeholder requirements.
• Maintained and documented all create and alter SQL statements for all release.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and Process Flows
• Designing Data Flows & System Interfaces using modelling tools.
• Architecting Work Flows, Activity Hierarchy & Process Flows; Documenting using Interface Diagrams, Flow Charts & Specification Documents.
• Implemented Hybrid Architecture comprising Inmon and Kimball approaches implementing Inmon at integrated layer and Kimball at the Semantic layer which is the best suited for Teradata.
• Created specific indexes to speed up the data load and the data retrieval.
• Worked on enterprise data warehouse and data marts
• Worked very closely with end user to implement their need in data model designed.
• Conceptual, logical and physical data models are designed with maintaining data governance and naming standards.

Environment: Erwin, SSRS, SQL Server 2000/ 2005, Oracle 10g, UNIX, Toad, MS Office, Gap analysis, Agile

Confidential, Minnetonka, MN

Tableau/Data Analyst

Responsibilities:

• Actively participated in Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau 8 desktop/Server.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• 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.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Design and development of various reports and dashboards that can be easily accessible through Tableau App in iPads, iPhones, and other smart mobile phones.
• Performed data analysis and data profiling using SQL on various sources systems
• Created SQL scripts to find data quality issues and to identify keys, data anomalies, and data validation issues.
• Reverse engineered all the Source Databases using Erwin
• Used data analysis techniques to validate business rules and identified low quality missing data in the existing Amgen enterprise data warehouse (EDW)

Environment: Oracle 10g/11g, MS Access 2007, MS Excel 2007, MS Word 2007, MS Outlook 2007, Erwin, Crystal Reports, PowerPoint 2007, SharePoint, data mapping

Confidential, Cambridge-MA

Data Analyst

Responsibilities:

• Created various Predictive Models for predicting analysis using R programming and SQL Server Analysis Services.
• Created various Data Profiling and Data cleansing task for clean data using Data Quality Services.
• Created Database Backup and Database security by revoking or Granting roles and privilege to various users.
• Worked on BI Report Tuning, Report Validation and SQL Tuning Involved in Data mapping, logical data modeling, created ER diagrams and used SQL queries to filter data within the database.
• Worked on Data Quality, Data Retention, and Data Governance.
• Coordinated and worked with the ETL team to ensure the timely execution of feeds to the reporting tables as well as testing the quality of data and providing inputs to them.
• Analyzed and developed usage of dashboards through PostgreSQL server.
• Created tables, views, sequences, indexes, constraints and generated SQL scripts for implementing physical data model.
• Developed Logical and Physical Data models by using Erwin r7.0 and its converted into physical database design.
• Extensively used Star Schema methodologies in building and designing the logical data model into Dimensional Models
• Model analyzed and examined Test plans and Test procedures using waterfall methodology .

Environment: Oracle 8i, SQL, SQL server 7.0, MS-SQL server Analysis Manager, Sybase, Rational Requisite, Windows XP, Crystal Reports.

Confidential

Software Developer

Responsibilities:

• Involved in design, coding and Documentation
• Designed and developed excellent, user friendly Win Forms using C# for Investor data collection.
• Used ASP.NET, JavaScript, IIS, HTML, and CSS for developing Web pages.
• Design and development of credit card transactions and statements module
• Backend database interaction with Oracle 8i
• Personal Credit/Bank account monthly statement generation and distribution
• Administration section for customer support personnel
• Developed the data layer class using C# which is reusable for data transactions of entire project. In this class extensively used ADO.NET objects like Dataset, DataAdapter, DataReader, Command, DataTable and DataRelation objects.
• Design and development of various stored procedures to Fetch, Update and Insert data.
• Design the testing process and unit testing.

Environment: ASP.NET, JavaScript, VBScript, VB.NET, HTML, CSS, Oracle 8i.

Confidential

Software Developer

Responsibilities:

• Write complex SQL queries in Teradata/Oracle for Data analysis.
• Developed ETL scripts using BAS SAS and Informatica
• Created test data and set up the test beds required for testing.
• Work closely with onshore on daily deliverables.