SUMMARY:

• Over 7 years of experience in Tableau and Cognos Business Intelligence Development and a wide range of progressive experience in providing product specifications, design, analysis, development, documentation, coding and implementation of business technology solutions.
• Experienced in creating Tableau reports and dashboards with rich graphic visualizations.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and making use of actions, other local and global filters according to the end user requirements.
• Experienced in creating POC Dashboards using Workspace Advance.
• Have a strong understanding of relational database concepts and extensively worked on databases like IBM DB2, Oracle 11g, SQL Server, MongoDB and Teradata.
• Hands-on experience in working with Report Studio for model design, report bursting for dynamic report delivery, Ad-hoc reporting and advanced report authoring.
• Expertise in Metadata Modeling - Advanced Relational Model as well as Dimensional Modeling with Cognos recommended approach.
• Good working experience on creating Stored Procedures to implement the business logics at the back-end and import them to Framework Manager to generate reports.
• Good understanding of Data warehouse Architecture, data modeling and dimensional modeling using Star Schema and Snowflake Schema.
• Experienced in interacting with business users to analyze the business process and requirements and transforming requirements into screens, designing OLAP and OLTP databases, documenting and rolling out the deliverables on time.
• Strong Analytical and problem solving skills.

TECHNICAL SKILLS:

Reporting Tools: Tableau 6.0/8.0/8.2, IBM Cognos BI Suite Cognos 10.1.1/8.3/8.4 , Report Studio, Query Studio, Framework Manager, Analysis Studio, Cognos PowerPlay, Cognos Transformer

Databases: IBM DB2, MS SQL Server 2005/2000, Oracle 11g, Teradata, MongoDB

Data Modeling: Star and Snowflake Schema Modeling, Facts & Dimensions.

Web Technologies and Scripting Languages: ASP.NET, C#, HTML, CSS, Python, JavaScript, Node.js

Other Tools: ChangeMan, IBM Data Studio, Informatica

Operating Systems: Z/OS, Windows Family, iOS

PROFESSIONAL EXPERIENCE:

Confidential, Milpitas, CA

Tableau Developer

Responsibilities:

• Worked with HR team and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
• Utilized different features of Tableau software like linking data from different data source connections in one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, and Filters (Local, Global) for various analytical reports and dashboards.
• Created Interactive Dashboards and guided navigation links within the Dashboards.
• Projected and forecasted future growth in terms of revenue generation.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Developed storytelling dashboards and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters.
• Published Workbooks on tableau server by creating user filters for user authentication and user restrictions where only appropriate teams can view it.

Environment: s:Tableau 8.0/8.2, Oracle 11g, MongoDB, JavaScript, Node.js, Python, HTML, CSS and Windows 7 Professional.

Confidential, Chicago, IL

Tableau Developer

Responsibilities:

• Created Sets, Parameters, custom Geospatial sheets, advance calculations, Calculated Fields, and functions for customizing calculations like dynamic sorting, filtering, parameter driven analysis etc.
• Developed complex visualizations with multiple sources using Tableau Dashboards and multilevel queries using joins & union data sets.
• Developed Ad-hoc reports using Tableau Desktop, Access, Excel and PowerPivot.
• Created daily and monthly Tableau Extracts to Tableau Server.
• Extensively used data blending capabilities within Tableau joining multiple sources for custom analysis.
• Maintaining close communication with Project Lead, providing regular feedback on all issues and initiatives; preparing, verifying and analyzing data in collaboration with the Team Leader.
• Database Point person for questions regarding data entry interface; maintaining ongoing updates and documentation for all data sets; providing ongoing database administration and troubleshooting, including data validation and QA test scripts.
• Created materialized views, functions and procedures to improve the performance.

Environment: s:Tableau 8.0, Oracle 10g, MS SQL Server, MS Excel and Windows 7 Professional.

