Arun Kumar Seniappan

Arun Kumar Seniappan

Analyst Programmer

Followers of Arun Kumar Seniappan31 followers
location of Arun Kumar SeniappanChennai, Tamil Nadu, India

Connect with Arun Kumar Seniappan to Send Message

Connect

Connect with Arun Kumar Seniappan to Send Message

Connect
  • Timeline

  • About me

    Project Manager at Cognizant | Business Intelligence | Power BI | Power Automate | Data Warehousing | OLTP | OLAP | ETL

  • Education

    • K.C.S Kasi Nadar college

      2007 - 2010
      Bachelor of Computer Applications - BCA Computer Science 73%

      Activities and Societies: To expand the technological horizons underwent technical training (GNIIT) at NIIT. Affiliated with Madras University. Completed BCA in the year 2010 with score of 73%.

    • Shebha Matriculation Higher Secondary School

      2006 - 2007
      HSC Commerce with Computer Science 79%

      Completed HSC with Computer science as major with a score of 79% under Matriculation Board

    • University of Madras

      2011 - 2014
      Master of Computer Applications (MCA) Computer Programming, Specific Applications 70%

      Successfully completed masters from University of Madras with 70% in parallel with working for Ramco Systems.

  • Experience

    • Ramco Systems

      Dec 2010 - Jul 2014
      Analyst Programmer

      • Proficient in Debugging, Optimization and Query tuning in SQL Queries and SSIS.• Proficient in creating and scheduling SQL Server Jobs, SSDT, SQL Mail Agent, SSIS Packages.• Developed basic cubes in SSAS and fetching data from cubes for the reports using SSRS with MDX query.• Good knowledge on SQL server queries and worked on SQL 2014 and 2016 versions. • Experience in generating Tabular, Parameterized, Drill-Down and Drill Through, Map and Sub Reports in SSRS with PDF, XLS and CSV formats. • Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedures consumed at various stages of migration/cleansing process, reports or data validation• Experience in Migrating databases from SQL 2008 R2 to SQL 2012 using SSMA. Show less

    • Cognizant

      Aug 2014 - now

      • Expertise in Understanding Business Requirements, Data Analysis, Designing, Building and Implementing Data warehousing solutions for various clients in Life Science, Retail, Communications, Healthcare, Aviation and Manufacture Logistics domains. • Developed complex Custom calculated measures using DAX in Power BI to satisfy the business needs.• Experienced in direct interaction with clients and understanding of various work cultures in USA, UK, Netherlands and India with excellent communications skills and interactions to understand the requirements and showcase the product in an agile project model to make quick and effective iterative changes.• Knowledge and expertise of working closely with Platform Leads, Product Managers, Analysts to understand the requirements for implementing solutions.• Expertise on ETL Architecture, Control Flow, Data Flow and Transactions in SQL Server Integration Services (SSIS). • Proficient knowledge in Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.• Mentored teams on MSBI and PowerBI, headed a team of 5 members which is responsible for a quick turnaround. Show less • Created Power BI dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts, line charts.• Interaction with business users and stakeholders to understand the requirements and showcase the product in an agile project model to make quick and effective iterative changes.• Worked on creating Azure Data Factory for moving and transforming the data• Skillful in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.• Developed OLTP system (s) and involved in creating facts, dimensions and Star Schema representation for the data mart Show less

      • Project Manager

        Jan 2019 - now
      • Associate - Projects

        Aug 2014 - Dec 2018
  • Licenses & Certifications

    • Microsoft Certified Power BI Data Analyst Associate (MS PowerBI)

      Microsoft
      Jan 2021
    • GNIIT

      NIIT Limited