SUMMARY

• 7+ years of development experience on Database Design and Development in SQL server 2008/2012 system in OLTP and OLAP environment.
• 5 years of experience in SSIS, SSAS (MSAS) and SSRS (MSRS) of MS SQL Server.
• 3 years of extensive Tableau Experience in Enterprise Environment, in Tableau 7.0, 8.0 and 8.1 as a Developer and Analyst.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau
• Excellent command on SQL SERVER 2012.
• Having experience in DBA tasks like back up recovery techniques, High availability, Security, Installation, Trouble shooting and Performance Tuning.
• Expert experience in ETL processes transferring/rewriting DTS packages to SSIS (SQL Server Integration Service) programs. Proficient in SSIS project design, implementation and troubleshooting and Erwin Data modeling.
• Extensive working experience in using/generating Visual Studio 2010 Business Intelligence Report, SQL Server 2012 SSRS or MSRS (SQL Server Reporting Service), ad-hoc reports, Crystal Reports development and deployment of Reports.
• Experience with ORACLE 10g,11g Database and Pl/Sql programming
• Solid knowledge and working experience in Installing, Configuring and Managing SQL server 2008/2012.
• Extensive experience with SQL Server and T-SQL in constructing tables, views, triggers, indexes, functions, stored procedures, user profiles, relational database models, data dictionary, data.
• Hands-on working experience in implementation of Backup and Recovery using DTS.
• Strong Excel skills and used pivot tables and slicers extensively.
• Experienced in data loads, database integration/conversions, and performance tuning, query optimization.
• Experience with software development life cycle (SDLC) and project methodologies
• Experience in Agile and Scrum Methodology.
• Extensive software development skills and experience in Object Oriented Analysis and Design.
• Experience in programming with C++, ASP.NET, Web Forms, XML Web Services, C#, Windows Forms, ADO.NET.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.

TECHNICAL SKILLS

Specialties: Data Visualization, Business Intelligence (BI), Software Management and SDLC, ETL, Data Collection.

Data Visualization: Tableau, Qlikview, PowerPivot, Excel, SSRS,SSAS, Visual Analytics, Business Objects XI/4.0

Relational Databases: MS SQL Server 2005/2008/2012, Oracle 8i/9i/10g/11g, MS Access.

Tools: and Packages SQL Server Management studio, Toad, Microsoft Visual Studio Languages SQL, PL/SQL, C, C#, ASP.Net, HTML, XML

Operating Systems: Windows 2008, Windows 2000/2003 Server, Data center, Windows NT, Windows 95/98/2000 XP, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Tableau Developer

Responsibilities:

• Created reports to users in Tableau by connecting to various data sources (MS SQL Server, Oracle, MS Excel, Netezza, .CSV).
• Generated ad-hoc Tableau reports based on user requirements.
• Generated Tableau Dashboards with filters, quick filters, context filters, global filters, parameters and calculated fields on Tableau reports.
• Combined multiple data sources by joining tables and using Data Blending.
• Generated Tableau reports with Trend lines, Reference lines and Bands and also generated several drill down and drill up reports.
• Worked on groups, sets, different calculation functions including Table calculations.
• Used multiple Measures like Individual Axes, Blended Axes, and Dual Axes.
• Created dashboards with the security using filters for the clients to measure cost saving.
• Performed end-to-end Data Analysis and ensured the data quality gaps are identified.
• Designed and developed Business Intelligence end to end solutions using Tableau.
• Published Workbooks by creating user filters and security, so intended teams can view it.
• Developed tableau dashboards with combination charts for clear understanding.
• Worked on various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Build complex calculations using advanced functions (ATTR, DATEDIFF, STR, IFs, nested IFs, OR, NOT, AND, SUMIF, COUNTIF, LOOKUPs and QUICK TABLE calculations).
• Created visualizations in Tableau using Excel data extract source, wrote Test Cases and documented the Test Results.
• Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau 8.1, SQL Server, Teradata, MS Access, Microsoft Office Suite (Word, PowerPoint, Excel).

Confidential, Jersey City, Morris Plains, NJ

Tableau Developer

Responsibilities:

