SUMMARY

• 8 Years of Experience in Programming, Analyzing, Designing, Testing, integration and deployment of enterprise architecture - based components and business applications and Business Intelligence.
• Extensive experience in creating UI visualizations with Tableau Desktop and Tableau Server in various versions of Tableau.
• Extensive experience in designing, developing, and publishing visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
• Expertise in creating the big data models, reports and dashboards using Power BI.
• Expertise in Power BI, DAX, and Power M Query.
• Strong understanding of project life cycle and Software Development Life Cycle (SDLC) methodologies including Waterfall and Agile.
• Experience in different BI tools (Tableau, SAP Business Objects, Qlik View, Jaspersoft, Power BI, ThoughtSpot).
• Having in-depth knowledge of various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Expertise in configuring Repository, Create/Manage Dashboards, Reports/Answer, and Building physical, Business model and Presentation layer.
• Experienced in Business Intelligence/Business Objects (BI/BO) enterprise solutions that include Business Objects Administration, Server Monitoring, Report deployment, Security, Report/Dashboard development, Documentation, Production Support and End user training.
• Expertise in writing Packages, Stored Procedures, Functions, Views and Database Triggers using SQL and PL/SQL in Oracle. Worked with query tools like Toad, SQL*Plus, SQL Developer.
• Worked on large datasets >50millions record.
• Active participation in Business Intelligence activities related to the data warehouse (TERADATA), ETL and report development methodology.
• Designing and developing the Extraction, Transformation, and Loading (ETL) program to move data from source to target, mapping source data attributes to target data attributes.
• Develop and deliver high-quality, tested code based on requirements and user-experience discussions
• Strong problem solving and planning skills, with an ability to work independently or along with Team in an agile environment.
• Quick learner, self-motivated, excellent interpersonal skills and highly motivated towards learning New Technologies.

TECHNICAL SKILLS

Database Systems: Oracle 11g, Oracle 10g, Oracle 9i, Teradata, MS SQL Server, MS Access, Azure

ETL Tools: Informatica, Data Services Integrator, Alteryx

Reporting Tools: Tableau Desktop & server, Power BI, Jasper soft Studio, BO, QlikView, ThoughtSpot

Software’s/Utilities: SQL*Plus, SQL*Net, SQL*Loader, PL/SQL, Import/Export, UNIX Shell Scripting, MS Azure, Agile, TOAD, ERWIN, SSIS, SSAS, SQL Developer, Snowflake, Jira, Jenkins, Putty.

Scripting Languages: Java Script, Python, HTML

Operating Systems: Windows 98 / NT / 2000 / XP, UNIX.

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Sr. Business Intelligence Developer

Environment: Power BI, Tableau, MicroStrategy, Azure, ADLS, Oracle, Databricks, Data Factory, Big data, Hive, impala.

Responsibilities:

• Designed and developed Power BI visualization solutions.
• Designed and Optimized Data Connections, Data Extracts, Data modeling, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Power BI and MicroStrategy
• Administer user, user groups, and scheduled instances for reports in Power BI.
• Developed complex calculated fields for the business logic, field actions, sets and parameters to include various filtering capabilities for the dashboards, and to provide drill-down features for the detailed reports.
• Train and built a Machine learning model for better predictions in Power BI.
• Built pipelines for data extract using Python.
• Involved in data validation of the results in Power BI by validating the numbers against the data in the database tables by querying on the database, also involved unit testing and bug fixes.
• Monitor communications from the Enterprise Platform team.
• Review site content, schedules, and usageto ensureserver resources are being used responsibly.
• Tested, Cleaned, and Standardized Data to meet the business standards using Conditional Split, Data Conversion, and Derived column in different environments.
• Developed best practices guide for Dashboard implementation using Tableau, Power BI and MicroStrategy.
• Interacted closely with the Business users to gather the business requirements and performed Gap Analysis for requirements.
• Interact and Present dashboard to CTO, VP, and Directors.

Confidential - Hillsboro, OR

Sr. Tableau Developer/Admin

Environment: Tableau desktop and Server, ThoughtSpot, Snowflake, Python, AWS, S3, MYSQL, Linux, SQL*plus, SSIS, Agile.

Responsibilities:

• Designed and developed Tableau visualization solutions.
• Work on generating various dashboards in Tableau server using various data source
• Administer user, user groups, and scheduled instances for reports in Tableau.
• Monitor communications from the Enterprise Platform team.
• Review site content, schedules, and usageto ensureserver resources are being used responsibly.
• Tested, Cleaned, and Standardized Data to meet the business standards using Conditional Split, Data Conversion, and Derived column in different environments.
• Networked with Strategic team and Business Systems analyst to analyze business needs and developed technical specifications.
• Remove scheduled extracts for non-Production content.
• Designed data visualization to present current impact and growth.
• Involved in implementing ThoughtSpot using python.
• Loaded data into ThoughtSpot and designed dashboards and Insights.

