We provide IT Staff Augmentation Services!

Technical Lead And Database Owner Resume

3.00/5 (Submit Your Rating)

Los Angeles, CA

SUMMARY

  • Technical Lead, Certified Scrum Master (CSM), with 13 years of experience in developing, defining, driving, and delivering diverse technology projects to fulfill business strategies in major industry verticals.
  • 6 years of experience as a Technical Leader coordinating development among offshore, on - site teams and vendors.
  • Hands-on experience in developing Enterprise level web-applications using Microsoft technologies including .Net Frameworks, ASP.Net MVC, C#, VB.Net, ADO.Net, Entity Framework, LINQ, RESTful Web API, JavaScript, JQuery, Ajax, WCF, Web services, Windows Application, ASP.Net Web-Forms, Microsoft SQL Server, SSIS & SSRS, IIS
  • Experience in developing web-application using AngularJS, .Net Web APIs, HTML5, Bootstrap, CSS3
  • Experience in developing WPF MVVM based application
  • Proficient in SQL. Experienced in writing Views, Stored Procedures, Functions, Cursors, creating ER Diagrams relational database MS SQL Server
  • Experience in SQL Performance Tuning, Handling Indexes, and Query Optimization
  • Experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS)
  • Hands-on experience using NoSQL Elastic Search for Full-Text and high-performance Search capabilities
  • Expertise in generating reports using SQL Server Reporting Services (SSRS) and Crystal Reports
  • Strong Problem Solving and Technical Skills combined with confident decision making for enabling effective solutions, leading to delivering the project on time with high customer satisfaction and stakeholder delight.
  • Experience in Implementation and production deployment activities
  • Experienced as a Scrum Master - Daily scrum, Backlog grooming, sprint planning, release planning, driving product demos for client/stakeholders
  • Articulate, confident communicator; able to successfully build strong working relationships with coworkers. Working closely with Developers, Architect, Testers, UI designers, DBAs to promote a good working environment
  • Adept requirements modeler who can scope business requirements, and align business goals with technology solutions, hands-on with creating wireframes, writing user stories, Use Cases, Sequence Diagrams, Class Diagrams, Technical Design Document
  • Experience with Software Development Processes & Models: Agile/Scrum and Waterfall

TECHNICAL SKILLS

Web Technologies: AngularJS with .Net WebAPI ASP.Net 4.5/4.0/3.5/2.0/1.1, MVC, C#, VB.Net, Entity Framework, REST APIs, JSON, XML, Web Services, AJAX, WCF, WebForms

Windows Application: WPF using MVVM, WinForms, Integrating hardware devices like Card-Reader, RFID, Receipt Printer

Programming languages: C#, VB.Net, ADO.Net

Database: Design and Development with Microsoft SQL Server 2012/2008/2005, 2000 and ElasticSearch

Business Intelligence, Reporting: SSIS, SSRS, Crystal Reports

UI, Scripting: HTML5, CSS3, Bootstrap, JavaScript, JQuery

Tools: Visual Studio 2013/2012/2010/2008, TFS for Version Control, TeamCity for Continuous Integration, Rally for User Stories and Test Cases, Microsoft Project, Axure for wireframes, Git

Web Servers: IIS 7.5 with windows 2008/2012/Win7

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Technical Lead and Database Owner

Responsibilities:

  • Driving development activities - working closely Technical Architects and Team for Development, Task Breakdown, Effort Estimations, developing POC solution, driving technical discussions
  • Development with AngularJS, .Net RESTful WebAPI using C#
  • Code-Reviews, Implementing Error-handling, logging, Entity Framework, Session management, Internationalization, Custom Routing, Internationalization
  • Developed Full-Text Search module with NoSQL ElasticSearch Dynamic query generation using NEST API
  • Database design and development - ER Diagrams, creating Tables, Views, Stored Procedures and Functions, Indexes, SQL Profiler
  • Scrum master for the team. Execution and Reporting with Agile methodology - Sprint Planning and execution, Daily Scrum, Managing releases, biweekly Product Demos
  • Working closely with product owner for Clarifications, User Story and Backlog Refinement, Defect Triaging
  • Overseeing Builds and Deployments, working closely with DBAs and other IT infrastructure teams to find out deployment issues
  • Used Team Foundation Server TFS for version control, Branching and Merging

Environment: AngularJS, .Net RESTful WebAPI, C#, SQL 2008, Elastic Search, JQuery, Entity-Framework.

Confidential, Houston, TX

Technical Lead

Responsibilities:

  • Lead the Development team in developing the Web Application using ASP.Net MVC
  • Creating Technical Design Document
  • Using various JavaScript libraries for Form-Validations, Pop-up Notifications
  • Work with Developers and Designers to create Responsive UI using HTML5, Bootstrap, Media queries and CSS3
  • High-Level Task-Breakdown, Effort-Estimations, assigning Tasks/Bugs, Code-Reviews
  • Database design and development - ER Diagrams, creating Tables, Views, Stored Procedures and Functions, Indexes, SQL Profiler
  • Used Team Foundation Server TFS for version control, Branching and Merging
  • Scrum master for the team
  • Driving sprint reviews / product demos
  • Working closely with product owner for Clarifications, User Story and Backlog Refinement, Defect Triaging
  • Overseeing Builds and Deployments, working closely with DBAs and other IT infrastructure teams to find out deployment issues

