SUMMARY

• Overall 16 years of working experience in Information Technology industry in USA from year 2000. Initially was working on Projects in VB.NET with MS SQL Server or Oracle. Later moved to reporting tools of Crystal Reports and Business Objects. Currently working on Tableau Desktop and Tableau Server Admin.
• Around 3 years of experience as Tableau developer and Tableau Server Administrator.
• Around 7 years of experience in Crystal Report designing, including the ability to quickly gather design requirements and creating complex, professionally formatted, readable reports in Crystal Reports and converting cross - platform reports (Microstrategy, Oracle and Access reports) to crystal reports through redesign and development.
• As a Tableau Administrator was involved in Installation and configuration of Tableau Server.
• Regular checked Administrative view for Tableau Server operation.
• Creating Project, Sites, Site Users and Group. Provided site role for users and Groups. Thus provided permission to Content Workbooks and Data Source. Gave group to users.
• Used Command line tabcmd utility for Tableau Server Administration. Also used tabadmin utility form DOS Command to do Tableau Server backup. A restore of Tableau Server from Command line was possible when required.
• As Tableau Developer used Tableau Start Page to connect to a File (as Excel, Access, Text) or To a Server (as SQL Server, Oracle, DB2). Worked with Extracts as well as Live data. Used Joins on tables. Also used New Custom SQL.
• Used Connect page and Data Pane of Workspace to build Data Source Metadata with Data hierarchies, splitting of original data fields, hiding fields, renaming fields, creating custom folders for fields, changing datatypes, creating calculated fields. Sets and/or Groups were created. Later published and/or saved the data Source.
• Charts built included Pie, Scatter Plot, Filled and Symbol Map, Bar Charts, Line/Area Charts, Bubble Charts, Bullet Charts, Box Plot, Tree Map, Word Cloud, Packed bubbles, Dual Axis chart, Histograms, Side by Side Bar,
• Built Dashboards containing worksheets, legends, interactive filters, text, image, webpage and blanks. Layouts were built considering the display devices using Vertical and Horizontal objects.
• Stories with story points were created as narrated walkthrough of worksheets and dashboards.
• Ability to understand and write SQL and Stored Procedures in Oracle and MS SQL Server.

TECHNICAL SKILLS

Reporting Tools: Tableau Desktop 9.3, Tableau Server, Crystal Reports 8.5/9.0/XI R 2/2008/2011/2013 Database MS Access, Oracle 10g/9i/8i, MS SQL Server

Packages: Java, VB.NET, MS Office, MS Word, MS Excel, MS Power Point

Languages: SQL, PL SQL, Transact SQL, SQL*PLUS

Tools: and Utilities TOAD, SQL Developer, SQL Server Management Studio, Scrum Agile Methodology, and Version Control tool Tortoise SVN.

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

Tableau Developer/Administrator

Responsibilities:

• Generated workbooks, dashboards and stories for the Integrated Eligibility System administrative application against the DB2 database.
• Used the DB2 database data by accessing using the MobaXterm for tunneling the data.
• Publishing of the Tableau Workbooks was done to Tableau Server from the Tableau Desktop. Worded as Tableau Site Administrator responsible for the content on the Tableau Server Site.
• Published Workbooks and Data Sources in appropriate projects giving Name, Description and Tag. Provide permissions and set schedules for extract while publishing.
• Added schedules in Tableau Server for ‘Extract refresh’ and subscription tasks.
• Generated Metadata with renamed fields, hidden fields, hierarchies and custom folders. And saved as .tds Tableau Data Source File. The tableau data source was published to the Tableau Server for other Tableau users. This helped reuse of the Metadata for several workbooks.
• Both Data Blending and Cross Database Joins were used to connect to multiple database.
• Built Maps Data visualization with custom Geocoding. This was reused several times and helped user of the workbook to understand the data right like a picture.
• Built Data Visualization using Show Me and also by use of drag and drop of Dimensions and Measures on to the shelves and Mark. Used Highlighters, Legends, interactive Filters and Parameters and showed ToolTips and labels to create Views.
• Data Visualization Models used Analytic Pane features as Trend Lines, Lines and Forecasting.
• Bar charts representing finance, Stacked bar charts representing finance for Dimension fields, Line/Area Charts for continuous Date field Dimensions, Stacked Area Charts used to represent finance over several years, Pie charts to represent finance over dimensions field, crosstab representing numeric data, Scatter plot with Marks clearly showing trend line were all generated and were made part of the data visualization.
• Built interactive filter to filter data right from a worksheet to the complete dashboard. Filtering was done at the record level or the data source level or the aggregate level. Filter were used along with the parameter.
• Dashboards were built with layout of the worksheets in consideration to show them efficiently on Tableau Server and on i-pads, mobiles and normal computers.
• Used both SQL and TOAD to access data for running queries in development process.
• Published workbooks, dashboards and data source to the Tableau Server. And scheduled for the worksheet to be emailed regularly and for the extracts to happen to the data sources periodically.

