SUMMARY

• 14+ years’ experience in IT industry with a strong background in Analysis, Design and Development in the field of Database and implementation of Business Intelligence applications. Extensive experience in Software Development Lifecycle (SDLC) managing project scope, requirement definition, resource management, change management, analysis, managing work schedules, project status reporting, project coordination and conflict resolution.
• Expert in Data Visualization development using Tableau, Power BI and Salesforce to create complex, intuitive, and innovative dashboards.
• Extensive experience in strategizing for Tableau Architecture and implementing for projects with Snowflake/Big Query/SAP HANA/SAP BW/SQL Server/Salesforce Sales Cloud as data - sources.
• Developed Source-Target mapping documents for the Dimensions and Fact tables
• Integrated custom visual based on business requirements using Power BI Desktop.
• Extensively used Alteryx workflows to process Extract, Transform and load the data into stage area and warehouse.
• Hands on experience in using the Alteryx for data cleansing and standardization.
• End to end experience in designing and deploying data visualizations using Tableau/Wave/Einstein Analytics.
• Strong in writing complex SQL Queries, functions, views in Oracle PL/SQL & SQL (9i/10g/11g) and used Database utility tools like SQL Plus, and SQL Developer.
• Hands on experience in creating tables, views, and stored procedures in Snowflake.
• Hands-on experience with Snowflake utilities, Snow SQL
• Able to administer and monitor Snowflake computing platform
• Extensive experience working with Salesforce Sales Cloud/Pardot as a report developer, and SME.
• Highly analytical, research and process-oriented data scientist with in-depth knowledge Machine Learning and big data capture, cleansing, curation, training and render as a service for later consumption in visualization.
• Hands on experience in building models like linear regression, Random forest and Logistic regression using Python.
• Proven ability to deliver and ensure success in high-pressure/high-risk situations.
• Proficient in Troubleshooting, code fixing for Production Reporting Problems.
• Smart learner, Team player and can motivate team to accomplish deliverables
• Excellent in Problem solving, multi-tasking, experienced and willing to work on 24/7 schedules

TECHNICAL SKILLS

Operating Systems: Windows 2000/2003/2008 , VISTA, MS DOS, UNIX.

Programming Languages: Python, C, Java, J2EE, Unix Shell programming Perl, Java script, HTML, CSS.

CRM Tools: SAP CRM, Salesforce, Salesforce Marketing Cloud Perl, Java script, HTML, CSS.

Reporting: Tableau, Power BI, JMP, Einstein Analytics, SAP Analytics Cloud, SigmaMatplotlib, Plotly, Google Analytics, MapBox.

Packages: UML

Databases: Snowflake, SAP HANA, Sybase, Netezza, SQL Server 2005/2008 MS Oracle 9i/10g/11g, MS Access.

ETL: Alteryx, AWS Glue,SAS Pandas, Azure Data Factory, ZEMA.

Web Servers: Apache Tomcat, Web logic Server 8.1/9.2/10, MS IIS 5/6.0

Other Tools: Toad, Putty, Workflow, SQLDbx, Aginity, ITRS, Aquadata studio,NZ Admin, MSTR Desktop.

PROFESSIONAL EXPERIENCE

Confidential, LA

Sr Tableau/Power BI/Snowflake Developer

Responsibilities:

• Interpreted complex Business specifications developed by the client and generated reports and interactive dashboards to meet customer specifications.
• Engaging with business users and team to support Tableau Enterprise Platform.
• Created Complex Tableau visualizations with complex chronological parameters to control multiple dual axis customized charts.
• Prepared powerful reports by applying Level of Detail (LODs) calculations, Tableau Functions, Quick Table Calculations, Calculated Fields, Parameters, Filters, Reference Lines, Sets, Groups, Bins, and other features and capabilities of Tableau Desktop.
• Designed Power BI Reports and published on Power BI server.
• Expertise in writing complex DAX functions in Power BI. Worked on calculated Columns, Measures queries in Power BI desktop to show good data analysis techniques.
• Worked on all types of transformations that are available in Power BI query Editors.
• Created Workspaces, Dashboards, Apps and Content Packs for Business users to view the developed reports.
• Expertise in implementation of Row Level Security (RLS).
• Worked on implementing SSO and developing Sigma reports.
• Hands on experience in creating tables, views, and stored procedures in Snowflake.
• Hands-on experience with Snowflake utilities, Snow SQL, Snow Pipe
• Created Streams and Tasks to automate data processing in a CDC manner.
• Created data sharing between two snowflake accounts.
• Developed data warehouse model in snowflake.
• Worked on data migration from east to west snowflake accounts.
• Experience in using Snowflake Clone and Time Travel.
• Able to administer and monitor Snowflake computing platform
• Worked on Snowflake JavaScript UDFs
• Extracted and loaded CSV files, json files data from AWS S3 to Snowflake Cloud Data Warehouse.
• Design and implemented metadata models
• Created ETL using Python API’s/AWS Glue/terraform/Gitlab to consume data from different source systems (smartsheet/ QuickBase/ google sheets) to Snowflake.
• Flattened and transformed the Kafka payloads at different tree levels.
• Hands on experience in SQL/Snow SQL of Oracle/SQL Server/Snowflake.

Environment: Tableau, Power BI, Snowflake, Sigma, Python, Anaconda, AWS Glue, Terraform, Gitlab Microsoft office, JIRA.

Confidential, TX

Sr Tableau/Power BI/Snowflake Developer

Responsibilities:

• Have extensive experience in sourcing, processing, managing, and distributing business-driven and actionable visual reports for key stakeholders using Tableau.
• Worked on generating various dashboards in Tableau/Power BI using various datasources like HANA, Snowflake, Salesforce, Oracle, SQL server, Excel, MS Access.
• Created Mobile dashboards and embedded in Salesforce App using Tableau Sparkler for SSO purpose to provide sales users one stop shop experience.
• Worked on integration and implementing security while embedding Tableau dashboards inside Salesforce, using Row level/ user filter concepts.
• Built dashboards which will provide insights Snowflake usage statistics.
• Created Live and Extract dashboards on top of Snowflake DW
• Solely took care of Admin responsibilities of the Tableau Server hosted on Azure cloud.
• Integrated custom visual based on business requirements using Power BI Desktop.
• Developed Complex calculated measures using Data Analysis expression language (DAX).
• Proposed users to use Power BI in replacement of Analysis for Office, to run reports connecting to Snowflake.
• Developed user friendly dynamic Dashboards and empowered users by enabling them to have multiple selection options using Parameters, Filters and Dashboard Actions (select, hover & URL) to slice and dice the data and gain in-depth insights to make timely and accurate decisions to realize sustainable business growth.
• Used MapBox for creating effective map charts.
• Worked on many POC’s with existing/new Reporting, ETL (Alteryx/Trifacta etc.), Cloud (AWS/Azure) applications to assess best environment to better serve for global users.
• Worked on a POC sourcing data from SAP Hana to JMP.
• Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project & business stakeholders throughout the project life cycle.
• Work mostly focused on Sales and Marketing projects and create dashboards for them.
• Facilitated cross-training and mentoring within the IT team to ensure effective support and on going personnel development. Analyze the existing requirement for Business.
• Hands on experience in using the Alteryx for data cleansing/standardization connecting to SAP HANA/Salesforce/Excel.
• Hands on experience in SQL/Snow SQL of Oracle/SQL Server/Snowflake.
• Hands on experience in maintaining tables, views and stored procedures in Snowflake.
• Strong knowledge of sourcing data to Snowflake from SAP / SAP BW using ADF, Alteryx.
• Worked on setting up profiles in ZEMA for consumption of Third Party datasources (plats/HIS/PMI etc.) for consumption to internal projects.
• Experienced working with Google Analytics/Big Query for the Digital Marketing project.

Confidential

Jr Data Scientist

Responsibilities:

• Built models like linear regression, Random forest and Logistic regression using Python.
• Performed feature reductions, exploratory data analysis.
• Predicted the propensity of a customer to make a purchase of product using Random forest model.
• Worked on Market Basket analysis, MB Affinity/MB Inspect tools in Alteryx to find the strong association for the chemical products for Target Marketing to existing customers and prospects.
• Predicting the nearest prospects within same industry of the current existing customers using K-Nearest Neighbor Classification Technique.
• Developed visualizations to create better understanding of data using Python Matplotlib, Plotly and Tableau.
• Confusion matrix, lift to validate the models.

Environment: Tableau, Power BI, Alteryx, SAS 9.1.3 Salesforce (Sales Cloud/Marketing Cloud/Wave/Einstein Analytics/Pardot),MapBox, Machine Learning, Python, Anaconda, Microsoft office, MS-Access, SQL Server, SAP BW, SAP Hana, BEX/AO(Analysis for Office) Snowflake, Azure Cloud, Big Query.

Confidential, NY

Tableau Developer/Support Specialist

Responsibilities:

• Worked directly with Business Lines in Retail, Risk Management, and Commercial Lending to gather dashboard requirements for development.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, heat maps, bullet charts, Gantt charts demonstrating key information for decision making.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary reports and dashboards using KPI’s
• Created, organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Hands-on development assisting power users in creating and modifying worksheets and data visualization dashboards for departmental consumption.
• Creating Incident Management tickets when SLA is missed
• Creating RFC’s when there is urgent/regular releases.
• Monitoring the ITRS tool to see the health of whole application.
• Co-ordinating between the DBA’s and Development teams when there is some issue to resolve it with in SLA.
• Proactively acting upon Autosys issues.
• Document and share own learning’s from the project seek information and leverage knowledge from other project in order to drive higher efficiency effectiveness.
• Learn from feedback, promote learning and drive proactive and viable innovation by encouraging openness to new ideas and risk taking.
• Handling Problem management for re-occurring issues.
• Automations of manual tasks to reduce day to day support effort.
• Testing the urgent/regular release items in UAT before deploying in to production environment.
• Training & Mentoring Team Members

Environment: Tableau Desktop 8.0/7.0, UNIX Shell Scripting, Sybase IQ, ITRS, Autosys(Scheduler), Sybase ASE 11.9 SQL developer, SQL 2008, Oracle 10g, Microsoft Excel 2007, MS Access, Windows 2007 server, java 1.5 platform, Microsoft Office 2007

Confidential

Java Programmer

Responsibilities:

• Performing enhancements to existing functionality and implementing fixes to the production system.
• Ensure availability of document/code for review
• Ensure Review Request corresponds to the actual document/code that needs to be reviewed
• Ensure all relevant documents (checklist provided by the client if any, documents from previous phases, IQA review records along with substantiation of IQA defects closure, tailored templates if any for the division for the artifact being reviewed or any other important information that the offshore team should be aware of before performing the review) are available
• Preparation and review of documents (BRD, LLD, HLD, Test case) for enhancements.
• Collecting review metrics for the project
• Analysis of client supplied documents
• Collect various process and product metrics in the project and update in IRIS.
• Monitoring and tracking the project status by using the tool IRIS System Study
• Use IPMS for all project management related quality activities.
• Checking the quality of the software and determining it’s degree of compliance to standards by using the tool ASA
• Automating the code review process by using the tool ASSENT.
• Site Administration process for critical updates
• Training & Mentoring Team Members

Environment: Core Java, Java Script, JSP, Servlets, AJAX, Struts, JDBC, Tomcat.