Data Architect Call Center

Dibyendu Meher

La Palma CA *****. 818-***-****. *******@*****.***

PROFESSIONAL SUMMARY

Technology leader with more than twenty years of experience in in Data management, Business Intelligence, Cloud Technology, Data modeling, Predictive Analytics, Architecture, and System Integration. Experience working cross functionally with IT team, business leaders, marketing, finance and C-level executives. Experience managing small and medium sized teams WORK HISTORY

Data Integration Lead/Manager Feb 2021 – Current

Acco Engineering Systems, Pasadena, CA

• Led the Data integrations projects related to ERP, Payroll, Data Lake, Field service management and Finance.

• Main projects included Migration of legacy timesheet entry system to Rhumbix, developing data pipelines for HCM to JDE, developing Data Lake, HCM to Data Lake interface, enhancing the modules for accounting, Talend migration to OCI/Upgrade.

• Architected ETL solutions using Talend and REST APIs.

• Managed stakeholders; Performed project planning, work estimation

• Supervised ETL and BI team members.

• Performed daily production support, process automation, adhoc requests and performance tuning.

• Designed ETL processes and developed ETL routines using Talend and SQL server stored procedures

Environment: Talend DI v7/8, Oracle 12c, SQL server 2016, HCM, JDE, Rhumbix, AWS Glue, Redshift, S3, REST API

BI/DW Solution Architect Mar 2020 – Aug 2020

Orange County Transportation Authority, Orange, CA

• Architected DW solutions, design data models, enhance EDW and data marts for various dashboards such as maintenance dashboards, ridership, transit dashboards

• Performed testing for migration of source system from Oracle to SQL server

• Migrated Data ware house from Oracle to AWS Redshift

• Designed/developed/maintained ETL processes.

Environment: Oracle 12c, Informatica Powercenter 9/10, Erwin 9.0.0, Qlikview 12, PL/SQL, Unix Shell scripting, S3, Redshift, SQL server 2016 Data Architect May 2018 – Feb 2020

Dermalogica LLC, Carson, CA

• Led the Data warehouse projects and enhancements from end to end.

• Architected DW solutions, designed data models, data marts for Global finance, sales, marketing and customer service departments.

• Main projects included developing/enhancing Domestic and Global data warehouse, Cognos migration, Account locator, ecommerce database, Face mapping database, CRM data integration, Finance data exchange, Inventory Analysis, GDPR etc.

• Managed stakeholders; Performed project planning, work estimation, budgeting and prioritization.

• Supervised data team, consultants, and performed vendor management.

• Designed ETL processes and developed ETL routines using Alteryx and SQL server stored procedures

• Prepared data for Finance team for Predictive Analytics and created Predictive models.

• Performed database administration, administered Alteryx, Tableau and Power BI servers.

• Worked on daily production support tasks, process automation, and performance tuning.

• Led the project for migration of reports and dashboards from Cognos to Tableau/Power BI. Environment: SQL Server 2016, Alteryx, Tableau, Cognos 10, Power BI, AWS, Erwin,T- SQL, Windows/Powershell scripting, RDS, EC2, Google Analytics, Google Data Studio, JDEdwards, Navision, Actian, Pepperi, Demandware

Dibyendu Meher

BI/DW Solution Architect May 2016 – Apr 2018

Orange County Transportation Authority, Orange, CA

• Worked on data acquisition and enhancement of data marts for various dashboards such as maintenance dashboards, ridership, transit dashboards, error correction, ride checks, Incidents, Cost analysis, CEO initiatives, On-time performance etc.

• Architected DW solutions, designed data models, and enhanced EDW and data marts.

• Designed ETL processes and developed ETL routines using Informatica and PL/SQL stored procedures.

• Worked on daily production support tasks, process automation, and performance tuning

• Designed and developed dashboards, defined KPIs and managed metadata. Environment: Oracle 12c, Informatica powercenter 9, Erwin 9.0.0, Qlikview 11/12, PL/SQL, Unix Shell scripting, Windows scripting, Amazon S3, EC2,RDS, SQL server 2016 Delivery Manager/ETL Lead Sep 2015 – Apr 2016

Pacific Life, Newport Beach, CA

• Managed and supervised a team of 5 onsite and offshore resources for Retirement solutions division.

• Performed project planning, work estimation, resource allocation, and delivery.

• Designed ETL process, guided the ETL team in building the ETL objects and reviewed those.

• Worked on data source analysis and requirement gathering from the users.

• Automated the DW processes related to Actuary, Life Insurance and Mutual funds.

• Maintained and designed tables in Redshift; developed ETL processes to load it. Environment: Oracle 12c, Informatica Power Center 9.5, Informatica Metadata Manager, MSVisio 2010, PL/SQL, Unix Shell scripting, Control-M 8.x, Redshift Lead BI/DW Solution Architect/Delivery manager Oct 2008 – Sep 2015 Guthy-Renker LLC, Santa Monica,CA

• Designed EDW from scratch with initial focus on orders, sales and financial returns data mart. Augmented the EDW with other subject areas such as Media, Customer membership Customer retention, Call center, Budget, Customer analytics.

• Architected EDW and BI solutions, lead data acquisition projects.

• Worked on data migration from a legacy system to a new system with a different business model, migration from external vendor to in-house data mart.

• Liaison between the business and technical team to gather requirement, define KPIs.

• Led a team of ten onsite and offshore resources.

• Recommended solutions to business users to come with up the best strategy.

• Designed logical and physical data models.

