Shahjade Alam

King of Prussia, PA

adhr52@r.postjobfree.com

323-***-****

• ETL developer with 8 years of experience in Business Intelligence (BI), Data Warehouse (DWH), and associated concepts

• Worked on all phases of BI including analysis, design, development, and testing

• Expert in enhancing performance at ETL and database levels

• First-rate ability to comprehend and deliver business requirements, ensuring zero defects and high client satisfaction

Authorized to work in the US for any employer

Work Experience

Senior Software Engineer (ETL Developer)

Majesco - King of Prussia, PA

March 2020 to Present

Gather and analyze information on business problems or procedures and data challenges of clients' organization and industry

• Review and edit requirements, business processes, recommend solutions and alternatives

• Coordinate with business personnel for smooth system implementation and rollout

• Draft and maintain the required documentation during the development/enhancement which helps create a knowledge repository

• Help testing efforts and ensure issues are identified, tracked, reported and resolved in a timely manner

• Identify and highlight the risks and critical issues that impact the delivery of the development work

• Work closely with the client in finalizing the design for the system, resolving production issues, deployment, debugging, etc.

• Highlight and communicate all critical issues to the management that enables timely resolution.

• Communicate with the offshore team daily to take care of any operational issue or queries

• Implement and adhere to the software development process laid down by the customer team for the smooth development of application and modules

• Attend the daily status meetings with the client and act as a bridge between the client and the offshore team

• Follow standards, policies, and guidelines for coding, documentation and other deliverables

• Undertake additional responsibilities and tasks to help enhance the processes

• Understand the concerns of different teams, network and build relationships to achieve progress towards larger goals

• Deliver high-quality results in compliance with the observations highlighted in the client-side User Acceptance Testing (UAT) reports

Senior Software Engineer

Majesco - Mahape, Maharashtra

June 2016 to February 2020

• Integrated data from Duck reek, Genius, CDW, and PolicyCenter and processed it to Staging Area

• Built Dimension and Fact using staging data as per business requirement and technical specification for EEDW Data warehouse

• Successfully developed Policy Dimension in EEDW

• Closely worked with Business Analysts and Data Architects to understand the requirement and drive to fruitful results

• Worked extensively on Slowly Changing Dimensions logic to load data in the database

• Worked on building Operational data store, data marts, and EDW for all lines of business like General Liability, Surety and Policy Center

• Used parameters and Variables to enhance the flexibility of code

• Identified all bottlenecks in the ETL code; also worked on enhancement and change requests

• Broadly used session, email, command, event, timer and decision tasks

• Automated and built a single workflow to load all lookup tables with the same structure

• Extensively analyzed data flow from Source to Operational datastore to EDW as per business requirements

• Developed pass through partition logic for the Mapping for faster processing of data

• Built mapping to handle Change data Capture(CDC)

• Validated data before and after loading into the target database

• Participated in system and user acceptance testing

• Provided Knowledge Transfer sessions to new team members

• Passionately led, trained and educated juniors to adhere and work as per the business

• Worked on all phases of data warehouse development lifecycle from gathering requirements to testing, implementation, and support

• Exceptional background in analysis, designing, development, customization, and implementation & testing of software applications and products

Associate

Cognizant - Airoli, Navi Mumbai, Maharashtra

March 2016 to June 2016

• Developed Informatica workflows and monitored results on a continual basis

• Leveraged shell scripting to automate the ETL, enhancing the efficiency of the mapping process

• Supervised and validated the efficacy of the workflows through rigorous data analysis

• Delivered high-quality results, complying with the observations highlighted in the client-side User Acceptance Testing (UAT) reports

Associate Consultant

Capgemini - Pune, Maharashtra

April 2015 to February 2016

Developing ETL Mappings using needed mapplet and transformation according to technical specifications

• Developed pass through partition logic for the Mapping for faster processing of data

• Extensively used mapping Debugger to analyze data flow

• Created Shell script to trigger, stop, start ETL workflows using pmcmd commands

• Used parameters and Variables to enhance the flexibility of Code

• Identify all bottlenecks in mapping on the source, target, and mapping Side

• Worked on Reusable And Non-Reusable Task in Workflow Manager

• Worked on Pre/Post session Tasks

• Broadly used session, email, command, event tasks, timer and decision tasks in Workflow Manager

• Provide Knowledge transfer to the new and junior member of the team Senior Software Engineer

Capgemini - Pune, Maharashtra

April 2014 to March 2015

• Built complex ETL mappings and created Shell scripts in conjugation with ETL mappings

• Worked extensively on Mapplets, Reusable Transformation, and Session properties to create customized jobs

• Transformed data as per the 'code pages' for different databases including Sybase, DB2, MSSQL, etc.

• Developed Mapplets that understand Japanese Kanji characters

• Migrated ETL code to QA, UAT, and production environment using Informatica Repository Manager Software Engineer

Capgemini - Pune, Maharashtra

August 2012 to March 2014

• Developed, provided support and monitored ETL jobs running in production environment

• Built Informatica mapping using transformations like Expression, Filter, Router, Sorter, Rank, Source Qualifier, Aggregator, Joiner, Sequence Generator, Union, Update Strategy, Lookup (Connected and Un- Connected), and Data Masking

• Developed the logic of sub-setting of data based on rows, column & data volume

• Participated in peer reviews conducted within the development team

• Created Auto Sys JIL (Job Information Language) and integrated it in Dev, QA, UAT & production environment

• Built Shell scripts to enable/disable constraints and drop/create indexes on tables

• Created Informatica Workflows using Workflow Manager and monitored the results using Workflow Monitor

Graduate Engineering Trainee

Mahindra & Mahindra Ltd., FES, Swaraj Division - Chandigarh, Chandigarh January 2012 to June 2012

Created innovative masking models (using Ansys & PTC Creo Elements/Pro) for tractor axles that helped insulate their threads, enabling selective coating at the time of manufacturing. Graduate Engineering Trainee

SAI GROUP - Roorkee, Uttarakhand

May 2010 to July 2010

Conducted stress & strain analysis on select automotive spare parts using CAD/CAM software including

Ansys and PTC Creo.

Education

Bachelor of Technology in (B.Tech.), Mechanical Engineering The ICFAI University

2008 to 2012

Skills

• Informatica

• Shell Scripting

• Unix

• Data Warehousing

• Business Intelligence (BI)

• Investment Banking

• Insurance

• Oracle SQL

• Oracle

• SQL Shahjade Alam -

• Microsoft SQL Server

• MySQL

• User Acceptance Testing

• Requirements Gathering

• User Interface (UI)

Links

http://linkedin.com/in/shahjade-alam

Certifications and Licenses

Analyzing and Visualizing Data with Microsoft Excel DataCamp #16,154,939 Intermediate SQL Server

DataCamp #16,182,995 Oracle Certified Expert Database SQL Oracle Improving Query Performance in SQL Server

DataCamp #16,197,121 NSE

Certification in Financial Markets

National Stock Exchange of India Limited NCFM-000********

Contact this candidate