Muthukumar Murugesan

Muthukumar Murugesan Email and Phone Number

Senior Specialty Software Engineer @ Bank of America
Muthukumar Murugesan's Location
Charlotte, North Carolina, United States, United States
Muthukumar Murugesan's Contact Details

Muthukumar Murugesan personal email

About Muthukumar Murugesan

Senior Developer ETL / Data Analyst with over 15+ years of experience in application design, development, maintenance and implementation. In-depth knowledge and experience in wide range of skill set, roles, industry vertical. Solid hands-on experience in SDLC lifecycle process and comprehensive exposures in end-to-end project execution for large and medium applications.• Strong hands-on experience with various versions of SSIS, SSRS, OBIEE, Birst, Informatica, C#.NET, SQL Server, Oracle, T-SQL, PERL Script, Batch Script, Data Quality Services. • Trained on Cloud technology and certified with Google Associate Cloud Engineer (GCP ACE)• Good hands-on experience in Azure Data Factory, Power BI, Talend and knowledge on Python, Hive QL, HDFS, CICD, Jenkins and zeal to learn new tools and technologies.• Real time programming experience in ASP.NET, VB.NET, BizTalk Server, LinQ, Entity Framework, ASP, HTML, CSS, jQuery, Java Script, Visual Basic, VB Script, Visual FoxPro, Excel VBA.• Expertise in design and implements ETL concepts, process, workflows and handles data from heterogeneous sources into Data Warehouse with OLTP and OLAP concepts.• Proficient in creating ETL mappings, transformation, writing complex business rules, dynamic packages, package migration and handle SSIS DB catalog and reports.• Extensively used C# programming in SSIS script tasks, script components, custom logging, error handling, develop custom reusable components to automate the manual complex process. • Strong hands-on experience in design and develop reports, dashboard, interactive visual insights and provides data extract with assorted format using various BI analytics tools.• Proficient in Database Design, Migration, writing complex queries, Troubleshooting, identify performance bottle necks and optimization using various versions of SQL Server.• Skilled in writing T-SQL, joins, sub queries, temp tables, bulk insert, cursors, indexes, views, stored procedures, triggers, logging, functions and various SQL server tools.• Experience in design Dimensional Data Model, Star Schema, Snow Flake Schema, FACT and Dimension tables, physical and logical data model for enterprise data warehouse.• Expertise in create, maintain and schedule the jobs using Autosys, Tidal Scheduler, SQL Server Agent, Control-M Enterprise Manger and Windows Scheduler.• Comprehensive knowledge in both Agile Scrum and Waterfall Model. • Experience in handling onsite-offshore model and managed 10+ members team

Muthukumar Murugesan's Current Company Details
Bank of America

Bank Of America

