We provide IT Staff Augmentation Services!

Tech Lead Analyst Resume

SUMMARY:

  • Microsoft .NET & ITIL Certified Professional with management skills having extensive experience in Software analysis and Development, Data warehouse and Business intelligence
  • Around 12 years of IT experience in System Analysis, Design, Development and Implementation of various enterprise e - business solutions and n-tier architectures for various business domain like Banking, Energy, Public service, Ecommerce, Manufacturing, Healthcare
  • Experience in N-Tier Distributed architectures, Client-Server, Object-Oriented and Service oriented architecture styles
  • Creating document using appropriate graphical & textual techniques, including use cases, diagrams, process models, wireframes, functional and technical specifications
  • Making logical design of the system with the technical team, including screen design and specifications, data modeling, and documentation of logical processing flows
  • Experience in Data warehouse architect, development, testing, implementation and support of enterprise data warehouse
  • Using Kimball Data Warehouse Methodologies in data modelling
  • Experienced in development of ETL mapping and scripts
  • Experience in large-scale integration projects using WCF/Web services, database and file exchange
  • Team leadership experience in large scale implementations
  • In-depth knowledge and experience in software design methodologies, software design patterns and object oriented design.
  • Experience with Service Oriented Architecture (SOA). Experience in developing Web API / WCF / Web Services
  • Experience in Traditional & Agile Software Development Methodologies
  • Project management experience including planning, execution, monitoring and closure
  • Worked with pre-sales team on new project proposals
  • Experience in stakeholder management (client, vendor, onsite-offshore and multiple internal teams)
  • Expertise in managing projects in Confidential and Onsite/Offshore delivery model
  • Experienced in MS SQL-Server 2005/2008/2012 (T-SQL) Database design, Development, Data modeling in data warehouse, writing queries, Constraints (Domain and Entity), Indexes (Clustered and Non-Clustered), Views, Stored Procedures, Extended Stored Procedures, LINQ to SQL, SSIS Packages, Cursors, Triggers, User Defined Functions, Migration from MS-Access.
  • Expertise in analysis of current Business Practices and Analysis of current IT Systems and Procedures and Documentation of workflow and Business Process Reengineering
  • Ability to handle projects as t eam player and an individual contributor with steep learning curve and in on application architecture design, assist in developing project plans, and good interpersonal skills.
  • Good knowledge of ITIL processes.
  • Effective communicator adept in delivering superior customer service and bridging the business and technical communities
  • Very Good in Team work

TECHNICAL SKILLS:

BI / Data Warehouse: - WhereScape Red 6.2, Tableau 9.x, Qlik Sense 2.2, SSIS, SSRS, SSAS

.NET: - Framework 2.0/3.0/3.5 / 4.0, WPF, WCF, Web API 2.0,XAML, ADO.NET, Win Forms

Frameworks: - Entity, MVC 3,4,5, IBatis, Dot Net 4.0

Languages: - C, C++, C#.Net (4.5/4.0/3.5/3.0 ), VB.NET (10.0/9.0/8.0 ), HTML, Unix Shell Programming

Modeling Methodology: - UML, Rational Unified Process (RUP), MS Visio 2010/2007

Web: - XML, XSLT, XSD, ASP.NET 4.5/ 4.0/3.5/3.0/2.0, HTML, JSP, HTML, CSS, ASP.Net, IIS, HTML, DHTML, SOAP, AJAX, WPF, Silver Light (4.0/3.0), VB Script, JavaScript, AJAX, JQuery, Bootstrap, OBOUT & Telerik controls.

Middleware: - WCF, ADO.NET 4.0/3.5/3.0/2.0, MSMQ, Web Services, Enterprise Library 5.0/4.0/3.1

Database: - ORACLE 11i, SQL Server 2012/2008/2005/2000, MS Access, LINQ, Stored Procedures, triggers, ADO.Net, SSIS Packages.

Operating Systems: - UNIX Sun Solaris, Red hat Linux, Windows 95/98/2000/7/8, DOS

