Experience

• 

  Cyours - india

  Jun 2008 - Mar 2011

  Software engineer

  Roles and Responsibilities: -> Designed, coded and Implemented Graphical User Interfaces using ASP.NET, Web Forms, HTML and CSS.-> Worked on developing Stored Procedures, Functions and Triggers for the implementation of data integrity using TSQLin SQL Server.-> Used JavaScript to perform validations and catch the events on client’s browser.-> Designed and implemented stored Procedures, views in SQL Server 2005.-> Displayed, Edited, Deleted data using Data Grid Control.-> Used the Ajax call method to collect the data from database and displaced on the pages.-> Application Support and maintenances Show less

• 

  Zenta

  Jun 2011 - Dec 2011

  Senior software engineer

  Roles and Responsibilities: Worked on developing Stored Procedures, Functions and Triggers for the implementation of data integrity using TSQLin SQL Server.Designed and implemented stored Procedures, views in SQL Server 2008.Displayed, Edited, Deleted data using Data Grid Control.Used the Ajax call method to collect the data from database and displaced on the pages.

• 

  Accenture

  Jan 2012 - Oct 2021

  • Extensive experience in Data Transformation and Loading (ETL) Using Sql server integration services (SSIS) in Sql server.• Creation of work flows with Data flow Task, Execute Sql Task, File System Task, Bulk Insert Task, and Containers.• Experience on Transformations like Derived Column, Conditional Split, Aggregates, Sort, Data Conversion, Merge join, Look Up and Union all.• Having good knowledge on creation and scheduling jobs in Sql server agent to run daily, weekly SSIS Packages.• Good experience in SQL Server 2008 database development and data migration.• Experienced on SQL Server Concepts like (DML, DDL, DRL, functions, stored procedures, joins, indexes, sub queries, constraints, views, Character functions, Arithmetic operators, Assignment operator’s, Logical operators, Aggregate functions, Date time functions, Set Operators) in Sql server2005, 2008R2,2012.• Great Knowledge in Dimensional Modeling.• Experience with T-SQL in constructing Tables, Triggers, User Function, Views, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity• Experience in Using multiple join statements to retrieve data from multiple tables• Experience in Creating Backend validations using Insert/Update and Delete triggers and Created views for generating reports• Experience in writing Programs for implementing Stored Procedures for different tasks. Worked with Development teams in relation to application tuning• Working extensively on data extraction, cleansing/data integration, and loading from different data sources using SSIS • Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS• Configured SSIS packages using Package configuration wizard to allow packages run on different environments • Experience in ticketing tools (Service Now, Jira) software cycle development. Show less • Experienced in UI technologies like HTML5, CSS3, jQuery, JavaScript, Bootstrap.• Experienced in SQL Server Database design developing SQL queries, Views function, stored procedures, and triggers using SQL Server.• Good Knowledge in Photoshop CS3 for image correction and banner Creations and icon Creations.• Good knowledge of ASP. NET 2.0/3.5 with C# concepts with Entity Framework.• Performed post-development stages of Testing, Implementation, and User Training.• Good domain experience in Finance, Banking, and Health industries.• Designed and developed ASP.NET Forms using Visual Studio 2015. Show less

  • Application Development Specialist

    Nov 2020 - Oct 2021

  • Application Development Senior Analyst

    Jan 2016 - Oct 2020

  • Application Development Analyst

    Mar 2014 - Dec 2016

  • Associate

    Jan 2012 - Feb 2014
• 

  Https://prabhakaran.co.in

  Jan 2019 - now

  Bi blogger

  This is my technical BI blog web site to share the what are the challenges I have faced while working in different type of BI issues. Perhaps it will help you with a similar problem. Go to https://prabhakaran.co.in

• 

  Capgemini

  Oct 2021 - now

  Manager c2