We provide IT Staff Augmentation Services!

Sr. System Analyst Resume Profile

4.00/5 (Submit Your Rating)

SUMMARY OF SPECIALIZATION

  • Over 13 years of experience in IT Over 13 years of experience using Databases Over 9 years of experience using .NET technologies and Over 5 years of experience using Java and various UNIX platforms.
  • Specialized in providing/converting High End End-To-End Complex Complete Solutions.
  • Specialized in boosting Existing Applications quality with minimum changes.
  • Specialized in SOA Architecting Designing Developing and delivering multi-tier sophisticated web applications using ASP.NET MVC4/JQuery/Various other JavaScript Frameworks/C with SQL Server/Oracle databases ADO.NET/ENTITY FRAMEWORK from scratch using agile methodologies.
  • Specialized in SOA Architecting Designing Developing delivering multi-tier sophisticated web applications using ASP.NET C with SQL Server/Oracle databases from the backend from scratch using agile methodologies.
  • Specialized in SOA Architecting Designing Developing delivering multi-tier sophisticated windows applications using WPF/XAML/MVVM/C with SQL Server/Oracle databases from scratch using agile methodologies.
  • Specialized designing High performing data warehouses using Star Schemas creating packages SSIS packages and DTS packages from scratch. Designed Complex and very large Database Architectures from scratch using SQL Server and Oracle.
  • Designed many GUI/Wireframes for web/windows based applications Specialized developing powerful and sophisticated algorithms

TECHNICAL SKILLS

Window Platform Programming MVC 4/C JQuery JavaScript WPF 4.0 C 4.5/4.0 ASP.NET 4.5/4.0 T-SQL SQL Server 2012/2008 HTML CSS Ninject DI JavaScript VB Scripting VB Web Services WCF WSE 3.0/2.0 WSCF.Blue XML XSLT ADO.NET SSIS SSRS Oracle 11g/10g Batch file TXT CSV MS Office Window Server T-SQL SQL PLUS UML

UNIX Platform Programming Shell Scripting Java PL/SQL SQL PLUS Oracle PERL SED AWK AIX

Distributed Methodologies MVC 4.0/3.0/2.0 MVVM RAD AGILE Parallel Computing Threads RMI Distributed Programming Client-Server TCP/IP Web Services Object Orient Techniques Service Orient Architecture Skeleton Design Complex Database Network Consolidations High Performance Computing Algorithm

Tools Used Windows Server 2012/2008/2003 Window 7/Vista/XP Solaris 9/8 IIS 8.0/7.5/7.0/6.0 Visual Studio.NET 2010/2008 Visio Pro 2010/2007

Office 2010/2007 Visual Studio 6.0 Front Page MYSQL JDBC ODBC

Others Technologies Used VB.NET C/C Assembly Linux Novel

Testing Visual Studio Unit Testing White Box Testing Black box testing Regression testing

PROFESSIONAL EXPERIENCE

Confidential

Sr. System Analyst/Technical Architect

  • Re-Architected Redesigned and helped developed all applications layers converted from Two Layer application into 7 Layers SOA layers including brand new Security Layers and web layer to track patients health using C MVC4 JQuery JavaScript Handlebar Bootstrap framework as well as other JavaScript frameworks etc.
  • Redesigned and designed GUI for the new/existing requirements as well as provided End to End solutions to feed or support various applications.
  • Boosted performance as well as user experience on existing SSRS reports using Star Schema and provided feasible solutions to complex problems without adding additional resources.
  • Architected Designed and Developed Data warehouse from scratch using Star Schema Visio and SSIS packages so data can be retrieved from multiple insurance companies and hospitals standardize the data and store the data into well designed search oriented SQL Server 2012 data warehouse to feed various systems.
  • Converting Existing Insurance/Hospital Data into money saving products such as finding medicines and its side effects which works better than others which further reduces cost to Patients and Hospitals.

Technologies Used JQuery Bootstrap Handlebar Visio 2010 Pro UML Visio 2010 C 4.5 T-SQL SQL Server 2012/2008 R2 Window Server 2008 R2 IIS 7.5 Visual Studio.NET 2013 Excel 2010 etc.

Confidential

Senior .NET Architect Consultant

  • Designed and Developed SOA multithreaded multi-tier two web projects using ASP.NET C HTML JavaScript JQuery CSS and SQL Server from scratch.
  • Developed optimized search engine from scratch to find articles based on keywords.
  • Created new database tables to support additional functionality including stored procedures triggers to support additional business requirements. This application was converted from legacy application.
  • Designed and Developed AD and LDAP authentication API to support various applications.
  • Designed Enterprise-wide SOA User Role Management System to support multiple applications.

