Post Job Free

Resume

Sign in

Sql Server Developer

Location:
New Delhi, DL, India
Posted:
June 23, 2015

Contact this candidate

Resume:

SAURAV ROY

Mobile:961*******; E-Mail ID: acqdt3@r.postjobfree.com

Seeking assignments as Technical Architect/ Technical Lead with leading IT companies.

Professional Synopsis

** ***** ** ****** ** experience in software development, design, leading, architecting using Dot net technologies. Presently associated with Accion Labs technologies as Architect involved in developing n tier Web applications in asp.net/c#, Ajax,SQl server . Distinction of working with Global Giants in Consulting and Technology like, Deloittte, Cap Gemini, Sapient, Kongsberg,.Synechron,Experis/Manpower group and Client Like TESCO,DELL,Fidelity,DAVITA,Asurion,Markse,SANDOW,

WCIRB Proficiency in handling the complete SDLC and flair for adopting & keeping abreast the latest IT trends/ technologies. Domain expertise includes Insurance, Health Care Investment banking, Logistics, job portals, Enterprise applications etc. Proven skills in adopting various Agile methodologies like TDD, scrum, extreme programming as Well as CMM/CMMI approaches. Excellent interpersonal & negotiation skills with strong analytical, problem solving & organizational abilities. Aspire to be an Ace Solution Architect.

Areas of Expertise

Design, Architecture planning, Coding and best practices

Case / System study and Analysis

Coding, Deployment, monitoring and development.

Define best practices for development and documentation.

Proven expertise in handling a development team based on offshore onsite model.

Creating POC’s and approaches based on latest and cutting edge technologies.

Full hands on with most of the latest web technologies using asp.net/c# and web 2.0 concepts.

Extensive use of Test Driven Development and Agile/Scrum methodologies.

Experience in creating Technical, Design documents and wireframe modeling.

Extensive knowledge of cutting edge Frameworks and Tools.

Ability to rapidly assimilate new information and new techniques.

Extensively involved in Code and peer reviews.

Refactoring using SOLID principles.

Experience in Isolation Frameworks and Unit Test Frameworks.

Expert knowledge in asp.net,MVC,c#,sql Server,Jquery,Html,SSRS .

Continuous Integration with Team Suite, Automated builds using MSBuild and Production and release packages like roll in roll out.

Impact Analysis and Approach Document Preparation.

Code review/ Peer Reviews

SAP,Tibco, MQ,Mainframe, Mirth and other Cross platform technology Integration experience .

Played a major role in growing a team from 4 people to 50 within 6 months span for a fortune 500 client.

Mentoring Team and Team Building expertise.

Expertise in Conducting Internal Organization wide Technology Training and mentoring programs.

Been part of Technical Interview Panel for major Organizations.

Establishes organization-wide relationships and serves as technical consultant to IT managers, peers, and business users.

Innovative problem solver, able to see the business and technical sides of a problem

Requirement Analysis, fitment analysis and solutioning.

Building the Non-Functional requirements for the product /solution.

Took part in PreSales activities like POC Creation,RFP ‘s, Product Demonstration and documents preparation required to generate business and closing the deal.

Experience in developing cross-platform code.

Experience with creating application architectures and frameworks

Experience in e-commerce workflows and payment gateways .

OnShore/OffShore Model of Working

Three Successful Onsite Assignments to US – Majorly to Denver,Chicago and Nashville,Pitsburgh.

Distinction of working with Fortune 500, Nasdaq and NYSE Listed Clients like Dell, LPS(Fidelity), DaVita,Deloitte,Asurion.Tesco

Involved into Migration of legacy to modern apps .

Technical Skills

Operating System : Windows ( 2000/ 2003/ xp/Windows7/Windows 8).

Application Servers : IIS5.1, IIS6.0, IIS7.0.IIS Express,IIS 8.0

Database : MSSQL Server 2000/2005/2008/2012,Document DB –Raven

Specialities : Visual Studio Visual Studio 2013/ 2012/2010/2008/2005/2003 - Asp.net 1.1,2.0,3.5,4.0,4.5 C#,vb.net,Ado.Net,Vb6.0,Ado/odbc,Win32Api,Windows,services.,EnterPrise,Library,SIlverLight4.0,REST/RIA Services.

