Sr. Consultant Resume
NJ
Professional Summary:
Over 14 years of IT experience in Analysis, Design, Coding and implementing medium to enterprise level business applications. Highly proficient in designing and developing n-tier business applications using Service Oriented Architecture (SOA), designing and creating business process workflows, designing and modelling databases using SQL Server as backend.Experienced in Waterfall, Agile/Scrum methodologies and Test Driven Development (TDD) Process.
Highly Proficient in .NET Framework 4.0/3.5/3.0/2.0, C#, Windows Communication Foundation (WCF), Workflow Foundation (WF), .Net Web Services, ASP.NET, ASP.NET MVC Framework, JQuery, ASP.Net Ajax Toolkit, Win-forms, multi-threading, Entity Framework 4.0 (EF),nHibernate, LINQ, SQL Server 2008R2/2005, T-SQL, SSRS (Reporting Services), SQL Server Service Broker, SQL Server Integration Services (SSIS)/ETL Packages, ADO.NET, XML, XSD, XSLT, HTML, JavaScript.
Expertise in designing normalized databases for business applications, writing stored procedures, SQL-CLR Procedures, identifying and creating necessary indexes, working with SQL Server Service broker queues, performance tuning complex stored procedures, T-SQL Queries, and creating SSIS/ETL Packages.
Experienced with full project life cycle (SDLC) using Agile/Scrum, Waterfall methodologies,and varied work experience in theWeb Marketing, Mobile Services, Health care, Lead/contact management, and volume licensing, financial/brokerage-oriented projects.
Certifications:
Microsoft Certified Application Developer (MCAD)
MCP Certified for Exam 70-229
Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.
MCP Certified for Exam 70-315
Developing and Implementing Web Applications with Microsoft C#. NET
MCP Certified for Exam 70-316
Developingand implementing Windows based applications with Microsoft C#.NET
MCP Certified for Exam 70-320
DevelopingXMLWeb Services and Server Components with Microsoft C#.NET and Microsoft .NET Framework.
Education
Master of Computer Applications (M.C.A)
Technical Skills:
RDBMS
SQL Server 2008 R2/2005
Development/Productivity Tools:
Visual Studio 2010/2008, Business Intelligent Dev Studio 2008, Team Foundation Server (TFS) 2005, Object Relational Designer (O/R Designer), SQL Server Management Studio, SQL Server Integration Services (SSIS), SSRS, Data Transformation Services (DTS), Red Gate SQL Build,Sql Server Profiler
Frameworks:
.NET Framework 4.0/3.5/3.0/2.0, Windows Communication Foundation (WCF), Workflow Foundation(WF), Entity Framework (EF) 4.0, nHibernate, LINQ (LINQ2SQL, LINQ2XML, LINQ2Objects), ASP.NET MVC, ASP.NET Ajax Framework, ADO.NET, Microsoft Enterprise Library
Technologies:
ASP.NET, ASP.NET MVC,WCF SOAP/REST Services, ASP.NET Web services, ASP.NET Ajax Toolkit, SQL Server Service Broker, MSMQ, ADO.NET, Style sheets (VSS), Web Parts, SQL-CLR Procedures, SSRS (Reporting Services)
Programming Languages:
C#, LINQ, JQuery, JavaScript,VBScript, VB.NET, T-SQL, HTML, XML, XSLT, XSD
Tools:
SharePoint Portal Server 2003, ER Win, MS Visio, MS Visual SourceSafe, Product Studio, Tortoise SVN, CruseControl.Net 1.5
Web Protocols:
Http, TCP/IP, SOAP
Web Server:
Internet Information Services (IIS) 7.0/6.0
Project/Work Experience:
Client: Confidential, NJ (Aug \'12toTill date)asSr. Consultant
Technologies and Tools:.NET Framework 4.0, C#.NET 4.0, Visual Studio .NET 2010, Windows Workflows 4.0, Entity Framework 4.0, ASP.NET 4.0, ASP.NET MVC3, JQuery,Ajax, XML, XSD, JSON Serialization, SQL Server 2008 R2, Log4Net, TFS
Project:SBC ToolKit
This project was designed and implemented under compliance of Patient Protection Affordable Care Act (PPACA) to produce SBC’s for UHC subscribers. PPACA requires insurance companies and employers to provide simple-to-understand summaries of the benefits and coverage (“SBC”) provided under both individual and group health plans. These summaries must be provided for most participants beginning with the first open enrollment period occurring on or after September 23, 2012.
Contribution: (Individual)
- As an individual contributor, I was accountable to design and code assigned pages (views, models, controller classes and repository classes).
- Analyzed and identified performance bottlenecks in the common medical events pages.
- Identified and fine-tuned complex stored procedures and related queries. Created necessary indexes to improve the query responses.
- Analyzed and provided design approach for loading plans data from various agencies using SSIS packages. Mentored ETL developers to implement packages.
- Actively involved in the QA, UAT and production bugs fixing activities.
- Actively involved in troubleshooting plans data issues and worked with client-teams to resolve data related issues.
Client: Confidential,New York (Sep \'10toJul’12)asSr. Consultant
Technologies and Tools:.NET Framework 4.0, C#.NET 4.0, Visual Studio .NET 2010,Tortois SVN, Windows Communication Framework (WCF), Windows Workflows 4.0, Entity Framework 4.0, ASP.NET, ASP.NET MVC3, ASP.NET Ajax Framework,ASP.NET Ajax toolkit, JQuery,XML,XSD, .NET Serialization, SQL Server 2008 R2, Sql Server Integration Services (SSIS), CruiseControl.Net, TestDriven.Net, Log4Net, NUnit, CuttingEdge.Conditions, NCover, Red gate ANTS, Red gate Data/sql compare
Project:Property Intelligence (PI)
The Property Intelligence application and tools were designed and implemented to have a centralized reporting and also integrated Real Estate Platform withlegacy MRI and Investran systems.Mainly it supports DRP capabilities to receive, store and reports on key financial and operational data elements for Real Estate and private equity Investments.
Contribution: (Individual)
- Worked with MRI SMEs and business analyst to understand the requirements for PI and MRI integration for financial data.
- Designed and coded views, domain model classes and controller get and post actions for templates management functionality.
- Designed and coded views for template management screens.
- Designed and coded WCF web services APIs for user interface operations and APIs to process financial data uploads and GL account translations.
- Designed and coded business logic layer classes for complete UI operations and workflow activities.
- Modeled and created database schema for the entire application and coded Data Access Layer using Entity Framework 4.0 and repository classes.
- Designed and coded template definitions and mapping approach for workflow engine to extract and process financial and operational data.
- Coded custom workflow activities data uploads and approval process by property managers and clients.
- Coded unit and integration test cases for TDD process for highest quality.
- Designed and developed SSIS /ETL Packages to load Chart of accounts, operational and financial data provided through excels and delimited files through MRI system.
- Designed and developed SSIS / ETL packages to synchronize PI and MRI systems bi-directional changes.
Client: Confidential,MIS, New York (Apr \'09toSept’10)asLead Developer / Architect
Technologies and Tools:.NET Framework 3.5, C#.NET, Visual Studio .NET 2008, TFS2005, Windows Communication Framework (WCF), Sequential Workflows using WF, Multi-threaded windows services, LINQ to SQL, O/R Designer, LINQ to XML, LINQ to In-memory Objects, ASP.NET, ASP.NET Ajax Framework, ASP.NET Ajax toolkit, JQuery,XML, XSLT, XSD, .NET Serialization, SQL Server 2005, MS Visio, InfoPath
Project:Print to Mail
Print-To-Mail solution is designed and developed for The City of New York, Human Resources Administration agency to deliver 20 million mail pieces to customers every year. The set of tools and services are implemented .Net environment using SOA architecture. This solution provides immense cost savings to the HRA by means of postal discounts and also assists in normalizing, correcting and presorting addresses.
Contribution: (Lead Developer / Architect)
- Closely worked with PM’s, business users to get detailed requirements and designed technical architecture and technical specifications.
- Designed the layers and services of the system and mentoring 3 developers in coding web request intake application, and coded services using SOA architecture to process these requests in the service layer. Web UI is designed and developed using ASP.NET, Ajax Toolkit, JQuery, and using C# as code behind page handlers. Web Services are designed and coded in WCF environment and workflow has been designed using Windows workflow foundation using Visual studio 2008.
- Modeled and designed normalized databases for the entire solution using SQL Server 2005. Maintained database changes for entire development cycle and frequent builds.
- Designed and implemented LINQ 2 SQL data context models using O/R Designer as a data access layer.
- Designed and coded business logic in the web services using WCF to process UI operations. Entire functionality has been implemented in the services layer.
- Coded asynchronous sequential workflow enabled web services to generate job samples by performing request processing steps like extracting data, validating data, performing address standardization, performing mail merge, generating pdf files.
- Designed and coded multithreaded windows services to process the production job workflow to process requests on scheduled intervals.
- Coded transformation utility library to transform electronic xml forms in to html using XSLT for pdf generation.
- Coded C# library to process extract/pull data from external SQL Server/Oracle databases, delimited text files. Used C# reflection to return dynamic list of objects to process generic file formats.
- Worked with other teams/developers to integrate PTM services with external FileNet /eforms services.
- Designed and integrated SSRS Reports for request summary and drilldown details of request review and approval.
- Performed code reviews and made sure team follows design/coding standards, mentoring on their day to day activities.
- Closely worked with PMs on updating development status, task assignments, and managing deliverables and review sessions with business group.
- Coordinated with DBAs for frequent database backup/restores, permission related issues.
- Involved with third-party vendor software reviews with respect to PTM2 integration architecture.
Client: Confidential,RedmondWA (Jan \'08 toApr’09)
Sr. Application Developer – (Sr. Consultant)
Technologies and Tools: .NET Framework 3.5,C#.Net, Winforms, Visual Studio .NET 2008, TFS2005, Windows Communication Framework (WCF), State Management Workflow (WF), LINQ to Objects, LINQ to XML, ASP.NET, ASP.NET Ajax toolkit, XSD, .NET XML Serialization, SQL Server 2008, SSIS/ETL Packages, MS Visio
Project:Cashback Bing/Live Search Merchant On-boarding
I have worked with Cash back Bing Search (earlier Live Search)Merchant On boarding team to help on boarding merchants who wants to participate in the Bing search (Live Search) Cash back program using Premium Direct API integration. Microsoft Bing/Live search cash back program offers savings to U.S customers who click on search text ads in the live search site.
Contribution: (Sr. Application Developer)
- Designed and developed a shopping cart application using ASP.NET, C#, Visual Studio 2008, .Net Framework 3.5
- Designed Shopping Cart Database in SQL Server 2008
- Integrated shopping cart with Live Search Cash back premium direct APIs using C#
- Implemented Digital Signature validations in C#
- Designed and coded Products & Catalog services using Windows Communication Foundation (WCF)
- Designed and coded Purchase Orders Processing Workflow using Windows workflow (WF)
- Integrated with PayPal for PayPal payment processing.
- Designed and coded DAL using LINQ to SQL O/R Designer.
- Created integration guidelines for onboarding merchants
- Wrote SSIS/ETL Packages to pull Catalog, products from products warehouse databases
- Closely worked with onboarding PM\'s and provided assistance for analysis and technical/architectural guidance.
Project: CLP-SA Benefits, Customer Centric Licensing
The customer License Position (CLP) solution toolset, services and workflow processwere designed for Microsoft Corp to help their customers to view comprehensive reports of volume licensing relationship with Microsoft across multiple programs and agreements. Customers worldwide can access their License Statements on demand and use that information to make better business decisions. Microsoft field employees or marking groupare using License Statements to drive revenue and provide superior customer services to their important customers.
Contribution:
- Developed Windows application in C# for generating License Statement templates in 14 supported languages.
- Developed Windows Service in C# for generating large size of Microsoft License statements in excel format.
- Designed and Developed License Statement Web Service & APIs for external users and applications to consume over httpusing WCF, C#, XML and SOAP.
- Implemented Certificate Security for all the Web Services developed.
- Designed and Coded Software Assurance Benefits features into services and workflow processes.
- Enhanced License Request Web site to support changes for every feature set released on monthly basis.
- Designed and implemented Customer Centric Licensing Services using WCF, C# in MLS Analytics environment.
- Designed and implemented SSIS/ETL packages to pull volume license data from corporate warehouse databases.
- Coded complex stored procedures to process XML data.
- Fine-tunedcomplexlegacy stored procedures and queries for better performance results.
- Participated in daily Scrum meetings and involved in peer-peer code reviews for weekly releases.
- Helped QA team to troubleshoot issues.
- Fixed production bugs and released on timely manner.
Client: Confidential,Omaha NE (Nov \'06 to Dec ‘07)asLead .NET Developer (Sr. Consultant)
Technologies and Tools: C#, .NET Framework 2.0, Visual Studio .NET 2005, TFS 2005, Windows Communication Foundation (WCF), ASP.NET 2.0, Telerik Controls, XSD, .NET XML Serialization, ASP.NET, Sql Server 2005 (T-SQL, Stored Procedures, Triggers, SQL-CLR procedures, SQL Server Service Broker), SSIS Packages/ETL, MS Visio, MS Project, Red Gate SQL Build
Contribution:
- Designed & Developed .Net Web Services, .Net windows services using for their UK clients.
- Designed and implemented enterprise exception handling and logging.
- Mentored 5 .net developers in the team.
- Designed normalized Database for Membership, Billing Interface Services.
- Designed and implemented a process to handle high-volume of transactions for Membership and billing Interface services.
- Accountable for the Membership and Billing Interface application deliverables.
- Helped ops team to deploy & setup services and applications during deployment on test and production environments.
- Helped QA team to troubleshoot configuration issues.
- Troubleshooting and fixing test and production issues.
- Participated in Architecture group discussions and to take design decisions at enterprise level.
Project: MMS Membership
Adaptive Marketing is an integrated marketing services company that gives consumers unrivaled opportunities to improve their lives through exclusive access to significant discounts and unique services. A primary vehicle for the addition of new members to many programs is through the use of Web advertising. This will allow a prospective member to review the program offerings and provide them the opportunity to enroll in the program through the Web. This sub-project of MMS is to create the services to allow a new membership to be created through a Web interface.
Project: MMS Billing
MMS Billing is designed and developed to process MMS projects related transactions through Payment Tech Payment processor. It enables rich batch processing and services to all MMS projects to send their AR and AP transactions to Payment tech through this interface. My contribution is to design & develop this interface to process Membership Fees, extended fees and online orders.
Client: Confidential,Bellevue WA (March \'06 to Oct \'06)asSr .NET Consultant
Technologies and Tools: C#, .NET Framework 1.1, XML, XSD, .NET XML Serialization, Visual Studio .NET 2003, Sql Server 2000, MS Visio, MS Project, Tortoise CVS (source control)
Environment:Windows 2003 Server, Windows XP Professional
Project: RSSFeedChannelProvisioning
Infospace provides the server side technology for Cingular Wireless as Media Net. The Content Provisioning System (CPS) that was delivered as a major part of the Media Net project for Cingular Wireless is used to build and deliver the content that is presented to the users of Cingular Wireless mobile phones. My contribution towards CPS is designed and developed a FCPR Plug-In to process RSS Channels and Feeds. Designed and developed a monitoring tool Feed Monitoring Web Service to view the status of feeds getting processed and administrators could see the health status of the process.
Project: IMGAdapter WebService
IMGAdapter provides a mechanism to applications which can send messages to Infospace Message Gateway that dispatches messages to Cingular/T-Mobile/Verizon carrier\'s mobile subscribers. Message could be SMS, MMS, and WAPPush. This adapter exposes predefined class definitions to accept input messages and serializes objects into predefined xml format.
Project: FinanceWrapper WebService
FinanceWrapper webservice designed and developed for Cingular Wireless carrier as a common interface to help multiple applications to extract stock quotes, Symbols and Charts from different feed sources. This smart interface will also transforms extracted stock quotes and symbols xml files from different formats into a common standard format using Xsl transformations.
Project: Weather WebService
This WebService is designed and developed for Cingular Wireless carrier to provide weather information by Location, by zip code, by city, state to Cingular mobile subscribers. This WebService extracts weather feeds from different feed sources based on the configurable params and will ache the feed for better performance and provides xml serialized Weather report to the mobile platform applications.
Client: Confidential,Redmond WA (April \'05 to Jan ‘06)asSr. Application Developer – (Sr. Consultant)
Project: MM System
MM System supports a consistent methodology for initiating, cataloging, tracking, managing and reporting on legal work items. And improve efficiencies through centralized legal department operations and common business process
Designed and implemented MMIPAM Interface, created Xml Schema definitions (XSD), coded enterprise layer component & web services, designed and implemented validation engine, involved in improving backend performance activities. Daily responsibilities are also includes tele-conference with the IPAMM team to understand the business requirements and then translate the requirements into application design.
Project:MS Collect 3.0
MS Collect tool supports Worldwide Credit & Collection activities on a single database, providing ease of data flow and consistency across the regions. This tool provides an ability to prioritize and automate customer collections tasks, improves the productivity and streamlines day-to-day operations and directly reduces the amount of headcount required, and potentially improves overall cash collections.
Design, coding, unit testing, troubleshooting and bugs fixing. Coordinated with test team and also conducted review meetings with the team to solve the issues to ensure that the quality,
Technologies and Tools: Visual Studio.NET Team Suite, ASP.NET, ASP.Net Web Services, C#, HTML, XML, XSD, .NET Framework 2.0, Windows Services, SQL Server 2000, MS Visio, MS Project, MS Visual SourceSafe, Product Studio
Environment: Windows 2003 Server, Windows XP Professional
WIPRO TECHNOLOGIES, Hyderabad, India (Jan \'04 to March ‘05)asTech Lead
Client: Microsoft Corp Project:Bart Payments Engineering
Microsoft has introduced this tool to automate the cash posting process for their retail customers worldwide eliminating the dependency on outsource vendors for the US, in Europe and Asia regions. As part of automation this tool takes the remittance details in Excel spreadsheets format and creates the BAI2 lockbox file by clubbing bank receipt information and remittance information.
Contribution:
Leading the dev team and responsible for the complete application and database design, development, testing, deliverables. Responsibilities also included tele-conference with the Onsite coordinator to understand the Business requirements. And then translate the requirements into application design, review meetings with the Microsoft FTE\'s from Redmond, WA.
I was also involving in the coding, integration, testing the application.
Technologies and Tools:Visual Studio.NET 2003, ASP.NET, C#, HTML, .NET Framework 1.1, SQL Server 2000, MS Visio, MS Project, MS Visual SourceSafe6.0.
Environment: Windows 2003 Server, Windows XP Professional
Confidential,Bangalore, India (May \'03 to Jan ‘04)
Sr. Software Engineer
Client: Confidential,USA Project: Banyan – SCI
Single Contract Issuance system is designed to maintain approved filed contract documents, business policies, and rules, automatically generates customer policy documents and certificates of coverage, provides the ability to view/print documents online through Frontier, and interfaces with internal/external print vendors to print, fulfill, and mail documents to customers\' business and home addresses.
Contribution:
Prepared SRS & Functional Specifications for the project and get it approved from the Client/Business Users. Prepared and maintained Project Plan/Milestone Reports for the Project in scope. Provided daily clarifications to the development team by interacting with the business users from offshore. Analyzed and estimated new work assignments/change requests and reporting to associate manager. Reviewed completed tasks/activities by the team on daily/weekly basis. Carried out periodic reviews with client regarding the status of the project releases. Assisted the development team in performing coding/unit-testing activities for the periodic intermediate Milestone releases to testing team.
Technologies and Tools:Visual Studio.NET, ASP.NET, C#, VB.NET, HTML, XML, XSLT, .NET Framework 1.0, Web Services, SQL Server 2000, MS Visio, MS Project, MS Visual SourceSafe.
Environment: Windows Professional Server 2000, Windows NT (Supports), Windows 98 (supports)
Confidential,Hyderabad, India(Dec\'98 to April ‘03)as
Project Engineer
Client:Confidential,
Projects: WeCare, MaxRAD, CARE, Budget Manager, Path, Mailing List, ADI Manager
I was involved in the designing, coding, testing and deployment of these applications.These applications weredesigned using 3-tier COM+ architecture Object Model. I was involved in coding (front-end, middle tier and back-end coding), testing, data migration process peer-peer code reviews the preparation of setup kits.
Technologies and Tools:ASP, ADO, Visual Basic 6.0, HTML, SQL Server 7.0/2000, MS Visio, MS Project, MS Visual SourceSafe,ActiveX, COM/DCOM, COM+, Visual InterDev, MS Access, Crystal Reports, Install Shield Express/professional
Environment: Windows 2000 Advanced Server/ Windows 2000 Professional client, Windows NT server, Win 98 client/Win-XP client