We provide IT Staff Augmentation Services!

Bi Architect Resume

3.00/5 (Submit Your Rating)

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

We'd love your feedback!