SUMMARY

• Software professional having 11 years of cumulative experience in Data Visualization, Data Analytics, Business Intelligence, Business warehouse modelling and Reporting tools likeTableau, SSRS, SSIS, Datastage.
• 9+ years experience in Banking and Financial Services Industry.
• Worked on creating various dashboards based on business requirements.
• Created solution driven dashboards using different chart types likeCrosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
• Experienced in technical support, troubleshooting, report design and monitoring of system usage.
• Expert in design and deploying rich Graphic visualizations with Drill Down feature and Parameters.
• End to End experience indesigning and deploying data visualizations using Tableau
• Produced attractivevisuals/dashboardsto convey theStory pointsof the data.
• Participated in business discussions with the users and created requirement documents from which the dashboards are created.
• Scheduled the Workflows to run on a daily and weekly basis using Autosys Scheduling tool.
• Maintained workflow logs, target databases, code backups and also performed operational support and maintenance ofETLbug fixes and defects.
• Expert inanalysis, design, development, testing, and production rollover of reporting and analysis projects.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Experienced in Administeringuser, user groups, and scheduled updates for reports inTableau Server.
• Experienced in granting permissions and other admin activities on Tableau server.
• Well versed in tab commands for developing scripts for tableau server backup and restoring.
• Comfortable working independently or with team with limited supervision and working in tighter schedules, meeting deadlines, and ability to learn on the fly.
• Excellent communication skills in facing the end users and training them in using the tool.

TECHNICAL SKILLS

Operating Systems: Linux, Unix, Windows Server 2008 R2

Databases: SQL Server 2008/2012, Oracle 11g, Oracle 12c. MySQL

Database Design Tools and Data Modeling: Erwin Data Modeler, Microsoft SQL Server, TOAD Data Modeler

Modelling Techniques/Tools: E - R Modelling, Star-Schema, Snow-Flake, Normalized/ De-normalized DataStructures

BI Tools: Tableau Desktop version 9.x/10.5, Microsoft SSRS 2008, Business Objects XI R2

ETL Tools: Microsoft SSIS 2008, IBM Datastage 8.1

Tools: /Database Utilities: SQL Developer, Toad, Microsoft BI suite, Microsoft Visual Studio 2008 Service Pack 2, Sharepoint.

Languages: Java, XML, JavaScript, SQL, HTML, UML

PROFESSIONAL EXPERIENCE

Confidential

Sr. Data/Tableau Consultant

Responsibilities:

• Participated in gathering the user requirements, involved in the analysis, data modeling, detailed system design, development and technical documentation.
• Reviews and edits requirements, specifications, business processes and recommendations related to proposed solution
• Identified and documented data sources and transformation rules required to populate and maintain data warehouse.
• Worked on Data visualization usingTableaufor analyzing sales and profits at Brand Level.
• Created multiple dashboards for analysis of products, Brand Analysis(BA), Counter Analysis containing visualizations for top selling, Top 25% Brand Items, Bottom 25% Brand Items repeat purchases, top recruitment, Quartlie analysis of user.
• Experience in creating aggregates, hierarchies, charts, filters, quick filters, table calculations, trend lines calculated measures.
• Usage of Context, SQL filters to improve performance and different date filters to show the details for different quarters and years.
• Designed Brand Level dashboard usingTableauDesktop and publishing the same onTableauserver, allowing executive management to view current and past performance sales trends at various geographic locations.
• Created graphs, to determine profit generation by using measures and dimensions data from Salesforce Marketing cloud Exact Target and MS Excel.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Administered user, user groups, and scheduled instances for reports inTableau
• Used tab commands to accomplish various server level administration functions.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets.
• UsingTableauDesktop created Interactive reporting dashboards by combining multiple views.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.

Environment: Tableau Desktop, Tableau Server, SQL Server 2012, JIRA, Confluence, MS Office, Salesforce Marketing Cloud (Exact Target), SiteCore CMS, Unix, Jenkins, Github.

Confidential

Sr. Data/ Tableau Consultant

Responsibilities:

