SUMMARY

• Over 7+ years of experience in Information Technology in System analysis, design, development, Implementation and maintenance of client server applications and Data Warehouse, providing Business Intelligence and OLAP solutions to Financial, wholesale distributing, Health Care, and Banking Sectors.
• ExtensiveExperience in TableauDesktop and TableauServer in 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.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including normalization, stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers and cursors.
• Good experience in Migration of Reports & Packages.
• In - depth knowledge 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 the 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 the Power Cubes.
• Good knowledge of various components within Cognos and how they interact with each other.
• In-depth knowledge on SQL queries and working with SQL Server 2000/2005/2008 , Oracle 11G/8i, PL SQL.
• Well versed in query optimization for performance tuning and monitoring of processes.
• Worked on complex KPI scorecards, heat maps, tree views, circle views, bar charts. Data visualizations and interactive dashboard which helped business get a good handle on the team's productivity.
• Worked on data blending and increased the dashboard performance by extracting data.
• Experienced in Analyzing the 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 know more about latest technology, new software and products.
• Involved in various activities of the 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/7.x, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS).

ETL Tools: Ab Initio, Informatica Power Center 8.x, SQL Server Integration Services (SSIS).

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

Database Tools: Green plum, 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.

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

Front End Tools: Microsoft Office, Microsoft Project, Microsoft Visio, and Visual SourceSafe.

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

Data Analyst/Sr. Tableau Developer

Responsibilities:

• Read business user requirements, analyzed data, and designed software solutions inTableau Desktop based on the requirements.
• Built and published interactive reports and dashboards usingTableauDesktop andTableauServer.
• Experienced in designing report layouts inSSRSand deployed cubes usingSSAS.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operationalDrill-throughandDrill-downreports usingSSRS.
• Created time series analysis on budget and actual data for Confidential and combined them in dashboard to show the customers by Line of business allowing interaction between the two charts for drill down analysis.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Blended data from multiple databases such as Green plum, MS Excel and Oracle SQL database by assigning primary key from each databases.
• Developed geographic maps showcasing demographics broken into age, race, and income category that showed content viewed by individual customers across all content providers.
• Developed parameter and dimension based reports, drill-down reports, matrix reports, charts, and Tabular reports usingTableauDesktop.
• Executed and tested required queries and reports before publishing dashboards.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.
• Administered user, user groups, and scheduled instances for reports inTableauServer.
• Presented, interacted, and communicated with business and user groups for explaining the dashboards that I have created with the ability to change and view the data on the fly.

Environment: Windows Server 2012,TableauDesktop 8.2,TableauServer, Reporting Services (SSRS), Analysis Services (SSAS), Green plum, Oracle SQL Database, PL/SQL, MS-Access, MS Excel and JavaScript.

Confidential, Madison, WS

Tableau Consultant

Responsibilities:

• Develop, Organize, manage and maintain graphs, tables and document templates for the efficient creation of reports.
• Prepared dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies inTableau.
• Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports; thus making them user friendly.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS.
• Designed and developed stored procedures, queries and views necessary to support SSRS reports.
• Served as aSSRS2000 Reports Developer and SQL Server Developer in support of Service Management System.
• 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 the view by members of the dimension.
• Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.
• Integrated the 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 Adadmin and Tabcmd commands in creating backups and restoring backups of Tableaurepository.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Migrated Workbooks and Dashboards fromTableau6 toTableau7.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings and provided Knowledge Transfer to the end users.

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

Confidential, Austin, TX

Tableau BI Developer

Responsibilities:

• Oversee the performance of Design to develop technical solutions from Analysis documents.
• Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Generated various Monthly, Quarterly, Bi-Yearly, Yearly reports by different type of reports using SSRS.
• Extensively worked on SSRS and delivered complex reports from different data sources such as SQL Database and Cubes.
• Developed various operational drill-through and drill-down reports using SSRS.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down and Drill-through reports using SSRS.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Analyzed the source systems and created Business Requirement Document (BRD).
• Deep experience with the 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 the 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 the appropriate permission sets forTableauserver logons and security checks.
• Extensive experience on creating trend reports including forecast and trend lines.
• Configured incremental data refresh for the 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 the users based on their privileges.
• Involved in migration activities related to Tableau across the 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 the 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, Reporting Services (SSRS),SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server, java 1.5 platform, Microsoft office 2007

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 the 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 the constructive Package.
• Analyzed customer requests for system enhancements, modifications for special reports.
• Worked on query subjects, relationships within query subjects, ad’s for cubes, importing views, tables in Frame work 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 the Cube performance by partitioning the Cube and deleting hidden categories.
• Created New Jobs using Cognos Connection.
• Scheduled reports in Cognos Connection based on the 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 the 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, Power Play 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 and customization.
• Clinical safety database, safety reviews/reports and narratives.
• Used Cognos Connection extensively to administer Reports as well as the Cognos Server.
• Worked on query subjects, relationships within query subjects, ad’s for cubes, importing views, tables and stored procedure in Frame work Manager& established Package security and published packages to Cognos Report Studio.
• Created the 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 the packages created in the framework manager, published the cubes in the analysis studio and created reports based on the cube.
• Monitored the Cube performance and modified the structure to enhance performance.
• Set up of the Alternate Drill down paths and the 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 the 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 the data in the 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 Power Play and Transformer.
• Provided security for Cubes of various User classes. Used Date Wizard to create time dimension in Transformer for creating cubes and Power Play 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 the Web server and later on Upfront.
• Deployed cubes and reports on Power Play Enterprise Server and also Published to Upfront.
• Monitored the Power Play cubes using PPES.
• Used Access Manager to meet the security requirements of the reports and cubes on the Upfront.
• Troubleshoot Cognos Server Environment for the better performance.

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