Tools: - MS Office 2016, Visual Studio, SharePoint 2013, NUnit, Crystal reports

PROFESSIONAL EXPERIENCE:

Confidential

Tech Lead Analyst

Technologies: C#.NET 4.0, LINQ, SSIS, SSRS, Visual Studio, MVC 4.0, ASP.NET, Web API 2.0, XML, SQL 2012, IBatis, TFS, PDFLib, Issue Net, ITSM, Remedy, RUP

Responsibilities:

  • Developing / Modifying the existing application in 3-Tier architecture like Business Layer and Data Layer
  • Followed the Agile programming methodology throughout the entire project life cycle
  • Followed the SCRUM Methodology for small progressive iteration development
  • Analysis of the programs in the existing system
  • Responsible for creating unit, integration, system and user acceptance test plans
  • Involved in reviewing the test cases with the testing coordinators and performing the quality checks
  • Responsible for documenting the defects and assigning the defects to the responsible people
  • Was also involved in tracking the status of the defects on a day to day basis to provide an update to the testing coordinator and the project manager.
  • Preparing technical documents
  • Using the various XML schemas for the interfacing data requirements of the application for transferring information between different teams
  • Creating database objects and modifying them in sql server.
  • Performing program modifications and enhancements with minimal direction
  • Providing impact analysis of proposed business changes on the application, in terms of development effort and processing time.
  • Making business documents like use case scenarios, models, conceptual design diagrams, and user stories to support iterative development
  • Designing, developing and coding for old or new projects in .Net technologies like Confidential (Alberta Mineral Information System), LAMAS, MOGIS, CARS, Foundation, ETS on various issues.
  • Performed Annual Disaster Recovery tests and compiled the results for various projects for analysis.
  • Facilitating requirement meeting for proposed changes with business users
  • Performing detailed analysis of proposed application changes
  • Providing solution to problems arising in the production version of the application

Confidential

Data warehouse Tech Lead

Responsibilities:

  • Analyze the requirement analysis done for the project.
  • Using Kimbell methodologies to design data warehouse DWH and different data marts to support dashboard
  • Using WhereScape Red to create data warehouse
  • Develop the data models to support the data warehouse
  • Designing data marts
  • Developed Stored Procedures and SSIS packages to import data from third party solutions to internal data warehouse
  • Created Unit Test cases for various package and test them.
  • Implemented CDC (change data capture) for inserting and updating slowly changing dimension tables in target for maintaining the history data
  • Setting security for data warehouse
  • Developing ETL processes
  • Coordinating in testing and implementing the project in 3 phase

Confidential

Qlik Sense Tech Lead / Administrator

Technologies: Qlik Sense 2.0, C#.NET 4.0, LINQ, Visual Studio, SSIS, SSAS, SSRS, XML, SQL 2012, and TFS

Responsibilities:

  • Analyze the requirement analysis done for the project.
  • Develop the data models to support the Qlik Sense Interfaces.
  • Developed Stored Procedures and SSIS packages to import data from third party solutions to internal data warehouse
  • Designing the QVDs for the Qlik Sense
  • Developing the graphical objects for the users in Qlik Sense
  • Setting security for QVDs
  • Managing QlikSense QMC experience including installation and upgrades of the Qlik Product
  • Managing QlikSense deployments from QA, UAT and Production
  • Modifying and and maintaining of QMC Security rules and Load Balancing rules
  • Administrating QlikSense multi node environment
  • Coordinating in testing and implementing the project in 3 phase
  • Creating rules and managing virtualization Streams.
  • Managing with QlikSense Confidential and License monitors.

Confidential, Minneapolis

Computer Systems Analyst

Technologies: C#.NET 4.5, MVC 4.0, LINQ, Visual Studio, JQuery, XML, Telerik, SQL 2012, Web API, CSS and TFS

