Bi Architect Resume
OBJECTIVE:
Become a key player in design and development of solutions for challenging business problems where I can enhance and utilize my software engineering expertise while providing my clients with simple intuitive solutions.
PROFESSIONAL SUMMARY:
- 16+ years of diverse experience in working with teams involved in giving comprehensive IT Solutions, which include requirement analysis, high - level design, development, implementation and testing of client/server/internet systems for various business requirements using Microsoft technologies.
- Expertise in business intelligence and data analysis.
- Expertise in T-SQL and PL/SQL, OOAD, Microsoft .Net technologies (VB.Net, C#, ASP.Net) and Java.
- Experience in Federal, PII Data handling, Financial, Risk Management, Healthcare, Heavy Duty Trucking industry.
- Performance Tuning of both application and SQL Queries.
- Expertise with Agile, Test-Driven Development Methodologies, and Automated Testing.
- Expertise in development of complex software products using client-server and web architecture.
- Good team player with excellent communication skills.
TECHNICAL EXPERTISE:
Primary Skills: .Net Technologies, PL/SQL, T-SQL, SSRS, SharePoint, Power BI, Tableau
Languages: ASP.Net, VB.Net, C#, T- SQL, Java, J2EE, JavaScript, C, C++, and Visual Basic
Methodology: Agile, DevOps, SAFe 4.5, Test Driven Development, UML
Servers: Windows Server 2016, IIS, SSRS Report Server
Tools: /IDE Power BI, Tableau, Visual Studio, SharePoint, Team Foundation Server, Fiddler, SSRS, Telerik Reporting, Git, JIRA, Firebug, ReSharper, Version One, SQL Server Management Studio, Crystal Reports, Rational XDE, PL/SQL Developer, MS-Project
Database: SQL Server, Oracle, My SQL, and MS Access
O/S: Windows, UNIX
Others: MS- Office, MS Project
Compliance: FISMA, 508, NIST
PROFESSIONAL EXPERIENCE:
BI Architect
Confidential
Responsibilities:
- Reverse engineered legacy data warehouse data, applications, and reports.
- Designed, rearchitected, and developed existing reports into Power BI and SSRS Reports.
- Developed KPIs in PowerBI for critical ATF data.
- Created Data Models for Power BI Reports.
- Designed and architected ASP.Net application for custom dashboards.
- Developed database objects, stored procedures for data analytics and complex queries.
- Developed stored procedures for parity check between different systems.
- Handled configuration management of reports including scheduling of reports, manage user access, and report server.
- Environment: Visual Studio, Oracle, SQL Server, Power BI, SSRS, ASP.Net, Version One
Sr. Systems Analyst
Confidential
Responsibilities:
- Design and Implement User Account, Position Description/Job Application Tool and Application workflow.
- Create and enhance reusable architecture for hosting components and controls.
- Perform Data Analysis and implement Dashboards.
- Handle PII and other sensitive data.
- Developed custom forms for SharePoint and InfoPath.
- Designed and Developed position workflow in SharePoint.
- Implemented single sign on for web application using Site Minder with Confidential team.
- Worked with Confidential Team on C&A for conducting security control assessments with NIST security controls and documenting results and coordinating teams in addressing the POAMS listed after the assessment.
- Fixed issues identified by C&A process.
- Executed HP Fortify static code analyzer for any software vulnerabilities.
- Identify potential new projects and developed working prototypes for demo to key stakeholders.
- Run-through testing to ensure application performs as intended.
- Deployment and maintenance of production servers.
- Performance testing and profiling of Oracle data and application.
- Identify and understand user needs and data requirements.
- Review requirements with the customer and implement the feedback.
- Code refactoring for performance and reusability.
- Identify and understand user needs and data requirements.
- Convert business requirements into software using the building block architecture.
- Review requirements with the customer and implement the feedback.
- Manage Confidential servers and deployments.
- Design and Implement User Account, Personnel Action Request and Application workflow.
- Create and enhance reusable architecture for hosting components and controls.
- Code refactoring for performance and reusability.
- Run-through testing to ensure application performs as intended.
- Deployment and maintenance of production servers and O&M.
- Performance testing and profiling of Oracle data and application data.
Environment: Visual Studio, Oracle, SQL Server, Telerik, JIRA, IIS, ASP.NET, C#, Java Script, jQuery, Ajax, Git, Share Point, InfoPath.
Sr. Software Consultant
Confidential
Responsibilities:
- Implementation of key features like Risk Assessment, Obligation Sets and Controls.
- Enhancements and Customizations of the product for different clients.
- Implementation of Dynamic Form Generation for monitoring module.
- Engaged in enhancements to User Interface.
- Run-through testing to ensure product performs as intended.
- Deployment and maintenance of production servers.
- Performance testing and profiling of SQL queries.
Environment: Visual Studio, SQL Server, MVC, Telerik, JIRA, Team Foundation Server, Subversion, ASP.Net, C#, IIS, JavaScript, CSS.
Software Consultant
Confidential
Responsibilities:
- Implementation of key features like Patient Security management (Lock Patient), Information distribution management (Failed Faxes).
- Development of reusable controls for Topaz Systems signature capture devices.
- Refactoring of Search Mechanism to increase re-usability, maintainability, and optimization of query execution.
- Enhancements to various sub-systems including security, deficiencies, messaging, Caching, and Auditing.
- Engaged in enhancements to User Interface.
- Run-through testing to ensure product performs as intended.
- Performance testing and optimization of search mechanism and SQL queries.
- Integration and production fixes.
Environment: ASP.Net 3.5 (VS 2010), C#, Web services, Oracle 11g, Infragistics, NHibernate, jQuery, JSON, IBM-FileNet
Software Consultant
Confidential
Responsibilities:
- Completion of projects from inception to deployment.
- Migration / Configuration of websites on the hosting servers.
- Integration of third party software for payments and online shopping solutions including paypal®, shopsite, Cart32.
- Production fixes for several clients.
- SQL Conversion and data migration from MS-Access, EXCEL Spreadsheets, text files into SQL Server.
- Create / Run SQL Reports and ad-hoc queries for various clients in the desired formats.
- Development of ad-hoc query engine using OpenXML.
- Fixing of SQL Injection for a real estate client.
- Profiling and optimization of SQL Queries that were used by different clients in various technologies.
Environment: SQL Server, My SQL, PHP, ASP, ASP.NET, C#, PL/SQL, HTML, Java Script, Open XML
Software Developer
Confidential
Responsibilities:
- Requirements analysis, design, development and testing of web and windows-based products.
- Develop web interfaces using ASP.Net, WinForms, reusable class libraries, and data access components.
- Design, develop reusable architectural components with Microsoft Technologies and Dot Net Framework.
- Develop test cases and automated scripts using Fitnesse (acceptance testing framework) and NUnit framework.
- Involved in Test Driven Development using Agile Methodology.
- Design, develop database objects including Tables, Views, Stored Procedures, and User Defined Functions.
- Design and development of user interface for both windows and web applications.
- Development and execution of Unit, System and Functional Test Plans.
- Facilitated coordination among development, QA and Support teams.
- Integration of help subsystem developed in Robohelp into the product.
- Development of APIs interfacing back to Confidential Legacy Systems.
- Maintenance of existing code base including refactoring, bug fixes and enhancements.
Environment: Visual Studio, SQL Server, ASP.Net, C#, JavaScript, Crystal Reports, IIS, Version One, UML, Crystal Reports, NUnit, Visual Source Safe, Test Driven Development.
Systems Analyst
Confidential
Responsibilities:
- Develop Object Models and sequence diagrams using Rational Rose.
- Development of JSP, Servlets, class libraries, data access components and other J2EE Components.
- Develop User Interface using JSP, HTML and JavaScript.
- Develop and execute test plans for Unit, System and Integration Testing.
- Development of testing procedures for project.
- Production fixes of the application.
Environment: JDK, Java Servlets, J2EE, JSP, Java Script, Oracle, Rational Rose, HTML, Visual Age Java, WebSphere, Tomcat
Programmer Analyst
Confidential
Responsibilities:
- Development of testing standards and guidelines for web applications.
- Development of Confidential application that facilitates generation and execution of test cases.
- Development of prototype of the application.
- Design screen layouts and prepare storyboard documents.
- Coding of JSPs, Servlets and Helper Classes using Java, J2EE and JDBC for data access.
- Development and execution of Unit and System Testing.
- Involved in the development and integration of user documentation.
Environment: JDK, Java Servlets, J2EE, JSP, Java Script, Oracle, Rational Rose, HTML, Visual Age Java, WebSphere, Tomcat
