Srinivas Kolluru

Email: aczk6z@r.postjobfree.com Phone: 503-***-****

15+ years of experience in developing web-based and client server applications with .NET & Microsoft technologies experience in Object Oriented Analysis, Design, Development, Implementation and Maintenance.

Experience in implementing n-tier Architecture & SOA Applications.

Experience in all phases of software development life cycle (SDLC) including Requirement gathering by client Interaction.

Sound experience in Microsoft .NET technologies using C#, ASP.NET, ADO.NET, VB.NET, WCF, Silverlight and ASP.

In depth knowledge of Web / GUI development, Crystal Reports X, SSIS, SSRS, and WCF/Web Services.

With strong leadership, management skills, excellent knowledge in business process redesign, integration of technologies, architecture skills, distributed components development.

Creative thinker with demonstrated ability to take conceptual vision to finished product.

Technical Proficiency

Operating Systems: Windows, XP, UNIX

Languages: C#, VB.NET, VB

Internet technologies: SilverLight, ASP.net, WCF, WEB API, Web Services, JavaScript, XML, CSS, Ajax, ASP, IIS

Databases: Oracle, MS SQL Server, MS Access, MySQL4.0

ETL & Reporting Tools: SSIS, SSRS, Crystal Reports X

Technologies: NET 4.5/4.0/3.5/2.0/1.1, MSMQ, Tibco EMS.

IDE: Microsoft Visual Studio

Tools: Visual Source Safe, Tortoise SVN, TFS, MS Visio, ERWin 3.2/4.0,Rational Rose 98, Sparx Enterprise Architect, Install Shield 8.0

Education

MCM (Master of Computer Management) from - Pune University, in 2002

Trainings:

Attended a Training Program on UML with Rational Rose conducted by SEED InfoTech, PUNE.

Attended a Training Program on COM/DCOM and XML conducted by CSI (Computer Society of India) PUNE.

Attended a 1 year Certificate Course of Diploma in Visual Programming from Datapro, Pune.

Attended a Training Program on GIS (Geographical Information Systems) conducted By Survey of INDIA, Hyderabad.

Strengths

Strong expertise in Object Oriented Analysis & Design.

Strong technical knowledge of .NET, Microsoft related technologies and database design.

Strong functional knowledge of domain and customer requirements.

Good business requirements gathering and documentation skills.

Strong leadership skills, ability to communicate with multiple teams about project objectives, ability to guide & help teams understand project functionality.

Good understanding of project planning and project estimation.

Accomplishments

Provided technical solutions with proof of concept/ prototype for different needs.

Proven record of accomplishment of multiple Product developments.

Proven record of accomplishment GIS Product developments with short learning curve.

Professional Experience

Sr Lead Developer, Macys Systems Technology, Johns Creek, GA Sep 2015 – Till Date

Project: Log Portal.

Environment: C#, VB.net, VB 6.0, Win Forms, Asp.net, Java Script, WEB Services, WCF, Visual Studio .NET 2010/12/15, MS SQL Server 2012/14, PL/SQL, SSRS, SSIS, XML, Tortoise SVN, Beyond Compare, Windows 7/Windows 2008/12 servers, Tibco EMS.

Description: Log Portal Application comprises of Receiving, OSD, Pool Stock, Receipt Edit, FLO, Analytics and Application Maintenance, couple of Tools to support the Macy’s Logistics division business team.

Responsibilities:

Documentation of System Specifications and Data models.

Developed WCF Services using Design Patterns with C#.

Developed POC using ASP.net MVC using WEBAPI

Worked on Enhancements for OSD, Receiving and Pool Stock Applications.

Worked on Multi-Threaded Windows service for Receipt Edit using Tibco EMS.

Designed and Developed SSIS packages and SSRS reports for the Logistics Analytics

Worked on performance improvements for Stored Procedures and Packages in PL/SQL and T-SQL.

