SUMMARY

• Around 6+ years of experience in Software Development life - cycle along with Business Intelligence Tools like Tableau 7/8/9, Business Objects (5i/ 6i/ XIR2/R3.1/BI 4.0), Crystal Reports and Xcelsius. Experience in PLSQL, SQL, TSQL
• Wide-ranging experience inTableau Desktop and Tableau Server in various versions of Tableau7.0,Tableau8.0/8.1,Tableau 9.0
• Capable in Full Life Cycle Development of Reporting Projects which includes Requirements gathering/analysis, Design, Development, Testing and Production rollover
• Strong expertise in using Tableau Software as applied to BI data analytics, reporting and dashboard projects
• Expertise on using OLAP tools Business Objects BI 4.0/XIR3.1/XIR2/6.x/5.x (Designer, Reports, Central Management Console (CMC), Central Configuration Manager (CCM), Report Conversion Tool, Web Intelligence, Desktop Intelligence, Web Intelligence Rich Client (3.1) and Supervisor)
• Implementing and working experience in Crystal Reports XIR2/10/9/8, and Crystal Xcelsius and designed Xcelsius Dashboards using QaaWs, Live office and XML sources
• Experience in Migrating Universes, Reports to newer versions and documenting the whole process during the project life cycle
• Implemented Derived Tables, Aggregated Tables using Aggregate Awareness concept in the Universe and responsible for creating Indexes, views to increase the performance of the universe
• Experience in SQL Server 2008/2005/2000 (database triggers, materialized views, In-line views, Packages, stored procedures, functions, and database constraints), Oracle 10g/9i/8i
• Expertise in writing and implementation of the packages, triggers, stored procedures, functions, views, materialized views, indexes at Database level using PL/SQL and oracle
• Practiced in writing SQL queries to debug data and to analyze query
• In-depth knowledge in formal Systems analysis design, implementation of Operational/Database systems, utilizing Oracle RDBMS Methodologies
• Experience in Migrating Business Objects from R2 to 3.1 and 6.5 to R1/R2/3.1
• Experience in Business Objects Administration on both Windows and Unix platforms
• Customized Auditor process using Business Objects & Post-Production Support for 24/7 system
• Trained CSRs on Tableau software
• Experience in Developed universe using Information design tool (IDT)
• Experience in loading Data for different environments
• Responsible for the design and implementation of Business Objects Enterprise in a large business operational reporting and analytics environment
• Worked with the ETL team and Data modeling team in the creation of data warehouse architecture and in the creation of design documentation and implementation
• Expertise in Universe designing/developing and generating reports with complex, business views, ad-hoc, dashboards, list of values (LOV) along with user acceptance test (UAT).
• Extensively used Business Objects Reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Grouping, Graphs and Breaks, Formulae.
• Demonstrated expertise in the use of Star-Schema Modeling, Snowflake Modeling, Fact, Dimension tables and Dimensional modeling using Erwin tool
• Having Experience in designing stunning visualizations usingtableausoftware and publishing and presenting dashboards on web and desktop platforms
• Trouble Shooting, Performance tuning and resolving issues within Tableau reports and dashboards
• Mastered the ability to design and deploy rich, thoughtful visualization & Visual Analytics using Tableau
• Created bubble charts, Scatter Plots, Heat Maps, Filled Maps according to deliverable specifications
• Practice in creating different visualizations using Bars, Lines and Pies, Maps,, Histograms, Bullets, and Highlight tables based on different scenarios
• Experience in Installation, Configuration and administrationof Tableau Server in amulti-serverandmulti-tierenvironment
• Established Best Practices for EnterpriseTableauEnvironment and development processes. Fashioned numerous interactive dashboards and worksheets using Tableau Desktop.
• Involved in Exploring, Designing, Building, QCing and Deployment the high level dashboards for Board of Directors, Marketing Decision makers, Finance for critical metrics using Tableau tool.
• Worked on Live Office objects and QueryAsAWebservice (WSDL’s) while developing BO Executive Dashboards
• Involved in Testing Phase to check the Reports for Data Accuracy
• Provided training for end users for generating their own report including complicated report.
• Capable to understand business problems and able to apply technology to formulate workable solutions according to the environment with excellent Interpersonal and Communication Skills with a sense of ownership
• Strong Analytical and Problem Solving Skills with ability to work independently and in team environments, simultaneously on multiple projects with competing priorities
• Skilled to synthesize substantial volumes of information
• Motivated, Reliable, Respectful, Friendly and Innovative

TECHNICAL SKILLS

Reporting Tools: Tableau, Business Object suite (XI R3.1/R2/6.x/5.x), Business Objects BI 4.0, SAP BW, Web I XI/6i/2.6, Designer, Reporter/Desktop Intelligence/Web Intelligence Rich Client (3.1), Supervisor, Broadcast Agent, Info view, Crystal Reports 2008/XI/10, Crystal Enterprise, Central Management Console, Xcelsius, QaawS, Live Office, Xcelsius 2008/4.5.

ETL tools: SQL Loader, Informatica Power Center 8.1, 7.1, 6.2.

Databases: Oracle 11g/10g/9i/8i/7.3, SQL Server 7.0/2000/2005, Sybase, DB2, Teradata and MS Assess.

Data Modeling Tools: ER Studio, VISIO, Dimensional Data Modeling (Star Schema, Snow-Flake, FACT Dimensions), ERWIN 6.1/4.5/3.5., iGrafx

Languages: SQL, PL/SQL, C, C++, JAVA, J2EE, HTML, XHTML

