Developer Manager

****, ********* *****

Edison

New Jersey - *****

Email id: **.*********@*****.***

Cell: +1-732-***-****

Abdul Rahman

Profile

Having 13+ years of IT experience encompassing a wide range of skill set, roles and industry verticals.

Currently working as Advisory System Analyst at Client location in IBM India Pvt Ltd since June 2015 to till date (have been an onsite team lead managing offshores from India and Philippines.)

Worked as Application Developer in IBM India Pvt Ltd, Chennai India since Nov 2009 to May 2015

Worked as Software Developer in Tech Mahindra (Satyam Computer Services Ltd.) Hyderabad since June 2007 to Nov 2009.

Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.

Extracted the data from database tables and Flat File data sources, Transformed and Loaded into Target.

Developed mappings/sessions using Informatica Power Center 8.6 for data loading.

Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.

Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.

Building Reports according to user Requirement.

Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.

Coded Unix shell scripts to load the data from flat files into oracle tables through ctl files i.e. through sql loader, flat files generation through Unix SQL files and NAS mounts activities.

Proficient in bash Shell scripting, Python Scripting and basics of Perl.

Worked on Python/Python AWS SDK (Scripting for Cloud integration).

End to End development of Data Warehousing Applications right from requirement gathering, planning, development, testing, automating, debugging and documentation.

Responsible for designing & creation of Informatica mappings, reusable mapplets, sessions and workflows using Informatica power center.

Responsible for end to end testing, preparing deployment document and then deploying packages in Production.

Involved in performance tuning by optimizing the sources, targets, mappings and sessions at Informatica level.

Extracting/Loading data by TD utilities like BTEQ, Fast Load and Multi Load.

Provided the control M set up and same have been implemented in stage and production.

Experienced in leading the team of 6 members for operational applications from Onsite.

Helping business users with their queries about the data in report and providing them with the Ad-hoc data as per their service request.

Implementation and deployment of RFC's in production environment.

Responsible for solving production issues, solving Incidents and helping business users with service requests during hyper care.

Oracle PL/SQL Development (Stored procedures, SQL queries, Query optimization) .

Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.

Comprehensive technical, oral, written and communicational skills.

Skill Set:

RDBMS:

Oracle 9i/10g/11g/12c, Teradata 16.2, and MS SQL Server 2000

Languages:

Oracle PL/SQL, Teradata, Shell and Python scripting, AIX-Unix/Linux 7.5, VB.Net, Web Logic 8/9

O/S:

RHEL, Windows, Solaris, AIX

Tools:

Informatica 10.2, PL/SQL Developer, SQL Navigator, Teradata SQL Assistant, Putty and Visual Studio 2005

Reporting:

Tableau

Methodologies:

ITL, Agile and Scrum.

Education:

B.E in Electrical and Electronics Engineering

OSMANIA UNIVERSITY, India, 2007

Achievements/Certifications:

IBM Service Excellence Award (SEA) in 2014 & 2019.

IBM GIC US Onsite Top Contribution Award (TCA) in 2015 & 2020.

IBM GIC US Onsite Talent Award (TA) 2018.

IBM Manager Choice Awards in 2014, 2016, 2017, 2018 and 2019.

IBM Service Recognition Award in 2019.

IBM-AIX6.0 UNIX certified.

ITIL V3 Foundation Certification.

Certified (1Z0-007) Introduction to Oracle9i SQL

Certified (1Z0-147) Oracle9i: Program with PL/SQL

Professional Experience

October 2017 - Till Date, Advisory System Analyst IBM India Private Limited, India& USA

Project: Johnson & Johnson – Corporate Business Technology:

The primary mission of this Project is to developer, monitor, maintain and enhance HRIPC to extract and transform HR demographic data from Workday and other source systems and storing them in Global Data Warehouse (GDW) to finally feed different downstream systems like Phoenix, Concur, Legal Hold, JIFF, MEDS, Benefits, XConnect, Safe fleet and others.