• Automated business and technical processes and did performance tuning of databases, ETL and reporting objects.

• Designed predictive models using multiple linear regression, logistics regression, decision tree, association rules etc. for order forecasting, customer attrition, market basket analysis.

• Performed project planning, work estimation, resource allocation, and delivery.

• Worked on data source analysis, requirement gathering, data stewardship, and impact analysis

• Designed ETL processes, guided the ETL team in building the ETL objects and review those.

• Designed reporting solutions such as cubes, reports and dashboards, and guided the reporting team in building and reviewing those.

Environment: Oracle 11g/10g, SQL Server 2012,Informatica Power Center 9.5, IDQ 9.0, Cognos 10,Redhat Linux 4.1, Windows 2008 server, Microsoft Project 2007, MSVisio 2007, Erwin 9.0.0, PL/SQL, Unix Shell scripting

Technical Architect Mar 2006 – Sep 2008

Fisher-Price, Buffalo, NY

Dibyendu Meher

• Designed the OSPOS data mart, data models, ETL processes and related sales reports and cubes, and was involved in the development of enterprise DW. Environment: DTS 8.0, Informatica Power Center 8.1.1, MS SQL 2000, Oracle 9i, Cognos Series 7.2/7.4 ( Impromptu, Power Play), CRN 1.1 MR1/MR2/MR3, Cognos 8 BI Suite, Framework manager, Unix shell scripting, Microsoft Project 2000, MSVisio 2000, UC4 scheduler.

Technical Architect Sept 05 – Feb 2006

Biosense Webster Inc., a J&J company, Diamond bar,CA

• Built a datamart and developed ETL solutions and programs for Demantra Spectrum Suite and Demand planning module

Environment: Informatica Power Center 7.1, SQL*Loader, Oracle 9i, Windows scripting, Vbscript,

BI Consultant Jul 2005 – Aug 2005

LAPD, Los Angeles, CA

• Worked on a consulting assignment for fixing and performance tuning of employee complaint reports.

Environment: Cognos Report Net 1.1 Report Studio, Framework Manager, ERWIN 4.1.4, Oracle 9i

Team lead Jul 2003 – Jun 2005

UBS Investment bank, Singapore

• Developed ETL programs and reports related to Global General Ledger (GGL) and led the testing team for end-to-end testing.

Environment: Informatica Power Center 6.0, Autosys Scheduler, Perl, Sun Solaris 5.7, Linux,Oracle 9i,

System Analyst Jun 2002 – Jun 2003

GE Global Technology Solutions, Bangalore, India

• Enhanced and maintained Direct Marketing Application, a $66 million business, one of the key systems for supporting business of GE Appliances, which consists of several modules.

• Redesigned the Web Solicits and cross sale application using six sigma DMAIC methodology.

Environment: Maestro Scheduler, Six-Sigma tools, Pro *C, Oracle, PL/SQL, Shell and AWK scripting, CGI-BIN, Java, UML, HP-UX 9000/800.

Senior Software Engineer Apr 1999 – Jun 2002

Employer: Tech Mahindra (India & Singapore)

Clients: Nokia, Alcatel, Airtel, Fascel

• As software engineer, successfully developed telecom applications such as Mediation device, Roaming data handler, Switch audit handler, call data collection system, network management systems.

• As a lead, played the client-facing role for implementation and support of software applications. Led a team of 2-5 members.

Environment: Pro *C++, ASN.1, UML, Sun OS 5.7, Rational PurifyPlus,VSS, Java, CORBA, UML/Rational Rose, Rational Clearcase, WinNT4.0, HP-UX 9000/800, ERWIN 4.0, Oracle 8, DEC- Unix, HP/9000FTAM APIs, Unix Internals, TECHNICAL SKILLS

Data Management: Talend v7/8, Informatica Powercenter 6.0/7.1/8.1/9.1/10.x, Alteryx, Informatica Metadata manager, IDQ 9.0, DTS 8.0, Informatica MDM, Actian Cloud services: Redshift, Glue, Redshift spectrum, EC2, S3, RDS Anthena, Snowflake Dibyendu Meher

Business Intelligence: Tableau, Qlikview 11, Cognos 10/8/7, Power BI Database : Oracle 7.x/8i/9i/10g/11g, MS SQL Server 2000, Sybase Predictive Analytics : Alteryx, KNIME, Spark ML, Python Data modeling: MS Visio, ERWIN

Project management: MS Project, Jira, Manage Engine Programming languages: C, Pro *C, C++, Java, PL/SQL, Shell scripting,Perl, Powershell,Unix Internals,

Statistics/Operations: Stata, Excel Risk solver

Configuration Management: Github, VSS, Rational Clearcase Other Tools: Autosys Scheduler, Maestro Scheduler, Control M scheduler, Six-Sigma tools Minitab, UC4 scheduler, Rational PurifyPlus, Rational Rose, ASN.1 compiler Methodologies : SSAD, OOAD, DMAIC, Scrum/Agile

Business Domain: Retail. Consumer products, E-commerce, Direct Marketing, Investment Banking, Infomercial business, Transportation, Telecom, Construction, HR CERTIFICATION:

AWS certified Cloud Practitioner

Talend Data Integration v7 Certified Developer

EDUCATION:

LOYOLA MARYMOUNT UNIVERSITY Los Angeles, CA

Master of business Administration

NATIONAL INSTITUTE OF TECHNOLOGY Silchar, India

Bachelor of Engineering

Contact this candidate