Technologies Used Visio 2010 Pro UML Erwin C 4.5 T-SQL SQL Server 2008 Window Server 2008 R2 IIS 7.0 Visual Studio.NET 2012 Excel 2010 etc.

Confidential

Senior .NET Architect Consultant

  • Architected/Designed/Delivered various complex maintenance free SSIS packages/ETL Programs using C T-SQL Batch files Database tables triggers and SSIS Controls.
  • Architected the whole Database from scratch to enhance business functionality by increasing performance.
  • Created testable various utilities written in C to archive various files and folders and to clean up the old files and folders.
  • Provided many solutions to complex problems quickly and delivered projects ahead of schedule.
  • Developed various batch files and C utilities to retrieve/deliver files from/to different files systems using ftp http shttp and sftp.

Technologies Used Visio 2010 Pro UML Erwin C 3.5 T-SQL SQL Server 2008 Window Server 2008 R2 IIS 7.0 Visual Studio.NET 2008 text files CSV files Excel 2010 etc.

Confidential

Senior Architect/Developer/Lead Consultant

  • Designed and Developed SOA architectures to support existing applications/added new features at various levels.
  • SOA Architected Designed and Developed MVC4 ASP.NET C Restful multi-tier multithreaded applications from scratch.
  • Developed SOA WCF services and client proxies from scratch and changed existing functionality of various web services which were used on different protocols and hosted on IIS and as window services.
  • Used WSDL to create various client proxies using WSCF.blue and Used SoapUI to test.
  • Converted stored procedures into XML based to increase performance as well as reduce network load in Oracle and SQL Server.
  • Designed and Developed Database Architectures tables stored procedures triggers views etc. in Oracle and SQL Server to support WF System and other applications.
  • Mentor other developers time to time about their part of enhancements helped developed functionality from scratch.
  • Developed and enhanced .NET layers so that many applications could use these layers to communicate or act based on User s Role.
  • Designed and Developed WF System from scratch using C and Developed many WCF Client Proxies.
  • Developed AD and LDAP authentication API to support all Department s applications.

Technologies Used C 4.0 ASP.NET MVC 4.0 UI WCF WSCF.blue WSE 3.0 SoapUI Fiddler FireBug ADO.NET LINQ AJAX Entity Framework JQuery ODBC AGILE Telerick T-SQL SQL Server 2005 Window Server 2003 IIS 7.0/6.0 Windows XP HTML CSS JavaScript Visio 2007 pro Visual Studio.NET 2010 Web Services flat files CSV files Excel 2007 UML 2007 etc.

Confidential

Senior Application Database Architect/Developer

  • Designed Developed SOA Restful ASP.NET MVC 3.0 C multi-tier Trading Web Platform application including integrate third party platforms where Power Market Traders view their hundreds of customized reports submit their bids to external systems using various services.
  • Designed and developed intranet applications using ASP.NET Silverlight to incorporate and test various Silverlight related technologies.
  • Designed and Developed SOA architectures to support WPF/C /XAML/MVVM bid insertion application
  • Created Systems and subsystems to retrieved thousands of data feeds per day from private and public internet data sources via ftp HTTP APIs web services scraping to store into SQL Server 2008 and SQL Server 2008 R2.
  • Used ADO.NET to retrieve data from database for many independent applications.
  • Designed GUI/Wireframes from scratch to support business functionality.
  • Designed Developed Complex Risk Analysis Algorithm to detect best points to invest in for various Energy trading markets and used Agile methodologies and SOA for throughout product development.
  • Developed WCF Services using SOA architectures to facilitate communication between servers. Created WSE 3.0/2.0 as well as WCF client proxies from WSDL and validated the XML content type using XSD.
  • Designed and developed many about 150 different independent C Utilities Java and Batch files to support business requirements.
  • Created hundreds of ETL SSIS packages to upload various type of files csv txt xls xml etc into database and to make files downloadable in CSV format from website and Window s application. Built data warehouse from scratch to support reporting project.
  • Created many SSRS and Crystal Report 2008 reports than later converted to Google Charts using Google Chart API and MS Charts to embed them into asp.net application.
  • Normalized optimized Architected designed and developed very large database tables stored procedures jobs triggers and functions to store and manipulate the data from various sources.
  • Used Microsoft Speech technologies to tell the traders when something happened abnormally.