Co-ordination with Offshore team, Business, QA and Management for Successful implementation

Performing code reviews / Peer reviews to ensure that it's secure, optimized and following standards.

Assisting other team members to solve day to day problems.

Deployment of the Solution across different environments

Technical Lead, Ernst & Young, Atlanta, GA, Chennai, India Aug 2013 – June 2015

Project: Allocation and Tiering Module (ATM), One Global System (OGS).

Environment: C#, Asp.net, MVC, Java Script, WCF, Visual Studio .NET 2010, Entity Framework, MS SQL Server 2012, SSIS, SSRS, TFS, Beyond Compare, Beyond Compare, XML, Windows 7/Windows 2008 server

Description: ATM application is providing Tax and Allocation functionality to different Clients by maintaining the Partners and their Incomes and Taxes submissions prepared for IRS.

OGS application is providing different services like Tax filing Calendar services, Travel and Immigration services for the Individual employees of EY Clients

Responsibilities:

Documentation of various artifacts including Design (high level and Low level), deployment diagram etc.

Re-engineer the existing Applications with Enhancements that includes Design and Development.

Designed new screens and developed WCF services for the Middle layer.

Worked on Winforms with C# for Utilities for parameter based Data extraction to generate XML and Excel files.

Designed and developed Multi-Threaded windows services to poll the Job Data to initiate the Data extraction and creating the Excel files.

Developed Views, Stored Procedures and functions for Business rules and Data extraction and for Reporting functionality using SSRS.

Designed and Developed SSIS packages to Import in to system and Export large data from system.

Test Cases created using MS Test for Unit Testing.

Created Tasks and Monitoring the Defects created in HP ALM in TFS.

Supporting the existing applications for break fixes.

Co-ordination with Business, QA and Management for Successful implementation

Co-ordination with different Development Teams (Onsite/ Offshore model)

Deployment of the Solution across different environments

Reviewing existing code and ensuring that it's secure, optimized and following standards.

Assisting other team members to solve day to day problems.

Sr Programmer Analyst, Inc Research, Cincinnati, OH Sep 2012 – July 2013

Project: Clinical Data Management System.

Environment: C#, VB.net, Asp.net, Telerik Controls, Java Script, WCF, Rave MediData Restful Web Services, JMS, Visual Studio .NET 2010, TSQL, Oracle 10g, PL/SQL, TOAD, TFS, XML, WinMerge, Windows 7/Windows 2008 server

Description: This is the Clinical Data Mart being used by multiple Applications to store and retrieve and Store data like Study, Subject, location, results and Reviews information of different Drugs of All Sponsors. Processing data from 3rd party data source (Rave from MediData) using Restful Web Services and SSIS.

Responsibilities:

Documentation of various artifacts including Design (high level and Low level), deployment diagram etc.

Re-engineer the existing Applications with Enhancements that includes Design and Development.

Developed new pages including UI and Middle tier.

Designed and developed a Multi-Threaded windows service (StudyTransfer Service) to read messages from JMS and post back to Rave MediData.

Designed and Developed SSIS package to Process CSV files and Load the data in to Clinical data mart.

Supporting the existing applications for break fixes.

Co-ordination with Business, QA and Management for Successful implementation

Co-ordination with the Team spread across various Countries (USA, Singapore)

Deployment of the Solution across different environments

Reviewing existing code and ensuring that it's secure, optimized and following standards.

Assisting other team members to solve day to day problems.

Project Leader, Humana Inc, Cincinnati, OH July 2009- Sep 2012

Project: Human Touch, Product Catalog, Humana Vitality, Shared Data Repository, Enterprise Address Service for Humana Inc.

Environment: Silverlight4, ASP.NET, C#, IIS, WCF, Visual Studio .NET 2008, SQLSERVER 2008,TSQL, SSIS, SSRS, PL/SQL, Entity Framework,TFS, XML, Windows XP/Windows 2003 server, FINALIST, Geocoding Plus, CICS, Tortoise SVN, Win Merge, Sparx Enterprise Architect,

