PROFESSIONAL SUMMARY:

• Result Oriented, Proactive and Industrious Professional with around 9 years of hands on experience in the field of in Data Visualization, Data Analytics, Data Management, Data Integration, Implementation and Maintenance of Business Intelligence, and the related Database Platforms.
• Core experience in developing data analytics products, which includes requirement gathering, analysis, design, data Validation and Data Visualization.
• 4+ years Hands on Expertise in building Complex tableau dahboards to provide insight to the data.
• Proficient in writing complex sqls queries in Teradata and Oracle to Analyze large amount of data; Good knowledge in OLAP andAggregated tables concept;
• In depth knowledge in Tableau advance features like Actions, Calculations, forecasting, Parameters and Trend lines.
• Ability to collaborate with peers in both, business, and technical areas, to deliver the optimal business process solutions, in line with corporate priorities
• Experience in all stages of Software Development Life Cycle (SDLC) with proficiency in Various Methodologies including Waterfall and Agile (SCRUM).
• Proficient in using complex SQL for data analysisin Teradata and hive systems.
• Expertise in creating Tableau Dashboards for data visulalization.
• Expertise in Deploying and maintaining the Tableau Dashboards to the servers.
• Experience in Banking and e - commerce domains.
• Expertise in working on Agile/Scrum methodology and used tools like JIRA,Rally,Sharepoint,Confluence for project collaboration.
• Experience in gathering business requirements from business/user, creating Process Flows and Data Flow Diagram (DFD)
• Adept in creating Use cases, Test Cases and GUI (Graphic User Interface) using MS WORD/VISIO.
• Strong analytical skills in data analysis and technical skills in using Excel modeling, Excel PowerPoint motivated professional with leadership qualities and extensive skills in interacting with subject matter experts, stakeholders, development team, users and various levels of management.
• Team lead skills encompassing user interviews, coordination with Technical Leads, developers, QA/QC analyst during the design and testing phaseof the product.
• Experience in maintaining support documents, Test Plans, QA Sign off Documents and Maintaining Weekly Status Reports.
• Excellent Communication and presentation skills.

TECHNICAL SKILLS:

Operating Systems: Windows2000/NT/7, UNIX

Languages: SQL, Hive

Databases: Teradata, Oracle,Sql server 2012

Tools: & Utilities: Jira,Rally,service now.

Domain Knowledge: Banking & Ecommerce .

Software Methodologies: Agile & Waterfall

Reporting Tool: Tableau

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, California

Data Analyst

Environment: Platform/OS Used: Windows/Unix Languages/tool/Database: Tableau,UNIX, Teradata, Hadoop (HIVE), JIRA,Rally,Confluence

Responsibilities:

• Cross analyze massive past transaction data and millions customer accounts to identify potentialfraudulent accounts and Transactions.
• Build Tableau Dashboards to Analyze complex and non-standard data from 3 credit bureaus for consumer and small businesslenders and implement credit risk models using Tableau.
• Performed data mining, analysis and support various BI group to develop analytical and operational reporting.
• Created Tableau Dashboards to track processing fees earned from various sources (Finacle, Symbols), offline/online fees and accruals; generated reports for the senior management
• Monitor progress of the Dashboards and facilitate the management on impact, issues and risks.
• Worked Closely with the ETL data team to fix the Data issues identified in tableau reporting.
• Worked in cross-functional teams across region and ensured reporting numbers are correctly provided to senior management.
• Analyzed losses from Credit card & mortgages by using bank's internal models and Teradata database for different cohorts.
• Planned a roadmap of project activity that generated measurable improvement in business performance metrics and Key Performance Indicators (KPIs).
• Creating ad-hoc data analysis to the users as when required.
• Used a variety of reporting tools like Tableau and Spreadsheets to assess Product program performance for the new system integrations.
• Published and scheduled daily/Weekly/Monthly Tableau dashboards to the tableau server.

Confidential, Seattle,Washington

Data Analyst

Environment: Platform/OS Used: Windows/Unix Languages/tool/Database: Tableau,Oracle, Teradata,JIRA,service now,Rally

