Sr. Application/ Bi Developer Resume
Mclean, VA
SUMMARY:
- I am seeking a challenging opportunity in the field of Information Technology where I can fully utilize my skills in system architecture, development, and implementation of highly complex and mission critical software applications. I am a full stack software engineer who can lead and execute, from building a prototype, to scaling platforms for millions of visitors and creating server topology and optimization.
TECHNICAL SKILLS:
- .Net
- ASP.NET
- C#
- VB.NET
- C++
- MVC4
- WFC
- JavaScript
- JQuery 1.11
- AngularJS
- JSON
- HTML5
- TFS
- SharePoint. Oracle 11G/9i
- MS SQL 2008/2012
- MongoDB
- OLAP
- Data Warehousing
- Business Objects
- PeopleSoft. Extract
- Transform and Load (ETL) data from different sources to final tables/dimensions using DTS and SSIS . Drupal 7.24
- Electronic Data Processing (EDP)
- Documentum 4i
- DQL
- DFC
- Workflows
- ACLs. SDLC
- COTS Integration
- Visio
- VSS
- PVCS
- Agile (Scrum)
- Macromedia Flash and Fireworks. Extensive knowledge in developing accounting and financial application - JD Edward AP/AR/FI/GL. Knowledge of UML standards and in preparing Case
- Class
- Sequence and Activity Diagrams.
PROFESSIONAL EXPERIENCE:
Confidential, McLean, VA
Sr. Application/ BI Developer
Responsibilities:- Designed ETL process to run sequentially or in parallel to reduce the current muli-hour ETL process. Developed and implemented solutions for cleansing data to remove errors and ensure data consistency. The ETL process is to collect data from different repositories and generate XML files for the State Department - Foreign Assistance web site.
- Performed Database indexing, profiling, tuning and written stored procedures to increase system performance.
- Created SSIS packages to generate downloadable CVS files from foreignassistance.gov site.
- Developed innovative user interfaces and interactive models that leverage next generation web technologies to improve user productivity and operational efficiency.
- Developed RESTful services for foreignassistance.gov web site. Designed and implemented a unit test framework using Moq and Visual Studio to increase test coverage on key automated payment processes.
Key Technologies: C#, WebAPI,SSRS, HTML 5, DHTML, AJAX, JavaScript and Node.JS
Confidential, Washington, DC
Sr. Web Application Developer
Responsibilities:- Architected, designed and implemented the Office Wage Hour - Claimant MIS system. Applied best design patterns such n-tier, MVVM, Repository, and Singleton for designing key reusable components, involved in designing UI parts to be mobile friendly using BootStarps and HTML5 skills.
- Architected and developed and delivered Time-Entry system. Created the required stored procedures and views using SQL Server, assured enterprise application integration by selecting tools, specifying shared data and code resources,defining interfaces and workflows, developed functional specifications, Use Cases and Test Scenarios.
- Created an identity verification process using LexisNexis Instant Verify and Instant Authenticate to validate the registered user’s identity. Reviewed software security vulnerabilities including SQL injection, Cross Site, scripting, buffer overflows Improper use of Cryptography, Malicious code and various other vulnerabilities.
- Used SSIS Packages to transform and load staging and reporting tables with the help of Data flow task, Execute SQL task, Sequence container and Data flow transformations like conditional split, row count, derived column and aggregate.
- Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x / 8.x) reports.
Key Technologies: Tableau, ASP.NET, MVC4, SQL, Visio, Agile, SharePoint, HTML5, AngularJS, JavaScript, Web API.
Confidential, Washington, DC
Sr. Application Developer
Responsibilities:- Designed and Developed core application components for the Criminal Investigation Management System products.
- Created Web Services to meet client requests to allow remote application to communicate with CIMS.
- Participated in design meetings to determine system requirements and determine design of components.
- Assisted with data migration to ensure the new system formats and requirements were met.
- Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environment, extracting, transforming and loading (ETL) data from legacy database using Microsoft SSIS and Data Export tools.
- Key Technologies: .Net, ASP.NET, Nunit, Business Intelligence, SQL 2008, Ajax.
Confidential, Washington, DC
Sr. Application Developer
Responsibilities:- Working closely with TSA NDO (National Deployment Office) system analysts to translate requirements into .Net technology solutions to create online browser-based Personnel Deployment system.
- Modified existing web application utilizing the tenets of Web 2.0 and multi/n-tier architecture. Written automated SQL scripts to migrate legacy data to SQL database.
- Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server
Key Technologies: .Net, ASP.NET, WCF, MVVM, MVC2, SQL, SSRS, Nunit, LINQ, Agile, JavaScript, Ajax.
Confidential, Washington, DC
Sr. Programmer Analyst Lead
Responsibilities:- Developed and managed requirements and system design for SMI (Secure Mail Initiative).
- Performed necessary SMI integrations with FTPSecure COTS.
- Performed ConnectShip system evaluation and software recommendation. (COTS)
- Ensured SMI comply with the current Section 508 accessibility requirements.
- Successfully involved in test driven development model (TDD) using NUnit and performed code reviews.
Key Technologies: .Net, VB.NET, MVVM,ASP.NET, JavaScript, SQL, NUnit, SSRS, TFS, Agile, VS2008, ConnectShip
Confidential, Washington, DC
Sr. Application Developer
Responsibilities:- Led the development of CAS (Central Alarm System) for Department of Energy. The CAS provides the capability to accept, process, display and store data from RPMs, NII machines and Cameras. The CAS system allows users to effectively manager alarm/event processing and to access the status of the system.
- Engaged in the development and implementation of intelligent traffic system devices, including traffic signals and lighting, traffic control systems, traffic sensors components to be integrated with CAS using C++.
- Implemented an Interface between 360 Surveillance video display systems using C++.
- Designed and Implemented the ArchiveManager component systems using WinForms.
- CAS was developed using Multi-Tier design pattern and utilized OOP principles.
Key Technologies: .Net, C#, C++, ASP.NET, WinForms, Windows Services, Oracle 9i, Crystal Reports, SharePoint 2007
Confidential, Washington, DC
Senior Software Developer
Responsibilities:- Led the development cycle of CMRIS web application. (Comprehensive Management Resources Information System) to keep track of all FAA personal education and certifications requirements.
- Designed and developed project elements, including but not limited to templates, user interfaces. Database schema design, created stored procedures and views.
- Assisted in troubleshooting and resolution of database issues.
Key Technologies: .Net, ASP.NET, VB.NET, Oracle 9i, PL/SQL, SSRS, Crystal Reports and PVCS
Confidential, Washington, DC
Senior Application Developer
Responsibilities:- Designed and developed a document management system to keep track of the client documents. The client is a law firm and partners should be able to search, update and modify documents. Prepared the user requirements specifications and contributed in the database design and front-end development.
- Migrated Internal Messenger Tracking System from Lotus Notice to ASP.NET. The system keeps track of the company hard-copy documents handling. Integrated the systems into the COTS Lawport System.
- Developed Utility to perform legacy data migration from Lotus Notes, to SQL 2000.
- Created Jobs and to performed data synchronization between Lawport and corporate databases.
Key Technologies: .Net, VB.NET, Oracle 10G, PVCS
Confidential, Orlando, FL
Delphi Programmer
Responsibilities:- Enhanced existing real-time software of INFINTI hotel reservation system to accommodate multiple languages and facilitate remote reservations. Designed INFINTI level security system to prevent unauthorized creation, editing or deletion guest information.
- Developed customized and batch utilities to migrate AMOS-D daily transactions to Disney World Cruise JD Edward AP/AR/FI Modules.
Key Technologies: C++,Delphi, Paradox.