Responsibilities:

  • Analyzing, designing and developing the web application in 3-Tier architecture.
  • Designed the ETL processes and procedures
  • Developed Stored Procedures and SSIS packages
  • Created Unit Test cases for various package and test them.
  • Implementing CDC (change data capture) for inserting and updating slowly changing dimension tables in target for maintaining the history data
  • Coordinating with other developers

Confidential

Computer Systems Analyst

Technologies: C#.NET 4.5, MVC 4.0, SSIS, LINQ, Visual Studio, XML, SQL 2012, TFS, SSRSResponsibilities:

  • Analyzing the requirement and designing the requirements for Data movement between different entities
  • Developed Stored Procedures and SSIS packages
  • Created Unit Test cases for various package and test them.
  • Assisting other developers

Confidential, Minneapolis

Systems Analyst

Technologies: C#.NET 4.5, MVC, LINQ, Visual Studio, JQuery, XML, SQL 2012, ASP.NET, Web API, MVC, AJAX, WCF, WPF, TFS, SSRS, Issue Net, ITSM

Responsibilities:

  • Designing the business requirements for HPA and translating them to technical documents.
  • Making use cases, diagrams, process models, wireframes, functional and technical specifications.
  • Using Entity Framework
  • Creating Unit Test cases for various waterfalls and test them.

Confidential

Designer, Developer

Technologies: C#, ASP.NET, WCF, JavaScript, SQL 2008, SSIS, SSRS, LINQ, XML, AJAX, HTML, TFS, Crystal Reports

Responsibilities:

  • Design, Construction & Maintenance of various modules, reports, forms in the existing system
  • Designed and implemented a front end using ASP.NET and C# & VB.NET using Visual Studio 2010/2008 Framework. Involved the usage of ASP.NET to display data from the backend SQL Server Database
  • Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
  • Responsible for setting and execution of Service Oriented Application systems by following standard testing methodologies
  • Developed and consumed Web Services in C# used for authentication of user.
  • Incident and Problem management
  • Detail Design Documentation for the processes and development for any changes in the existing system.
  • Preparing Task Work Plan, System Enhancement, Client Management, Technical Documentation, providing direction and implementing Application Design changes, Data Preparation & Migration
  • Creating and modifying database objects in sql server.
  • Developing and executing test cases and scenarios and documenting expected and actual outcomes.
  • Designing the various XML schemas for the interfacing data requirements of the application
  • Performing all the possible enhancements and performance analysis

Confidential

Designer, Developer and Administrator

Technologies: ASP.NE, LINQ, VB.Net, Java Script, Silverlight, XML, Sharepoint 2010, SQL 2008, AJAX, Entity Framework, HTML,Crystal reports, TFS, NUnit, SSIS, SSRS, Web API

Responsibilities:

  • Involved in requirements gathering, system analysis, design and development of a custom 3-tier web based system for an validation of sponsorship debt system using ASP.NET, C#, VB.NET, SQL Server, XML, JQuery, JavaScript, XSLT, XPATH.
  • Coding for the e-VOSD Web Front End & e-VOSD Data Loader
  • Responsible in full development life-cycle using Object Oriented Programming (OOPS) concepts. Project plan is done in Microsoft Project Professional 2010.
  • Designed and implemented a front end using ASP.NET and C# $ VB.NET using Visual Studio 2010/2008 Framework. Involved the usage of ASP.NET to display data from the backend SQL Server Database
  • Implemented validations using the ASP.NET Validation Controls
  • Used SSIS to perform ETL operations for Master Data Management (MDM) needs as well as auditing reasons.
  • Extensively Involved in WinForms coding and implementation phase using C#.
  • Involved in designing and development of SOA services using Web Services/ WCF. Consumed and exposed WCF services by deploying in IIS.
  • Conversion of window based application to Web based Application in .Net
  • Design, Construction & Maintenance of input/output Client/Server & Web Interfaces using Menus, Forms
  • Analysis of the programs in the existing system
  • Preparing technical documents
  • Detail Design Document for the Confidential Web Front End & for the Confidential Data Loader
  • Creating and modifying database objects in sql server.
  • Preparing Task Work Plan, System Enhancement, Client Management, Mentoring, Technical Documentation, Technical Support, Providing Direction and Implementing Application Design changes, Data Preparation & Migration
  • Providing production and testing support on rotational basis.
  • Developing and executing test cases and scenarios and documenting expected and actual outcomes
  • Design, Construction & Maintenance of input/output Client/Server & Web Interfaces
  • Designing the various XML schemas for the interfacing data requirements of the application
  • Performing all the possible data validations like operations related to checking dates, checking for valid numbers, out of range values etc.
  • Designing, developing and coding for old or new projects in .Net technologies like Confidential (electronic Validation of Sponsorship Debt) which was to be converted from windows.net to ASP.Net
  • Using knowledge of software development life cycle (SDLC) methodologies, systems analysis, design coding, testing and implementation
  • Supporting MECA (Managing enforcement thru Computerized Assistance) by analyzing various problems, upgrade or maintenance of the same

