Manager Project

Priyanka Email: ********.*****@*****.***

Senior Tableau Developer Phone: 908-***-****

Over Seven 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 Capital Market, wholesale distributing, Health Care, and Banking Sectors.

SUMMARY

Extensive Experience in Tableau Desktop and Tableau Server in various versions of Tableau 6.0, 7.0, 8.0, 8.1, 8.2, 9.0, 9.2 as a Developer and 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 Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.

3+ 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 knowledge on Tableau Desktop, Tableau Reader and Tableau Server.

Proficient in Tableau data 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 using Tableau.

Deployed tableau server in clustered environment by adding worker machines.

Done good work in design, development and testing of Cognos Power play cube 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 Hadoop, SQL Server 2000/2005/2008/2012, Oracle 11G/8i, MySQL.

Developed KPI’s and dashboards based on reports, spreadsheets and charts.

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, Report Net 1.0/1.1(Report Studio, Query Studio, Cognos connection, Framework Manager), Cognos Impromptu 7.x, Cognos Transformer & Power Play7.3/7.4, Impromptu Web Reports (IWR), Cognos visualizer 7.0, Cognos Query, Cognos Upfront, Cognos Power Play, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS), MS Excel 2007

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

Databases: Greenplum, Oracle 8i/9i/10g, MySQL, SQL Server, MS Access, DB2.

Database Tools: TOAD, Enterprise Manager.

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

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

Big Data Tools: Hadoop, HDFS, Hive, Sqoop, Big Query.

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

Client: Goldman Sachs, Jersey City, NJ Nov 2015 – Till Date

Position: Sr. Tableau Developer

Responsibilities:

Work with business stakeholders, application developers, production teams to gather business needs and discuss solution options

Participate in Client requirement discussions and provide suggestions on the design and architecture for new interfaces. Design, Develop, Unit test, Production support, User acceptance testing support for each component in the application

Assist in back-end system development research and responsible for capturing and analyzing the database objects like stored procedures, package functions using SQL/PLSQL in Aqua data studio and tune the same to improve application performance

Develop complex queries for dashboard and ad hoc analytical reports for Investors and Issuers of the company.

Responsible for providing fast and timely Development support for production issues.

Created Issuer dashboard to analyze Issuers of the company based on order size, demand, and allocation.

Created analysis for Investor reports comparing year over year trends for top investors, geographic distribution and classifications.

Built order mapping web tool to clean free text orders and map investors from downstream improving Data quality for cleaner reporting analytics.

Responsible for planning and developing as well as aligning with the assigned sprints through agile methodology

Involved in Administrative activities, Migrated Reports from Tableau 9.0 to 9.2, doing deployment and monitoring schedules and jobs on Tableau server.

Gathering user requirements to meet end client specifications, implement new enhancements and provide production support.

Environment: Windows 7, Tableau Desktop 9.2, Tableau Server, MS Office, Aqua Data Studio, SQL server 2012, SecDB, Oracle Database, Agile Methodologies and Java.

Client: Direct financial solutions, Logan, UT April 2015 – Nov 2015

Position: Sr. Tableau Analyst.

Direct Financial Solutions is an online lending company and is based in Logan, Utah. The BI team involves with creating dashboards and reports for all the departments in DFS.

Responsibilities:

Gathered Business Requirements, Interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.

Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports.

Collaborate with key information users and super users in other functional departments to build analytical reports on our loan services.

Worked on Business Intelligence standardization to create database layers with user friendly views in MS SQL Server that can be used for development of various Tableau reports/ dashboards.

Deliver fit for purpose analytics by building comprehensive performance reports that cover the big picture storyline and allow for relevant drill drowns

Effectively used data blending feature in tableau and defined best practices for Tableau report development.

Consistently attended meetings with the Client subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business's needs.

Fine-tuned the SQL queries using optimizer hints for joins, parallelism and execution plan.

Optimized the query performance with modification to SQL queries, removing unnecessary columns, establishing necessary joins, creating useful indexes.

Executed and tested required queries and reports before publishing dashboards.

Created unit test plans to unit test the code prior to the handover process to QA.

Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.

Environment: Windows 7, Tableau Desktop 9.0, Tableau Server, MS Office, MS Visual studio 2013, SVN, SQL server 2012, MySQL, Oracle Database, C#., Agile Methodologies and JavaScript.

Client: WellCare Inc. Tampa, FL May 2014 – March 2015

Position: Sr. Tableau Developer.

WellCare Health Plans, Inc. began operations in 1985 and is based in Tampa, Florida. WellCare provides Medicare and Medicaid managed care health plans for 2.2 million members, partners with over 91,000 physicians, and employs over 3,500 associates. The BI team involves with creating dashboards and reports for all the departments in WellCare.

Responsibilities:

Read business user requirements, analyzed data, and designed software solutions in Tableau Desktop based on the requirements.

Built and published interactive reports and dashboards using Tableau Desktop and Tableau Server.

Created reports to show top high cost members for the Florida market at the state level, Regional level, IPA and PCP level

Created time series analysis on budget and actual data 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.

Hadoop is used in our organization to resolve the data storage problem and to depend less on the traditional databases which struggles to retain data at massive volume.

