Arumugham Thiagarajan

Having industry experience of architecting, design, development, software support, administration, and implementation of high-quality business solutions in Consumer, Retail, Banking, Hi-Tech, Healthcare, Telecom and Legal Domains. Architected solutions and implemented Digital Data Analytics and Business Intelligence Solutions based on Snowflake, Databricks, Qlik Compose, Informatica, Informatica Cloud, Power BI, Tableau and OBIEE. Managed Digital transformation and Modernization of Data Platform and Data Engineering such as Hadoop Snowflake, OBIEE Snowflake and Business Objects/Microstrategy OBIEE. Have in-depth experience in Analytical Solutions, Data Modelling, Data Warehouse Solutions on Cloud, and non-Cloud platforms. Architected and solutioned in building different technical strategies including data migration Strategy (Extract Transform and Load – ETL and Extract Load and Transformation - ELT) for global implementations, Data Migration strategy for Consolidation project, Testing Strategy. Architected solutions to optimize/automated the pipelines in Hadoop to Snowflake Migration project resulted 75% reduction of pipelines (1053247) Experience in designing and developing Snowpipes, Tasks, Stream, Analytical functions, bulk loading from internal/external, External Tables, Secured/Materialized Views. Experience in Information Schema, Resource Monitoring, Time Travel, Data sharing and integrating Snowflake with MS Azure. Hands-on experience in Databricks Architecture Data Lake House, SQL, Data Science Engineering and Machine Learning. Experience in Databricks SQL, develop reports and dashboards. Experience in creating Jobs for running Python Scripts and monitor Jobs and resolve issues in Databricks. Experience in designing mappings, ETL sets, look up transformation, and analytical functions in Qlik Compose Experience in designing Data Vault 1.0, Star Schema, workflows and monitoring in Qlik Compose. Experience in designing and developing Data Model, Dax Functions, Reports, Dashboard and loading various data sources in Power BI. Experience in requirement gathering, technical design and implemented BI Solutions to cater actional metrics, KPIs and data visualization in Power BI. Experience in automating scheduling Data Set Refresh and resolve failure in Power BI. Migrated Tableau reports into Power BI Maintaining and migrated code repository in Azure Dev Ops. Tracking and Monitoring Incidents/Service Request/Problem Ticket and Change Management using Service Now. Participated in CAB Meeting and part of review management board. Implemented green field projects and handled support of CRM solutions on Siebel – Sales, Call Center, Marketing, Legal-Case Management, PRM and Lead Management modules. Handled delivery of Transformational and Engagements. Handled escalation procedures, incident management, Problem Management, Change Management, and other disciplines related to service delivery. Managed tracking service metrics such as MTTR, SLA Metrics, effective utilization, Incident throughput, Aging analysis and led the effective service delivery team. Managed/Building Implementation Team of different sizes (20-50), including distributed groups in different geo locations. Handled RFPs (15), created and assisted in proposals. Delivered effort estimation and solutions on RFP estimates ranges between 5M and 10 M. Managed critical incidents and established effective communication between stakeholders for post-incident reviews. Experience in building CoE/Practice Teams and deploy resources (75). Ensured and guided on cross skilling and upskilling the team for better utilization of resources. Provided performance/process improvement solutions and resolved reliability issues.

• HCL Tech, November 2000 to Till Date
• Cygnus Software Pvt Ltd, December 1998 to November 2000
• J.K. Pharmachem Ltd, May 1995 to December 1998
• Chemfab Alkalis Ltd, September 1992 to May 1995

Bachelor of Commerce

• Snowflake Advanced Architect
• SnowPro Core
• Databricks Lakehouse Fundamentals and V2 Accreditation
• Big Data Analytics
• Azure Data Analytics and Data Lake
• Datawarehouse and Data Modelling Foundation
• Hadoop Administrator
• Implementation Specialist in OBIEE
• Siebel 2000 Core Consultant
• Siebel Customer Certified Consultant
• Oracle, Unix, and C.
• WEBTECH
• ASP, XML, VB Script and WAP
• Software Metric
• ASM Service Transition and Design
• Software Asset Management
• OMS ISO Quality Management