Environment: ASP.Net MVC 4, C#, SQL server 2008, JQuery, HTML, XML, Team Foundation Server, Rally, IIS 7.5, Visual Studio 2012, Rally

Confidential, Houston, TX

Technical Lead

Responsibilities:

  • Develop a C# utility to load data from staging SQL DB to CouchBase
  • Reviewing and Developing SQL scripts used for extract & transform data
  • Reviewing SSIS package for populating Staging DB
  • Monitoring/developing/Reviewing SSRS reports used for ETL progress - Critical Data Error Check report, Staging Data Viewer report
  • Working closely with Central Technical Transition team in UK to implement ETL solution
  • Providing technical help to SQL Developers and discussing functional transition rules
  • Working with Product Owners for understanding Data-Transition Business Rules, Data Transformation/Cleansing/Anomaly rules
  • Leading and executing ETL Dry Runs and production runs
  • CouchBase database administration, owner of multiple Transition environments

Environment: C#, SQL 2008, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, NoSQL CouchBase

Confidential, Houston, TX

Tech Lead and Database Owner

Responsibilities:

  • Developing modules like Back-office CRM, Buyer Search, Subscription management, Communication management, RFI, Audits etc using C#, ASP.Net 3.5, JQuery, HTML, CSS
  • Developing scheduled background jobs for communication/Subscription Renewals using Quartz Scheduler and Windows Services
  • Assigning tasks to team members and providing technical help
  • Reviewing task breakdown, Sequence flow diagrams, Class diagrams
  • Database Owner - Maintaining ER diagrams, Designing or approving schema changes
  • Performance tuning of SQL Stored Procedures with DBAs, creating Indexes, covering indexes, database obfuscation scripts
  • Modifying SSIS package to integrate new functionality in Cube Search DB
  • Creating and Merging Branches in TFS
  • Dev. SPOC for Production Releases - Working closely with Release Manager, Build Engineer, DBAs and Network/Server support teams to configure Environments, MSBuild files, IIS configuration like Permissions, Session management, URL rewriting, WebConfig edits
  • Working closely with Product Owners / BAs / other stakeholders over webex/emails/meetings to understand requirements

Environment: C#, Asp.net 3.5, MVC, JQuery, ADO.Net, LINQ, SQL 2008, TeamCity, TFS, Windows Services, Quartz Scheduler

Confidential

Tech Lead / WPF Developer

Responsibilities:

  • Work with Technical Architect to define System architecture.
  • Develop WPF based modules using MVVM architecture - observable collections, command binding, two way data binding, Delegates
  • Develop ASP.Net based CMS web application for managing Products, prices, discounts, orders and MIS reports
  • Designing WPF GUI, writing custom animation storyboards for UI Elements
  • Work closely with client for requirements definition and weekly demos
  • Design and Develop SQL dependency for communication between multiple devices like Customer Kiosk, Kitchen Display and Operator Kiosk.
  • Integrate Thermal Receipt Printer, Bar-code Printer, RFID Reader, Bar-code Scanner, and Chip&Pin-pad using their APIs through RS-232 and USB interfaces
  • Unit Testing
  • Deployment and Dry-runs for integration testing

Environment: WPF, C#, Asp.net 3.5, JavaScript, SQL 2008, SQL Dependency, ADO.Net, LINQ

Confidential

Senior Developer

Responsibilities:

  • WPF C# development with 3-Tier architecture
  • Writing WCF services
  • Database design using SQL server 2005
  • Error handling and logging
  • Writing Stored Procedures to implement business logic
  • Developing reports in SSRS
  • Bug fixing & production support

Environment: Windows presentation Foundation WPF, C#, Windows Communication Foundation WCF, SQL 2008, SSRS

Confidential

Senior Developer

Responsibilities:

  • Development using Microsoft .Net technologies - Asp.Net 2.0, Webforms, VB.Net, JavaScript
  • Unit testing, documentation
  • Database design and Index Tuning, Writing Complex Stored Procedures for Reports, SQL Transactions, and Cursors
  • Implementing Snapshot and Transactional SQL Server replication for applications deployed at different locations
  • Production app-support and deployment activities
  • Working closely with the client as a Technical consultant for analyzing new requirements and reports
  • Create and maintain Database backup schedules
  • Develop Crystal reports for Invoice, Sales, Orders, Stock and other MIS reports

Environment: Asp.net web-forms 2.0, VB.Net, SQL Server 2005, Crystal Reports, JavaScript, IIS 6, Visual Studio, Windows 2003, VSS

Confidential

Developer

Responsibilities:

  • Implement business functionality to track and manage Inquiries, Sales, Orders, Purchase Orders using VB.Net, ASP.Net
  • Database design and development with SQL server
  • Build Deployment on web-servers with IIS
  • Crystal Reports and other web-reports

Environment: Asp.net 2.0, VB.Net, SQL 2005, Crystal Reports, JavaScript, IIS 6, Visual Studio, VSS

We'd love your feedback!