Sql Server .Net

PROFESSIONAL SUMMARY:

** ***** ** ** ********** in Systems Analysis, Architecture, Design, Development, Testing and Implementation of various Client / Server, N-Tier and Web applications and Database design.

Over 10 years of professional work experience using .NET with ASP.NET, C#.NET, VB.NET, WPF, WCF, ADO.NET, SQL Server, Oracle and XML

Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, and ETL processes

Expertise with Database design, modeling including dimensional modeling.

Extensive experience in MS SQL Server 2012/2008R2/2005/2000, Oracle 9i/11g, Business Intelligence in MS SQL Server Integration

Services (SSIS), MS SQL Server Reporting Services (SSRS), and MS SQL Server Analysis Services (SSAS).

Expert in ETL-Extraction Transformation Loading, Data warehousing, Operations Data Store concepts, data marts and OLAP Online Analytical Processing technologies.

Extensive knowledge in maintenance and optimization of Database and Server using various SQL tools (SQL Profiler, Indexes, Statistics, File Groups, and DBCC).

Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2008/2005/2000.

Experienced in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.

Good knowledge on Sharepoint2010/2013.

Having Strong experience in Crystal Reports and Web Intelligence tools.

Very strong experience in developing Applications using .Net 4.5 Framework, WCF, MVP, Silverlight, MVC 4.0, Entity Framework 4.0,Restful Services and WebAPI

Strong Development experience with Microsoft.Net Framework using C#, ASP .Net, .Net 1.0, .Net 2.0, .Net 3.5, .Net4.0 and experience in developing applications of Graphical User Interface (GUI) using WPF, Silver Light

Extensive experience in Software Development Lifecycle (SDLC) specifically Extreme Programming (XP), .Net Application Architecture and SCRUM methodologies, N-Tier applications, Service Oriented Architecture (SOA) and Web based (B2B, B2C) and One-Stop messaging and collaboration Solutions integrates on Hosted Exchange.

Performing logical and physical data modeling, implementing physical database objects and developing optimized stored procedures to solve complex problems using Microsoft SQL Server 2012, 2008 and 2005. Extensive used of complex SQL queries, scripting, stored procedures, views, triggers and schema definitions for xml queries, WCF services and web services.

Implemented various Design Patterns such as Model View Controller (MVC), Singleton Pattern, Factory patter ns etc.

Solid knowledge in Agile/SCRUM Methodologies. Managed the developers monitoring project progress and development using SCRUM methodologies.

Implemented ADO.Net Entity Framework to do data mapping of business objects. Query objects using LINQ to Entity in a WCF Services and/or Web Services.

Used Base Class Libraries (BCL) such as System.IO, System.XML, System.Diagnosticsetc for various projects

Highly Proficient in a wide range of Internet/Intranet, web, Client/Server technologies like XML, .Net Framework 3.5, CLR, Using XML in .Net, PDF, MS-Word Templates, C#, COM,COM+,ASP. Net, .Net Security, .Net Remoting, ADO. Net, SOAP, .Net, VB 6.0 and scripting using JavaScript.

Strong Hands on experience in SilverLight, WCF, WPF and WinForms and WebForms

Expert in N-tiered Architecture, development and implementation using Microsoft .NET technologies

Innovative and self-directed individual with strong interpersonal skills, highly adaptable and quick to learn and adept at analyzing situations and taking initiative to solve problems.

TECHNICAL SKILL SET:

Languages: C, C++, C#

Web Technologies: ASP .NET 4.0, ASP 3.0, AJAX, XML, WCF, WebServices, SharePoint 2010/2013, Crystal Reports, SilverLight, Entity Framework, ColdFusion, MVC, WPF, WWF

Databases: SQL Server 2005/2008/2012, LINQ, Oracle 11g

Web Servers: IIS 6.0, IIS 7.0

Scripting Languages: Java Script, VB Script, JQuery, CSS, HTML

Unit Testing Tools: NUnit, NMock

