Avinash C Email & Phone Number

Detroit, Mi, Us

Detroit, Mi, Us

Roles and Responsibilities: • Worked on developing .Net applications using Entity Framework for automating file parsing based on business rules and created database objects to insert data into database.• Worked on creating .Net Console Applications to consume reports from SSRS report service and generate pdf files for further business continuity. • Implemented SSO (Single Sign on) authentication mechanism to enable users to login to other websites.• Developed a console application to parse fixed length files and processed them to SQL Server and DB2 databases using C#, VB.Net.• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform to parse files in different formats by triggering .exe file and load data to database.• Created SSRS reports to create dashboards (with different report items) with metrics as needed by business to evaluate the enrollments for different product lines and services.• Developed an application which creates and refresh financial reconciliation spreadsheets for different vendors based on monthly data feed using Excel interop services.• Create SQL script to automate database restore from shared location to SQL Server using Maintenance Plans and used operators to send email in case of failures or success.• Worked as a lead developer and implemented SSIS Packages for extracting the data from different data sources like Oracle, MySQL and legacy applications to transform that data and load it into OLAP.• Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.• Migrated SSRS reports from Report Server 2008 to 2012 for different business departments.• Involved in optimizing SQL Queries based on Query execution plans, Performance monitor, SQL Profilers, Activity Monitor.

Roles and Responsibilities: • Worked on developing .Net applications using Entity Framework for automating file parsing based on business rules and created database objects to insert data into database.• Worked on creating .Net Console Applications to consume reports from SSRS report service and generate pdf files for further business continuity. • Implemented SSO (Single Sign on) authentication mechanism to enable users to login to other websites.• Developed a console application to parse fixed length files and processed them to SQL Server and DB2 databases using C#, VB.Net.• Developed SQL Server Integration Services (SSIS) packages to automate the nightly extract transform to parse files in different formats by triggering .exe file and load data to database.• Created SSRS reports to create dashboards (with different report items) with metrics as needed by business to evaluate the enrollments for different product lines and services.• Developed an application which creates and refresh financial reconciliation spreadsheets for different vendors based on monthly data feed using Excel interop services.• Create SQL script to automate database restore from shared location to SQL Server using Maintenance Plans and used operators to send email in case of failures or success.• Worked as a lead developer and implemented SSIS Packages for extracting the data from different data sources like Oracle, MySQL and legacy applications to transform that data and load it into OLAP.• Developed and implemented error handling logics in all the SSIS packages to handle bad data and avoid package failures.• Migrated SSRS reports from Report Server 2008 to 2012 for different business departments.• Involved in optimizing SQL Queries based on Query execution plans, Performance monitor, SQL Profilers, Activity Monitor.

Mt. Pleasant, Michigan, Us

Roles and Responsibilities• Worked as .Net and SharePoint developer to manage and create website for SAP User group. • Created new pages to update SAP User group activities in website with images, videos in Website. • Created reports to evaluate performance of students in different courses for BIS department in MS Excel using data from SQL Server and SAP systems.• Created Course Completion Certificates in pdf format for students and annual report to BIS department using SAP Lumira.

Bangalore, Karnataka, In

Roles and Responsibilities:• Extensively Worked on creating User Interface pages (aspx) using C#, ASP.NET MVC 3.0/4.0, CSS, Bootstrap, HTML, AJAX, JQuery, Java Script and to implement complex Business Rules and Validation of front end forms• Used AJAX and the third party Telerik controls for adding rich features to the application. • Responsible for code merging using Microsoft Team Foundation Server (TFS) and for other source code maintenance needs.• Designed, created workflow and developed web services to expose data as required for different applications• Worked on writing stored procedures to handle business scenarios and complex queries for generating reports.• Worked on ADO.NET technology for retrieving, querying, inserting and manipulation of data.• Involved in developing and bug fixing for data handling using CDC in downstream systems• Worked on IIS logs to get stats to know website usage trends using LogParser.• Worked on Implementing Help document for different applications using MS HTML Help.• Worked with SQL Server Reporting Services (SSRS) for providing comprehensive reporting functionality for variety of data sources.• Worked on SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.• Worked on migrating and enabling Availability Group (AG) option in SQL Server 2012 for this application to reduce server utilization by downstream web services. • Developed a console application which is used to clean up the data as per business requirements and insert processed data to downstream database.• Involved in fixing bugs and managing Lucene .Net search mechanism to enable full-text search in application and web services.• Responsible for deployment of applications to production and resolving various deployment issues. • Unit testing, documentation and Peer review (using CodeFlow, CodeBox).

Master Of Science - Ms, Management Information Systems

Bachelor'S Degree, Computer Science