Sql Server Software Developer

Professional SUNITA ELLINTI

:847-***-**** (Res)

847-***-****(Cell)

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

Professional Summary:

Enthusiastic, innovative and Versatile IT professional with over 16 years of experience in Leading, Architecting, Designing the Software applications following Software Development life cycle (SDLC).

Extensive work knowledge in Health care, Financial, Investment management and trading industry.

Experienced in managing, developing and supporting n-tiered architecture Windows and Web applications using.NET Framework. Extensively worked on Multi-Threaded windows Services, Web-services.

Extensively worked on communication and transport mechanisms like FTP, SFTP, NDM, MSMQ 3.0 and Web sphere MQ6.0. Extensively worked on FIX protocol.

Experience in analyzing and gathering Business / Technical Requirements, develop technical design document, create sequence diagrams, process diagrams, data flow diagrams, Use Cases documents.

Effectively and efficiently manage global teams.

Excellent analytical and problem-solving skills with excellent presentation and communication abilities.

Capable to understand and work in complex applications. Ability to work independently in time sensitive environment.

Work independently as a self-starter, and a Good Team Player.

Technical Experience:

Frameworks .Net Framework 1.1 to 4.5, VS 2003 to 2017

Languages: C#, VB.NET, ASP.NET, ASP.Net MVC, WPF, Java, Visual Basic, HTML, ASP, PowerBuilder, AS/400.

Middleware: WCF, Web Service, WebAPI

Messaging Service: Microsoft MSMQ 3.0 and Web Sphere MQ 6.0

Databases: MS-SQL Server 2008 R2, Oracle, PL/SQL, SQL Plus, MS Access

SCM Tools: Test Director, Rational ClearQuest, Rational ClearCase, Microsoft Visual SourceSafe, CVS, Subversion, Microsoft TFS

Quality Process: Agile, Waterfall

Trading Application: Charles River development (OMS)

Education:

M. Tech. in Electronic Engineering, Nagpur University, India.

B. Tech. in Electronic Engineering, Nagpur University, India.

Professional Experience:

INVESCO(PowerShares ETF) AUG 2015 – Current

Application Team Lead

Manage a team of developers globally to support the ETF applications. Provide support to all stakeholders including ETF operations specialists and Portfolio Managers, trading strategy and analytics, compliance brokers, back office.

Responsibilities:

Support Invesco PowerShares Capital Management (the “Adviser”) and PowerShares Funds. Support ETF structures and operations for equity and fixed income securities, commodities, and derivatives and support new product launch. Experience with Bloomberg.

Responsible to design and development, enhance home grown ETF applications. Support Charles River Development OMS system and trading operation. Support ETFs, currency hedging, equities, fixed income securities, trading strategies, portfolio modeling, trading and index-based management.

Interact with Portfolio Management, Trading, Investment Operations, Legal, Marketing/Sales and Product Development. Organized meetings with Key Stakeholder and End Users to discuss project goals, timelines and prioritize deficient enhancements to increase the stability of the applications.

Support Options, Futures, FX and Swaps trading, algorithm development, FIX connectivity, workbenches, Trade blotter, Post and pre-trade setups in Charles River application.

Manage the file transmissions via FTP, SFTP, NDM, and MQ to and from the external parties.

Ensure trading platforms are production ready at all times, and track the progress of issue resolution. Analyze business as usual issues, quickly evaluate information, engage and assist technology staff, and communicate issues to help remediate and resolve production issues efficiently and effectively, looking for trends and patterns to identify recurring problems to enable root cause analysis.

Lead and manage global teams and provide technical support. Coordinate the needs of the global teams into a single priority queue ensuring the proper business value.

Environment: Visual studio 2017, C#, WebAPI, IIS, Entity Framework, SQL Server 2012, Oracle, MQ WebSphere, NDM, SFTP, Charles River Development OMS, FIX, Portware, ServiceNow.

Motorola Solutions Inc June 2010 – AUG 2015

Software Manager

Architect and Design, WCF Service Design and Database Design to Develop applications for Motorola Customers to manage radios and retrieve, modify and deliver configurations from and to radios over the air and wire.

Responsibilities:

Architected, designed and developed a Windows application using the latest .net technologies WPF with Prism and MVVM design pattern, WCF, Entity Framework and SQL Server 2012.

Architected, designed and developed a Web application using ASP.net MVC4, WCF, Entity Framework and Oracle.

Prototype the UI using Blend to get customer feedback.

Adopted agile methodologies in the development cycle. Expert in driving the scrum calls and drive the Iteration Planning.

Review Requirements and Create Product Backlogs for Sprint planning. Provide Work Estimation and break down tasks for development team.

Monitor, measure, and report on project progress to management.

GUI design using the high performance data grids like Infragistic and DevX controls and all the WPF controls

Design, Develop the Presentation tear using WPF and Data Service layer using WCF

