Sql Server Management
Resume:
Malathi Bandlamudi
*******.**********@*****.***
Objective
Experienced .Net, SharePoint developer seeking opportunity as a .Net/SharePoint Developer, Specializing in Business Analytics, Architecture, Team Leadership, Development, and Administration roles.
Summary
• Overall 10+ years of experience in the IT industry.
• 7+ years as a professional web/application developer (C#/ASP.NET).
• 7 years overall experience in the Gaming and Service industry, specializing in Client services and business systems architecture.
• Over 3 years experience with SharePoint as a subject matter expert with advanced knowledge in design and architecture, implementation, development and training.
• Complete application development life-cycle experience including requirements gathering, analysis and design, programming, testing and solution deployment.
• Excellent communication, project management, documentation and organizational skills.
Technical Proficiency .Net/SharePoint
• .Net Framework 4.0/3.5/3.0/2.0, ASP.NET, C#.NET, Web Services.
• SharePoint 2010, Windows SharePoint Services 3.0 (WSS 3.0), SharePoint Portal Server 2003.
• Installation, Configuration, Content Management, Content Migration, Site Design and Architecture, Site template customization, Site definition customization, Custom web part development, and Reporting Services report design, InfoPath forms design, Master Pages, Content types, Features, Excel Services, and workflows.
Programming
• ASP.NET, C#.NET, Web Services, PowerShell, Team Foundation Server (TFS).
• SQL Server 2008/2005/2000, SQL Server Reporting Services (SSRS).
• Agile and SCRUM programming methodologies.
• Visual Studio 2010, .NET Framework 3.5, VB.Net, ASP.Net, C#, WCF,WPF, MVC 3, JQuery, CSS, PL/SQL, ORACLE 10g, XML, XSLT, Team Foundation Server. Active Reports 6.0, DevExpress controls, Atalasoft controls for document, Infragistics controls.
Internet Development
• HTML, DHTML, CSS, XML, ASP.NET, JavaScript, jQuery, PHP, Silverlight, Graphic Design, Web Presentation.
• Microsoft IIS 7/6.
Platforms
• Windows Server 2008/2003/2000/NT, Windows 7/Vista/XP, Linux, Virtualization (VMWare).
EMPLOYMENT EXPERIENCE
Lead Analyst February 2011 – Present
Integration of Ontario Lottery and Gaming Commission (OLG), Canada with Bally systems
Ontario Lottery and Gaming Corporation (OLG) is an Operational Enterprise Agency created by the Government of Ontario. OLG and its affiliated companies employ more than 18,000 people throughout the province. They are responsible for 24 gaming sites and sales of lottery products at approximately 10,000 retail locations across the Province of Ontario.
Integration of Ontario Lottery and Gaming Commission (OLG), Canada with Bally systems involves implementation, installation and support the validation of unit integration test results of a GMS Integration Proof of Concept (POC) for integration between the Bally GMS, specifically the Casino MarketPlace (CMP), and OLG applications.
This POC will provide an integration flow updating the OLG Player Information Repository (PIR) application with Patron Enrollment data entered in Bally Casino MarketPlace (CMP).
The implementation will be consistent with the architecture and design proposed for the integration of Bally and OLG applications.
Responsibilities
• Client system analysis and requirement gathering.
• Participate in brain storming session and follow-up meetings with the Customer.
• Hire a team of experienced resources for development activities.
• Oversee POC development activities.
• Complete the project within estimated timeframe.
• Create the Demo for the final presentation to the Customer.
• Present the Product demo to the Customer.
• Lead the Integration project.
Points of Interest
• Represented Bally Technologies as lead engineer.
• Participated in requirements gathering workshops.
• Analyzed their current system to integrate with Bally systems.
• Showcased Bally products.
• Led the team in creating Proof of concept (POC) with solutions to the Customer needs.
• Presented the Product demo to the Customer.
• POC and Product demo helped in approval of project by the Customer and the contract has been signed to initiate the integration project.
Lead Analyst
Bally SharePoint central technical documentation repository February 2010 – January 2011
Bally SharePoint central repository maintains different user groups confidential documents with restricted access as well as public share for all authorized domain users.
Responsibilities
• Bally’s SharePoint site collection and development of custom SharePoint solutions (WSP’s).
• Empower site administrators by providing training labs and presentations.
• Design and develop SharePoint solutions that meet the needs of the center’s offices, divisions, and branches.
• Gather requirements and provide in depth documentation for best case solutions necessary for development.
• Design and develop solutions (WSP’s) involving SharePoint web parts, site and list templates, applications, and workflows, utilizing the SharePoint object model, client model, and/or SharePoint web services.
Points of Interest
• Senior SharePoint developer for Bally Technologies.
• Developed custom web services solutions to lists, libraries, and security to the new tightly controlled collection for Bally SharePoint sites.
• SharePoint enterprise development to improve the integrity of end user data collection.
• Redevelop existing web parts to adhere to Microsoft's recommendations for SharePoint development procedures and best coding practices.
Senior .Net Developer March 2009 – January 2010
ECFMG – Educational Commission for Foreign Medical Graduates
Electronic Portfolio for International Credentials is a web portal for physicians over the world to create an online profile for requesting services provided by ECFMG like credential verification, credential reports and repository to keep the verified credentials.
Administrative Processing for EPIC is a WPF application where managers and users process service requests like verify credential documents, send reports to recipients and portal accounts creation requested by physicians.
Recipient Portal is web portal developed in ASP.Net for medical institutions participating with ECFMG allowing creating user account where they can login on daily basis and verify credential verifications from physicians all over the world through EPIC portal. They can also request to see notifications from ECFMG on new EPIC account established.
Document Imaging, Scanning and Capture is an internal WPF application where managers and ECFMG mailroom user use on a daily basis for capturing credential document, correspondence document images through scanning and index the documents to attach to EPIC physician accounts. Atalasoft is used to present annotations to redact images; mark or stamp document images annotations are burned on document image before saving to database.
Responsibilities
• Involved in all phases of the application development from business requirement analysis, design, development, testing, bug fixing and management of the applications.
• Participate in regular team meetings, discussions on change requests with business team, setting up milestones, organize and prioritize pending tasks, perform impact analysis and feasibility checks
• Designed and developed web pages using ASP.Net 3.5, C# and .Net framework 2.0/3.5
• Used LINQ for querying the various sources of data.
• Involved in database design in ORACLE 10g.
• Extensively worked on the PL/SQL, Stored procedures & Functions.
• Fetch data from different databases and displaying data in SharePoint portal task list
Points of Interest
• Senior .Net developer.
• Developed WCF Services for business layer and ASP.NET Interfaces for web sites in C#.
Lead Analyst September 2008 – February 2009
Casino Management system(CMS) Production Implementation and Data Migration
• Traveled all over United States and overseas as a software engineer sponsored by Bally Technologies, utilizing my IT and technical experience to implement Casino Management System in Windows 2008/XP/Win7 mixed platform systems and high volume complex data migrations and application installation.
Responsibilities
• Server staging details verification and Virtual machine (VM) hardware resource allocation and management.
• SQL Server installation and Fail over configuration.
• 3rd party Customer database schema analysis and migration data scope requirements gather.
• Data migration scope documentation sign off from Customer.
• Hire a team of experienced resources for migration activities.
• Oversee development activities and involve Customer in periodic testing phases.
• Final sign off from Customer after the completion of data validation and acceptance testing, to proceed with Go-Live.
• Successful completion of CMS implementation and data migration.
Senior Software Analyst
Bally Promotional Kiosk January 2008 – August 2008
The Promotional Kiosk application allows a player to play promotional games in the casino and it also increases the casino’s Customer base and builds Customer loyalty. This application can be accessed by the players using the freestanding touch-screen kiosks.
Responsibilities
• Involved in Design, Development and Maintenance of the application.
• Designed and implemented rich user interface using WPF.
• Developed reusable code components and services.
• Involved in developing Complex stored procedures in SQL Server.
• Involved in testing and deployment of the application.
Points of Interest
• Proposed innovative ideas related to kiosk monitoring admin tool and kiosk health check service, which has contributed to evolve it as a product.
• Kiosk Admin UI is used to configure different attractive screen savers/Header or footer images, Printers to each kiosk with scheduled date and time to be effective and also card/slip printers from a centralized system.
• Kiosk Health Check service will monitor heartbeat of each kiosk and report to IT admin if any kiosk is down for some reason. It will also monitor the printers attached to kiosk and will notify events like paper Jam/Paper Low/Offline etc. status.
Senior Software Analyst
January 2007 – December 2007
Patron Distributed Architecture
Patron Distributed Architecture is implemented using 3-Tier architecture. All the patron related changes does in one casino will be distributed to another casino (sister property) on a multi-site casino environment.
Responsibilities
• Responsible for collection and analysis of requirements.
• Developed Business and Data tier using C#.NET and ADO.NET.
• Designed & developed database tables in SQL Server.
• Created database tables and Stored Procedures using SQL Server.
Software Analyst November 2005 – December 2006
Patron Web Portal
The Patron Web Portal is a web application. User is authenticated at multiple places however authentication is customized as per the application requirements. Content on web pages are maintained from the database by the administrators.
Responsibilities
• Responsible for collection and analysis of requirements.
• Design & development of various UI of the application using ASP, HTML & JavaScript.
• Created database tables and Stored Procedures using SQL Server.
Software Analyst April 2004 – October 2005
Casino Marketplace Reports using SQL Server Reporting Services(SSRS)
Designed Casino management Reports using SQL Server reporting services. All the reports are develop as win forms in earlier versions which are transformed into RDL files and also developed intermediate wrapper screen which will allow end user to filter criteria and save the criteria. It made simpler for Customer to not provide filter criteria every time and instead can choose the saved criteria to render report.
Responsibilities
• Report Design using Visual Studio 2005
• Installation & Configuration of SQL Server Reporting Services and deployment of Reports
Associate Software Analyst June 2002 – March 2004
Avaya Leads and Opportunities Management System
Avaya Leads and Opportunities Management System is a web-based sales lead management system for maintaining and utilizing sales lead, Customer data and tracking field activity. This application allows users to enter lead and opportunities information online. The application intended to for sales representatives and managers to make their job easier with fast easy access online, offline system, simple and easy user interface. The primary objective of Avaya Leads and Opportunities Management System is to keep track of all the leads, their nature, value, forecasts, funneling and overall market.
Responsibilities
• Gathered User Requirements; Involved in the design using UML methodology and Rational Rose that included identifying the use cases and its surroundings, drawing Use case diagrams, identifying classes, drawing class diagrams and sequence diagrams.
• Application was designed based on N-Tier Architecture.
• Developed Business and Data tier using VB.NET and ADO.NET.
• Worked on Role Base Security at the presentation layer involving Authentication and Authorization modules proved by ASP.NET.
• Developed User controls using ASP.NET and VB.NET for reusability.
• Used Object oriented features such as inheritance, encapsulation and polymorphism in the implementation.
• Written PL/SQL Queries and developed stored procedures and user-defined functions to support data retrieval.
• Found several areas for improvement, made recommendations, and made changes to improve security across all components and systems.
• Used Visual source Safe for version control.
• Used Web Services for accessing data from the web server.
• Executed Stored Procedures using Oracle and the data extracted was displayed using Crystal Reports.
• Performed Unit and Integration Testing.
AWARDS Received
• Received many compliments from end users (casino Customers) for the efficient execution and demonstration of leadership during Production roll out(Go-live) and has been nominated as “Star of the Week” several times along with cash bonus awards.
• Achieved “Going Extra Mile” (GEM) award in Bally for the individual efforts put on Product design and development.
BUSINESS TRAVEL to following countries
• Canada, Chile, Bahamas, Aruba, PuertoRico, South Africa, Argentina and Macau.
BUSINESS VISITS to following Client places
• Apache Gold (Globe, AZ), Aura Casino (Aruba), Casino Arizona Talking Stick resort (Phoenix, AZ), Golden Nugget (Atlantic city, NJ), Grand Traverse (Traverse City, MI), Greektown casino (Detroit, MI), Kewadin Casino, Marina del Sol (Chile), Menominee Casino, Ocean Downs Casino (Delaware), Opus Casino (long Island, NY), Pichi's casino (PuertoRico), Poarch Creek Casino (AL), Treasure Bay My Lucaya (Bahamas), Valley Forge Casino(PA) and Wheeling island Casino (WV).
EDUCATION
Masters in Computer Science, Andhra University, India
REFERENCES AVAILABLE UPON REQUEST
Contact this candidate