• Created views in Tableau Deskto pthat were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Maps showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Combined views and reports into interactive dashboards inTableau Desktopthat were presented to Business Users, Program Managers, and End Users.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Data Blending, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. inTableau9.0 desktop/Server.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Administered user, user groups, and scheduled instances for reports inTableau
• Scheduled data refresh onTableau Serverfor weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Technical and Data Management responsible user for FundPortal for all environments in clients infrastructure.
• Handling promotion of code from SIT to UAT to PROD, ensuring all Change Management Processes are met and are compliant.
• Software Delivery responsibility for multiple phases of the project: On time, On Budget, On Specifications
• Managing application delivery adhering to industry best practices for various phases of Agile methodology
• Liaise with key stakeholders for developing solutions and acceptance criteria, present prototypes, prioritize issues, seek feedback and report project status
• Ensure that IT Systems and Services are aligned with business and stakeholder needs. Train User groups; prepare training materials, user guides/manuals.
• Build and plan technological capability within the team to serve needs as per business requirements
• Responsible for success of Process and Quality initiatives to enhance overall efficiency and effectiveness of end to end delivery management

Environment: Tableau Desktop, Tableau Server, Microsft SSIS, Windows Server 2008 R2, SQL Server 2008, ASP.NET, C#, XML, MS Visio, MS SharePoint, MS Office, MS Project, Autosys, HWM Mantra, Sungard Investran, Hedgetek, BroadRidge Paladyne, Oracle Flexcube, Advent Geneva

Confidential

Sr. Data Analyst

Responsibilities:

• Ensured all artifacts complied with corporate SDLC Policies and guideline.
• Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR)
• Managed business solution creation and approval of related projects via comprehensive business cases that include solution scenarios and benefits achievement. Managing the business requirements management process, using appropriate tools, including workshop facilitation, use case modeling,data and process flow modeling etc.
• Worked with Tech Architects on Conceptual and logical data design to built a system to load a data mart from legacy systems and designed a cube for Consumer Finance performance reporting.
• Gathered requirements for BI solution to extract data from CFS and reports to be used by the portfolio managers for performance management
• Prioritized outstanding defects and system problems, ensuring accuracy and deadlines were met
• Performed GAP analysis of business rules, business and system process flows, user administration, and requirements
• Participated in creating the Scope of Work, setting deadlines and time schedules, prior to the commencement of a module pertaining to the application
• Indentified issues and areas for business and technical improvements, integrating with internal and external systems, data conversion and validation documentation, definition of application and technical documentation requirements
• Monitored System, Integration, End to End testing and monitored the application behavior during various builds
• Followed Agile/Scrum development process

Environment: Windows XP, Unix, SSIS, SSAS, and SSRS, Autosys, MS Sharepoint, MS Project, MS Office Tools etc.

Confidential

Sr. Data Analyst

Responsibilities:

• Liaised with business and functional owner during risk engineering and high-level review sessions to derive and execute action plans, meeting deadlines and standards
• Worked closely with project managers, business users to transform business idea and define requirements following Agile methodologies
• Responsible for developing Business Requirement and Functional Requirement Document and documenting the same in Quality Center.
• Handling scope creep and managing the same for delivery reporting with Project Managers and Owners.
• Designed and developed a BI solution for Investment Banking and Credit Risk.
• Supported the achievement of business objectives by developing a Business framework for an integrated-company-wide Business Intelligence environment, providing Key Performance Indicators, performance reporting, analytics and insight to CIT decision makers
• Implemented an OLAP Database (cube) and ad-hoc/canned reports for Exposure reporting
• Participated in defining standards and best practices for ETL
• Designed and developed financial reports and end-to-end processes to ensure timely delivery of accurate financial data to business needs
• Coordinated change management and release management procedures in collaboration with the Business Services Manager
• Identified, re-modeled and optimized several time consuming sub-optimal business processes and applications, thereby increasing the speed and efficiency of operations multi-fold
• Worked with QA team to design test plan and test scenarios / cases for User Acceptance Testing (UAT)
• Regression testing was performed upon receiving new builds and updated the Scripts accordingly

Environment: Windows, Unix, SQL Server 2008, VB, ASP, MS SharePoint, HP Quality Center, XML, DHTML, MS Visio, MS Office, MS Project, UML, IBM Datastage 8.1, Business Objects XI R2