SUMMARY:

• Over 7 years of IT industry experience in Data warehousing and Business Intelligence technologies along with 3+ years of data visualization using Tableau.
• Worked in all phases of Software Development full life cycles including analysis, design, development, testing, deployment, post - production support/maintenance, documentation and end-user training.
• Involved in gathering user requirements, analyzed and designed software solution based on the requirements.
• Knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Solid understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema, Snowflakes modeling, fact and dimension tables modeling of data.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Have experience in working with various data sources such as Oracle, SQL Server, and flat file sources.
• Expertise in Tableau 10.x/9.x/8. x.
• Hands on experience on Tableau Desktop, Tableau Reader and Tableau Server.
• Have experience in designing and creating various Data Visualization Dashboards, worksheets and analytical reports to help users to identify critical KPIs and facilitate strategic planning in the organization utilizing Tableau Visualizations according to the end user requirement.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Experienced in using of action filters, user filters, advanced navigation techniques, Level-of-Detail (LOD) expressions.
• Worked extensively with Advance analysis Actions, Data blending, Calculations, Parameters, Background images, Maps.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters in Tableau.
• Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.
• Produced attractive visuals/dashboards to convey the story inside the data.
• Published Tableau workbooks on tableau server with view permissions, scheduling and authentication features for refreshing the extracts on a particular schedule.
• Strong testing and debugging skills procedures and strategies to extract data from different source systems.
• Extensive experience in troubleshooting, performance tuning and supporting Business reporting platforms.
• Provided 24X7 Operational/Application support for business-critical applications.
• Experience working with Incident Management tools like JIRA, IBSM management tools.
• Good understanding of business environment, excellent communication skill and ability to work proactively in a fast-paced environment.
• Communicate effectively with colleagues and business users.

TECHNICAL SKILLS:

Database: MS SQL Server 2008 R 2 /2012/2014/2016 , Oracle 10g/11g, PostgreSQL 9.1 / 9.2/ 9.3

ETL Tools: SQL Server Integration Services (SSIS), Oracle Data Integrator(ODI)

Reporting Tools: Tableau 8/ 9/ 10, SQL Server Reporting Services (SSRS)

SQL, PostgreSQL, T: SQL, PLSQL

Web Technologies: HTML, CSS, VB.net, python, Big data

Operating System: Windows Server, RHEL, Linux, UNIX

Web Servers: Apache, Tomcat

PROFESSIONAL EXPERIENCE:

Confidential, Bowie, MD

Tableau Developer

Responsibilities:

• Gathered user requirements, reporting requirements and prepared the requirement specifications document.
• Participated in all the phases of project - development, testing, deployment and support.
• Involved in analyzing existing logical and physical data modeling with STAR and SNOWFLAKE schema techniques in Data warehouse.
• Performed Dimensional modeling, Identify Fact tables and Measures, Identify Dimension Tables to store business attributes, Identify Aggregate tables and their definitions.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Experienced in building and publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Used advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Created complex formulas and calculations within Tableau to meet the needs of complex business logic.
• Involved in design and development of various reports and dashboard utilizing Tableau Visualization tools like Cross tabs, bar graphs, scatter plots, pie-charts, bar charts, whisker charts, heat maps, Custom color palettes, geographic map and other local & global filters.
• Designed Summary and Detailed reports using Data Blending and cascading feature in Tableau to provide dependency on objects through filters.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps to assist end users in solving complex problems.
• Worked in Tableau environment to create dashboards like Yearly, monthly reports using tableau desktop & publish them to server.
• Restricted data for users using Row level security and User filters.
• Created Data extracts for better performance and accessing data offline.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Executed and tested required queries and reports before publishing.
• Scheduled frequency and time to refresh data when the sources are published or extracted to server.
• Created Views, Materialized views, Indexes, Stored Procedures etc. as per reporting requirements.
• Involved in Creating Test Scripts to represent the features and any added new functionality that need to be tested in the application.
• Performance tuning the reports by analyzing and comparing the turnaround times between SQL, Tableau.
• Involved in Testing, Debugging, Data validation and performance Tuning of Reports.
• Trained users on tableau to create adhoc reports using excel files, flat files.

Environment: Tableau Desktop, Tableau Server 9.x/8.x, Oracle 11g, Microsoft SQL Server 2012, Microsoft Windows 7, Oracle SQL Developer, Microsoft Office (Word/Power Point, Excel)

