Arshad Husain

**W*** Hillside Lane Burr Ridge IL 60527

312-***-**** adt10x@r.postjobfree.com

Summary

Significant progressive experience in business analysis, design, and implementation of enterprise solutions for the Financial/Banking sector, Healthcare, and Telecommunication industries. Experience with industry-leading data management systems, programming languages, operating systems, and commercial software applications. Comprehensive understanding of software development lifecycle, project management, and software quality principles. Demonstrated ability to deliver enterprise-scale business solutions to global partners.

Skills

•JAD session facilitator for Enterprise-level application.

•SCRUM master for large-scale projects.

•Consolidating the development tools and standardized computing environment provides lower TOC and increased cross-application portability.

•Established a center of excellence to promote best practices and knowledge sharing.

•Created a framework to integrate, secure, and share "Data as an Asset" using the PasS paradigm.

•Interacted with process owners to create a unified vision and roadmap of milestone deliverables.

Technical Skills

OS/Cloud Environments:

•Unix, Linux, Mac OS, Windows (System Admin/Development)

•iOS (Development)

•AWS, Azure

Enterprise Application:

•Jira, ServiceNow, Subversion, Git, confluence, AutoSys, UC4, Control-m

Design/Development/tool:

•Erwin, Toad, SQL Developer,

•Tableau, Power BI, IBM Cognos, SSRS/SSAS/SSIS,

•Informatica, IBM DataStage, Oracle data warehouse builder

RDBMS Environment:

•Oracle, SQL Server, Teradata, Informix, Sybase, Hive, Snowflake

Language:

•C/C++, Java, Visual Basic, C#, Bourne, Ksh, Csh and Bash shell, JavaScript, dBase, PL/SQL, T-SQL, SAS, R, Python

Exposed to:

•MR2, hive, pig. VMware, HL7, Machine learning, design patterns, Servicenow, Jira, UML, ITTL, Agile, Scrum

Professional Experience

UsefulBI Corporation

Program Manager/Gilead Sciences Apr 4, 2022 – present

•Manager of analytical boundary applications in the PDM space.

•Responsible for migration and modernization of applications to AWS cloud.

•Provided design and implementation details to the team and maintained a roadmap and timeline.

•Coordinate a team composed of developers and BA.

•Developer standard operating procedure (SOP) and runbooks for each application.

•Participate in Data Lake design discussions. Developed practices to extract data from the Lake.

•Worked with technologies: Airflow, AWS Glue, RDS/PostgreSQL, S3 etc.

Factspan Apr 18, 2021 – Apr 4, 2022

Delivery Manager/DW Architect at Disney

•Responsible for the modernization of Disney cruise line Revenue management system (DCLRMS) from an on-premises application to an AWS cloud implementation in snowflake. Modernization included: coordinating offshore resources, requirements gathering, and project planning. Data pipeline design, implementation, testing, and UAT sign-off.

•Snowflake data warehouse design and implementation to provide analytical details to optimize cruise line revenue generation.

•Responsible for upgrading the 12 applications from the Teradata and Hive (Hadoop) environment to a snowflake.

Bank of Montreal - Harris Bank Nov-2018 – Jun 2021

Sr. Program Manager/Architect

•Deployment of ITG MacGregor XIP application and infrastructure at a new data center. Provide an overview on selecting the type of server and storage. Provide guidance in security setup on DMZ network.

•Deployment of Bloomberg Compliance Center application, including vendor interaction, infrastructure requirement, and interface development at a new data center.

•Created a solution for consolidating business-managed applications after a divestiture into a technology-managed environment.

•Provide Solution Architecture oversite in developing an application for Global Asset Management.

•Worked on a migration project to encapsulate business logic and data from Hadoop/hive to snowflake

American Medical Association June 2018 – Nov 2018

Senior Developer/Architect

•Converting legacy Informix 4GL stored procedure logic to Informatica workflows to improve performance and readability.

•Documented business logic and process maps.

•Establish a standard way to call workflow in a Unix environment.

US Cellular Feb 2017 – May 2018

TEKsystems

Senior Database/ETL Developer

US Cellular Chicago, Illinois

•Designed and implemented ETL process to provide campaign data to us cellular mobile app.

