Sql Server Developer
Resume:
Mirza Kamal Baig
********@*****.***
Work Authorization: US Citizen
Professional Summary
** **** ********** ******* ** Microsoft based Application Architecture and Development
Azure Certified Solution Architect for IAAS, PAAS, Serverless workloads as well as Azure Resource Portal
Extensive experience with .NET (C# 5/6.0, ASP.NET .Net Core 1.0 / MVC 4.0/5.0, AJAX, LINQ, TPL)
Design and debugging applications using Visual Studio 2015 / 2017 & SQL Server 2014/2016
Application Development using Azure Cloud Services, Azure Table, Azure Blob and Azure Queue services
Design n Development using Platform As A Service (PAAS) Web Roles, Worker Roles, VM, VM Scale set
Using Azure App Services (Web Apps, Mobile Apps, API Apps) for scalable apps development
Using Azure Search Service / ElasticSearch /Lucene for searching capabilities in web and mobile applications
Familiarity with Azure Services (Redis Cache, Service Bus, Queues, Relays, Topics, File Storage services)
NoSQL database design and development using MongoDB, Windows Azure Table Storage & DocumentDB
Development using AWS services S3, EC2 and AWS Lambda serverless application development
Microservices development using Node.Js n Python and serverless AWS Lambda & Azure Functions
Strong skills in HTML, JQuery, JavaScript, MVC 5.0, Razor, Microsoft ASP.Net Ajax, AngularJs
Distributed App. development using WCF, WebApi 2.0, XQuery & XSLT, Altova XMLSPY, MapForce
DB development SQL Server 2008/2014 Stored Procedures, Triggers, Indexes, Views, Profiler & Analyzer
Professional experience with SQL Server Backup & Recovery Models, CLR Stored Procedures & Function, SQL Reporting SSRS Data integration, Transformation and Bulk Importing using SSIS/DTS
WinForm application development using Visual Studio WinForm Controls & Telerik & Infragistics
SPA development using ASP.Net MVC 4.0/5.0, JQuery, WebAPi 2.1, EF 7.0, Automapper, Angularjs
E-Commerce application using ASP.Net (4.0,5.0), ASP.NET MVC 5.0, REST WebAPi, Payment Gateways
Microsoft Data Access, Logging, Caching, Exception handling application blocks for Application enhancement
3-tier application development using Entity Framework EF 6.0, Subsonic ORM and Enterprise Library
RAD development experience using Telerik, Infragistics and Component Art GUI Controls, Dundas charts
RAD development using .Net Framework 4.5/4.0, OData Services, LINQ, LINQ2SQL, EF 6.0
Development of SOAP & REST based WebApi / WCF with (WSE) Web Services Enhancement feature
technical skills
Cloud Services (Azure / AWS)
Microsoft Certified Azure Solution Developer & Architect
(MCP: 70-532 & 70-534)
Azure VM, Cloud Services Web Roles, Worker Roles, Service Bus Queues, VPN, API Gateways, Azure Blob Storage, DocumentDB, Azure Table, Azure Service Fabric, Azure Function, Redis Cache, Azure Service Fabric Reliable Services Stateless & Stateful, Data Lake, Data Factory, HdInsight, Notification Hubs, Azure IOT Hub, Stream Analytics, AWS Serverless Architecture AWS Lambda, AWS S3, EC2, Elastic Bean Stalk, Machine learning using Azure & AWS
Version Control System
GitHub, SourceTree, TFS, SVN, SourceSafe, AceProject Project Management
Web Technologies
ASP.Net Core 1.0 & Asp.Net MVC 3/4.5/5.0, C#, VB.Net 9, ASP, HTML,IIS WebServices, JSON, JQuery, LINQ2SQL,XML, CSS, JavaScript,TypeScript
Reporting Technologies
Crystal Reports, SQL Server Reporting Services (SSRS)
JS Frameworks / Libraries
AngularJs 1.3/1.4, Node.js, ReactJS, Meteor, ES6.0, Expess, Knockout JS,Select2
Professional Experience
Capgemini Sep 2017 - Current
Azure PaaS & Big Data Architect / Azure Delivery Architect
Royal Caribbean Cruises
As an Azure Delivery Architect for the end client RCCL my responsibilities included designing and implementing technical architecture for consolidating on-premise data for more than 20 different sources into the Data lake store and establishing a foundation for data exploration, machine learning and reporting
Data Lake & ETL architecture design using Azure Data Lake, Azure Big Data Service & Talend
Data Ingestion using Talend on IaaS VM, Data Lake integration with Azure Active Directory
Data Transformation using Azure Data Lake Store, Talend Big Data job & Spark on HDinsight
Data Exploration using Azure SQL DW, Polybase & Dremio on IaaS VM
Reporting architecture using Azure SQL DW & PowerBI integration
Customer 360 API architecture design and exploring CosmosDB vs. NOSQL and Neo4J graph dbs
Experienced in Presales, Technical planning and assessment for Big data cloud migration workload
Professional Experience
Freelance Contractor Developer / Architect Oct 2016 – Current
Azure Architect IaaS / PaaS / Big Data / ASP.NET MVC & .NET Core
Microsoft / PWC (March-April, 2017)
Worked as part of the Microsoft Team to enable their end client PWC establish a road map to migrate their on-premise workload to Azure PaaS. The Migration Framework provides a consistent approach to Identification, Development and Migration to Azure PaaS services.
Evaluation and Migration of PWC web api to Azure Web Api PaaS service
Integrating Application Insight with PWC Api to enable detailed insight and advance telemetry
Enable & mentor PWC team to utilize Search and Analytics capabilities of Application Insight
Migration of an on premise SQL DB to Azure SQL using BACPAC. Using SQL Server Migration Assistant (SSMA) to analyze on-prem DB and verify compatibility for migration.
Setting up Continuous Integration Deployment CI/CD pipeline using Team Services VSTS
Analyzed different PaaS services e.g. Container Service, Api Gateway, Azure Redis Cache for enhancement of this and other applications within PWC pool of applications
Independent Contractor
My recent experience involves learning and working with Big Data Solution and Analysis using Microsoft Azure Cloud Services and Microsoft Big Data tools and its integration with other Industry standard tools for processing Big Data workloads.
POC using Azure Data Science VM (DSVM) along with R Server/ Jupitor Notebook / python
POC using DSVM and Apache Drill for big data analysis across various diverse data sources
Design and analysis of Big Data Lambda Architecture (Batch vs. Streaming data processing scenarios)
Big Data analysis in SQL Server 2016 and heterogeneous data sources using PolyBase
Spark 2.0 on HDInsight and its Integration with Azure Event Hubs for streaming real-time data
Azure Streaming Analytics with Event Hubs and sending output to PowerBi Dashboard
POC regarding log file analysis using Spark 2.0 on HDInsight using DataFrames, DataSets & SparkSQL
POC regarding Spark 2.0 Machine learning capabilities and Clustering & Linear Regression analysis
POC on 911 calls dataset using Spark 2.0 on Databricks and exploring data in graphical format using Zepplin / Jupitor Notebooks
POC on 911 calls dataset using Spark Machine learning for K-Mean Clustering & Linear Regression
Real-time data processing using Azure Event Hub and then reading data through
oAzure Functions Apps and write to DocumentDB
oAzure Worker Roles & C# .Net Client Libraries and storing in Azure Table storage
Data Pipeline creation using Azure Data Factory (ADF) for log data and Using U-SQL for transformation and data manipulation (ETL)
Big data orchestration and Transformation using Azure Data Factory copy pipeline & Custom transformation activity using Visual Studio, C# & On demand HDInsight clusters
Custom Data Ingestion pipeline using Azure Blobs, Azure Function Apps to read and parse data & index in Azure Search & Azure Redis Cache
C# based Microservices development using Azure Function Apps / Serverless architecture
Api Management for authentication Azure Function based Microservices
Machine Learning using Azure Machine Learning Studio, HDInsight with SparkML & H2o library along with R language, R-Studio and Python based libraries panda, SciKit-Learn for statistical models
oRegression Modeling
oClassification ( Binary / Multi-Class)
oRecommendation & Clustering
Azure App Services (PAAS)
Web /Api / Mobil / Logic Apps
Cloud Services (Web / Worker Roles)
Azure VM, Blob / Table Storage
Azure DocumentDB (NoSQL)
Azure Redis / Search service
Service Fabric / Az. Container Services
Function Apps / Serverless computing
H2o / SparkML Machine Learning
AWS S3, Redshift, RDS, DynamoDB
AWS EMR with Spark & Presto
AWS Athena, AWS Lambda
Azure HdInsight (Spark 2.0)
Azure IOT / Event Hubs
Azure Batch / Spark Streaming
Azure Stream Analytics
Azure Data Lake Store / Analytics (U-SQL)
Azure Data Factory / Power BI
Azure SQL Server 2016 / PolyBase
Azure Machine Learning
AWS Machine Learning
AWS GLUE (ETL) & Catalog
AWS Macie for PII Data
AWS Kenesis Firehose, Data Analytic
Professional Experience
Alegeus Technologies (Maitland, Florida) Feb 2016 – Oct 2016
Sr. ASP.NET Developer / Architect
Description
Alegeus is the market leader in consumer directed healthcare solutions (CDHS), offering a comprehensive platform for administration and a powerful engagement solutions to help consumers maximize savings and optimize spending for their healthcare plans e.g. HSA, FSA, HRA etc.
Roles and Responsibilities:
Application design and development using ASP.Net MVC 4.0, WebForms, C# 5.0, EF 6.0, SQL Server, JQuery
Design and Development of Business and Service layer using WebAPI 2.0, WCF with Soap and Json
Database and EDI design and enhancement using SQL Server 2014, stored procs, custom routines
Migration and Testing of Caching service layer from AppFabric to Azure Redis Cache
POC ASP.NET MVC / WebApi web app development and deployment Azure WebSite / App Service
POC Microservices architecture design & development using Azure Service Fabric Stateless & Stateful Services
POC Web role and Worked role & Azure DocumentDB hosting employers expense reporting app
Environment:
Visual Studio 2015, ASP.Net MVC 4.0, C# 5.0, SQL Server 2014, JQuery, .Net Framework 4.5, Seapine Surround SCM Source control, Seapine TestTrack Bug Tracking system, WebAPI 2.0, JSON, XML, XSLT, EF 5/6.0, LINQ, Redis
Professional Experience
Deloitte LLC, (Florida / Kentucky) Aug 2015 – Jan 2016
.Net Senior Developer / Architect
Description
Deloitte is helping the state of Kentucky with the Health Care Market place project. KYNECT health care connects and provide Individuals, families and small Businesses with easy one stop shopping for all HealthCare coverages.
Roles and Responsibilities:
Design & Development using ASP.Net MVC 4.0/5.0, WebAPI 2.0, C# 4.5/5.0, EF 6.0, SQL Server, JQuery
Design and Development of Business & Service layer using WebAPI 2.0, JSON, Automapper, TPL
UI development and enhancement using JQuery, JSON, HTML 5.0, Ajax, JQuery UI & plugins
RDBMS design and enhancement using SQL Server 2012 & NOSQL MongoDB Integration
Service Development & Integration with healthcare web service using WCF and Soap based services
Environment:
Visual Studio 2013, ASP.Net MVC 4.0, C# 5.0, SQL Server 2008/2012, JQuery, NInject, .Net Framework 4.5, GitHub, SourceTree, SVN, WebAPI 2.0, JSON, Knockout.js, Angularjs, Grunt, Bower, Yomen, XML, XSLT, EF6.0, LINQ, PLINQ, Task Parallel Libraries TPL, Async Controllers, SignalR, Redis, Lucene Search, ElasticSearch, MongoDB
Professional Experience
Equinox, NYC Sep 2013 – June 2015
.Net Senior Developer / Architect
Description
Equinox offers innovative health and fitness services across USA, UK and Canada. The company aims for inspiring members to push themselves to their personal best. Personal training, group fitness, Spa are some of the services in the company’s growing portfolio.
Roles and Responsibilities:
SPA Development using ASP.Net MVC 4.0/5.0, WebAPI 2.0, C# 4.5/5.0, EF 6.0, SQL Server, JQuery
Admin Dashboard SPA development using AngularJs, Yeomen, Grunt and Bower, WebApi 2.0, JSON, C# 4.5
Development of Search Modules for Classes using WebAPI 2.0,Apache Lucene and Lucene.Net Client
Design and Development of Studio Cycling component using MongoDb, C#, LINQ, Webapi
Design and Development of Business & Service layer using WebAPI 2.0, JSON, Automapper, TPL
UI development and enhancement using JQuery, JSON, HTML 5.0, Ajax, JQuery UI & plugins
Dependency Injection using Ninject for distributed and loosely coupled component development
MOQ, Automapper, LINQPad, SOAP UI, Fiddler2, for debugging, ORM mapping and TDD automation
Github, SourceTree, Atlassian JIRA, Jenkins CI, SVN for source control and build automation processes
Performance Monitoring and Code Optimization using New Relic Dashboard
Environment:
Visual Studio 2013, ASP.Net MVC 4.0, C# 5.0, SQL Server 2008/2012, JQuery, NInject, .Net Framework 4.5, GitHub, SourceTree, SVN, WebAPI 2.0, JSON, Knockout.js, Angularjs, Grunt, Bower, Yomen, XML, XSLT, EF6.0, LINQ, PLINQ, Task Parallel Libraries TPL, Async Controllers, SignalR, Redis, Lucene Search, ElasticSearch, MongoDB
Professional Experience
Macmillan Publishers, NYC Feb 2012 – August 2013
.Net Lead / Senior Developer
Description
Macmillan publishes a wide range of books, magazines, and digital products for consumers and education markets. The Company is transitioning from print to digital contents for editors, content producers, students and uses an in-house application platform (PX = platform X) based on latest Microsoft web technologies for content creation and distribution.
Roles and Responsibilities:
Involved in Scrum based approach for team collaboration and for delivering reusable Components
Web Development using MVC 3.0 Models, Views, Controllers, Partial views, Global & Custom Action Filters
Intranet based application development C#, ASP.Net, JQuery, LINQ, Entity Framework 4.1, Visual Studio 2010
UI development using ASP.Net MVC 3.0, JQuery, JSON, JavaScript, HTML, AJAX
UI enhancement using JQuery Validation, JQuery plugins, HighCharts, Lightbox, JQuery UI widgets and effects
Business Component development based on Design Patterns e.g. Repository, Singleton, Decorator
Dependency Injection Framework NInject for distributed and loosely coupled component development
Development and integration of REST based WCF services for Content management and 3rd party LMS systems
DB design and development using SQL 2008, TSQL & CLR Stored Procedures, SSIS, SQL Agent Jobs
Involved in Version Control and Unit Testing using TortoiseSVN, TFS, NUnit, MoQ etc.
Environment:
Visual Studio 2010, ASP.Net 4.0, ASP.Net MVC 3.0, C#, SQL Server 2008, JQuery, NInject, LINQ, .Net Framework 4.0, TFS (Team Foundation Server), WCF, JSON, XML, XSLT, EF4.0, LINQ2SQL, LINQ to Entities
Professional Experience
Micro Strategies Inc. NJ Sep 2011 – Dec 2011
.Net Senior Developer
Description
Micro Strategies is a business and infrastructure solution provider. For one of their prestigious Electric Power Company they provided invoice and billing system. The project spanned across SharePoint along with .Net technologies and integration with legacy systems.
Roles and Responsibilities:
Design and Analysis of data transfer components using SQL 2008, SharePoint Lists for Invoice Reporting
Involved in Scrum based approach for team collaboration and for delivering reusable Components
Web UI development for Invoice Tracking Dashboard using C#,ASP.Net, JQuery, LINQ, Telerik UI Controls
Business layer development using .Net 4.0, C#, LINQ to SQL, LINQ to SharePoint, ADO.Net, NUnit
Data layer development using SQL 2008, TSQL & CLR Stored Procedures, SQL Agent Jobs
Environment:
Visual Studio 2010, ASP.Net 4.0, C#, SQL Server 2008, JQuery, NInject, LINQ, .Net Framework 4.0, TFS (Team Foundation Server), WCF, JSON, XML, XSLT, SharePoint Lists, EF4.0, LINQ2SQL, LINQ to Entities
Professional Experience
EveryDay Health Inc. NYC Apr 2011 – Sep2011
.Net Senior Developer
Description
MedPageToday (MPT) provides medical news and information to physicians and medical related people. This site offers latest medical articles, summaries, actionable information along with Continuing Medical Education (CME) so that physicians, nurses and other medical related people can earn credits and keep their medical profile updated. The site was originally developed in Cold Fusion and is in the process of migration to .Net
Roles and Responsibilities:
Design and Analysis of existing Cold Fusion application for migration to ASP.Net MVC app
Involved in Scrum based approach for team collaboration and for delivering reusable Components
Web User Interface development using ASP.Net 4.0, JavaScript, CSS, JQuery libraries
Cold Fusion Component and Web Services design and integration with C#,LINQ, Generics, WCF
Integration with publishing application and workflow for data ingestion and collaboration C#,EF4.0, LINQ
Team Foundation Server for source code control and collaboration and project tracking
Environment:
Visual Studio 2010, UltraEdit, ColdFusion 8, ASP.Net 4.0, C#, SQL Server 2008, MVC 3.0, Razor, JQuery, NInject, .Net Framework 4.0, TFS (Team Foundation Server), EF 4.0 (Entity Framework 4.0)Cold Fusion Web Services, WCF, JSON, XML, XSLT
Professional Experience
Dow Jones, NJ Nov 2010 – Mar 2011
.Net Senior Developer
Description
Involved in design, development and integration of end-to-end business management components and controls for internal projects. Creating controls for the DashBoard project and integrating with web services. The Dashboard project then becomes the foundation for all internal and external publishing, financial and marketing applications.
Roles and Responsibilities:
Involved in Scrum based approach for team collaboration and for delivering reusable Components
Component and Services design and development using XP practices Pair Programming and TDD
Pluggable UI component development using Visual Studio 2010, C# 4.0, ASP.Net 4.0, MVC 3.0, JQuery
WCF development using C#, Generics, EF 4.0, LINQ and testing using Visual Studio 2010 and VSTS and TFS
Team Foundation Server for source code control and collaboration and project tracking
Environment:
Visual Studio 2010, ASP.Net 4.0, C#, SQL Server 2008, MVC 3.0, Razor, JQuery, Inversion of Control using NInject, LINQ, .Net Framework 4.0, TFS (Team Foundation Server), Entity Framework 4.0, Web Services, NUnit, WCF, JSON, XML, XSLT, JQuery HighCharts plugin
Professional Experience
NYC, DOE (Department of Education)
ESB (Enterprise Service Bus, Center of Excellence)
.Net Architect / Senior Developer Nov 2009 – Nov 2010
Description
ESB is an integration platform helping various distributed WebServices and applications within DOE environment to collaborate and provide unified Student and Schools Management information to business users. Using IBM Web Sphere Enterprise Services Bus helps enable fast and flexible Application Integration, Decouple complex integration logic from each application and offers central integration solution eliminating point-to-point connectivity programming.
Roles and Responsibilities:
Scrum based approach for development, team collaboration and coordination
Prototyping and Proof-of-Concept (POC) involving Canonical Models, SOAP Services, WCF, Message Broker
SOAP based Web Services development using C#, Visual Studio 2005/2010, NUnit, SOAPUi, XMLSpy
Web Apps using ASP.Net 4.0, MVC 2.0, JQuery, Visual Studio 2010, ComponentOne iPhone Ui Controls
WebServices unit testing and Stress Testing using Visual Studio Team System 2010 and TFS integration
SQL Server 2005/2008 Tables, Views, Stored Procedure & T-SQL Functions, SSIS and XSLT transformation
Visual Source Control for version control and centralized development storage repository
Environment:
Visual Studio 2005/2010, C#, SQL Server 2005/2008, SSIS, LINQ, MVC 2.0, .Net Framework 2.0, 3.5, 4.0, SQL Management Studio, SQL Profiler, SQL Analyzer, WCF, Visual Source Safe, VSTS 2010, TFS, JQuery, XSLT 1.0/2.0, MQClient, Altova MapForce, Altova XMLSpy, IIS 6
Professional Experience
eSchoolData, Bohemia, NY
Project Name: Knowledge Management System (NexGen)
Senior .Net Developer April 2009 – Oct 2009
Description
NexGen is a Web based Enterprise level Student Management System. Based on the latest technologies and SOA architecture it not only offers detailed Student & Grade level Management but also reporting functionalities in accordance with State accountability standards.
Roles and Responsibilities:
Scrum based approach for development, team collaboration & coordination
GUI using VB.Net, ASP.Net 2.0, Authentication, Authorization, Role & Membership Mgmt.
GUI enhancement using ASP.Net 2.0 Master Pages, Themes, Ajax Pro, JavaScript & XSLT 1.0/2.0
Web User Control development for code reusability within same and multiple web applications
DB enhancement using SQL Server 2005/08 Tables, Views, Stored Procedure & T-SQL Functions
T-SQL Queries, Stored Procedure testing & optimization using SQL Profiler, SQL Query Analyzer
Visual Source Control for version control and centralized development storage repository
Environment:
ASP.Net 2.0, Visual Studio 2005, MVC 2.0, C#, VB.Net, SQL Server 2005/2008, SQL Management Studio, SQL Profiler, SQL Analyzer, Ajax Pro, JQuery, JSON, Visual Source Safe, XSLT 1.0/2.0
Professional Experience
Alpha wire Company, Elizabeth, NJ
Project Name: Warehouse Management System (WMS)
.Net Lead / Sr. .Net Developer Jan 2009 – April 2009
Description
This was a Windows CE based Inventory management system. The company is into manufacturing and sales of cables and inventory management, stock counting etc. act as a backbone in all the operations. Warehouse
Management system integrates with the CRM and the Sales application for complete tracking of company’s business.
Roles and Responsibilities:
Application Design & Development using VB.Net, Visual Studio 2003/2005, Windows Mobile 5.0, Microsoft Emulator, Active Sync 4.5
Database development in SQL Server 2005 Tables, Views, Stored Procedure & T-SQL Functions
Handheld device used for the application Intermec 730B Mobile Computer
Environment:
Visual Studio 2003/2005, VB.Net, SQL Server 2005, SQL Management Studio, SQL Profiler, SQL Analyzer, Data-Direct ADO.Net Provider, Visual Studio Mobile Application Development, ActiveSync 4.5, Mobile Device Emulator
Professional Experience
Mega Solutions (Offshore – Out of US) Aug 2005 – December 2008
Senior .Net, Lead C# Developer
Project: Terasen Business Process Automation
Description:
The project focused on automation of business processes like Billing and Enrollment processing for a Canadian Gas Company. Manual processes are automated to increase efficiency, improve performance and reduce work load. A window based application integrated with automated window services for importing customer’s files and billing information from other server application. Overall the application automates and simplifies business processes running inside the organization and provides more opportunities to analyze and cater changing business requirements.
Roles and Responsibilities:
Actively involved in Analysis, design, development and testing of 3-tier architecture for the application
Using Scrum based project development approach for developing a 3-tier architecture
Database Design and Development involving DB tables, Views, Triggers, Stored Procedures and Functions
Data layer development using ADO.Net, Enterprise Data Access Application Block
Business layer developed based on Façade and singleton design pattern using C#
WinForm based development using C#, Web Services, Grid Control, Combo, Listbox, PanelBar, TabStrip
Involved in of SQL Server CLR based-functions and Bulk importing utility development using SSIS
Responsible for managing iterative and incremental development process
Application deployment and Remote based installation
Environment:
WinForm, Visual Studio 2005, C#, SQL Server 2005, Telerik Grid Control, XML, Xpath, SQL Management Studio, SQL Profiler, SQL Analyzer, GotoMyPC, SQL Server Analyzer, SQL Server Profiler, SQL Integration Services (SSIS)
Project: Booking System (Medical Spa)
Description:
Booking system is a web based application which aims to provide booking and other related facility to people in the Medical spa domain. The application offered management and tracking facilities of clients, services, payroll, employees and inventory records and details.
Roles and Responsibilities:
Scrum based project development and management approach used for developing a 3-Tier application
Analysis and Development of Web based Application using ASP.Net 2.0, VB.Net, AJAX & SQL Server 2005
DB development including table design, Views, Stored Procedure, T-SQL functions and Query Development
Using EasyObject ORM for business and data layer development and integration
Design and develop UI Front-End forms using ASP.Net 2.0, Ajax, Membership, Profiling, Validation controls, Master Pages, CSS and JavaScript for a richer and interactive interface
Web User Control design and development for code reuse and Caching techniques for performance reasons
Microsoft ASP.Net Ajax used for offering faster Searching and paging functionalities
Business related interactive Report generation using (SSRS) SQL Reporting Services 2005
SOAP Web Service development for future enhancements and integration
Actively involved in Application QA, testing and debugging
Source Safe used for version controlling and AceProject for online project management tasks
Environment:
WebForms, IIS, VB.Net, Visual Studio .Net 2005, ASP.NET 2.0, JavaScript, HTML, Web Services, XML, Xpath, T-SQL, ADO.Net, Ajax, SQL Server 2005, SQL Management Studio, SQL Analyzer, SSRS, SQL Profiler, JavaScript, JSON, JQuery, HTML
Project: Loud Click
Description:
LC is a highly scalable content management solution (CMS) that addresses most demanding site development and management tasks. The application allows creating multiple websites easily and offers editing, managing and publishing features for all kind of contents. User Friendly interface, Admin panel, Work Flow engine, Content sharing and branching along with Drag & Drop editing features makes this a very handy tool.
Roles and Responsibilities:
Technical analysis and development of 3-tier application development using scrum based approach
Web based Application development using ASP.Net 1.1, SQL Server 2000, VB.Net, Visual Studio 2003
Involved in development and integration of various modules and business components developed in VB.Net
DB Design and Development including table design, Views, Stored Procedure & T-SQL Functions’ development
Extensive use of SQL Profiling and Query Analysis Tools for T-SQL Query optimization and debugging
DTS packages for email generation to the concern people based on the application business logic
Transaction management at the DB level as well as through ADO.Net Transactions functionality
Integrated Microsoft Enterprise Application Blocks for Data Access, Logging, Exception handling functionalities
Involved in the integration of 3rd party GUI Controls from Telerik for a richer user interface
Web User Control design and development for code reuse, Caching User Controls for performance
Extensive use of XML, XSLT and XPath functionalities and code integration with Telerik Tree & Menu Controls
Extensive use of Visual Source Safe for version control and AceProject for project task management
Mentor new developers ensuring a seamless and timely transition into the larger team
Environment:
WebForms, IIS, VB.Net, Visual Studio .Net 2003, ASP.NET 1.1, SQL Server 2000, SQL Profiler, JavaScript, HTML, Web Services, T-SQL, ADO.Net, CSS, XML, Telerik Editor, Combo, Menu, PanelBar, Splitter, TabStrip, Toolbar & Tree View Control
Project: SOAR (System Output & Archival System)
Description:
S.O.A.R. (System, Output, Archival and Retrieval) is a .Net windows based system which works in collaboration with Adobe Products such as: Adobe Central Server and Adobe Output Designer. It allowed organizations to create personalized documents from legacy systems like AS400, RS6000 etc. and present them in a professional manner which can then be emailed, faxed or printed. The application utilizes Adobe Acrobat Distiller, Adobe Output Designer, Adobe Central and Visual Transformation Editor along with C#, SQL Server 2000 and MS Access.
Roles and Responsibilities:
Translating moc-ups and functional specification documents into design document for development process
Involved in development & extension of application using C#, SQL Server 2000 and Adobe products like Adobe Distiller, Adobe Output Designer, Adobe Central and Visual Transformation Editor
Analysis and Development of DB objects like Tables, Views, Stored Procedures & T-SQL Queries
DTS for gathering data from legacy AS400, Access, RS6000, Excel applications into SQL Server 2000
Extensive use of SQL Profiling and Query Analysis Tools for T-SQL Query optimization and debugging
Development and integration of business and data access components for push and pull strategies
WinForms based application using C#, ADO.Net & reporting services integration
Professional Experience
DataFocal Systems Ltd. (offshore) Apr 2005 – Aug 2005
Lead C#/.Net Developer
Project: SWAT
Description:
SWAT is Point of Sales (POS) software that the retailers use to calculate sales and operate the cash drawer. It’s a window-based application using C# & SQL Server 2000 to help SimplyWireless organization to enhance its IT-operations and streamline the organizations extensive operations.
Roles and Responsibilities:
3-tier application development using Scrum based approach for translating user requirements into workable solution using C# & SQL Server 2005
DB design and development of Tables, Stored Procedures, View and functions
T-SQL Query
Contact this candidate