Software Engineer Manager

SRIKANTH MELPAKKAM

LEAD SOLUTIONS ARCHITECT

Hands on Architect and Development Manager with extensive experience in design and implementation of Enterprise and SaaS applications. Expert with security, performance, cloud and DevOps. Security Expert, skilled in Secure Design, Risk Management, Compliance.

Contact Information

Email:

**********@*******.***

Tel:781-***-****)

Work Status:

US Citizen

Accomplishments

Microsoft Certified Programmer in C#

Certified PowerBuilder Developer

12 years of experience in Oracle developing Functions, Stored Procedures and Optimizing SQL queries.

Over 4 years of experience as ETL Tech Lead using Informatica

18 years of experience in U.S.A.

Over 9 years working as Tech Lead/Manager

10 years of experience working and Managing with offshore development Teams

Have organized, trained and led onshore and offshore development teams in Agile environment

Good analytical and programming skills.

Extensive Experience in development of Object-Oriented business applications in Client/Server and Internet/Intranet systems

8 years of client facing experience. Working with Clients to understand their requirements and supporting them in installing and troubleshooting the application.

Technical Expertise

O.S. : Windows95, Windows NT, Windows 2000,XP,Windows 7

GUI/Tools: PowerBuilder 4.0,5.0,6.5, 7.0, 8.0, 9.0,11.0, VB.NET, ASP.NET C#, Crystal Reports 9.0, MVC 3.0, WCF, WPF, .NET FRAMEWORK 2.0,3.0,3.5, Visual Studio 2005, 2008.2010,2012

Databases: Oracle 7.1, 7.3, 8.0,10g SQL Server 7.0,2005, SYBASE 12.0

ETL: Informatica 9.6,10.4

Languages: C, BASIC

Areas of Expertise

Application Programming using Client-Server, Web Based Technologies and smart client applications.

Database Programming using Oracle, SQL Server and Sybase.

Expertise in Microsoft .NET technologies and PowerBuilder, real-time Client Server, Windows applications, web technologies, network programming and multithreaded server programming and web-enabled multi-functional, multi-platform distributed systems.

Extensive Experience in Software Development Life Cycle and in Software Design and Architecture.

Responsible for developing Service Oriented Architecture and developing frameworks.

Extensive experience working on ETL pipelines using Informatica 10.4

3 years of experience working on Digital Transformation.

Worked in Big Financial companies like StateStreet, DST Systems and Mass Financial Services, John Hancock Insurance, Boston

Extensive experience in Web Services and XML technologies.

Successfully developed using major software technologies including .NET Framework, C#, WinForms, ASP.NET, ADO.NET, VB.NET, WCF, WPF, PowerBuilder

Extensive experience in requirement analysis, project specifications, application integration, component design, database design and development.

Extensive experience with OO methodologies and Software Design methodologies.

Designed, developed solutions implementing complex business logic using an object-orientated approach.

EXPERIENCE

Lead Solutions Architect – Digital Transformation

John Hancock Investments, Boston, MA July 2016 – Till Date

Role & Responsibilities:

Provide senior level IT technical lead services and direction (which may include) software, middleware, and/or hardware projects (e.g., applications, networks, communications, and client server technologies) on a single platform. Provides technical expertise in systems, technical infrastructure, tools, modeling, external interfaces, and other areas. Completes complex development, design, implementation, architecture design specification, and maintenance activities

Manage offshore on shore technical resources and work with Business team on deliverables.

Building and managing data warehousing using Informatica 10.4

Provided technical documentation and perform code reviews.

Provide deep technical guidance based on strong technical acumen and technical currency in a variety of technologies. Informatica, Java, .Net, Windows,, Web, SQL, Azure, Virtualization, API, Microservices, JSON, load balancers, firewalls, networking (DMZ, DNS), integration, AD, ISAM etc

Developed and built at least one rich-client-based (i.e. client-server) application using Windows Forms or WPF on .NET 4.5 or later which fully utilized the MVVM design pattern and used Prism/Composite Guidance from Microsoft patterns & practices

Identify and implement methods/algorithms for optimizing business processes and improving IS application efficiency. Provide guidance to the technical team responsible for the development, unit/integration testing and implementation of simple to complex business solutions

Conduct daily code, design and process reviews, including code sampling design reviews, code profiling, unit test reviews and process adherence for source code control and builds

Design and develop frameworks, database schemas and back-end systems to support full-featured and styled web applications, considering both business and technical considerations

DST Systems, Boston, MA Nov 2010 – June 2016

Technical Lead

Role & Responsibilities:

Technical lead for planning and architecture of a Microsoft .NET TRAC Smartdesk system.

Responsible for providing functional, technical and architectural design

Responsible for development of Custom Controls that are used across multiple modules, including analysis, designing and coding and also preparing unit and system conditions and deliver Quality Components/Projects and Maintenance of the Modules.

Developing SOA module which includes development of Web Services and also integration of UI with Infrastructure code.

Mentor coordinate with offshore project team and responsible for delivery and integration of modules.

Prepare and update documentation for all the requirements, enhancements and constraints including change control for the requirements with proper review mechanisms.

Provide project estimates to the Project Leader.

Work with the Business Analyst to understand the enhancements and also attend meeting with clients.

Prepare technical specifications/design documents and publish them for review. Consolidate comments offered by peers.

Perform installations, upgrades and enhancements in the staging, mock, and production application environments.

Developed PL/SQL functionalities including Packages, Stored Procedures, Triggers and DML’s

Project Experience - The TRAC recordkeeping platform is designed specifically for the economic and servicing requirements of the retirement marketplace. DST Systems draws on extensive industry experience and client collaboration to deliver innovative solutions that align with the unique demands of your retirement business. As a real-time, rules based system, TRAC provides a single, integrated solution for multiple types and sizes of retirement plans.

Technology – C#, VB.NET, Oracle 10g, DB2, MVC 3.0, WCF

State Street, Boston, MA. July 2008 – Oct 2010

Consultant - Software Engineer (Contract position)

Project Experience - Fund of Funds (TDGL). A "fund of funds" (FoF) is an investment fund that uses an investment strategy of holding a portfolio of other investment funds rather than investing directly in shares, bonds or other securities. This type of investing is often referred to as multi-manager investment.

Technology – C#, VB.NET, PowerBuilder 9.0 ADO.NET, Oracle 10g

Role & Responsibilities:

Project lead for planning and architecture of a Microsoft .NET FOF system that was integrated into third party channel system (web services)

Responsible for providing functional, technical and architectural design

Responsible for development of Custom Controls that are used across multiple modules, including analysis, designing and coding and also preparing unit and system conditions and deliver Quality Components/Projects and Maintenance of the Modules.

Established departmental standards and processes for workflow and asset management

Coordinate with offshore project team and communicate status to onsite/offshore teams.

Prepare and update documentation for all the requirements, enhancements and constraints including change control for the requirements with proper review mechanisms.

Provide technical leadership and design for proposals to the development team on the projects.

Prepare technical specifications/design documents and publish them for review. Consolidate comments offered by peers.

Perform installations, upgrades and enhancements in the staging, mock, and production application environments.

Developed PL/SQL functionalities including Packages, Stored Procedures, Triggers and DML’s

Massachusetts Financial Services, Boston, MA. August 2007 – May 2008

Consultant - Software Engineer

Project Experience - Fixed Income Trading System (FITS); the Fixed Income Trading System (FITS) supports the work of the MFS fixed-income trading desks. FITS users can: view real time bids/offers in the Offerings blotter; create orders to buy and sell short term and long term fixed income securities, equity securities, and currencies using built in allocation methods to ensure fair allocation, with front end compliance checks. Allocations include Sell Percent, Target Percent After, Target Percent Increment, Target Percent Issuer and Percent of Assets Managed. Automatically generate FX orders to fill the day's FX needs for both Fixed Income and Equity trades and, optionally, simultaneously hedges a percentage.

Technology – PowerBuilder 11.0, C#, IIS 6.0, VB.NET, ASP.NET, ADO.NET, Visual Studio .NET, XML, XSL, Sybase 12.5 Windows Server 2003

Role & Responsibilities:

Responsible for providing technical and function design and development support for the Fixed Income Trading System (FITS) and for providing functional, technical and architectural design and support for the User Defined Reports project.

Led analysis of Business requirements and converted them into technical design/component model design.

Conducted sessions with business analysts to analyze and verify interface requirements.

Enabled business analysts to make decisions by giving them feedback on technical feasibility and application restrictions for the interfaces.

As a Consultant, I was responsible for most technical milestones of the project including development deadlines, integration testing and release to production.

Prepared technical specifications/design documents and publish them for review. Consolidate comments offered by peers.

Established departmental standards and processes for workflow and asset management

Cross Country Automotive Services, Medford MA April 2001 – July 2007

Software Engineer

Role & Responsibilities:

