SUMMARY

• 7 years of IT experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and teh related Database Platforms.
• Extensive experience inTableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 6, Tableau 7 and Tableau 8.
• Involved in requirement gathering/analysis, Design, Development, Testing and Production rollover of Reporting and Analysis projects.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableau ServerandReports.
• Extensive TableauExperience in Enterprise Environment and Tableau Administrator experience including technical support, troubleshooting, report design and monitoring of system usage.
• Extensive experience on building dashboards using Tableau.
• Involved in upgrading Tableauplatforms in clustered environment and performing content upgrades.
• Expertise in writing SQL Queries, Dynamic - queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Proficient in designing Data Mart and Data Warehouse using Erwin Star and Snowflake Schemas.
• Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members.
• Well versed in using multi-dimensional expression (MDX) queries, mathematical formulas, and user-defined functions for developing reports from Multi-Dimensional OLAP Cubes.
• Strong analytical, logical, Communication and problem solving skills and ability to quickly adapt to new technologies by self-learning.

TECHNICAL SKILLS

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

BI Tools: Tableau 8.1

Tools and Packages: SQL Server Management studio, Toad, Microsoft Visual Studio, Crystal Reports

Databases: Oracle 8i/9i/10g/11g, MS Access, MS SQL Server 2000/2005

Programming Languages: SQL, PL/SQL, C, C#, ASP.Net, HTML, XML, XSL

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

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr. Tableau Developer

Responsibilities:

• Working closely with teh business users to gather requirements
• Designing, developing, testing, and maintaining Tableau reports and dashboards based on user requirements.
• Involved in trouble shooting of performance issues which was associated with Tableau reports.
• Utilized Tableau server to publish and share teh reports with teh business users. Also involved in administration tasks such as providing access to teh users and adding them to teh specific group.
• Trained teh users and helped them to improve and maintain their reports.
• Training onsite team using and creating Tableau report.
• Managing Testing cycle regarding teh reports and dashboard utilizing onsite and in inshore resources.
• Working noledge on Tableau Server / Administration.

Confidential, Dallas, TX

Tableau Developer

Responsibilities:

• Analysis teh metric dashboard reports and identified teh formulas and functionality of teh dashboard reports and digitizing teh metric dashboards to Tableau application.
• Published teh dashboard reports to Tableau Server for navigating teh developed dashboards in web.
• Scheduled teh published dashboards from Tableau Server on weekly basis.
• Sending teh dashboards to users by emails with teh help of admin team with subscriptions.
• Given training/demos to users on Tableau Desktop for development.
• Created Tableau worksheet which involves Schema Import, Implementing teh business logic by customization.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Built complex formulas in Tableau for various business calculations.
• Resolved various performance issues and analyzed teh best process distribution for different projects.

Confidential, CT

Tableau Developer

Responsibilities:

• Worked closely with teh business users to identify various KPI’s and designed solutions to enhance business decision-making.
• Participated in complete life cycle of teh project from project initiation, to development, to production support and maintenance.
• Strong understanding of CRM and ERP transactional data model and dimensional modelling, Data warehousing concepts and designing of Star/Snowflake schemas.
• Worked on Oracle BI EE Administration tool for customizing teh Physical layer, Business layer, Presentation layer and modifying it according to teh business requirements.
• To create Connection pools, import physical tables and define joins in teh Physical Layer.

Environment: Oracle Business Intelligence Enterprise Edition (OBIEE) 10.1.3, Informatica Power Center 8.1.1, Data Warehouse Administration Console (DAC), Oracle Delivers, Windows XP, Oracle 10g, SQL, PL/SQL, and TOAD 6.3/7.0.

Confidential, Windsor, CT

Tableau Developer/ OBIEE Developer

Responsibilities:

• Analysis, Design, Implementation and documentation for various projects for reporting aspect i.e. OBIEE metadata/logical/physical data models.
• Design, develop and implementation of complex OBIEE user interface objects.
• Did configurations for OBIEE (Multi User Development MUD, Usage tracking, iBot(scheduling), Security Model using LDAP authentication) and BI Apps ( Roles Responsibilities, security model)
• Analysis, Design, Implementation, documentations and BI specifications dat Incorporate OBIEE development standards & best practices as well as ongoing support for Data Warehouse.
• Created Tableau dashboards with teh data pre aggregated usingSAS.
• Worked on Physical, Business Model and Mapping Layer and Presentation Layer of OBIEE. Cashing options configured and defined overall cache strategy
• Worked on Initialization Blocks and Variables development to achieve security and personalized
• Worked on performance tuning of various OBIEE Reports / Dashboard
• Supported teh iBots scheduled reports 365*24*7

Environment: OBIEE 10.1.3.4, OBI Administration tool, Presentation services (Answers, Dashboards, Delivers), BI Scheduler, iBots, BI Publisher, Informatica 8.1.1, db2, SQL, Windows and UNIX, OS/390, Oracle10g

Confidential

MS SQL Server Developer /Analyst Programmer

Responsibilities:

• Carried out a Developer’s role on MS SQL Server 2000, MS Access Databases (using DTS, Stored Procedures and Views.
• Involved in developing teh SQL code for teh application.
• Solved various T-SQL issues using Query Analyzer.
• Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers.
• Created ad hoc T-SQL Queries
• Used BCP utilities, Data Transformation Services (DTS), Extract Transform Loading tool (SSIS) to populate data from various data sources, created packages for different data loading operations for application.
• Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support teh whole SSIS process workflow.
• Designed, Developed and Deployed reports in MSSQL Serverenvironment using SSRS.
• Working with Business analyst in converting data over to tableau using SQL/SAS/Excel data over to tableau
• Created cube structure for teh analysis of business condition and for creation of report using SSAS.
• Involved in designing and implementing teh Stored Procedures and Triggers for automating tasks.
• Worked on MS SQL Server tasks such as Data Loading, Batch Jobs, BCP, DTS and Indexes.
• Analyzed teh Reports, Tables and ETL process.
• Created and automated regular Jobs such as Daily/Weekly Report Generations.
• Used SQL Server profiler for auditing and analyzing teh events which occurred during a particular time horizon.
• Managed and Monitored System Utilization. Managed Backup and Disaster Recovery of teh systems. Managed teh security of teh servers as a part of administration duties.

Environment: T-SQL, MS SQL Server 2008, SSAS, SSRS, SSIS, XML, Windows 2000/2003/NT/XP, Microsoft .NET framework 3.5, MS-Excel.