SUMMARY

• Over 8 years of experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Extensive experience inTableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7, Tableau 8 and Tableau 9
• Involved inRequirements gathering/analysis,Design, Development, TestingandProduction rollover of Reporting and Analysis projects
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinTableau ServerandReports.
• Extensive experience on building dashboards using Tableau.
• Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
• Expertise in writing SQL Queries, Dynamic - queries, sub-queries and complex joins for generating Views.
• Strong experience in Installation and Configuration of Cognos on Windows platforms.
• Expertise in Cognos 8 & 10 Query Studio, Report Studio, Analysis Studio, Access Manager and Cognos Connection.
• 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, Data Collection.

Data Visualization: Tableau, Cognos, Qlikview, PowerPivot, Excel

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

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

Languages: SQL, PL/SQL, HTML, XML, XSL

Web/App Servers: Apache Tomcat, Web logic Server 8.1/9.2/10, JBoss

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

Configuration Management Tools: Visual Source Safe, Clear Case

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Tableau Developer

Responsibilities:

• Involved in System Analysis & Design of the Enterprise Data Visualization Architecture
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications
• Designed various practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, published it in various Tableau workbooks for Confidential Analytical Projects and Data Visualization teams
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server
• Designed and implemented near-real-time monitoring Dashboards for Tableau Server and Visualization users
• Designed Self-Refreshing Activity Monitoring Dashboards for Information Analytics & Innovation Portal.
• Prototyped Visualization of Time Series and Data Transparency in tableau for attendance, payroll, and benefits data Integration
• Optimized Tableau Workbooks and Background Tasks for Targeted Interactions Analytics
• Successfully administered user, user groups, and scheduled instances for reports in Tableau.
• Created scripts on windows task scheduler for auto sync of users from Active Directory groups.
• Improved performance by tuning Operational Dashboards for Oracle and SQL Server based Data Warehouse
• Defined best practices for Tableau report development.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues
• Worked on various complex SQL Queries to implement the business logic.
• Interacted with the users and troubleshooting the problems involved with the reports, dashboards and problems related to the privileges.

Environment: Tableau Server v7/8, Tableau Desktop v7/8, SQL Server 2008/2012, Oracle 11g, Team Foundation Server, Visual Studio 2012.

Confidential, Secaucus, NJ

Tableau Developer

Responsibilities:

• Designed Visual Reports and interactive Dashboards in Tableau for Students Behavior Frequency Analysis for the Individualized Education Program
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Created and assisted users in Tableau dashboard development
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Worked on several complex visualizations that all had to do with improving the programs offered to various schools in NYC.
• Developed business process and technical design documentation for each reporting service developed in this project.
• Optimized queries by looking Confidential Execution Plan for better tuning of the database.
• Developed internal and external performance management dashboards enabling business intelligence reporting for application portfolio.

Environment: Tableau Server 7, Tableau Desktop 7, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, Oracle 11g, Toad, MS Office, Visual Studio 2010.

Confidential, Vernon Hills, IL

Cognos Developer

Responsibilities:

• Application development, reporting and documentation of patient reports. Extensively used Query Studio for developing Ad hoc reports. .
• Created multiple reports from simple to complex that involves bursting of reports, dashboards, drill through and conditional variables.
• Developed various dashboard reports, chart reports as per user requirements.
• Used conditional formatting and conditional blocks to display different sets of data based on different conditions.
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.
• Worked with Complex reports in Report Studio using Master Detail Relationship, drill through, burst options, cascading options and Prompts depending on user requirements.
• Customizing Cognos Connection Portal based on user specifications. Scheduled Reports to run on Monthly, Weekly and daily basis as per the requirement.

Environment: Cognos 10 (Report Studio, Analysis Studio, Query Studio), SQL Server.

Confidential, Arlington, VA

Cognos Developer

Responsibilities:

• Analyzed given reports and reporting Confidential the transactional level is furnished via Cognos Impromptu.
• Created Tables in SQL Server and used these tables as input, Catalog tables and folders were created in Impromptu.
• Involved in the design and development of reports in Report Studio.
• Used a lot of prompts like Date, Search & Select, and Value in the report.
• System study and requirements documentation.
• Created Cognos cube.
• Understood the source system and interacted with users to acquire the elaborate technical and business requirements and required documentation for clear understanding and traceability of requirements.
• Installation and configuration of the Cognos 10 in Development environment.
• Created Star schema dimensional model.
• Created Dashboard reports using the Cognos Report Studio.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple
• Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Trained end users effectively to use reporting tool, to build and customize their ad-hoc reports.
• Performance tuning of the reports implemented by creating summarized tables, views and appropriate indices.
• Involved in creating the User Training manual to help the Business Users understand the reporting architecture.
• Documented the Lessons Learnt and Best Practices.

Environment: Cognos 10 (Report Studio, Analysis Studio, Query Studio), SQL Server.

Confidential

HR Analyst

Responsibilities:

• Increased Leadership visibility into the organization by making information and its trends easier to obtain and compare.
• Provided guidance to ETL and Data warehousing teams to structure Human Capital Information in a meaningful, useable manner.
• Build relationships with business leaders to better understand human capital analysis needs.
• Designed and implement human capital analytics to address existing talent and business issues, such as attrition, performance, growth or cost reduction.
• Build complex insightful reports, mine data to detect for patterns, opportunities and insights using Teradata, Cognos and other analytics software.
• Worked with business partners to identify opportunities to increase Human Capital decision-making capabilities through data driven analyses.
• Interpret and communicate analytical results and findings to business partners and senior management in a clear, concise and effective manner.
• Managed the relationship with related business partners and ensure that analytic projects are delivered in a timely manner.
• Participated in Workforce Planning, Predictive Talent Analytics, Organizational Analytics, HR Optimization and Scorecards, as well as joining up with business partners in Operations, Risk, Technology and other domains to provide broader solutions
• Utilized data from multiple sources to find correlations between employee attributes and performance.
• Provided HR and Business leadership with forecasts and projections related to employee and business growth
• Participated in key diversity efforts, such as equal opportunity / hiring analyses
• Supported the design and development of critical analytic assets such as metrics, measurement frameworks, data models, analytic applications and data visualization tools
• Coordinated end-user training and documentation and provide second line support to power users who develop reports for their departments.