Technologies Used C 4.0/3.5 ASP.NET 4.0/3.5 Silverlight 4.0 ASP.NET MVC3 ADO.NET WPF/XAML 4.0 GUI LINQ AJAX WCF WSE 3/2 Entity Framework JQuery RAD ODBC AGILE Telerick T-SQL SQL Server 2008 R2/R1 Window Server 2008 R2/R1 IIS7.5/7 Windows Vista Windows Server 2008 R2/R1 Installation Configuration SQL Server 2008 R2/R1 Installation Configuration HTML CSS JavaScript Visio 2007 pro UML Visual Studio.NET 2010/2008 Google Charts MS Charts 4.0/3.5 Crystal Report 2008 Web Services ADO.NET flat files CSV files Excel 2010/2007 etc.

Confidential

Senior Application Architect/Developer Consultant

  • Designed and Developed SOA complex international high profile ASP.NET C multi-tier applications to keep track of Telephone bills Disputes and Collection. Incorporated SSO into two Enterprise International level applications.
  • Built Source Code Management System similar to SourceSafe from scratch for AT T to store source code and various document files. Files were compared before adding into the UNIX platform using shell scripting/Java.
  • Enhanced existing applications which was written VBScripts JavaScript ASP with new functionality. Converted legacy applications into ASP.NET C applications and redesigned the GUI for ASP.NET applications.
  • Redesigned complete enterprise level data warehousing from scratch designed and developed various scheduled and unscheduled DTS and SSIS packages web based report systems using charts and graphs as well as email based reporting system to send financial reports to corporate executives daily weekly bi-weekly and monthly basis.
  • Leading and mentoring other offshore developers about their part of projects helped developed functionality from scratch.
  • Created automatic and manual packages to create flat files transfer data between servers.
  • Designed and Developed enhanced and maintained Oracle database/SQL Server databases.
  • Designed and created complex databases using normalization techniques modified and optimized existing databases for various applications created and modified tables stored procedures triggers views functions and jobs.
  • Created migration plan disaster planning rollback plan combining existing hardware architecture and software architecture to use existing resources efficiently.
  • Created many different programs which read and insert XML data into databases.

Technologies Used C VB.NET ASP.NET 2005/2003 GUI HTML ADO.NET Java SQL Server 2008/2000 Window Server 2008/2003 Windows XP VB VBScript JavaScript Visio 2003 Visual Studio.NET 2003/2005 Visual Source Safe 6.0 Web Services ADO.NET notepad Excel 2003 Access 2003 XML etc.

Confidential

Customer Service Representative

Performed various duties as required or assigned including handling customer inquiries introducing producing to customers open new accounts and wire transfer for clients nationally internationally.

Confidential

Senior Application Developer Consultant

  • Helped in formulating the business case for the site individually designed the logical and physical structure of the application
  • Developed Shipment System which was written many different languages including PL/SQL C and Java on UNIX and Windows platforms to perform activities such as ordering calculating of price and transferring data from local server to central server of the company when order was shipped.
  • Optimized existing infrastructure and created sophisticated SQL Server databases to responsively handle complex queries and .NET data access components
  • Designed Skeleton for large application using .NET Web Forms. Used Crystal Reports to create reports based on SQL Server database. Envisioned and built front-end for the site designed in .NET.
  • Redesigned large database to improve performance by normalizing and database tuning which reduced the time in execution almost in half.
  • Responsibility included high level application architecture design application design developing testing white box testing black box testing regression testing maintaining and documenting the program logic using designated programming languages under proscribed software development lifecycle.
  • Enhanced distributed application using multi-threading and object orient techniques. Completed Implementation of Remote C program to data transfer between many computers and perform operations using C and korn Shell on UNIX Solaris and AIX platform.

Technologies Used VB 6 ASP Visual Studio 6.0 SQL Server 2000 Windows Server 2003 Visual Studio.NET 2003 VB.NET C ADO.NET ASP.NET XML VBScript HTML DHTML JavaScript Dreamweaver HTML CSS C/C Solaris Oracle 9i Crystal Reports 9

Confidential

Oracle Developer Quality Assurance Systems Analyst

  • Developed database architecture with normalized tables Developed and enhanced packages procedures and functions using PL/SQL.
  • Developed Database triggers
  • Tested Unit Integration test cases
  • Tuned Performance

Technologies Used IBM-AIX UNIX Shell Scripting ORACLE 9i/8i PL/SQL SQL PLUS C PR C

We'd love your feedback!