Business Intelligence

/Reporting : SSRS, SSIS, Crystal reports.

Web Technologies : Html, XHTML, XML,xpath,xslt,JavaScript,CSS,JSON, REST,AJAX,RSS feeds,jQuery,

web Sockets,HTML5, Query Mobile, ODATA,HTML5.

OOAD and UML tools : Microsoft Visio 2010

Architectural Patterns/Frameworks: MVC 3.0/4.0/5.0, MVP(WCSF 2010),MVVM using silverlight .

Design Patterns/Practises/GOF :Singleton,Facade,Adapter,Factory,Comand,DI/IOC,Observer,SOLID,TDD, BDD,Strategy,Provider,Repository,Prototype, AOP, Builder, Publish Subscribe.

EAI/Workflow Tools :Biztalk 2006 R2,WWF,Mirth Connect using HL7 Messaging.

Middle Ware/SOA :MQ Series, MSMQ, SAP Connectors, COM, WCF 4.0, XML/SOAP Web Services, TIBCO iprocess EMS queuing,NServiceBus.,http Services using WebAPI.

Configuration/ Source Control : TFS2010,TFS 2012, SVN, Continuous Integration,MSBuild, GitHub with Source tree

OR/M : Entity Framework 4.0/4.1/5.0 (POCO,Code First,Data First), nHibernate

Monitoring/Debugging : ANTS, Fiddler,FxCop,Resharper.Firebug,IE Developer,YSlow.

Mocking /IOC containers/TDD : nMoc, Unity, Nunit, MoQ,MS test, Structure Map,Auto Mapper

Third Parties/Open Source : Telerik. JQuery Controls, Kendo UI,Knockout.js,Razor Views,Jquery Datatables,, Sonar Cube,Jq Grid, Jquery Datatables .

Analytics : Active Analysis, google analytics

Automation : Power Shell Scripting, Nugets

JavaScript Frameworks : Angular Js, Knock Out Js

Mobility : Windows 8 Phone, Xamarin Studio, Emulators.

Cloud : Amazon Cloud Services,S3 .

Career Highlights

Accion Labs - From 2014 Aug – Present

Designation - Technical Architect/lead developer

Role - Individual Contributor

Client: PCNClosings LLP Team Size: 7

Duration: Oct 2014-Present

Location –Bangalore-Pittsburgh

Business Domain-: BSFI – Mortgage and Banking, Safe Escrow .

Platform: VS2013, MVC5, WebAPI, GitHub, Amazon Cloud Services,Entity Framework 6, SQL Server2012,, TeamCity,Angular js, SSRS,SSIS . Wiki, Mirth Connect (EAI),Bootstrap .

Responsibilities: Involved in end to end transition leveraging on onsite-offshore Model for the application development, design and change request.

Client site visit to Pittsburgh (US) for design and architecture discussions.

Involved into application code refactoring and hands on coding when required.

Third party API integration using Mirth Connect (EAI ) .

Incorporated Enterprise wide Business Intelligence for the Client leveraging on Enterprise reporting, ETL and Data Migration

Integration of WebApi from SSRS for reusability of Domain Entities.

Architecture decisions on Automation test scripts.

Building Proof of concepts for different technical approaches keeping functional as well as non functional paradigms in mind

Considerations and development of various Technology Integration and Endpoints aspects.

Played role of a solution designer and Consultant across business domains.

Involved into design and architecture of their ETL,Data Migration and Reporting Infrastructure .using SSIS .

Development of REST API’s .

Migration of MVC 4 to MVC5 .

Reporting directly to CTO/CEO of the client .

Database Modelling and writing Complex Stored Procedures .

Title: Sandow/BeautyDNA.com Team Size: 6

Duration: Aug2014-October

Client: Sandow Media

Location –Bangalore

Business Domain-: Media

Platform: VS2013,MVC4,WebAPI, GitHub, Amazon Cloud Services,Entity Frameowork 6,SSRS,SSIS.SQL Server2012,Zillow API

