Technical Lead And Database Owner Resume
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
