QUICK SNAPSHOT:

Experienced resource with expertise in Cloud, ETL and Tableau reporting experience. With experience understanding the different schema’s in Data warehouse and creating live reports using Tableau and redshift views and power BI. Experience writing complex SQL queries for data manipulation, cleansing and loading into RedShift.

PROFESSIONAL SUMMARY:

• Around five years of experience in developing live and interactive reports using Tableau and Power BI.
• Experience handling ETL and ELT processes using tools like Data Stage and Matillion.
• Involved in different aspect of Business and Data analysis including data collection, storage and identifying KPI’s.
• Worked with different cloud - based data warehouse like Redshift and Google BigQuery.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau Desktop, Tableau Server.
• Experienced working with stakeholders and creating reports runtime to finalize requirements.
• Designed and created data extracts, supporting SSRS, Power BI, or other visualization tools reporting applications.
• Experienced in exploring data in a variety of ways and across multiple visualizations using Power BI and creating multiple kind of Power BI Reports and Dashboards.
• Experience in complete project life cycle including documentation, analysis, and development.
• Specialized in creating complex queries and procedures using SQL Server.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS).
• Good knowledge in developing and designing reports through SSRS and Excel.
• Created Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Managed packages the in SSISDB catalog with environments, automated execution with SQL agent jobs.
• Experienced in processing Batch Jobs and offered services to support the application job failures.

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Sr. ETL/Tableau Developer

Responsibilities:

• Performed requirements gathering, analysis and source data analysis and identified business rules for the development .
• Designed ETL jobs as per the technical requirement and source to Confidential mapping.
• Worked with the business in identifying their KPI’s before creating reports and filters and modified until the business approved the same.
• Created test plans and performed the Unit testing, Integration testing and System testing for the ETL jobs.
• Created Interactive Dashboards in Tableau with Context filters, Quick filters, Parameters and Actions to handle views more efficiently.
• 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.
• Created customized Calculations, Sets, Conditions and Filter (Local, Global) for various analytical reports and dashboards
• Developed various reports using best practices and different visualizations like Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables
• Performed analysis to build Tableau extract data sources leveraging existing data mart.
• Created advanced mapping, transformations, and workflows using Informatica PowerCenter 8.x then exported the csv files to use in Tableau.
• Involved in Performance Tuning of mappings in Informatica.
• Extracted data from different source file and migrated into SQL Server 2014 using Talend Data Integration.
• Good knowledge of version control like SVN, GIT and GitHub.

Environment: Google BigQuery, Matillion, Mongo Db, Postgres, Tableau 8.1, Windows XP, Microsoft Office Suite (Word, PowerPoint, Excel).

Confidential, Dallas, TX

SQL/Power BI Developer

Responsibilities:

• Involved in Data modeling, designing, and building relational databases.
• Designed logical and physical data models and create DDL scripts to create database schema and database objects.
• Used Azure SQL to manage the data and optimized the queries to take advantage of the columnar nature of the database.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
• Worked on Tabular Model and imported it into Power BI.
• Created designs and process flow on to how standardize Power BI Dashboards to meet the requirements of the business.
• Worked on making data visualization in a variety of ways of multiple visualizations using Power BI.
• Designed and create Report templates, bar graphs and pie charts based on the financial data using Power BI.
• Used Power BI power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.
• Created DAX calculated columns in Power pivot worksheets to extract, import and join data that coming from different sources
• Worked on Power BI to import, shape, and transform data for business intelligence BI, visualize data, author reports, schedule automated refresh of reports and create and share dashboards based on reports in Power BI desktop.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS) and Power BI.
• Worked on designing Power BI report layout, adding tables/matrix/pie charts, creating DAX measures, calculated columns, formatting the report/fields, validating the data against the excel manual reports for its accuracy and performance.

Environment: Azure SQL, SQL Server, Microsoft Visual Studio 2012, Windows 7, MS Office, Dax, SSIS, SSAS, SSRS, SharePoint, Power pivot, Power view, Power BI.

Confidential

IBM Data stage Developer

Responsibilities:

• Designed and developed various new processes, Fixed the existing process with business requirements, and meetings with users for Input.
• Designed and developed jobs for extracting, transforming, integrating, and loading data into data mart using DataStage Designer .
• Developed, executed, monitored and validated the ETL DataStage jobs in the DataStage designer and Director Components.
• Worked with DataStage Director to schedule, monitor, analyze performance of individual stages and run DataStage jobs.
• Generated Surrogate Keys for composite attributes while loading the data into Data Warehouse using Key Management functions.
• Developed user defined Routines and Transformations for implementing Complex business logic.
• Developed Job Sequencer and batches and have edited the job control to have jobs run in sequence.
• Imported Metadata from Oracle database. Imported metadata definitions into the repository. Exported and imported DataStage components.
• Involved in the preparation of ETL documentation by following the business rule, procedures and naming conventions .
• Performed Troubleshooting and Tuning of DataStage Jobs for better query performance.
• Reviewing the developed jobs based on the build review checklists.
• Responsible for Unit, System and Integration testing. Developed Test scripts, Test plan and Test data.

Environment: IBM Infosphere DataStage 8.7/8.5(Parallel Extender, Quality stage), PVCS Version Controller, Citrix, Mercury Test Director, Control-M Scheduling, Oracle, Teradata and UNIX.

Confidential

Junior Business Analyst

Responsibilities:

• Actively involved in SCRUM and Sprints of agile methodology.
• Actively participated during requirement analysis, design, development, testing and implementation of functional enhancements.
• Created various stored procedures to facilitate the requirements.
• Created and tested various connection property files for various environments.
• Involved in Data Modeling, Database Design, Designing of Data Flow Diagrams for Regression process.
• Extracted, discussed, and refined Business Requirements from Business Users and team members.
• Facilitated and managed meeting sessions with committee of SMEs from various business areas.
• Facilitated (JAD) Joint Application Development sessions to identify business rules and requirements with Business Teams.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and Collaboration Diagrams.
• Coordinated activities between Business Unit and Technical Staff, developing new methods, policies, and procedures to meet the business needs.
• Wrote extensive SQL queries to retrieve information from the SQL Database Server.

Environment: Agile Scrum, SQL, XML, MS Visio, MS Excel, MS Word, MS PowerPoint, Agile, Waterfall,JIRA.