Summary
Overview
Work History
Education
Skills
Timeline
Senior Business Analyst
Open To Work

Naveed Syed

Uline Shipping Supplies
Lombard,IL
20
Years of experience

Business Analyst with expertise in stakeholder management, requirement gathering, and strategic planning. Uses analytical thinking and data-driven decision-making to improve processes and guide business choices. Communicates clearly, solves problems effectively, and adapts quickly to shifting priorities while supporting team collaboration.

Work History

Senior Business Analyst

3 Years 6 Months
Uline Shipping Supplies | 05.2023 - 11.2026
  • Collaborated with stakeholders to translate business needs into clear functional specifications for system enhancements.
  • Led business requirements gathering for shipping supply operations, aligning solutions with finance, inventory, and logistics teams.
  • Analyzed order fulfillment workflows to identify process gaps and improve operational efficiency across departments.
  • Developed reporting dashboards using SQL and Excel to support data-driven decision-making.
  • Evaluated inventory and sales data to support forecasting, replenishment, and service-level planning.
  • Recommended process improvements that strengthened accuracy, reduced manual effort, and supported scalable operations.
  • Managed stakeholder expectations through transparent communication and timely status updates, ensuring alignment between project deliverables and business objectives.
  • Facilitated requirement gathering workshops, resulting in clear project objectives and deliverables.
  • Led process mapping initiatives, resulting in optimized workflows and reduced redundancies across departments.

Application Programmer

1 Year 6 Months
Bank of America | 08.2021 - 02.2023
  • Working with product owners, business users, technical leads, subject matter experts, and technical support groups to understand business requirements and deliver solutions that meets the business need.
  • Created new mapping and workflows using Informatica version 10.5 based on business requirements.
  • Modified existing ETL code to resolve issues identified by team lead and deployed changed code to production using continuous integration and continuous development (CI/CD) after testing code for bugs.
  • Working with product owners, business users, technical leads, subject matter experts, and technical support groups to understand business requirements and deliver solution that meet the business need.
  • Modified ETL mapping to resolve data quality issue and deployed the changed code via the change management process followed at the bank.

Sr Informatica Developer

8 Months
Royal Caribbean Cruise Ltd. | 11.2020 - 07.2021
  • Collaborated with initiative leads, business users, technical leads, subject matter experts, and technical support groups to deliver solution and value to business.
  • Modified SQL queries to create partition table and views for fast data extraction and used the materialized view for net revenue calculation for onboard revenue (OBR) and sales revenue.
  • Developing ETL process using Informatica Power Centre to load data from a wide range of sources such as Relational databases such as Oracle, SQL Server, Stored procedure, Flat files, XML files, JSON etc.
  • Used the Web Consumer Services and APIs (example WSDL, SOAP) for updating the key definitions for the project.

Informatica Analyst

6 Months
Pixelle Specialty Solutions | 04.2020 - 10.2020
  • Migrated complete system from existing environment to new environment after clients acquired two new mills.
  • Installed and configured Informatica 10.2 server and client on DB2 database for client new to Informatica, setting up Development and Production environments.
  • Created user accounts with admin, development, and execution or monitoring-only privileges.
  • Worked on technical specification documents like system design and detail design documents for the development of Informatica mappings and workflows to load data into various target.
  • Designed and developed ETL process using Informatica Power Centre to load data from wide range of sources such as Relational database, SAP ECC load, Flat files, XML files etc.
  • Migrated folders, mappings, and sessions from development to test environment and created migration documents to move code from one environment to another environment.
  • Developed and modified mappings and mapplets to load data from various sources using Source Qualifier, Filter Expression, Lookup, Router, Update Strategy, Sorter, Normalizer, Aggregator, Joiner, SQL, and XML transformations based on business logic.
  • Created Test cases for Unit Test, System Integration Test and UAT to check the data.
  • Troubleshooted and fixed testing defects and supported all testing, including Development Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing, and Performance Testing.
  • Developed PL/SQL Stored Procedures, Views and Triggers to implement complex business logics to extract, cleanse the data, transform and load the data into the SQL server database.
  • Extensively used various active and passive transformations like Filter Transformation, Router Transformation, Expression Transformation, Source Qualifier Transformation, Joiner Transformation, and Look up Transformation, Update Strategy Transformation, Sequence Generator Transformation, Rank Transformation, and Aggregator Transformation.

