SUMMARY

• Served as Data Analyst for a fortune global 500 companies with a track record of successfully managing the IT projects.
• 5 years of overall IT industry experience as Data Analyst and Tableau developer.
• Expert in gathering the requirements from the Business users and understanding the Business rules and functionalities.
• Adept at preparing functional and technical design document for reports.
• Developed data model to create the reports and dashboards
• Developed worksheets using the parameters, calculated fields, groups, sets and hierarchies.
• Coordinated with the ETL team to create a helper view required for developing the prototypes in Tableau per the requirement
• Review the created prototypes with the stakeholders and receive sign off to roll the finalized version to production.
• Well versed in publishing and scheduling workbooks on the server 10.3, 10.1 both production and Dev environment as per the industrial standards.
• Domains: eCommerce, Marketing, Business Intelligence, CRM, Payroll.
• 5 Years Hands - on experience on Tableau Desktop, Tableau Reader and Tableau Server.
• 4 years Microsoft experience including pivot tables, v-lookup, h-lookup in Excel, Visio.
• 1 year AWS experience: Migrated legacy and operational systems data into AWS where customer service and sales representatives could access data for wide range of services.
• Experience in all the Latest BI Tools Tableau, Dashboard Design, DataTables,Persicope.

TECHNICAL SKILLS

Programming: JavaEE, HTML5, Clojure, AngularJS, Spring, CSS3, ASP.NET, R, Hibernate, Python, C++, D3.JS, Core JAVA, Drupal8, C#, SharePoint, Bootstrap, NodeJS, ReactJS, Restful API

Databases: MySQL, MongoDB, PostgreSQL, CouchDB, Stored Procedure, BigData, PL/SQL, SharePoint Server 2013, Vertica Database, Teradata, Microsoft SQL Server 2012

Services: Redshift, V-Lookup, Macro, Microsoft Azure, EC2, S3, MS-OFFICE, AWS

Tools: Eclipse IDE, PyCHARM, Web Harvy, MongoLAB phpMYadmin, Selenium, Tableau, Qlik, NMap, Wireshark, Light-table, NetBeans IDE, Android Studio, SoapUI, FileZilla, WYSIWYG, Xampp, Frevvo, Periscope, Bootswatch

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, Delaware

Java Developer

Responsibilities:

• Being a Java Developer, my responsibility is to utilize mature (3rd or 4th Generation) programming methodologies and languages and platforms (Java, MySQL, SQL loader, UNIX Korn Shell scripting, Windows and UNIX)
• Adhere to coding standards, procedures and techniques while contributing to the technical code documentation.
• Provide high quality technology solutions that address business needs by developing applications within mature technology environments.
• In corporate security requirements into design, provide input to information data flow and understand and comply to Project Life Cycle Methodology in all planning steps. Adhere to IT Control Policies throughout design, development and testing and in corporate.
• Participate in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed IT solution. Participate in design reviews and provide input to the design recommendations.
• Corporate Architectural Standards into application design specifications. Document detailed application specifications, translate technical requirements into programmed application modules and develop. Enhance software application modules.
• Participate in code reviews and ensure that all solutions are aligned to pre-defined architectural specifications. Identify application code-related issues. Review and provide feedback to the final user.
• All these responsibilities will help the candidate to go ahead and work for other Organizations too in future giving him proper knowledge on the work needed as a Developer.

Confidential, California

Technical Business Analyst

Responsibilities:

• Utilized advanced MS Excel to manipulate data and support DSS.
• Executed, Updated and created MySQL queries to pull data in Teradata.
• Executed daily publishing of new items, on average publishing over a thousand SKU’s a week.
• Created daily and weekly store request reports with graphs and charts using advance excel (pivot tables, macros, index, match, v and h lookup, among other functions)
• Provided custom reporting, data analysis, quality assurance, data cleansing, daily maintenance, etc.
• Performed assortment coverage reporting using Teradata, MySQL and advance MS Excel.
• Escalated reported issues to Microsoft SharePoint Platform Support for detailed incident
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created visualization for logistics calculation and department spend analysis.
• Used SharePoint Server 2013, created Helpdesk app in which people can post tickets with their problems and can get immediate solution.
• Build the document management workflow in Square 9 smart search DMS tool. In which according to the department through an automated flow the document goes to archives.

Confidential, California

Database Developer/ Data Analyst

Responsibilities:

• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, Involved in Debugging andmonitoring, and troubleshooting issues.
• Work directly with management, vendors, and third parties to ensure that Web-site’s financial transactions and database management applications operate at peak efficiency.
• Ensured projects were completed on time and within budget.
• Played key role in enhancing client’s Web reporting system, reducing time of delay financial tracking analysis by 30%.
• Configuring a Tableau Server and Microsoft-SQL 2008 R2 server for Data warehouse purpose.
• Consolidate multiple data silos that exist on campus to one location.
• Scheduled data extracts on a daily basis.
• Sophisticated stored procedures and triggers to provide complete technical solutions.
• Worked with all levels of development from analysis through implementation and support.
• Participated in test planning and test script definition.
• Resolved end user reporting problems through collaboration with IT and Operations.
• Collected all the data of students travelling to university and do a data analysis on that for future prediction that how much parking spaces will be needed to accommodate more students, generated a dashboard to show more clearly the specifics using the Tableau.
• Manipulating MySQL tables and queries (Update, Repair, Modify, Extract) depending on the business requirements and complexity of reports
• Daily Extraction and Cleaning of data from Business Intelligence Warehouse in order to transform the data into reports
• Created several templates, reports and queries in Business Warehouse as part of the simplification process
• Providing Daily, Weekly and Monthly Data Analysis and report recommendations to stakeholders
• Processing bulk data into figures, charts and reports understandable by the stakeholders
• Automation of in house reports and maintaining communications with different departments in order to fulfill their requirements
• Assist with creation of training manuals and job aids for global use as well as development of audit process for HR Operations Workday team
• Creating daily reports and tasks efficiently. Member of 2 projects which spans multiple departments - Coordinating with different stakeholders for handover4 and migration of processes

