Software Engineer Manager
Resume:
Shahjade Alam
King of Prussia, PA
*********@*****.***
• 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