Operating systems: UNIX, LINUX, Windows 98, XP, 2000/NT.

Application Servers: Web Logic, Web Sphere, Tomcat.

Software Packages: MS OFFICE

PROFESSIONAL EXPERIENCE

Confidential, Portland, OR

Tableau Developer/ Administrator

Responsibilities:

• Participated in requirement gathering, analysis and structuring of Business Intelligence objects reports based on user requirements and conducted meetings every month for group of Directors to help them understand how their units are doing
• Grant server access to team members for live connections
• Developed Test Scripts and Training modules for end users
• Developed reports using custom SQL queries and created .tdsx, .tde and .tds files and Created four reports and filtered them by various measures and dimensions
• Blended data from multiple databases into one report
• 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.
• Created interactive dashboards by combining views and reports inTableauDesktop that were presented to Business Users, Program Managers, and End Users
• Using MS Excel, charts are converted into Crosstabs for further underlying data analysis
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel
• Designed and developed monthly, quarterly and yearly reports at branch and bank level.
• Concerned in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance

Environment: SQLQueries, .tdsx, .tde and .tds files, TableauDesktop 8.1 & 7,TableauServer,MS Office Suite,Oracle SQL ServerR2, MS Excel

Confidential, Boston MA

Tableau Developer/Business objects developer

Responsibilities:

• Participated in requirement gathering, analysis and structuring of Business Intelligence objects reports based on user requirements and conducted meetings every month for group of Directors to help them understand how their units are doing
• Modifying the existing universes, adding new objects
• Worked as an administrator in creating users, folders and managed the access privileges in Windows
• Involved in understanding the reporting requirements and providing Tableau reporting solutions
• Develop, maintain and document highly visualized comprehensive dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges
• Work with subject Matter Experts to identify data relationships, report field mappings and translate them into technical requirements for development
• Involved in building the interactive visual reporting Dashboards in Tableau, contains charts of key metrics for the executive leadership team
• Design mockups/wire frames for various reports by using MS Visio and Excel.
• Write and execute SQL scripts, Stored Procedures to develop reports and perform data/report validation
• Responsible for creating file based events and scheduling various Webi reports to different business users on daily, weekly and monthly basis
• Created multiple breaks, sorts and complex variables in the reports
• Created reports using Business Objects using functionalities like drill down, @functions, cross tab, master detail tables and formulas, etc
• Used Prompts in the reports as well as the Universe to create more interactive reports for the users
• MS EXCEL: Experience in validating and Analyzing data in worksheets using sorting, filtering, Vlookup, creating PIVOT tables, charts
• Trained the power users/end users in Business Objects
• Implemented breaks and sections in the reports for white spaces and better navigation.
• Created dashboards, graphs using Crystal Xcelsius. Personalized the dashboards to reflect user-specific alerts and metrics to track critical Key Performance Indicators (KPI).
• Expertise in creating executive Dashboards using Crystal Xcelsius by importing data from excel file to create the visualization using Live Office
• Extensively used Web Intelligence Info view, reporter and explorer for querying, reporting and analysis tasks
• In Info view, implemented customized logins at application level and provided password-reset options to the users
• Involved Design, Development and Implementation of Reports using Crystal Reports Developer XI. Created Sub reports called from the main report to implement the business logic
• Developed reports containing Crystal Formulae, SQL Expressions, Selection Criteria, and Sub Reports etc

Environment: Tableau 8.0/ 8.1, SAP Business Objects XI 4.0 (Desktop Intelligence, CMC, CMS, Application Foundation, Data Integrator, Web Intelligence, Designer, Universe Builder, Import Wizard), Oracle 10g, BI 4.1, Xcelsius Dashboards, Crystal Reports, iGrafx, MS office.

Confidential, Phoenix, AZ

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements andanalyzingdata sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop
• Understanding of relational database structures, theories, principles, and practices
• Interacting professionally with a diverse group, including executives, managers, and LOB
• Find ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports
• Experienced with the design and development of Tableau visualization solutions
• Responsible for Developing a Dashboard and preparing ad-Hock Reporting.
• Working on generating various dashboards in Tableau server using various sources such as Teradata
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports
• Background in installing and upgrading of Tableau server and server performance tuning for optimization
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks
• Preparing Dashboards using calculations, parameters in Tableau
• Creating calculatedfields,groups, sets and hierarchies etc
• Creating data blending in case of merging two different datasets
• Analyzing and solving the issues in order to effectively develop technical solutions to their requirement

Environment: Tableau Desktop 6.02, 7.0,8.0 Tableauserver / Administrator, tabcmd, SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server, Java, Microsoft office 2007.

Confidential

SQL consultant

Responsibilities:

• Involved in logical and physical modeling of the database
• Successfully implemented physical database on MS SQL Server 2000. Supported complex relationship using triggers
• Tuned database by creating proper Indexes on different tables that improve the performance of T-SQL queries on the database
• Facilitated simplified access of database for end users using de-normalized views and created triggers on them to maintain to database integrity
• Created audit trails of activities on database using triggers on backend
• Implemented the business logic and processing of the payment by developing stored procedures and scripts
• Created Cursors to facilitate the users (credit officers) to scroll through the Queues to perform manual operations on the payment
• Used SQL Server Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary
• Environment: MS SQL Server 2000, T-SQL, Visual Basic 6.0 and windows NT

Environment: SQL Server 7.0/2000, T-SQL, VB 6.0, Windows NT/2000 server.