View
Senior Specialty Software Engineer
Muthukumar Murugesan Work Experience Details
  • Bank Of America
    Application Development - Data Strategy
    Bank Of America Aug 2023 - Present
    Charlotte, Nc, Us
  • Wells Fargo
    Senior Specialty Software Engineer
    Wells Fargo Aug 2021 - Aug 2023
    San Francisco, California, Us
  • Advantasure
    Senior Etl Consultant
    Advantasure Jan 2021 - Aug 2021
    Aliso Viejo, Ca, Us
  • Wells Fargo
    Application Architect
    Wells Fargo Mar 2018 - Jan 2021
    San Francisco, California, Us
  • California Resources Corporation
    Etl Specialist - Data Analyst
    California Resources Corporation Apr 2017 - Mar 2018
    Los Angeles, Ca, Us
    CRC Universe is a data warehouse application that integrates the data’s from various internal applications (Open/Closed Wells, Property Master, ODS, TOW, OSI PI) and data’s received from Department of Conservation’s (DOGGR) into centralized SQL server database. It processes Ingres and non-Ingres data’s from different zones and maintains the various status of oil, natural gas, and geothermal wells which handles by CRC. Software Used: SSIS 2016, SQL Server 2016, SSRS, Data Quality Services, BizTalk Server 2010, Oracle 11g, Data Warehouse, Business IntelligenceTools Used: SSDT, VS.NET 2015, Report Builder, GitHub, SQL Server Agent, Quality Center, PLSQL Developer,Roles and Responsibilities:• Consult with customers, team members, and stakeholders to understand the business strategy, requirements and provides the technical design/solution.• Collaborate effectively with architects, modelers, data scientists, analysts and customers to maximize user experience and product quality.• Skilled in design and implementing ELT processes, complex business rules, dynamic packages, handling various data sources like SQL Server, Oracle, MS Access, Flat File, Excel using SSIS.• Proficient in design, construct, deploy the efficient and robust ETL workflows.• Expert in implementing custom components, logging, error handling, troubleshooting, analyzing performance bottlenecks, code optimization and automation in SSIS.• Skilled in data manipulation, data extraction and implementing data quality process like data validation, cleansing, profiling, mapping and transformation. • Research, develop, and manage the approaches to improve data reliability, quality, and performance.• Skilled in using T-SQL, joins, sub queries, temp tables, bulk insert, cursors, indexes, views, stored procedures, triggers, logging, functions and SQL agent/job scheduling.
  • Td Ameritrade
    Senior Etl Developer
    Td Ameritrade May 2016 - Apr 2017
    Omaha, Ne, Us
    Environment: SSIS, SSRS, SQL Server 2012, Oracle 11g, PERL Script, Data Warehouse, Business Intelligence, SSDT, VS.NET 2012, Report Builder, Attunity, SVN, Cisco Tidal Enterprise Scheduler 6.2.1, BMC Remedy, Quality Center, MoveIt, CyberArk, PL/SQL Developer, Oracle SQL Developer, JiraRoles and Responsibilities:• Closely worked with SMEs and business/clients to translate the business requirements into design and technical solution.• Extensively used SSIS 2012 features like project parameters, deployment, environment variables, writing custom queries on SSIS catalog, SSIS DB reports.• Proficient in using various SSIS concepts like checkpoints, transactions, parallel execution, data taps, project template and auditing.• Involved in creating complex custom reports, dashboard, performance tuning, implementing security, scheduling and publishing reports using reporting tool SSRS.• Responsible for database design, writing complex SPs, business rules, troubleshooting, logging, query optimization and database maintenance activities.• Extensively used T-SQL scripts and stored procedures to migrate the data from various sources like MySQL, SharePoint, MS-Access, Active Directory to SQL Server.• Responsible for identifying the areas of reusable codes and implementing the innovative ideas to improve the business process and productivity.• Engage various teams and provides support activities for existing and new applications.• Extensively worked on handling various SQL server tools like SQL Profiler, Index Tuning Advisor, SQL Server Migration Assistant (SSMA), Lite Speed and Open DBDiff.
  • Mphasis Corporation
    Delivery Project Lead
    Mphasis Corporation Aug 2010 - Apr 2016
    Bangalore, Karnataka, In
  • Ibm India Private Limited
    Middleware Specialist
    Ibm India Private Limited Jul 2006 - Aug 2010
    Armonk, New York, Ny, Us
  • Aztecsoft
    Software Development Engineer
    Aztecsoft Aug 2005 - Jul 2006
    In
  • Nihilent Technologies
    Senior System Analyst
    Nihilent Technologies Dec 2004 - Aug 2005
    Pune, Maharashtra, In

Muthukumar Murugesan Skills

Requirements Analysis Microsoft Sql Server Sql Server Integration Services Sql Server Reporting Services Oracle Database Data Warehousing Asp.net Active Server Pages C# Biztalk Software Development Javascript Vbscript Html Agile Methodologies Sql Server Integration Services

Muthukumar Murugesan Education Details

  • Karpagam University, India
    Karpagam University, India
    Computer Science
  • Manonmaniam Sundaranar University
    Manonmaniam Sundaranar University
    Computer Science
  • Bharathidasan University
    Bharathidasan University
    Computer Science
  • Sengunthar Arts & Science College
    Sengunthar Arts & Science College
    Computer Science
  • Govt. Boys Hr.Sec School. Tiruchengode, Tamilnadu, India
    Govt. Boys Hr.Sec School. Tiruchengode, Tamilnadu, India
    Maths-Biology-Physics-Chemistry

Frequently Asked Questions about Muthukumar Murugesan

What company does Muthukumar Murugesan work for?

Muthukumar Murugesan works for Bank Of America

What is Muthukumar Murugesan's role at the current company?

Muthukumar Murugesan's current role is Senior Specialty Software Engineer.

What is Muthukumar Murugesan's email address?

Muthukumar Murugesan's email address is mm****@****ibm.com

What schools did Muthukumar Murugesan attend?

Muthukumar Murugesan attended Karpagam University, India, Manonmaniam Sundaranar University, Bharathidasan University, Sengunthar Arts & Science College, Govt. Boys Hr.sec School. Tiruchengode, Tamilnadu, India.

What skills is Muthukumar Murugesan known for?

Muthukumar Murugesan has skills like Requirements Analysis, Microsoft Sql Server, Sql Server Integration Services, Sql Server Reporting Services, Oracle Database, Data Warehousing, Asp.net, Active Server Pages, C#, Biztalk, Software Development, Javascript.

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.