Technical Consultant Resume
Irvine, CA
SUMMARY:
- Over 13 years of experience in technical consulting with major focus on enterprise architecture and design following the software engineering best practices.
- Extensive Hands on experience on various platforms and technologies such as Microsoft, Oracle, IBM, Sybase and Intersystem Cache.
- Extensive working experience of technical pre and post sales consulting and enterprise solution architecture on various domains and technologies including but not limited to Databases, Data warehouse, ETL, Reporting tools, Mobility products and back office applications.
- Successfully lead enterprise data and integration solution design efforts of Confidential ’s national health care reform (HCR) implementation for off - exchange Sales and Renew work stream.
- Extensive hands on working experience on multi-tier client/server and web based applications, reverse engineering, system analysis and design, systems integration, development, testing, deployment and support phases of Software and Product Development Life Cycle (SDLC).
- Well versed with different software development methodologies e.g. RAD, Waterfall and Agile/Scrum.
- Hands on experience of both structured and Object oriented design and development.
- Working experience of managing multiple projects with cross matrix team ranging from small to big size.
TECHNICAL SKILLS:
Programming Languages: Pascal, C/C++, VB 6.0, Java/J2EE, VB.Net, C#, Python, nodeJS
GUI: Win Forms, Web forms, Html, CSS
Methodologies: Structured, OOP/Analysis and Design, UML
Technologies: COM, Classic ASP3.0, ASP.Net, MVC 2.0,Ajax,.Net framework 1.0-4.0, MS Enterprise Library 3.0, Intersystem Cache, Big Data (Hadoop)
Database: MS SQL SERVER, SSIS/SSRS, BO Crystal Report, Ingres 3.0, MySQL, IBM DB2, Oracle, Sybase iAnywhere, ASA 10, Sybase IQ 15.1 P&T, Intersystem Cache, NoSQL MongoDB, Django(ORM web framework)
Design/ Architecture Tools: ER Studio Data Architect 9.0, Visio, Erwin, UML, GOF Patterns, Agile, SOAPower Designer: Scripting: VB / Java Script, DOM, XML/XSL, Cache Object Script(COS), Cache Server: Pages (CSP), Unix/Linux KSHEnvironment: Windows, U/Linux, IIS 5.0-8.0,HP QC, BMC Remedy, Azure
Source Code Version Control: Visual Source Safe, TFS, MS Visual Studio, pyCharm
Distributed Applications: (WCF) WCF, .Net Web Services, COM, SOAP/REST/JSON
PROFESSIONAL EXPERIENCE:
Technical Architect/Consultant
Confidential - Newport Beach
Responsibilities:
- Currently involved in designing and building multiple Confidential software’s e.g. Site and Property Management System (SMS), Captive Portal product for wifi hotspot network and Nationwide Arena Ad server.
Tools: /Technologies: C#/MVC, Python/Django-ORM/MySQL, Cisco ISG gateway, Radius/AAA Server, SQL Server on Azure VM, Azure Cloud Storage.
Technical Consultant
Confidential - Irvine, CA
Responsibilities:
- Business and Capability Roadmaps (BTR)
- Application and Technology Portfolio Management (ATM)
Tools: /Technologies: Visio, ER Studio Data Architect 9.0, SQL Server 2008, Dot Net platform, AngularJ
Solution Architect
Confidential - Pasadena, CA
Responsibilities:
- Some other responsibilities were handling multiple projects, interacted with multiple jurisdictional teams, hosted and attended JAR/JAD sessions, assisted the development team in physical design, reviewed the test cases (UT, SIT, and UAT), making sure that the development and testing were met the business requirement. Identified technical issues and risk and provided the mitigation strategy to project and program managers/leaders.
Tools: /Technologies: SOA, UML, MS DOTNET/J2EE, IBM Mainframe, DB2, IBM Data Power (ESB), Oracle, Informatica, SAS and Ab Inito, System.
Technical Consultant
Confidential - Redwood City, CA
Responsibilities:
- Analyzed and developed a new module of eDocument management. E-Fax documents were tiff images daily received from 70 plus facilities and saved into file server, scheduler pulls all the fax documents and push into database, user can extract tiff images frames and convert it into different image format and associate the documents with related Confidential ts based on facility.
Tools: /Technologies: DOTNET, C#, Python, ASP.Net, SQL Server2008, LINQ, WCF, SSRS
Solution Architect
Confidential - Mt Laurel, NJ
Responsibilities:
- Responsible for providing both strategic and tactical solutions following the banks Technology, Business and Security architecture standards (TRAM, BRAM, and XRAM).
- Responsible for designing and architecting conversion and archival project solutions by leveraging the existing Tools, technology and infrastructure.
- Interfacing and communicating with all stakeholders of project in all the phases of project (SIT, BAT, and PAT) to ensure the successful implementation.
- Responsible for producing Risk Assessment Worksheet (RAW), Architectural Governance Worksheet (AGW) and Blueprint documents as a part of solution where necessary.
Tools: /Technology: Java, SQL Server2008, RSA security SSO, Web services, MQ, ESB, Fidelity Main Frame, Portico framework for BI reporting, PayPlus, Pep+, Titan.
Technical Lead /Architect
Confidential - Orange, CA
Responsibilities:
- Extract data from ASE server and load into IQ server
- Sybase IQ database installation, administration and support
- Convert/rewrite Stored Procedures and tune queries to gain the performance of IQ engine.
- Database and Index reorganization.
- User and Rights administration.
- Batch jobs management, disk space administration and performance tuning.
- Backup/Restore, Systems tuning, Database backup/restore.
- I was a team member of Confidential ’s console application development of appliance and took active role in designing, development of Data Ware house console application.
Tools: /Technologies: Java, XML, HTML, Tom Cat Apache Webserver, Sybase ASA, Sybase IQ, MicroStrategy.
Confidential, Diamond Bar, CA
Responsibilities:
- Managed multiple projects in parallel, project scheduling, allocating resources, problem solving, reverse
- Engineering, integrating and adapting to the new or changing situations.
- Proposal, Software Requirements, integration requirement and Detailed Design Document;
- Interacting with clients in all meetings.
- Involved in all the phases of the application design to deployment.
Tools: /Technologies: VB.Net, C#, ASP.Net 2.0/Ajax, JavaScript, MS Enterprise Library 3.0, SOAP SDK 3.0, .Net Web, WCF Service, XML,XSD, XSL, MS SQL Server 2000, Ingres 3.0, IIS 6.0
Confidential
Responsibilities:
- Application Completion Web Service Integration: Reverse-Engineer the older process and technology used for generating the Open and Closed application report for the past two years. This report was generated at the beginning of each week by a CRON job implemented using UNIX & SQL scripts. These scripts were used to extract data from the DBCIR database and converted them into text files, which were transferred to a local server using file-transfer protocol. Using these text files, users generate reports in Microsoft Excel manually. Converted the SQL scripts into DOTNET components and developed the new web service in DOTNET C# following the security rules of Task Scheduler. This web service loads data into temp table then it creates and copy data into excel sheet and email to stake holders.
Tools: /Technologies: C#, IIS 6.0, Ingres 2.6, Web Service integration
Confidential
Responsibilities:
- Confidential Web Service Integration: Reverse Engineer the Confidential Tracking System, Refund, Invoice and Approve module of a client/server Visual Basic 6.0 with an Ingress 2.6 back-end db application into DOTNET Web Service using C#. This web service is called in VB 6.0 application using SOAP 3.0 SDK clients.
Tools: /Technologies: C#, IIS 6.0, .Net Web Service integration, Ingres 2.6, VB 6.0, SOAP SDK 3.0
Confidential
Responsibilities:
- Purpose of this scheduler was to automate the schedule of AQMD different reports and printing task on the daily, weekly and monthly basis to automate process.
Tools: /Technologies: C#, VB.Net, IIS 6.0, .Net Web Service, System Service Ingres 2.6.
Confidential
Responsibilities:
- Permit Statistics is the project which process and manages all the received, processed and pending applications data received from companies for installing devices in different allocated facilities of the regions. Reverse engineered the existing permit statistics reports of AQMD and converted it into .Net framework based application using Ingres DB. The existing system was written on UNIX using shell script and system services, with Ingres DB.
Tools: /Technologies: C#, IIS 6.0, .Net Web Service integration, Ingres 2.6
Confidential
Responsibilities:
- This is an air quality monitoring web based project which shows the reports of quality of air with different parameters like Oxygen, Nitrogen, and Humidity etc. of port of Long Beach both tabular and graphical form. The application was enhanced using .NET framework and SQL Server database.
Tools: /Technologies: C#, ASP 2.0, AJAX 1.0, IIS 6.0, SQL Server 2000
Confidential
Responsibilities:
- Architected designed and developed online Human Resources Application to be utilized in a Software As a Service (SaaS) model. The application includes Application Tracking, Performance Management as well as basic HR functions.
Tools: /Technology: VB.Net, C#, ASP.Net 1.1/2.0/3.5, Web Service, IBM DB2 9.0, IIS 6.0
Confidential
Responsibilities:
- I was responsible for maintaining and enhancing financial and accounting application.
Tools: /Technologies: VB.Net, ASP 2.0/3.0, JavaScript, IIS 5.0, SQL Server 2000, Link Server, Main Frame
Solution Architect
Confidential
Responsibilities:
- Provided technical consulting to different clients and vendors
- Gave proof of concept (POC) of Sybase Database, Data warehouse and mobility middleware products.
- Comparative analysis of Sybase products with other competitors and vendors product to position the Sybase products.
- Gave technical presentation on different products of Sybase ASE/IQ/iAnywhere/365 and DR/BCP
- Analyze, design and architect solutions according to different business domain and customers need
- Helped sales team in closing the deals and costing etc.
- Attended Sybase Asia Pacific (AP) Singapore, Malaysia and Thailand’s boot camps and s to equip with new products and updates.
Sr. Software Engineer
4W Technologies
Responsibilities:
- I worked on this project alone and did R&D, Analyzed, designed and developed the snipping web site and multithreaded snipping engine.
Tools: /Technologies: C#, Multi-threading, System Service, IIS 5.1, Cache db., Cache Object Script (COS), Cache Server Pages (CSP), Dream Weaver MX, JavaScript, D/Html
Confidential
Responsibilities:
- Reversed engineered an old Mumps (database) system into MS SQL SERVER 2000 using MS VB6.0 as a front end And Crystal Reports 9.0 as reporting tool.
Tools: /Technologies: VB 6.0, MS SQL Server 2000, Crystal Report 9.0
Software Programmer
Confidential
Responsibilities:
- It was an automated solution to a cumbersome and manual process which enabled to reduce document-handling cost. I was able to work in Enquiry and Order Management modules.
Tools: /Technologies: VB 6.0, COM, MS SQL Server 2000
Software Programmer
Confidential
Responsibilities:
- A real estate portal developed to provide the services of buying, selling, renting, advertising and different services related to real state and homebuilders.
Tools: /Technologies: Windows 2000, VB 6.0, COM, ASP 3.0, VB/Java Script, D/HTML, CSS, Dream Weaver MX 6.0, MS SQL Server 2000, IIS 5.1, MS VSS, MS Interdev, MSXML 3.0
Confidential
Responsibilities:
- client/server based application designed for human rights, a Non-Governmental Organization (NGO) with the aim to contribute towards the development of the civil and human society by providing children and youth with socially relevant and human rights sensitive
Tools: /Technologies: VB 6.0, COM, MS SQL Server 2000