As a Technical Lead / Senior Software Engineer at Cross Country Automotive Service, I was involved in analysis, design, coding, unit testing and working with off-shore resource teams, post-production support and technical documentation. Developed stored Procedures, triggers, functions and worked on creating and modifying database structures including Data Definition Language and Data Manipulation Languages (DDL & DML’s)

PROJECTS:

DMS Billing Application:

The DMS Billing application is used for obtaining credit card authorizations and settling accounts on a daily basis. This application is used to generate the daily billing and cancellation file and send it to the third party vendor Payment tech to get the authorizations and settlements. The application performs updates to the database on receipt of the return billing and credit files from the vendor.

Technology used: NET 2.0, C#, ADO.NET, Visual Studio .NET, Oracle 10g

Role & Responsibilities:

Led analysis of Business requirements and converted them into technical design/component model design.

Led the Development Team and was involved in coding and mentoring the team.

Interacted with the vendor to get the specifications and certification for the billing application.

Developed Reports providing daily status on enrollments. Renewals and cancellations to the Finance team.

Cadillac Tech Website. Responsible for Design, Development, Bug Fixing, Testing and End-user Training.

Technology - ASP.NET, Oracle 10g

The Cadillac tech Website is a web application used to maintain Service Provider information which includes their company profile information, working hours and the ability to turn their pagers on and off. The website also provides reporting section which is used to generate reports about how many calls the Service providers handled in a month. This enables to calculate the incentives which need to be provided to the Service Providers.

SA Chrysler Data Load. Responsible for Design, Development, Bug Fixing, Testing, End-user Training

Technology - C#, Oracle 8

The SA Chrysler Data Load Windows file watcher application automates the Service Advantage Chrysler Data Load Process so that it gets loaded to the Service Advantage database on a daily basis and sends an email to the Account Manager about the statistics of the records loaded and failure status report. The Load Process will be deployed to the Scheduler so that the file gets picked up automatically and processed.

Pager Monitoring Service. Responsible for Design, Development, Bug Fixing, Testing, End-user Training

Technology - VB.NET, Oracle 10g

The Pager Monitoring Service is used to turn off and turn on the Pagers of Cadillac Technicians. Cadillac Technicians can turn off the Pagers during a particular time Period. The Pager Monitoring Service will monitor the database and turn on the Pager on the Scheduled end date. This service is written using VB.NET

Access International. Cambridge, MA October 1999 – January 2001

Programmer Analyst

Access International has catered to the unique needs of larger more complex not–for-profit organizations across North America. As Programmer Analyst I was part of the team which was involved in the creation of a Web based application “Enterprise 7.0” which allowed clients to use either two-tier, multi-tier or the Web applications to manage and track information about their fund raising activities and allows them to extend their market to smaller non-profit organizations. Was involved in the development of Code Tables, various modules in Account Management like Notes, Mail Flags, Extended-Bio, Roles and modules in Selection Management.

Technology - Powerbuilder 6.5 7.0, SQL Server 7.0, EAStudio 3.5

Involved in detailed Design, Development, Bug-fixing and Testing.

Used Powerbuilder 7.0, EAStudio 3.5 and Microsoft SQL server as the database.

Used Object Oriented features of Powerbuilder like Inheritance, Polymorphism and User Objects.

Developing Stored Procedures, Triggers, functions and working on creating and modifying Database structures including Data Definition Language and Data Manipulation Languages(DDL & DML’s)

Syntel, Inc. Troy, MI April 1999 – September 1999

Programmer Analyst

As a Programmer Analyst I was part of the part of the team involved in the development of the application ERIS for West Virginia Department of Environmental Protection, Charleston, West Virginia. This application has been used in the computerization of various offices in West Virginia like Office of Mining and Reclamation, Office of Environmental Reclamation and Office of Water Resource. Involved in the development of the application for Fees and Invoice Collection consisting Internal Feed Data Collection, Internal Feed Maintenance and Invoice Billing.

Technology - PowerBuilder 6.5, Oracle 7.3, Windows'98 and Novell Netware

Involved in detailed Design, Development and Testing.

Used PowerBuilder 6.5 as the main coding language and Oracle 7.3 as the database.

Used the Object-Oriented features of PowerBuilder like Inheritance and also User Objects.

Developed Stored Procedures, Triggers, functions and worked on creating and modifying Database structures including Data Definition Language and Data Manipulation Languages (DDL & DML’s)

Education

B.S. Physics from University of Madras, India

Advanced Diploma in Systems Management, N.I.I.T, India

Diploma in Relational Database Management System from Software Solutions Integrated, India

Post Graduate Diploma in Marketing Management from Loyola Institute of Business Administration

Contact this candidate