SUMMARY

• 6 plus years of professional experience as a Data Analyst in - depth understanding of development, Business/Data analysis and Reporting services
• Experience in Software Development Life Cycle (SDLC) methodologies
• Experience in gathering user requirements and generate Business Requirement Document (BRD) and Functional Requirement Document (FRD), maintaining Data dictionary and Meta Data
• Interaction with the Business users during the various stages of the project lifecycle to identify various KPI's and designed solutions to enhancebusinessdecision making
• Experience in conducting Joint Application Development (JAD) session with Stakeholders, Business Users and Tech Lead to obtain domain level information of the project
• Experience in writing SQL Queries, Dynamic-queries and complex joins for generating Complex Stored Procedures, Views, Cursors and Triggers
• Experience in creating filters, quick filters, data source filters, global filters, context filters, user filters and creating Dashboards for key Performance Indicators
• Experience in using Data Blending for merging data from different datasets and creating different visualizations like Scatter plots, Gantt Charts, Bubbles, Geographic Map, Histograms, Bullets, Heat maps and Density Chart
• Hands on experience publishing of various kinds of interactive data visualizations, dashboards, and workbooks from Tableau Desktop to Tableau Servers, Web pages
• Experience in Tableau server configuration, creating Users, Groups, Projects and assign Privileges etc.
• Highly proficiency in working with advanced Excel: lookups, Pivot Tables, Formulas and Functions
• Experienced in data Cleansing and analysis of clients expenditure data With Excel, using pivot tables, formulas (v-lookup and others), data validation
• Performed User Acceptance Test (UAT) by working with internal and external users/customers and obtained delivery approval of the project
• Knowledge in Python scripts to manipulate data or data loads, extracts, statistical analysis
• Good knowledge of Data Marts, OLAP, Dimensional Data Modeling, Star Schema and Snow-Flake schema for FACTs and Dimensions
• Knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Foreign Keys

TECHNICAL SKILLS

• SQL Server 2012/2008 R2/2005/2000, Oracle 10g.racle
• Tableau 10.3, 9.x/8.x (Desktop/Server)
• Python 3.x, JavaScript, HTML, CSS, Visualforce
• Windows 95/98/NT/XP/Vista, Mac OSX
• Microsoft Word, Excel, Outlook, Access, PowerPoint
• Salesforce Administrator - ADM201

PROFESSIONAL EXPERIENCE

Confidential, San Jose

Business Data Analyst

Responsibilities:

• Gathered Business Requirements, Interacted with the Users, stakeholders and SMEs to get a better understanding of the Business Processes.
• Effectively facilitates and participates in Joint Application Development sessions with project stakeholders to gather detailed business rules and functional requirements
• Analyzing data and presenting actionable information to help sales leadership to make business decisions
• Develop and run ad hoc Data queries from multiple database types to identify system of records, Data inconsistencies and data quality issues
• Extract the data from different data source and provide dataanalysis to the business user based on the requirements
• Used Data Loader for insert, update and bulk import or export of data from Salesforce.com Objects. Used it to read, extract and load data from comma separated values (CSV) files
• Standardize company names, addresses, and ensure that necessary data fields are populated by making them mandatory fields in SFDC
• Review the database proactively to identify inconsistencies in the data, conduct research using internal and external sources to determine information is accurate
• Monitor the Database for duplicate records and merge the duplicate records and ensure that the information is associated with company records
• Used advanced Excel functions, VLOOKUP and pivot tables for data analysis
• Involved in executing various SQL database queries from Python using Python SQL connector and SQL dB package
• Designed and constructed real time dashboards for sales and marketing teams using Tableau
• Created relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections and in-memory in both Tableau and Excel
• Created Data Connections, Published on Tableau server for usage with Operational or Monitoring Dashboards
• Executed and tested required queries and reports before publishing and performed quality analysis with data validation by comparing raw data in SQL/Excel to Tableau Dashboards
• Testing the reports and dashboards by validating data from database

Environment: Tableau 9.x/10.3,Oracle 11g, Python 3.x, SQL Server management Studio, SFDC, Microsoft Excel

Confidential, Ohio

Data Analyst

Responsibilities:

• Analyzed Business user and technical requirements for proposed projects system solutions
• Interacted with various business team members to gather the requirements and documented the requirements.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business Requirements
• Analyzed data by creating SQL queries and identified fact and dimension tables.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using SQL in SQL Server
• Performed Data Analysis and Data validation by writing complex SQL queries using SQL against the SQL server database
• Monitor, tune and analyze database performance and allocate server resources to achieve optimum database performance
• Preparing Dashboards using calculations, parameters, calculated fields, groups, sets and hierarchies in Tableau
• Extensive experience in various reporting objects like Facts, Attributes, Hierarchies, Transformations, Action filters, Calculated fields like YTD, MTD, Sets, Groups, Parameters etc., in Tableau
• Extensively used advance chart visualizations in Tableau like Dual Axis, Bar chart, Pareto Chart, Heat Maps, Tree maps etc., to assist business users in solving complex problems
• Created views in Tableau desktop that was published to internal team for review and further data analysis and customization using filters and actions
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Scheduled data refresh on Tableau server for weekly and monthly increments based on business
• PerformedDataprofiling using SQL queries on various sources.
• Data conversions and data loads from various databases and file structures and also compared the targetdatawith the sourcedata

Environment: Oracle 11g, SQL, Developer, UNIX, Tableau 8.x/9.x

Confidential

Business Data Analyst

Responsibilities:

• Coordinating with Business Analysts in requirement analysis meetings to gather requirements up to the mark
• Created complex SQL queries, stored procedures, indexes, functions and views to support efficient data storage and manipulation
• Designed Packages, Procedures, Functions and Triggers. Handle database performance and DB tuning.
• Created and executed SQL Server Integration service packages to populate data from the various
• Developed several Tables, Stored Procedures, functions and views to load data from the SQL server
• Data sources, created packages for different data loading operations for many applications
• Contributed from design to implementation and maintenance phase of the application in AGILE environment/methodology
• Involved in integrating legacy applications into Salesforce.com SOAP & REST callouts
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
• Developed work flows and data flows to extract, transform and load data in to the Business Intelligence Center using Data Integrator’s designer
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance
• Administered user, user groups, and scheduled instances for reports in Tableau
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPIs.
• Used Data Loader for insert, update and bulk import or export of data from Salesforce.com Objects and also used to extract and load data from comma separated values (CSV) files
• Integration of data from different integration teams to Salesforce using Data Loader

Environment: Oracle 11g, SQL Developer, Tableau 8.x/9.x, SFDC

Confidential

Data Analyst

Responsibilities:

• Involved in Design, Development and testing of the system
• Worked closely with Maintained the quality ofdataanalyst, researched output and reporting, and ensured that all deliverables met specified requirements
• Developed SQL Server Stored Procedures, Tuned SQL Queries
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database
• Performeddataanalysis anddataprofiling using SQL queries on various sources
• Created source to target mapping documents ofdatamart for all sources
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise

Environment: Oracle 11g, SQL Developer, Microsoft Excel