Programmer Analyst Resume
Pittsburgh-pennsylvaniA
SUMMARY
- A Full Stack Developer with 8+ years of extensive experience through the entire Software Development Life Cycle. Analysis, Design, Development and Testing of Client - Server and Web-based n-tier Architecture for Windows and Web Applications.
- Good Implementation knowledge in Microsoft .NET Technologies.
- Analysis, Design, Web Development and Application Development, Testing and Implementation of internet applications using C#, ASP.NET, ADO.NET, WCF, XML, XHTML, Web Services.
- Experience in Website design, hosting, configuration, IP Address scheme, Policies, security issues, administration, updating.
- Experience in Internet, Intranet, and 2-tier / 3-tier client/server applications.
- Strong at database designing using SQL Server 2000/2005/2008/2008 R2/2012, MySQL and MS Access.
- ASP.NET web development for applications with ASP.NET MVC with Razor, classic ASPX, jQuery, Microsoft AJAX, and XML/XSLT.
- Used Test Driven Development, Agile/SCRUM in a fast changing environment.
- Familiar with C# 2.0/3.0/3.5/4.0/4.5 .
- Experience in designing and developing reports using Tableau.
- Experienced in the implementation of Web Applications, Windows Applications using C# & .NET Framework Class Libraries, Web Services using SOAP XML, WCF.
- Experience in REST (XML, JSON) and SOAP Web Services development using ASP.NET, Web API, and WCF.
- Experience in developing rich, uniformed User Interface using CSS, AJAX, Web parts, JQuery, Mobile JQuery.
- Knowledge of installation, configuration & implementation of MongoDB.
- Implemented processes to automate File Management using Python Scripting.
- Implementation knowledge of architecture at all layers using design pattern (MVVM) in WPF.
- Developed system services SOA application platform for use by all web applications utilizing WCF services.
- Project Configuration Controller for more than 2 years.
- Implemented Web Services to integrate the client systems using WCF.
- Developed and consumed WCF Services to achieve Service Oriented Architecture (SOA) and communication between heterogeneous applications.
- Developed WinForms user interface projects with initial layout and base controls.
- Expertise in WinForms application development using C#, ADO.NET, WPF.
- Analysis, Design, web development and application development, Testing and Implementation of internet applications using ASP.NET MVC & MVP.
- Knowledge of Windows Azure Cloud platform utilizing Cloud Services & Amazon Web Services.
- Knowledge of installation, configuration & implementation of Java Hibernate.
- Strong knowledge in SSIS and SQL Server Reporting Services (SSRS).
- Worked with .NET Server Controls like Data Grid/Grid View, Data List, List View, Repeater Control, etc. to retrieve the data from the database and display it to the user. Used various features of these controls like Paging, Sorting, Editing and created dynamic user controls.
- Experience in designing and developing reports using Crystal Reports.
- Extensive experience in SQL Server Database design, Database maintenance, developing Stored Procedures and Triggers (PL/SQL and T-SQL (Transact-SQL) using MSSQL and MySQL.
- Experienced in HTML, ASP. Net, CSS (Cascading Style Sheets), XML, XSL, XSLT, XPath, Master Pages and Java Script.
- Knowledge of installation, configuration & implementation of Java Spring MVC.
- Experience with ASP.NET and its components: AJAX, Entity Framework, ASP.NET Providers and Typed Datasets.
- Extensive experience in Database Modelling Concepts, Query Building and Running Database.
- Used versioning tools Microsoft Team Foundation Server (TFS), TortoiseSVN and Visual Source Safe (VSS) for version controlling of the Application.
- Worked extensively in resolving the problem logs and defects logged by testers and business people in the .NET applications.
- Hands on experience in Unit testing, Integration testing & Functional testing.
- Extensive experience in documentation of business requirements and system functional specifications.
- Utilized a combination of business knowledge, technical skills, and strategic analysis to provide solutions and creative insights to critical, business problems.
- Effective in multitasking and effective management of assignments according to work schedules with strong project management orientation.
- Good team player with excellent communication and interpersonal skills and ready to learn new concepts.
- Participated in the development of overall test strategies/test plans for manual testing including definition of test cycles and schedules.
- Installing and maintaining SQL Server database systems. Maintaining the database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
- Coordinating with the Systems Administration team, install and maintain approved application software and systems.
- Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
- Migrating application code and objects from Development/Test environments to production.
- Working with development and systems teams to perform application and database tuning.
- In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
- Migrating Databases from SQL Server 2005 to SQL Server 2012.
- Setup and maintenance of appropriate database and application monitoring.
- Review of physical and logical database design; Promote the reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
- Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
- Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005 and SQL Server 2012.
- Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
- Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
- Monitored and modified Performance using execution plans and Index tuning.
- Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
- Responsible routine DBA jobs like Backups and Restores.
- Basic knowledge of Teradata.
- Primarily responsible for Client's Requirement Analysis, Design which includes logical, Coding, Testing & peer code review, effort estimations.
- Shouldering the onus of writing the data access and business logic classes.
- Efficiently handling a team and responsible for delegating work to the team members, monitoring team performance through timely feedbacks, thereby, ensuring overall team productivity and quality.
- Entrusted with the task of managing the entire specialty regarding technical issues.
- Interacting with the team members for the mutual benefits in the project while interacting with the customers\ Confidential on their projects for providing technical advises & feedbacks, creating high-level requirements report and gap analysis during the development phase.
- Evaluated the specifications provided by the client while managing design & development.
- Gathering requirements from client design and propose new solutions depending on the requirements.
- Involved in Code, Design Document & Unit Test Plan Review.
- Proven ability to work as a team player as well as an individual. Excellent Interpersonal and Communication skills, coupled with strong technical and problem solving capabilities.
- Proven record of working in both small and big teams under stringent timing constraints and ability to deliver on time.
- Good analytical and problem solving skills with Technical expertise on .NET/Java Technologies.
- Functional domain experience involves Tax Credit & Incentives, Media & Entertainment, Medical Suppliers, Shipping and Forwarding, Automobile Dealership Companies, etc.
TECHNICAL SKILLS
Languages: C#, Java, PHP, Python, SQL, NoSQL.
Scripting Language: Java Script, JQuery, JQuery Mobile, VBScript.
RDBMS: MongoDB 3.2.4, Teradata, Oracle 11g, SQL Server 2000/ 2005/2008/2012 MySQL 5.0.
Web Technologies: ASP.NET, ASP.NET MVC, SOAP Web Services, REST (JSON, XML) WCF Services, CSS, HTML, XML, XSL, XSLT, XPath.
IDE: Visual Studio 2005/2008/2010/2012 /2013 , Python IDLE, Tableau Desktop, Teradata Studio, WAMP, Dreamweaver, Microsoft Access/Excel/PowerPoint/Visio/Word.
Tools: & Utilities: Photoshop CS3/4/5, Macromedia Flash 8.0, SWF Decompiler.
Application Servers: IIS 5.1/6.0/7.0, Apache 6.0.
Operating Systems: UNIX, Windows 98/2000/NT/XP/7/8.
Framework: .NET Technologies 2.0/3.0/3.5/4.0/4.5 .
Microsoft Technologies: Windows Application, ASP.NET, ASP.NET MVC, C#.NET, ADO.NET.
Business Intelligence: SSRS 2005/2008/2012 , SSIS 2005/2008/2012 .
Reporting: Tableau 9.0.1, Crystal Reports.
Version Management: TFS, VSS, SVN.
PROFESSIONAL EXPERIENCE
Confidential, Pittsburgh-Pennsylvania
Programmer Analyst
Environment: C#, ASP.NET MVC 3.0, .NET 4.0, REST (JSON), WCF, Tableau ReportsMSSQL 2008 R2, MongoDB, Python.
Responsibilities:
- Involved in the complete Software Development Life Cycle including Analysis, Design, Implementation, Testing and Maintenance using Agile methodology with daily scrums.
- Responsible for applications development in an enterprise architecture environment within .NET framework using C#.
- Designed and developed various classes, interfaces and modules to construct the business logic and data access layer using C#.
- Extensively involved in developing components for Business layer and Data Layer, implementation using C# in ASP.NET MVC architecture.
- Web Form design in ASP.NET using CSS, Server Controls, JavaScript and coding using C#.NET.
- Implemented Web Services using C# to integrate the client systems using WCF.
- Developed and consumed WCF Services to achieve Service Oriented Architecture (SOA) and communication between heterogeneous applications.
- Developed and created a custom JavaScript library that could be used for Tableau Reporting. The library is basically a framework that supports Tableau Reports within HTML pages.
- Extensively worked with Tableau JavaScript API.
- Implemented design patterns to support the system features using C#.
- Created various database objects (tables, indexes, views, stored procedures and triggers) and implemented referential integrity constraints for enforcing data integrity and business rules
- Successfully migrated data between different heterogeneous sources such as flat file, Excel, Oracle, Teradata and SQL Server using SSIS.
- Involved in writing Python scripts for File Management.
- Conducted Requirement Analysis for Enhancements in the Application.
- Modifying existing Stored Procedures for Performance Improvement.
- Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
- Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts.
- Created reports that were a part of the major dashboards using Tableau.
- Worked on the Reports module of the project as a developer using Tableau & MS SQL Server 2008 (using SSRS, T-SQL, scripts, stored procedures and views).
- Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
- Worked on all phases of data mart development lifecycle, from gathering requirements to testing, implementation, and support.
- Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), DataStage and ETL package design, and RDBM systems like SQL Servers, Oracle, and DB2.
- Strong leader with experience training developers and advising technical groups on ETL best practices.
- Designed, developed and deployed reports in MS SQL Server environment using SSRS 2008 R2.
- Used TFS (Team Foundation Server) for version control and to maintain the updates.
- Interaction with the business for requirement understanding, follow ups & approvals.
Confidential, St.Louis-Missouri
Technical Analyst
Environment: ASP, ASP.NET MVC 2.0, MVP, Windows Application, XML, WCF, JS/JQuery.NET 3.0/3.5/4.5
Responsibilities:
- Participated in Design reviews, Architecture reviews, Code Reviews and proposed solutions to the business problems.
- Designed and developed business layer & data access layer which would connect to various databases for various groups.
- Programmed Data Access Layer using ADO.NET which involved in accessing data from the Database using Connected Architecture which requires the strong OOPS concepts in C#.
- Web Form design in ASP.NET using CSS, Server Controls, JavaScript and coding using C#.NET.
- Object oriented technology was extensively used for developing re-usable components using C#. Net.
- Extensively involved in developing components for Business layer and Data Layer, implementation using C# in MVC architecture.
- Implemented Web Services using C# to integrate the client systems using WCF.
- Developed and consumed WCF Services to achieve Service Oriented Architecture (SOA) and communication between heterogeneous applications.
- Conducted Requirement Analysis for Enhancements in the Application.
- Designed, developed and Implemented the application using WinForms,Visual Studio C#, ADO.NET using MS SQL Server ver. 2008 R2.
- Modifying existing Stored Procedures for Performance Improvement.
- Creating database scripts to monitor backend activities.
- Creating Tables and writing Queries, Stored Procedures using SQL Server 2008.
- Implementing n-tier Architecture at all layers.
- Involved in developing web Pages with rich UI, AJAX, and JQuery using ASP.NET.
- Writing Classes & Internal functionalities, Core business logic.
- Analyzed business requirements and defined the Object Oriented solutions.
- Client side validation is done by Ajax.
- Used JavaScript/JQuery to create dynamic client side validations and improved UI experience on the client side.
- Used TFS (Team Foundation Server) for version control and to maintain the updates.
- Interaction with the client for requirement understanding, follow ups & approvals.
Confidential, California
Technical Lead
Environment: .NET Framework 2.0/3.0/3.5/4.0/4.5
Responsibilities:
- Involved in setting up the Application Environment.
- Worked with different teams to setup the hardware and software required to setup the environment.
- Analysis for MSSQL Migration from SQL 2005 to SQL 2012.
- Analysis for SSRS Migration from SSRS 2005 to SSRS 2012.
- Analysis for SSIS Migration from SSIS 2005 to SSRS 2012.
- Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
- Migrating application code and objects from development/test environments to production.
- Working with development and systems teams to perform application and database tuning.
- In conjunction with development teams, define and maintain database and code standards and naming conventions for the organization to ensure consistency in database and code development.
- Identify servers that needed to be upgraded/migrated/decommissioned.
- Compatibility & Migration related Issue Fixing.
- Interaction with the client and other vendors for migration related activities, follow ups & approvals.
- Used TFS (Team Foundation Server) for version control and to maintain the updates.
Confidential, California
Technical Lead
Environment: .NET Framework 3.5/4.0, JSON, WCF.
Responsibilities:
- Involved in Architecture & UI Design.
- Responsible for applications development in an enterprise architecture environment within .NET framework using C#.
- Interacting with the team members for the mutual benefits in the project while interacting with the customers\ Confidential on their projects for providing technical advises & feedbacks, creating high-level requirements report and gap analysis during the development phase.
- Designed and developed various classes, interfaces and modules to construct the business logic using C#.
- Implemented design patterns to support the system features using C#.
- JSON WCF Service development using C#.NET
- Programmed Data Access Layer using ADO.NET which involved in accessing data from the Database using Connected Architecture which requires the strong OOPS concepts in C#.
- Evaluated the specifications provided by the client while managing design & development.
- Gathering requirements from client design and propose new solutions depending on the requirements.
- Developed system services SOA application platform for use by all web applications utilizing WCF services.
- Involved in Code, Design Document & Unit Test Plan Review.
- Conducted Analysis Performance Improvements.
- Involved in setting up the Application Environment.
- Writing Classes & Internal functionalities, Core business logic.
- Creating Tables and writing Queries, Stored Procedures.
- Used TFS (Team Foundation Server) for version control and to maintain the updates.
- Interaction with the client for requirement understanding, follow ups & approvals.
Confidential, California
Technical Analyst
Environment: C#.NET, Windows Application, XML, WCF, .NET Framework 2.0, .NET 3.0
Responsibilities:
- Primarily responsible for Client's Requirement Analysis, Design which includes logical, Coding, Testing & peer code review, effort estimations.
- Responsible for applications development in an enterprise architecture environment within .NET framework using C#.
- Shouldering the onus of writing the data access and business logic classes.
- Designed and developed various classes, interfaces and modules to construct the business logic using C#.
- Efficiently handling a team and responsible for delegating work to the team members, monitoring team performance through timely feedbacks, thereby, ensuring overall team productivity and quality.
- Designed and developed data access layer, which would connect to various databases for various groups using C#.
- Entrusted with the task of managing the entire specialty regarding technical issues.
- Implemented Multithreaded programming using C#.
- Implemented design patterns to support the system features using C#.
- Programmed Data Access Layer using ADO.NET which involved in accessing data from the Database using Connected Architecture which requires the strong OOPS concepts in C#.
- Interacting with the team members for the mutual benefits in the project while interacting with the customers\ Confidential on their projects for providing technical advises & feedbacks, creating high-level requirements report and gap analysis during the development phase.
- Evaluated the specifications provided by the client while managing design & development.
- Gathering requirements from client design and propose new solutions depending on the requirements.
- Developed WinForms user interface with initial layout and base controls.
- Designed, developed and Implemented the application using WinForms, Visual Studio C#, ADO.NET using MS SQL Server ver. 2005/2012.
- Extensive usage of Delegates and Events to establish communication between theWinForms using C#.
- Involved in Code, Design Document & Unit Test Plan Review.
- Involved in Onsite Business & Technical Knowledge Transition to Offshore.
- Involved in setting up the Application Environment.
- Conducted Requirement Analysis for Enhancements in the Application.
- Involved in application design and development.
- Involved in Application Level Bug Fixing.
- Writing Classes & Internal functionalities, Core business logic.
- Creating Tables and writing Queries, Stored Procedures.
- Modifying existing Stored Procedures for Performance Improvement.
- Creating database scripts to monitor backend activities.
- Involved in enhancing the application for Confidential requirement based on the market demand.
- Involved in developing the requirement with C# 2.0 and WCF
- Unit testing, system testing and release management.
- Involved, working on database scripts, Store Procedures, View, Indexes and Functions in SQL server 2005.
- Project Configuration Controller for more than 2 years.
- Involved in Project Level Audits - Internal/External.
- Utilize and worked on Source/Version control Tools using with the TFS and SVN, validate the change sets /code changes, apply the Labeling, Check-in/Out and etc.,
- Involved in TFS and Agile implementation.
- Involved in application release and responsible for defect free migration in different environments.
- Responsible for identifying the repetitive problems in application and come up with the solutions to fix them.
- Responsible for production support and maintenance of the various releases.
- Responsible and performing up to the client expectation in all aspect of project development.
- Interaction with the client for requirement understanding, follow ups & approvals.
Confidential
Team Member
Environment: C#.NET, ADO.NET, WPF, .NET Framework 4.0.
Responsibilities:
- Conducted Requirement Analysis for the Application.
- Database Architecture design.
- Creating Tables and writing Queries, Stored Procedures.
- Implementing n-tier Architecture at all layers using design pattern (MVVM).
- Programmed Data Access Layer using ADO.NET which involved in accessing data from the Database using Connected Architecture which requires the strong OOPS concepts in C#.
- Designing the User Interface using WPF.
- Writing Classes & Internal functionalities, Core business logic.
- Utilized and worked on Source/Version control Tools using VSS.
- Involved in TFS and Agile implementation.
- Involved in application release and responsible for defect free migration in different environments.
- Responsible for identifying the repetitive problems in application and come up with the solutions to fix them.
- Responsible for production support and maintenance of the various releases.
- Responsible and performing up to the client expectation in all aspect of project development.
Confidential
Team Member
Environment: ASP.NET 3.5, C#.NET, ADO.NET, SOAP Web Services, JavaScript, HTML, XMLXSL, XSLT
Responsibilities:
- Gathering Requirement for the whole application.
- Database Architecture design.
- Involved in enhancing the application for Confidential requirement based on the market demand.
- SOAP Web Services development using ASP.NET.
- Unit testing, system testing and release management.
- Involved, working on database scripts, Store Procedures, View, Indexes and Functions in SQL server 2008.
- Modifying existing Stored Procedures for Performance Improvement.
- Creating database scripts to monitor backend activities.
- Involved in enhancing the application for Confidential requirement based on the market demand.
- Developed Cascading Style Sheets (CSS) for User Interface uniformity throughout the application.
- Interaction with the client for requirement understanding, follow ups & approvals.
Confidential
Team Member
Environment: ASP.NET 3.5, C#.NET, ADO.NET, JavaScript, HTML, XML, XSL, XSLT
Responsibilities:
- Gathering Requirement for the whole application.
- Database Architecture design.
- Creating Tables and writing Queries, Stored Procedures.
- Developed Cascading Style Sheets (CSS) for User Interface uniformity throughout the application.
- Creating Tables and writing Queries, Stored Procedures.
- Unit testing, system testing and release management.
- Involved, working on database scripts, Store Procedures, View, Indexes and Functions in SQL server 2008.
- Modifying existing Stored Procedures for Performance Improvement.
- Creating database scripts to monitor backend activities.
- Implementing n-tier Architecture at all layers.
- Designing the User Interface (WinForms Designing).
- Writing Classes & Internal functionalities, Core business logic.
- Responsible for identifying the repetitive problems in application and come up with the solutions to fix them.
- Interaction with the client for requirement understanding, follow ups & approvals.
Confidential
Team Member
Responsibilities:
- Gathering Requirement for the whole application.
- Database Architecture design.
- Creating Tables and writing Queries, Stored Procedures.
- Implementing n-tier Architecture at all layers.
- Developed Cascading Style Sheets (CSS) for User Interface uniformity throughout the application.
- Designing the User Interface (WebForms Designing).
- Involved in application release and responsible for defect free migration in different environments.
- SOAP Web Services development using ASP.NET
- Responsible for identifying the repetitive problems in application and come up with the solutions to fix them.
- Interaction with the client for requirement understanding, follow ups & approvals.
Confidential
Team Member
Responsibilities:
- Gathering Requirement for the whole application.
- Database Architecture design.
- Designed and developed various classes, interfaces and modules construct the business logic using C#.
- Designed and developed data access layer, which would connect to various databases for various groups using C#.
- Implemented a wrapper with Windows Word COM to integrate the radiology reports generated from a third party control to the WinForms Application.
- SOAP Web Services development using ASP.NET.
- Creating Tables and writing Queries, Stored Procedures.
- Implementing n-tier Architecture at all layers.
- Designing the User Interface (WinForms Designing).
- Designing WinForms using C#, ADO.NET.
- Writing Classes & Internal functionalities, Core business logic.
- Implemented Web Services using C# to integrate the client systems.
- Involved in application release and responsible for defect free migration in different environments.
- Responsible for identifying the repetitive problems in application and come up with the solutions to fix them.
- Interaction with the client for requirement understanding, follow ups & approvals.