•Created technical documentation and data governance profiles.

•Team code reviews

•Upgrade to Informatica 10.1

Bank of America Chicago, Illinois Mar 2015-Dec 2016

TEKsystems-Solution/Data/BI Architect

•Designed a process that automated SOC-compliant processes that were in excel spreadsheets into a Bank proprietary "Quartz" environment using Python and SQL on Teradata, DB2, and MS-SQL Server.

•Secured business logic under version control using CVS.

•ETL data from Teradata, DB2, and MS-SQL Server operational systems into MS SQL Server 2008R2 data mart using SSIS.

•Collaborate with front-end development and provide ER models to support an abstracted approach development SOC 2 compliant processed.

•Established baseline reports verifying extraction results.

•Wrote complex, but readable queries using CTE for recursive extraction of data.

•Organized SQL script under source control to manage deployment to a production environment.

•Interface with process owners to convert requirements into user stories in JIRA.

•Worked with off-shore members to successfully transfer "run-the-bank" processes.

•Converted complex SAS/base data steps into T-SQL stored procs for business logic.

•Classes in Unity financial reporting tool.

•Created logical and physical data models for the mortgage data mart.

•Created a star schema with over 12 facts tables.

•Created T-SQL procedures to populate dimensions and facts table from operational systems.

JLL Chicago, Illinois Oct 2015-Mar 2016

TEKsystems-Solution Architect

•Delivered a Data Quality Engine (DQE).

•Design and developed data model for DQE Data Mart.

•Populated data mart with reference and statistical data from source systems as produced by DQE.

•Created stored procedure in SQL Server to support data input and validation of DQE metadata.

•Created ETL in Informatica 9.6.2 to load DQE and Data Mart.

•Created a tableau front end to present DQE data.

•Proposed using PowerBI; created a process with ETL and reporting in PowerBI as a demo.

•Evaluated Collibra (data governance tool).

UBS Chicago, Illinois May 2006- Sept 2015

Senior Data/Data Warehouse Architect

•Planning and delivering Data Integration as a Service model at UBS.

•Reduce license cost of Informatica by providing a central PasS.

•Established standard for Informatica 9.6.1 environment for ETL development with the reusable object and leveraged data quality (IDQ) and master data management (MDM) for improved analysis.

•Implemented new strategies to deliver robust data warehouse solutions by using Kimball standards.

•Drove rapid adoption of business strategies/solutions by leading Informatica implementation teams.

•Responsible for establishing an area of excellence within UBS for Informatica IDQ, HUB, MDM, and the PowerCenter products.

•Established deployment standard; wrote bash shell scripts for deployment from Dev to UAT and Prod environment from the subversion repository.

•Created a standard data integration process to populate dimension and fact tables in a star schema.

•Successfully used ETLFactory to automate data source to dimension loads.

•Created conceptual, logical, and physical schemes to house server data for an oracle database.

•Developed a data warehouse to analyze CPU/Memory and storage utilization for the UBS computing environment.

•Developed front-end dashboard in Tableau to provide analysis for decisions support

•Hands-on leadership role in the development of custom oracle packages in PL/SQL, Unix shell scripts with calls to C/C++, and Perl to automate data warehouse housekeeping tasks.

•Architected a data center migration tool using Visual Studio 2015 IDE with C#/.NET and SQL-Server 2008R2. Used AngularJS and Bootstrap to design the UI.

Acxiom Corporation Chicago, Illinois 2005-2006

TEKsystems – Business Solutions Consultant

•Created data validation reporting system which integrated live data feeds and stored these into a data warehouse.

•These reports were generated using COGNOS and Oracle as the database.

•Implemented reporting schemes using the COGNOS Scheduler application.

•Developed validation test cases for COGNOS reports that verified ETL from a CMS system and other data sources.

•The test cases were executed and validated using Toad Oracle 9.2 and MS Excel.

•Developed shell scripts in Korn Shell on Tru64 UNIX for processing data files using an in-house custom application written in PERL.

•Created change requests for design correction and bugs in the ETL processing.

•Developed and automated a scripting library for COGNOS catalogs.

Key Bank, Inc. Chicago, Illinois 2004-2005

