PROFESSIONAL SUMMARY:

• Over 10 years of experience in Software Design, Database Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Extensive knowledge in Health care, Retail, Manufacturing and Human Resource.
• Extensive experience in working with Tableau Desktop, Tableau Server in various versions of Tableau 10/9/8/7.
• Extensive experience in creating Tableau reports, Tableau dashboards using stack bars, bar graphs, scattered plots and geographical maps.
• Experience with Level of Detail (LOD) expressions for cohort analysis and complex aggregations at different dimensional levels to provide deeper insights into the available data.
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.
• Experience in generating reports by fetching data from different sources (RDBMS/ Text/ CSV/ EXCEL) using Data Blending.
• Employed various Tableau functionalities like Tableau Extracts, Cross Database joins, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.
• Experience in Administering user, user groups, Projects, Sites and scheduled instances for reports in Tableau.
• Extensively used other BI reporting tools Cognos, Qlikview and Microstrategy for reporting.
• Diverse knowledge in software technology.
• Hands on experience with ETL tools like Data Manager and Informatica.
• Project management and cost management.
• Strong knowledge and use of full life cycle methodologies, standards and procedures.
• Excellent knowledge in sql and pl/sql.
• Knowledge of etl and data warehouse concepts.
• Expertise in report development.
• Excellent knowledge in multidimensional modeling.
• Able to do leadership and mentoring role.
• Strong development and analytical skills, proficiency in root cause data analysis, and ability to problem solve.
• Ability to multi - task and provide expertise for multiple development teams across concurrent project tasks.
• Good experience with complexities of crosses functional issue identification, resolution and prioritization.
• Able to develop project plans.
• Excellent ability to gather and understand business requirements and translate into it solutions.
• Good experience in testing.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL,C, Powerbuilder

ETL Tools: Data Manager, Informatica

Databases: Oracle, Sql Server, DB2

BI Reporting tools: Tableau, Cognos, Qlikview, Microstrategy, BO

Scripting Language: Javascript

MS Office: MS Word, MS Excel, Powerpoint

PROFESSIONAL EXPERIENCE:

Confidential

Tableau Developer/ Data Analyst

Responsibilities:

• Extract data from different sources and used the same to create worksheets and dashboards.
• Creating data blending in case of merging two different datasets.
• Created various dashboards, reports utilizingTableau VisualizationslikeBar Graphs,Scatter Plots, Pie-Charts, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Bump Charts, Heat maps, Geographic Visualizationand other.
• Developed Tableau mobile dashboards.
• Extensively used data filters, context filters and quick filters.
• Created drill down and drill up in worksheets.
• Created Tableau mobile and geographic maps.
• Created dual and blended axis using multiple measures.
• Created hierarchies, folders, groups, calculated fields, parameters, filters, sets, actions and bins.
• Created several dashboards based on KPI like sales, Revenue etc.
• Publish dashboards and reports to tableau server.
• Scheduling dashboards and reports.
• Performed administrative tasks like creating users, groups and permissions.
• Designed a dashboard where the users can slice and dice the data at a wide range of Data elements.
• Created Forecasted Reports for the Upcoming Year to Observe Trends in Tableau.
• Created a dashboard consisting of more than 7 tables by joining them using custom SQL.
• Designed a dashboard to dynamically show or hide crosstab sheets with the detail records upon the selection on the summary chart on the dashboard.
• Created a dashboard with row level security, restricting access to the data on the dashboard based on the user.

Confidential - FL

Sr. Application Engineer

Responsibilities:

• Gather requirements from clients and document.
• Lead the team in design, development, testing and performance tuning.
• Lead both onsite and off - shore team.
• Maintained and scheduled and refresh ETL jobs, reports and cubes.
• Develop several reports and dashboards using visualization tool like Tableau and Cognos reporting tools.
• Using SQL for managing large volume of data.
• Communicating with clients to analyze historical data and identify KPI.
• Improving data processing speed by building automations.
• Tweaking sql queries for best performance.
• Analyzing the data so as to identify trends and share insights.
• Build credibility, establish rapport, and maintain communication with client at multiple levels.
• Maintain continuous alignment of program scope with strategic business objectives, and make recommendations to modify the program to enhance effectiveness toward the business result or strategic intent.
• Coach, mentor and lead personnel within a technical team environment.

Confidential - CO

Business System Analyst

Responsibilities:

• Support different users in different divisions with various technical and non-technical issues in data warehouse.
• Resolve on-going or any bugs or data problems in data warehouse.
• Solve most or all the support tickets on time, which resulted in increased productivity.
• Create and modify Reports in data warehouse using Report Studio, Query Studio and Analysis Studio.
• Carrying out investigation of root cause analysis.
• Communicating with customers to analyze historical data and identify KPI.
• Create and modify models using Transformer and Framework Manager.
• Support and maintain daily refresh of cubes and ETL Jobs.
• Create and modify documents related to data warehouse.
• Create and maintain data securities in data warehouse.
• Perform administrative tasks.
• Perform testing of reports and data.
• Modify packages and cubes.
• Support North America, EUROPE and ASIA regions.

Confidential

BI Developer

Responsibilities:

• Understanding the Requirement Specifications.
• Functional knowledge of HR and Health Care.
• Design, develop, and support of the overall Cognos BI content including reports, cubes, packages, dashboards and presentation portals.
• Collaborate with Data Architect/DBA to development/optimize the star-schema model for the Cognos reporting tools.
• Collaborate with Data Architect/DBA to maintain optimal reporting tables and views within Cognos.
• Solid understanding of the Cognos BI suite- Report/ analysis studio; Framework MGR; Transformer
• Design and support public folder reporting via Cognos Report Studio and Query Studio.
• Built Cubes using Transformer.
• Develop and maintain technical documentation.

Confidential - CA

Programmer Analyst

Responsibilities:

• Analyze, Maintain, develop, modify, debug and troubleshoot BBCS Application. BBCS Application supports different programs, such as Voucher program, rebate program, meter program and audit program.
• Design, develop, modify and debug reports that support different programs.
• Assist users with procedural and minor technical problems.
• Assist with design, analysis, develop, document and test new programs.

Confidential - CA

Programmer Analyst

Responsibilities:

• Gather user requirements.
• Interact with BI team for developing the reports and solving the issues.
• Provide critical information like total sales, daily revenue, goals and various new plans.
• Extensively used the Cognos reporting tools, Hummingbird and Microstrategy to create various types of simple and complex report.
• Document and test reports.

Confidential - CA

Technical Support Analyst

Responsibilities:

• Troubleshoot, test, write, modify, edit, and debug customer codes.
• Develop sample programs for clients.
• Install, maintain, document, and test development software.
• Train clients in SQR, VisualSqribe, PowerSqribe, and ReportMart.