ETL/Informatica Developer

2 Years 2 Months
JPM Chase Bank | 09.2016 - 11.2018
  • Customized data models for Data warehouse supporting data from multiple sources.
  • Developed Logical and Physical data models that capture current/future state data elements and data flows using Erwin.
  • Extensively worked with transformations Lookup, Update Strategy, Expression, Filter, Stored Procedures, Router and others.
  • Did CDC by using the mapping variable for the insert/update date.
  • Used Informatica techniques to load data from MS SQL Server, XML files, and flat files into target Oracle database.
  • Optimized/Tuned mappings for better performance and efficiency.
  • Developed mapping parameters and variables to support SQL override.
  • Worked extensively on error handling methodology.
  • Participated in the detailed level and high-level design documentation of the ETL system and mapping of business rules.
  • Maintained data quality and data consistency before loading into the database.
  • Parsed the data from XML’s XSD file using xml transformation.
  • Created entities, categories, periods and accounts (Dimensions) info for reporting units in Hyperion.
  • Customized data models for data warehouse supporting data from multiple sources.
  • Developed logical and physical data models capturing current and future state data elements and data flows using Erwin.
  • Used B2B data transformation to get data from unstructured sources (XML).
  • Retrieved and Loaded data into sales force dot com (SFDC) and Sales Vision.
  • Supported detailed level and high-level design documentation of the ETL system and mapping of business rules.
  • Designed and developed table structures, stored procedures and functions to implement business rules.
  • Developed error handling methodology.
  • Tested the data and data integrity among sources and targets using Unit Testing.
  • Supported Production support team in various performances related issues.
  • Environment: Informatica Power Center 10.1/9.6.1, Informatica IDQ, Oracle 10g, SFDC, SSIS, Sales Vision, PL/SQL, Toad, XML, SQL
  • SQL Server, SAP BW, Erwin 7.2, HP UNIX, Shell Script, Autosys.

Senior Informatica Developer

11 Months
Baylor Hospital | 09.2015 - 08.2016
  • Developed Informatica mappings and workflows supporting enterprise hospital data integration.
  • Designed ETL solutions for patient, finance, and clinical reporting systems.
  • Optimized SQL queries and transformation logic to improve data processing efficiency.
  • Maintained Informatica repository objects, sessions, and workflow dependencies with accuracy.
  • Troubleshot failed jobs and resolved data quality issues across source-to-target loads.
  • Coordinated with analysts and database teams to align integration requirements and delivery.
  • Led code reviews and enforced development standards for reusable Informatica components.
  • Documented interface logic, mappings, and deployment procedures for support and maintenance teams.
  • Maintained proper documentation for all developed jobs, facilitating easier troubleshooting and knowledge transfer within the team.
  • Assisted in the design and development of data marts and warehouses, ensuring seamless integration with existing systems for comprehensive reporting and analytics capabilities.
  • Provided expert guidance on best practices for Informatica development to junior team members, fostering a culture of continuous learning.
  • Implemented data security measures such as encryption at rest and in transit, safeguarding sensitive information from unauthorized access.
  • Streamlined ETL processes by designing reusable transformations and mapplets for optimized performance.
  • Optimized performance through careful monitoring of system health, identifying bottlenecks, and implementing enhancements as needed.
  • Ensured timely delivery of high-quality projects by efficiently managing workloads and prioritizing tasks based on business impact.
  • Reduced development time by creating reusable templates and automating common tasks in the ETL process.
  • Environment: Informatica Power Center 10.1/9.6.1, Informatica IDQ, Oracle 10g, SFDC, SSIS, Sales Vision, PL/SQL, Toad, XML, SQL
  • Loader, SQL Server, SAP BW, Erwin 7.2, HP UNIX, Shell Script, Win XP, Autosys.

Data Integration Engineer

1 Year 10 Months
National Oilwell Varco (NOV) | 10.2013 - 08.2015
  • Implemented ETL Informatica designs and processes to load data from sources to target warehouse.
  • Designed mappings from scratch and also did performance tuning of the mappings that were previously implemented.
  • Led integration architecture for drilling equipment controls, aligning PLC, SCADA, and HMI interfaces.
  • Developed interface specifications and validation plans for automation systems and third-party hardware.
  • Troubleshot communication faults across Ethernet, Modbus, and fieldbus networks during commissioning.