TEKsystems – Business Intelligence Consultant

•Engineered a process to convert reports written in FoxPro to Crystal Reports within the limits of the Oracle database backend strategy.

•Extract Transform Load functions were completed by implementing stored procedures in PL/SQL Oracle environment into a data warehouse schema using Pro*C++ programs.

•Developed a Visual C++ console program that managed a central scheduling program that not only scheduled but handled exception scenarios for ETL programs.

•The C++ VB scheduling program used COM to update MS Excel with status and was able to start ETL processes in parallel for maximum throughput.

•Daily running and supporting of Crystal Reports with various users throughout Key Bank.

•Managed incidents and corrective action/preventative action methods were used to fix defects within reports.

•Created standard reports as determined by business process teams and completed validation scripts and testing plans.

MCI, Inc. Chicago, Illinois 2003-2004

TEKsystems – Business Solutions Consultant

•Worked as a business intelligence solutions developer to create reporting tools using the COGNOS suite.

•This environment was a scalable enterprise solution that incorporated a web-based dashboard that managed the scheduling, processing, and monitoring of reports.

•Instrumental in establishing a method for UNIX Transformer to communicate with a Windows Powerplay using Oracle Pro* C++, when the cube production was completed on the UNIX the windows Powerplay jobs were able to access the cubes using a Pro*C interface. Converted 6.5 Powerplay Report, Powerplay Transformer, Impromptu, and COGNOS macro to the COGNOS 7.x.

•Installed and configured COGNOS 7.x on Windows XP and HP UNIX which connects to a data warehouse on Oracle 8.1.7.

•Established a procedure to convert Impromptu reports to ReportNet.

•Establish a business process to create reports faster.

•Provided daily support on production issues.

CNA, Inc. Chicago, Illinois 2002-2003

TEKsystems – Lead Developer

•Designed and developed sections of a large Disability and Casualty System (DCS) which was written in Visual Basic 6.0 with Oracle 8i as the database component.

•Created and implemented a class generator to speed up the development of the DCS system.

Universal Access, Inc. Chicago, Illinois 2001-2002

Technical Consultant

•Designed and developed a data warehouse for the knowledge management department that evaluates circuit demand information. This data warehouse received most of its data from a Client-Server application written in Visual Basic 6.0 with an Oracle 8 database backend.

•Defined meta-data and business rules

•wrote programs in PL/SQL to clean and transform data from materialized views that were data warehouse specific in the operational system. All cleaning and transformation processes were done through Oracle stored procedures and triggers.

•Transformed operations data into a star schema data warehouse in Oracle 8.1.7.

•Created EIS reports in Crystal Report. The reports were accessible through a VB ASP interface.

•Improved performance of the client-server application by providing background threaded database access.

•The data access methods were encapsulated in COM DLL using ADO asynchronous calls to the Oracle database.

•Configured and implemented a set of server-side cursors which enhanced system performance.

LoveInSite.com, Inc San Jose, California 2000-2001

Programmer / Systems Consultant

•Designed and developed a dating website with Microsoft’s Internet Information Server and VB/COM.

•The matching engine was developed using Neural-Net weighing techniques.

•The site database strategy was Microsoft SQL Server.

•The middle tier was COM/MTS written in Visual Basic 6.0, served by Microsoft’s Internet Information Server.

•Front-end was developed using Active Server Pages.

•Development activities included the setup of a merchant account and a secure server to ensure the secure processing of transactions.

Teldata, Inc Chicago, Illinois 1999-2000

Programmer / Systems Consultant

•Wrote functional requirement specifications for multiple interfaces between SCT Banner and other hardware devices.

•Developed and implemented interfaces written in ProC in a UNIX environment.

•Responsible for completing software quality documentation.

•The interfaces included meter reading for ITRON handheld devices, check processing from the item processor system and stub processing from Career OCR reader.

•The ProC programs are connected to the Oracle database.

•Created and modified stored procedures and triggers used by the Oracle Forms GUI.

•Created an environment that allowed PL/SQL programs to migrate a legacy utility system data to an SCT Banner relational model.

•System Administration on Sun Solaris 2.6.

