SUMMARY:

• Result Oriented, Proactive and Industrious Professional with around 9 years of hands on experience in the field of Data insight, Data Analysis and Data Visualization. Core experience in developing data analytics products, which includes requirement gathering, analysis, design, data Validation and Data Visualization. Strong in writing Complex sqls queries in RDBMS to Analayze large amount of data; Good knowledge in OLAP andAggregated tables concept; Hands on Expertise in building Complex tableau dahboards to provide insight to the data.
• Highly proficient in Data analysis, Design, data management, databases and data visualization.
• 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 analysis in Teradata and hive systems.
• Expertise in creating Tableau Dashboards for data visulations.
• Espertise 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 phase of the product.
• Experience in maintaining support documents, Test Plans, QA Sign off Documents and Maintaining Weekly Status Reports.
• Experienced in handling concurrent projects and providing expected results in the given timeline.
• Excellent Communication and presentation skills.

WORK EXPERIENCE:

Data Analyst

Confidential - SanJose, California

Platform/OS Used: Windows/Unix

Languages/tool/Database: UNIX, Teradata, Hadoop (HIVE), JIRA, Rally, Confluence

Responsibilities:

• Cross analyze the massive past transaction data and millions customer accounts to identify potential fraudulent accounts and activities.
• Analyze complex and non-standard data from 3 credit bureaus for consumer and small business lenders and implement credit risk models using Tableau.
• Leading cross-functional teams and coordinating on multiple projects.
• Performed data mining, analysis and support various BI group to develop analytical and operational reporting.
• Used Tableau 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 project and facilitate the management on impact, issues and risks.
• Analyzed losses from Credit card & mortgages by using bank's internal models and SQL database for different cohorts
• Creating ad-hoc data analysis to the users as when required.
• Used a variety of reporting tools like Tableau and Spreadsheets to assess program performance and customer behaviour

Data Analyst

Confidential - Seattle, WA

Platform/OS Used: Windows/Unix

Languages/tool/Database: 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, oracle, manipulate and analyze using quantitative, statistical, and visualization using tools like Tableau, Excel and SQL assistance.
• 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.
• 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 queries for business needs.
• Adapted agile scrum methodology.

Data Analyst

Confidential

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.

Data Analyst

Confidential

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.

Software Engineer

Confidential

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.