Anil Kumar Email & Phone Number

Bengaluru, Karnataka, India

Bangalore

Bangalore

Requirement Gathering from Onsite teamDesigning and get it approved by the Architectsworking on Implementation and preparing test cases, unit testingEnable Proof of Concepts for various modules, their implementation in projectsCoordinate with Offshore Development, Support & Onshore Teams.Serve as a focal point to communicate and resolve interface and integration issues with other team.Implement the Database changes in SQL Server dacpacCreation of Tables, Views, Indexes and Sequences. Working with Joins, Cross/ Outer Apply, triggers, and Table Valued Parameters (Table Type Object).Writing Complex Queries, inline queries, Stored Procedures and Functions, CTE’s Working with Transactions, Locks and isolation levels.Working with Dynamic SQL and SQL injection.Improve the Query performance by using Dynamic Management views(DMV’s) and SQL SERVER Profiler.Reviewing and Execution of Test Cases Developed SSIS packages to get the data from different source systems like SQL Server, Excel(xls, xlsx, xlsm),text, csvSSIS Configurations and Logs. Automate the SSIS Packages using SQL Server Agent, Windows Task scheduler.Creating Linked Servers.Coordinating the Developing activities with the development team And QA teamProvide Support on SSRS reports, L2,L3 issues.working on Agile/Kanban methodologies, continuous integration uses jenkins

Bengaluru Area, India

Requirement Gathering from Onsite team Preparing the Plan and assigning the tasks to Team. working on Implementation and preparing test cases, unit testing Enable Proof of Concepts for various modules, their implementation in projects & track productivity improvements Coordinate with Offshore & Onshore Team, Business Team, and IT support Team. Serve as a focal point to communicate and resolve interface and integration issues with other team. Trained the project teams in technical concepts and technologies in SQLSERVER ,SSIS and SSRS Provide status reporting of team activities against the project plan or schedule Involved in Design(HLD,LLD), coding and deployment. Creation of Tables, Views, Indexes and Sequences. Working with Joins, Cross/ Outer Apply, triggers, and Table Valued Parameters (Table Type Object). Writing Complex Queries, inline queries, Stored Procedures and Functions, CTE’s Working with Transactions, Locks and isolation levels. Working with Dynamic SQL and SQL injection. Improve the Query performance by using Dynamic Management views(DMV’s) and SQL SERVER Profiler. Reviewing and Execution of Test Cases Supported from DB side for Developing Oracle Materialized views. Developed SSIS packages to get the data from Oracle server, xml, Excel(xls, xlsx, xlsm),Cloud, text, csv and different types of files to SQLSERVER Creating SSIS Packages to read the data from webservice, Flat Files and writing into CRM 2013 Application, SQLSERVER tables. SSIS Configurations and Logs. Developed SSIS Packages to read the data from webservice, writing into Flat Files and upload them into Remote server using winscp Automate the SSIS Packages using SQL Server Agent. Creating Linked Servers. Coordinating the Developing activities with the development team And QA team Developed different kinds of SSRS like Drilldown, Drill through, Linked , Cascade, Parameterized, matrix Reports and Charts, dashboards. Working with SSRS Groups, Calculations, toggle an

Bangalore

Bangalore