Connected tableau directly to Hortonworks Data Platform through hive interface so that business users can quickly find insight with Hadoop deployment.

Connected tableau to Greenplum Database which is a fully compliant SQL Database that sits on top of Hadoop for real time analytics.

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 Ad hoc reports, performance reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.

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 in Tableau Server.

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, Tableau Desktop 8.2, Tableau Server, Hadoop, Greenplum, MySQL, Oracle Database, Informatica, MS-Access, MS Excel and JavaScript.

Client: Citigroup Inc. Warren, NJ July 2013 – May 2014

Position: Tableau Developer

Citi, the leading global financial services company, has some 200 million customer accounts and does business in more than 100 countries, providing consumers, corporations, governments and institutions with a broad range of financial products and services, including consumer banking and credit, corporate and investment banking, securities brokerage, and wealth management. The BI team provides reporting solutions to all the departments in Citigroup.

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 within Tableau Desktop.

Designed and implemented proof of concept solutions and created advanced BI visualizations using Tableau platform.

Responsible for upgrading the tableau 7.0 to tableau 8.2.

Installing and configuring of tableau worker servers.

Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.

Worked closely with business power users to create adhoc reports/complex dashboards using tableau desktop.

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.

Connected Tableau to Apache Hive via ODBC connection for SQL access in Hadoop and to visualize the data and built interactive dashboards.

Effectively used data blending, filters, actions, Hierarchies feature in tableau.

Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.

Tableau server maintenance, Tableau server backup activity.

Created users using Tableau Admin and assigning privileges to create report/publishing reports to server.

Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

Enabled the data security filters for the users/groups in an AD.

Tuned the reports performance using Cache options / Timely refreshes of data.

Involved in testing the SQL Scripts for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Responsible for creating /delivering monthly reports to business users.

Environment: Windows Server 2012, Tableau Desktop 8.2/8.0/7.0, Tableau Server, Hadoop, MySQL, Oracle, MS-Access, MS Excel, Informatica and JavaScript.

Client: Bank of America, Austin, TX Aug 2012 – July 2013

Position: BI Developer

The Bank of America Corporation is an American multinational banking and financial services corporation headquartered in Charlotte, North Carolina. It is the second largest bank holding company in the United States by assets. The BI team involves with creating dashboards for funds liquidity. Interactive Dashboard was created based on the liquidity by payout days and exposure.

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.

Analyzed the source systems and created Business Requirement Document (BRD).

Deep experience with the design and development of Tableau visualization solutions.

Responsible for creating reports using Tableau desktop and publishing reports to Tableau server

Configured different data sources using Tableau Desktop

Connected tableau to Google BigQuery for fast, interactive analysis of massive data.

Enabled tableau Actions to drill down from Dashboard to worksheet.

Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server 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 in Tableau.

Background in installing and upgrading of Tableau server 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.

Implemented security in reports per employee groups and roles according to the requirement and was involved in deployment process.

Expertise in connecting to Oracle and MySQL databases and troubleshooting.

Environment: Tableau Desktop 8.0/7.0, Tableau server / Administrator, tabcmd, Google BigQuery, MySQL, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server, java 1.5 platform, Microsoft office 2007

Client: Chubb Corporation, Hartford, CT July 2011 – Aug 2012 Position: Cognos Developer

Chubb Corporation is an U.S. leading multinational insurance organization focusing on profitability, distribution and claim processing. It has been delivering better insurance for different types of product and services around the global.

Responsibilities:

• Used Framework Manager to create models, packages and publish packages to the cognos 8 Server.

• Configured data source on Cognos 8 portal and in Framework Manager model.

• Used Cognos Configuration to set up Active Directory Server.

• Used Cognos Connection to create Group or Role and set access permissions.

• Experience in developing models using prompts and filters.

• Distributed reports to various agents using Bursting.

• Added new Dimensions and Measures in the already existing reports in the Production.

• Performed BI Content Administration tasks including scheduling and content management

• Developed SQL in TOAD and exported results to Access Database.

• Developed SQL Driven reports.

• Administered user access protocols and managed user accounts and access privileges.

• Setting up different environments (development, testing and production)

• Deployed the reports from development to testing and from q/a to prod through deployment tool.

• Used Cognos Connection for organizing, security, scheduling and distributing reports.

• Created various portals involving Cognos 8 port lets.

• Administer user access protocols and created user accounts and access privileges.

Environment: Cognos 8BI,Cognos Connection, Report Studio, Query Studio, Analysis studio, Metric studio, Frame Work Manager, Oracle 10g, SQL, Scheduler,XML and Windows NT/4.0

Client: SONATA SOFTWARE LTD, India Aug 2009 – July 2011 Position: Cognos Developer.

Sonata Software is a leading provider of IT consulting and software services globally. Sonata services range from IT consulting to product engineering services, application Development, Application Management, Business Intelligence, Packaged Application and Travel Solutions.

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 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 the Web server and later on Upfront.

Deployed cubes and reports on PowerPlay Enterprise Server and also Published to Upfront.

Monitored the PowerPlay 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.

Contact this candidate