Description: This is the Data Store getting updated by using SSIS Packages and WCF services to get updated from Enterprise Data Warehouse and other data sources which is being used by all applications across Humana.

Responsibilities:

Manage teams, resources and responsible for release the project on time.

Coordinate with different Development Teams (Onsite / Offshore model) and Business

SOA Implemented by communicating to Legacy Systems through WCF service and CICS web service.

Created Architecture, High level and Detail design Documents for Product catalog, Enterprise Address service and Humana Vitality.

Designed and Developed Silverlight Application using MVVM pattern for Product catalog.

Worked on UI development using ASP.net for MDM application

Designed and Developed ETL Packages using SSIS to process Millions of records across Databases.(i.e. DB2 to SQL Server), FTP to Mainframes Copybook, Creating Text files and FTP to Linux Server for EDW.

Developed a Data Conversion Process by mapping the DB2 data from different Platforms data to SDR structure using ETL packages of SSIS / Informatica tools.

Designed and Developed Reports using SSRS.

Test Cases created using MSTest for Unit Testing.

Assisting my superiors to design secure and optimized architecture and recommending solution.

Implementing strong security solution to protect sensitive data and application.

Reviewing existing code and ensuring that it's secure, optimized and following standards.

Shared Data Repository was implemented by Agile/Scrum methodologies.

Assisting other team members to solve day to day problems.

Sr. Developer/DBA, Intel Corporation, Beaverton, OR June 2008- June 2009

Project: UPAPOC Framework

Environment: ASP.NET, C#, WCF/WSE, Web Services, Visual Studio .NET 2005/2008, MSMQ, JAVA SCRIPT, HTML, IIS, SQLSERVER 2005/2008,TSQL, NHibernate, NUnit, Cruise control, XML, CSS, Windows XP/Windows 2003 server, Sparx Enterprise Architect, TFS.

Description: This is a an initiative from Enterprise Architecture team to create an Unified Project Architecture Framework for Intel's future Healthcare Products based on SOA.

Responsibilities:

Designing and Implementing N-Tier Application Architecture.

Translating exiting Use Cases, sequence diagrams and implementing it as per specifications.

Assisting my superiors to design secure and optimized architecture and recommending solution.

WSE3.0 Webservices converted to WCF using .Net Framework 3.5

NHibernate and WCF/WSE3.0 used to communicate between DAL and other business components.

Developed UI for the Application and consumed the WCF services

Designed and Developed Multi-Threaded Windows Service to process messages in MSMQ queues.

Designed and Developed Multi-Threaded Windows Service to process Files and update the Staging Database.

Strong security solution implemented to protect sensitive data and application.

Test Cases created using Nunit for Unit Testing.

Deployment packages and the User documents created.

Performed Code reviews to verify the coding standards and expected results.

Assisting other team members to solve day to day problems

Lead Analyst, Avazpour Networking Services Inc., Overland Park, KS Feb 2008- May 2008

Project: Avazpour

Environment: VisualStudio.NET 2005, C#, ASP.Net, ADO.NET, IIS, HTML, XML, SQL Server 2005, SQL Server Reporting Services, Windows XP, AJAX, Visual Source Safe.

Description: This project is designed to automate the systems in Avazpour for their Customer management and maintain the accounts and Billing information with reporting functionality.

Responsibilities:

Optimized the source code to improve performance

Created reports using SQL server reporting Services (SSRS)

Working with Business people on the requirements and Feasibility study

Billing data of the Application integrated with QuickBooks.

Involved in the UAT and fix the issues field by QA

Project Leader, Automatic Data Processing Pvt Ltd., Hyderabad, India Jan 2006-Jan 2008

Project: eStart