• Scope of the project was to enhance the Mobile Banking App's systematic processes which were associated with Confidential Personal Banking division. Developed Tableau Dashboards for app usage data based on login time status, usage of pay bill capability, and transfer money to get better understanding of future enhancements.
• 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 system 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 behind 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 to ensure that the published dashboards are displaying accurate and up-to-date information.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop, Tableau Server, Oracle SQL Server, MS Excel, CSV, Win Server 2008 R2, Active Directory

Confidential, Montville, NJ

TABLEAU DEVELOPER

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• 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.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: Tableau Desktop 7 & 8.1, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel

Confidential, NYC, NY

TABLEAU DEVELOPER

Responsibilities:

• Read business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.
• Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.
• Created pie and bar charts and combined them into dashboards to show top content viewed by customers in each category including sports and news channels allowing interaction between the two charts for drill down analysis.
• Analyzed data from various databases and formatted it into graphs using Tableau Desktop.
• Created line charts to show over time in a breakdown of daily, weekly, quarterly, and yearly parameter numbers of viewers watching a particular sports channel.
• Blended data from multiple databases such as MS Excel and Oracle SQL database by assigning primary key from each databases.
• Developed geographic maps showcasing demographics broken into age, race, and income category that showed content viewed by individual customers across all content providers.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Executed and tested required queries and reports before publishing dashboards.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Administered user, user groups, and scheduled instances for reports in Tableau Server.
• Presented, interacted, and communicated with business and user groups for explaining the dashboards that I have created with the ability to change and view the data on the fly.

Environment: Tableau Desktop 6 & 7, Tableau Server, Oracle SQL Server, MS Excel

Confidential, Westlake village, CA

Tableau Developer

Responsibilities:

• Created Schedules and Extracted the data into Tableau Data Engine.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Developed dashboards in Tableau Desktop and published them on to Tableau Server that 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.
• Converted metric insight reports to tableau reports.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Executed and tested required queries and reports before publishing dashboards.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Extensively worked on Tableau Desktop, by creating Sears & Kmart Complex reports & Dashboards.
• Created Tableau scorecards, dashboards, Heat maps using show me functionality.
• Good Experience in publishing reports and dashboards to Tableau server Created and deployed Webi and Crystal reports through Info View.
• Responsible for setting up the Database logon info and parameters on Info View for the users to run the reports
• Enhance/modify existing reports by creating new Parameters, Formulas.
• Optimize various SQL queries to make the reports run faster
• Used Sql extensively in command objects of Crystal reports
• Migrated Universe/Reports from Development/QA to production.
• Used Crystal Reports to develop custom and dynamic reports.
• Created queries using add Command object in Crystal Reports 2008. Created linked, unlinked and on-demand sub reports.
• Created cascading prompts by creating List of values through Business View manager
• Created filters and row level security in Business view manager.

Environment: Tableau Desktop 8.1/8.0/ 7.0, Business Objects 3.1, IDT, CrystalReports, Web Intelligence, Oracle 10g, SQL Server 2008/2012, Info view, Windows 2008 Server and Java based Applications.

Confidential, Los Angeles, CA

Tableau Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models using ERWIN.
• Worked on Database design and Architecture.
• Involved in project planning, scheduling for database module with project managers.
• Created new Data source and replaced with existed Data source.
• Created Schedules and Extracted the data into Tableau Data Engine.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps
• Effectively used data blending feature in tableau.
• Defined best practices for Tableau report development.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Developed dashboards in Tableau Desktop and published them on to Tableau Server that 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.
• Converted metric insight reports to tableau reports.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop.
• See a comprehensive view of your sales pipeline and results.
• Access dashboards from any browser or tablet
• Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPI's.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Data analysis and Adhoc workbook creation using Filtering Measures and Dimensions.
• Designed staging tables as per the requirement and used for the report creation.
• Created WEBI reports with complex calculations.
• Designed and maintained Universes and exported them to the repository.
• Developed Webi reports on SAP BW Queries using BICS in Business Objects 4.0/4.1.
• Design and development of Xcelsius dashboards as per the requirement.
• Extensively involved in creating database packages, procedure functions, cursors and triggers using PL/SQL.
• Developed complex webi reports using combined queries, merging dimensions, complex functions at the report level and complex filters to satisfy the end user requirement.
• Experienced in working with grouping, ranking, report variables and different functions in WEBI.
• Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.
• Extensive knowledge in SQL Server 2008/2012, SSIS.

