Objective: To obtain the position of an IT Lead / Business Systems Analyst

Technical Knowledge:

• Languages: BI Tools BIDS, SSIS, SSRS, SSAS Net Technologies - C .NET, VB.NET, ASP.NET, ADO.NET, LINQ, AJAX, XML, XSLT, AJAX, Web Services, SQL Server Programming, VBA, Visual Basic 6.0, Visual FoxPro , Java
• RDBMS: MS-SQL, ACCESS, DB2, Visual Fox Pro
• Web Scripting: HTML, XML, XSLT, VBScript, JavaScript, API, PayPal API
• Legacy Programs: COBOL, RPG/III/400, CL/Sub-File Programming, Visual Basic, JavaScript, UNIX Scripts, JCL, CICS, VMS, DB2, Pascal
• Software: Visual Studio 2010-2003, SQL Server 2008, IIS 7.5, Silverlight, Expression Web, MS-Project 2005, Microsoft Office 2005, Visio, FrontPage, Adobe Photoshop, Adobe Illustrator, Crystal Reports, UML
• Hardware: Assembly Of Internal Computer Components and diagnostic testing. Routing Protocols, Implementing and Maintaining MS SQL Server, Implementation and maintained Windows Server 2003 Active Directory, Backups BES Server
• Networking: Cisco for instructors
• Other: OOPS, System Analysis and Design, E-Commerce PayPal API , Stored Procedures, Fuzzy logic, Marketing

Relevant Skills and Experience:

Confidential

Business Systems Analyst

• Analysis , Application Design , Database Design , Testing and Implementation of Mobile Library Software
• Made architectural and design recommendations to meet business requirements using Visio and UML
• Solicited requirements from Clients in order to create use case, activity and state designs to clarify and define business flow and processes using Visio
• Defined a TO-BE document for the new project requirements
• Created and implemented Database architecture using Access RDBM
• Designed Forms, Views, Reports in order to track library sources and operational transactions using Access 2008
• Created Reports and pivot tables to analyze and aggregate data in regards to defined KPI's and constraints using Access 2008
• Unit test and Integration testing and load testing of Software to ensure that it met the constraints and requirements defined in the BRD UML- Visio
• Research and documented the Dewey Decimal Classification System widely used to implement on the mobile system
• Tools used : VISIO, Access Database, SQL, UML, Visual Basic

Confidential

ApplicationDeveloper- Technical Lead

• Worked closely with GT Clients to ensure that the business model is correctly interpreted and directly relatable to the functional decomposition of the business requirements UML-Visio
• Reviewed and evaluated capabilities and benefits of existing system and/or processes to determine if requested changes were necessary and/or possible
• Interacted with key stakeholders, internal and external clients regarding timelines, technical issues, and infrastructure integration
• Interviewed prospectus employees and involved in the hiring process and management and mentoring of I.T. staff
• Worked as the technical-lead to ensure architectural consistency and the best software practices were followed
• Defined, designed, and implemented multi-tier distributed applications for 50 Fortune 500 external client sites - IIS, Visio, C , ASP,NET
• Made architectural and design recommendations to meet business requirements - Visio - UML
• Created and implemented software architecture
• Developed, maintained and improved applications by evaluating business needs, analyzing requirements, in accordance with GT's coding standards
• Created client accounts and external websites and E-commerce by programming PayPal Interface IIS- C , SQL, LINQ,
• Secured GT's databases with high-level security encryption SQL, C
• Worked independently as well as jointly with other team members and Clients to design, code and test major features
• Made efficient and secure applications for multiple clients. Modified existing sites to ensure that they were up to GT's coding standards C - ASP.NET, SQL, Expression web, Silverlight - Ajax
• Created stored procedures to execute data insertion, updates, deletions, and retrievals from SQL Databases SQL server
• Adhered to strict project deadlines while delivering quality programs.
• Conducted essential security testing, unit and integration testing SQL- C - N-unit
• Corrected and modified program logic and performance tuning, if necessary - UML C - ASP
• Dealt business issues in a timely, professional manner
• Provided support by ensuring stability of the application and addressing and resolving problems
• Developed support protocol and escalation procedures for software application support
• Tools used: Visual studio 2010 suite, C .NET, ASP.NET, SQL Server 2008, .Net Technologies LINQ, Ajax, N-tier architecture,IIs7, Silverlight, ExpressionWeb, FileMaker , PayPal API

