Manager Developer Sql Server Oracle .Net Engineer
Resume:
Chaaya Nayak
*************@*****.***
SUMMARY
Technology Professional with Eight years of experience in various roles such as Software Engineer, Web Developer, Database Developer, Data Analyst and Client Relationship Coordinator within Financial,
Educational, ERP and Supply Chain vertical markets.
SKILLSET SUMMARY
• MCP: Microsoft Certified .Net Professional using ASP.Net and C#
• OCA: Oracle 9i Certified Associate
• Sitecore 6.0 Certified Developer
• Solid experience with ASP.Net, C#, Python, AJAX, Silverlight, XML, Multithreading, ODP.Net and PowerBuilder
• Experienced using Visual Studio 2005, 2008, 2010 , Quartz.
• Proficient with Oracle 10g/ 9i, SQL Server 2005/2000, MS Access, and Excel
• Experience in PL/SQL Developer, SQL Server Management Studio, SQL Server Enterprise Manager, Toad, and Golden View
• Involved in Design, development, support, master code lookup data setup, historical data load and validation during initial deployment / Go-live process
• Data Analysis on a daily basis with extensive client interaction
• Involved in End-user Training of ERP Products
TECHNICAL SKILLS
Languages/GUI: C#, ASP.Net,Python, AJAX, VB.Net, ADO.Net, Web Services, VB 6.0, VBScript,
JavaScript, CSS, XML, XSLT
Windows/Web Development: Web Forms, Windows Forms, ASP.Net, C#, VB.Net, Silverlight, Web Services, Visual Studio, 2010, 2008, 2005, Quartz, Crystal Management Console, File Store
Operating Systems: Windows XP/2000/2005/NT
Databases: Oracle 10g/ 9.0, Microsoft SQL Server 7/2000/2005
Software: MS Team Foundation Server, Visual Source Safe, MS VISIO 2000, Visual
Interdev 6.0, MS FrontPage, Crystal Reports, MS Word, MS Excel
Technologies: ODP.Net, COM, COM+, ODBC
Report Development Tools: Crystal Reports 10
PROFESSIONAL EXPERIENCE
Merrill Lynch / Bank Of America, Jersey City, NJ Oct 2010 – Present
Application Developer
Worked on workflow tools for Market Risk Technology Group. Products worked / supported are “New Product Review (NPR)”, “Model Workflow Tool (MWT)” and “Approved Product List (APL)”.
NPR is a front to back office work flow tool which manages trading products through various phases like Pre review, Evaluation, Review, Approval and Launch. In addition to online review and approval. It is a high visibility tool used by office of the COO, Risk managers and various Business units like Global Commodities, Rates and Currency etc. It provides improved pre and post launch follow up by automated notifications and escalation.
MWT is Model workflow Tool which manages Model Change process and provides enhanced model governance controls and data capture. MWT enables Model life cycle transparency and enhanced communication. It establishes clear ownership by providing online review and approval by each groups (Risk Manager, Model Validator, Middle Office, Finance, Technology etc) involved. It has controls to provide proper prioritization around models in the queue and provides dynamic search and reporting capabilities.
APL is a repository of Approved products including Legacy Merrill Products which were all maintained in SharePoint in excels. There is functionality to add and Edit a product / view the history of transaction / Upload bulk products / with bulk upload functionality to find the cell by cell difference between two excel files.
Responsibility:
• Rewriting MWT workflow tool in Quartz using Python. Working on developing UI pages in Quartz. Writing a Sqldb class to access SQL server from Quartz.
• Attended Quartz training by Chris Laffra.
• Optimizing the Team Page – Page was taking long to run and was timing out sometimes. Optimized the code to Load the page in fraction of seconds.
• Using open XML reading excels for different Line of business, and loading data into corresponding tables. Also saving excels in varbinary column of sql server table to keep a history.
• Using Open XML exporting data table to excel sheet.
• Writing UI to show the difference between two excels.
• Writing UI for Add / Edit products.
• Writing Notifications – writing notification that sends notification to identified groups / users on each stage the model moves.
• Add / Removing a step in the model life cycle, and making sure different type of models flows as expected with proper notification.
• Writing a console application to integrate data from APL and NPR.
• Working on BAU items – These are regular support / enhancements to the tool that business identifies.
• Production Support – Because of Front office high visibility, the quick solution / fix for any production clarifications/ issues.
• Coordinating with the offshore team for development and integration.
• Coordinating with the system administrators and DBA’s for the releases.
• TFS code merge to DEV / QA / UAT / Production and backing up the production code for reference / rollback.
Environment: Visual Studio 2010 / 2008 / 2005, SQL server 2005, Infragistics controls, Open XML, Enterprise library, Team Foundation Server (TFS), Code Smith.
Release Tools: Maximo, Application inventory tool (AIT), TFS release.
Peterson’s, a Nelnet Company, Lawrenceville, NJ Feb 2008 – Sept 2010
Software Engineer
Peterson’s is an education content providing company with generating leads to colleges. They have various cobranded, CMS driven web properties. (e.g. www.petersons.com www.studentedge.com www.resumeedge.com, www.essayedge.com ). Petersons.com provides content related to Undergraduate, Graduate, and Distance Learning markets. Studentedge.com is designed to assist High School students get ready for their SAT, PSAT exams, request college information, and to provide leads for colleges. Applications are developed using C#, ASP.Net, Visual Studio 2005/ 2008, AJAX, AJAX Control Toolkit, XML, Multi threading, Sitecore, Oracle 9i/10g, and PL/SQL.
Responsibilities for the www.petersons.com Project:
• Developing a control panel for the client account managers to add Cost per Click (CPC) / Cost per View (CPV) links for the clients either at program level for graduate market or at institution level for both undergraduate and graduate market.
• Search for and view details of all undergraduate profiles available on Petersons.com
• Create new CPV orders with custom search description text and custom client paragraphs that will appear on an “Overview” tab in the profile
• Add new organizations to the site and create profiles for the organization or for the programs
• Add budget for the organization and share the budgets if the client has shared budget scenario.
• Create Grad Hierarchy.
• Developing a administrative tool for creating users, assigning them roles
• Interface for Excluding Crawler IP’s from billing clients.
• Interface for Excluding the domain addresses and keywords (which are not appropriate for students)
• Creating code for the affiliate campaigns.
• Reporting client’s usage on Cost per clicks and cost per views and usage.
• Converting ASP pages to asp.Net pages
• Placing the 301 redirects.
Responsibilities for the www.studentedge.com Project:
• Generating Co-Branded web pages.
• Developed Web Service for getting CMS content.
• Created controls for different parts of the page.
• Control panel side: Allow Client Account Managers a place to put orders for competitive and non-competitive (formerly known as Regional) replacement products.
• Allow Client Account Managers the ability to add subscriptions, edit, renew, and delete subscriptions.
• Allow account managers to create delete rules with the ability to track any changes made to the order
• Send email to student networks inbox when the leads delivered is the 75% of the ordered leads.(This happens in a nightly job)
• Student side: collect student information like birth date, ethnicity, interest, GPA, state, country and present a list of schools which match the criteria of the school.
• Student will then select the schools they are interested in and when they submit, it will be saved as a lead to the school.
• Wrote a console multi threaded application to generate the reports depending on if the report is Excel / ASCII Fixed / ASCII Comma delimited.
• Developed a console application to read the messages from message queue and send to the email addresses specified in the send leads to column of the creating subscription.
Environment: ASP.Net, C#, ADO.Net, Silverlight, Grid View Control, AJAX control toolkit, Web service, CSS, Java script, web forms, ODP.Net, ODBC Drivers, Oracle 10g, IIS, Excel interop assembly, Console applications, Microsoft Messaging Queue and Opalis.
Merrill Lynch, Hopewell, NJ Feb 2007 – Dec 2007
Programmer Analyst
Worked on the Executive Stock Option e-Reporting application which facilitates timely execution of client reports in monthly, quarterly and annual schedules. It offers a wide range of e-Reporting options such as the standard and adhoc reporting to suit the specific client needs. ExSOP eReporting was designed as a customized web eReporting tool using ASPs, CSPs and ASP.Net.
Responsibilities:
• Analyze user requirements and design the application.
• Extensive work with Crystal Enterprise, Business Objects and .Net.
• Developed a .Net utility to clear the file store of historical files (Empty Folders and Files which are n number of days or older).
• Enhanced the webpage for running and scheduling the reports. (Report parameters, formats, database, scheduling info…)
• Extensively used Business Objects Info store.
• The Out-Of-Box features of Crystal Enterprise had been modified to fit into the eReporting application.
• Used PVCS for Version control.
• Extensive Data Analysis and Testing of the reports using CR10/ Toad.
• Made enhancements to existing reports using Crystal Reports 10.0.
• Used Data Direct 4.2 for ODBC connection to Oracle database.
• Administration of Crystal Enterprise Server.
Environment: ASP.Net, C#, ADO.Net, Crystal reports 10, Oracle 9i, Crystal Enterprise 10, Crystal Query Builder, Crystal Management Console, HTML, PVCS, Data Direct ODBC drivers.
Diaspark, Inc., New York, NY Jun 2003 – Jan 2007
Programmer
Diaspark Jewel is a user-friendly Windows based ERP application that provides a complete enterprise management solution for a jeweler using Accounting, Manufacturing and Customer Support. For accounting functions, the application includes General Ledger, Accounts Payable, Account Receivable, Cash Manager, Sales Order and Invoicing, Purchase Order and Invoicing, Sales Person, Contact Manager, System Manager, and EDI Interface. Manufacturing process is supported by the following modules: Style Setup, Contractor, Gold/Casting, Diamond/Stone Inventory, Style/Casting Inventory, Production, Return & Repair, and Imaging & Catalog. The application is flexible and gives the freedom to setup transactions, forms and reports as per business process needs.
Involved in the following activities for multiple client installations:
• Understand the current object model of the knowledge base and made enhancements to it.
• Coded and designed the User interface in ASP.Net and C# for sales person module as a part of PowerBuilder to .Net conversion.
• Wrote SQL queries, stored procedures, and triggers to access database.
• Interacted with the EDI Options to get the files and uploading and testing the files in Diaspark system and sending the invoices through EDI.
• Coordinated with the client deployment of the application.
• Installed the ERP application at client side along with installation of SQL server 2000/2005 (both server and client installation).
• Customized application in PowerBuilder to meet client requirements.
• Customized reports in PowerBuilder to meet client requirements.
• Attended the daily queries as a part of client support, analyzing the queries and giving a solution.
• Trained end-users at client site to use the application.
Environment: C#, ASP.Net, Power Builder 6.5, 7.0,8.03, VB 6.0, MS Access, SQL Server 2005/2000
National Savings Bank, UK Oct 1998 – Jun 2000
Programmer
As a member of a 3-person team worked on the Check Book Printing (7250enar) project that involved upgrading application from a file system to the Oracle database, from VB 4.0(16 bit) to VB 4.0 (32 bit) and from Windows 95 to Windows NT OS.
• Wrote SQL code for transferring data from files to the Oracle database
• Tested transferred data
• Performed system test after all upgrades
Environment: Visual Basic 4.0, C, Oracle and Windows 95/NT
EDUCATION / TRAINING
Manipal Institute of Technology, Manipal, India 1998
Bachelor of Engineering (Equivalent to BS Education in US)
Boston Computer Institute, India 1999
Advanced Computer Diploma
Software Research Group, Edison, NJ 2006
Oracle 9i Training
• OCA: Oracle 9i Certified Associate 2006
• MCP: Developing and implementing web application using ASP.Net and C# 2006
• Sitecore 6.0 Certified Developer 2010
WORK AUTHORIZATION
• United States Citizen
REFERENCES
Available upon Request
Contact this candidate