Environment: Tableau Desktop 10.0, DB2, Java, MobaXterm, Tortoise SVN, SQL Developer, TOAD, Excel, Windows 10

Confidential, Boise, ID

Tableau Developer

Responsibilities:

• Interacted with the Business stakeholders to gather requirements for building Tableau Workbooks for the Customer Care and Billing application.
• Used the Tableau Start Page to connect to Oracle 10g Database. Used the Data Source Page Left Pane, Canvas Pane, Data Grid and Metadata Grid Pane to create a Metadata with sorted data, hidden fields, duplicate fields and hierarchies for fields. Generated calculation, alias and split fields. These were saved as Saved Data Source and published as .tde data source file on Tableau Server.
• Tableau Worksheets were built with Quick Filters, Highlighters, Legends and Parameters. Each of which provided the user interactivity on the worksheet. Tooltip was used to display the relevant information when user hovers over a view.
• Chart Types built on the Tableau worksheets were Bar Chart, Line/Area Chart, Pie Chart, Scatter Plot, Box Plot, Bubble Chart, Tree Map, Heat Maps, Funnel Chart, Waterfall Chart and others. Show Me was used as a guide to build these charts.
• Filtering of data for the view was done on Filter Shelf, with Quick Filters or in the view, Legends with Keep only or Exclude options. Filtering was done for pill types of Dimensions, Measures or Date fields with their relative options with filter shelf or as interactive filter.
• Parameters where added for interactivity and flexibility to a workbook by end user and were incorporated in filters, sets, line and calculated fields.
• Grouped data represented by paperclip icon in data pane was generated in visualization by picking marks or headers. Grouping of data was also done from data pane. Visualizations were based on aggregations of grouped members and others for non-grouped members.
• Constant Sets were created from marks on view. Dynamic Sets were created form dimensions applying conditions, general list or Top N. Combined sets with same dimensions were created using Venn Diagrams. And used in color with IN/OUT for color.
• Prepared metadata with hierarchies so that a view could be drilled down to lower levels of details. Drilldowns were also done on date fields both as discrete and continues dates using Tableau’s inbuilt functionality for drilldown on dates.
• Sorting of data was done on view by Quick sort or sort on header/legends or by sort at pill.
• Dashboards were created of automatic size with horizontal and vertical layout container containing text, images, web-pages apart from Tableau worksheets. Titles of dashboard/worksheets were turned on or off. Filters and Legends were appropriately added for complete dashboard. And for some dashboards even the views on the dashboard were made to act as filter.
• Stories with story points with worksheets and dashboards were made for sequential presentation.
• Published workbooks to Tableau Server. Set subscription and scheduled database extract. Set the permissions for user and group on the Tableau Server.

Environment: Tableau 9.3, Oracle 10g, MS SQL Server, Excel, Windows 7

Confidential, Dallas, TX

Crystal Report Team Lead/ Developer

Responsibilities:

• Generated Crystal reports for Financial Data against issuance and redemption of Fuel Rewards against the Oracle 10g database.
• Analyzed business requirements and design the layout of the reports.
• Created various documents regarding the design and testing procedure that was followed while creating the report.
• Worked on multi-level grouped reports while using section expert that require running totals, SQL expressions, graphs, sub-totals, sub-reports, and conditional display of groups, database fields and text objects using conditional formatting.
• Extensively used features like suppress, drill-down, hide, new page after and split sections.
• Created linked, unlinked sub reports. These sub-reports were built to open on-demand or in line to the main report.
• Applied formatting for reports and developed reports with necessary Formula fields, Parameters fields, Group and Record Selections.
• Strong experience in working with advanced features like incorporating a parameter into a formula, parameter with multiple prompting etc.
• Involved in deploying and bursting reports in CMC and assigning user/report security.
• Tested the created reports in development environment by creating various records against the various scenarios of hardware sales and service. Later moved these reports to production environment using set data-source location.
• Extensively used Toad for testing the accuracy of records in the report.
• Changed and Performance tuned old Crystal reports as per the change in the requirement.
• Exported Crystal Reports into various formats like PDF, HTML, EXCEL, and WORD for the users.
• Worked in Scrum a form of agile that optimizes the estimation and execution of work. As a team lead allocated Scrum teams work in fixed intervals, known as sprints, iterating on the product over and over.

Environment: Crystal Report 2011, Oracle 10g, Toad, Excel, Windows 7

Confidential, LA, CA

Crystal Report Developer /Analyst

Responsibilities:

• Involved in the development of reports using Crystal Reports XI and SQL Server 2000 as database.
• Actively involved in gathering end user requirements, user/system documentation, user and testing developed reports for final deployment.
• ODBC connection set up in Administrative tools in Control Panel to the SQL Server 2000 database.
• Wrote the SQL queries required for the reports in SQL Command. Also used tables, views and store procedures for connecting to the database in the database expert.
• Created Standard Reports, Cross-tab Reports, Sub Reports and Drilldown Reports using Crystal Reports XI release 2.
• Displayed pie charts, bar graphs more understandable for top-level management in the Reports.
• Extensively involved in using of formula fields, parameter fields, Group selection and record selection in Crystal Reports.
• Published Reports on the web using BO Enterprise CMC, Infoview and BO XI Publishing Wizard.
• Involved in Creating Users, Folders and Groups in CMC.
• Involved in scheduling the monthly and Weekly Reports using Business Object Enterprise XI.
• Extensively involved in writing Views, Stored Procedures and Queries.
• Performance tuned old Crystal Reports.
• Trained users to export Crystal Reports into various formats like, PDF, HTML, EXCEL, and WORD.
• Worked extensively on writing of the report specifications which included
• Documentation of the tables, views and store procedures used in database Expert.
• Documentation of the column or formulas for grouping of dataDocumentation of parameters required for the report.
• Documentation of formulas with a brief explanation.
• Documentation of related information of the report to build sub-report.
• Created mock up reports in Microsoft Excel

Environment: Crystal Report XI R2, Business Object Enterprise XI, Oracle 10g, Excel, Windows XP

Confidential, Grand Rapids MI

Crystal Report Developer

Responsibilities:

• Worked on Visual Basic Application and Reports for System Monitor a logistic system inside the Distribution Center of Wal-Mart.
• Performed the analysis and collection of prior year Financial and Sales data using MS Access.
• Generated Standard Crystal report specification for the all the required report and developed reports based on Financial and Sales data against SQL Server 2000.
• Developed some major financial reports like Monthly run rate, Monthly Outlook, Operating Profit and Loss, Sales reports like Comparative Sales (Prior Year and Current Year), HR report like Headcount Summary report(reporting off SQL Server 2000).
• For upgrade moved the Legacy reports which were in Crystal reports version 8.5 to Crystal Reports XI R2. Even the reports which were in Crystal reports version 9.0 were upgraded to the more recent Crystal Reports XI R2.
• The Data Dictionary concept of holding SQL query for Crystal reports 8.5 was changed to more current SQL Command of Crystal Reports XI R2 as part of migration.
• Built report which generated pages having a common data (retrieved from single table of Sales or Forecast) in bar chart (dual axes or single axes) and in cross tab.
• Using cross tab expert set row and column data and summarized field data suppressing (or not suppressing) row (or column) grand totals.
• Published the reports on Business Objects XI Server and scheduled to run as per required by the user. Configure success/failure notification and email notification to specific users.
• Identified specific groups and users as per business requirement and defined their rights and access levels for viewing, scheduling, running, exporting etc. of reports.
• Used the Central Management Console (CMC) to perform user management tasks such as setting up authentication and adding users and groups etc.
• Applied formatting for reports and developed reports with necessary Formulas and Parameter fields.

