Anand A.
Data Warehouse Architect at Texas Municipal League Intergovernmental Risk Pool- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
elavarasi manickam
Anand is a Fast Learner.Good Team Player. Highly Commited towards the work. Reliable resource.
CHRISTINA THAMMADI
Anand is a very hard working and talented guy working individually and also as part of the Team.He has good technical knowledge of the subject.
elavarasi manickam
Anand is a Fast Learner.Good Team Player. Highly Commited towards the work. Reliable resource.
CHRISTINA THAMMADI
Anand is a very hard working and talented guy working individually and also as part of the Team.He has good technical knowledge of the subject.
elavarasi manickam
Anand is a Fast Learner.Good Team Player. Highly Commited towards the work. Reliable resource.
CHRISTINA THAMMADI
Anand is a very hard working and talented guy working individually and also as part of the Team.He has good technical knowledge of the subject.
elavarasi manickam
Anand is a Fast Learner.Good Team Player. Highly Commited towards the work. Reliable resource.
CHRISTINA THAMMADI
Anand is a very hard working and talented guy working individually and also as part of the Team.He has good technical knowledge of the subject.
Credentials
-
Communicating with Empathy
LinkedInSep, 2021- Oct, 2024 -
Improving Your Listening Skills
LinkedInJun, 2021- Oct, 2024 -
Linux overview and Installation
LinkedIn Learning ⋅ Course CertificateMay, 2020- Oct, 2024
Experience
-
Texas Municipal League Intergovernmental Risk Pool
-
United States
-
Insurance
-
100 - 200 Employee
-
Data Warehouse Architect
-
Sep 2014 - Present
Implementing full pipeline for the following projects From Operation data to Operational Data Store (ODS) using replication then from ODS to Data warehouse (snowflake schema) using ETL SSIS/SQL Stored Procs/ SAP BODS And finally creating the reporting interface with Cognos Framework manager / Looker LOOKML PolicyCenter ETL & Datamart in MS SQL| SAP BODS / Reporting Implementation using Cognos Activities of claim adjuster Real-time Datamart/Reporting… Show more Implementing full pipeline for the following projects From Operation data to Operational Data Store (ODS) using replication then from ODS to Data warehouse (snowflake schema) using ETL SSIS/SQL Stored Procs/ SAP BODS And finally creating the reporting interface with Cognos Framework manager / Looker LOOKML PolicyCenter ETL & Datamart in MS SQL| SAP BODS / Reporting Implementation using Cognos Activities of claim adjuster Real-time Datamart/Reporting implementation Customer facing Portal dashboarding ETL & reporting implementation using Looker(Google) Guidewire ClaimCenter ETL & Datamart in MS SQL / Reporting Implementation using Cognos
-
-
Data Warehouse Architect
-
Mar 2013 - Aug 2014
Implementing full pipeline for the following projects From Operation data to Operational Data Store (ODS) using replication then from ODS to Data warehouse using ETL SSIS/SQL Stored Procs And finally creating the reporting interface with Cognos Framework manager Guidewire ClaimCenter ETL & Datamart in MS SQL / Reporting Implementation using Cognos Sync internal & External contacts from Legacy application to Guidewire Contact manager (address book) All Ad-hoc… Show more Implementing full pipeline for the following projects From Operation data to Operational Data Store (ODS) using replication then from ODS to Data warehouse using ETL SSIS/SQL Stored Procs And finally creating the reporting interface with Cognos Framework manager Guidewire ClaimCenter ETL & Datamart in MS SQL / Reporting Implementation using Cognos Sync internal & External contacts from Legacy application to Guidewire Contact manager (address book) All Ad-hoc reporting or data dump needed for Analytics
-
-
-
Sprint Nextel
-
United States
-
Retail
-
Microsoft BI Lead (MSBI Lead)
-
Apr 2011 - Mar 2013
Requirement Analysis and creating understanding document Providing project plan with phase by phase timelines and resources allocation Designing database and ETL frame work and establishing development environment Development and team co-ordination with offshore Data modeling with Visio and implementing table structures (Dim and Fact) Creating SSIS packages to populate data in Dim and Fact tables Creating and processing OLAP using Analysis Services (SSAS). Testing the… Show more Requirement Analysis and creating understanding document Providing project plan with phase by phase timelines and resources allocation Designing database and ETL frame work and establishing development environment Development and team co-ordination with offshore Data modeling with Visio and implementing table structures (Dim and Fact) Creating SSIS packages to populate data in Dim and Fact tables Creating and processing OLAP using Analysis Services (SSAS). Testing the package individually – Unit Testing Testing the process end to end – Integration testing Handling offshore Team to co-ordinate development activities Meeting Clients with weekly status and provide project plans Creating reports for the end user with SSRS and Tableau. Supporting the system till the warranty period Fixing issues during UAT and when Production support needs help. Show less Requirement Analysis and creating understanding document Providing project plan with phase by phase timelines and resources allocation Designing database and ETL frame work and establishing development environment Development and team co-ordination with offshore Data modeling with Visio and implementing table structures (Dim and Fact) Creating SSIS packages to populate data in Dim and Fact tables Creating and processing OLAP using Analysis Services (SSAS). Testing the… Show more Requirement Analysis and creating understanding document Providing project plan with phase by phase timelines and resources allocation Designing database and ETL frame work and establishing development environment Development and team co-ordination with offshore Data modeling with Visio and implementing table structures (Dim and Fact) Creating SSIS packages to populate data in Dim and Fact tables Creating and processing OLAP using Analysis Services (SSAS). Testing the package individually – Unit Testing Testing the process end to end – Integration testing Handling offshore Team to co-ordinate development activities Meeting Clients with weekly status and provide project plans Creating reports for the end user with SSRS and Tableau. Supporting the system till the warranty period Fixing issues during UAT and when Production support needs help. Show less
-
-
-
Verizon
-
United States
-
IT Services and IT Consulting
-
700 & Above Employee
-
SQL Server/ MSBI Admin
-
May 2008 - Mar 2011
Managed and Administrated SQL Server 2005/2000 production and Non-production (Datawarehousing ) servers.. Automated many manual ETL process using SSIS and Supported with existing complex Production SSIS Packages. Extensively worked on SSIS for transferring data from Heterogeneous Database ( OLE DB , Excel , Flat file , Data reader for Teradata Tables ) to create Data Marts Created logical and physical data modeling using ERWIN and MS-VISIO for Normalizing flat file / Table to Dimension… Show more Managed and Administrated SQL Server 2005/2000 production and Non-production (Datawarehousing ) servers.. Automated many manual ETL process using SSIS and Supported with existing complex Production SSIS Packages. Extensively worked on SSIS for transferring data from Heterogeneous Database ( OLE DB , Excel , Flat file , Data reader for Teradata Tables ) to create Data Marts Created logical and physical data modeling using ERWIN and MS-VISIO for Normalizing flat file / Table to Dimension model ( Star and snow flake schema ) Created Molap cubes using SSAS using Dimension Hierarchy and Fact tables with monthly Partition. Created Teradata BTEQs and SQL Script to create FACT and Dimension Tables. Created regular and ad-hoc reports using SSRS as per clients requirement (Verizon Business) Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery. Used Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor. Created regular and ad-hoc reports using SSRS as per clients requirement (Verizon Business) Created maintenance plans for monthly back-up, shrinking database , truncating log and refreshing indexes. Created of Teradata Fastload, OLEload and Mload scripts ( Teradata Utilities ) for loading data according to the requirements for Ad-hoc tasks. Documenting the Projects and flow chats with VISIO and MS-Word. Show less Managed and Administrated SQL Server 2005/2000 production and Non-production (Datawarehousing ) servers.. Automated many manual ETL process using SSIS and Supported with existing complex Production SSIS Packages. Extensively worked on SSIS for transferring data from Heterogeneous Database ( OLE DB , Excel , Flat file , Data reader for Teradata Tables ) to create Data Marts Created logical and physical data modeling using ERWIN and MS-VISIO for Normalizing flat file / Table to Dimension… Show more Managed and Administrated SQL Server 2005/2000 production and Non-production (Datawarehousing ) servers.. Automated many manual ETL process using SSIS and Supported with existing complex Production SSIS Packages. Extensively worked on SSIS for transferring data from Heterogeneous Database ( OLE DB , Excel , Flat file , Data reader for Teradata Tables ) to create Data Marts Created logical and physical data modeling using ERWIN and MS-VISIO for Normalizing flat file / Table to Dimension model ( Star and snow flake schema ) Created Molap cubes using SSAS using Dimension Hierarchy and Fact tables with monthly Partition. Created Teradata BTEQs and SQL Script to create FACT and Dimension Tables. Created regular and ad-hoc reports using SSRS as per clients requirement (Verizon Business) Planned the Complete Backing up of Database and Restoring the Database from Disaster Recovery. Used Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor. Created regular and ad-hoc reports using SSRS as per clients requirement (Verizon Business) Created maintenance plans for monthly back-up, shrinking database , truncating log and refreshing indexes. Created of Teradata Fastload, OLEload and Mload scripts ( Teradata Utilities ) for loading data according to the requirements for Ad-hoc tasks. Documenting the Projects and flow chats with VISIO and MS-Word. Show less
-
-
-
Accenture
-
Ireland
-
Business Consulting and Services
-
700 & Above Employee
-
Senior Software Engineer
-
Sep 2007 - Jan 2008
Project - General Ledger / Client - Auto Club Group
-
-
Software Engineer
-
Dec 2003 - Aug 2007
Field Expansion ( Client - United Health Care ) SPRF ( Client - United Health Care ) Worked On-site in Basking Ridge, NJ from Aug 2005 to Aug 2006 for our client United Health Care
-
-
Education
-
Bharathiar University
MCA, Computer Science