Arun Kumar Seniappan

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