Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Burhan Tanweer

Superior Township,MI

Summary

  • Experienced Solution Architect with over 20 years of experience in Auto/Healthcare. Excellent reputation for resolving problems and improving customer satisfaction.
  • Skilled in working under pressure and adapting to new technologies and challenges to resolve problems and improving customer satisfaction.
  • Experience working with Agile methodologies (Scrum and Extreme Programming) and cross-functional teams.
  • Developing and deploying quality T-SQL codes, complex stored procedures, views, functions, and jobs using relational database.
  • Worked extensively on optimization of complex ETLs using SQL Server Integration Services (SSIS) and Data Stage.
  • Developed and deployed SSIS packages to receive EDI 835/837 files from FACTES gateway server for claims adjudication
  • Strong understanding of Data Modeling (Relational, dimensional, Star and Snowflake Schema), Data analysis, implementations of Data warehousing.
  • Analyzing existing databases to develop source to target mapping for the design of a new database and extract data from Legacy system.
  • Using Python to extract dependent codes and eligibility codes from ACA XML files.
  • Collaborated with business partners to develop strategic plans for process improvement and application enhancements.

Overview

19
19
years of professional experience

Work History

Senior Solution Architect

Ford Motor Company
Dearborn, MI
08.2021 - Current
  • Worked closely with customers, internal staff and other stakeholders to determine planning, implementation and integration of system-oriented projects.
  • Participated in Scrum of Scrums to discuss, and remove architectural impediments.
  • Evolved solution architecture with input and feedback from Product Owner and Application Developer.
  • Monitored and tested application performance to identify potential bottlenecks, develop solutions, and collaborate with developers on solution implementation.
  • Managed installation, upgrade and deployment projects and provided on-site direction for network engineers.
  • Improved programming practices such as acceptance test driven development, continuous integration, and continuous delivery.

Solution Architect

Ford Motor Company
11.2018 - 07.2021
  • Designed and developed conceptual and logical architecture to meet strategic business, financial, and technology objectives through documentation of systems.
  • Designed technical document across broad scale of tools, technologies and architecture models.
  • Analyzed existing application databases to develop source to target mapping for the design of a new enterprise data warehouse
  • Migrated Legacy warranty contracts from DB2/Oracle database into MS SQL Server using Microsoft ETL tool SQL Server Integration Services (SSIS).
  • Developed and deployed quality T-SQL codes, complex stored procedures, views, functions, and jobs using Microsoft SQL Server and Oracle.
  • Extracted warranty contracts and claims from SQL Server into Business Objects using scalable ETL platform IBM DataStage.
  • Collaborated with business and technical resources to understand and develop solutions that meet business requirements, translating strategy and objectives when necessary
  • Worked closely with customers, internal staff and other stakeholders to determine planning, implementation and integration of system-oriented projects.
  • Managed use of various types of databases and configured, installed and upgraded new ones.
  • Participated in system development life cycle from requirements analysis through system implementation.

Solution Architect

Michigan Conference Of Teamsters Welfare Fund
Detroit, MI
03.2012 - 10.2018
  • Formulated strategic plans for component development to sustain future project objectives.
  • Suggested architectural improvements, design, and integration solutions, and formulate methodologies to optimize object-oriented software and database development.
  • Designed and developed web intelligence for various demographic and coverage errors reported by IRS using SAP Business Objects
  • Developed program to generate ACA compliant XML file using Microsoft .NET LINQ to XML query techniques
  • Attended IRS webinars to understand Affordable Care Act's employer provisions and related requirements
  • Contributed to overall project plans in compliance with established procedures and standards as well as provided support and error resolution for developed desktop and web applications
  • Used Python to extract dependent codes and eligibility codes from ACA XML file
  • Supervised team members to design and print required 1095-B and 1095-C form in PDF format to print and deliver for each member
  • Developed various applications including Web and Client/Server Application development using Microsoft .NET Framework, C#.NET, ASP.NET, AJAX.net.
  • Evaluated impact of a programming change or modification on whole system as well as communicated status of all projects to team leaders or development lead to ensure projects were implemented properly

