SUMMARY:

• Over 5 years of IT experience as Business Systems Analyst/Data Analyst including project planning and management, software analysis and design.
• Experienced in Data Visualization, Data Analysis, Business Intelligence, IT Analysis/Design, and Client/Server Sys - tem Architecture.
• Hands-on with creating solution driven dashboards by developing different chart types including Heat Maps, Geo Maps, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantt chart, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau versions 6/7/8.1/8.2/8.3 and 9/9.2.
• Utilized all Tableau tools including Tableau Desktop, Tableau Server, Tableau Reader, and Tableau Public .
• Built better dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Produce attractive visuals/dashboards to convey the story inside the data.
• Built and expanded reports available for both internal support and external customer reports, which included increas- ing the scope of data extracted and utilization of reporting purposes.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of reporting and analysis projects.
• Experienced in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Re- ports.
• In depth knowledge of Software Development Life Cycle (SDLC).
• Extensive experience with object oriented analysis & design, also developing use-case models.
• Good understanding of accounting, financial management, retail, and financial service industry.
• Experience in guiding the team to accomplish the goals set by management and play a vital role in supporting the team and yet at the same time work under a supervisor.
• Ability to work independently with no/limited supervision along with working in tighter schedules and a quick learner.
• Excellent communication skills in both written and oral along with ability to tell a story through data.
• Extensive knowledge of financials including amortization, debt securities, equities and derivatives such as options, futures and currency swaps.
• Understands appropriate IT controls required to achieve Sarbanes-Oxley (SOX) compliance.
• Ability to meet deadlines and handle pressure coordinating multiple tasks.
• Demonstrated strong interpersonal skills with the ability to work effectively with upper management and excellent leadership skills in motivating others.
• Developed on BI-BigData-Analytics and Microsoft Technologies.
• Experience in Tableau Development and Tableau Administration.
• Development experience in Python, Unix Scripting, R, SQL.
• Attended training and have introductory hands-on in Big Data technologies like: Hadoop Framework (Cloudera\IBM BigInsights), Spark, Pig Latin, Hive, Hbase, SAS.
• Result oriented, ethical and able to adapt new technologies.

TECHNICAL SKILLS:

Tools: Doors, Rational ClearCase/ClearQuest/Rose/RequisitePro, ERWIN4.0, MS Visio, MS Excel, MS Power Point, MS Project.

Databases: MS Access, Oracle 7.x/8i/10g/11g, DB2, Teradata, MS-SQL Server 6.5/7.0/2000.

Operating Systems: Windows 98/2000/ME/NT/XP, Mac OS, UNIX (Solaris), Linux 2.4, AIX.

Methodologies: OOAD, UML, RUP (Rational Unified Process), RAD (Rapid application development), Agile, Business and Data Modeling.

Languages: TSL, C, C++, Java 2.0, SQL, PL/SQL, C, C++, SQL, Java, SAS, HTML, VB Script, JCL (mainframe), Python 2.7/3.0

Reporting Tools: Micro strategy, Cognos, Business Objects, Crystal Reports, Tableau 7.x/8.x/ 9.0

Internet Technologies: Java Script, CGI/Perl, Oracle 9iAS, JWS, BroadVision, Apache, WebLogic, NetDynamics, XML, HTML.

Networking: FTP, TELNET, TCP/IP, LAN, WAN, PC- Anywhere.

Programming: VB.Net, ASP.Net, Java, J2EE, C, C++, C#, SQL, PL/SQL, Shell scripting, HTML, XML, Python, Ruby

Other Tools: Abinitio 2.15/2.14, Informatica 7.1, BOXI, Cognos, Excelsius, Crystal Reports, Autosys, Toad, Visio, Microsoft Office, XML SPY, TIBCO, SOAP UI, REST Client, Team city, Jenkins, GIT

PROFESSIONAL EXPERIENCE:

Confidential

Data Analyst / Digital Sales Analyst

Responsibilities:

• Proactively monitored sales data looking for trends, anomalies, and other insights.
• Worked on Monitoring key business trends, audience trends and integrated into sales stories.
• Worked as a strategic thinker and leveraged research to provide market overview, segment information, customer insights and/or proprietary data as needed for specific advertisers.
• Worked with various groups to determine inventory availability and sales opportunities and then provide revenue fore- casts based on that information.
• Worked on generating reports for Senior Management for ad hoc requests, weekly forecasting, and annual budget plan- ning.
• Worked on analyzing revenue results and providing explanations for variances to forecasts. This analysis included pro- viding actionable data regarding advertising forecasts, eventual results, and trends.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of re- ports.
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Created area map to find out customer base usage within United States and found gaps in areas where USATODAY lacked coverage. Created quick filter to narrow down individual states and cities along with revenue being generated in individual state or city.
• Created side by side bar chart comparison of USATODAY users who were domestic vs. international along with pro- viding profit revenue generated.
• Experience in standardizing Tableau for shared service deployment. Building, publishing customized interactive reports and dashboards report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked on general day-to-day support of sales staff and management and also synthesizing large amounts of data into concise, actionable messaging and reporting
• Studying and learning industry news and trends and incorporating these into the digital forecasts
• Designing the Reports as per client Requirement and created the reports using Excel file and Oracle database.
• Created complex reports utilizing the features like hierarchy, New Calculated Columns, Drill functionality, Tables, graphs, line Charts and Bar Charts.
• Created Parameters to achieve desired functionality.
• Created and modified some of the existing reports and dashboards.
• Created connection pools, physical tables, defined joins and implemented authorizations in the physical layer of the repository.
• Created conditional prompts and Action links to filter the data on dashboard.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Analyzed data from various databases and formatted it into graphs using Tableau Desktop.

Data Analyst / Circulation Analyst

Responsibilities:

• Performed financial planning and analysis, including forecasting, annual budgeting, and ad hoc P&Ls.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Creating users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Developed Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Connect to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Performed SQL reporting with the ability to create SQL views and wrote SQL queries.
• Worked on generating dashboards that tracks financial status by monitoring variances from plan.
• Generated financial status by comparing and analyzing plans and forecasts with actual results.
• Conducted Investigation on variances to expected results and provided explanations.
• Developed and maintained a relationship with shared service centers relating to circulation items such as account recon- ciliations, journal entries, accounts payable, billing and cash receipts, credit and collections.
• Provided information to management by assembling and summarizing data; preparing reports; making presentations of findings, analysis and recommendations.
• Created visually compelling actionable interactive worksheets and dashboards.
• Designed, developed and implemented Tableau Business Intelligence reports.
• Worked on different chart objects like Bar Chart, Line Chart and Pivot table.
• Used Parameters, Aggregate Functions, Filters.
• Used TableauDesktop to analyze and obtain insights into large data sets.
• Worked on combining the visualizations into Interactive Dashboards and publishing them to the Server.
• Prepared Dashboards using calculations, parameters in Tableau.
• Automated User Management across site using REST API in Python.
• Implemented trend analysis and forecasting using Tableau on data volume growth and traffic happening on Hadoop clus- ter.

Environment: Tableau Desktop 8.0, Tableau Server 8.0, Microsoft Office 2007, SQL Server 2008, PL/SQL, T-SQL, Angular JS, ASP.NET, Java, HTML, CSS,SQL, Windows 7/Vista/XP, MAC OS, SQL Server 2008, iPhone OS, Android OS, Python, Ruby, VMWare, Tableau 9.0, MS Internet Explorer, Mozilla Firefox, Chrome, Safari, Opera, Bugzilla, Xpath, Firebug, SOAP UI, REST client, Open source tools, Jenkins, GIT, Team city, REST API

Confidential

Research & Data Analyst

Responsibilities:

• Worked on s ynthesizing large amounts of data into concise, actionable messaging and reporting
• Worked on proactively monitoring sales data looking for trends, anomalies, and other insights.
• Worked on analyzing revenue results and providing explanations for variances to forecasts
• Provided multiple demonstrations of Tableau functionalities and efficient data visualizations approaches using Tableau to the senior management at the client as part of the BRD.
• Involved in data validation of the results in Tableau by validating the numbers against the data in the database tables by querying on the database.
• Dashboards from Tabular Models to help managers to identify critical KPIs and facilitate strategic planning in the orga- nization.
• Designed and developed the most suitable User Interface such as Dashboards, multiple charts types, Trends, cus- tom requests for Excel Export and objects for Management Dashboard reporting using Power Pivot.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill down features for the detailed reports.
• Performed Tableau Admin duties that comprised configuration, adding users, groups, managing licenses and data con- nections, scheduling tasks, embedding views in the Tableau Server.
• Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Developed highly polished executive level dashboard prototype for the Operations Research Consulting group which provides BI for different LCME KPIs to implement their decision support systems for developing competitive financial aids, hospital operations, optimizing the medical school and hospital organization, etc.
• Designed dashboards on the concept of Dynamic Availability where in a variety of worksheets / views were connected by Actions, and provided an interactive reporting environment of the Confidential Student Surveys, the Council of Teaching Hospitals Operations and Finance Survey, the Faculty Roster, the Financial Aid Summary, Confidential compensation surveys, the Group on Resident Affairs Member Engagement Survey, the Organizational Characteristics Database, the Report on Residents, the Student Records System, and the Tuition and Fees Survey.
• Created histograms, pie charts, box plots, scatter plots for inventory management, background maps illustrating the po- tential LoRs generation, applicants registered at different geographic school locations, time-series statistics for graduates variance across different medical schools, heat maps for applicant activities across medical schools.
• Implemented Tableau Online to enable cloud implementation of analytics developed on Tableau desktop, and to make dashboards available on the cloud platform AWS being implemented by the client.
• Worked on building queries to retrieve data into Tableau from SQL Server 2008 and Oracle SQL Developer, and devel- oped T-SQL statements for loading data into Target Database.
• Developed best practices guide for Tableau implementation using Tableau Desktop, Tableau Server and Tableau Online.
• 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
• Updated and maintained office manuals that documented policies and procedures for data collections, data management, and data reporting.
• Helped design, test, launch, and manage surveys. Facilitated efforts with colleagues and constituents to devel- op, execute, maintain, and enhance data operations that provide compelling information for transformative reports.
• Cooperated with IT to ensure that on-line survey instruments, reporting tools, and management tools exhibit a high degree of functionality and usability.
• Developed and maintained quality control checks and project management schedules to ensure that surveys are launched in a sound and timely manner.
• Provided day-to-day reports for survey participants with log-in issues, content-related questions, reminders, extensions, or similar operational concerns.
• Create, modify, and refresh Oracle tables that store survey data and their crosswalk files and meta data.
• Process, edit, and track survey responses or data collection submissions. Facilitate efforts with colleagues and constituents to develop, execute, maintain, and enhance data services that compel transformative change.
• Contributed to a number of recurring data services reports, such as Confidential Student Surveys Report, the Council of Teach- ing Hospitals Operations and Finance Survey report, the Faculty Roster report, the Financial Aid Summary Report, Confidential compensation surveys report, the Group on Resident Affairs Member Engagement Survey report, the Organizational Char- acteristics Database report, the Report on Residents, the Student Records System report, and the Tuition and Fees Survey report.
• Created ad hoc requests for special reports and other data services reports.
• Involved in reviewing requirements and data sources from MS Excel and MS Access for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Used Tableau Desktop for blending databases and creating different interactive views and dashboards.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization.
• Used Tableau Desktop and created Interactive reporting dashboards by combining multiple views.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Created users, groups, and domains from Active Directory and created different License Levels for each user. Took back- up of the Tableau Server on a regular basis by using Tab admin commands and have also restored when there was a system failure.
• Reviewed Vendors Status Reports with Project Team and created visualization for budget forecasting.
• Responsible for RFP (Requests for Proposals) data visualization creation in Tableau Desktop.
• Published views and dashboards in Tableau Server for auditor review.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and busi- ness groups.