Confidential

DBA/ Technical Project Lead

• Maintained company's international websites portals as well as created new functionality using oops and n-tier methodology in C .Net and ASP.Net
• Maintained, created , analyzed and debugged ETL packages to ensure the loading from the 10 provincial Liquor Boards to a complex database system SSIS SQL VB.NET
• Developed SSIS Packages and programmed scripts in visual basic.net
• Created stored procedures, views, triggers, queries, indexes and maintained complex system database structure of over 100 tables. SQL Server
• Maintained SLQ Server 2005 Test and Production environment BlackBerry Enterprise Server, Windows 2003 Server when needed Performance maintenance, Backups and restores, Queries, Views , Functions and Stored Procedures
• Created SSRS Reports Financials and Accounting Sales and Marketing Logistics and Supplier reports which are crucial for present and future purchasing decisions SSRS - SQL
• Created unit test cases and ensured that all modifications and new implementations were integrated and functioned correctly C
• Led project as well as was a technical resource for full-time employees and co-operative placements during project phases MS Project
• Stabilized present system and improved performance for reports by optimizing the queries. -SQL
• Created new company Data warehouse and ETL system to scrub the data in preparation for the creation of cubes using the Kimball/Munday Method in order to provide a clear understanding of niche markets and predictive consumption patterns SQL-SSAS-SSIS
• Initiated partnerships with Sheridan College, University of Toronto, York University and Centennial college for co-operative program placement at the firm
• Implemented SQL Server Industry standards and procedures for the company
• Tools used: Visual studio 2005 suite, SQL Server 2005, BI Tools SSRS, SSIS, SSAS ,SQL Programming, Full SDLC, .Net Technologies N-tier architecture and Data warehousing methodologies

Confidential

Free Lance Software Developer

• Corroborated and aided in the development of the company website ASP VB6
• Maintenance of in-house billing software using requirements from principle Systems Designer Excel- VBA, HTML
• Tools used: VB6.0, HTML, VBA, Excel, FlashMX 2004

Confidential

Systems Analyst -Independent Software Developer

• Developing an on-line registration system and in-house software for an international dance performance company which hosts national competitions Crystal Reports- C - ASP.net - VBA
• Visited client on-site to analyze client requirements, investigate previous software and then define requirements for new in-house software UML-VISIO-BRD-MS Project
• Diagnosed and fixed fatal run time errors in major in-house software the company uses on tour thus rescued their national touring season VB6- Access HTML
• Tools used: C , ASP.net, ADO.net, Visual Web Developer 2005, IIS Server, UML, Visio, MS Access, SQL, SQL Server, Visual Basic 6, HTML, OOP,MS Project, Crystal Reports

Confidential

Systems Analyst-Team Lead

• Analyzed requirements for on-line web system
• Research and generated a detailed project scope SDLC for the prescribed on-line system BRD UML MS Project
• Theoretical design of web system for the graphic artist and web designer Story boarding - Prototyping - Mockups
• Designed software coding structure for the Database design and stored procedures for junior programmer
• Tools Used: OOPS design, System Analysis Model, UML, Visio, Microsoft Project, Visual Studio 2003, ASP.Net ADO.Net, MS-SQL

Confidential

Systems Analyst