Confidential

Technical Lead, Systems Analyst and Developer

Technologies.: C#, ASP.NET, MVC, SQL 2008, Sharepoint 2010, XML, LINQ, WCF, AJAX, Crystal Reports, TFS, NUnit

Responsibilities:

  • Project Planning and Effort Estimation, Structured Systems Analysis & Design, Data Modeling, Process Modeling, Data Migration, Query Performance Tuning, SQL Loader, Functional Specifications and Technical Specifications
  • Designed and implemented a front end using ASP.NET and C#.NET that involved the usage of Visual Studio 2005 Framework
  • Implemented forms authentication or administration of role based security using Active Directory.
  • Played a major role in production of SSIS jobs. Used custom .NET assemblies for Script Task in SSIS.
  • Used JavaScript to highlight user selections in the data grid with Dynamic Controls and CSS
  • Involved in Web parts development using HTML, XML, XSLT, and classic ASP and create and process XML documents, including using XML Serialization
  • Written SQL Queries, Stored Procedures, Triggers, Database restoring, Defining roles, creating users, Assigning Roles to users and relational database design(RDBMS) in SQL Server 2005
  • Involved in the development of module using Object Oriented Methodologies like UML.
  • Involved in the deployment of the entire application using Microsoft Internet Information Service (IIS). Involved in EDI process of file transfer between clients
  • Extensively involved in creating the Ajax components fo r multiple updates in datagrids. Used other AJAX library such as Update Panel and Model Popup Extender within some web pages.
  • Performed Unit testing by using Nunit 2.4 Beta1 version and performance tuning of the application by populating and creating indexes in the database.
  • Extensively Involved in WinForms coding and implementation phase using C#.
  • Extensively involved in .Net exception handling management, debugging, user controls in GUI.
  • Prepared project plan using Microsoft Project Plan 2003 and Function Point Analysis
  • Involved in designing and documentation of flows and functional diagrams using Visio 2003
  • Responsible for configuration management (Configuring the Project in VSS, Taking VSS backup)
  • Done unit testing, integration testing and regression testing.
  • Implementing DB issues with regards to Server & Application Tuning and Session Management.
  • Extensively involved in creating the Ajax for making smaller, faster and user friendly web-page application.
  • Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using Crystal reports.
  • LINQ technology was used for all database queries. LINQ to SQL and LINQ to XML
  • Followed the extreme/agile programming methodology throughout the entire project life cycle
  • Designed applications using UML - Modeling by applying Object Oriented Analysis and Design (OOAD)
  • Involved in Unit testing and Integration Testing for the entire system
  • Extensively involved in developing components for Business and Data tier using VB 9.0, ADO.Net
  • Extensively involved in the creation of User Controls and reusable components
  • Written SQL Queries, Stored Procedures, Triggers, Database restoring, defining roles, creating users, Assigning Roles and relational database design (RDBMS) in Microsoft SQL Server 2008
  • Involved in preparation of Cascade Style Sheet (CSS) files
  • Involved in Code review phase
  • Maintained the version of the project by using module developed with latest version in TFS
  • Involved in designing and documentation of flows and functional diagrams using Visio 2010
  • Testing of database, queries optimization
  • Developed an XML- Web Services using RPC
  • Construction and Bug-Fixing Windows Forms, Reports, Menus and Sql Modules
  • Providing impact analysis to management of proposed business changes on the application, in terms of development effort and processing time