Human Resource Informatica Power Center (HRIPC): HRIPC is an interface application between WorkDay and GDW built on Informatica 10.2 and Oracle 12c where it processes the xml files from workday and publish txt files to GDW. In HRIPC various events like new hire, rehire, job change, compensation, termination, etc. are created along with the individual position, work and home addresses and organization ids for the employee HR data from workday. Also extracts data from other interface (JJEDS) through LDAP connection for contractors.

Global Data Warehouse (GDW): It is a Teradata system has been designed and maintained to host current and historical demographic data for both employee and contingent worker. It gets data from GDI system and gets updated with daily delta changes. GDW is act like a main source for global HR data for its downstream system. There are many downstream systems receives daily /weekly/ monthly feed from GDW which has been implemented though Informatica Power Center and Unix Scripts. Some of the downstream systems of GDW are Phoenix, Concur, Legal Hold, JIFF, MEDS, Benefits, XConnect, Safe fleet, GCRAFT, Compliance Wire and others.

Phoenix: It is the major and business critical downstream systems of GDW, has been designed to extract employee’s demographic indicative data as well as Global Mobility information from GDW system and payroll information from OurSource (SAP) system to generate consolidated feed to J&J employee’s Equity Compensation Management (ECM) system known as Fidelity. Fidelity is externally hosted third party system to manage employee’s stocks (RSU/PSU), grants and options, as well as ensures proper tax calculation of them. Informatica Power Center along with Unix shell script has been used to perform extraction of data from different upstream systems, perform merging and delta detection and finally generate encrypted delta feed to Fidelity system.

CMOD: Content Management on Demand is interface system to JNJ Payroll system i.e. OurSource where multiple files are received and processed into format in required format for the end-users. This system is built on Linux shell scripts and Oracle Database.

In this project I have performed below duties to provide support-maintenance & implementing enhancements.

providing solutions using his expertise on Teradata, Informatica Power Center, Unix Scripts along with Oracle PL/SQ.

Developed ETL programs using Informatica to implement the business requirements.

Communicated with business customers to discuss the issues and requirements.

Created shell scripts to fine tune the ETL flow of the Informatica workflows.

Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.

Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.

Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.

Reviewing of existing system design for possible remediation areas.

HRIPC Application development/enhancements/production support and business integration.

Integrating business needs and technology solutions.

Application designing and prototype developments to achieve the business needs.

Provide day to day support for any technical issues encountered in the project.

Ensuring highest quality of deliverables and timelines following IBM as well as J&J quality process.

Have been providing day to day support for any technical issues encountered in the project during HRIPC hyper care.

Training, defining support procedures and implementation of the post go-live policies.

Providing Automation and continuous process improvements for application performance and reduction of incident volume.

OurSource Payroll GL Reports: These GL payroll reports are built on Tableau 10.2 for the end users. Has been a front-line support member in providing resolution to all production support issues faced by end users in Tableau reporting and data issues in database built on oracle 12c. CMOD has been a backend system for Tableau reporting.

Environment: Informatica Power Center 9.6/10.2, Teradata v16, Unix/Linux, Oracle PL/SQL 12c, Tableau 10 and IRIS

Team Size: 5

June 2015 – September 2017, Application Developer IBM India Pvt. Ltd. India

Project: ITHR – Johnson and Johnson

I have been working in ITHR of portfolio by handling/supporting/migration/enhancement of below suite of applications.

Compensation Navigator (CompNav)

Executive Compensation Manager (ECM)

Global Access Equity Tool (GATE)

Benefit Reporting

STEP and GxRS

BRAVO

BRAVO:

Bravo is a BCA, a J&J primary Financial Reporting and Consolidation system for both Public and management reporting. It will be or is open for the month end submissions for over 350 affiliates will be submitting their financial information into the bravo Consolidation system.

Worked on development of SOX Audit reports.

Installation/Configuration of secure certificates on Linux servers both WebLogic and Oracle EBS.

Have been working on file load into DB by various informatica work flows.

Have been working/worked on various production issues.

Worked on various deployment activities on ETL errors.

Compensation Navigator:

CompNav is a worldwide decision support tool designed to assist Line Managers and Human Resource staff with compensation planning. In particular, this includes support for the year-end compensation planning cycle. The cycle formally begins in November and finishes in February with the issuance of bonuses and other forms of year-end compensation.

CompNAV is accessible on a year-round basis and is not closed at the end of the year-end planning cycle. Managers can view the compensation of their staff at any time. Managers can also access information on Johnson & Johnson’s compensation policies, guidelines, and other relevant information regarding compensation at the Compensation Navigator portal site.

• Initially assigned to CompNav suite of applications where I successfully took the transition and provided continuous on time support.

• Worked on UNIX scripts for pushing the file to mbox.

• As an integration support person, completed all the integration deployments on time so that deliverables do not get affected.

CompNav provides several reports for management reporting and for profile generation where user generate huge amount of reports during Nov – Feb.

Successfully handled the issues during report generation which are built on Crystal XI R2 and clustered (CMS) on 4 different servers.

J&J follows an unique way for migrating changes from one region to another using Serena PVCS Version Manager (v8.2) and Merant Tracker(v8.0) along with ticketing tool IRIS so that after development phase the change will go through several testing phase in integration and quality/Staging server before moving to production server. There is another internally used tool has been implemented to accelerate the complex migration process.

ECM & GATE:

The LTI program provides incentives for J&J leaders, aligning employee and shareholders’ interests, motivating them to contribute to the success of the company.

ECM is responsible for tracking and managing stocks that are granted to employees around the globe, serving as the midpoint between Computershare, the grantee and the broker.

• Involved and actively/effectively handled all ECM/GATE issues.

• After joining ECM/GATE team, with in 2months proposed and completed the Automation of weekly termination reports.

• Provided all adhoc reports to ECR's in time so that they can complete their closing for which received good feedback for quick response.

• Actively participated in periodic activities i.e. monthly reports, quarterly RSU issuances, etc.

• Keep monitoring the GATE exercise issues and helped customers in providing temporary fixes and prevented escalations.

• Investigated complex issues between GATE and SMTP relay servers and keep updating the customers for which they felt happy for the timely updates.

• Received good feedback from ECR's for multiple occasions for providing on time help.

• Has successfully worked on Automation of Unix job monitoring project, which is being handled manually for quite long time due to which ticket count reduced a lot.

• Identified and fixed the long-time data issue (ECM Demog Sync) which has been not noticed for which customer was impressed.

• Improved the oracle procedures by handling the exceptions in better way so that we can have updated data, insert data, bad data and exception data on daily basis. This is served as nice report during sox audit.

Benefit Reporting:

Successfully handled the SDDC migration project where it has migrated from UNIX to Linux i.e. RHEL2.6.

Interacted/Co-ordinated with different teams (IDM, Unix Admin, Linux Admin, SDDC Migration team, Oracle DBA team and Tidal team) for below various tasks and successfully completed the migration for all environments within time without any escalation.

Allocation of memory disc on the Linux servers.

Creation with service accounts with proper privileges.

Creation of application mount point and File System.

Loading/Mounting of NAS mount points on both application and database servers.

Installation of Oracle Client 11g on Linux Application server.

Extensively worked with DBA team for migration of oracle objects, users with proper privileges, dropping of specific users, NAS mount point issues, etc.

Successfully modified/improved UNIX/Linux scripts and tested successfully.

Installed/configured python and its components on Linux (RHEL).

Python scripts has been successfully migrated/configured from Windows machine to Linux servers (RHEL) so that we reduced the cost of windows workstation for python jobs.

Additionally, supported STEP and GxRS applications by providing continuous monitoring support to the application, parser services, Informatica workflows, analyzing and providing fix to data issues, DB Patching activities on weekends etc.

Environment: Oracle PL/SQL, UNIX & RHEL Shell Scripting, Crystal XI R2, Crystal Info View XI R2, ASP, ASP.NET, SQL-SERVER.

Team Size : 20 members

Achievements:

Received Top Contribution Award 2016 (TCA).