ETL Developer

1 Year 10 Months
Kohl's | 11.2011 - 09.2013
  • Created Mappings using Mapping Designer to load data from various sources, using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Normalizer, Filter and Router transformations.
  • Converted business rules into technical specifications for ETL process.
  • Created conceptual data model by gathering business requirements from functional teams, business analysts, and business documents.
  • Involved in performance tuning of the Informatica mapping and identifying the bottlenecks.
  • Used SQL for data analysis and reporting tasks.
  • Worked extensively on Flat Files, as the data from various Legacy Systems is flat files.
  • Created mapplets using Mapplet Designer and used those Mapplets for reusable business process in development.
  • Created re-usable transformations and Worklets.
  • Implemented error handling strategy for reliable data processing workflows.
  • Worked with UNIX shell scripts to perform pre-session and post-session operations.
  • Used Shell script and Perl script to audit check on the flat files before loading the data into National data mart.
  • Generated unit test and case text documents.
  • Analyzing business processes, functions, existing transactional database schemas and designing star schema models to support the user’s reporting needs and requirements
  • Improved performance tuning of Informatica mapping and identifying bottlenecks.
  • Extensively worked with Informatica server that runs on UNIX platform and used workflow monitor to monitor Informatica server and reviewed session logs that it generates for failed sessions.
  • Conducted code review sessions with BSA, Project Managers and with Technical Team.
  • Generated Unit test and case text documents.
  • Designed the data warehouse tables based on the functional requirements.
  • Environment: Informatica Power Center 9.X/8.6.1, Workflow Designer, PowerCenter Designer, Repository Manager, Oracle 10g/9i, SQL, PL/SQL, SQL Loader, UNIX Shell Scripting, Windows XP

Design Engineer

3 Years 3 Months
Tri Ocean Engineering Ltd | 06.2006 - 09.2009
  • Designed well tie-ins, pipelines and facilities for various oil and gas clients including Shell, Cenovus, Aramco etc.
  • Collaborated with clients and internal engineering team to collect data related to design and maintain compliance with relevant design codes and client specifications.
  • Mentored junior engineers and checked their design calculations and drawing for accuracy.
  • Delegated and coordinated deliverables to support on-time completion of assigned projects.
  • Arranged weekly meetings to discuss issues on hand and recommended a mitigation plan for resolution.

Education

Batchelor’s in Engineering - Mechanical Engineering

NED University of Engineering & Technology | Karachi, Pakistan | 08-1998

Skills

Software development lifecycle management
Requirements gathering
Agile methodology
User acceptance testing
Interview facilitation
Business process mapping
Requirements documentation
Gap analysis
Data modeling
Workflow design
SQL proficiency
SQL reporting
Process mapping
Dashboard development
Extensive experience as ETL Developer in technologies and methods using Informatica PowerCenter and Pentaho.
Dimensional data modeling
AWS cloud services
SQL performance tuning
Data modeling
Business requirements analysis
Client communication
Oracle data warehouse development
MS SQL
Oracle 12c
Test case development

Timeline

Senior Business Analyst

Uline Shipping Supplies
05.2023 - 11.2026Read More

Application Programmer

Bank of America
08.2021 - 02.2023Read More

Sr Informatica Developer

Royal Caribbean Cruise Ltd.
11.2020 - 07.2021Read More

Informatica Analyst

Pixelle Specialty Solutions
04.2020 - 10.2020Read More

ETL/Informatica Developer

JPM Chase Bank
09.2016 - 11.2018Read More

Senior Informatica Developer

Baylor Hospital
09.2015 - 08.2016Read More

Data Integration Engineer

National Oilwell Varco (NOV)
10.2013 - 08.2015Read More

ETL Developer

Kohl's
11.2011 - 09.2013Read More

Design Engineer

Tri Ocean Engineering Ltd
06.2006 - 09.2009Read More

NED University of Engineering & Technology

Batchelor’s in Engineering from Mechanical Engineering
Read More
Naveed Syed