Confidential

Technical Lead, Systems Analyst and Developer

Technologies: c#, ASP.NET 3.5, MVC, Java Script, HTML, IIS, SQL Server, SSRS, Crystal Reports, TFS

Responsibilities:

  • Involved in the design and development of the ASP.NET Web Forms using HTML, JAVA SCRIPT, ASP.NET Server Controls, AJAX Control Toolkit and TELERIK Controls
  • Used partial-page update support to a Web page by using Microsoft ASP.NET 2.0 AJAX Extensions server controls: the Script Manager control and the Update Panel control to remove the requirement to refresh the whole page with each post back, which improves the user experience
  • Involved in calling WEBSERVICE methods from client side by using AJAX concepts
  • Worked on WinForms
  • Worked to Retrieve Data from XML File by using XML Reader and DOM methods
  • Extensively worked on User Controls to create Widgets used on the Web page and the Widget Settings can be changed by Edit Click by using User controls.
  • Involved in database design and developed Complex Queries, Stored procedures and Triggers in SQL Server.
  • Worked on Developing Data Access Layer by using C# and OOP Concepts
  • Extensively used ADO.NET with the SQL Server Database
  • Worked on Application, Session Objects and View State
  • Worked with ASP.NET Server Controls, Validation controls and with Data Controls
  • Used .NET remoting to transfer data between different
  • Prepared Test Plans at Unit level and System level
  • Analysis of the existing system and Preparation of analysis and technical specification documents
  • Conducted Load Testing and Performance Testing before major website/database updates
  • Directions, presentations and Discussions with the Client Technical Authority regarding the Project Architecture, Project Standards, Project Plan and Project Progress
  • Structured Systems Analysis & Design, Impact Analysis, Data & Process Modeling, Data Migration, Effort Estimation, Query Performance Tuning, Interface Development, Migration of Users, Privileges and Profiles
  • User Requirement Analysis, Impact Analysis, Design, Development, Modification and Performance Tuning of existing application), Warranty Support, Application Support, Project Management, Business Development and Client Management
  • Design, Construction & Maintenance of input/output for Client/Server & Web Interfaces using Menus, Forms & Crystal Reports.
  • Preparing Task Work Plan, System Enhancement, Client Management, Mentoring, Technical Documentation, Technical Support, Providing Direction and Implementing Application Design changes, Data Preparation & Migration
  • Creating and modifying database objects in SQL server.

Confidential

Technical Lead, Systems Analyst and Coding

Technologies: C#, ASP, .NET 3.5, Java Script, HTML, SQL Server, Windows 2000, TFS, Crystal Reports, NUnit

Responsibilities:

  • Analysis of the C# program in the existing system and Preparation of analysis and technical specification documents
  • Used N-tier architecture for presentation layer, Business and Data Access Layers and were coded using C#
  • Developed application logic using C#
  • Designed and implemented a front end using ASP.NET and VB.NET & C#.NET.
  • Involved in Screen Designing for Prototyping approvals
  • Developed Web User Control, which can display Current Date, Current User in uniform way in all Web Forms
  • Involved in Developing Business layer using C#.NET
  • Extensively Used Grid View, Form View, Detail View Controls with Object Data Source Controls.
  • Implemented Master Pages and Tree View Control with Site Map Data Source
  • Implemented Data Access Layer in New Manner with Table Adapters
  • Involved in writing Stored Procedures using SQL SERVER 2000
  • Played a major role in developing SSIS jobs
  • Used custom .NET assemblies for Script Task in SSIS
  • Created prototype and production-level object-oriented application including design, modeling, coding, and testing
  • Developed stored procedures, functions and triggers using PL/SQL in SQL Server
  • As a member of the development team, I was responsible for executing the test cases and documenting the test results. Involved in maintenance and production support
  • Structured Systems Analysis & Design, Impact Analysis, Data & Process Modeling, Data Migration, Effort Estimation, Query Performance Tuning, Interface Development, Migration of Users, Privileges and Profiles
  • Creating and modifying database objects in sql server
  • Extensive use of both Forward & Reverse Engineering (E-R Modeling, Server Modeling, Design Editor)
  • Directions, Presentations and Discussions with the Client Technical Authority regarding the Project Architecture, Project Standards, Project Plan and Project Progress
  • Preparing Task Work Plan, System Enhancement, Project Management, Client Management, Mentoring, Technical Documentation, Technical Support, Providing Direction and Implementing Application Design changes, Data Preparation & Migration