Team Leader

Michigan Conference Of Teamsters Welfare Fund
Detroit, MI
07.2008 - 02.2012
  • Developed financial models for new businesses and products, working closely with product managers and senior management
  • Prioritize all work assignments, commit team to work, manage quality of work and drive people management activities within team
  • Worked with user community for requirements gathering, design, development, testing and maintenance of various modules of eligibility
  • Created web-based applications with ASP.NET MVC 4, HTML5, CSS3, JavaScript, jQuery and other client-side scripting technologies
  • Created database objects (tables, views, stored procedures) using MS SQL Server 2008
  • Developed and enhanced business application with web technologies like HTML JavaScript, ASP.NET, Web services.
  • Designed and developed measures, dimensions, and classes in Business Objects for data analysis and user reporting
  • Generated HIPAA ASC X12 version 5010 transaction for Health Care Eligibility Benefit Inquiry and Response (270/271)
  • Conducted training and mentored team members to promote productivity, accuracy and commitment to friendly service.
  • Mentored and guided a team of 26 employees to foster proper completion of assigned duties and increased sales by 15%

System Analyst/Senior Web Developer

Michigan Conference Of Teamsters Welfare Fund
Detroit, MI
01.2003 - 06.2008
  • Experience in design and development of applications using .NET Framework, C#.NET, ADO.NET, LINQ, Visual Studio 2005, AJAX, SQL Server 2000,
  • Developed CSS styles and themes for web pages.
  • Developed and modified complex stored procedures, jobs, views, and tables using Microsoft SQL Server.
  • Facets enabled Blues plans to better support real-time claims processing and member liability estimation using the ITS structure.
  • Developed custom reports using MS SQL Server Reporting Services (SSRS)
  • Developed and deployed SQL Server Integration Services (SSIS) packages to receive EDI 835/837 files from FACTES gateway server for claims adjudication
  • Worked with FACETS administrative team to configure group (employer), class and products to provide eligibility for subscriber and their dependents.
  • Worked extensively on optimization of complex ETLs using SQL Server Integration Services (SSIS) to extract and load into SQL server database.
  • Investigated and addressed system issues to enhance usability and improve functionality.
  • Evaluated and adopted new technologies to address changing industry needs.

Education

Master of Science - Electrical Engineering

Wayne State University
Detroit, MI
04.1996

Bachelor of Science - Electronics Engineering

University of Westminster
London
05.1994

Skills

Net Technologies:

ASPNET, C#NET, ADONET, XML, Web Services, Windows Services, LINQ,

Languages:

C#, NET, ASPNET, T-SQL, PL/SQL, HTML5, JSON, XML, JavaScript, jQuery, PHP, JSP, Java, Python, Scala

Client/Browser Technologies:

AJAX, Ajax Extensions, XHTML, HTML, DHTML, XSLT, JavaScript, CSS

Databases:

MS SQL Server 2016/2008/2005, Oracle 8, 9, 10i, MS Access 2010, 2013, 2016, MySQL 4x, 5x, DB2, Teradata 16

Design Methodologies:

Design Patterns, Data Flow Diagrams, Flow Charts

Tools & IDE:

Microsoft Visual Studio 2008/2010, Microsoft 365, IBM Data Studio 41, SQL Assistant

Languages

English
Full Professional
Hindi
Full Professional

Timeline

Senior Solution Architect

Ford Motor Company
08.2021 - Current

Solution Architect

Ford Motor Company
11.2018 - 07.2021

Solution Architect

Michigan Conference Of Teamsters Welfare Fund
03.2012 - 10.2018

Team Leader

Michigan Conference Of Teamsters Welfare Fund
07.2008 - 02.2012

System Analyst/Senior Web Developer

Michigan Conference Of Teamsters Welfare Fund
01.2003 - 06.2008

Master of Science - Electrical Engineering

Wayne State University

Bachelor of Science - Electronics Engineering

University of Westminster
Burhan Tanweer