Confidential, Burbank, California

Database Administrator Intern

Responsibilities:

• Data Analysis on the database developed by different games like Batman the Arkham Knight, MadMax, Gauntlet.
• Used Vertica Database for pulling up data.
• Used Tableau for making real time dashboard with the database server containing data collected by different user-profile which updates daily.
• PL/SQL for data prediction on the data sets for helping them in creating new games for the genre which is more played by the players.
• Implementing changes to existing BI systems.
• Providing data and analysis in support of the company's initiatives and projects.
• Building strong working relationships with cross functional teams.
• Coming up with analysis that is cogent and timely.
• Managing the timely flow of business intelligence information to senior managers and users.
• Leading small projects from scope definition through to execution and implementation.
• Developed and tested SQL queries/dashboards (ad-hoc or scheduled) utilizing Microsoft SQL Server 2012, Google Analytics, and MS Excel/Access.
• Developed Tableau dashboards, ad-hoc reports, and reporting tools as requested by internal/external customer’s using the above listed BI tools.
• Contributed to the development of new products to increase revenue growth in emerging markets.
• Performed daily ETL performance tuning, complex SQL query design and ETL process verification for optimal performance.
• Working with User for requirements and part of the team developing the software.
• Publish Tableau workbook to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.
• Formulated and documented ETL process design based onbusinessrequirements andsystem specifications including source to target mappings, data dictionaries and transformations.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Designed Tableau Workbooks, Tableau Reports, Dashboards and Tableau Administration.
• Scheduled reports debugged issues and provided resolutions for Tableau.
• Done performance tuning to optimize the run time.
• Changed stored procedures according to the new hierarchy.
• Designed and created Report templates, bar graphs and pie charts based on the financial data using Tableau.
• Involved in designing Parameterized Reports and Report Models for generating Ad-hoc reports as per the client requirements.

Confidential

Data Analyst

Responsibilities:

• Developed and maintain website for the company using Spring-Hibernate, HTML-CSS, Bootstrap
• Website which Displays goods and in the real time it shows how many samples are remaining in the inventory, it has the link to all the social networking sites and the person will get notified whenever new sample launches via E- mail. Manage Database for the company and track the records of all the dispatched goods.
• Used MySQL while working there. Worked on MongoDB and Python.
• Designed Excel and Tableau dashboards for higher management reports, and other data visualization reports as per needs of the user to measure KPI. Frequently prepared ad-hoc reports using Microsoft Access and Excel.
• Performed Data Analysis using QlikView, Tableau software to analyze financial data.
• Created BRDs and PRDs with the collaboration of project manager, QA and systems analyst.
• Data Analysis using MySQL for queries from DB2, Excel, Access DB.
• Developed UML diagrams showing high level map of business.
• Combining structured and unstructured information for data warehousing and analyzing claims data to help identify cost and recovery. Working with formats like csv, xml, and Excel
• Wrote SQL queries in Microsoft Access based on management’s requirements/expectations.
• Plan, design, and implement application database code objects such as stored procedures and views.
• Provide database coding to support business applications using T-SQL.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data files for counterparties.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Performed development activities from gathering requirements and designing solutions, through developing code / reports, to testing and release / deployment.

Confidential

Data Analyst

Responsibilities:

• Gathered the requirements from the Business to create Tableau dashboards
• Created Parameters, Calculated fields, Reference lines, Trend lines, Sets, Groups to match the conditions per the requirement while creating the charts.
• Build various charts like Bar Graphs, Pie charts, Funnel charts, Scatter plots, Donut chart, Bubble charts etc. per the requirements.
• Created action filter in the dashboards to navigate and map the relevant Data.
• Created detailed reports to drill down the data and help users to view the data at a very granular level.
• Educated the user to utilize the dashboards developed and retrieve the significant data within few seconds.
• Managing Access to the users in the share point site and scheduling automation of Reports.
• Formatted the dashboards per industrial standards
• Scheduling the reports according to the users define time to refresh.
• Worked to enhance the existing dashboards per the change request.
• Developing technical specifications and diagrams using Microsoft Visio

Confidential

Data Analyst/ Internship

Responsibilities:

• Analyzed massive and highly complexDatasets, performing ad-hoc analysis anddata manipulation.
• Analyzed journal entries provided by client for equality, completeness, and abnormalities
• Validateddataformats and Verified control totals against the general ledger.
• Imported and exported data from text files, saved queries, or databases used automatic outlining, inserted subtotals, created advanced filters, and used database functions.
• Researched, updated, and validated data underlying spreadsheet production strategically fill gaps.
• Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items and group data, and refreshed and formatted pivot tables.
• Designed, recorded, and executed macros to automate data entry inputs.
• Formatted spreadsheets and workbooks for print, document reproduction, and presentations.
• Executed standardized and audit-objective- specific scripts for journal entry testing and performeddataanalysis testing
• Mapping the data according to the Bing Data base according to the results & run the data in the data tool for Validation.
• Validating the data through different validation tools such as Swiss Knife, Hit App, Pin Pointer, Data Clustering, Data Templates.
• Escalating Issues & Interacting with the Business Managers for insertion of bulk data and other possible Mapping Entities
• Sending Reports to the managers on daily basis about the schedule work.
• Maintained the quality ofDataanalysis, researched output and reporting, and ensured that all deliverables met specified requirements