Database Architect & Developer, And It Project Manager Resume
SUMMARY:
- I have extensive experience in various Information Technologies and Engineering fields (such as, database & software engineering, system designing, software quality assurance and project management).
- Throughout my career, I have worked with Fortune 500 and internationally recognized companies, and worked on projects involving leading edge technologies.
- I can work independently, or as part of a team, with equal effectiveness.
- I am familiar with current technology trends and have a good understanding of the issues and opportunities offered by the Internet, advances in wireless and mobile computing, and data mining. I specialize in designing and developing high - end, enterprise-wide solutions around the SQL Server, Oracle, MS-Access, C#, Visual Basic, .Net, XML & Windows Mobile platforms. I also work with WCF (Windows Communication Foundation), WPF (Windows Presentation Foundation), AJAX (Asynchronous Java and XML) and Metadata.
- I am result-oriented and motivated by challenging assignments.
- I am very flexible in adapting new technology trends that are introduced frequently.
- I have experience in Quality Assurance (QA), Disaster Recovery and Business Continuity Planning, as well as SQL Server tools, such as SSMS, SSRS, SSIS and SSAS.
COMPUTER-RELATED SKILLS:
General: Extensive experience in designing, developing and maintaining software for engineering and business applications. In-depth knowledge of personal computers and networking hardware, and numerous software platforms.
Systems: IBM Mainframes; CDC Cyber Systems; DEC/VAX and HP Mini-Computers; Apple Macintosh, IBM-Compatible Personal Computers & PDAs, and Metadata.
Operating Systems: MS-DOS, Windows 3.x, 9x, NT 4, 2000, 2003, XP, Vista, Windows 7, WinCE, Pocket PC 2003, Windows Mobile 7, etc.
Databases: SQL Server 2000/20 R2; Oracle 10g, MySQL, XML, MS-Access, FoxPro, etc.
SQL Server Tools: SQL Server Management Studio (SSMS), Reporting Service (SSRS), Integration Service (SSIS), Analysis Service (SSAS), as well as Replication.
Programming Languages: FORTRAN, Basic, VisualBasic, VBA, EmbeddedVB, VB.NET, C#, ASP.NET, etc.
Internet Applications: Web Authoring, Web Site Development & Administration Tools; such as, Visual Studio.NET, FrontPage, HTML, ASP, ASP.NET, Web Services, VBScript, JavaScript, MVC, MFC & AJAX, Infragistics Controls, etc.
Current PC Applications: Microsoft Office Suite (95 to 2007), Corel Draw, PIMS, Internet Explorer, Outlook Express, MS-Project 98/2003/2005 , Outlook, pcAnywhere, etc.
CAD/CAM Packages: AutoCAD, CATIA, TrueSpace, Computer Graphics System, etc.
PC Applications: Numerous office automation packages, such as Bloomberg API, AutoCAD, Quattro Pro, Timeline, MultiPlan, etc.
PROFESSIONAL EXPERIENCE:
Database Architect & Developer, and IT Project Manager
Confidential
Responsibilities:
- Worked as a database consultant with numerous companies.
- Involved with all aspects of software development life cycle, including developing proposals, preparing specifications and designing, software coding, quality assurance, testing & installation; as well as, developing documentation & training.
- Extensive experience in creating tools for data migration, data transformation & automated data processing
- Designed and developed numerous enterprise-wide database management systems, including systems for managing mortgages, investment portfolios, debt settlement services, medical offices and claims processing, conferences, airline revenue, venture capital services, contacts, pharmaceutical depot and distribution, retail pharmacies, professional societies, company accounts and salary administration using various platforms.
- Well versed in Visual Studio.NET & Windows Mobile technologies for developing client/server, intranet and Internet solutions. Instructed several information technology related courses.
Confidential, Los Altos, California
Manager, Information Laboratory
Responsibilities:
- Responsible for developing the concept of an Information Laboratory where leading edge technologies were to be demonstrated in real-life situations; such as the Internet.
Manager, Software Quality Assurance
Confidential
Responsibilities:
- Responsible for developing and maintaining a software QA program.
- Developed QA plans and procedures for assuring quality during all phases of the software life cycle. Handled internal and external QA audits.
- Involved in the development, enhancement and maintenance of software used in nuclear power plant maintenance and engineering analysis; and for developing technical and user documentation.
Project Manager/Team Leader
Confidential
Responsibilities:
- Worked on several projects in various capacities such as project manager and technical task leader. Led the task for developing a repository of ten safety studies of nuclear power plants, as well as Task leader for documenting NRC review comments on 17 nuclear power plant safety studies.
Confidential, Troy, Michigan
Manager, Project Development
Responsibilities:
- Developed proposals of more than in revenue and was involved in implementing information technology projects.
- Managed numerous hardware and software projects through various phases of concept, design, pricing, justification, procurement, implementation and maintenance.
- Designed software for data acquisition, analysis and management, and for data base integration.
- Developed an MS-Access 2007 application and a new SQL Server 2008R2 database to integrate tracking, purchasing and marketing of an extensive coins collection that included single, as well as multiple coins.
- It handled unlimited collection of images, as well as metadata about each coin in the group and their professional grading condition.
- SQL Server Reporting Service (SSRS 2008) was used to create reports and SSIS 2008 was used to import external data.
- Installed SQL Server 2008R2 on a Windows Server 2003 Operating System.
Confidential
Project Manager/Team Leader
Responsibilities:
- Used C# in Visual Studio 2008 and designed an MS-SQL Server 2008 database to develop an enterprise-level, intranet Web application to monitor, process and report currency transactions as required by the Federal Regulations CTR 010 and CTR 020.
- Extensive search capabilities were created, which interacted with the database through stored-procedures.
- The user interface also used the Grid View, and included a lot of code to customize its behavior based on the underlying content and user mode.
- Access to all Site Map Nodes was determined through roles assigned to each user by the CTR Management. Users were identified through their login credentials and Windows Accounts.
- CTR2 was built as a mission critical Intranet application with no access to any Confidential employees outside those working in the CTR department.
- Also, except for the CTR management, none of the users were permitted to look at the work of other employees.
- The entire security model was created on the basis of detailed System Requirements that were created by the bank.
- And, because of security concerns, only a small team of IT and CTR staff was used in the design and development of this application.
- The application also included a File Watcher Service that monitored a network folder whenever new files arrived and loaded the data automatically into the database.
- Data and format related errors and/or messages were posted into the Server’s Application Event Log, as well as an Email notification was sent based on parameters specified in the web.config file. Internet Information Service 7.0 (IIS 7.0) was used for website control on an internal Windows Server.
- Created the application’s MS-SQL Server 2008 database structure, as well as the data import & export files for CTR010 and CTR020 compliance.
Confidential
Project Manager/Team Leader
Responsibilities:
- Designed a new MS-SQL Server 2000 database and installation, as well as later upgrades and administration support as and when needed.
- The front-end of this application was developed in C# with WPF using Visual Studio 2005 with Oracle 10g database to create a complex, yet flexible, sales system for trading convertible bonds and stocks.
- The application displayed live trading data from the Bloomberg API on numerous forms using WCF.
- Visual Source Safe was used to manage the application development process that required multiple programmers working with an Agile implementation in two different countries.
- The front-end used Windows Forms technology, User Controls and XML, which allowed users to customize their interface by moving, opening or closing dock able panes as and when needed. The user interface made extensive use of Infragistics controls, such as the Dock Manager and the UltraWinGrid.
- Oracle 10g automation was achieved through hundreds of Views, Stored Procedures, Packages and Functions.
- Assisted in creating a new Oracle 10g-based MS-Windows Server 2008.
Confidential
Project Manager/Team Leader
Responsibilities:
- Created data migration plans, QA procedures and Use Cases for moving mission critical data to a new system.
- This project required working with an international team on three continents using the Agile software development methodology.
- Visio was used for creating the data flow charts.
Confidential
Project Manager/Team Leader
Responsibilities:
- Created several tools for loading into and extracting mortgage data from corporate databases including DataTrac, FICS and Empower.
- These tools were used to support Secondary Marketing and Warehouse Banking, and involved MS-Excel Add-Ins for Posting Commitment Data, Resetting Commitment Data, Posting Loan Data, Confirming Locks, Posting Conduit Data, Posting Purchased Loans, Updating Shipping Status, Updating Status Codes, Transferring Warehouse Banks, Downloading First Collateral, Comerica & RFC Loans, and Creating New Loans in DataTrac.
- Created an MS-Access 2005 database for managing bonds that were being released to mortgage investors. SQL Server 2005 was used as the back-end.
- Installed and maintained a new SQL Server 2005 on new client hardware.