Received excellent feedback from customer for SDDC migration project for Benefit Reporting.

Nov 2009 – May 2015, Application Developer IBM India Pvt. Ltd. India

Project: Finance/ValueQuix – Xerox Corporation

I worked in XEROX project Since October 2009 onwards where I have handled multiple applications and responsible for supporting and Maintaining, Enhancing and implementing all financial related applications for Xerox Corporation, USA.

The complete project was segregated in terms of partitions and groups totally we have 6 Partitions and 8 groups. Each partition contains multiple groups and each group contains multiple applications. I belongs to Finance & Governance portfolio where it contains the below applications

Global E-Pay

Purchasing Card (PCARD)

Xerox Approval Authority (Approval Authority Search Tool)

North American General Ledger (NAGL)

Xerox Application Portfolio (XAP)

Freeze Exception Processing System (FEPS)

Capital Reporting System (CRS)

Etime & Payroll and

ValueQuix System Engineering Module.

Proactive monitoring and resolving the issues and completing the issues raised by the clients within the expected time.

Installation, Configuration, Troubleshooting and Maintenance of Web Logic Server 9.2

Monitoring the WebLogic Server and Deployed applications.

Provide technical support and solutions for problems faced in critical issues to the team members.

Reviewing and implementing the updated code changes in to production environment.

Updating weekly reports (completed, Tickets with issues and additional achievement) to immediate Leads.

Worked in accordance with the Production Support Resource Roles and Responsibilities, including understanding the clients’ business, On-call duties and researching and resolving issues within the SLA commitments.

Did enhancements and gave new idea to the customers that helps to improve the business functionality.

No delivery related Customer escalations.

Effective responsiveness to Customer requests/crisis situations - Lead the crit-sit and incident resolution meetings. Drive Client Meetings in accordance with meeting guidelines and ensure everyone from the team participates. Up to date understanding of all project issues (including end client owned) and risks and active participate in resolution and mitigation.

Drove innovation, demonstrate business value add and continuous improvement, driving cost and process benefits for Client/IBM.

Drove high quality of documentation in the team- design documents, AID, ASCP, tech specs, Test scripts/cases, Ticket resolution, RCA, Migration request

Have been taking responsibility of System Load Testing (ValueQuix) for every major build during non-business hours.

Have been successfully handling VQX System Engineering Activities which includes deployment of builds in time without any delay, monitoring of VQX QA application so that it is available to users and our testing team for their activities, monitoring and resolving locater-router services, resolution of issues/errors from GUI launch.

Environment: Oracle PL/SQL, UNIX Shell Scripting, WebLogic 9.2, ASP, ASP.NET, SQL-SERVER.

Team Size : 22 members

June 2007 – November 2009, Developer Mahindra Satyam

Project: Product Development

Initiative by the client to provide an online channel for Diasporas of the country so enabling them to connect to their origin and help in its development. The portal includes sub portals like

My Connect – a social networking portal

Service Connect – an online retail portal

Philanthropy Connect – a portal to help society

Government Connect – a portal for all government related services and information.

Under these verticals, Non-resident Indian (NRIs) may request for bill payments, property management, legal and taxation services, school or college admission information service, travel and leisure, visit by Relationship Ambassador and other specialized concierge services.

As a Developer and Functional Analyst, I am responsible for

Design and Development of database of entire project.

Monitoring the performance of stored procedures using SQL Profiler

Coding using sql/plsql

Wrote stored procedures using sql/plsql.

Load testing on the database

Gathered and updated required information for look up tables.

Active participation in DataModelling process, redefined all the databases removing existing drawbacks.

Developed the logic for propose functionalities using C sharp as the programming language and ASP Dot Net 2.0 as the technology.

Environment: ASP, ASP.NET, Oracle PL/SQL and SQL-SERVER.

Team Size : 15 members

Achievements:

Rated as a “MERITORIOUS” performer for first year’s performance in Satyam.

Rated as a “MERITORIOUS” performer for second year’s performance in Satyam.

Contact this candidate