Ashish B. Email & Phone Number

Chandigarh, India

Chandigarh Area, India

My current role is to develop reports, dashboards, creating ETL packages, writing SQL queries, optimizing existing SQL scripts, creating indexes and designing database schema.

Chandigarh Area, India

I am working as a Senior SQL Developer. My current project is Payroll Management Product.My job and responsibilities are -* Migrating data from SQL Server 2008 R2 to 2012 using SSIS packages.* Creating SSRS reports to deliver employee payslips to them.* Creating SSIS package to upload client employees data to our Payroll system.* Creating SSIS package to deliver employees payslips to them in excel format.* Creating SSIS package/SSRS reports to deliver complex general ledger reports to clients.* Creating stored procedures to implement complex general ledger logic inside it.* Optimizing various existing stored procedures of SSRS reports to minimize loading time.* Adding required Indexes to tables for faster access of data.* Requirement gathering from end user and creating document for that.* Deploying code changes to DEV and QA server.* Adding code changes to TFS server.* Unit testing my code changes on DEV/QA server and adding test data in database.* Daily updating assigned tickets on IT help ticketing system for better visibility.* Daily Call with clients for requirement gathering.

Chandigarh Area, India

My project is Insurance product. I am working as a Senior ETL developer.My job and responsibilities are -* Creating SSIS packages to move huge transactions data from OLTP DB to Data-Warehouse DB.* Creating SSIS packages to calculate Insurance agents commissions from Data-Warehouse DB.* Creating reports according to client requirements with capability of multi-column sorting and aggregation.* Optimizing SQL queries and stored procedures to return result set in optimal time.* Performing database administration tasks such as monitoring backup jobs, transaction log space, specifying correct recovery model, resolving fragmenting indexes issues, updating statistics and monitoring CPU/Memory utilization by SQL server.* Creating ETL package to load new client data into existing OLTP database (One time task).* Checking-In my code changes to SVN for better tracking/management.* Updating about my work done/progress on Trello.

Mohali, Punjab, India

After having experience of almost 4 years in software development, I am promoted to Senior Software Developer Level 2. New responsibilities include -* Develop high-quality SQL queries to process million of rows in seconds.* Develop/maintain documentation for all changes in system.* Collaborate with all team members to improve product.* Automate tasks through appropriate tools and scripting.* In-depth knowledge of MS SQL Server.* Perform validation and verification testing.

Mohali, Punjab, India

After working in a project for almost 3 years promoted to Product Owner of project.New responsibilities added to my job is-* To provide quick solutions for customer issues.* To identify and optimizing the performance of SQL queries.* Reviewing and testing the code of team members.* Look for issues which may occur in future.* Provide new ideas to management for better implementation of new functionalities.* Designing database tables, schema and views.

Mohali, Punjab, India

New responsibilities added to my job is -* Solving critical tickets as per specified time limit.* Optimizing bad performing SQL queries.* Writing new stored procedures with highly optimized code.* Creating SSIS/SSRS packages to load/deliver reports.* Daily call with my US manager.

Mohali, Punjab, India

Working in same project. New responsibilities added to my day to day work is-* Give training to new freshers added to our project so that they can start working on it.* Testing code changes done by my team.* Deploying team code changes to our main branch of project after resolving any conflicting issues.* Helping team about how to write SQL queries in optimized way.* Regular sessions with team to explore more about MS SQL Server.

Mohali, Punjab, India

Continued to work in same project (Energy trading product) and promoted to Software developer.Some new responsibilities added to my day to day work is-* Solving complex requirement tickets such as creating new procedure to implement new business logic.* Started implementing SQL joins in queries.* Added triggers to perform auditing changes in major tables.* Try to implement Set-based approach instead of loop based approach for quick execution.* Unit testing my code changes and creating shelves on TFS using Microsoft Visual Studio.* Sending emails to ticket requester for clarifications.

Mohali, Punjab, India

Started learning about project. My project is Energy Trading Product.My day to day work is-* Doing small HTML, CSS and Java Script changes in product web-pages.* Modifying existing stored procedures to add new columns in result set.* Creating ad-hoc query as per ticket assigned to us.* Daily updating assigned tickets status using internal IT ticketing system.* Daily sending Status Report via internal email system.

Master Of Computer Applications - Mca, Computer Programming, 76%

Activities and Societies: Act as Class Representative for two years. Participated in cricket tournaments.I did my post graduation.

Bachelor Of Science (B.Sc.), Electronics, 69%

Activities and Societies: Participated in arts and sports tournament.I did my graduation from one of the best college (MLN college).