Environment: VisualStudio.NET 1.1/2.0, C#, ASP.Net, VB.NET, ADO.NET, IIS, HTML, XML, webservices, SQL Server 2000/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Windows XP, Microsoft Visio, AJAX, Visual Source Safe, Tortoise SVN, MSMQ, ASP, MySQL.

Description: eStart is an Intranet Application used by the Sales force, Management and the Implementation Specialists of ADP, across 35 regions in USA for Payroll processing of different customers of different Capacity.

eStart will capture the data from the Sales Team, Management and Implementation Specialists in their Region in to a regional database and the necessary data is being updated in to the Central database using MSMQ and Job Schedules defined. The central database is being used for the Analysis and to track the status of Sales orders, Tasks assigned to IS and so many useful reports being generated by the National Reporting tool across all the regions.

Responsibilities:

Involved in the design, development and requirement analysis of the enhancements of the Application.

Working with Business on requirements gathering and finalizing the same.

Working closely with developers on technical issues and time lines.

Manage teams, resources and responsible for release the project on time.

Provide extensive production support, and fix problems in a short span of time.

Created Web Forms using web form server controls (ASP.Net server controls, validation controls, Custom controls and User Controls)

Designed and implemented a Data Access layer for requests to the database.

Designed and developed reusable User Controls to reduce the number of pages the user has to navigate.

Converted all the queries that are used by Current web forms into stored procedures for better performance.

Achieved portability and reusability of the code by making aspx page just a container which holds User Controls

Used SSIS for updating the Central reporting database from the central transaction database.

Used SSRS to create National reports.

Lead Designer, (KPIT Cummins & InfoWorld for iKnowvate Inc.), Pune, India Aug 2004-Dec 2005

Project: WellDreams

Environment: VisualStudio.NET 1.1, C#, VB.NET, ADO.NET, LLBGen Pro, XML, SQL Server 2000, Windows XP, Microsoft Visio, FxCop, Crystal Reports X, Visual Source Safe, Infragistics suite, Install Shield,.

Description: iKnowvate has undertaken a key initiative to enhance the business process of Well Drillers in USA at various capacities i.e. a small Home business to an Entrepreneur in that area. They come up with an Idea of Developing a product named WellDreams with different configurations for a small business to an Enterprise.

Responsibilities:

Prepared Class Diagrams, Functional Specification, Business Objects and Use cases for all User Control, Screen and Business Logic.

Used ADO.Net and LLBGen Pro for Data Access Layer.

Developed custom Caching objects using C#

Designed UI layer controls for Winforms, business objects of Business Layer and Database tables. Implemented reflection to Implement Design Patterns.

Generated Reports using Crystal Reports and provided runtime design functionality for the reports.

Worked extensively on all Layers i.e. UI/Winforms, Business and Data

Project Manager, RAAY Software Pvt Ltd., Pune, India Mar 2003 - Aug 2004

Project: ProDoc

Environment: VisualStudio.NET 1.1, C#, VB.NET, Winforms, ADO.NET, XML, SQL Server 2000, Windows XP, Microsoft Visio, Crystal Reports, Visual Source Safe, Infragistics suite, Install Shield, ERWin.

Description: This is a Health care product targeted to all clinics in Europe and India. It is a multi-user, Multi-lingual (English, French and German) Windows based client-server application. The software allows the user to manage patient records i.e. maintain OPD as well as IPD visit related clinical information of a patient and Billing system. The software allows the user to maintain various examinations done (like Abdomen, Cardiovascular, ENT, Neck etc) and investigations like (Endoscopy, Imaging, Physiology etc). The software also allows the user to maintain daily schedules of all employees of hospitals and also allows recording bed scheduling information.

Responsibilities:

Analysis & Design of Application and Database

Effort Estimation, Project planning, Scheduling and Tracking.

Development of Code Components (Data Access and Business Logic)

Developed stored procedures, Views, Triggers and Functions using T-SQL.

Co-ordination with Development Team, Language Translators (French, German), Doctor and QA.

