Dotnet and Sql Server Technology Lead, Microsoft Certified.
Resume:
Vikash Kumar Singh
Edinburgh, UK.
**********@**********.***
Technical skills
Languages
Proficient in: C#, HTML, ANSI SQL and Transact-SQL
Familiar with: C, C++, VB, Java, XML/XSL, NoSQL
Other: JavaScript, jQuery, CSS
Software & Technologies
Database: Microsoft SQL Server 2012, 2008 R2 and 2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), familiar with Oracle and MongoDB
Platforms: Microsoft Windows, familiarity with Linux, Unix and AIX
Technologies: DOT NET Framework 4.5, C#, ADO.NET, ASP.NET, AJAX, MVC, WCF (Windows Communication Foundation) & RESTful web services, IIS, IBM Http Server (IHS), WebSphere.
Tools: Microsoft Visual Studio 2012 and 2008, Microsoft SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Team Foundation Server (TFS), Visual Source Safe (VSS), IIS Manager, Robomongo, Quality Center (QC), Active Directory and Windows Management Instrumentation (WMI), Microsoft Management Console (MMC).
Software development life cycle (SDLC): SDLC models like iterative waterfall, prototype, evolutionary, spiral and agile methodologies. Good working knowledge of Configuration management, Change management, SSL certificate implementation and management, Information Technology Infrastructure Library (ITIL), and quality assurance processes.
Certifications:
Microsoft Certified Solutions Expert (MCSE) Data Platform,
Microsoft Certified Solutions Associate (MCSA) SQL Server 2012,
Microsoft Certification Exam 70-433: TS: Microsoft SQL Server 2008 Database Development,
Microsoft Certification Exam 70-515: TS: Web Applications Development with Microsoft
.NET Framework 4.
IT Experience
Total Experience: 6.2 years November 2009 – Till Date
Onsite Experience: 1.9 years March 2015 – Till Date; August 2012 – August 2013 [Edinburgh, United Kingdom]
Current Role: Technology Lead / Team Lead October 2014 – Till Date
Organization: Infosys Limited, India November 2009 – Till Date
Project Details
Rainbow2 Project June 2014 – Till Date
[Edinburgh, UK : March 2015 – Till Date;
Chennai, India : June 2014 – Feb 2015]
Working as onsite coordinator and technical lead in Rainbow phase 2 project for the Royal Bank of Scotland (RBS). This project involves development and deployment of new applications, and updating & migrating existing applications to a new infrastructure.
Responsible for application design, infrastructure design reviews, code reviews, coordination with client, offshore team and other stakeholders. Direct interface with client, status updates, reporting and coordination.
Creating application designs, coding, testing, doing quality reviews, and deploying applications on IIS and Windows servers.
Involved in web hosting of WCF services and websites on IIS, installing ISAPI filters, and enabling communication with WebSphere application server for java based applications.
Involved in design and development of RESTful WCF services, to implement Service Oriented Architecture (SOA) for applications.
Incorporated security and performance improvements in web applications and database designs, and its subsequent implementations. Used MongoDB NoSQL database for performance and high availability criteria in one of the application.
Implemented Secure Sockets Layer (SSL) certificates for websites and WCF services, to secure transport channels in the web applications.
Created and deployed data migration packages and customized reports using SQL Server Integration Services and SQL Server Reporting Services (SSIS and SSRS).
Privileged Access Management (PAM) August 2012 – May 2014
[Edinburgh, UK : August 2012 – August 2013;
Chennai, India : August 2013 – May 2014]
Have worked as onsite coordinator and database administrator in Privileged Access Management (PAM) Phase 2 project for the Royal Bank of Scotland (RBS).
Responsible for coordination with client, offshore team and other stakeholders during PAM project discovery, analysis and execution phases. Direct interface with client, status updates, reporting and coordination.
Leading Privileged Access Management offshore team, requirement analysis, time and effort estimation, task distribution, testing and quality review.
Involved in requirement analysis, design, build and testing phases for all the development work in phase 2 of PAM project.
Involved in design and development of WCF services, to implement Service Oriented Architecture (SOA) for the application.
Worked in phase 3 of Privileged Access Management project as a Wintel Access Management analyst. This project involved remediation of servers and management of privileged access, as per the RBS Security Policy.
Involved in privileged access review and have also worked on Active Directory groups and settings.
Have worked on database query optimization and response time improvement. Have created data migration packages and customized reports using SQL Server Integration Services and SQL Server Reporting Services (SSIS and SSRS).
Have created and presented required reports to client, using SQL Server Reporting Services (SSRS).
Awarded with Infosys INSTA award for my excellent analytical ability and efficient work in PAM project.
On Demand Information Network (ODIN) January 2012 – July 2012
[Chennai, India]
Building, updating and maintaining a web application named, On Demand Information Network (ODIN), associated with the Bank of America. On Demand Information Network (ODIN) application consolidates data from multiple systems, for different marketing channels and Line of Businesses, across the bank into an aggregated database and provides an integrated end-to-end reporting platform for marketing analytics & reporting system for Bank of America.
Developing multiple reports and implementing data analysis business logic using SQL Server Reporting Services (SSRS).
Building front end web pages having filters for drill-down functionality while generating reports using ASP.NET 4.0
Involved in code review, unit testing, system testing and deployment of ODIN application.
Enterprise Risk and Issue Management (E-RIM) November 2009 – December 2011
[Chennai, India]
Building, updating and maintaining a web application named, Enterprise Risk and Issue Management (E-RIM), associated with the Bank of America. Enterprise Risk and Issues Management (E-RIM) tool is meant to be an efficient tool to assist each Line of Business / Region to have one place to view all Issues and Emerging Risks, manage and monitor issues and emerging risks, and to aggregate them as needed for Senior Leadership reporting.
E-RIM site development included use of CSS, HTML, JavaScript, JQuery, AJAX, web services, ASP.NET using C#, Object Oriented features, and form processing.
Developed automated email alerts for E-RIM to keep aligned Risk associates, management, and executives aware of new issues and significant issue updates. Automated alerts are also generated as issues approach or past target and follow-up dates.
Created dynamic views of E-RIM data that allow filtering, to target desired information, as well as data exporting. Users also have the ability to generate adhoc search and export queries.
Create, update, and maintain a reporting tool that allows users to generate pre-formatted detail and summary canned reports, using SQL Server Reporting Services (SSRS).
Building data feed from different applications and different databases to Microsoft SQL Server for E-RIM, using SQL Server Integration Services (SSIS). Like E-RIM receives daily updates for Audit Issues from the Audit Central Issues Tracking (CIT) system (Excel Source), Data feed from Issue Tracker system (Oracle database) to E-RIM Microsoft SQL Server database.
Responsible for planning, modeling, and developing database schemas using Entity Relationship modeling and Normalization concepts.
Regularly coordinate with clients and Onsite for requirements gathering, requirements analysis, design and quality control in Rapid Application Development (RAD) model practices. Utilized Visio for documenting schemas and workflows.
Received client recognition for providing outstanding service. Received Infosys SPOT award for my excellent analytical ability and efficient work in E-RIM.
Education
Computer Science & Engineering, Bachelor of Technology
St. Thomas College of Engineering and Technology
West Bengal University of Technology
June 2005 – June 2009
Kolkata, West Bengal
Graduation Date: June 2009
Degree Grade Point Average: 9.08 out of 10
Affiliations & Interests
Received Infosys SPOT award and INSTA award for my contributions and exceptional performance in projects at Infosys.
Got top cumulative relative rankings (CRRs) of 1+ for my hard and efficient work at Infosys.
Have completed technical and software product quality related certifications like, Infosys Certified MST Web Developer, Infosys Certified Software Engineering Professional, and Infosys Quality Centric certification.
Like collecting coins and reading books in leisure time.
Have worked for Unified Mission for Rehabilitation and charities, (U.M.F.R.C.), Working nationwide for the cause & care of poor and needy children.
Contact this candidate