Responsibilities:

• Performed in-depth analysis for Ebayplus and PUDO programs which includes understanding the business needs and translating to analytic requests, extracting data from a variety of sources like Teradata and oracle.
• Built, published customized interactive reports and Tableau dashboards, report scheduling using Tableau server. Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Met with various groups, including business owners, SMEs (subject matter experts) and marketing team, for requirements gathering in definition Stage
• Built end to end reporting layer in Tableau Dashboard for analytical, operational, real- time and adhoc reporting environment.
• Defined historical and incremental refresh frequency in tableau for the data refresh.
• Developed Tableau workbooks from multiple data sources using data blending and interactive views, trends and drill downs.
• Responsible for creating /delivering monthly reports to business users for Ebayplus and PUDO programs.
• Provided guidance and recommendations on process improvements and best practices.
• Worked with the project manager to estimate best/worst case scenarios, track progress with weekly estimates of remaining work to do, conducting informal meetings ad hoc and as needed.
• Wrote adhoc sql queries for business needs.
• Adapted agile scrum methodology.

Confidential

Data Analyst

Environment: Platform/OS Used: Windows/Unix Languages/tool/Database: UNIX, Teradata

Responsibilities:

• Perform daily data queries and prepare reports on the daily, weekly, monthly and quarterly basis.
• Used advanced Excel functions to generate spreadsheets, pivot tables and vlookup tables.
• Heavy SQL queries including complex joins, nested queries, stored procedures, common table expressions (CTEs) etc. were being used for Integration and Management of data.
• Data migration tasks were accomplished via SQL Server Integration Services (SSIS). Featuring tool for data Extraction, Transformation, and Loading (ETL).
• Reviewed and validated business requirements from stakeholders and steering committee members and transform the business requirements to technical design and transformation logics.

Confidential

BI Engineer

Responsibilities:

• Build and maintain comprehensive dashboards and metrics to enable real-time business decisions
• Compiled, analyzed, and evaluated data on various targets and actual.
• Worked closely with Operations and application teams for queries and programs. Used advanced Microsoft Excel to create pivot tables, used VLOOKUP, and other Excel functions.
• Worked on increasing Net Sales and AUM based on the insights
• Provided the intelligence to measure and drive initiatives to increase revenue per customer and decreased churning of portfolios.
• Developed new reports and delegated tasks to team members
• Analyzed the Investments Focus report every month for each branch and discussed the same with the Branch Managers and Investment counselors.
• Extracted, interpreted and analyzed data to identify key metrics and transform raw data into meaningful, actionable information.
• Designed the conceptual and logical data warehouse architecture and implemented on Oracle and DB2 database.
• Implemented data relationship, data control and referential integrity constraints in Oracle 9i and enforced business logic transformations on the data warehouse.
• Created and implemented materialized views by fragmenting the data warehouse for various line of business.
• Identify the Target Class and analyze the interesting knowledge in the target class based on various aspects such as region, income range, loan period, pay frequency, returns, etc.
• Created data marts for Credit risk line of business and implemented Data Cubes for reporting using MS BI.
• Identify the target datasets and analyze the interesting knowledge on the datasets based on various variables such as region, income range, loan period, pay frequency, returns, credit line, etc.

Confidential

Software Engineer

Environment: Platform/OS Used: Windows/Unix Languages/tool/Database: UNIX, Teradata, Datastage

Responsibilities:

• Involved in meetings with SME's, Data Architect and Data modelers in getting the Business Requirements.
• Developed the Enterprise Data warehouse in Agile methodology.
• Identified and understood the business function activities, entities, data attributes, metadata and documented detailed design specifications for new system.
• Analyzed the reverse engineered Enterprise Originations (EO) physical data model to understand the relationships between already existing tables.
• Worked with the DBAs to create a best fit physical data model from the logical data model and worked with BI team to ensure all the requirements are met for reporting.
• Closely interacted with developers to understand application functionality and navigational flow and keep them updated about Business strategies.