Selenium for Automated tests,Rihno Mocks .

Description: Involved in Re-Architecting a Performance bottleneck module using SSRS .

Setting up Infrastructure for the Github, Evaluation and comparison of Various Open Source and licence software’s.

Involved into 3rd API integration used for Mortgage Valuation . Integration of Amazon Cloud Services (AWS and S3) .

Involved into setting up Infrastructure and evaluation of various open source as well as Proprietary licenses

Involved into technology decision making and Coming up with various POC's .

Involved in implementing google analytics for the website .

High level design of a payment gateway module .

Ecommerce and Payment Gateways Integration.

Xinthe Technologies - March 2014 – July 2014 (Contractual Mode for Sapient and Tesco from Xinthe )

Designation - Architect/Technical Lead

Title: Tesco.com (World’s biggest retailer) Team Size: 20

Duration: mar 2014-July 2014

Client: TESCO On payroll of Xinthe Technologies.

Location –Bangalore

Business Domain-: Retail

Platform: VS2012, Asp.net MVC4.0, C#, XML, SQL server 2012, Entity Framework 5.0,WebAPI. BDD,TDD,SpecFlow .

Description: World’s one of the Biggest Retail portal.

Responsility: Involved into design and architecture of tesco Europe grocery stores based on Multi tenant,SAAS model

Architecture,

Development of WebAPI’s used in Business logic layer for Mobile devices .

Powershell scripting for automation of Active Directory Components and attributes

Experis (Fortune 500 company) - From 2012 Dec – 2014Feb

Designation - Technical Architect/lead developer (Contractual/Consulting mode from Experis to DELL)

Role - Individual Contributor

Title: Dell.com Team Size: 20

Duration: June 2012-present

Client: Dell R & D (fortune 100 company). On the payrolls of ManPowerGroup

Location –Banglore

Business Domain-: Manufacturing/Enterprise Apps

Platform: VS2012, Asp.net4.5/MVC 3.0, C#, XML, SQL server 2012, Entity Framework 5.0., NSerrviceBus,MSMQ

WebAPI.,knockout js,Angular JS, Signal R .

Description: World’s Biggest Ecommerce portal generating revenue of $15 billion early for Dell international.

Responsility: Engaged in research and development work playing a role of IC (individual contributor) involved in

Enterprise architecture, design and development. Extensively involved in creating POC’s based on latest technologies.

Extensive experience in debugging and troubleshooting complex technical problems .Used various monitoring tools

Gomez,ttw,tea leaf for improvising on production end product.

Konsberg Gruppen /Digimaker - Sept 2012 – Nov 2012

Designation - Tech Lead

Client: Emisoft Norway

Location –Banglore

Business Domain-: Oil and natural Gas

Platform: Silverlight,.net

Emids - From 2011 Oct – 2011 June

Designation - Technical Lead

Role - Lead and Developer

Title: Falcon Blueprint Team Size: 20

Duration: October 2011-June 2012

Client: Davita (fortune 500 company).

Location –Chicago/Banglore

Business Domain-: Healthcare/Kidney Dialysis

Platform: VS2010, Asp.net4.0/MVC 3.0, C#, XML, SQL server 2008, Entity Framework 4.0.

.Telerik,Jquery,AJAX .Jquery,Json,Html5,KnockOut.js,Kendo UI.Unity (DI),HTML5

Description: Heavily and extensively worked on the client’s UI framework and 3rd part integration software’s

Like kendo UI (html5),JavaScript’s frameworks, Repository Pattern, Moq . Also involved leading a team of . E-Prescription module

With Iterfaces like Mirth Connect and HL7 messaging. Simulators etc

Responsility: On site Requirement Gathering from business, extensively worked on UI to match MockUps

More of Onsite/Offshore Coordination leveraging more on Individual Contribution .Delegating work assignments

To appropriate team members and monitoring status and reporting risks proactively.

Responsible for growing team size from 4 people to around 20 in short duration. 80% coding involvement. Leading

A team of 7 people from offshore.

VServe - From 2011 June – 2011 Sept

Designation - Technical Architect/Technical lead

Role - Architect and Hands on developer

