Business Intelligence Software Development
Resume:
LAKSHMI APARNANA POTTURI
*************.*********@*****.***
PROFESSIONAL SUMMARY
Tableau Developer with 6+years of extensive IT experience in Software Development, Integration, Implementation and Maintenance of Business Intelligence applications and the related Database Platforms.
Extensive experience in Tableau Desktop, Server, Reader, Public and Mobile in various versions of Tableau 6, Tableau 7 and Tableau 8.1/8.2 and Tableau 9 and Tableau 10.5.
Proficient in design and development of various dashboards, reports utilizing Tableau visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.
Experience in creating dashboards with relational and multi-dimensional databases including SQL, MS Access at gathering and manipulating data from various sources.
Strong understanding of project life cycle, SDLC methodologies including RUP, RAD, Waterfall and Agile.
In-depth knowledge of creating use cases, functional design specifications, activity diagrams, logical, component and deployment views to extract business process flow.
Expertise in Tracking, Documenting, Capturing, Managing and Communicating the requirements using Requirement Traceability Matrix (RTM)which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
Excellent analytical, problem solving and Tableau and SQL debugging skills.
Organized Joint Requirement Planning sessions, Interviews and Requirement Elicitation sessions with end-users, clients, Subject Matter Experts and the technology group.
In depth understanding of the As-Is and To-Be (Gap Analysis) business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans.
Experience in designing the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.
Experience in Data Modeling Dimensional Relational concepts like Star Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
Experience in using various MS office tools for analyzing, arranging and presenting data.
Excellent command in writing complex routines for Data Validations, Data Extraction, transformation and loading to target decision support systems using MS Excel on various environments.
Proven skills in Data Cleansing, Data Archival, Data Migration, ad-hoc reporting and coding utilizing SAS on Windows
Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
Good working knowledge of Meta-data management in consolidating metadata from disparate tools and sources including Data warehouse, ETL, Relational Databases and third-party metadata into a single repository to get information on data usage and end-to-end change impact analysis.
Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
Experience in creating and implementing interactive charts, graphs, and other user interface elements
TECHNICAL SKILLS
Specialties
Data Visualization, Business Intelligence (BI), software Management, Data Collection.
BI Tools
Tableau 6.0/7.0/8.1/8.2/9, Tableau Desktop, Tableau Server, Cognos, Crystal Reports, Qlikview
Tools and Packages
SQL Server Management studio, Toad, Microsoft Visual Studio
Languages
SQL, HTML, XML
Office suite
MS PowerPoint, MS Excel, MS Word, MS Visio, Star Office, Open Office
Operating Systems
Windows 2000/2003,2008 Server, Windows 95/98/2000/XP/7/8
EXPERIENCE
Tableau Developer
MCO, New York August 2022 – Present
Responsibilities:
Developed various dashboards illustrating data visualizations using Tableau Desktop
Proven experience in installation and maintenance of Tableau Server and administering users, user groups, projects and scheduling instances for dashboards in Tableau.
Defined best practices for Tableau report development.
Involved in creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
Developed Dashboards using calculated fields, parameters, sets and actions in Tableau.
Created drill through reports in dashboard.
Involved in creating data blending in case of merging different data sources.
Involved in creating a dual-axis bar charts with multiple measures, box plots, heat maps and background maps, trend lines statistics.
Worked on Datazen and had a good knowledge in creating the dashboard which best suites the requirement.
Understanding of relational database structures, theories, principles, and practices.
Monitored Application Server and Tableau Data server activity to track performance and system availability
Configuring the SharePoint data with Data Visualization and analytic tools like MS Power BI & Tableau.
The ability to interact professionally with a diverse group, including executives, managers, and LOB.
Working on creating various dashboards in Tableau Desktop by querying various ODBC connections such as Teradata, Oracle SQL Developer, SQL Server 2008.
Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.
Involved in license management SLAs with Tableau support.
Developed proof of concept for best practices in Tableau development & deployment, and ad-hoc reporting.
Environment: Tableau Desktop 8.0/8.1, Tableau server, Oracle SQL developer, SharePoint, SQL Server 2008/2012, Oracle 10g/11g, PL/SQL, T-SQL, MS Access, Windows 2007 server, Teradata, MS Office 2007
Tableau Developer
Natixis– New York September2020-August2022
Responsibilities:
Involved in translating the business questions and business requirements to actual and final dashboard technical requirements
Used Tableau for the data / business predictive analysis, for trending, for finding the pattern of data over the period of time
Building the customized and interactive dashboards using multiple data sources
Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.
Gathered user requirements, analyzed and designed software solution based on the requirements.
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Created worksheets and dashboards by using custom queries and multiple tables.
Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
Effectively used data blending feature in tableau.
Defined best practices for Tableau report development.
Administered user, user groups, and scheduled instances for reports in Tableau.
Executed and tested required queries and reports before publishing.
Designed and developed reports in Tableau desktop and integrated in SharePoint page through Tableau server.
Developing Attributes, Facts, Metrics, Filters, Prompts and Hierarchies as per Specifications for developing reports.
Create new and manage existing Tabcmd commands to send reports to business users.
Creating DB views for the reporting purpose.
Preparing Report Mapping Documents as per Specifications.
Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
Mentored business power users to create reports/dashboards using tableau desktop.
Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.
Environment: BI Applications, Tableau 8.1/8.2/9.0, SharePoint, Windows 7, SQL Server 2012, Oracle 11g/12c, Excel, MS Access.
BI / Tableau Developer
MAK IT February2019- September2020
Responsibilities:
Hands-on experience with Installation, configuration and upgrading the Tableau Server across the environments.
Performed administrative and support activities across Tableau infrastructure including security administration, installation and configuration of the Tableau Server.
Actively involved in the creation of users, groups, projects, workbooks and the appropriate permission setup for Tableau Server logons.
Monitoring the Tableau Server and giving feedback to the client on managing the environment effectively.
Expertise in setting up single node Tableau Server/Tableau Cluster.
Experience in implementing Tableau Sever security with SSL and SAML authentication.
Created workbooks to display the capacity of the environment, user traffic which connects to the Tableau PostgreSQL DB.
Automated the Tableau Server backup.
Experience in implementing High Availability (HA) for a Tableau cluster.
Managed client communication and understanding the requirements for all projects.
QC the workbooks that were developed before sharing with the clients.
Environment: Tableau Desktop 8.0/8.1, Tableau server, Oracle SQL developer, SharePoint, SQL Server 2008/2012, Oracle 10g/11g,MS Access, Windows 2007 server, Teradata, MS Office 2007
SQL Server BI Developer
ITEM INC March 2018- Feb 2019
Responsibilities:
Developed the project using agile methodologies in the team and take initiative to break
down requirements.
Developed packages in SSIS platform by using various tasks and transformations and
configuring as per requirements.
Involved in requirement gathering and analysis of source systems, database architecture
of the HSN database
Managing periodic reports based on the statistical analysis of the data from various time
frame and division using SQL Server Reporting Services (SSRS)
Created databases and database objects like tables, stored procedures, views, triggers,
rules, defaults, user defined data types and functions.
Created design of initial package, keeping in view and implementing appropriate SSIS
controls.
Created drill-through reports, parameterized reports and linked reports using SSRS 2005
Generated reports in the form of tabular, matrix and chart forms.
Rendered the reports in the form PDF, Excel, .CSV and XML formats
Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Data Tools, SQL
Server BI (SSIS, SSRS, SSAS), TSQL, TFS, XML and Windows Server 2003.
Junior Tableau Developer (internship)
Corporation Bank April2014 – September2015
Responsibilities:
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 Dropdown menu option and Parameters using Tableau.
Worked closely with Business users. Interacted with 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 Cross tabs, Heat maps, Box and Whisker
charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
Worked extensively with Advance analysis Actions, Calculations, Parameters,
background images, Maps, Trend Lines, Statistics and table calculations.
Education Details:
Bachelors - B.V Raju institution technology- Information Technology
Masters - California University of management sciences (Computer Information systems)
Contact this candidate