AugmntX

AugmntX is the world’s largest network of pre-vetted talent.

Contact Info

305, IRIS Corporate Centre,
Hiranandani Meadows, 400610.
hello@augmntx.com
+919820045154

Follow Us

Home / Developers / AXF16777
profile image
Divia Lordson A AXF16777 Active
Data Architect in Tenkasi
As an experienced Technical Data Architect and Certified Data Scientist with over 15 years of progressive experience in the IT industry, An array of skills in diverse technologies and a proven track record of delivering data-driven solution across various sectors.
Industries : Manufacturing
Share
Hire Divia Lordson A
Download PDF
Availability
Full-time
Total experience
15 years
Technical skills
T SQL
8 Years
SSIS
5 Years
.NET
3 Years
SSAS
2 Years
SSRS
2 Years
Python
2 Years
POWER BI
1 Years
R
1 Years
Projects
Manufacturing Execution System
April-2021 to November-2023
Description
Oversaw the Data migration using the SSIS ETL technique, leveraging SSIS Packages (SQL Server 2019) from Oracle legacy system.
Roles and Responsibilities
END to END Data migration using the SSIS ETL technique, leveraging SSIS Packages (SQL Server 2019) from Oracle legacy system.
Technologies: SSIS
Industry: Manufacturing
Batch Tracking System
November-2023 to February-2024
Description
Designed and implemented a Batch Tracking System using SQL Server 2019, SSAS, and Power BI, including elements of Fact, Dimension, DSV, Cubes, and Dashboard
Roles and Responsibilities
Designed and implemented Dashboard for Batch Tracking System using SQL Server 2019, SSAS, and Power BI, including elements of Fact, Dimension, DSV, Cubes, and Dashboard
Technologies: Power BI
Industry: Manufacturing
Work history
Technical Architect • May-2021 to July-2023
Description: Engineered and executed comprehensive ETL data migration packages from legacy Oracle systems to a state-of-the-art SQL Server 2019 production environment, enhancing operational efficiency and system performance. • Devised and implemented robust SSIS ETL packages on SQL Server 2019, optimizing long-running stored procedures to enhance system speed and reliability. • Showcased multifaceted experience across diverse stages of the software development lifecycle, encompassing Development, QA, UAT, and Production through adept use of SSIS ETL packages. • Championed the design and development of SSAS cubes to facilitate end-to-end business process reporting on the Power BI dashboard, improving business intelligence capabilities. • Successfully orchestrated data migration operations from aging to a new production environment (
CO-Founder • March-2012 to March-2021
CTS Technologies Training Institute – Tamil Nadu
Description: Steered a team of 5, spearheading comprehensive training and academic projects encompassing SSIS (ETL), SSRS, SSAS, and T-SQL, fostering an enriching learning environment. • Successfully executed industrial projects leveraging R, SAS, Python and Machine Learning methodologies implemented with Python, accelerating business efficiency and growth. • Championed end-to-end business operations, demonstrating prowess in data acquisition, data wrangling, and data exploration to drive informed business decisions. • Effectively managed Big Data projects, employing tools such as MySQL, Sqoop, Hive, and Hue alongside Tableau to extract valuable insights and strengthen data-driven strategies. • Delivered high-impact technical sessions to corporate clients in SQL Server (Chennai) and SSRS (Bengaluru), enhancing their technical acumen and cultivating client relationships.
Pre-Sales Solution Architect • August-2009 to December-2011
Scalability Experts – Mumbai (Managed Partner of Microsoft)
Description: Led pivotal proof of concept (POC) efforts on SQL Server and MSBI (SSIS, SSAS, SSRS), executed modifications to existing Data Migration ETL packages to align with new business needs, and aided in the development of data marts, OLAP cubes. • Developed T-SQL packages and MS SQL reporting services reports while providing significant support for internal webapplication modules utilizing ASP.NET with C#, demonstrating prowess in SQL Server and MSBI domain. • Conducted impactful 'Practical SQL Server 2008 for Oracle DBAs' technical sessions for Microsoft clients in both global and domestic markets, including locations like Shanghai, Kuala Lumpur, Singapore, Bangkok, Hong Kong, Dubai, Moscow, Mumbai, Bengaluru, Chennai, Delhi, and more. • Conducted POC on SQL Server and MS BI (SSIS, SSAS and SSRS) • Executed effective process for modification of existing SSIS package as per new business requirements. Collaborated with data warehouse team members in designing of data marts along with reporting. Assisted in development, maintenance of OLAP cubes and data sets. Effectively delivered technical presentations on SQL Server 2008 R2, fortifying client relationships and showcasing proficiency in cutting-edge database technologies. Developed T-SQL package and MS SQL reporting services reports.
Corporate Trainer • March-2008 to August-2009
karROX Technologies
Description: Led comprehensive technical trainings encompassing a wide range of tools and technologies such as T-SQL (Stored Procedure, Function, Triggers), SQL Server 2000, HTML, .Net 2.0, C#, VB.NET, ASP.NET, Crystal Report, SQL Server 2005, Oracle PL/SQL, and Oracle Administration. Successfully provided Tier 3 support to public domain. Developed and delivered high-quality technical presentations, established engaging technical labs, and produced effective training materials to enhance learning outcomes and drive technical proficiency among participants.
.NET Developer • February-2006 to March-2008
MKCL limited (Mumbai-Thane)
Description: Developed T-SQL Query, Stored producer and functions for the project. Developed Query Management System. Training sessions on VB.Net, ASP.Net, C, C++, C#, SQL Server 2000, SQL Server. Provided T3 Trainings. (Train The Trainers).
Computer Teacher • June-2002 to January-2006
Sacred Heart School Kalyan
Description: Computer Teacher, Head of computer department , Lab and Theory for 1 std to IX STD
Certifications
DNIIT by NIIT
2002
Microsoft Business Intelligence (MSBI) by Intellipaat
2021
Data Scientist by Simplilearn
2021
Education
Masters degree in Master of Business Administration
sikkim manipal university
2007 to 2011
Diploma degree in PG DST Specialization .NET
MKCL
2006 to 2007
Language
English - Intermediate