Title: SystemX Phase 1 Team Size: 30

Duration: Mar 2011 – Sept 2011

Client: Lender Processing Services- Asset Management Services Arm of Fidelity. (Fortune 500 company).

Company: V-Serve Solutions Pvt Ltd.

Client: Fidelity Information Services (fortune 500 company).

Location –Onsite,Denver Colorado

Business Domain-: Mortgage and Field Services.

Platform: VS2010, Asp.net4.0, C#, XML,SQL server 2008 Service Broker,ORM/Entity Framework 4.0.Blaze Rule Engine,

WWF.Telerik,Jquery,AJAX .MVC.Jquery,Json,Html5,KnockOut.js,Kendo UI,Dev Express,Dotnet Nuke .

Description: SystemX is a initiative for creating a common gateway for Lender Processing Services Field Services Arm.

SystemX is capable of handling the business at an Enterprise level using an asset centric centralized business processes and data repository.

Architecture: The web UI leverages on MVP and WCSF2010 architecture with extensive use of Rad, Jquery and Ajax.

Enterprise messaging uses Service Broker as asynchronous message processing with in-built queues.

Security model. Uses asp.net Role, sitemap,memebership providers .WCSF 2010 Service dependency for DI.

Responsility: On site Requirement Gathering from business, Creating business Use cases and interaction Use cases.

Design and architecture decision making. Coding code review .Standards and best practises .

Synechron - From 2009 Dec – 2011 Jan

Designation - Technical Lead

Role - Team Lead and Developer

Title: iWeb www.PhoneClaim.Com

Duration: Dec’09-Jan 2011 Team Size: 30

Client: Asurion (world’s largest Handset insurance provider)

Company: Synechron Technologies

Business Domain-: Handset Insurance/Telecom

Platform: VS2010, Asp.net4.0/3.5, C#, XML, Xpath, SQl server, NHibernate, Microsoft Dynamics CRM,WCF,TDD’s,Moq

Description: PhoneClaim.com is the most crucial portal for Asurion for online claim processing, it aimed to reduce call centre

Maintenance cost for handset claim processing by emphasising more on web processing.

The portal is capable of handling huge number of online claims without minimum intervention and use B2B interactions.

This site is designed based on n-tier architecture and also interacts with various internal and third party components like

CRM, Rule Engine,Tibco email services,Joomla etc .

Responsibilities-: Design/architect and developed a very critical module called TIP(Tibco i process) for integrating it with the present web portal by using Tibco EMS connectivity .

Leading a team of 4 people and mentoring them with architectural design and know hows.

Leading/Driving daily Scrum Calls relevant to Tier 1 agile and Business Calls.

Requirement gathering and analysis using UML and OOAD tools like EA.

Independently working on various User stories and tracking the successful delivery of those within the Sprint timeline.

Leading/Participating on Sprint Planning meetings and estimation of efforts and timelines, risk/dependency analysis.

Tracking Product Backlogs for proactive solution analysis.

Code Reviews, Peer Reviews .Best Practises and site performance monitoring, offshore onsite coordination.

Sapient Corporation - From 2008 June – 2009 Nov

Designation - Senior Associate

Role - Senior Developer/Team Lead

Title: Leerink portal initiative www.Leerink.com

Duration: Since May’09 Team Size: 10

Client: Leerink Swann LLC (MedaCorp)

Company: Sapient Corporation.

Business Domain-: Health Care Investment Banking.

Platform: VS2008, Asp.net, C#,SSRS, XML, Xpath, SQl server 2005, LINQ,MVC Framework,nunit,nMock

