SUMMARY

• Over 4 years of IT experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and the related Database Platforms.
• Worked in all phases of BW/BI full life cycles including analysis, design, development, testing, deployment, post - production support/maintenance, documentation and end-user training.
• Strong understanding of project life cycle, SDLC methodologies of Waterfall and Agile.
• Over 2 Years of experience working onTableau (Desktop, Server).
• Good understanding of Data ware housing, Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases.
• Strong hands on experience implementing dash boarding, data visualizations, and analytics using Tableau desktop and Server.
• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.Proficient with MS SQL Server, SSIS, SSRS, SSAS.
• Experience in Data Extraction and Transforming and Loading (ETL) using SSIS packages to manage SQL Server databases andSQL Server objects between instances of SQLServer.
• Extensive experience in Tableau and SSRS for creating Dashboards, stories and published.
• Expertise in generating reports using SQL Server Reporting Services (SSRS) and MS Excel spreadsheets.
• Programming inSQL Server - Using the stored procedures, Triggers, User-defined functions and Views, etc.
• StrongSQL Server DDL, DML skills with understanding of writing efficient queries and troubleshooting complex queries.
• Experience in tuning the performance of stored procedures, database activities like maintenance and performance monitoring and tuning using SQL Profiler and other troubleshooting and monitoring tools.
• Expertise in EnterpriseReporting includes generating reports using linked reports, sub reports and filters, charts in SQL server reporting services (SSRS).
• Experience in developing management reports using SSRS (SQL Server ReportingServices)
• Good understanding of technical trends, architectures and highly motivated to know more about latest technology, new software and products.
• Team player with good communication and interpersonal skills.

TECHNICAL SKILLS

Programming Languages: T-SQL, PL/SQL, R Script, Python, Javascript, Angular JS .

RDBMS/Databases: MSSQL Server, MY SQL, PostGreSQL, MONGO DB

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analytical Services (SSAS),Visual Studio, BIDS,Tableau 8x/9x/10.0

Application Packages: MS Office, Microsoft SharePoint Server (MOSS) 2007

Version controll system: GIT

Issue track system: JIRA

SDLC: Agile, Scrum,Waterfall

PROFESSIONAL EXPERIENCE

Confidential, Palo Alto

SQL/BI/Tableau developer

Responsibilities:

• Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server Reports Services (SSRS).
• Maintained disaster recovery and database maintenance plan. Monitored SQL Server jobs, and developed queries to perform database operations.
• Resolved any deadlocks issues with the databases/servers on a real-time basis
• Performed job scheduling and alerts.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel and SQL Server.
• Extra level of security implemented by creating views and creating stored procedures to query the confidential data.
• Administered user, user groups, and scheduled instances for reports inTableau
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Adjust views/dashboards after initial POC presentation with new features of tableau 10.0.
• Build better dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data.
• Experienced in requirement gathering/analysis, design, development, testing, and production rollover of projects.
• Train end client users onTableau Desktop by providing step-by-step guidance from basics to advanced functions of Tableauincluding working with calculations, parameters, and date functions.
• Involved in creating dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axes bar chart with multiple measures.
• Worked extensively with Advance analytics like Reference Lines and Bands, Trend Lines.
• Expertise in working with data building Groups, Hierarchies, and sets.
• Mastered in different Formatting techniques, using Annotations and Mark labels.

Environment: PostGreSQL, MY SQL,HTML, CSS, Javascript, Angular JS, GIT, Tableau 9x/10.

Confidential, Arizona

SQL/BI/Developer

Responsibilities:

• Created advanced chart types, visualizations and complex calculations, Analytics, BIand Production Support issue resolution.
• Responsible for creating database objects like table, views, Store Procedure, Triggers, Functions etc.
• Worked on ETL Processes (SSIS) to build data warehouse using different components (control flow, data flow and event handler).
• Wrote SQL queries using Joins and Sub queries to retrieve data from multiple tables.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel Spreadsheet, Flat Files and OLEDB Sources.
• Creation of SSIS packages to load into data marts.
• Identified and included report parameters.
• Good knowledge on OLTP databases.
• Worked on drill-down, drill-through, parameterized, chart, gauges, data driven reports using SSRS and successfully deployed on report manager.
• Worked extensively with advanced analysis Actions, Table calculations, Parameters, Maps, Trend Lines, Background images, Groups, Hierarchies &Sets to create detail level summary reports and Dashboards on Tableau.
• Strong in writing calculated fields, publishing customized interactive reports and dashboards using Tableau server.
• Created bar charts, scatter plots, pie charts & parameters as per the desired functionality.
• Developed Tableau data visualization using Pareto's, Combo charts, Heat maps, Box and Whisker Charts, Scatter Plots, Geographic Map, Cross tabs, Histograms etc.
• Generated Tableau dashboards for sales with forecast and reference lines.

Environment: MY SQL, MONGO DB, HTML, CSS, GIT, Tableau 9x

Confidential

Jr. SQL/BI Developer

Responsibilities:

• Created ER diagrams to the proposed data base.
• Worked on development of data ware houses.
• Created data base objects such as tables, views, stored procedures, triggered etc.
• Designed SSIS packages, extracted data from OLTP to OLAP.
• Performed various tasks like creating cubes, task processing and update using SSAS.
• Developed monthly reports using SSRS to generate drill down, drill through reports.
• Performed data extraction from various data sources (SQL server) and Data loading into target sources using SSIS.
• Performed database and BI (ETL, OLTP, OLAP, and Reporting) services for various applications.
• Design, deployment, and maintenance of variousSSRSReports in SQL Server.
• Queried against Heterogeneous Data Sources to retrieve records for data loads using SSRS.
• Created Triggers to enforce data and Referential Integrity.
• Worked on SSRS to generate drill-down, drill-through, parameterized and ad-hoc reports.

Environment: SSMS,SQL SERVER