Environment: Crystal Report XI R2 and Crystal Report version 9.0 and 8.5, Business Object XI, SQL Server 2000, MS Access, VB.NET

Confidential, Fairfield, CT

Crystal Report Developer

Responsibilities:

• Developed Reports using Crystal Reports 9.0 / v10.
• Generated Crystal reports for System using ODBC connection set up in Administrative tools in Control Panel to the Oracle 10g database.
• Used SQL Command along with tables, views and store procedures for connecting to the database in the database expert. Proper linking of the tables/views/SQL command was done in link tab of the database expert as per the database schema and business logic.
• Adding and deleting objects, sizing objects and sections working with guidelines. Managed sections by controlling visibility of sections in a report by hiding or suppressing sections. Kept section together or splitting sections as per the situation.
• Used format editor to format fields of data type Date, number, string, boolean, currency on the report.
• Used formula workshop to create global, shared and local variables used in complex reusable formulas.
• Report contained sub-reports which were linked to the main report by the link option of the report. Proper alignment was made to align the sub-report data to the main reports information. Sub-reports were both inline sub-report and on-demand sub-reports. Splitting of sections was done to avoid overlap of the data when the sub-report data grew when there were more records in sub-report.
• Cross tab and charts were used on reports to show summary level information.
• Exported reports into different formats like PDF, Excel, HTML, RTF (Microsoft Word), Editable RTF etc,
• Managed the BO Enterprise with CMC (Central Management Console), CCM (Central Configuration Manager).
• Used SQL Expression fields for server side queries.
• Involved in user signoff, QA and User, Interaction with the End Users.
• Wrote Stored Procedures and Views for faster Report Access.

Environment: Crystal Reports 9.0/10, Crystal Enterprise 10, Oracle 8i, TOAD, Business Objects and XML

Confidential, Richmond, VA

Crystal Report Developer

Responsibilities:

• Designed & developed Natural Work Row Team Summary Report (NWT) which displays Weight, Ventilation, Circumference, Process Standards, Production in Last 7 days, Production in Last 30 days, Uptime, Downtime etc.
• NWT report has got around 51 Sub-Reports and displays almost everything about the Cabarrus Production Unit with Graphs, Summary and Details.
• Designed the report in such a way that it takes common Parameters for all the 51 Sub Reports.
• Trained all the Users of the Reports.
• Gathered user requirements, draft specifications, design and deployed reports using Crystal Reports Designer. Responsible for drafting documentation for end user usage and developed materials.
• Created Stored Procedures, Views, Queries, and Templates to produce the reports.

Environment: Oracle 9i, PL/SQL, SQL Navigator, MS Access 2000/Reports, MS Windows 2000, Crystal Enterprise 8.5, Crystal Reports 8.5.

Confidential, Bethesda, MD

VB.NET and Crystal Report Developer

Responsibilities:

• Development of VB.NET application Invoice Management System.
• Developed and published several Crystal Reports ranging from complex drill-downs, cross-tab reports and charts.
• Applied formatting for reports and developed reports with necessary Formula fields, Parameters fields, Group and Record Selections.
• Created linked, unlinked sub reports. These sub-reports were built to open on-demand or inline to the main report.
• Scheduled and configured the reports on to the Crystal enterprise server.

Environment: SQL Server 2000, MS Windows 2000, Crystal Enterprise 8.5, Crystal Reports 8.5, VB.NET.