SUMMARY:

• 12+ Experience in Web application development utilizing SDLC and Agile methodology.
• Microsoft Certified Professional with extensive experience in object oriented analysis, design and development, report, dashboard development, Web Services based Mobile and Web applications.
• Experienced in database design, development and administration, ER - Win, creating SQL Stored Procedures, ETL packages development in SSIS and reports in SSRS / Report Builder.
• Industry experience: State Government,, Product Information Management, Catalog Publishing, and Telemarketing Call Center.

TECHNICAL SKILLS:

Programming Languages & Frameworks: .Net 4 & 5, C#, Python, VB.Net, LINQ, ASP.Net, MVC, XAML, WPF, XML, XSL, DTD, Web Services, SOAP, OData, AJAX, JavaScript, jQuery, JSON, HTML, KendoUI, SQL, PL/SQL, SVN, Team Foundation Server (TFS)

RDBMS & Application Development Tools: Microsoft SQL Server 2012 & 2016, SQL Azure, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Report Builder, PowerBI Visual Studio 2012 & 2015, Visual Studio BIDS, ER-Win, VISIO, MS Access, Visual Source Safe, MS OfficeOracle 10g, FoxPro, MySQL, SQLite

Mobile Development: iOS SDK, SWIFT, Xamarin, Android (on Xamarin), Xamarin extension for Visual Studio 2015

Cloud: Amazon AWS: EC2, S3, CloudWatch, RDS, Code Deploy, Redshift, Lambda, SNS, DynamoDB, Aurora Microsoft Azure, SQL Azure, Azure Active Directory, Azure Storage, CDN

Web Server & OS: Microsoft IIS 6 & 7, Windows Server, Windows 8, UNIX, Mac OS, Apache

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Senior .Net & Report Developer

Responsibilities:

• Responsible for the design and development of Web based application for HELC. HELC oversees all private postsecondary al institutions in the District of Columbia.
• Designed and developed .Net MVC based customer survey and reporting application.
• Designed and developed ETL in SSIS to import data and generate reports. Developed complex reports using MVC Web pages and SSRS based reports with business logic using SQL Server stored procedures.
• Developed several executive dashboards which includes filter enabled pie, line and bar charts for HELC management. Implemented row level security of data presented in the reports.
• Implemented .Net based generic authentication for public facing application and Active Directory (AD) based authentication for internal users.
• Providing DBA support to daily monitoring of ETL packages, database performance, SQL query tuning and server monitoring.

Technology: SQL Server, SSIS, SSRS, Stored Procedures, .Net, C#, MVC, Kendo UI, HTML, JavaScript

Confidential, Washington, DC

Senior .Net & Report Developer

Responsibilities:

• Lead application developer for the design and development of SLED (Statewide Longitudinal Data warehouse) project for DC government. Analyzed requirements and data feed from various sources for consolidating and developing a central al data warehouse to include student, enrollment, audit, test score, school, and attendance data.
• Designed data warehouse model (snowflake schema), developed Extract, Transform, Load (ETL) packages in SSIS. Responsible for developing customizable reporting portal.
• Developed reports and dashboards in SSRS / Report Builder, D3, stored procedures, views and MDX queries for reporting.
• Analyzed and converted about 600 reports to SQL Server Reporting Service based reports and HTML based reports. During this process, I implemented a generic methodology to define the business logic in stored procedures and securing the data using row level security. This approach significantly reduced the cost and time to develop and deploy new reports in SLED.
• Responsible for developing and standardizing ETL using SSIS. Developed SSIS packages for importing data from ed.gov, school attendance, LEA’s, meal information and several post-secondary data sources.
• As a DBA, conducted capacity planning of SQL database servers in production environment, setup replication, and tuned database performance by adding indexes, table partitioning, and SQL Server configuration parameters.

Technology: SQL Server Reporting Services - SSRS, SSIS, C#, MVC, SQL Server, Stored Procedures, Kendo UI.

Confidential, Washington, DC

Senior .Net & Report Developer

Responsibilities:

• Orchard application streamlines the application process for federal child nutrition programs in DC. Responsibilities include, database design, .Net based Web application development, ETL, report and dashboard development.
• Designed and developed over 50 SQL Server Reporting Services - SSRS reports and several .Net MVC based Web application forms for school and LEA data entry.
• Converted Excel based reports sent to schools and LEA’s to SSRS based reports and automated encrypted PDF report creation and delivery.

Technology: SQL Server Reporting Services - SSRS, SSIS, C#, .Net, MVC, SQL Server, HTML, JavaScript.

Confidential, Rockville, MD

Senior .Net Developer

Responsibilities:

• Designed and developed pimhub.com - an industrial online portal to connect product suppliers with procurement, engineering, scientific and manufacturing professionals.
• Developed cloud based Product Information Management (PIM) software and analytics dashboards using EC2, S3, Lambda, API, Cloudfront, IAM, SNS, SQL Server and SSRS.
• Developed several Python scripts for automating client data upload, parsing of complex product data and importing of various ecommerce feeds into a generic database.
• Developed REST API with AWS, Lambda and C#. Developed SaaS based retail, customer and ecommerce analytics application and dashboards using PowerBI, Redshift and DynamoDB.
• Responsible for requirements analysis, pimhub.com Web site, database design, application UI prototyping.
• Designed and developed responsive .Net MVC 5 application in C#, Razor, Bootstrap, jQuery, JavaScript, SQL Azure using Visual Studio 2015.
• Developed complex PDF reporting and catalog creation module with Stimulsoft reporting engine.
• Designed PIMHUB database schema in ER-Win and customized ER-Win for stored procedure script creation.
• Lead developer for Partsgram industrial sourcing platform. Partsgram is a Mobile and Web based platform for industrial buyers and suppliers to source parts and supplies by posting buy / sell requests and publishing them to social network and various other distribution channels, Send RFQ, promote products with display Advertisements, engage in product discussion
• Analyzed requirements for developing Mobile and Web based application for Partsgram platform and ensured that application can share cloud based database and can serve iOS, Android and Windows based apps.

Confidential, Washington, DC

Senior .Net Developer

Responsibilities:

• CAPTEL conducts outbound telemarketing for fund-raising, development, grass-roots lobbying, survey research, polling and other voice communications requirements.
• Developed web-based call center system using ASP.Net, C#, IIS, SQL Server 2012, XML, and Web Services.
• Provided database administration support and migrated databases from Oracle to SQL Server.
• Designed master pages and server custom controls to share functionality between admin, tele-marketing agents, verifiers and supervisors. Developed .Net web application utilizing Object Oriented Programming concepts.
• Migrated call center applications and databases to Amazon AWS. Developed cost estimates for utilizing EC2, S3 and other AWS services.
• Worked on CLI to automate server maintenance and monitoring. Developed several Python scripts to analyze and store telephony data in SQL Server.
• Implemented SQL Server 2012 SSRS reporting and dashboards for call center operations and monitoring.
• Worked with PCI agency to conduct audit and to receive PCI for call center.

Confidential

Senior .Net Developer

Responsibilities:

• Designed and developed Web based property tax maintenance application for O’Conner & Associates, Texas.
• Provided software maintenance support for client’s property tax maintenance application.
• Analyzed client change order, coordinated with team members to develop and apply software changes for an ASP.Net, SQL Server based application.
• Developed proof-of-concept prototype screens and design documents for change orders.
• Developed SSIS ETL packages for property data extraction and managed nightly SQL jobs for all ETL packages.
• Developed unit test plans, coordinated with quality assurance team for system integration testing and validating requirements.
• Developed core functionality with the .NET Framework and Implemented Object Oriented fundamentals to design system architecture.
• Responsible for application development using TFS and Visual Studio .NET 2012
• Developed front end responsive web application features using, jQuery UI, JavaScript, ASP.NET, C#, and Visual Studio 2012
• Implemented security module with forms and Windows based authentication with .Net and Active Directory (AD) Developed stored procedures and custom SQL in SQL Server.

Confidential

Senior Software Engineer

Responsibilities:

• Confidential provides software and services that help manufacturers, distributors, wholesalers and catalogers to manage their product content efficiently and deliver consistent product information to their customers across various marketing channels.
• Team member for the development of Product Information Management (PIM) and Multi-channel product catalog publishing software suite using .Net (C#) and SQL Server 2005/ 2008.
• Worked with Systems Architect and designed GUI prototypes and mockup catalog samples

Confidential

Senior Web Developer

Responsibilities:

• Team member for the development of Product Information Management (PIM) and Multi-channel product catalog publishing software suite using .Net (C#) and SQL Server 2005/ 2008.
• Worked with Systems Architect and designed GUI prototypes and mockup catalog samples.
• Supported database schema development, programming stored procedures and custom SQL in SQL Server 2000
• Designed and developed embedded reports in SSRS.

Confidential

Software Developer

Responsibilities:

• Developed eSpares Web based spares tracking application for a manufacturing company.
• Developed Application with ASP.Net 2005, VB.Net and SQL Server 2000 for Acer
• Designed prototype UI for the application, interacted with client to refine UI and document business requirements.
• Developed eSpares Web based application with Infragistics Web controls. Customized ASP.Net and stored procedures to handle server side paging for large data grids.
• Implemented online ad-hoc querying tool to query large spares database and to generate spares technical specification sheets in PDF. Developed custom PDF document rendering module with C# and StimulSoft reporting framework.

Confidential

Software Developer

Responsibilities:

• Responsible for design and development of time tracking system and integrating with the payroll system.
• Analyzed requirements and developed design document. Developed system conceptual design and mockup UI.
• Designed and developed client / server application using Visual Studio 2003, C#, SQL Server 2000.