Creation of Customized Installable using Install Shield.

Involved in the UAT and fix the issues field by QA.

Project Manager, Techni Graphic Systems India Pvt Ltd., Pune, India May 2000 - Feb 2003

Project1: PlotFinder

Environment: VB.net, Winforms, ASP, VB 6.0, ASP, Windows NT 4.0, webservices, MS SQLServer 2000, Crystal Reports 8.5, MAP Objects from ESRI (Environmental Systems Research Inc.), QuickBooks SDK1.1 for Financial Accounting, ERWin.

Description: This Product is targeted all the cemeteries form medium to large size and Customizable to the Client requirements. This is the unique Product having the Interface with Map displaying the entire cemetery with Visual & statistical information of Grave Status in the Cemetery. Also this will allow Multiple Cemeteries having the Database at one Place and maintain the Common inventory and other Administrative tasks to be done centrally from one Location.

Responsibilities:

Involved in the requirement, design, development and analysis of all the modules.

Coordinating with Business people on requirements and converting them to Technical specifications.

Developed a Wrapper control on Map Objects to display the Cemetery on the screen.

Developed Webservice to Pull the Map files changed by concurrent users.

Development of Code Components (Data Access and Business Logic),

User Controls developed for Winforms.

Developed stored procedures, Views, Triggers and Functions using T-SQL.

Involved in the UAT and fix the issues field by QA.

Provide extensive production support, and fix problems in a short span of time.

Developed a Data Conversion Process by mapping the Client data to Plot Finder data structure to convert the Data from the database of other Products for the new Clients.

Project 2: MxVision

Environment: VB 6.0, Clipper 4.0, Windows NT 4.0, Access 2000, SQL Server and Crystal Reports 8.5

Description: MxVision is the Re-Engineered Product of MxVision Developed by Swartz Systems Inc. USA, with Additional features of Inventory, Financial Accounting and Payroll System in addition to the Clinical Module, Targeted all Nursing Homes in OHIO, Kentucky and Michigan States of United States.

This Product is designed according to the HCFA (Health Care Financial Assistance) rules and regulations which is the Authorized body for Residents Welfare at Nursing Homes and will Pay the Resident's Expenses during the stay based on the score of CMI (Case Mix Index) calculated from RUGs.

Based on type of Assessment and Medicare and Medicaid provisions of Resident this software calculate the RUG Score, ADL Patterns and CMI to be submitted to HCFA for the payment of a particular Resident.

Responsibilities:

Involved in the requirement, design, development and analysis of all the modules.

Analysis & Design of Application and Database

Development of Screens and Business logic.

Developed stored procedures, Views, Triggers and Functions using T-SQL.

Developed Audit module consists of 500 functions to validate the MD2 Data entered.

Created Crystal reports of different complexities using Sub reports.

ActiveX components developed for validating and formatting the user input.

Creation of Customized Installable using Install shield.

Involved in the UAT and fix the issues field by QA.

Sr SoftwareEngineer, Decos Software Development (India) Pvt. Ltd, Pune, India Feb 2000-Apr2000

Project: Decos Document Professional (WEB Version)

Environment: VB6.0, VBA, Windows NT 4.0, ASP, Java script, Back end independent (Connectable to SQL Server, Oracle, Access)

Description: Template Manager is a Unique Module Which Allows Creating and Modifying Word Documents for mail merging purpose through Decos Document Professional of Both WEB and Client / Server Applications.

Responsibilities:

Developed Template Manager Module.

Created Installable and Integrated with Decos Document professional.

Systems Analyst, DSS InfoTech Pvt. Ltd., Pune, India Jan1998-Feb 2000

Project 1: On-line Process Quality Management System

Environment: VB 6.0, Windows NT 4.0, Back end independent (supports SQL Server, Oracle, Access), Crystal reports, ERWin, Install Shield.

