.Net Business Manager Project Management Sql Server
Resume:
Abhijeet Rokde
********.*****@*****.***
PROFESSIONAL PROFILE
. 7+ years of professional IT experience in designing and developing
state of the art cutting edge enterprise software solutions.
. Experience in a broad spectrum of industrial tasks including
requirement analysis, design, development, testing and deployment of
windows and web-based applications using Microsoft technologies.
Worked on new development as well as maintenance projects.
. Experienced with code generation of DAL, BLL and Entity Component
Layers for .NET.
. Expertise on C#, .NET frameworks, VS.NET 2005/2008/2010, WPF, WCF, Win
Forms, SSRS, ASP.NET, IIS 6.0, Silverlight, SQL Server 2005 and NABS.
. Expertise in third party reporting tool Oblicore.
. Expert level understanding of OOPs, RDBMS, N-tier application
concepts.
. Practitioner of Best Practices in all phases of Software Development
Life Cycle and Project Management. Worked in both Agile and Scrum
methodology and very well experienced with Scrum Meetings and Agile
task estimation.
. Valuable Team Leader/Member and a Fast Learner
. Excellent Analytical, Problem Solving, Programming and Debugging
skills
. Excellent communication and interpersonal skills
FUNCTIONAL SKILLS
. Good understanding of the Telecom Domain and call processing.
. Sound Knowledge of E-commerce business.
TECHNICAL SKILLS
Operating Systems Windows XP/2000/2003/2008
RDBMS ORACLE 8i/9i, SQL-Server 7.0/2000/2005, DB2, MS
Access 2000
Internet Programming ASP.NET, .NET Framework, WPF, WCF, Web
Services, ADO.NET, XML/XSL, SOAP, CSS, HTML,
DHTML, XAML, SOA
Languages C#, VB.NET, ADO.NET, PL/SQL,
Web Servers IIS
Scripting Languages JavaScript, VB Script
SQL Tools SQL Enterprise Manager, PL/SQL Developer,
SQL*PLUS, T-SQL
Other Tools Visual Studio, VSS, Star Team, Sub Version,
Oblicore
CERTIFICATION
* Microsoft Certified in Microsoft .Net Framework 2.0 - Web based Client
Development (Exam ID 70-528)
* Microsoft Certified in Microsoft .NET Framework 2.0 - Application
Development Foundation (Exam ID 70-536)
PROFESSIONAL EXPERIENCE
American Express, Phoenix, AZ
Jan'010 - Present
Role - Technical Lead
Project: GCT, Service Level Management
Service Level Management project is a crucial project for American
Express. This project actually calculates the Service attainments of
American Express Vendors like Verizon, AT&T, HP and IBM. The project uses
Oblicore as their Reporting tool for generating reports, Metrics and .NET,
C# and WCF for generating Scripts. Oblicore is a third party tool developed
by Oblicore Inc. This tool consists of implementation process which
includes:
. Service Catalog Manager
. Contract Manager
. Business Logic Expert
. Data Sources Expert
. System Administrator
Responsibilities:
* Involved in Design Architecture of SLM Data flow using Microsoft
Visio. In this Architecture we designed different work flows as how
the data will come to AMEX Network (TIMS Server) through different
vendors and how we process the data to calculate the SLA's of AMEX
Vendors.
* Implemented WCF Services to read the Raw Data file (Which is
basically an Excel file) through NetTCP Binding.
* Implemented different Public Classes to convert the output data
into CSV file using LINQ to OBJECTS in C#.
* Created Data Access Layer for INSERT/UDATE/DELETE in SQL Server.
This DAL is created by using LINQ to SQL and LINQ to Objects.
* Created an Interface in C# for transferring the data from SQL
Server database to Oracle Database. As Oblicore uses Oracle as a
backend database.
* Generated different Events/Delegates which distribute the huge data
into multiple Objects.
* Implemented Base Exception Class for Exception Handling.
* Creating Contracts for multiple metrics. These contracts are
basically defines a particular Service Level Attainment.
* Created different SLALOM module in Business logic Module. The
SLALOM is basically a type of MAP/Array object which holds the
records/data of previous metrics.
* Designed and Developed the Oracle Database schema for Oblicore
Adapters.
* Generated different procedures and functions in VBScript for
calculating the Service Level Attainment of a Contractual metrics.
* Business Logic highlights:
1. Identifying and defining input Event Structure required for
calculation later to be defined as Event Types
2. Building required fields into Event Type to provide data
required for all calculations in which it is used
3. Defining Metric registration process to maximize Events flow
4. Determining how to build the resource model from available
data to satisfy all reporting and logic requirements
* Data Source highlights:
1. Identifying Data Source type and deciding how it should be
normalized by the Adapter into defined Event Types and fed
into Oracle database.
2. Deciding Event type identifiers that should be attached to
the data.
* Used the framework to help move the business services division from
an Access centric development model to a .Net based model with
Agile methodology.
* Day -to- day offshore team co-ordination, Responsible for SCRUM,
CVS and configuration management.
* Maintained backlog for the application and estimated the tasks in
daily Scrum meetings.
Environment: .NET 3.5, WCF, C#, LINQ VBScript, Oracle10g, SQL Server 2005,
MS Excel, XML, Oblicore, Microsoft Visio.
Cap Gemini Consulting India Pvt. Ltd.
May'08 - Dec'09
Role - Sr. Software Consultant (.NET Architect)
Project: TDC DealerShip System, Denmark
TDC is one of the leading Telecom and mobile service provider
largely spread in Denmark and most of the places in Europe. The heart of
TDC sales shops is an application called TDC-KVIK which is implemented in
ASP.NET, C#, SQL Server 2005 and WCF. This is an integrated multilingual
platform supporting back office and front office user. This application
mainly designed for sales and support business functionality and integrated
with different shared services involving different technology stacks.
Responsibilities:
* Utilized prior system design experience to translate business
requirements into logical designs that conform to the current
Application Architecture.
* Responsible for designing High & Detail Level Design document after
doing detailed system analysis. These documents gives the
information to the client how a particular project is going to
impact the entire production environment.
* Used JQuery in web pages for better effects and more responsive on
the client side.
* Implemented complex data manipulation logic using Stored
Procedures, Views and Triggers.
* Evaluated various application blocks provided by Microsoft
Enterprise Library such as UIP, caching, logging and exception
handling application blocks.
* Used wsHttpbindings in WCF services to get the orders from
different systems, which are not based on .NET framework.
* Implemented Factory and Abstract Factory Pattern to interface with
external credit reporting sources for TDC BackOffice user to check
the customer credit rating.
* Contributed in building the data access layer, which will interact
with disparate systems such as OSM (Order Service Management
system) and NABS (New Accountability and Billing System) Database.
* Used multithreading for asynchronous call to credit reporting
agencies and DBR system to show report seamlessly on the screen.
* Developed several Interfaces in C# which is directly connected to
NABS Database.
* Used xml serializers and de-serializers while exchanging data with
multiple systems.
* Designed data layer using ADO.Net Datasets, Data readers for
efficient communicating with SQL Server database. Created Indexes
for optimization of SQL queries in SQL Server.
* Performed troubleshooting and debug existing code, Tested code and
fixes to ensure quality.
* Oversaw Production Support, provided level-of-effort estimates to
project managers, interviewed job applicants and performed other
team leadership duties.
* Performed unit testing on the code by using Nunit.
* Conducted walkthroughs and code reviews of all completed
specifications.
* Resolved open issues clearly identified and explained base
assumptions to my team and management.
Environment: ASP.NET 2.0/3.5, C#, XML, WCF, JQuery, SQL Server 2005,
SubVersion (SVN), OSM (An Oracle Product), NABS Database.
Client: Lehman Brothers, New York
Aug'06 - Apr'08
Project: LB Business Center Online
Lehman Brothers Business Banking Solutions provides commercial online
banking services for LB commercial clients. As an extension of the current
offering, Business Banking Solutions also offers an online banking service
(ACH, Wire Transfers, and Account Transfers). LB Business Center, which
combines aspects of LB On-line and WCMA Cash Manager (WCM) with enhanced
cash management functionality, online lending, service activation and
account tiring information. WCM, provided by P&H Solutions, Inc.,
represents the cash management component of the LB Business Center.
Responsibilities:
* Web services developed in C# based on SOA principle to provide cash
management services to LB customers.
* Implemented multi-threading for information flow between disparate
systems.
* Efficient use of data structures to cache most recently used data,
thereby improving the overall performance of the applications.
* Developed C# Windows Service to use with Autosys scheduler to
support back office system.
* Designed Rich client interfaces using .NET Windows Forms
* Worked on data layer using ADO.Net Datasets, Data readers for
efficient communicating with SQL Server database.
* Implemented email setups using Microsoft Exchange application when
account transfer has been done on a particular Account.
* Implemented application as a windows service running under a
windows user account.
* Worked on the design, development, management and integration of
SSRS reports into the LB Business Center Application.
* Responsible for writing complex stored procedures in SQL server.
* Resolved open issues clearly identified and explained base
assumptions to my team and management.
* Conducted walkthroughs and code reviews of all completed
specifications, before delivering to the client.
* Provided Production Support for the Executive Management
Information System (EMIS), a web reporting portal which uses
Oblicore as their reporting tool.
* Performed unit testing on the code by using Nunit.
* Deployment of application using Install Shield 8.0
Environment: .Net Framework 2.0, MS Visual Studio 2005, C#, SQL Server
2005, Win Forms, ADO.NET, Microsoft Exchange Server
Yoginet India Pvt. Ltd.
Oct'04 - Aug'06
Role - Sr. Software Developer
Project: www.indiayogi.com, Mumbai
Indiayogi.com is an E-Commerce business & provides a gateway to
spiritual resources from India. Indiayogi provides a safe shopping
experience to members for all its products and consultations, as Credit
Card Payments are Verisign Secured. This ensures safety of credit card
transactions as well as personal information on indiayogi.
Responsibilities:
* Designed and Developed the whole Architecture of the Web Site.
* Solely Responsible for Production Environment of Indiayogi web site
and worked closely with the client to resolve their Production
Issues.
* In the process of rewriting the application from Classic ASP to
.NET 2.0, use Ajax control toolkit, also use update panel to
control full post back.
* Designed Master Pages to show various articles and products on the
Web Site.
* Designed various interfaces using C# for uploading products on Web
site.
* Developed http Web Services for getting order's from different
portals like rediff and tollshop.
* Created generalized Cascade Style Sheet classes compatible for IE,
Firefox and Safari.
* Maintained most of the business rules in xml and henceforth-created
xml rules factory for deserializing business rules.
* Implemented instrumentations techniques like event logging for
logging errors.
* Used caching techniques for some of the static data to improve
performance.
* Worked on URL Rewriting, URL Redirecting, Provided support for old
classic asp pages by using custom HTTP Handlers and custom HTTP
Modules.
* Created Custom Controls like Menu Control by using xml,
Personalized Control etc
* Designed custom Payment Gateways using Fa ade pattern for sending
credit and debit cards info to the payment processing company.
* Solely responsible for SQL Server performance, tuning and
optimization.
* Created Indexes for optimization of SQL queries in SQL Server
* Implemented OOPS concepts, designed Abstract Classes, Multiple
Inheritance using Interfaces.
Environment: ASP.NET, C#, .NET Framework 2.0, AJAX, Visual Studio 2005, Web
Services, JavaScript, SQL Server 2000, T-SQL, IIS 6.0 Administration, HTML,
DHTML, XML, CSS, Windows Server 2003 (server)
Project: www.yogiimpressions.com, Mumbai
Yogi Impression is an E-Commerce business and are Self-help, Personal
Growth and Spiritual book publishers based in Mumbai, India. Established at
the turn of the millennium, at Mumbai, in 2000, Yogi Impressions publishes
books, which seek to revive interest in spirituality, enhance the quality
of life and, thereby, create the legacy of a better world for future
generations.
They publish books, which in terms of design aesthetics, production
techniques and print quality match international standards. Besides books
on spirituality, self-improvement and personal growth, health and well
being, esoteric knowledge and financial prosperity.
Responsibilities:
* Designed and Developed the whole Architecture of the Web Site.
* Solely Responsible for Production Environment of Yogi Impression
web site and worked closely with the client to resolve their
Production Issues.
* In the process of rewriting the application from Classic ASP to
.NET 2.0, use Ajax control toolkit, also use update panel to
control full post back.
* Designed Master Pages to show various articles and products on the
Web Site.
* Designed various interfaces using C# for uploading products on Web
site.
* Developed http Web Services for getting order's from different
portals like rediff and tollshop.
* Created generalized Cascade Style Sheet classes compatible for IE,
Firefox and Safari.
* Maintained most of the business rules in xml and henceforth-created
xml rules factory for deserializing business rules.
* Implemented instrumentations techniques like event logging for
logging errors.
* Used caching techniques for some of the static data to improve
performance.
* Worked on URL Rewriting, URL Redirecting, Provided support for old
classic asp pages by using custom HTTP Handlers and custom HTTP
Modules.
* Created Custom Controls like Menu Control by using xml,
Personalized Control etc
* Designed custom Payment Gateways using Fa ade pattern for sending
credit and debit cards info to the payment processing company.
* Completely Evolved in Analysis of existing system, Designed,
Developed, Configured and Automated with Best performance. That
can be controlled and monitored by customers easily
* Solely responsible for SQL Server performance, tuning and
optimization.
* Created Indexes for optimization of SQL queries in SQL Server
* Implemented OOPS concepts, designed Abstract Classes, Multiple
Inheritance using Interfaces.
Environment: ASP.NET, .NET Framework 2.0, AJAX, Visual Studio 2005, Web
Services, C#, JavaScript, SQL Server 2000, IIS 6.0 Administration, HTML,
DHTML, XML, Windows 2003 (server), Microsoft Exchange Server, CSS
Project: Yogiimpressions Stock Management System, Mumbai
This module was developed to provide a web based solution to various
Department Heads, in order to maintained and update there Stock Register,
Royalty Programs, and Daily Order Dispatching Reports.
Responsibilities:
* Responsible for Customization, Implementation, Enhancement,
Building and Deployment, Support and fine-tuning of Stock
Management System
* Creating Web pages and modifying existing Web pages in co-
ordination with end users
* Used ASP.Net web controls such as Data Grids, Combo box, List box
for designing web Pages
* Used Windows Authorization Manager (Azman) for authentication and
controlling module level access for different users from different
department.
* Used ADO.Net, Parameter collection for database manipulation using
Stored procedures
* Used crystal reports for reporting.
* Written complex stored procedures, triggers, views, functions using
SQL Server
Environment: ASP.NET, .NET Framework 2, C#, CSS, JavaScript, Visual Studio
2005, SQL Server 2005, IIS 6.0 Administration, ADO.NET, HTML, DHTML,
Crystal Reports, Windows 2003, XP
Project: Payroll System
It is an In house Time tracking system. The system was developed to
enhance the functionality of the Payroll System of the organization. Module
is fully automated which generates necessary reports and outputs.
Responsibilities:
* Developing ASP.NET pages, writing Stored Procedures, creating
Reports
* Testing, build & deploying web application on client side
* Responsible for Customization, Implementation, Enhancement,
Building and Deployment, Support and fine-tuning of Payroll System
* Used crystal reports for reporting.
* Used Telerik rad controls which is a Third Party web controls for
ASP.NET
Environment: ASP.NET, .NET Framework 2, C#, CSS, JavaScript, SQL Server
2005, IIS 6.0 Administration, T-SQL, HTML, DHTML, Crystal Reports, Windows
2003 & XP
OmniVision Technologies - .NET Developer
June'02-July'04
Client: R M Mehta, Oil dealership company, Mumbai
Project: Edge Accounts with Inventory (Financial Domain)
This project is based on 3-tier architecture, having
accounting, inventory,
order processing, and admin modules. Also, it has a provision of creating
multiple companies and later on merges them to see the consolidated reports
Responsibilities:
* Developed all masters modules like Group Master, Company Master,
Scheme Master
* Implemented database independent project which can use any database
as a backend
* Implemented a 3-tier architecture having each tier installed on
different machine
* Involved in Database design, specifying Constrains, creating
Indexes, writing Triggers, User Defined Functions, Stored
Procedures, Views
* Used Crystal Reports for reporting
* Involving in maintenance of the source code in VSS
* Preparing low level design documents, flow diagrams, functional
specifications, implementation plans, unit test cases and release
manuals
Environment: Win Forms, .NET Framework 1.1, VB.NET, Visual SourceSafe, SQL
2000, Windows 2000
EDUCATION
* Master of Science in Information Technology from Southern New
Hampshire University, Manchester, U.S.A.
Contact this candidate