SUMMARY

• Over 7+ years of experience in Information Technology in System analysis, design, development, Data Warehouse, implementation and maintenance of client server applications, providing Business Intelligence and OLAP solutions to Financial, wholesale distributing, Health Care, and Banking Sectors.
• ExtensiveExperience in TableauDesktop and TableauServerin various versions ofTableau6.0, 7.0, 8.0, 8.1, 8.2 as a Developerand Administrator.
• Experienced in Cognos 8, Cognos Report Net, Framework Manager, Query Studio, Report Studio, Analysis studio, Metric Studio and Cognos Connection.
• Over 3+ years of TableauExperience in Enterprise Environment andTableauAdministrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• 4 years of experience in collaborating BI Cognos implementation in corporate finance, Investment Management, Securities Lending.
• Good Knowledge in relational/multidimensional databases and data modeling for OLAP/ROLAP.
• Good experience in Migration of Reports&Packages.
• In - depth noledge onTableauDesktop,TableauReader andTableauServer.
• Proficient inTableaudata visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
• Mastered teh ability to design and deploy rich Graphic visualizations usingTableau.
• Deployedtableauserver in clustered environment by adding worker machines.
• Done good work in design, development and testing ofCognosPower playcube models.
• Implemented Cube Security. Enhanced performance of teh Power Cubes.
• Good noledge of various components within Cognos and how they interact with each other.
• In-depth noledge on SQL queries and working with SQL Server 2000/2005/2008, Oracle 11G/8i, PL SQL.
• Developed KPI’s and dashboards based on reports, spreadsheets and charts.
• Worked on data blending and increased teh dashboard performance by extracting data.
• Experienced in Analyzing teh BI Needs, interpreting business user requirements and translating them into reports.
• Good interaction with clients, understanding Business Applications, Business Data Flow and Data Relations.
• Good understanding of technical trends, architectures and highly motivated to no more about latest technology, new software and products.
• Involved in various activities of teh Software Life Cycle.
• Strong commitment to organizational work ethics, value based decision-making and managerial skills.

TECHNICAL SKILLS

