SUMMARY

• 9+ years of experience in Business Analysis, Systems Analysis, Data Analysis, Software design, development, testing and maintenance of BI/Data warehousing environment.
• Extensively worked with Tableau 7.x, 8.x &9.3(Desktop & Server), Cognos & SAS enterprise guide & miner.
• Sound Knowledge in Health Care, Power & Financial Industries.
• Proficient in gathering requirements and authoring Functional Specification Documents (FSD) and translating them into Technical Specification Documents (TSD) by identifying interface between functional requirements & technical requirements.
• Extensive knowledge of all phases of the Software development life cycle (SDLC), Agile, Scrum and the iterative Rational Unified Process (RUP).
• Organized numerous Joint Application developments (JAD), Joint Requirement Planning sessions (JRP), Interviews, workshops and Requirement Elicitation sessions with end - user/clients/stake holders, Subject Matter Experts and the technology group.
• Managed cross-functional teams through Software Development Life Cycle.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Extensively providedtechnicalandanalyticalexpertise in responding tocomplex,specializedreport requests requiringhigher-level data analysisanddata management services.
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), MS Access and client/server applications.
• Experienced in Performance Tuning by analyzing and comparing the turnaround times between SQL and Tableau.
• Manipulate and prepare data; extract data using SAS, SQL, Oracle, Excel and Access.
• Outstanding knowledge in writing and analyzing complex SQL queries, stored procedures, database tuning, query optimization and resolving key performance issues.
• Comfortable working independently or with team with limited supervision and working in tighter schedules, meeting deadlines, and ability to learn on the fly.
• Adaptable to new Technologies and can learn quickly
• Excellent communication skills in both written and oral along with ability to tell a story through data. Strategic thinker, Meticulous, Analytical, detail/results oriented with excellent problem-solving skills and strong work ethic.
• Ability to interact professionally with a diverse group including executives and managers and interpret Business requirements.
• A highly motivated and excellent team player with technical expertise in software engineering processes and outstanding knowledge on life cycle of the software design process (SDLC).
• Extensively involved in Reverse-Engineering and Business rules extraction expert in project planning, strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planning and tracking of results.
• Flexible, enthusiastic and project oriented team player with excellent communication skills with leadership abilities to develop creative solution for challenging requirement of client.

TECHNICAL SKILLS

BI/Visualization Tools: Tableau Desktop7.x/8.x/9.x, Tableau Server 8.x, Cognos, SAS Enterprise Miner, predictive, sentiment Base SAS, SAS Enterprise Guide.

Scripting Languages: SQL, Base SAS, C, C++, HTML, Python, R Programming.

Utilities: MS Office Suite, MS SharePoint.

Front End Tools: MS Project, MS Office.

Databases & ETL Tools: Oracle SQL, MS Access, MS SQL Server, SSIS,SSAS,SSRS,Teradata, SAS/ACCESS, OLAP, Micro Strategy.

Document Management: Visual Source Safe 6.0, Share point, Ultra Edit, Documentum.

Platforms: Windows7/8/2003/NT, MS Server 2008 R2, Mac OS, DOS, UNIX.

Data Modeling: Erwin, Visio.

PROFESSIONAL EXPERIENCE

Confidential, Franklin TN

Team Leader Tableau

Responsibilities:

• Gathered user requirements analyzed and designed software solution based on the requirements.
• Extracting data from DW and hosting Dashboards in servers.
• Selected and implemented agile development practices according to the user requirements for the project.
• Daily communication with IT and Senior Leadership and Recommending Dashboards per Tableau visualization features
• Involved in reviewing business requirements and analyzing data sources, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop, in Agile environment, that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current distributors by colors that were broken into regions allowing business user to understand where we have most profitable vs. least.
• 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 MS SQL Server, DWH and SAP HANA.
• Combined views and reports into interactive dashboards in Tableau Desktop, environment, that were presented to Business Users, Program Managers, and End Users.
• Oversee the Tableau data import/export and data modelling.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Actively involved in testing new/upgraded features like new Visualizations, Forecasting, Parallelized Dashboard, Hyperlink Objects, Color-coded tabs etc. in Tableau8.1 desktop/Server.
• Administrated the Active Directory to manage user authentication for Tableau server access, in corporate the existing SS single-sign on component.
• Write scripts or set up configuration to automate the data import process into Tableau.
• Set up default file directory to host the Tableau software and data files and Data Modelling appropriately.
• Daily check up servers. And deploying servers.
• Making the end users to use tableau on iPad, creating offline snapshots and deploying dashboards on cloud.
• Worked on Performance tuning of report with huge queries using concurrent query execution for better performance of report.
• Responsible for daily communications to management and internal organizations regarding status of all assigned projects and tasks.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• 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.
• Troubleshooting erroneous reports or views issues.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Created automated diagnosis, testing and debugging modules.
• Practiced backlog grooming, release and sprint planning, daily stand-ups, impediment removal and conducted user acceptance testing.
• Responsible for functional/technical track of the project.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Involved in complete Life Cycle including Analysis, Design, Development and Testing.