Confidential, Austin, TX

Tableau Developer

Responsibilities:

• Experience in Working with Agile software life cycle methodologies including daily scrums, collaboration and code demonstrations.
• Involved in design and development of facts and dimensions to accommodate all the reporting requirements.
• Expert knowledge of SQL and relational database management systems.
• Provided Production support to Tableau users and wrote Custom SQL to support business requirements
• Developed Ad-hoc reports using Tableau Desktop. Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Involved in generating dual-axis bar chart with multiple measures and data blending in case of merging different sources.
• Involved in creating side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps to assist business users in solving complex problems.
• Extensively worked on global filters for use in exercising dashboard wide control over requests that are embedded into a dashboard page.
• Utilized Tableau server to publish and share the reports with the business users
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, joins, data blending, and dashboard actions.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Assist with Tableau server administration, security configuration including setting up AD user groups, permissions, security roles in cloud environment like Microsoft Azure.
• Coordinated with Clients for feasibility study of the project in Tableau and drawing up the timelines as per project requirement.
• Performed various functions such as processing data, creating reports, analyzing metrics, implementing verification procedures, and fulfilling client requests for information using MS Excel, Word, Access, and Power Point.
• Participated in daily stand-ups with clients on daily design and development effort.
• Performed Data validations, Unit testing and preparation of Unit test cases.
• Provided production support for Tableau users.

Environment: Tableau Desktop 9.0/8.3, Tableau server / Administrator, SQL developer, SQL Server, Oracle 10g/9i, Microsoft Excel 2012, Microsoft office 2012.

Confidential, Austin, TX

Report Developer

Responsibilities:

• Worked closely with project Business Analyst, Data Architect and ETL Developer to ensure that the end to end designs meet the business data requirements.
• Have experience in writing SQL Queries and Stored Procedures based on requirements.
• Experienced in testing databases using complex SQL and TSQL Scripts.
• Experienced in creating database objects like Tables, Views, Procedures, Triggers and Functions using T-SQL to provide definition, structure and to maintain data efficiency.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS and integrated into the web front end.
• Created many complex dashboards by extracting data from many different sources using data blending and joining multiple tables in case of merging data from different sources using Tableau and SSRS for a different set of teams.
• Involved in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS) and other reports using Crystal reports.
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Responsible for Developing Dashboard and preparing ad-Hoc Reporting.
• Assisted with business development activities, such as proposals, capture, whitepapers, conferences, and other thought leadership materials.

Environment: Informatica 8.1.1, HP UNIX, Sun Solaris Oracle 9i, 10g, PL/SQL, Windows 2003 Servers, Agile, Jira.

Confidential, Austin, TX

Database Developer

Responsibilities:

• Participated in the Design Workshops with the different stakeholders of the application and come up with the finalized approach.
• Proficient with SQL and Entity Relationship diagrams.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases
• Created DDL Scripts for database schema and database objects.
• Wrote SQL queries and stored procedures for high volume reports as per the business requirements.
• Highly involved in query optimization and troubleshooting long running queries
• Used SQL Profiler, Execution Plan and Database Engine Tuning Advisor tools to trace the slow running stored procedures and tried to optimize the queries to enhance the performance.
• Rebuilding indexes and tables at regular intervals.
• Created and automated various jobs.
• Worked on TFS, SVN for version control, source control.
• Provided 24/7 support for production databases.
• Performed code reviews and planned test plans for the project deliverables.

Environment: Informatica 6.x, 7.x, Oracle 8,8i, 9i, PL/SQL, UNIX SUN Solaris, Windows 2000/NT, UNIX.

Confidential, SD

Software Developer Intern

Responsibilities:

• Documented technical Specifications for new application features based on use case and functional requirements.
• Supported the maintenance and updating the contents for Confidential Mobility public site based on client’s requirement.
• Have knowledge of Data Warehousing concepts and principles.
• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Analyzed, designed, implemented and tested ad-hoc and standard reports.
• Created Tables, Indexes, Table Spaces, Views synonyms, and integrity constraints.
• Involved in creation of schema objects, roles and privileges, users.
• Involved in Performance tuning, query optimization and execution plan of queries for better performance.
• Gained the ability to work independently as well as with the team.

Environment: SQL Server 2008/2010, SQL, PL/SQL, TOAD. Windows 7, SVN, Toad, Microsoft Office (Word/Power Point, Excel).