Description: On-line Process Quality Management System is a product, targeting the manufacturing industry where Process Quality Monitoring is involved. The system gives the facility to monitor the ongoing jobs as well as completed jobs. Aiming at a multi-user environment, the product gives facility for global level Job monitoring, on-line and off-line decision-making facility on non-conformities etc.

It lets the user to formulate and maintain the Quality Assurance Plan, Monitor the Jobs, Maintain History Records, take actions on rejections after inspection and to analyze the Quality and its trends using Control Charts.

Responsibilities:

Analysis & Design of Application and Database

Development of Screens and Business logic.

Developed stored procedures, Views, Triggers and Functions using T-SQL, PL/SQL.

Crystal reports creation

ActiveX components developed for displaying different types of charts.

Creation of Customized Installable.

Involved in the UAT and fix the issues field by QA.

Project 2: EDI System (Electronic Data Interchange System)

Client: Mahindra Sintered Products Ltd., Pune, India

Environment: VB 6.0, Windows NT 4.0, Back end independent (Connectable to SQL Server, Oracle, Informix, Sybase, Access), Crystal reports, ERWin, Install Shield.

Description: Main Objective is to send Business Documents Digitally without Paperwork, by Generating Text File Using the Selected Database (Any RDBMS or Access) by the User.

The application takes care of retrieving information from the existing database and it's converted into a text file to be sent to the client through electronic media.

Vice - versa data is accepted from the electronic media in an ASCII format and it's uploaded into the system. Necessary selection / updating of data are done automatically, as per the definition for different customers and suppliers. This will reduce the Time and maintains accuracy.

Responsibilities:

Involved in the requirement, design, development and analysis of all the modules.

Analysis & Design of Application and Database

Configured the connectivity for Informix database on SCO UNIX server to Windows Server.

Development of Screens and Business logic

Developed stored procedures, Views, Triggers and Functions using T-SQL, PL/SQL.

Creation of Customized Installable.

Created reports using Crystal reports

Involved in the UAT and fix the issues field by QA.

Project 3: Central Database Maintenance System

Client: Arabian Insurance Group, Bahrain

Environment: VB 5.0, Oracle 7.3, MS Access, Crystal Reports Windows NT 4.0, ERWin, Install Shield.

Description: A Centralized database is maintained at Bahrain. The Centralized database will have the

relevant reference and transaction data from Head Quarters at Bahrain will have the highest version of the

application and all Sites will have lower version. The purpose of this application is to transfer the reference

data from the sites to Central Database through Inter Net (FTP).

Responsibilities:

Involved in the requirement, design, and analysis of all the modules.

Development of Screens and Business logic.

Developed stored procedures, Views, Triggers and Functions for data access and manipulation using PL/SQL.

Developed an Interface to communicate with UNIX server from Windows server using FTP.

Created reports using Crystal reports

Created deployment files using Install Shield.

Project 4: RAPID (Relational Application for Process and Instrumentation Diagrams)

Client: Intelligent Computer Solutions Ltd., London, UK

Environment: VB 5.0, VC++, Oracle 7.3, AutoCAD 14, Object ARX and Windows NT 4.0, ERWin

Description: RAPID is a specialized software package targeted to Oil Plants and other major plants where Process and Instrumentation Diagrams (P&ID) are involved in layout designing and maintenance.

RAPID have modules for storing, customizing and retrieving layout diagrams. It uses the User friendliness of VB and the RDBMS power of Oracle to store and manipulate AutoCAD 14 Diagrams. RAPID maintains a very useful symbol library where P&ID symbols are stored and attached to the drawings when needed.

VB forms are used for administrating the drawings and assigning attributes to the symbols and drawings.

Responsibilities:

Involved in the requirement, design, development and analysis of all the modules.

Developed COM components for reusability.

Development of Screens and Business objects.

Developed stored procedures, Views, Triggers and Functions using PL/SQL.

Created reports using Crystal reports

Created deployment files using Install Shield.

Contact this candidate