• Generated project scope and analysis for new project using SDLC
• Interviewed all stakeholders to obtain system requirements VISIO DFD Flow Charting
• Used previously designed in-house software redesigned and enhanced the existing patient statistical software to meet the needs of new processes that were put into place. - VB6
• Designed a new patient medical database which allow for the tracking of patients, test sites and results, hospital care, and treatment plans Access - SQL
• Developed and Implemented software which resulted in generating an increase of funding Visual Basic,
• Tools Used: Visual Basic 6.0, Access Database, SQL, Visio

Confidential

Instructor of Computer Information Systems-tenure track

• Effectively taught 6 classes per semester Visual Basic 6, Systems Analysis and Design, Micro Focus Cobol, Programming Logic, Relational Databases, Introduction To Computers to freshman and sophomore students
• Excellent communication skills both verbal and written to motivate clients to articulate complex concepts into an easily understood terms that resulted in a high student success rate
• Experienced in Academic and Career Advising as well as Curriculum development
• Managed and coordinated and trained 160 students in a lab environment
• Developed projects, tests and course content that was relevant and up-to-date in order to ensure the marketability of the clients
• Excellent client retention rate thus contributing to the department rated scores which allows for the hiring of new instructors and overall growth of the department
• Completed all grading and input them into college wide grading software on time
• Tools used: Visual Basic 6, COBOL, MS Office 2000 SQL, MS Access 2000,JCL, CICS, Unix Script system analysis and design, RDBMS

Confidential

Systems Analyst

• Used extensive knowledge Of RPG, COBOL, AS400, and IBM legacy systems during the Development, Enhancement and Conversion of the existing Shipping and Receiving System of an international Steel coil and car manufacturing company
• Trained end user in software use and completed all tasks in a timely manner
• Assisted in house end-users to resolve issues and problems both on the phone and in person
• Used client analysis to developed the system requirements using the data modeling and creation of the data stores
• Migrated data from Toyota Tsusho's head office to other geographical branch location ensuring data compatibility
• Used CL programming, sub files, SDA,RDA, logical and physical files for creating programs and subsequent report generation of inventory control
• Converted Cobol to RPG using AS400 platform from interviewing users in shipping and receiving to development working within the business logic and maintaining functionality
• Prepared programs for compliance on INFOPAC regulations data exchange and interface
• Maintained mainframe programs and created batch processes
• Employed communication skills both verbal and written to articulate complex concepts into an easily understood terms and to effectively overcome client objections and address concerns
• Tools used: COBOL, AS400, RPGIV, IBM Systems 36, JCL, CICS, Windows 2000, DB2

Systems Analyst

• Proven ability in software development analysis and design, support maintenance of large scale applications
• Used investigative and analytical skills to find and correct an error in the in-house financial mortgage software that saved the company millions of dollars
• Employed full system development life cycle for various industries by designing and implementing project specifications including regression testing and documented data dictionary and modeling
• Developed migration and data transfer software
• Generated timed daily, monthly and year-end status reports for top management in Dallas describing company transactions, accounts, profit and loss and expense of all local branches
• Used the ability to multi task and prioritize to meet tight time deadlines in a fast paced environment in converted large scale financial programs for the Y2K
• Competently worked in a result and team oriented environment to effectively trouble shoot and solve client problems
• Tools Used: Cobol, Unix, Unix Script, Micro Focus Cobol, SQL, DB2

Confidential

Systems Analyst - Client Server Development Specialist

• Proven problem solving abilities to diagnose application related problems with clarity to assist in house end-users to resolve issues and problems both on the phone and in person
• Used excellent interpersonal skills to work well with all levels of internal/external clients to build and maintain strong client relationships
• Generated and kept up to date technical designs and documents on data stores, product specifications and implementation
• Developed new software and SDLC was employed according to the specification of the Cabinet of Finance for the Government of Kentucky. Projects included a governmental bidding system for price contract review
• Created a Cabinet of Families and Children's School to Work program, and a Child Support Payment Tracking System
• Investigated and analyzed end user requirements
• Tools Used: Visual Fox Pro Visual Fox Pro Database, SQL