Involved in Performance tuning of the database to accomplish the performance goal of the product.

Involved in tracking and measuring project resource against goals, timelines, and budget.

Managed offshore & onsite SDLC and software Support teams

Environment:

Visual studio 2013 and TFS,C#, WPF with MVVM and Prism Design Pattern, WCF, Entity Framework, XML/XSL, SQL Server 2012, Nunit, Microsoft Expression Blend, ASP.Net MVC4 and Oracle

SUNGARD Transaction Network April 2008 – June 2010

Sr.Software Developer

The Sungard Transaction Network (STN) is a connected community of financial service institutions, comprising SunGard customers and other market participants. STN supports the key information flows in the trading lifecycle, including order routing, execution, allocations, affirmation and matching, notification, reconciliation and reporting for equities, fixed income securities, mutual funds, money market funds, commercial paper and certificates of deposits.

STN Securities automates communications between institutions with brokers, creating operational efficiencies for capital market participants. STN Securities streamlines the full trade lifecycle from order and execution through the post trade process, for equity and fixed income securities.

Responsibilities:

Design the Architecture of the .Net web applications, Windows applications, Windows services, and Web services containing the isolated Business, Data Access, and Presentation Layer.

Work on the VB 6.0 applications and deploy legacy applications in MTS as COM+ applications and proxy components.

Work on the developing and upgrading the web applications developed in ASP and ASP.Net.

Create the performance reports of the applications running in production as and when required by querying the Database and putting it in a graphical representation in excel

Creating windows services to create the different formats of the file as required by the Banks and Brokers in the financial industry. And created the windows service to FTP the file to the clients.

Upgrade a highly sophisticated .Net Windows service called Router which handles the FIX and FIXML formats of the messages from banks and brokers of the financial industry to communicate to each other for allocations trade orders and every kind of Stock purchases and sells.

Work on all the applications to resolve the Productions issue.

Environment:

Windows XP, Windows 2000, Windows 2003,Visual studio 2008, C#, ASP.Net, .Net Multi Threading, MTS COM+ application, VB 6.0, ASP, SQL Server 2005, Microsoft Messaging Service (MSMQ) 3.0, Web sphere MQ Series 6.0 client, Java 1.6, JSF, Unix, Oracle 10i, IPP tool, FIX

CEC Online Education Group July 2005 – March 2008

Sr.Software Developer

Learning Management System (LMS)

The Online Education Group developed the web-based virtual campuses like American InterContinental University Online and Colorado Technical University Online and Stonecliff. The online campuses of these three universities collectively offer a variety of degrees in information technology, computer science, business, visual communication, health sciences, criminal justice, and education.

The LMS automates the administration, tracking, and reporting of classroom, common ground course and online training events, enabling detailed analysis of the effectiveness of our training investment.

Responsibilities:

Design the Architecture of the .Net web application containing the Business, Data Access, and Presentation Layer in enterprise architect tool.

Crated the database and the stored procedures in SQL server DB.

The LMS environment implemented the SCORM 2004 1.3.3 standard.The SCORM APIs are a set of communication devices for the courses to interact with the system. They are used to initialize the communication between the courses and the LMS and to track the data that the course may create.

Created managerial and individual user reports using Reporting Services

Created the DTS package to import the user information from the internal People soft database maintaining the employee’s information.

Environment:

Windows XP,Visual studio 2005, VB.Net, C#, ASP.Net, Multimedia Flash, Macromedia Breeze, JavaScript, SQL Server 2000, Nunit, Data Transformation Services of SQL Server

American Imaging Management (https://www.imasis.com) September 2004 – May 2005

Sr.Software .Net Developer

Health Care Call Center Web Application

American Imaging Management, Inc. (AIM, Inc.) is the nation's leading provider of diagnostic imaging management services. AIM, Inc. partners with health care clients to manage the diagnostic imaging services provided to their members.

Imasis applications is a highly scalable and customizable web call center application that can be used by a variety of health care clients to preauthorize the diagnostic imaging services use this application.

Responsibilities:

Gather Requirements and Design the Architecture of the .Net web application containing the Business, Data Access, and Presentation Layer.

Implementing the Cascading Style sheet for the design or external appearance of the application.

Implementing the requirement using VB.net and follow TDD using Nuint framework, design UI to accomplish intuitive UX.

Testing the application to work in accordance with the internal windows and the web applications.

Implementing the Sybase stored procedure in SQL Server as the database was going to be replaced with SQL Server.

Used and extended the Microsoft Application Block Exception to publish the exceptions into the log files in text, XML format and configured the web.config file to email the exception occurred

Reporting Preauthorization summary in multiple file foramts.

Environment:

Windows 2000, VB.Net, C#, ASP.Net, JavaScript, ODBC connections, Sybase, Nunit, SQL Server 7.0, Microsoft Exception Blocks, Crystal Reports, Visio

Contact this candidate