Kamran Roy
Milwaukee,WI
Summary
Motivated and focused data integration engineer with 7+ years of experience and a positive attitude seeking to apply advanced data management skills to collaborate with business, technology, and operations partners to foster a culture of information sharing and learning. Able to swiftly gain an in-depth understanding of data structures and apply that knowledge to maintain, correct and improve business processes. Proactive, flexible, and a great team player.
Overview
11
11
years of professional experience
Work History
Data Integration Engineer
HealthEquity
Draper, UT
12.2015 - 04.2022
- Analyzed, identified, and resolved data issues by creating complex scripts to resolve data conditions and anomalies in an efficient and effective manner that is in accordance with established Service Level Agreements (SLA’s)
- Collaborated with external vendors and internal relationship partners to implement new mappings and data pipelines that accurately extracted and loaded healthcare data in production environment via SFTP
- ETL of data from mainframe flat file source to SQL Server by implementing data cleaning, T-SQL Scripting and SSIS data pipeline creation
- Provided support for implemented data mappings in Prod by trouble-shooting any active issue by finding root cause to develop long-term solutions via updating existing data pipe line configurations
- Use Excel, Access, SQL, Azure, and other tools to provide valuable insights to business leadership
- Implemented new reporting process to maintained existing RO Inbound Queue process
- Train and mentor new team members by building on their existing skills and knowledge to best fit the needs of the company
- Provided recorded material and procedural documentation for existing process to support live mappings
- Lead New Platform Implementation as product owner working with the team of developers by providing timely feedback with Business Logic and User Interface Testing procedures
- Participated in Scrum ceremonies throughout new platform development cycle and supporting production environment.
- Worked closely with customers, internal staff and other stakeholders to determine planning, implementation and integration of system-oriented projects.
- Participated in system development life cycle from requirements analysis through system implementation.
- Provided 2nd and 3rd level technical support and troubleshooting to internal and external clients.
Business Consultant Specialist
Northwestern Mutual
Milwaukee, WI
02.2015 - 08.2015
- Designed and developed report “mockups” based on business requirements
- Conducted functional and user acceptance testing for Performance Program Enhancement project within the agency business area
- Built a SQL Server from the ground up to move data needed for a Business Object project
- Moved, extracted, and maintained data files based on client requirements using SQL
- Used SSIS and SSAS for data deployment of Business Objects reports
- Composed procedural documentation for measuring velocity for incident tickets
- Standardized and managed internal work tracker tools to measure work efficiency for incident tickets generated in HPService Manager
- Implemented Business Object reports for quality incentive bonus statement checkout process
ETL Informatica Developer
Northwestern Mutual
06.2013 - 08.2015
- Involved in design, development, and maintenance of database for Data warehouse project
- Involved in Business Users Meetings to understand their requirements
- Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica 9.1
- Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations
- Worked extensively with the connected and unconnected lookup Transformations using dynamic cache
- Created and scheduled Sessions, Jobs based on demand, run on time and run only once
- Monitored Workflows and Sessions using Workflow Monitor.
Investment Systems Business Intern
09.2013 - 01.2015
- Developed business requirements as part of a cross-functional team and translated requirements into technical specifications for developers
- Supported and led the design databases with senior database architects
- Used Bloomberg and Barclays Point to create reports using data from external data sources
- Participated and led daily business operations within the Investment business department
- Modified Business Objects Universe layer and created various reports
- Documented provisioning process for the implementation of new environments such as MSBI (Microsoft Business Intelligence Tool) installation process
Summer Intern
Information Systems
06.2013 - 08.2013
- Worked on a large PeopleSoft re-implementation project:
- Created Excel macros to analyze data patterns
- Utilized Excel to validate Cognos Report tree nodes
- Processed various data reconciliation during testing
- Extracted data from Essbase database and transformed it so that it could be fed into PeopleSoft
- Created Autosys Production Batch jobs using internal PBRS system
- Presented and participated in projects related to Diversity & Inclusion
Education
Bachelor of Science - Business Administration, Finance and Information Science Technology
University of Wisconsin Milwaukee
Skills
- KAMRAN ROY
- RELEVANT TECHNICAL SKILLS:
- Microsoft SQL Server, Microsoft SSIS, SQL,
- Oracle, Business Objects, Bloomberg, Barclays Point
- Microsoft Excel VBA
- Share Point Designer, CAAutosys,
- PowerCenter ET Informatica,
- File Center (HealthEquity File Processing ETL Tool), Complink (HealthEqutiy Data Editor Tool)
- Database Design
- Technical Documentation and Reporting
- Third-Party Systems Integration
- Critical Thinking
- Team Communication and Collaboration
- Customer Relationship Management
- Reading Comprehension
- Team Training
Timeline
Data Integration Engineer
HealthEquity
12.2015 - 04.2022
Business Consultant Specialist
Northwestern Mutual
02.2015 - 08.2015
Investment Systems Business Intern
09.2013 - 01.2015
ETL Informatica Developer
Northwestern Mutual
06.2013 - 08.2015
Summer Intern
Information Systems
06.2013 - 08.2013
Bachelor of Science - Business Administration, Finance and Information Science Technology
University of Wisconsin Milwaukee
Similar Profiles
Matt StevensMatt Stevens
Sr. Director (AVP) of IT at HealthEquitySr. Director (AVP) of IT at HealthEquity
J.R. WYSSJ.R. WYSS
Trust Supervisor at HealthEquityTrust Supervisor at HealthEquity
SCOT STANGERSCOT STANGER
Implementation Manager at HealthEquityImplementation Manager at HealthEquity
Shelly BashShelly Bash
Senior Implementation Manager at HealthEquitySenior Implementation Manager at HealthEquity
Anadion MaddoxAnadion Maddox
In-Store Shopper at Whole Foods Market IncIn-Store Shopper at Whole Foods Market Inc