•Created shell script to produce system information and maintenance reports.

•Upgraded production server E350 to RAID 5 using Disk Suite and Solaris 7.

Monsanto, Inc. Chicago, Illinois 1998-1999

IT Technical Consultant

•Designed and developed a documentation control system.

•Key features of the system were security, version control, and ease of use. The system was developed on Windows NT 4.0 and IIS 4.0 (ASP) for the middle tier.

•ADO/ODBC was used to connect to an Oracle8i database located at the main office in St. Louis. COM specification was used in integrating Microsoft office products such as MS Word and MS Excel.

•Word document model was used for translation for current documents to Html for presentation over the web. (No embedded MS Word documents were used).

•Created a sample ordering application for the Internet with SSL. The application was developed in Java. The application was tied into SAP for maintenance and order processing.

The Epsilon Group, LLC Charlottesville, VA 1998-1999

IT Consultant

•Designed and developed an information inventory system. This system was used for reporting the progress of various information systems currently operational and under development at a large hospital site. Windows NT 4.0 was used and IIS 4.0 (ASP) and VB/COM for the middle tier. ADO/ODBC was used to connect to MS-SQL Server 6.5.

•Provided technical recommendations for a clinical workstation project design and development.

•The Clinical workstation was used by doctors to look at lab and other test results in a real-time environment. The system uses a Cloverleaf interface engine to send HL7 data that is parsed by a C++ program and populated in an Oracle database. This information was then processed and translated by IIS 4.0 for viewing in a web browser.

MicroModule System, Inc. Cupertino, CA 1997-1998

Staff Engineer

•Designed a high availability system for substrate testing in a class 100 cleanroom environment. This system was designed in Java and C++ to control a flying probe tester manufactured by IBM. The controlling process was created on an NT 4.0 workstation, which submitted processing instruction to an OS/2 host connected to the flying probe. The system submitted a test sequence for large area panel testing. Once the panel was tested, the results were stored in an MS SQL Server.

•Established standards for version control of software and documentation for current and upcoming systems.

•Managed a team of electrical/mechanical engineers to complete system design and development activities.

University HealthSystem Consortium Oak Brook, IL 1991-1997

Director of Application Development

Responsible for all application development activities at UHC. Some of the key development projects included the Information Management System. This client/server software was developed for UHC members. Using MS SQL Server as the database and Visual Basic 3.0 for the front-end development, this system provided in-patient resource utilization information.

Data Collection and Analysis System were developed to collect in-patient data using FTP from UHC member sites. Once the data was collected, SAS verification reports were run to analyze the cleanliness of the data. The results were sent to member hospitals for re-submission of data. Once the data was cleaned, it was then risk-adjusted using SAS. The SAS dataset was then stored in an Oracle database as a data repository for further analysis. The Data warehouse system was used as the data repository of in-patient information and specific drug analysis. The data analysis was used to determine the best clinical pathways and to establish a frequency/duration and effectiveness of a delivery route. The data mart was designed and developed using Oracle as the backend and SAS EIS tools for analysis. Established standards for development tools and databases and created guidelines for interaction with clients for rapid development. Managed a team of programmers, technical writers, product specialists, and software application trainers. Instrumental in moving UHC from an Informix 4.0 standard engine to the Oracle 7.3 database.

Illinois Department of Revenue Springfield, IL 1989-1991

System Analyst

Created standard user interface routines in dBase for the PC development group. Provided training for the development community in the usage and implementation of modular programming techniques. Designed and developed a documentation tracking system. This system was developed in dBase IV. This was the standard database for the Illinois Department of Revenue. The system was used by 40 workers who were responsible for tracking/storing tax filings. Provided support PC development group in dBase and C. Wrote Cobol programs. Worked on CICS applications interface development utility on Mainframe.

Professional Training

•Informatica Powercenter Administration

•Informatica IDQ/Developer

•Oracle 9i/10g/11g/12c PL/SQL

•Informix 4GL

•Kimball University: Data warehouse

•Solaris Administration

•AWS Certified Solutions Architect Associate (2016)

Education

B.S., Computer Sciences

Southern Illinois University - Edwardsville, Illinois.

US Citizen.

Contact this candidate