Confidential

Functional Lead, Tech. Lead, Module Lead and Code Developer

Technologies: C#, .NET 2.0, COM, Java Script, ASP, SQL Server, Windows 2000, Crystal Reports

Responsibilities:

  • Created and maintained Databases, Table spaces, Data files, Redo Log Files, Alert Log files and Rollback Segments. Conducted Backup and Recovery and also constructed and managed the User Schemas
  • Used N-tier architecture for presentation layer, Business and Data Access Layers and were coded using C#
  • Developed application logic using C#
  • Created prototype and production-level object-oriented application including design, modeling, coding, and testing
  • Developed stored procedures, functions and triggers in SQL Server
  • Followed Client IT Department’s Proprietary Structured SDLC Standards & Methodology, which was based on ISO Guidelines
  • Enhancement (Effort Estimation, Work Plan Preparation, User Requirement Analysis, Impact Analysis, Data & Process Modeling, Development, Modification and Performance Tuning of the existing application), System Integration, System Testing, Application Support, Mentoring, Project Management, Business Development and Client Management
  • Extensive use of Web Forms in both Forward & Reverse Engineering (DFD, E-R Modeling, Server Modeling, Design Editor)
  • Preparation of Test Plans, Test Data and Test Cases for Unit, Integration, System and User Acceptance Testing
  • Preparation and updating Functional and Technical Design Documents and also User Manuals
  • Providing impact analysis of code changes on the application, in terms of development effort and processing time

Confidential

Functional Lead, Technical Lead, Code Developer

Technologies: VB, SQL Server 2000, Crystal Reports

Responsibilities:

  • Creation of Application Schema, Application Database, Transaction Log, User Privileges, Database Backup, Database Recovery and Database Administration
  • Used N-tier architecture for presentation layer, Business and Data Access Layers and were coded using VB.
  • Requirement Analysis, SSAD, Data & Process Modeling, Construction, System Integration, Implementation,, Project Plan, Work Estimation and Client Management
  • Designing and Coding the front end of the application
  • Created prototype and production-level object-oriented application including design, modeling, coding, and testing
  • Developed stored procedures, functions and triggers using SQL Server
  • As a member of the development team, I was responsible for executing the test cases and documenting the test results.
  • Involved in maintenance and production support
  • Creating and modifying database objects and Data conversion done in SQL server.
  • Providing impact analysis of code changes on the application, in terms of development effort and processing time

Sr. Programmer

Confidential

Technologies: VB, Oracle, Crystal Reports

Responsibilities:

  • Analysis of the existing system and Preparation of analysis and technical specification documents
  • Coding using VB, ORACLE
  • Analysis of the reports generated in Business objects and Preparation of technical specification documents.
  • Program Analysis
  • Program Specification Document preparation
  • Unit Testing

Developer, tester

Technologies: Visual Basic, Oracle, IBM Server, Windows

Responsibilities:

  • Coding and modification using VB as front end and Oracle at backend
  • Designing and Coding reports for the presentation purposes on a weekly basis.
  • Preparation of Test Plans, Test Data and Test Cases for Unit, Integration, System and User Acceptance Testing
  • Checking modules functionality

Hire Now