PIYALI CHOWDHURY

additm@r.postjobfree.com Mobile: +1-647-***-**** Toronto, ON

LinkedIn Profile: https://www.linkedin.com/in/piyali-chowdhury-b46379136/

Tableau Public Profile: https://public.tableau.com/profile/piyali.chowdhury#!/

Github Profile: https://gist.github.com/Piyali-TCS/435b14328a98d917f56429c77a9c114b

PROFESSIONAL PROFILE

A highly motivated and results-oriented IT professional with 6+ years of rich experience in gathering business requirements, analysis, design, development, integration, implementation and support of enterprise Data Warehouse and BI applications. Strong client facing experience supported with effective communication and interpersonal skills.

Areas of expertise include:

ETL

SQL/PL-SQL

Data Profiling

Data Quality

Data visualization

BI Reporting

Python

AWS

Hive, Hbase, Sqoop, Hadoop

Data Blending & Transformation

Business Analysis

Excel

Requirement Gathering

Business Process/Data Modelling

SDLC

Agile

User Support

Incident Management

Project Management

SLA Management

TECHNICAL PROFICIENCY

ETL Tools: Informatica Power Center 9.6, 9.1, 8.6, IBM InfoSphere, DataStage and QualityStage

Databases: Teradata 16.10, Oracle 9i & 10g, Oracle 12c, PostgreSQL, MS SQL Server 2008, Hive, Hbase

Visualization Tools: Tableau Desktop 10.2, Tableau Desktop 9.x, Tableau Server 9.x

Languages: SQL/PL-SQL, T-SQL,Unix, Sqoop

Project Management: JIRA

Scheduling Tools: Autosys, Control-M, TIDAL

Methodologies: Agile, Kanban

Domain Experience: Life Science, Pharma Domain(Clinical Trials),Pharma Supply Chain, Bank Services & Retail Services

ACHIEVEMENTS & CERTIFICATIONS

[PCEP-30-01] PCEP – Certified Entry-Level Python Programmer.

Tableau Desktop 10 Qualified Associate Certified.

Completed course in Big Data Hadoop Developer by Insanalytics, India.

Achieved On The Spot Award for exceptional performance in Q4,2016.

Received a Special Initiative Award in Q1,2016 in a team of 15 members.

ITIL FOUNDATION v3 Certified.

Certified in Parma Management of TCS Business Domain Academy.

Certified in Life Sciences of TCS Business Domain Academy.

RECOMMENDATIONS

CAREER HIGHLIGHTS

Good understanding of BI and DWH concepts with ability to translate business needs into designs and deliver the services within the context of the business.

6+ years’ of experience on Informatica Power Center 9.x, Oracle (SQL & PL/SQL), Data Warehousing and UNIX.

6+ years’ experience in SQL/PL-SQL, functions, procedures and packages. Efficient in oracle performance tuning using index, table/index partitioning.

3+ years’ experience in Tableau. Designed and implemented sophisticated BI Dashboard Solutions with Tableau.

Flexible to write program in Python. Responsible for bug fixing on interfaces/integration flows.

Understanding of concepts and components related to Data Management, such as Data Architecture, Data Models, Data Lineage, Data Dictionary, Controls etc. Experienced in process improvements and best practices, database environment control and change management.

Worked as Data Architect and business analysts to design complex DW/BI solutions.

Informatica/Oracle tuning expert with strong understanding of the Oracle Architecture and the design. Extensive SQL and PL/SQL programming experience including packages, stored procedures, functions, triggers, indexes and exception handling. Create database objects like tables, views, sequences, synonyms, indexes. Responsible for designing, developing and documenting complex T-SQL, stored procedures, views, triggers etc.

Strong hands on experience in AWS eco-system (S3/Redshift/ec2) and Big data eco system (Hadoop, Hive, Sqoop, Hbase).

Excellent skills in Application documentation including functional specifications documents, requirements specification documents, low and high level technical design documents and User Manuals.

Investigated all SLA shortfalls and performed Root Cause Analysis. Experience in working on all the phases of SDLC lifecycle like requirement gathering, development, unit testing, SIT, UAT, implementation, production support.