BI Tools: Tableau Desktop, Tableau Server, Cognos 8.x, Report Net 1.0/1.1(Report Studio, Query StudioETL Tools: Informatica Power Center 8.x, SQL Server Integration Services (SSIS).

Databases: Oracle 8i/9i/10g, MS SQL server, MS Access, DB2.

Database Tools: TOAD, Enterprise Manager.

Data Modeling: ER/Studio 3.5/4.0, Erwin 4.1

Languages: C, C++, SQL, PL/SQL, T-SQL, HTML, JavaScript and XML.

Web Servers: Apache web server, Microsoft IIS 4.0

OS: Windows 2000, Server 2003, 2012, VISTA, Windows NT 4.0, Linux, UNIX.

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst

PROFESSIONAL EXPERIENCE

Confidential, Harrisburg, PA

Sr. Tableau Developer.

Responsibilities:

• Oversee teh performance of Design to develop technical solutions from Analysis documents.
• Gatheird Business Requirements, Interacted with teh Users, Project Manager and SMEs to get a better understanding of teh Business Processes.
• Analyzed teh source systems and created Business Requirement Document (BRD).
• Deep experience with teh design and development ofTableauvisualization solutions.
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server
• Configured different data sources using Tableau Desktop
• Created best visualizations reports as per teh business requirements using Tableau desktop professional edition.
• Blended data using multiple data sources (primary and secondary).
• Enabled tableau Actions to drill down from Dashboard to worksheet.
• Experience with creation of users, groups, projects, workbooks and teh appropriate permission sets forTableauserver logons and security checks.
• Extensive experience on creating trend reports including forecast and trend lines.
• Configured incremental data refresh for teh data sources.
• Prepared BI Interactive Dashboards using calculations, parameters inTableau.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Background in installing and upgrading ofTableauserver and server performance tuning for optimization.
• Configured AD security using tableau server.
• Responsible for authorizing teh users based on their privileges.
• Involved in migration activities related to Tableau across teh environments.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Worked on childcare public welfare in Pennsylvania. Created various dashboards on geospatial.

Confidential, Pleasanton, CA

Sr. Tableau Developer.

Responsibilities:

• Interacted with business users and performed Gap Analysis of Client requirements.
• 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 withinTableauDesktop.
• Designed and implemented proof of concept solutions and created advanced BI visualizations using Tableau platform.
• Responsible for upgrading teh tableau 7.0 to tableau 8.2.
• Installing and configuring of tableau worker servers.
• Created views inTableauDesktopthat was published to internal team for review and further data analysis and customization using filters and actions.
• Worked closely with business power users to create reports/complex dashboards usingtableaudesktop.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet inTableauDesktop.
• Utilized advance features ofTableausoftware like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• TEMPEffectively used data blending, filters, actions, and Hierarchies feature intableau.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Projected and forecasted future growth in terms of number of customers indeveloping Area Maps to show details on which states were connected teh most.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand teh data on teh fly with teh usage of quick filters for on demand needed information.
• Tableauserver maintenance,Tableauserver backup activity.
• Created users using Tableau Admin and assigning privileges to create report/publishing reports to server.
• Scheduled data refresh onTableauServer for weekly and monthly increments based on business change to ensure that teh views and dashboards were displaying teh changed data accurately.
• Enabled teh data security filters for teh users/groups in an AD.
• Tuned teh reports performance using Cache options / Timely refreshes of data.
• Involved in testing teh SQL Scripts for report development,Tableaureports, Dashboards, Scorecards and handled teh performance issues TEMPeffectively.
• Responsible for creating /delivering monthly reports to business users.

Environment: Windows Server 2012,TableauDesktop 8.2/8.0/7.0,TableauServer, SQL Server 2008/2012, PL/SQL, MS-Access, MS Excel and JavaScript.

Confidential, Minneapolis, MN

Tableau BI Developer.

Responsibilities:

• Oversee teh performance of Design to develop technical solutions from Analysis documents.
• Gatheird Business Requirements, Interacted with teh Users, Project Manager and SMEs to get a better understanding of teh Business Processes.
• Analyzed teh source systems and created Business Requirement Document (BRD).
• Deep experience with teh design and development ofTableauvisualization solutions.
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server
• Configured different data sources using Tableau Desktop
• Created best visualizations reports as per teh business requirements using Tableau desktop professional edition.
• Blended data using multiple data sources (primary and secondary).
• Enabled tableau Actions to drill down from Dashboard to worksheet.
• Experience with creation of users, groups, projects, workbooks and teh appropriate permission sets forTableauserver logons and security checks.
• Extensive experience on creating trend reports including forecast and trend lines.
• Configured incremental data refresh for teh data sources.
• Prepared BI Interactive Dashboards using calculations, parameters inTableau.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Background in installing and upgrading ofTableauserver and server performance tuning for optimization.
• Configured AD security using tableau server.
• Responsible for authorizing teh users based on their privileges.
• Involved in migration activities related to Tableau across teh environments.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Designed filters, power prompts, and complex financial calculations for various analytical reports.
• Implemented security in reports according to employee groups and roles according to teh requirement and was involved in deployment process.
• Expertise in connecting to Oracle and SQL databases and troubleshooting.

Environment: TableauDesktop 8.0/7.0, Tableauserver / Administrator, tabcmd, SQLdeveloper, SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server, java 1.5 platform, Microsoft office 2007

Confidential, Detroit, MI

Tableau Consultant

Responsibilities:

• Develop, Organize, manage and maintain graphs, tables and document templates for teh efficient creation of reports.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies inTableau.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Used dimension on Page shelf for a detailed analysis of teh view by members of teh dimension.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Integrated teh tableau reports to other portals.
• Provided reporting solutions for OLTP and OLAP systems.
• Published Workbooks and Dashboards to theTableauserver.
• Created extracts, published data sources totableauserver, refreshed extract inTableauserver from TableauDesktop.
• Administered user, user groups, and scheduled instances for reports inTableau.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableaurepository.
• Combined visualizations into Interactive Dashboards and publish them to teh web.
• Migrated Workbooks and Dashboards fromTableau6 toTableau7.
• Created extensive documentation on teh design, development, implementation, daily loads and process flow of teh mappings and provided Knowledge Transfer to teh end users.

Environment: Tableau7.0/6.0,Tableauserver, Oracle 11i, Informatica 8.x, SQL, SQL*Plus, TOAD, Windows 2003/XP, UNIX.

Confidential, Edina, MN

Cognos Developer, Admin

Responsibilities:

• Expertise in Cognos product suite including implementation and Installation of Cognos report net environment on multi-server platform including installation, configuration and customization.
• Model query subjects were necessary and hence created for teh ease of use and created joins, built standalone filters, prompts, merge query subjects into new query subject.
• Build complex reports and queries using a Dimensional model modeling using Cognos Framework Manager.
• Determine hierarchy and dimension information in Framework Manager in order to reclaim teh constructive Package.
• Analyzed customer requests for system enhancements, modifications for special reports.
• Worked on query subjects, relationships within query subjects; iqd’s for cubes, importing views, tables in Framework Manager & established Package security and published packages to Cognos Report Studio.
• Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports and Bursting Reports Using Report Studio.
• Supplemented regular prompts, cascading prompts, filters, Conditional style, static headers, Drill Through, sub queries to add interactivity for users in Report Studio.
• Developed Ad-hoc reports using Query Studio.
• Used Power play transformer to model multidimensional cubes. Improved teh Cube performance by partitioning teh Cube and deleting hidden categories.
• Created New Jobs using Cognos Connection.
• Scheduled reports in Cognos Connection based on teh reports to run daily, weekly basis using Event Studio.
• Maintaining Files through File Management.
• Defined, stored and maintained security information using Access manager.
• Created user groups and roles as per teh company standard and integrated Active Directory for authentication.
• Testing and improving Report Performance.

Environment: Cognos 8.2 Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, PowerPlay Transformer, Cognos Scheduler, Configuration Manager, Content Manger, Access Manager, Apache Web Server, Unix, Windows XP Professional, LDAP, Oracle 10g, SQL Server 2005.

Confidential . Newton, MA

Cognos Admin, Developer

Responsibilities:

• Writing technical documentation from scratch to production level with Cognos 8.
• Expertise in Cognos product suite including implementation and Installation of Cognos report net environment on multi-server platform including installation, configuration andcustomization.
• Clinical safety database, safety reviews/reports and narratives.
• Used Cognos Connection extensively to administer Reports as well as teh Cognos Server.
• Worked on query subjects, relationships within query subjects, iqd’s for cubes, importing views, tables and stored procedure in Framework Manager& established Package security and published packages to Cognos Report Studio.
• Created teh calculations, conditions and prompts.
• Created static choice value prompts, conditional variables (Boolean and string) and conditional blocks associated with these variables to display/hide columns and queries based on user’s selection in Prompt page.
• Created Complex reports using Multiple Drill through, Conditional Layout.
• Created cubes by using teh packages created in teh framework manager published teh cubes in teh analysis studio and created reports based on teh cube.
• Monitored teh Cube performance and modified teh structure to enhance performance.
• Set up of teh Alternate Drill down paths and teh convergence levels.
• Engage users in analysis and evaluation of functional models and prototypes; identify dependencies and priorities using FM.
• Documented high level business user requirements.

Environment: Cognos 8 BI Framework Manager, Report Studio, Query Studio, power play transformer, analysis studio, Cognos Connection, Oracle, Windows NT/2000.

Confidential

Cognos Developer

Responsibilities:

• Interpreted complex Business specifications developed by teh client and generated cubes and reports to meet customer specifications.
• Created standard and Ad hoc reports using Cognos Impromptu designed catalogs and defined User Classes, security and privileges.
• Created User Classes who needed to access teh data in teh catalog.
• Assigned password to User Classes, assigned various kinds of accesses to Tables and Folders.
• Created Lists, Groups and Cross-tab reports with Drill-through functionality.
• Created Multidimensional reports by implementing Multi Dimensional Cubes using PowerPlay and Transformer.
• Provided security for Cubes of various User classes. Used Date Wizard to create time dimension in Transformer for creating cubes and PowerPlay reports.
• Calculated fields, created manual dimensions and used special categories for creating cubes and reports using Transformer models.
• Created Impromptu Web Reports and published them on teh Web server and later on Upfront.
• Deployed cubes and reports on PowerPlay Enterprise Server and also Published to Upfront.
• Monitored teh PowerPlay cubes using PPES.
• Used Access Manager to meet teh security requirements of teh reports and cubes on teh Upfront.
• Troubleshoot Cognos Server Environment for teh better performance.

Environment: Cognos EP Series 7, Oracle 8i, Window 2000, Informatica 6.0.

Confidential

Cognos developer

Responsibilities:

• Involved in Strategic Planning for Framework Models.
• Designed and Developed Framework Packages.
• Developed Standard Reports, Drill Through Reports, Master Detail Reports Using Report Studio.
• Developed Ad-hoc reports using Cognos query.

Environment: Cognos impromptu v7.3, IWR, Oracle 8i.