C# Sql Server
Resume:
Shilpa A Rao
Application programmer- Microsoft Technologies
Professional Summary
10+ years of experience in application development and database programming, covering the full SDLC.
Expert in .NET development, including ASP.NET (Web Forms & MVC), C#, VB.NET, ADO.NET, and Web Services.
Strong database expertise with SQL Server, including Stored Procedures, Indexing, and Query Optimization.
Production support experience ensuring high availability and minimal downtime for mission-critical applications.
Rich experience in automation and RPA, utilizing Kofax Design Studio 11.0.
Proficient in Crystal Reports for advanced reporting and data visualization.
Familiarity with AWS cloud computing for scalable application deployment.
Python scripting knowledge for automation, data processing, and workflow enhancements.
Proficient in JavaScript and VBScript for UI interactivity and application responsiveness.
Quick to adapt and learn emerging technologies and frameworks.
Industry experience includes front desk operations, retail sales, and logistics management.
Technical Skills
Languages & Frameworks: ASP.NET, C#, VB.NET, JavaScript, Entity Framework, Web API, Python
Database: SQL Server (Stored Procedures, Indexing, Query Optimization)
Tools & Platforms: Crystal Reports, Jira, Ajax, Kofax Design Studio, Azure, AWS
Automation & RPA: Kofax Design Studio 11.0
Certifications
Microsoft Certified Azure Developer Associate (AZ-204)
Microsoft Certified Professional (70-515): Web Applications with .NET Framework 4
Microsoft Certified Professional (70-315): Web Applications with Visual Studio and C#
ITIL Foundation Certificate
Professional Experience
BMG Novato Nov 2023 – Present
Role: IT Support Specialist
Skills: SQLite, ASP.NET, Python, Office-365
Project: BMG is part of Postal Annex providing business support services. It partners with major carriers such as UPS, FedEx, and USPS, offering flexible shipping options for domestic and international deliveries. Helps to streamline daily tasks for professionals, remote workers, and small business owners.
Maintained PostalMate systems and APIs, ensuring seamless operations and integrations.
Developed and refined SQL queries for faster and more efficient data processing.
Collaborated for resolving interface issues with IT teams of Fedex, UPS.
Designed and implemented a web-based application using SQLite to track customer purchases and reward points.
Provided timely technical support, quickly resolving system issues to enhance user experience.
Marin Community Action (Volunteer) Apr 2023 – Oct 2023
Role: Customer Support
Skills: SQL, VB Scripts
Project: Marin Community Action is a nonprofit organization dedicated to supporting low-income individuals and families in Marin County through housing assistance, education, and economic empowerment programs. It provides vital resources such as job training, financial aid, and food security initiatives to promote self-sufficiency and community well-being. Through advocacy and direct services, the organization works to reduce poverty and improve the quality of life for vulnerable populations.
Developed web-based scheduling tool to streamline appointment booking using WaitWhile tool.
Sent SMS notifications upon user registration, providing estimated wait times to enhance customer experience.
Provided comprehensive customer support, swiftly addressing inquiries and resolving issues to ensure high satisfaction
LSEG (London Stock Exchange Group) – unit merged from Thomson Reuters & Refinitiv Nov 2015 – Jun 2022
Role: Senior Software Engineer
Skills: ASP.NET, C#, SQL Server, Kofax Design Studio, API
Project: KATE – A stock market data processing system that extracts, transforms, and distributes financial data to multiple stakeholders.
KATE extracts data from multiple sources, processes it, and generates output files for downstream systems. Extraction occurs via website robots, IMAP emails, user uploads, and NDA Oracle queries. During transformation, data is validated, enriched with ISIN, Effective Date, and RIC via web services, and stored in the database, with failed validations triggering stakeholder alerts. Finally, output files are generated based on the effective date and distributed to NDA, GEDA, CZ, EVM, EJV, and IQM
Designed and implemented front-end and back-end data workflows, optimizing extraction, processing, and distribution of stock market data from multiple exchanges, reducing processing time and improving efficiency.
Provided comprehensive application support for KATE and BIMBQM, ensuring high system reliability, minimal downtime, and uninterrupted financial data processing.
Resolved critical production issues and JIRA tickets, delivering timely code fixes to enhance functionality, improve user experience, and mitigate business risks.
Developed impact analysis and detailed design documentation, enabling structured project execution and future scalability.
Automated manual support processes using Kofax Design Studio, reducing manual workload and improving response time for business operations.
Collaborated with business analysts and stakeholders to align technology solutions with business needs, ensuring seamless system integration and compliance.
Spearheaded robotic process automation (RPA) initiatives, designing and deploying BOTs to handle repetitive tasks, significantly enhancing productivity and reducing errors.
Built small-scale applications to streamline support activities, leading to increased efficiency and reduced operational costs.
Dion Global Solutions Jan 2014 – Sept 2015
Role: Software Developer
Skills: ASP.NET, SQL Server, Data Visualization
Project: Dion Global Solutions is a financial technology solutions provider specializing in capital markets, stock market projects, and investor relations for various companies. The company delivers comprehensive software solutions that cater to investment banking, wealth management, trading, compliance, risk management, and post-trade processing.
Designed and developed applications for the Investors section, ensuring alignment with business requirements and user needs.
Created and implemented various charts to visualize stock market data, including EOD, Intraday data for BSE and NSE, and shareholding pattern pie charts.
Delivered intuitive user interfaces with a focus on responsive web design, ensuring seamless experiences across devices.
Developed and maintained web services to support seamless integration with other systems.
Jeeves Consumer Services Apr 2013 – Jan 2014
Role: Developer/Programmer Analyst
Skills: ASP.NET, SQL Server, CRM Development
Project: A service management platform for electronic products, allowing users to register service requests via phone or website. Customers receive SMS and email notifications with reference numbers for tracking. The system supports preventive maintenance and annual maintenance services, ensuring efficient service management and customer engagement.
Developed an application for automated report generation and dispatch, improving internal reporting efficiency.
Enhanced website and CRM functionality, optimizing user experience.
Built a data upload application, streamlining integration workflows.
Created and optimized SQL Server 2008 stored procedures for improved database performance.
Designed intuitive UI screens using ASP.NET and Visual Studio .NET for better usability.
Conducted peer code reviews, ensuring adherence to coding standards and best practices.
TCS Limited (On assignment from CMC Ltd) Jun 2007 – Mar 2008
Role: Developer/Programmer Analyst
Skills: ASP.NET, VB.NET, SQL Server
Project: A multi-tier web application for American Express customer service representatives, providing Servicing & Sales, Customer-Focused Sales, and Operations Maintenance. It facilitates credit card transactions, cancellations, and additional card requests while ensuring incident resolution within SLA timelines. The three-tier architecture consists of a presentation layer (ASPX pages), a business logic layer handling calculation, and a database for transaction management.
Performed requirement analysis, database design, and development strategies to align technical solutions with business needs.
Designed and implemented intuitive GUIs using ASP.NET and VB.NET for enhanced user experience.
Analyzed and resolved incidents by identifying root causes, implementing code changes when required, and ensuring seamless system operation.
Performed change management activities, including creating impact analysis documents, drafting detailed design documents, implementing code, developing component test plans, and executing component testing.
Performed Production support activities.
CMC Limited (merged with TCS Ltd)- Jul 2006 – Jun 2007
Role: Software Engineer
Skills: ASP.NET, VB.NET, SQL Server, Crystal Reports
Project: A web-based financial management system was developed for the Karnataka Treasury Department to streamline transactions, expenditures, payments, deposits, and pension reports across 216 treasuries. It consolidates treasury data into a central SQL Server for accurate financial tracking, utilizing a hierarchical 15-digit classification system to categorize government departments and facilitate budget estimation. Role-based access control enables Chief Controlling Officers (CCO), Controlling Officers (CO), and Drawing & Disbursing Officers (DDO) to efficiently manage financial approvals.
Designed and implemented financial reporting dashboards.
Automated reconciliation processes, improving financial accuracy.
Developed a multi-user authentication system for secure data access.
Conducted performance analysis and optimized system load times.
Provided technical support and troubleshooting for system users.
Education
Bachelor of Engineering (B.E.) in Computer Science
VTU, Belgaum, Karnataka – First Class with Distinction
Novato, CA
*********.*@*****.***
Contact this candidate