Experience to work on multiple projects using Waterfall or Agile model. Knowledge on the phases of agile methodology and scrum methodology.

Experience on JIRA, confluence. Attended service level meetings with managers covering performance reports, service improvements, quality, and processes.

Excellent interpersonal, cross-functional, communication, writing, and presentation skills.

PROFESSIONAL EXPERIENCE

Business Intelligence Developer & Data Analyst May 2019 – Nov 2019

TCS, India

Client: Banking Services – TD Bank

Project processes different accounts data from multiple source systems under CANADA and US LOB. Data for different accounts from different source system gets processed through MDM and IBM InfoSphere DataStage & QualityStage and stored into DW.

Proposed a process improvement plan for the existing application to the client and it was accepted.

Successfully implemented my idea into current system.

Received corporate client appreciation for my work.

Performed data profiling and analysis of source systems by running SQL queries to analyse data and view results. Dive deep into data issues to find root causes that lead to data quality improvement.

Created reporting tables in database to capture daily job status and their processing rows through ETL jobs.

Built a script in Unix which captured the required information in some .txt files after reading from job logs.

Performed impact analysis of the requested changes from business for existing ETL codes in Data Stage tool.

Performed Unit testing, System Integration testing of the mappings, workflows.

Built UCID status report for different LOBs in Tableau Desktop and scheduled it once published it in Tableau Server.

Applied Conditional formatting, Action filter, Data Blending in Tableau Dashboards.

Technology: Oracle SQL Server, UNIX, Autosys, IBM InfoSphere DataStage & QualityStage, Hadoop, Tableau Desktop 10.2

Business Intelligence Developer & Data Analyst May 2018 – Apr 2019

TCS, India

Client: Healthcare Supply Chain – J&J Medical Devices

Project integrates MD&D data elements from multiple ERP systems into the Enterprise Data Warehouse for Supplier Delivery (Good Receipts) and Janssen Data warehouse for Schedule Attainment & Capacity Utilization, Forecast, Inventory, OTIF (LIFR) and Bill of Materials (BOM), projected inventory and targeted inventory to provide visibility on the respective Subject areas.

Worked closely with business SME and Internal Business Partners (IPs) to clarify business requirements and translate the requirements into technical specifications.

Performed impact analysis and gap analysis for changes to the existing data warehouse.

Developed views, functions, procedures, and packages using SQL-PL/SQL to load data from heterogeneous source system into target tables.

Designed and developed ETL mappings based on the customer needs and gathered details of business logic changes in existing ETL load mappings and then implemented business logic changes in existing ETL codes as per the requests from business.

Built Sales and Inventory reports in Tableau and published those in Tableau Server and scheduled those reports.

Applied context filter for performance improvement in reports. Used normal and quick filter to improve user experience of reports. Used different date calculation functions QTD, PQTD, YTD, PYTD, MTD as a KPI in sales growth report.

Created cross tab reports, donut, pareto chart and other charts as well based on client requirements making user understand easily.

Created User Stories in JIRA, log all work for different stages of development to implementation in JIRA.

Estimated, planned, scheduled, tracked and delivered requests received on a weekly basis.

Conducted impact analysis of the requested changes from business for existing ETL codes.

Carried out Unit testing, System Integration testing of the mappings, workflows. Created UAT test cases and scenario documents.

Technology: Informatica 9.6, Teradata 16.10, Tableau, UNIX, Autosys

Business Intelligence Developer Sept 2017–Apr 2018

Ample Organics, Toronto, ON

Client: Cannabis Supply Chain

This cannabis software solution reports every stage of business, from seed to sale, and from patient to government.

Accountable for to building a BI reporting platform and solutions for cannabis supply chain in ON.

Involved in analysis of end user requirements and collaborated closely with Senior Manager in understanding of the current system.

Provided high-level solutions for each situation and always delivered expected result successfully.

Created dimensionally modelled relational model.

Created sales growth reports in Tableau using list, cross tab, drill through, drill up down, charts, filters, bursting of reports, etc.

Worked in special date calculation functions; applied different KPIs QTD, PQTD, YTD, PYTD to show the Sales Growth.

Built Cannabis Seed to Sales report, Bottles to Sales report and Customer by Geography.