Environment: Tableau Desktop 8.1/8.0/ 7.0, BusinessObjectsXIR3, IDT, Crystal Reports, Xcelsius 2008, Web Intelligence 4.1/4.0/3.1, SAP BW, Oracle 11g/10g, SQL Server 2008/2012, Info view, Windows 2008 Server, .NET and Java based Applications.

Confidential

Business Object Developer

Responsibilities:

• Published reports in Business Objects Enterprise XI R2 using Central Management Console and publishing Wizard.
• Assigned Scheduling Rights as per the User Requirements
• Used multiple sub reports, pass through parameters and pass by parameter linking for generating complex reports for management
• Work with Business Users and team leads to develop system requirements, analyze data element and continuous end-user support.
• Work with production team to coordinate and assist in rollout of releases.
• Setup hierarchies in the Universe for providing drill down options in the reporting environment
• Created complex reports using user-defined functions like @variables, @prompt, condition Objects and Aggregate Awareness Functions for SQL enhancement.
• Worked with BO support in troubleshooting issues and provide logs as per request for resolving several complex issues
• Created various complex Reports and exported to Excel Spreadsheets for Analytical uses
• Provided solutions to various groups for scheduling reports using Packages and event based job scheduling.
• Coordinating with various groups in scheduling releases between environments.
• Deployment of Crystal Reports via various methodologies Central Management Console (CMC), publishing Wizard, Infoview, Import Wizard.
• Migration of Universes and Web Intelligence documents via Import wizard to maintain relationship between objects.
• Experience on Developing Crystal Reports.
• Daily reporting to Management on status, issues, migrations, escalations and progress.
• Created various types of reports of type Standard, Cross Tab, Drill Down, Sub Reports on Audit
• Database for investigating User activity and narrowing down issues.
• Assist Team in Optimizing system architecture.
• Assist with website deployment architecture (e.g. web servers, databases etc.) and code optimization.
• Designed and implemented Adhoc Reports, Extracting Data from an SQL Server database.
• Experience managing user accounts and group accounts in Crystal enterprise environment.
• Used Clear case Explorer to Take Backup of Webi Reports and Universe.

Environment: Business Objects XIR1/XI R2 SP2, Crystal Enterprise 10, Crystal Reports XI R1/ XI R2, Windows 2k3/2k, Universe Designer, Web Intelligence. Oracle 10g, Clear case

Confidential

Business Objects Developer

Responsibilities:

• Identified and road mapped the Business Requirements (functional & technical) with the Business users, which acted as a base for the project initiation and implementation.
• Extensively used Business Objects Designer to design and maintain Data warehouse Universe.
• Created New Universes and Managed existing Universes
• Migrate, upgrade and test the Business Object XIR3 content/environment
• Setup, execute, and test the assigned programs utilizing BO XIR3 WEBI and DESKI tools
• Creation of multiple Universes and Linked Universes.
• Design complex Web Intelligence and Desktop Intelligence Reports
• Plan the implementation of migration to different Environments in Business Objects.
• Involved in the Data Warehouse design process
• Develop Dashboards for the higher management of the company
• Worked on extensive features of Business Objects XI including Index awareness, Derived tables and Input Controls
• Creation of reports, working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created reports using WEBI, DESKI, full client.
• Analyzed the reports using the Drill Through, Slice and Dice.
• Trained the users in viewing/scheduling the reports using the Info view and Designed security model for users to access the report
• Responsible for Universe Designing, Hierarchy Building for Data Analysis and applied conditions in Business Objects.
• Designed, developed, tested and maintained highly complex reports.
• Use of BO Designer Module to implement Universes, linkages between tables, creating prompts and queries, parsing the Universes, applying contexts and alias tables to remove cyclic dependencies.
• Deployed the reports by using Import Wizard (between DEV and UAT) and archived the reports.
• Used Business Objects supervisor to create repository, creating and managing the users, giving access permission for Business Objects Reports.

Environment: Business Objects XI 3.1/6.5(Web Intelligence/Desktop Intelligence), Designer, Import Wizard) Performance Management, Oracle 9i, DB2, AS/400, SQL Server, Windows XP.