Environment: Tableau Desktop 8.1 & 9.3 Tableau Server, MS SQL Server 2012, MS Office Suite, MS Project, MS Visio, Agile Scrum Environment.

Confidential, NY, NY

Tableau Developer

Responsibilities:

• 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.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Created dashboard using parameters, sets, groups and calculations.
• Created drill down and drill up in worksheets.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• 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.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server, which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• 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.
• 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

Environment: Tableau Desktop 7 & 8.1, Tableau Server, Oracle 10g/11g, IBM DB2 9.1, Windows XP,WS FTP.

Confidential, Denver CO

Sr. Business Object developer

Responsibilities:

• Created logical data models to define business and project requirements of customer management and pipe sales quoting system.
• Gathered, analyzed, and documented, communicated requirements for logical data modeling in the system including narratives, data flow diagrams and functional decomposition diagrams.
• Created requirements matrix and tracked solution validation to requirements matrix.
• Managed requirements prioritization and requirements change process.
• Organized requirements for customer statement, invoice and ticket system with use cases and UML classes.
• Developed feasibility analysis and project risk analysis.
• Wrote a use cases description Including preconditions, post conditions, assumptions, and scenarios.

Environment: Business Objects XI R3.1/XIR2/6.5 (Designer, DeskI, WebI, Infoview, Auditor, CMC), Xcelsius, Oracle 9i/10g, PL/SQL, Windows XP/Solaris/Unix, Microsoft Visio, Microsoft Office suite,Sql Server 2008.

Confidential, Rochester, NY

Business Objects Developer

Responsibilities:

• Currently leading team on multiple projects like Migration of Preferred Health and Confidential to Business Objects XI Release 2, Confidential Health Connections, Care Engine Reports, Public Health Response (PHR) Soul Source Reports, Claims and Authorization Reports
• Collaborated effectively with Business Owners, various Project Managers, Business Analysts, Quality assurance team and other team members in the Analysis and gathering of Requirements.
• Developed DeskI & WebI reports by using advanced functionalities like Optional prompts, Merge function, Custom SQL at Report level and Report level contexts.
• Design and Recommend changes to Data warehouse schema’s like Star and Snow Flake designs at Active Health.
• Assisted Web team in developing the Custom Parameter tool in .Net to feed the predefined set of parameter values to the Objects XI Enterprise. Reports scheduled on Business
• Maintain the repositories for different environments like DEV, QA and PROD

Environment: Business Objects XI 3.1/XIR2/6.5/6.1, Data Integrator XI,BO Analytics (Supply chain, customer intelligence), Dashboard Manager, Crystal Reports, Xcelsius, Web I 6.1, Windows 2000/NT, SQL, Oracle 9i, T-SQL scripts, TOAD

Confidential, Amelia, OH

Business Objects

Responsibilities:

• Interacted with Business Users and Managers in gathering business requirements.
• Involved in analyzing, documenting business requirements, functional requirements for developing universes and reports.
• Involved in the designing and Building of Universes, Classes and objects
• Worked on Master and Component approach during the linking of universes.
• Resolved loops and Traps using Contexts and Aliases while designing Universes.
• Experience in universe migration across repositories
• Set up Universe level conditions to restrict data based on report requirements.
• The project involved development of reports using Business Objects and WEBI to cater Ad-hoc reporting needs.
• Created reports using Desktop Intelligence (DESKI)
• Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s.
• Migrated reports from Development/Testing environment to Production Environment.
• Worked with Multiple data providers including Personal Data files, Stored Procedures.
• Created dynamic LOV’s based on report requirements.
• Worked extensively on Sybase.
• Published and scheduled Business Objects Reports to users using Scheduler.
• Coordinating with DBA and general supervisor for resolving technical issues
• Upgraded Business Objects Universes, Users and user groups, and reports from Version 6x to Version XIR1 using the Import Wizard.

Environment: Business Objects XIR2/6.x, Performance Management, Business Objects Designer, Web Intelligence, Desktop Intelligence, Broadcast Agent, Windows 2000 Server.