Created different charts like donut, histogram, lollipop, Waffle, stacked bar, waterfall chart and more other charts as well based on client requirements.

Got a appreciation for all of my delivered work from my senior manager.

Technology: Tableau, PostgreSQL

Business Intelligence Developer May 2016 –Jan 2017

TCS, India

Client: Life Science & Health Care (Pharma) J&J

Enterprise Data-ware House Project involves L3 support Enhancements, which includes change requests and ad hoc requests for the application. EDW prepares the data for many downstream applications such as Incentive Compensation, Vital Signs, Access-One and NA Pharma Reports in the following technology areas - SQL/PLSQL, LINUX and Informatica.

Understood the business requirements related to EDW project and analyzed the system requirements.

Coordinated with EDW functional consultants to set up the data.

Analyzed the data in EDW and worked with business to set up the data for the required fields.

Performed regression testing for the existing data.

Solved issues / Performed data validations during UAT. Resolved customer complaints and concerns with strong verbal and negotiation skills.

Worked on finding missing data, remove duplicate, make data in correct format to maintain the data quality before loading it into Data Warehouse.

Involved in development of Informatica Jobs with required transformations like Aggregator, Filter, Lookup, Sorter, Normalizer, Update strategy Transformer etc.

Development of new mapping, session and workflow through Informatica mapping designer, workflow manager.

Executed adhoc requests according to the requirements.

Carried out automation for cost optimization and improved speed to value.

Maintained tracker system to estimate effort and managed the CR and adhoc request status.

Accountable for support to Database related activities like PL/SQL Stored Procedures, Functions and Triggers creation & testing and data migration through these objects along various databases. Also maintained these objects that were already running in production.

Resolved performance, formatting and data related issues for deliverables to the end-user.

Technology: Informatica 9.6, Oracle 12c, UNIX, TIDAL, MBOX

ETL Developer May 2013 – Apr 2016

TCS, India

Client: Life Science & Health Care (Pharma) – J&J

Enterprise Data-ware House 3D Project involves development and enhancements to integrate the other applications (Butterfly, CDR etc.) and OPCOs (Ortho-McNeil-Janssen) under current EDW architecture which includes getting the requirements from the clients and develop the same.

Attended business meetings for requirement.

Analyzed the system requirements and the data in EDW and worked with business to set up the data for the required fields; coordinated with EDW functional consultants to set up the data.

Analyzed and performed regression testing for the existing data; solved issues; performed data validations during UAT. Deployed the changes / new objects in Production with BI Support team.

Developed new mapping, session and workflow through Informatica mapping designer, workflow manager.

Involved in development of Informatica Jobs with required transformations like Aggregator, Filter, Lookup, Sorter, Normalizer, Update strategy Transformer, etc.

Wrote Shell scripting for flat file handling and modifications.

Technology: Informatica 9.6, Oracle 12c, Control-M, UNIX, MBOX

ETL Developer Dec 2011 – Apr 2013

TCS, India

Client: Life Science & Health Care (Clinical Trial) – J&J

This project was about creating BI Platform for a pharmaceutical company to show source from where ingredients are coming for a particular medicine, so that they can investigate any issues per batch

Involved in analysis of end user requirements and business rules based on given documentation and worked closely with tech leads and Business analysts in understanding the current system

Assisted Business Analyst in documenting business requirements, technical specifications and implementation of various ETL standards in the mappings

Developed the core routines (PL/SQL packages) using Global Temporary table, explicit cursor etc.

Worked in SQL server to do the validation of data of tables. Analyzed source and target tables using SQL queries in order to maintain integrity.

Prepared and executed unit test cases and co-ordinate with SIT team in testing phase.

Built new mappings, sessions and workflows through Informatica mapping designer, workflow manager.

Gathered details of business logic changes in existing ETL load mappings and did the impact analysis of the requested changes from business for existing ETL codes.

Technology: Informatica Power Center(8.6,9.1,9.6), SQL Server, UNIX,TIDAL

EDUCATION

Bachelor of Technology, West Bengal University of Technology (India)

Credential evaluated to Canadian equivalency of Bachelor of Technology by World Educational Services.

REFERENCE

Will be furnished upon request.

Contact this candidate