Confidential - Denver, CO

Report Developer

Environment: Tableau desktop and server, T-SQL, SQL*Plus, MYSQL, Java, web services, Confluence, SVN.

Responsibilities:

• Involved in the publishing of various kinds of live, interactive data visualizations, dashboards, reports, and workbooks from Tableau Desktop to Tableau servers.
• Involved in conducting training to the user on interact, filter, sort and customize views on an existing visualization generated thru Tableau desktop.
• Extensively participated in translating business needs into Business Intelligence reporting solutions by ensuring the correct selection of toolset available across the Tableau BI suite.
• In charge of the team that builds tableau architecture and dashboards using Tableau Desktop, Tableau Server and Tableau Online.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Built complex formulas in Tableau for various business calculations.
• Provided support once the dashboards were published if there were any data changes, system changes, or requirement changes.

Confidential - Salt Lake City, UT

Report Developer

Environment: Jasper studio & server, web Intelligence, Java, Teradata, HTML, SQL*Loader, XML, Putty, SVN, WinSCP, SharePoint.

Responsibilities:

• Collaborate with Management to identify report requirements, design features and specifications in implementing Jasper Reporting.
• Designed and developed various Jasper reports including Crosstabs, Tables, Charts using Jasper soft studio and Deployed in Jasper Server to represent Red Flags.
• Analyzing reporting problems to develop quality designs for reports.
• Produce documentation of Reports and the development process as needed to support the system.
• Executed various date logics calculations including adding, subtracting months or days from parameter date and formatted the dates as per the needs of business user.
• Published Reports, workbooks and data source to server and exporting the reports in different Formats.
• Support and maintenance of Jasper Reports Server as needed.
• Co-ordinate with the team and business analysts in discussing about the technical and functional requirements for enhancing existing business objects universes based on business requirements.
• Design, develop, maintain, and test universes for supporting ad-hoc queries and canned reports according to the business requirements.
• Established standard process for data model reviews.
• Integrated multiple logical data models into a single data model.
• Created Web Intelligence reports based on the requirements against the universes and tested them.
• Updated and maintained existing universes based on changing user requirements and based on changes in data source.
• Created different types of reports like Master/Detail and Crosstab.

Confidential - Austin, TX

Business Intelligence Developer

Environment: Tableau Desktop developer, Admin, Jaspersoft, SSIS, SQL Server 2008R2/2008/2005, Enterprise manager, Crystal Reports, XML, MS Project, Big Data, MS Access 2000 & Windows Server 2000.

Responsibilities:

• Interacting with business users to understand the functionality and their requirements.
• Involved in the publishing of various kinds of live, interactive data visualizations, dashboards, reports, and workbooks from Tableau Desktop to Tableau servers.
• Assisted users to publish and collaborate reports via a web browser & embed Tableau views in other web applications like SharePoint.
• Creating action filters, parameters, and calculated sets for preparing Dashboards and Worksheets in Tableau
• Advanced level knowledge with tableau table and window calculations.
• Providing technical and analytical expertise while responding to specialized report requests requiring higher-level data analysis and data management services.
• Functional Lead role in defining the dashboard requirements and providing the best practices/approach to performing ETL and publish data to the reports/dashboards.
• Publish Tableau workbook to cloud and schedule the refresh of data. Specialized in analyzing the incremental refresh scenarios.

Confidential - Saint Louis, MO

Business Intelligence Developer

Environment: Tableau Desktop, Business Objects, Amazon Redshift, R, MySQL, Agile, ITSM.

Responsibilities:

• Understand the Requirements and Functionality of the application from specifications.
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameters using Tableau.
• Worked closely with Business users. Interacted with ETL developers, Project Managers, and members of the QA teams.
• Converted existing BO reports to tableau dashboards
• Created different KPI using calculated key figures and parameters
• Developed Tableau data visualization using Crosstabs, Heatmaps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Wrote Custom SQL to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.

Confidential

SQL Developer

Environment: Oracle 9i/10g, PL/SQL, TOAD and SQL *PLUS, UNIX.

Responsibilities:

• Designed, developed, tested, tuned, and implemented relational databases and procedural database code.
• Provided database development support to the development team.
• Produced ad-hoc queries and developed reports to support business needs.
• Performed unit testing of developed solutions.
• Supported database administration and participated in special projects related to database administration.
• Developed and maintained SQL scripts in Microsoft SQL Server.
• Wrote Database triggers for audit and to implement complex business logic.
• Designing BI solutions with Microsoft SQL Server 2008 / 2008 R2 / 2012.
• Generated SQL scripts for creating tables, Views, Primary keys, Indexes, Constraints and Sequences.
• Developed and modified PL/SQL packages, procedures, functions as per customer requirement to make new enhancements or resolve problems.