• Land O’ Lakes Inc, Minneapolis, April 2012 to Till Date, Enterprise Data Lake Migration to Snowflake, Technical Lead, July 2021 to Till Date, Snowflake, Databricks, Power BI, Tableau, Qlik Compose, IICS, Microsoft Azure, Hadoop, Oracle, Created data ingestion framework from Azure Blob Storage to Snowflake., Bulk loading and continuous data processing from the external storage Azure Blob Storage to snowflake cloud using Copy command and Snowpipes, respectively., Stored procedures developed to transform the JSON data into Fact, Dimension tables, views using LATERAL JOIN, FLATTEN function., Created secured views with complex queries involving Window functions, analytical functions for business reporting in Power BI., Architected solutions to optimize/automated the pipelines in Hadoop to Snowflake Migration project resulted 75% reduction of pipelines (1053 >247), Implemented Temporary Tables and Transition Tables for session-specific data used during ETL., Worked on Streams for Change data capture, created tree of Tasks, Procedures, UDFs in Snowflake., Resolved issues of Snowpipes/steam/tasks, Created cloned database for multiple development environments., Worked on secure data sharing between accounts in the same Azure region., Created clustering keys for larger tables for performance improvement., Worked with Databricks team to migrate and develop data science use cases in Databricks., Designed ETL transformation using IICS and ensured the delivery done by the ETL team., Reviewing the final deliverables, defining implementation check list, post implementation review checklist, and Validation have been done., Designing and developing Data Model, Dax Functions, Reports, Dashboard and loading various data sources in Power BI., Designed ETL process and data model design for implementing Power BI Solutions to cater actional metrics, KPIs and data visualization in Power BI., Migrated Tableau reports into Power BI., Automated scheduling Data Set Refresh and resolved failure in Power BI., Designed of tabular and multi-dimensional data models in Power BI., Performed query fine tuning and performance improvement in Power BI., Developed and executed database queries and conduct data analysis for designing reports in Power BI., Created connections to data sources such as DB, SharePoint, and external Web URL for importing data and transforming data for Business Intelligence., Implemented row level security on data and application security layer model in Power BI, Application Support Maintenance, Minneapolis, April 2012 to June 2021, OBIEE 12c, Informatica 10.x, IICS, DAC, ODI, DRM, Hyperion, Oracle, MS Sql Server, Ensuring Business as usual. Resolve issues & ensure support is provided to users. Identify training needs of Business Users and providing feedback to Land O’Lakes project team., Conduct Business Process workshops for existing and new modules with Land O’Lakes Business Analysts. Prepare and document functional specifications complying discussions with Business Users and Business Analysts., Perform OBIEE repository, Dashboard, Reports and Extract Transformation and Load Hyperion Configuration (OBIEE 10.1.3.4.1, OBIA 7.9.6), Informatica and DAC. Configure, Perform Unit and integrated testing., Responsible in preparing High level design and Low-level design for Financials, Procurement and Spend and Compliance Reports., Designed and developed new data model for developing for creating LOL report requirements., Created Customized tables using SDE and SIL mappings and also extended additional columns to meet the LOL report requirement., Created joins between the Fact and the Dimensions in the Physical Layer and Business Model Layer according to the business requirement., Created Calculated Fields or Logical Columns in the Business Model Layer to achieve the requirement, Design various reports with Navigation, Pivot, Bar Chart, Gauge View in Answers, Add users to the new group and apply the data level and object level security at rpd as well as presentation services
• Standard Chartered Bank, India-Offshore, May’10 - Jun’11, Implemented OBIEE 10x solutions
• CSL Behring (KOP, USA), India-Offshore, Jun’09 - Apr’10, Implemented OBIEE 10x solutions
• Dubai Customs, Dubai, Mar’09 - May’09, Implemented Public Sector Module in Siebel 8
• Lexis Nexis, India-Offshore, May’08 – Feb’09, Implemented Siebel Analytics 7.8x
• Autodesk Inc., SanRafael, CA, Jan’07 – Apr’08, Implemented Sales and Sales Analytics – Siebel Analytics 7.8.2x and Siebel 7.7
• Saudi Telecom, India-Offshore, Jun’06 - Dec’06, Implemented Siebel Analytics 7.8x
• McData Inc,, Denver, CO, Sep’05 - May’06, Implemented Closed Loop Management – Siebel 7.5x and Marketing Analytics 7.7
• Itronix, India-Offshore, Mar’05– Aug’05, Implemented Siebel 7.5.x
• OCBC Bank, Malaysia, Jan’05 – Mar’05, Siebel Tester Role – Siebel 7.5.3
• McData Inc.,, Denver, CO, Apr’04 – Nov’04, Siebel Sales Upgrade – Siebel 6 to Siebel 7.3x
• RSA Security Inc.,, Boston, MA, Oct’03 - Mar’04, Siebel Sales Upgrade – Siebel 6 to Siebel 7.5x
• Exult (Hewitt), Charlotte, NC, Nov’01 - Sep’03, Implemented Siebel Call Center, 6x, 7.5x
• Convergys Corporation, India-Offshore, Jun’01 – Oct’01, Implemented Siebel Sales 6x
• Telstra Corporation, Melbourne- Australia, Feb’01 May’01, Implemented Siebel Sales 6x
• Citibank, Japan, India-Offshore, Nov’00 – Jan’01, Implemented Siebel Call Center 6x
• Citibank, India, India-Offshore, Dec’98 – Oct’00, Implemented Siebel Sales 6x, HRPS, HRIS, XPU Systems

• Snowflake
• Databricks
• Python
• Qlik Compose
• Informatica
• IICS
• Oracle Data Integrator 12c
• Hadoop Platform - NIFI, Kibana, Ambari, Oracle SQL/PL SQL, MS Sql Server, Service Now
• Power BI
• Tableau
• OBIEE 12c
• Oracle BI Publisher
• Alation
• DRM and Hyperion
• Siebel eBusiness 2000
• Siebel Analytics