We provide IT Staff Augmentation Services!

Sr Programmer Analyst Resume

Aurora, IL

Cynthia is a Sr. Software Developerhaving over 10 years of experiencein the full Software Development Life Cycle including Requirements Analysis, High Level Design, Detailed Design, Build, Testing, Acceptance and Installation, Maintenance and Production Support. Her expertise lies in the architecting, design and development of Desktop (Windows) and Web Based solutions using technologies and tools like .Net Framework 3.5/2.0/1.1 (C#, VB.Net, ASP.Net, ADO.Net), Windows Forms, Web Forms, WCF, LINQ, Web Services, Visual Studio 2003/2005/2008, XML, Front-End programming and design (HTML, JavaScript, Ajax, Ajax Control Toolkit, CSS), IIS 6.0/7.0, PowerBuilder 5.0/10.0, VB 6.0, Visual Interdev 6.0 (Classic ASP),ADO, ADO.Net,JavaScript, VBScript and SQL Server 2000/2005/2008, T-SQL, ETL/DTS, SQL Analysis Services, SSIS, SQL Business Intelligence Development Studio, Oracle 9.i/10g, PL/SQL (as backend and database programming tools). She has strong knowledge of Object Oriented Programming, UML, SOLID Principles and Best Practices.As aproject leader, Cynthia was responsiblefor -Business Analysis, Project Requirement Management, Project Task Management, Project Scope Management, Project Time Management, Project Cost Management, and Project Quality Management.She has been involved in projects executed with quantitative/qualitative methodologies such as CMMI Level 5 and Agile (Scrum).She has excellent analytical, problem solving and communication skillsdemonstrated through successful software implementations and extensive customer service/software support.

TECHNICAL SKILLS:

Web Technologies: ASP.NET, Classic ASP, Ajax, XML, XSL pages, Web Services, LINQ, WCF.

Programming Languages: ASP.NET 1.1/2.0/3.5/4.0(C#), ASP.NET 1.1/2.0/3.5/4.0 (VB), VB.NET 1.1/2.0/3.5/4.0, JavaScript, Power Builder 5.0, PowerBuilder 10.0, HTML, Microsoft Visual Interdev (classic ASP), Pascal, C ++, COBOL, Visual Basic 6.0, Oracle (PL/SQL), Versata.

Scripting Languages: JavaScript, VB Script

Development Tools: Visual Studio 6 to 2010, C++, Pascal, Cobol, PowerBuilder 5.0/10.0

RDBMS: SQL Server 2000/2005/2008, MS Access, Oracle 9.i/10g, MySQL

UI Design: Visual Studio 6 to 2008, Front Page, HTML, CSS, XSLT, Web themes.

Web Servers: Internet Information Server 6.0/7.0.

Versioning Tools: Visual Source Safe 2005, Team Foundation Server.

Build/Deployment: MS Build.

Reporting: Crystal Reports 9/10

Hardware: PCs, Peripherals, Raid Disk arrays, Network/Memory Cards.

Software: Microsoft Front Page, Visual Studio .Net 2.0, Visual Studio .Net 3.5, Visual Studio .Net 4.0, Microsoft Project, Microsoft Visio, Flash, IIS, Apache Tomcat, SQL Server Analysis Services, TOAD, SQL Business Intelligence Development Studio.

Operating Systems: Windows 3.1 to 7, Novell, Linux (RedHat).

PROFESSIONAL EXPERIENCE:

Sr. Programmer Analyst, Confidential, Aurora, IL 05/11-12/11

Wolters Kluwer is a global provider of information, software, and services that help professionals do their work more quickly and efficiently. They provide information in the fields of legal, business, tax, accounting, finance, audit, risk, compliance, and healthcare. They have offices in over 45 countries, and customers across the world in more than 147 countries.

The project here consisted of taking an user/expert collaboration portal called Knowledge Connect

(which was being migrated from J# to C# ) and analyzing a list of user stories so that the changes could be coded and integrated into the application. This collaboration portal concentrates all the business knowledge regarding any topic in the form of Publications, Blogs, Best Practices and Frequently Asked Questions. The users can search for information in the application and the application will display all Publishes, Blogs, FAQs and Best practices related to that topic. The users can also interact with each other to request information about a certain topic or to provide information about it.

Responsibilities:

  • Application, database and documentation analysis. We initially received a copy of the source code in J#, the database (which was created in SQL 2008) and some documents related to the database and the application and its functionality. We analyzed the code and the database and did many business test flows in the application so that we could fully understand how it was used and how it worked along with the database.
  • User Story analysis. A list of user stories was placed in an internal system called Rally. Each user story was considered a requirement or bug. We analyzed each user story and broke each one of them into small tasks (each task estimated in no more than 4 hours). This allowed us to consistently deliver work related to the user stories and to better administer and better document what was being done in each one of the user stories.
  • User Story documentation. Once a user story was completed a technical document was created. This document included an explanation of the changes made, the steps taken to make those changes and the objects considered. If there were any database side scripts they were also included as part of the documentation.
  • Responsible for Programming/Developing the Applications. Wrote the code for all necessary business requirements (user stories) the application had and the code to fix any bugs. The application used a 3-tier framework base and the UI layout (design and code behind) was developed as XSL pages in Visual Studio 2010 (using C#).
  • Designed and developed ASP pages and classes using ASP.NET 2010 and C#. The pages referenced widgets or controls, and these controls utilized XSL templates (populated by information formatted in XML). Used CSS (Cascading Style Sheets) in ASP.NET pages. CreatedCSS to improve the general “look and feel” of the applications. Used XSL templates to control the look and feel of individual pages. Information formatted as XML was the source of these templates. Used JavaScript for client-side validations.

Designed and DevelopedCustom Widgets and Controls. Each widget and control translated into a very specific function in a page or page (i.e. Login Widget).

Created and deployedAssemblies.

Used ADO.NET Database Connectivity for storage and retrieval of data from Database. This information was then formatted as XML so that our XSL templates could take it as the source.

Used Dataset, DataView, and Data Adapter to manipulate and display data.

Configured web.config and other (custom) config files to control database access, some values for our XSL templates and other variables for the application.

Created tables and indexes and wroteStored Procedures, functions, views and Triggers in SQL Server 2008.

Handled all user access and permissions using system specific tables to control users, roles and permissions.

Used Team Foundation Server for version control.

Used web services and WCF to allow admin users to import data into the application.The data was related to publishes, users, communities, etc.

  • Responsible for designing the Applications’ Database. Analyzed the applications’ information and data requirements in the user stories and worked on the database design of the applications using both SQL 2008 as RDBMS. All the necessary tables, functions, stored procedures, functions, triggers, indexes, views and jobs were created.
  • Did Database administration and tuning. Created tables and wrote stored procedures, functions, triggers, indexes, DTS, SSIS, jobs, views, database backup and maintenance plans.
  • Responsible for Team mentoring. Provided technical training to other team members on topics such as Application design and functionality, 3-layer architecture, design patterns, best practices, peer reviews and technical support of .NET.

Environment: .NET Framework 4.0, ASP .Net 4.0 (C#), XSL, XML, SQL Server 2008, Classic ASP, JavaScript, ADO, ADO.Net, HTML, IIS, WCF, Team Foundation Server for version control.

Sr. Programmer Analyst,Synovate, Confidential, Chicago, IL/ London, England05/08-05/11

Synovateis a company that conducts market research studies. The projects consist of building ASP.NET (C# and VB) Web based applications that allowsSynovate’s customers to view the results of these studies (via the web, using charts and reports as reference). The results of the market research studies become the data source of the applications that are built and then used. These results are formatted, cleaned, processed and updated so that the web applications can display them as charts and dynamic reports. These web applications help Synovate’s customer’s decision makingon product improvements and their customer service levels.

Responsibilities:

  • Requirements gathering and analysis.Participated in meetings interacting with project managers, business users and end users in order to understand their needs and goals.
  • Business requirements document creation.This includedUML diagrams such as sequence diagrams, flow diagrams, user stories, use cases, UI prototypes. Created theHigh level design document for the proposed system architecture represented with blocks diagram, hardware and software requirements, and diagram of interaction between external systems.Created thedetailed designdocument (for each project), including the database modeling and normalization, application architecture, coding standards and a detailed description of each use case, process, calculations, user interface layout, detailed screens description and relationship of the components. The detail level was at class/method level; basically a blue print of what was required to be coded.
  • Project Plan and Tracking
  • Developed the Application Architecturebase framework for each web application consideringthe 3-layer architecture. Developed the data access layer, business logic layer and the presentation layerin ASP.NET 2.0/3.5 Webforms(and in isolated cases classic ASP pages).
  • Responsible for Programming/Developing the Applications. Developed the reporting and charting modules, web pages and processes for all the required applications, starting with the applications’ 3-tier framework base. The UI layout ( design and code behind ) was developed as webforms in Visual Studio 2005/2008 ( using C# and VB ) :

Designed and developed Web Forms using ASP.NET 2.0/3.5 and C# (in some cases VB). Applied AJAX in Web Forms using ASP.NET AJAX controls in VS.NET 2.0/3.5. This was achieved using the AJAX control kit components, like the Update Panel (for partial page rendering), Modal popup Extender, Calendar, etc.

Used LINQ to obtain the data from collections when needed.

UsedWebservicesand WCF to obtain data and used this data to populate the reports or Webformobjects.

Used CSS (Cascading Style Sheets) in ASP.NET pages. CreatedCSS and Themes for various GUI effects and to improve the “look and feel” of the applications.

Used JavaScript for client-side validations.

Used functionality like Master-Pages and UI controls like TreeView, Menu control etc.

Used ASP.NET Web Server controls like Grid View, Data Grid, Data List and Repeater for displaying the records.

Designed and DevelopedUser Controls and Custom Server Controls.

Applied Validation controls for validating the Web Forms for the UI using ASP.NET and C#.

Created and deployedAssemblies.

Used ADO.NET Database Connectivity for storage and retrieval of data from Database.

Used Dataset, DataView, and Data Adapter to manipulate and display data.

Configured web.config for setting the Application and Session variables.Used Telerik third party controls to support the reporting modules. RadGrids, RadTabStrips and RadPageViews were used to display information and to keep the design clean and interactive by allowing the user to see different sets of related reports in one single page ( using tabs in the page ).

Designed and developed different sets of dynamic reports for the applications. These reports included Scorecards, league tables, regional info (using maps), etc.

Designed and developed different sets of dynamic charts for the applications. The charts included bar charts, line charts, pie charts, radar charts, funnel charts, tables, etc.

Developedfuncionality that allowed the user to generate all the reports and charts as Excel files, PPT files and PDF files. This was achieved by using a third party component called ABCPdf andAspose Slides( for .Net ). Used Google maps to display regional info in maps.

Used DotNetCharting (for .Net) andComponentART (for .Net) to create professional looking charts.

Created tables and indexes and wroteStored Procedures, functions, views and Triggers in SQL Server 2005(orOracle 10g).

Handled all user access and permissions using the .Net membership framework.

Used Visual Source Safe forversion control.

  • Responsible for theapplications’ Database Design. Analyzed the applications’ information and data requirements and worked on the database design of the applications using both SQL 2005 and Oracle 10g as RDBMS. All the necessary tables, functions, stored procedures, functions, triggers, indexes, DTS, SSIS packages, views and jobs were created.
  • Responsible for data uploads and data maintenance: Populated the data source for all these applications. The results of the market research studies come in as files and these files have data. These files were taken and used to upload/update the necessary data for the web applications (using SSIS packages and complex queries).
  • Built the necessary data upload procedures using SQL queriesandSSIS packages.
  • Responsible for theApplications’ Maintenance/Production Support.New requirements were handled and changes were made to the existing modules in the applications. Production support also included assistance on usability of the system, investigation of issues related with data and bug fixes.
  • DidDatabase administration and tuning. The databases for these applications were also administered and tuned up. Tables, stored procedures, functions, triggers, indexes, DTS, SSIS, jobs, views, database backup andmaintenance plans were created when needed.
  • Responsible forTeam coordination and mentoring. Worked as a task coordinator for the projects. As a mentor, provided technical training to the team members on topics such as Application design and functionality, 3-layer architecture, design patterns, best practices, peer reviews and technical support of .NET.

Environment: NET Framework 2.0/3.5, ASP .Net 3.5/2.0, 1.1, C#,WCF, LINQ,Webservices, SQL Server 2000/2005, .Net Server controls, Oracle 10g, Toad, Classic ASP, JavaScript, ADO, HTML, DotNetCharting (for .Net), Telerik(for .Net),ComponentART (for .Net), IIS,DTS, SQL Analysis Services, SSIS, SQL Business Intelligence Development Studio, AJAX, Visual Source Safe for version control.

Sr. ProgrammerAnalyst, Confidential, México, México City México 05/01-05/08

SIS Nuevo Laredo is a consulting company that offers software solutions to forwarding agencies and logistics companies so that they can have control over their imports, exports, transports and other logistics operations.

Aduasis (desktop application and web based reporting solution).

This system helps forwarding agencies to control their imports and exports. This system administers the merchandise from the time it arrives at the warehouse, to the time it leaves in order to be imported or exported. Also, this system generates all the legal documents required for all imports and exports between Mexico and other countries.

Responsibilities:

  • Requirements gathering and analysis. Participated in meetings interacting with project managers, business users and end users in order to understand their needs and goals. The final Business Requirements document was created. It integrated the business process with the updated analysis requirements and the document also included UML diagrams such as sequence diagrams, flow diagrams, user stories, use cases, UI prototypes.
  • Design/Programming/Implementation.Developed the warehouse, traffic, shipping and reporting modules and processes for all the required applications. Many implementations of this system were made with various customers. Over 30 implementations were made and each implementation was done according to the specific needs of the customer. The tasks for this included: All the screens, windows forms and reports that were necessary for the customers’ operations and business needs were developed.system was developed in PowerBuilder 5.0/10.0andSQL 2000. Created tables and indexes and wroteStored Procedures, functions, views and Triggers in SQL Server 2000. In some cases, the customers required a solution that was built and provided ascubes in SQL 2000 Analysis services. This solution allowedkey information to be reported to high executives via Excel.
  • Compliance to Mexican law. The law is very strict in terms of the import/export validation files that need to be generated and the documents that need to be presented in order to be able to export or import merchandise, soit was very important to take care of any changes that the law required. All the files and reports that the system produced needed to be always up to date (according to the law) and the customers needed to always have the most updated version of the systems so that their operations could go smoothly.
  • Developed a generic reporting website for forwarding agencies. An extensive analysis of the import/export process was made so that a generic reporting website (that all customers could use) could be built. This project consisted in building a web site that the clients of the Forwarding Agencies could use to consult their inventory and the status/flow of their merchandise (for both imports and exports). Once completed, this web site was implemented as part of the Aduasis solution. The project’stasks included:

Involvement in all phases of the System Development Life Cycle (SDLC), from inception/analysis, to training the users and giving support and maintenance.

The web sitewas done in Visual Interdev 6.0(classic ASP/HTML) with SQL Server 2000 & ADO and it contained essential searches and reports.

Applied server-side validations using VBScript in ASP Pages. Used JavaScript for client-side validations. Used CSS (Cascading Style Sheets) in ASP pages.

Created tables and indexes and wroteStored Procedures, functions, views and Triggers in SQL Server 2000.

Involved in Database diagram design and Tables design in SQL Server.

After some years of operation, this website was migrated to .Net 1.1 / Crystal reports platform, using SQL 2000 as the database management system. This included tasks like:

All the existing ASP pages were developed as new and improved .Net webforms that produced both web based reports and Crystal reports. Designed and developed Web Forms using ASP.NET 1.1 and C#. Used CSS (Cascading Style Sheets) in ASP.NET pages.

Used JavaScript for client-side validations. This also helped to keep the reports dynamic and to achieve a better user-application interaction.

CreatedCSS to improve the “look and feel” of the applications.

Used functionality like Master-Pages and UI controls like TreeView, Menu control etc.

Used ASP.NET Web Server controls like Grid View, Data Grid, Data List and Repeater for displaying the records.

Designed and DevelopedUser Controls.

Applied Validation controls for validating the Web Forms for the UI using ASP.NET and C#.

Used ADO.NET 1.1 advanced features for Database Connectivity for storage and retrieval of data from Database. Used Dataset and Data Adapter to manipulate and display data.

Crystal Reports was used to produce the necessary reports.

Created tables and indexes and wroteStored Procedures, functions, views and Triggers in SQL Server 2000.

Published the application to development, testing and live environments when necessary. IIS was used in the web servers.

  • Received and attended calls and emails from all customers with questions and inquiries regarding the imports/export processes, legal documents and validation files used in the imports/exports processes, system functionality, best practices in the import/export process, etc. HighJump (mobile device application and web based reporting solution) HighJump is a Warehouse management system. This system helps to control all the merchandise in a warehouse and it to keep the merchandise organized in warehouse locations. Using this system the merchandise can easily be allocated and shipments organized.

Responsibilities:

  • Requirements gathering and analysis. The Business Requirements document was created. It integrated the business process with the updated analysis requirements and the document also included UML diagrams such as sequence diagrams, flow diagrams, user stories, use cases, UI prototypes.
  • WMS Analysis/Design/Programming/Implementation: Fully implemented a WMS System (which is a system to manage all the operations existing in a Warehouse) in the warehouses and distribution centers of a chain of furniture stores in Mexico City. This system was also implemented as the main WMS System in the warehouses of a logistics company. The tasks for these projects were: Analyzed all the customer’s needs and implementing both the application part and the web part of the WMS System. The projects required involvement in all phases of the System Development Life Cycle (SDLC), from inception/analysis, to training the users and giving support and maintenance. For these projects HighJump Software, Oracle 9.i, SQL 2000 and Crystal Reports were used. All screens were developed using HighJump Software and all reports were developed using Crystal Reports. Created tables and indexes and wroteStored Procedures, functions, views and Triggers in SQL Server 2000 and Oracle 9.i. Grand_e( web based system ) Grand_e is an ERP system that helps to have control of all the operations of a company like Product management, customers, orders, sales, account payable, account receivable, invoicing, etc. The projects consisted in implementing one or more of these software solutions (depending on the customer needs).

Responsibilities:

  • Requirements gathering and analysis. The Business Requirements document was created. It integrated the business process with the updated analysis requirements and the document also included UML diagrams such as sequence diagrams, flow diagrams, user stories, use cases, UI prototypes.
  • ERP Analysis/Design/Programming/Implementation: The project consisted in supporting the implementations of an ERP system for a chain of stores in Mexico City. The projects’ tasks were: Part of the ERP functionality was built and 4 full interfaces were also built. These interfaces loaded information that is considered the backbone of the ERP system’s functionality. The 4 interfaces were: Products, Commercial structure, Offices and Prices. They were built as stored procedures under Oracle 10g. ERP Reports were made with Crystal Reports

The Modules of ERP application (windows, query objects) were developed usingVersata.

Created tables and indexes and wroteStored Procedures, functions, views and Triggers in Oracle 10g.

Internal Projects –

a) Built fully functional E-commerce website. The site included shopping cart and payment gateway. This was done using UML and ASP.NET 2.0 (C #) with SQL 2005.

b) Built a Web based Knowledge Base system to improve the quality of the customer support given in the company. The knowledge base had a relationship of the most common questions and problems the customers had and the solutions to these questions and problems.

c) Built Customer Support and Consultant Task Administration Application. This system had a relationship of all the customer support calls that each consultant took and all the tasks that each consultant did. This facilitated task administration and task assignment for each consultant.

Tasks done included:

Designed and developed all

webformsfor company info, products/price listing, product buying, shopping cart and payment gateway were developed in ASP.NET 2.0 (C #). Used CSS (Cascading Style Sheets) in ASP.NET pages.

Created UML Diagrams using Visio 200

Used JavaScript for client-side validations.

Used CSS (Cascading Style Sheets) in ASP.NET pages. CreatedCSS and Themes to improve the “look and feel” of the applications.

Used ASP.NET Web Server controls like Grid View, Data Grid, Data List and Repeater for displaying the records.

Designed and DevelopedUser Controls. Applied Validation controls for validating the Web Forms for the UI using ASP.NET and C#.

Used ADO.NET 2.0 advanced features for Database Connectivity for storage and retrieval of data from Database.

Created tables and indexes and wroteStored Procedures, functions, views and Triggers in SQL Server 2005.

Used Dataset, DataView, and Data Adapter to manipulate and display data.

Took part in the business process redesign tasks.

Published the application to development, testing and live environments when necessary.

  • Project Management, Project Plan and Tracking.Did the project plan for the development, testing and implementation phases. As a project leader fully managed and administeredthe system implementation project. The solution was adapted using PowerBuilder 5.0/10.0, Visual Interdev, SQL Server 2000 (with T-SQL), Visual Basic 6.0 and VB.NET (using ADO.Net).
  • Application Maintenance/Production Support.
  • Database administration and tuning. Created Tables, stored procedures, triggers, views, functions, indexes, DTS, jobs, database backup andmaintenance planswhen needed.

Environment: ASP.Net 1.1/2.0, VB.NET 1.1/2.0 (using ADO.Net), Visual Interdev,HighJump, Versata, Visual Basic 6.0, PowerBuilder 5.0/10.0, SQL Server 2000/2005, SQL (T-SQL, ETL/DTS and SQL Analysis Services), Oracle 9.i.

EDUCATION:

  • Master of Science, Information Systems from Texas A&M International University, Laredo, TX.
  • B.S., Computer Systems Engineering from Technical Institute of Nuevo Laredo, Mexico.

Minor: Networks and Distributed Systems(with Honors)

Hire Now