SUMMARY:

• Business oriented, visionary and productive professional with over 8 years of experience in Business Intelligence, Programming, Data Analysis, Data Warehouse development, Database development, ETL Process, Data Science and Upgrade Projects across domains like Healthcare, Finance and Retail.
• Adept at translating business needs into end user interactive reports thereby aiding business decisions with demonstrated experience in Analysis, Design, Development, Implementation, Modeling, Testing, and support for Data warehousing applications such as Snowflake and Teradata.
• Proficient at providing competitive intelligence and actionable insight into the projects, ability to design and deploy rich, thoughtful visualization & Visual Analytics using Tableau/MSTR, SSRS and QlikView; skilled in using MSTR architect, distribution services, Narrowcast server, intelligent cubes, enterprise manager, Integrity Manager.
• Expert at devising scalable reporting solutions, automation tools and processes as such as Grid vs Visualizations to provide mission - critical intelligence for profitable business actions, tactics strategies with hands on experience in using various project tracking tools such as JIRA, Confluence.
• Working experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS and T-SQL Programming using DDL, DML, and DCL commands for various business applications, SQL performance tuning expert; with strong expertise in cloud computing platforms such as Snowflake, Microsoft Azure Storage Blob. Experience in upgrading from Teradata to Snowflake.
• Highly proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle; successfully leveraging existing business intelligence and analytic assets to successfully integrate the company's BI operations cross all company departments.
• Experience in writing scripts using Python libraries, packages and frameworks for various enterprise activities.
• Good experience in writing UNIX shell scripts, SQL scripts for development, automation of ETL process, error handling and auditing purposes.
• Successfully migrated over 100 Tableau reports from Teradata to Snowflake data warehouse while single-handedly managing the pre-validation, developing plan, post validation, migration, quality assurance, data validation, production deployment and production support.
• Led Teradata to Snowflake migration, Involve in Enterprise Datawarehouse remodeling project (Robling) and successfully converted, 100 0s of ddls, sqls, shell scripts.
• Analyzed data and provided rich visual analytics which aided the decision making thereby improving the business using various Python libraries such as Pandas, Numpy, Sklearn, Matplotlib, Seaborn, Machine Learning, etc.
• Worked with Business executives in the Finance and identified key areas that would benefit from a modern data analytics strategy and developed Finance Operations dashboards and KPIs.
• Tableau expert providing E2 E support for all the key projects across the firm.
• Worked with various business teams to provide analytics, reporting and self-service BI which aided key business decisions to improve profitability, improve business, drive down controllable expense, recover lost revenue and helped improve potential savings.
• Developed business intelligence through modern reporting tools such as Tableau and MicroStrategy thereby providing cost-effective and time saving solutions for the performance of sales.
• Completed the warehouse Teradata to snowflake migration project within 3 months against the Confidential of 6 months.

EXPERTISE AREA:

• Business Intelligence
• Data Analysis
• Requirement gathering
• Project management
• SDLC
• Problem-solving
• Effective communication
• Scripting
• Team management

TECHNICAL SKILLS:

BI Tools: T ab l e au 10 / 2 01 9, Mi c r oSt rat e gy 10. 5, SQL Serve Reporting Services (SSRS), SQL Server Integrating Services (SSIS), QlikView 9

Cloud Technologies: Microsoft Azure Blob Storage, Snowflake

Programming Languages: C, C++, SQL, PL-SQL, HTML, XML, Python 3.5Shell Scripting (Bash/Korn)

Database: Snow f l ake, Pos tgreS Q L, T e r ad at a, SQL Serv e r 2 005/2 008/201 2 , Orac l e 1 1 g/ 1 0g/9 i /8i

Operating Systems: Wi nd ow s X P /7 /10/20 1 2 R 2, Li nux, UNIX

Other Tools/Technologies: GIT, bitbucket, CA Harvest, Agile Methodology, Scrum, Jenkins, Autosys, SourceTree for GITSharePoint, MSAS, TFS

EXPERIENCE:

Confidential

Sr . Business Intelligence Consultant | Data Analyst

Responsibilities:

• Requirements gathering & system specification, Lead, E2 E delivery of Tableau Development/Administration.
• Creating MicroStrategy, Tableau Documents/Dashboards utilizing Tableau, MSTR Visualizations.
• Deriving data-driven insights, enabling rapid analytics through snowflake data warehouse cloud technology.
• Developing the Finance Operations dashboards and KPIs, providing on Snowflake and Tableau and helping reach the tools reach across the organization and educate the users to do more self-service BI.
• Extensively involve in Enterprise Datawarehouse remodeling project and convert the existing complex sqls, ddls, datamarts to Robling Enterprise Data Model.
• Provide solutions on the challenges for the Tableau reporting which doesn’t come as an inbuilt functionality within Tableau such as creating the default date parameters, custom dynamic axis titles, etc.
• Involve in upgrade activities for migrating from Teradata to Snowflake data warehouse. Knowledge on Snowflake administration activities.
• Use Microsoft Azure Blob Storage to effectively store and access the data needed for the Data Warehouse.
• Work on integrating SnowSQL with Linux/UNIX Bash environment to implement automated fashion. Use various Snowflake functionalities to automate data warehouse tasks.
• Extensively Involve in upgrade activities for migrating from Teradata to Snowflake data warehouse. Knowledge on Snowflake administration activities.
• Develop code related to SQL in Snowflake, Teradata, Python and Shell scripting as per the changing needs of the projects for file transfer and automation.
• Creating and automating repeated tasks using Teradata components such as FLOAD, MLOAD, BTEQ and Fast Export.
• Working on self-service BI dashboards using MicroStrategy intelligent cubes, relational databases to handle huge volume of data.
• Work on Environment Upgrades such as MicroStrategy Upgrade (9 to 10.5 ), Tableau Upgrade (10.2 to 10.5 ), involve in various administrative activities and ensure the functionality does not break with the upgrade.
• Managing E2 E project delivery, testing, QA and preparing multiple Unit Test Cases, QA Test cases and promoting the code to Production after acquiring the Project Group Approvals.
• Resolve several Production support issues related to Tableau Dashboards, SQL scripts, MicroStrategy reports and Shell scripts and Python code.
• Overlooking the complete System Development Life Cycle (SDLC) and Agile Scrum methodology, using JIRA and confluence extensively for the Project tracking.

Business Intelligence Developer

Confidential, Enfield, CT

Responsibilities:

• Worked closely with business users to create reports/dashboards using Tableau Desktop and provide feasible solutions for the reporting.
• Created Tableau dashboards using Stack bars, bar graphs, scatter plots, geographical maps, Gantt charts using as per the requirements from the business users.
• Created MicroStrategy prompts, filters, templates, reports, metrics, consolidations, and custom group objects in an enterprise data warehouse team environment.
• Implemented best practices and standards in developing Tableau/MSTR reports.
• Wrote scripts for Data Extraction, Transformation and Loading of data from various systems to Enterprise Data Warehouse using BTEQ, Fast Load, FastExport, Multiload, Tpump.
• Involved in testing and QA the SQL Scripts, UNIX/LINUX shell scripts for report development, Tableau/MSTR Dashboards, Scorecards and handled the performance issues effectively.

Tableau/ MicroStrategy Developer

Confidential, Enfield, CT

Responsibilities:

• Led reporting platform and responsible for end to end delivery of the reports.
• Developed Key Performance Indicators (KPI) dashboards that provides Trends of specific period using Tableau/MSTR.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, Level-of-Detail (LOD), calculated fields, sorting, groupings, live connections and extracts in Tableau.
• Worked on Teradata Enterprise Data Warehouse Design, Development, testing and supported Extract, Transform and Load (ETL) processes necessary to load and validate data warehouse using UNIX shell scripting.
• Worked on end to end data validation for the data warehouse, create test scripts, unit testing and QA.
• Wrote Teradata FastLoad, FastExport, BTEQ and MultiLoad utilities for loading the millions of records data.
• Worked closely with ETL developers for the new requirements, create data files and new integrations into data warehouse. Knowledge on ETL process and ETL Informatica.
• Used Autosys for Enterprise jobs scheduling, jobs monitoring and create JIL files for the new scheduled tasks.

Confidential, Boston, MA

Tableau/SSRS Developer

Responsibilities:

• Created complex and routine reports stating revenue, cost based on products using cascading parameters and Tablix structure in SSRS.
• Developed and deploy packages in SSIS, imported data on daily basis from the OLTP system, Staging area to databases.
• Created multiple UNIX shell scripts to conditionally validate, schedule and automate the ETL tasks and performed required actions on SQL Server database

Confidential

SQL/SSRS/SSIS/ Developer

Responsibilities:

• Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Created and Modify stored procedures, functions, views, Triggers and Dynamic Cursors in PL-SQL for maintaining SQL server databases and assigned permissions to a role for Stored Procedures for Application Developers, performance tuning of queries.