โข 18+ years of experience as Microsoft Business Intelligence DTS,SSIS,SSSRS,SSAS, T-SQL, Stored Procedures, Triggers, SQL
Server
โข 20+ years of Software Development experience in MS technologies like ASP.Net 1.1/2.0/3.5/4.0/Core 2.0, C# , VB.Net, SQL
Server 2000/2005/2008, MVC, Web services, Web APIs, JavaScript, VBScirpt, and JQuery in Production, Development and
Staging Environments.
โข 4 Year of experience in working with .NET core technologies.
โข 2.5 Years of experience in Service-Now Developing and managing different ITSM Processes.
โข Experience in BI Development and Deployment of DTS, SSIS packages, SSRS Reports from MS-Access, Excel, and SQL Server,
Oracle, MySQL etc. Good Knowledge in SSAS (Microsoft SQL Server Analytical Services)
โข Involved in writing complex stored procedures and T-SQL queries. Involved in SQL Performance and Query optimizations.
โข Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets.
โข Involved in data migrations, transfers (ETL) using utilities like Data Transformation Services (DTS), and SSIS.
โข Designing and Deployment of Reports for the End-User requests using Web Interface & SSRS.
โข Experienced in programming Tasks-Stored Procedures, Triggers, and Cursors using SQL Server 2005/2008/2012 with T-SQL.
โข Excellent Presentation, Communication & Team Management capabilities.
โข Experienced in SDLC life cycle for Design, Development and Staging phases of the projects with support of Data-Flow, Process
Models, and E-R Diagrams.
โข Team management experience with team of 30+ people on account of various critical development and maintenance projects
meeting the stringent deadlines and SLAโs.
โข Customer Engagement experience while handling various projects and CR management with a good track record of ensuring
repeat business.
โข Development and Monitoring of End of day data processing and Transformations using SSIS ETL Packages, SQL Jobs.
โข Managing DR Drills and Colocation Drills with Application team, Infrastructure team and Security Team.
โข Managing System Security finding of WAPT Testing and Fixes of the same for Public Portals.
โข Cloud Migration of on Premise Servers to Azure and Application testing for the same.
| ๐ Nationality | ๐ฎ๐ณ India |
| ๐ก Residency | ๐ฎ๐ณ India |
| ๐ Location | ๐ฎ๐ณ India |
|
|
rok.co/@itranjitgmailcom |
|
|
sdfljasfjkhsdfajsf โญ๏ธ Upgrade to Premium to contact |
|
|
sdfljasfjkhsdfajsf โญ๏ธ Upgrade to Premium to contact |
| Skilled in | dts ssis sssrs ssas t sql stored procedures triggers sqll server asp dot net core 2 0 c sharp vb dot net sql mvc web services web apis js vbscirpt dot net core |
| Fluent in | englishhindi |
| Preferred timezone | +91 |
| Preferred annual pay (min) | $120,000/year |
| Preferred hourly pay (min) | $15/hour |
| Last seen | 2 years ago |
| Signed up | 2 years ago |
| Badges |
๐จโ๐ป Remote worker ๐จ Maker ๐ Early adopter |
2016 - 2023: Senior manager Technology @ Mahindra Finance
2016 - 2023: ETL process
1999 - 2003: Bachelor of engineering @ Shivaji university