Configuration Tools: VSS, CVS, Rational Clear Case, SVN and TFS

Messaging Technologies: MSMQ

Operating Systems: Windows 2000/NT/XPs/Vista/7, Red Hat Linux 9, Solaris, UNIX/ Linux

Frameworks: AngularJs

PROFESSIONAL EXPERIENCE:

Client: HealthwaysInc, Nashville TN May 2015 to Till Date

Title: Senior .Net Developer

Embrace™ is a revolutionary platform that supports a suite of solutions to deliver individual-centric, whole person interactions and interventions. These interactions drive customer-desired outcomes such as adherence to clinical guidelines, improvement in well-being and cost savings. Embrace platform leverage best medical evidence, behavioral science and engagement techniques that positively influence the health and well-being of individuals and population.

CIS: Clinician Information System is a windows application is being used to carry out interaction between Clinicians (Healthways employees) and members (Healthways customers). Healthways offers comprehensive solutions that improve well-being, decrease healthcare costs, enhance performance and generate economic value for their customers. We have built and maintaining the CIS for Healthways to serve their mission critical and day to day operations, to carry out and track day to day interaction between members (end users) and clinicians, to track member’s health needs and behaviors and suggest in case of any modifications required in member’s behaviors for their wellbeing.

Responsibilities:

Create and maintain Embrace and Popworks SQL Server database objects

Provide 24x7 application support for Embrace and CIS for nine call centers

Analyze, define and document system requirements for data, workflow and logical processes

Cross train fellow colleagues

Provide technical input for new development and enhancements to supported applications and processes

Respond to error reports, problems or questions regarding supported applications and processes

Work closely with QA and Deployment groups to correctly test and deploy new development to production

Knowledge of complex business logic as it pertains to all contracts for CIS and Embrace

Worked on ORM technologies like nHibernate,Entity framework.

Designed and developed simple and complex WPF,windows,WCF applications with very little or no supervision.

Contributing to design solutions, coding, testing, code reviews, test case reviews, review of functionaltest plans and support ST, System integration testing, user acceptance testing, Critical Business Testing,

Dress rehearsals.

Architecting and building various components. Requirement analysis, solution design and proposal directlywith account stake-holders.

Proposing performance and enhancement proposals supported by various artifacts like Proof of concepts, metrics and wireframes.

Creating development supportive document like Technical specifications

Design Architecture and dependency chart.

Developing frameworks, establishing code discipline (fxCop, Code Analysis),

Code review, functionality review.

Programming and coding various components written in different technologies like WPF MVVM, WCF

Client: Michelin Investments Limited, S.C (Greenville) Nov 2013 toMay 2015

Project: Stock Allocation Management

Title: Senior .Net Developer

Stock Allocation Management (SAM) application is used to allocate the availability of the warehouse wise stock to the needs of different customers (Importers) based on the business rules along the horizon of 78 weeks.

Data Receipt Management module is used to handle all the inputs coming from different systems of operations and all the inputs will upload the system automatically.

Stock Allocation module is involves the calculation of stock allocation by taking the inputs such as demand, Shipment plan, stock available and outstanding purchase order quantity.

File Generation menu used to generate the output files (MISAOR/Attribution/Weekly Needs and Monthly Needs) from SAM application to other applications.

Admin Module maintains primary (reusable) data. This menu is used by system admin to set up zone level parameter data, user access setup, and automated job setup for input file uploads, Calculations & Process, Output File generations.

Responsibilities:

Designed relational database and normalizing them for SQL Server database and developed Stored Procedures, Triggers and SQL Queries.

Designed using ASP.NET MVC4.0 framework.

Implement business rules and developed middle tiers of the applications using ADO.NET Entity Framework, LINQ to SQL, LINQ Queries, and XML Web Services.

Used various OOPS concepts like Inheritance, abstract class, interfaces, polymorphism in Business entity layer.

The team uses Visual Studio Team Foundation Server for version control, work item tracking, build management, planning, and project governance and performance analysis.