Environment: JIRA, VersionOne, Java, SQL, SharePoint, Visio, relational DBMS (Oracle, MS SQL Server), REST Client, SOAP UI, MQ / JMS queues, Firebug, Business Objects, Crystal Reports, Tableau 8.2, Websphere 6.0, Eclipse JSON, Oracle 10g, Selenium IDE, Ruby, Web driver, Tableau Desktop 8.2, Tableau server, Oracle SQL developer, SQL Server 2012, Oracle 10g, PL/SQL, T-SQL,MS Access, Windows 2007 server, Tera data, MS Office 2007

Confidential, VA

BI Developer / Analyst

Responsibilities:

• Checked the Abinitio graphs for adherence to corporate standards and best practices
• Validated Abinitio XFRs against the business requirements
• Worked on data Extraction and Analysis utilizing available applications/tools to query portfolio data and extract data as needed for reporting analysis/development or for customer delivery Analyze data for both reporting development as well as trend identification, event impact analysis, process measurement and improvement, and observation/summarization for se- nior management attention
• Conducted research and analysis and examined risk elements of portfolio/public data to present trends, assess risk, and pro- vide mitigation recommendations to management
• Developed adhoc/automated reporting for all levels of the organization
• Supported communications, training, and end user support efforts with reporting awareness and usage guidance
• Prepared and presented reporting to all applicable levels of the organization
• Used financial analytical tools to make projections for prospective financial performance.
• Analyzed financial data for prospective purchase, asset allocation, fee generation or other cash flow, using typically industry/ company standard analytical tools or measures.
• Determine cash flow, costs, profit margins, future cash flows, and alternatives based on varying assumptions and projected market or economic conditions.
• Contributed analysis to report being prepared for business unit management to aid in making financial, client, acquisition, or other business decision.
• Conferred with business unit management and staff to acquire operating or financial data for analysis. Using this data, con- ducted standard or ad hoc analyses to satisfy variety of management objectives.
• Developed month end analysis to summarize, reconcile, and report financial data from transactions, fee payments, accruals, or other cash flows, in order to track trends. Consolidated work done by other analysts into final tables or report.
• Developed/prepared and continually improved quarterly forecast process for particular business unit, product line, client group or market segment. Reported monthly actual performance against forecast and developed analysis for variances.
• Developed queries to obtain financial data requested by users within the company, including the data validation. Coordinated the development of data files, the validation in the acceptance phase, and the migration of the data requirements to the pro- duction.
• Played technical or project lead role on specific analytical project; provided guidance to less senior analysts; provided input to developing specific analytical or reporting objective.
• Worked on reporting and forecasting in an FP&A environment, as well as acquired knowledge of general accounting princi- ples (preparing and validating accruals/re-class activity, performing reconciliations, etc.)
• Involved in end to end implementation and enhancements on Mobile Banking App data starting from requirement gathering and dashboards development in Tableau Desktop.
• Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the sys- tem along with dashboard development.
• Created numerous dashboards in Tableau Desktop based on the data collected from Mobile Banking App by importing and blending data from MS Excel and CSV files along with Oracle SQL Server Databases.
• Developed Geo/Area Maps to show details on which states are most connected using the App vs. the least states.
• Created Bar Charts which is complied with data sets and added trend lines and forecasting on future usage of the Mobile App.
• Created Crosstab’s to display underlying data based on various graphs and charts created for further data analysis.
• Developed Scatter Plots and Area Maps to show states utilizing the Mobile App most vs. least.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed story telling be- hind the Mobile App usage with Quick Filters for on demand needed information with just a click of a button.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau Desktop to validate static and dynamic data for data validation.
• Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date live data and sent those into production after editing.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: UNIX, Oracle 10g, Abinitio 2.14/2.15, BOXI, Excelsius, Crystal Reports, Tableau 7.0 / 8.0, Autosys, Korn Shell Scripts, Quality Center, Sybase, TOAD, Sun Solaris 5.10, MS Office software, Visio, relational DBMS (Oracle, MS SQL Serv- er), SQL, Doors, Quality Center, ClearCase/ClearQuest, and Sharepoint