- By Narayan Biswas
attended Class IX-X Tuition
"He is very committed in his work. He is very patient in making me understand the subject well. His commitment towards teaching and his attitude of responsibility has impressed me. "
Reply by Divesh
Thanks, Shriyash, I would really happy if my teaching would help you to crack the UPSC exam.
"Which is the best UPSC coaching institute in Kolkata?" in Exam Coaching/UPSC Exams Coaching, Exam Coaching/UPSC Exams Coaching/IAS (Indian Administrative Service) Coaching
Join ALS Online class in Kolkata.
Experienced professional on SSIS & SQL Server
? Having 5+ years of experience in IT as an MSBI (SSIS, TSQL) Developer, Design, Development and Customization of Business Application using SQL server2008&2012. ? Hands on experience in extracting and transforming data by creating SSIS packages. ? Experience in Analyzing, designing and developing SQL server integration services (SSIS) Packages. ? Involved in various tasks such as Control Flow(Execute SQLtask, For each loop Containers, Dataflow Task, File System Task etc..) and transformations such as Aggregate, Sort, Lookup, Fuzzy Lookup, Merge join, Multicast, Conditional split, Derived column etc. ? Experience in Performance Tuning in SSIS, and also tuning the packages in Package level, Source level, Destination level and Data flow level. ? Implemented Checkpoints at Package Level. ? Creating the SQL agent jobs using SQLscripts. ? Implementing the Data flow task and Control flow task by using various types of Transformations, Tasks and Containers. ? Managing Incident, Problem, and Change record for EAT application. ? Worked on problem records and implemented change successfully on production since joined the application. Provided solution for the defects on given time line. ? Implemented emergency change in a day successfully to resolve the critical issue, Prepared Documents for Implementation of change, time estimate for enhancement, Root Cause for problem record and updated Service management plan after every release. ? Build and deployed the changes on User acceptance and on SIT for bug free release. Performed technical verification for application after change. ? Provided information to customer regarding EAT application as and when required. ? Providing fix to the incident and moving to production by creating a change request by getting proper approvals. ? Involving in CRB (Change Review Board) Call.
? Expertise in designing and development package using SQL Server Integration Services 2008 and 2015. ? Proficient in Requirements Analysis, Designing, Coding, Testing, Deployment and Maintenance. ? Ability to work under pressure and simultaneously on multiple projects and capability of working under aggressive deadlines. ? Having good knowledge of Software Engineering and complete SDLC life-cycle of different projects. ? Involved in multi environment client interaction. Understanding of End user requirements and transforming them to Business and Functional Requirements to the application. ? My work area mainly includes SQL Server 2008 With SSIS. o Worked With various Task Such as Sequence Container, for each Loop Container, Data Flow, Execute SQL Task, Lookups, Merge Joins, Multicast, Conditional Split, Derived Column, Data Conversion Task. o Worked on Configuration, logging & Error Handling. o Capable on Adapting to working on new system & environment easily. o Good domain knowledge in Banking, Finance and insurance. o Unit Testing & Integration testing and validations.
Microsoft Certified Professional (MCP) of 70-767 of Implementing Data Warehouse MSBI Lead around 10 years of experience in Business Intelligence (BI), Data Warehouse (DWH) and Data Analytics related consulting projects. Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency Experience across entire Microsoft BI suite of products including SQL Server, SSIS, SSAS, SSRS and POWER BI Good hands on experience on performance Optimization in SQL server as well as SSIS. Good Hands on experience on writing Complex queries, Joins, T-SQL queries, Stored Procedures, Triggers, Functions, Indexes, Views