Business Data Analyst

Sai Kumar. N

*************@*****.***

Mobile: 786-***-****

5+ Years of total IT experience in implementing Software Development Life Cycle in data Warehousing including: business requirements gathering & analysis, design, development, testing and production support.

Experience in documenting BRD (Business Requirement Document), FSD (Functional Specification Document), SDS (System Design Specification) and SRS (System Requirements Specification).

Proficiency using standard business software including Microsoft word, Excel, Visio, Excel, Access, Power Point, SQL, Windows OS.

Excellent collaboration with all stakeholders including Customers, Partners, Delivery, and Finance to collect the Business requirements & documented the business flows.

Involved in BAT, UAT, Cross-functional Testing, System Testing and Performance Testing in all phases of project until Go-Live.

Experience in working with Business Users to understand and analyze project requirements and to co-ordinate work efforts with multiple teams.

Technical hands-on experience using Tableau v. 10/9/8

Hands on experience in creating workbooks and dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions Tableau 8/9 and Tableau 10

Publish Tableau Dashboards in Tableau Server, Tableau public Premium.

Experience in building prototypes for demonstration and illustration purposes for Business partners and senior leaders

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines and Statistics. Groups, hierarchies, Sets to create detail level summary reports and dashboards

Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.

In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.

Extensive knowledge of writing SQL and T-SQL queries, working with back end tools such as Toad, Teradata SQL Assistance for analysis and data validation. Technical Skills:

Business Intelligence Tools: Tableau Desktop 8.3/9.2/10.0, QlikView. Office Admin Tools: MS Office, Adobe Acrobat Standard X Pro. Database Tools: SQL Developer, SQL Server, Toad, MS Databases: Oracle 11i/9i/8i, SQL, TSQL, SFDC.

Application Tools: AppDynamics, New Relic, Salesforce (CRM) Servers: Tomcat, Jmeter, AppDynamics Controller.

Operating System: Windows, UNIX, Ubuntu

Academic Background

Masters in Computer Science from California during the period 2015-2016

BE with specialization in Electrical and Electronic Engineering (EEE) during the period 2006 – 2011

Professional Experience:

Client: Sterling Jewelers Inc Aug 2016 – Till Date Role: Business/Data Analyst

Location: Fairlawn, OH

Signet Jewelers Limited is the largest specialty jewelry retailer in the US, UK and Canada. The company's annual sales of approximately $6 billion derive from the retailing of jewelry, watches and associated services

Responsibilities:

Worked a great extent with the design and development of Tableau visualizations, which includes Preparing Dashboards using calculations, parameters, calculated fields, groups, sets, hierarchies etc.

Created solution driven dashboards by developing different chart types including Crosstab’s, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop

Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

Created Tableau workbooks with calculations, parameters, Quick Filters.

Worked and generating various workbooks and dashboards extracting date from various sources such as Oracle, SQL Server and data files using data blending and joins.

Developed workbooks and dashboards using Tableau Visualizations like Heat maps, Pie Charts, Dual Axis workbooks and Charts, Bar Graphs, Scatter Plots, Trending and Forecast dashboards, Waterfall Charts, Geographic maps using local and global filters.

Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.

Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.

Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

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.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Responded to users’ requests for additional data.

Responsible for analyzing post implementation issues by looking at the various reports created based on the new system.

Installed and configured systems and trained team members that were responsible for creating reports based on the new system.

Performed Data Analysis and Data validation by writing complex SQL queries using SQL against the SQL server database.

Worked with the DBA and Database developers to convert the functional specification to technical specification.

Closely monitored the system performance after implementation to address any minor performance issues and evaluate the overall system.

Wrote complex SQL queries to pull and process data from multiple data sources (SQL Server, flat files, etc).

Designed and programmed re-usable SQL code to prepare data for analysis.

Downloaded data from various sources

Environment: Tableau 10/9, Oracle 11, Teradata, Microsoft SQL Server, Toad 12.1, Teradata SQL Assistance, Microsoft Office, HP Quality Center Client: Wadia Groups (WTESL) - India June 2011 - Feb 2015 Role: IT Analyst

Location: Hyderabad, IND

Wadia Techno-Engineering Services Limited (WTESL) formerly Gherzi Eastern Limited (GEL) is a part of Wadia Group of Companies, a leading business house in India. Wadia Techno focuses on the dynamic needs of various industries and provides world class comprehensive consulting services.

Responsibilities:

Facilitate business stakeholder’s discussion to define scope and to document Functional and Business documents.

Prioritized business requirement on the basis of business need and where the business requirement naturally fits with the overall deployment plan.

Analyzed and validated the source systems data Validated data against data rules and quality.

Performed Map and Gap Analysis to validate requirement feasibility.

Created the source to target mappings and defined the business rules.

Involved in the data modeling sessions with architects, SME, business to define the data models as per the standards.

Involved in daily meetings with the ETL and development team as point of contact from Business to communicate and clarify the requirements to support the code development.

Participated in the planning and execution of the UAT effort. Guided team in writing test cases, developing test scenarios and test data besides action as liaison between technical team and testing team to resolve issues and defects.

Conducted weekly follow up meetings with Business on the data quality issues for the daily monthly and quarterly reports incurred as part of technical /system errors.

Monitored the data quality issues and track the issues until resolved through incident creation.

Have done the reverse engineering to find the bottlenecks in the reports, ETL’s and in the source for data issues reported.

Co-ordinate with operations /support teams on incident management, production issue handling.

Environment: Teradata, SQL Assistant 14.01, Oracle 10g, Toad 9.6.1,PL/SQL, MS Office, HP Quality Center.

Contact this candidate