Analyzed and uses UML methodology such as use cases and flow process chart with Visio 2003.

Supervised team progress, monitoring the activities keeping in mind the date’s commitment trying always to do the revisions or the deliveries just in time.

Designed the User Interface with VisualStudio 2010.

Created various SSRSreports which are available for customers reporting needs.

Performed support for replication and data latency problem.

Provides production support on all kinds of previous maintenance.

Provides QA role in business logic behind stored proc, views, and triggers.

Used advanced XML manipulation on the client and server side to improve performance in web service

Good experience on SOAP and Rest Web services

Environment: ASP .Net MVC4.0, C# 4.0, SQL Server 2008, WCF, XML,JQuery,HTML,SVN, Dependency Injection.

Client: Netik LLC/ CoreOne TechnologiesMar 2005 – Oct 2013

Project Name: Interview Data Warehouse 7.x, 8.x

Role: .NET Developer / Sr .NET Developer / Technical Lead

Location: New York, London, Cape Town, Bangalore

Description:

Interview, designed specifically for global funds management, the key and core feature of Interview is its data warehouse which is widely used across the Money Management and Investor Services sectors for all aspects of Reporting and Data Management. ETL based workflows sit at the heart of Investment Operations at many of the leading Asset Managers, Hedge Funds, and Wealth Managers, Private Bankers, Prime Brokers, Fund Administrators, Custodians and Investment Operational Outsourcing providers.

Responsibilities :

Involved in architecture & design of various modules of the Interview product.

Involved in requirements gathering from onsite business partners and clients to design & building the key functionalities of the Product.

Hands on coding of core assemblies, Web Services, Web forms, etc.,

Involved in Code Review of various modules written by the team members and guide them on technical issues.

Performance tuning review of various components of the system including the Database design issues and Stored Procedures.

Participating in design and development of WCF service, windows service, Admin UI, model objects implementation and WCF Service testing tool implementation.

Lead a team of 10 members at on offshore and responsible for development and delivering the modules on time.

Responsible for entire life cycle of the project includes Requirement gathering by communicating with business team.

Conducting daily Scrum meetings with the team to meet the deliverables.

Work closely with our management as well as the client for the delivery of the solutions, releases.

Analyze business requirements, identify a work breakdown, and lead the design and development of the Assignment application project.

Have weekly review calls for status, requirement and tracking with team and client together.

Working as the point of contact with QA, and able to track and assign defects, and report status.

Monitor & manage, training and development of staff

Environment: VS.Net 2010, ASP.NET, C#.NET, VB.NET, WCF, .NET Framework 4.0, Sqlserver2008/2005/2000, Oracle 9i, Entity Framework, ASP.NET MVC 4.0, Microsoft Office, HTML5, JavaScript, CSS, XML, XSLT, VB.6.0, ASP, Crystal Reports XI/2008, and MS-Visio

Module Name: Enterprise Reporting

Description:

Enterprise Reporting is built on Interview framework which enables the customers to design their reports using Crystal Reports and incorporate them into the Product framework. This enables the feasibility of generate different flavors of the reports and bundle them together into a report pack delivered to the configured customers based on different delivery methods configured in the system. This feature enables the clients deliver their financial reports to their users in a timely fashion. Scheduler functionality is built around this feature enabling the Report generation process trigger automatically upon availability of the financial data.

Responsibilities :

Involved in designing and implementation of PDF builder component and all its related functionality.

Involved in architecture & design of other Key Workflow components.

Involved in requirements gathering from onsite business partners and clients to design & building the key functionalities of the Product.

Writing the functional and technical documentation of different modules of this functionality.

Prepare and Manage project plan.

Have weekly review calls for status, requirement and tracking with team and client together.

Involved in Code Review of various modules written by the team members and guide them on technical issues.

Participating in design and development of windows service, Web forms, model objects implementation.

Lead a team of 4 members at on offshore and responsible for development and delivering the modules on time.