Confidential, San Antonio, TX

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from 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.
• Published Tableau dashboards to Tableau Server.
• Created Sets, Parameters, custom Geospatial sheets, advance calculations, Calculated Fields, and functions for customizing calculations like dynamic sorting, filtering, parameter driven analysis etc.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Designed data collection mechanisms, data collection and validation.
• Preparing Dashboards using calculations, parameters in Tableau and creating calculated fields, groups, sets and hierarchies etc.
• Used Tableau to create reporting prototypes and also to validate datasets.
• Manipulated large and complex data sets, exporting/importing data from various systems and link key applications in order to create reports and analysis; delivering monthly project status reports with all issues resolved/addressed in a timely manner.

Environment: s: Tableau 6.0, Cognos 10.1.1(Business Insight Advanced, Report Studio, Framework Manager), Oracle 10g, SQL Server, MS Excel, Windows 7 Professional.

Confidential, NJ

Senior BI Developer

Responsibilities:

• Generated various Dashboard Reports, List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Up Reports using Cognos 8.4.
• Created interactive reports with variety of prompt types such as sliders and tabbed button groups using Cognos Active Reports.
• Used Advance techniques like Tabular SQL, Tabular Sets and tabular models, Report Bursting, master detail relationships and conditional styles.
• Developed reports with Drill through, rendered variables functionalities and multilevel queries using joins & union data sets.
• Developed a Framework Manager model by importing Metadata, preparing business logic, setting up object level security and developing and publishing package.
• Developed Stored Procedures and imported Stored Procedure Query Subjects in Framework manager to enhance Report Performance.
• Used JavaScript, Conditional Formatting and conditional rendering to meet the user’s unique reporting needs.
• Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Involved in Unit testing of the reports and designing the Unit Test cases template.

Environment: s:Cognos 8.4 (Query Studio, Report Studio, Analysis Studio, Active reports, Cognos Connection, Framework manager), Teradata, Windows 7 Professional.

Confidential, NJ

BI Developer

Responsibilities:

• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Design and develop meta-data models by Importing Metadata from Multiple Sources.
• Created COBOL-DB2 stored procedures and also worked on performance tuning of stored procedures having complex SQLs.
• Used some advanced features like Conditional Formatting, Conditional Rendering of reports using prompts in Report Studio for generating multipage reports.
• Created Ad-hoc reports based on user requirements using Query Studio.
• Created security at package level, object level in model and security to package in Cognos connection.
• Worked on Analysis studio and creating the drill through from the Dimensional data to relational data report (Dynamic drill through).
• Preparation and Review of Technical Analysis and Design Documents. Created Implementation plan and live release plan for the Production release.

Environment: s:Cognos 8.4 (Query Studio, Report Studio, Analysis Studio and PowerPlay Studio), IBM DB2, ChangeMan, IBM Data Studio, Z/OS and Windows 7 Professional.

Confidential

BI Developer

Responsibilities:

• Created drill through and Master detail relationship reports.
• Created multi-dimensional cube using Transformer and deployed the same along with reports using PowerPlay Enterprise Server.
• Designed and developed multiple reports in Report studio using various templates like List reports, cross-tab reports and charts in the reports with Cognos Report Net.
• Implemented Relational Modeling in Framework Manager and developed Dashboard reports in Report studio and Scheduling of Cognos reports.
• Worked on resolving the Performance issues of the Cognos reports and increased the performance of the reports by tuning SQL.
• Used Java Scripts to dynamically build the visible prompts by filtering the corresponding hidden prompts with those values currently selected.
• Implemented Dynamic Filters and Dynamic sorting functionality to give users ability to sort and filter the data in Report Viewer.
• Developed models in Framework Manager and PowerPlay Transformer.
• Enhanced Production reports based on the Change Requests.
• Instrumental in Coding, testing, debugging, maintaining and refining the computer software to deliver the solution.

Environment: s:Cognos 8.3 (Cognos Connection, Framework Manager, Query Studio, Report Studio and Analysis Studio), Informatica, SQL Server 2005 and Microsoft Windows XP.