SUMMARY:

• Result Oriented Sr. Developer/ Architect /Tech Lead with over 14 years of proven experience in enterprise software development.
• Successfully delivered projects for industry leaders like Product Management, Education, Catalog Publishing.
• Experienced 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, Education, Product Information Management, Catalog Publishing, Telemarketing Call Center.
• Expertise in JavaScript based hybrid Mobile Technologies mobile first responsive UI design using Bootstrap
• Experience establishing best practices and guidelines for selecting, developing, and implementing information systems within enterprise.
• Good experience in Microsoft .NET Technologies (ASP.NET MVC, C#)
• A flexible team player with the ability to adapt to an evolving product development environment.
• Good knowledge of ETL tools, SSIS, Reporting Service (SSRS).
• Experience in ORM tools like Entity Framework
• Environment, Scrum, Test Driven Development (TDD).
• Experience in Object Oriented programming.
• Worked in Design Patterns: MVC, MVVM, gang of 4 patterns, designing de-coupled architecture, IOC-Dependency Injection (DI)
• Expertise in UI / Frontend Technologies (AngularJS, jQuery, JavaScript, Responsive Web Design, HTML5, CSS3, Bootstrap, Kendo UI tools).
• Strong in Database Technologies (SQL Server, T-SQL queries, Database design, normalization, Indexing, query optimization, performance tuning, stored procedures).
• Hands on experience in Service Oriented Architecture (SOA) with WCF, Web Services. REST services using ASP.NET Web API.
• Good experience on Cloud platforms: Microsoft Azure and Amazon Web Services (AWS). iOS SDK, SWIFT, Xamarin, Android (on Xamarin), Xamarin extension for Visual Studio 2015.
• Excellent communication, presentation, and organizational skills.

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 Office Oracle 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 Microsoft Azure, SQL Azure, Azure Active Directory, Azure Storage, CDN, Blob

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

PROFESSIONAL EXPERIENCE:

Confidential, CA

Senior .Net Developer / Architect

Responsibilities:

• Responsible entire Software Development Life Cycle as well as Microsoft .Net Framework Technologies. Having sound knowledge of developing web based B2B B2C applications in the client/server environment.
• Implementation experience in installation, configuration, customization and extension of Microsoft Dynamics CRM as well as doing the deployment, trouble shooting and production support for the applications developed.
• Experience in developing complex applications on Microsoft Dynamics CRM platform with customization of entities, sitemap writing client side JavaScript.
• Experienced in creating, updating, and reviewing project plans.
• Experience in client management and system development, design, and implementation

Confidential, Rockville, MD

Senior Software Engineer

Responsibilities:

• Responsible for the design and development of Web based application for HELC. HELC oversees all private postsecondary educational institutions in the District of Columbia.
• Designed and developed .Net MVC based customer survey and reporting application.
• Worked in MVC 5, Asp.net and implemented OOPs concept using C#, created models, Controllers and Data Transfer Objects (DTO)
• Designed database using ER-Win tools.
• Written complex stored procedure, Views and Common table expressions.
• Worked stored procedure query performance tuning, optimization.
• 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 membership 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.
• Experience with REST API/ Web API creation, consumption, integration using Service Oriented Architecture.
• Technology: SQL Server, SSIS, SSRS, Stored Procedures, .Net, C#, MVC, KendoUI, HTML, JavaScript, JQuery

Confidential, Washington, DC

Senior .Net Developer / Architect

Responsibilities:

• Lead application developer for the design and development of SLED (Statewide Longitudinal Education Data warehouse) project for DC government. Analyzed requirements and data feed from various sources for consolidating and developing a central educational data warehouse to include student, enrollment, audit, test score, school, and attendance data.
• Designed and developed .NET MVC 5 application in C#, Razor, Bootstrap, JQuery, Kendo Ui, based application.
• Created (Service Oriented Architecture SOA), WebAPI service to call and retrieve the data.
• Token based authentication used for access webapi service.
• Designed data warehouse model, developed Extract, Transform, Load (ETL) packages in SSIS. Responsible for developing customizable reporting portal.
• Developed reports and dashboards in SSRS / ReportBuilder, D3, stored procedures, views and MDX queries for reporting.
• AngularJS used to wire up controller, module and other tags.
• 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 education 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: C#, MVC, SQL Server, Stored Procedures, KendoUI, Jquery, Javascript, SSRS, SSIS,SQL Server Reporting Services

Confidential, Washington, DC

Senior .Net Developer / Architect

Responsibilities:

• Leading a team, design and developed web based application
• 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 .Net MVC based Web application forms for school and LEA data entry.
• Extensively worked on Login pages Password Reset, First Time Password Change, Forgot Password
• Implemented Account Confirmation and Password Recovery with ASP.NET Identity.
• Worked on Telerik Kendo Controls(Kendo UI) like Grid, Calendar, ListView, and other controls.
• Worked on JavaScript, JSON data, iterating and creating new JSON
• Worked on QuickBase application to .NET/SQL Server migration
• Worked on control/data specific showing notifications, alerts and error messages
• Good knowledge in Testing, bug fixing, QC
• Designed wen using twitter Bootstrap and responsive UI.
• Converted Excel based reports sent to schools and LEA’s to SSRS based reports and automated encrypted PDF report creation and delivery.
• Technology: C#, MVC, SQL Server, Stored Procedures, KendoUI, Jquery, Javascript, SSRS, SSIS,SQL Server Reporting Services

Confidential, Rockville, MD

Senior .Net Developer / Architect

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.
• Worked on Telerik Kendo Controls(Kendo UI) like Grid, Calendar, ListView, and other controls.
• AngularJs used to developed application, Controller, Databinding, expressions, directives, filters and other core concepts
• 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.
• 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, Rockville, MD

Senior .Net Developer / Architect

Responsibilities:

• 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
• Created websites in Windows azure.
• In Windows Azure setup Continuous integration / Continuous deployment from TFS build to deployment in UAT/Test location.
• Windows Azure SQL Server database used to developed stored procedure.
• Experience with Microsoft Azure (Azure SQL, Storage, Web apps, web roles, worker roles, Service Fabric, IoT Hub, Blobs, CDN).
• Professional experience with Azure (planning, migrations, deployment, configuration)
• Experience extending Active Directory to cloud services Azure.
• Understands the performance aspects of Azure storage platforms.
• Designed and developed Mobile application using Xamarian for Android and iOS
• Designed iOS UI for iPad and iPhone, prototypes mobile application using Balsamiq.
• Designed and developed SQL Azure based database schema in ER-Win, which included functionality to track user, OS, Geo location, chat and social media data aggregation for analytics.
• Designed C# .Net, REST based Web services and implemented server side API’s in Windows Azure.
• Developed unit tests and coordinated with quality assurance team for application testing.
• Developed automated scripts to unit test database stored procedures and REST API’s.
• Worked with a team of 4 developers, provided technical leadership and developed iOS app using SWIFT programming language.
• Created (SOA Service Oriented Architecture) WebAPI service to call the retrieve the data.
• Developed SQL Stored Procedures, end user Email and SMS notifications.
• Designed MVC based Web front-end application for Partsgram to utilize same SQL Azure database and API’s.
• Developed authentication modules using .Net membership and Azure Active Directory.
• Designed Web UI using Twitter Bootstrap and responsive UI
• Extensively utilized CSS, JavaScript, and JQuery for client side data validation.
• Utilized agile development with 2 week sprints and completed Mobile, Web and API rollout successfully.
• Implemented SSRS reports in external SQL Server with data connection to SQL Azure to generate daily management reports and send subscription email with PDF reports to company executives.

Technology: Microsoft .Net, C#, ASP.Net, JavaScript, AJAX, JQuery, Bootstrap, MVC, Microsoft SQL Azure, iOS SDK, SWIFT, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services), ER-Win, Apple App Store, REST, JSON

Confidential, Washington, DC

Senior .Net Developer

Responsibilities:

• CAPTEL conducts outbound telemarketing for fund-raising, membership 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 certification agency to conduct audit and to receive PCI certification 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 membership and Active Directory (AD) Developed stored procedures and custom SQL in SQL Server.

Confidential

Senior Software Engineer

Responsibilities:

• TradingBell 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.