Responsible for entire life cycle of the project includes Requirement gathering by communicating with business team.

Conducting daily Scrum meetings with the team to meet the deliverables.

Environment: Interview Framework, VS.Net 2010, ASP.NET, C#.NET, VB.NET, WCF, .NET Framework 4.0, Sqlserver2008, Entity Framework, HTML5, JavaScript, CSS, XML, XSLT, Crystal Reports XI/2008.

Module Name: Netik Admin Controller

Description:

Netik Admin Controller is a windows application intended to control the admin features of the Interview application. Basically this application allows the administrators of the application create / manage user groups, users, accounts, user level permissions, account level permissions, creating an Inquiry, roles, configuring database archiving and many more.

Responsibilities :

Involved in porting the application from VB 6.0 to VB.NET using the Framework 4.0.

Designing the implementation of new enhancements defined by the Product management team.

Act as a technical architect for development and integration of .Microsoft applications using Visual studio 2008, C#, ADO.NET and SQL Server.

Design and Developed database objects (stored procedures, queries) using T-SQL for SqlServer 2008 to store and manipulate data.

Lead a team of 2 members at ofoffshore and responsible for delivering the modules on time.

Prepare and maintain Technical documentations.

Have weekly review calls for status, requirement and tracking with team and Product Management team.

Environment: C#, Framework 4.0, Visual Studio 2008, Sqlserver2008, TFS, XML, XSLT.

Module Name: Netik Schedule Reporting

Description:

Another add-on module build on top of Interview framework which generates time based or event based reports of the configured Inquiries (Reports) in Interview application and delivers them using different delivery mechanisms defined in defining any schedule. A unique feature that will help the application users to receive the financial reports delivered without even logging into the system.

Responsibilities :

Act as a technical architect for development and integration of .Microsoft applications using Visual studio 2008, C#, ADO.NET and SQL Server, Interview Framework.

Design and Developed database objects (stored procedures, queries) using T-SQL for SqlServer 2008 to store and manipulate data.

Lead a team of 3 members at ofoffshore and responsible for delivering the modules on time.

Work closely with the Product Architect team in gathering requirements.

Prepare and maintain Technical documentations.

Work independently and promote team productivity ensuring team delivers high quality components.

Prepare and Manage project plan.

Have weekly review calls for status, requirement and tracking with team and Product Management team.

Environment: C#, Framework 4.0, Visual Studio 2008, Sqlserver2008, TFS, XML, XSLT, Interview Framework, DataPortal, InterChange.

Product Name: InterChange&DataPortal

Description:

InterChange is the core Netik proprietary ETL tool developed in house to read various formats of data and load into Interview warehouse. This is workflow based framework enables the users develop custom workflows to define the custom file loaders. This tool also provides the framework for the users to enable them to write their own components using the framework and plug it into the workflow. Event driven workflows can be built using the InterChange workflows.

DataPortal is group of components along with the Database that drives the InterChange workflows and enables the users explore the complete and extensive use of the InterChange workflows. DataPortal database act as a staging place where the data gets loaded, cleansed, transformed and loaded into the Data Warehouse.

Responsibilities:

Involved in porting the legacy code onto C#.NET and framework 4.0

Involved in porting the legacy standard workflows into new InterChange framework.

Design and Developed few key components like Excel file parser comment to read and parse the excel documents and load into DataPortal Database.

Act as a technical architect for development and integration of .Microsoft applications using Visual studio 2008/2010, C#, ADO.NET and SQL Server 2008.

Design and Developed re-usable business components and User Controls.

Design and Developed database objects (stored procedures, queries) using T-SQL for SqlServer 2008 to store and manipulate data.

Identifying and analyzing the performance related issues and executed the recommendations.

Worked in an agile methodology environment.

Environment: Visual Studio 2010, .NET Framework 4.0, 3.5, C#, ADO.NET,.NET Windows Service, SQL Server 2008, Oracle, TFS

Module Name: Reconciliation

Description:

Interview Data Warehouse is enabled to load data from different data sources, which requires need to reconcile the data. Interview provides a well-designed tool which allows reconciling of different data sources and generating reports on completion.

Module Name: FundOfFunds

Description:

FundOfFunds is another add-on module developed on Interview framework. Fund of Funds provides the external fund managers as well as internal administrators with the ability to search the Fund Security Master file for information regarding fund investments and provides expanded securities information for these funds.

Module Name : Geneva and APX Adapter

Description:

These are strategic adapters which enable the customers to export and import the account data from and to their Account Systems. These adapters are building using the DataPortal and InterChange workflow and framework. These Adapters are globally building to suite the customers who own the accounting system from Advent Geneva.

Responsibilities:

Designed and Implemented the key transformation components

Implemented the standard workflow solutions using the InterChange&DataPortal components.

Created and integrated required tasks for the entire application.

Reviewed the design and re-implemented the database objects to address the performance issues in Reconciliation module.

Implemented code behind logic using Object Oriented concepts.

Designed and Developed user-friendly web interfaces using Visual Studio 2010, C# 3.5, server side ASP.NET controls, Web User Control and validation controls.

Developed database objects (stored procedures, queries) using T-SQL for SqlServer 2008 to store and manipulate data.

Environment: Visual Studio 2008/2005, .NET Framework 3.5/3.0/2.0, ASP.NET, C#, ADO.NET, WCF, .NET Windows Service, Web Forms, Sql Server 2008, IIS 7.5, Java Script, Ajax.

Project: BNY SocGen Reporting

Client: BNY Mellon

Role: Sr .NET Developer

Location: Bangalore

Description:

BNY (Bank of New York) SocGen Client Enterprise Reporting will allow the report packs to be compiled on a composite, combined OR single account basis. The SocGen requirement is for reporting which will cater equally and identically for clients irrespective of the number of accounts they may have. BNY must provide the ability to report multiple accounts in a reporting package and in some cases summarize the account information and generate a composite report for the client. In other cases, the schedule must be generated for the composite and then by each account. SocGen Reporting provides reliability, flexibility and minimal technology assistance to reorder or reassign reporting packages. The majority part of the reporting pack is the valuation report, which is generated from data held within SGA. Workflow-driven control will track the Client Reporting process.

Responsibilities:

Designed and Implemented the Crystal reports as per the functional specification defined by the Business analysts.

Involved in database programming to design and implement the stored procedures.

Implemented the standard workflow solutions to incorporate the Crystal Reports into the InterChange framework.

Worked as a team member in a 5 member to deliver the product.

Environment: Visual Studio 2005, .NET Framework 2.0, ASP.NET, C#, ADO.NET, .NET Windows Service, Sql Server 2005, Crystal Reports XI.

Project: CIBC Fund Reporting

Client: CIBC

Role: .NET Developer

Location: Bangalore

Description:

CIBC, the prime brokerage system is integrated with Allocationware to capture Trades done with (TDW) CIBC on behalf of CIBC’s Canadian Prime Brokerage (CPB) Clients. Allocationware is a straight-through trade processing (STP) system to automate the trade allocation and ticketing process for institutional block trading activity. Once implemented, the Allocationware will accept client orders from a variety of sources and electronically match associated exchange executions or fills against these orders. Allocationware is responsible for determining the post-execution allocations submitting the details of these transactions into CPB. This project is to provide CIBC with better and easy way over their existing manual system to maintain the details and keep track of trades between two market entities.

Responsibilities:

Involved in designing the ETL based InterChage workflows to read and parse the client data files.

Involved in database programming to design and implement the stored procedures.

Analyzed and Developed front-end screens using ASP.Net and C# technology.

Used C# and ADO.NET to define and implement middle-tier components.

Coding and testing various Components.

Used VSS for Configuration Management.

Environment:Visual Studio 2003, .NET Framework 1.1, ASP.NET, C#, ADO.NET, Sql Server 2005.

Contact this candidate