Description:) It aimed to create a critical Pricing Model which would be used by leerink to price there clients based on Surveys they conduct on health Care investment. It would be integrated in the existing leerink Portal (www.leerink.com

Responsibilities-: Extensively involved in designing and well as coding the module using OOAD methodologies both in front end,

back end middle tiers. Involved in mentoring junior team associates giving transitions and helping out with technical solutions

.

Extensively followed agile/Scrum methodologies like refactoring, TDD, peer reviews etc, daily meetings etc.

Title: Legacy Replacement System (Phase 1)

Duration: Jul’08 – Apr’09 Team Size: 30

Client: WCIRB California (US Govt)

Company: Sapient Corporation.

Business Domain-: Insurance.

Platform: VS2008, Asp.net, C#, SSRS, SSIS, Biztalk 2006 R2, MQSeries, MSMQ, XML, Xpath, SQl server 2005.

Description: It aimed to replace the old Legacy Mainframe based Rating system of WCIRB which would save huge maintenance charge every year for them. The application has got 4 phases to be developed out of which Phase 1 has been completed.

This is a very complex technology integration project in Sapient.

Responsibilities-: Handled a very critical module LSR/CTA, Redesigning/refactoring it using open XML format both in

front end back end and middle tiers using technologies like Biztalk,SSRS,Asp.net,MQ series,MSMQ.

Capgemini India - From 2007 June – 2008 June

Designation - Consultant

Role - Developer

Title: Columbus

Duration: July-2007-jun 2008 Team Size: 50

Client: Kanbay International USA

Company: Capgemini Consulting India

Platform: Asp.net (C#) 2.0, Sql server 2000, Java Script, HTML, People soft HR, Oracle Apps

Description: It aimed to develop and support groups of applications and share point portals of Kanbay and integrate that to capgeminis

Responsibilities-: Resolving all productions issues/Tickets raised by clients, involved in client interaction for better understandilitity

Of the ticket. Solving high priority issues like S1, S2 ‘s.Everyday support activities like Taking backup modifying SSIS/DTS packages Etc.

Deloitte - From 2006 Nov – 2007 June

Designation - Analyst

Role - Developer

Title: Partners Photo Directory

Duration: Nov06-May 07 Team Size: 10

Client: Deloitte & Touche LLP (USA)

Company-: Deloitte India

Platform: Asp.net(C#), SQL server 2000, Sqlserver 2005, SAP Connectors, Java dScript, Html, Web services, SSRS reports, Microsoft BI (SQL server 2005)

Description: It is a module of Deloitte’s portal (DeloitteNet) and it’s a technology integration project which integrates SAP, Dot net and Sql server technologies. It’s aim is to fetch the Deloitte's partner’ and director's Images which are there in SAP repository by Calling SAP RFC's from dot net using SAP dot net connector (proxies) and outputting those in Reports (PDF & xls) format using Microsoft Business intelligence (SSRS reports).It’s a typical System Integration project

Responsibilities-: Independently coding a module PPD photo directory,

ESSPL - From 2006 June – 2006 Nov

Designation - Analyst

Role - Developer

Title: OPS_Work_Package4

Client: Markse Sealand (AP Moller group Denmark)

Duration: 6 Months Team Size: 20

Platform: Asp.net(C#), sql server 2000, java script, HTML,Vb6.0,asp

Business Domain-: Logistics.

Company: Enterprise System Solutions.

Description: It aimed to develop an application used to monitor the operational business for Mearsk Logistics (AP Moller Denmark). It keeps a track of the ships movements along with the containers used to carry goods from one location to another.

Worked as a free lancer for various

Small business and websites

- From 2004 sep – 2006 Apr

Designation - Programmer

Title: Gardencentrejobs.co.uk (http://www.gardencentrejobs.co.uk/),Diagnostic centres in Kolkata etc .

Business Domains Worked For -: HealthCare, Insurance, Automobile, Mortgage, Logistics, and Enterprise Systems,

Manufacturing,Ecommerce,BSFI,Media,Oil and Gas .

Academic Highlights

2008 MSC (IT) from Kuvempu University, Shimoga Karnataka

2003 Bachelor of Computer Application from M.C.R.P.V, Bhopal

Personal Information

Date of Birth: 26th May 1980

Passport No- F9199801

Visa Status -B1 VISA till 2021 (Multiple Entries).

Onsite Experience -7 months – 3 successful onsite assignments to USA for decisions on technology roadmap.

Achievements -: Member and a technical author of Code Project .(member id - imsauravroy)

Successfully published various tip/tricks .

Hobbies: Driving, Snooker, Travelling (Travelled to most of the places of North and Central America)



Contact this candidate