SUMMARY

• Result drive professional wif over8 years of experience providing technical solutions, Application support through high - quality service and support.
• Extensive experience in ETL development and supporting Datastage application wif managing infrastructures and applications across UNIX, Linux and Windows platforms.
• Highly experienced Production support analyst, working as first tier of POC for any failure and remediation of any application error/issue.
• Extensive knowledge in monitoring tools like Zena and Autosys
• Vast experience in high-volume environments wif strong analytical communication and organizational abilities
• Experience wif Datastage/Informatica administration on a Unix based system - migration, installation, patches, ticket creation, user handling, security.
• Experienced in working wif Oracle, SQL, DB2,
• MS Excel on UNIX and Windows platforms
• Ability to work for long hours and deliver results wifin reasonable timeframe to ensure client satisfaction
• Ability to handle multiple tasks simultaneously wif equal attention
• Proven ability to create and deliver solutions tied to business growth, organizational development and tool optimization. Skilled problem identifier and troubleshooter comfortable managing systems, projects and teams in a range of IT environments
• Ability to build strong relationships wif business partners and ensure uninterrupted business flow in day to day processes in an efficient manner

AREAS OF EXPERTISE

• IBM Infosphere Datastage
• Development
• Administration
• Informatica
• Development
• Administration
• Oracle SQL, DB2
• Base SAS
• UiPath - RPA tool
• Production Support
• Monitoring tool Zena, Autosys
• Interpersonal skills
• Project Management
• Working wif shifting priorities
• Team player
• Fast Learner
• Good Analytical skills

PROFESSIONAL EXPERIENCE

ETL Developer and IT Application Support Technician

Confidential, Naperville, IL

Responsibilities:

• Understand application requirements of teh clients and provide L2 Support to application
• ETL Datastage Development and enhancement as per business requirement
• Created ETL IBM-Datastage parallel jobs to extract and reformat teh source data so it can be loaded into teh new data warehouse schema
• Monitor, Resolve, Schedule teh job flows from teh data source to processing and then to Loading into target database
• Performed troubleshooting and performance tuning for DataStage 8.5 ETL jobs. Analyzed error table entries and resolved related issues.
• Provide resolution for teh failing jobs and suggest modification requirements to teh developers based on requirements.
• Plan, design, test and implement changes in teh Datastage job as per new business guidelines and requirements
• Co-coordinating wif upper management in application releases, attending meetings wif teh application directors and business users to halp them understand teh production process which include Incident, Change and Problem management
• Actively monitor Datastage job and director logs for proper processing and functioning of jobs.
• Handled technical troubleshooting wifin an enterprise environment, including system crashes, slowdowns and monitor, troubleshoot and resolve issues wif teh application across multiple environments.
• Create and execute SQL queries to return data from teh database and verify data is loaded properly
• Meeting SLA transmission deadlines and troubleshooting file-error and delinquencies.
• Complete root cause analysis of defects.
• Processed large batches of data on daily, weekly and monthly basis
• Co-ordinate wif different source systems to maintain flow of data.
• Identify gaps in data mismatch and troubleshoot and rectify it wifin stipulated time.
• Coordinate and lead teh Technical Bridges for any P1/P2 issues.
• Automated several monitoring and other activities using shell scripting dat saved more TEMPthan 50 hours monthly of combined effort of teh team
• Involved in Initial loads, Incremental loads and daily loads to ensure dat teh data is loaded in teh tables in a timely and appropriate manner.
• Monitor all teh Production job through Zena scheduling team and resolve any failures
• Create, solve, assign tickets form SNOW ticketing tool.
• Supported weekend systems upgrades: provided technical support and knowledge of system availability times; in need of back outs, would set up Tech Bridge calls to engage technical resources to coordinate action plan.
• Attended daily status meeting to follow-up and resolve outstanding group issues

Informatica and Datastage Administrator and ETL development

Confidential, Springfield, MA

Responsibilities:

• Ensured dat all server hardware, operating systems, software and procedures aligned wif organizational standards and strategic business plan.
• Analyzed slow running processes and perform root cause analysis and corrected performance issues.
• Developing and enhancing Informatica and Datastage jobs
• Maintained Enterprise Informatica and Datastage Administrationhosting more TEMPthan 40 applications
• Installation/upgrade and maintenance of teh Informatica tool.
• Reengineered company’s systems setup, establishing automated server maintenance scripts, optimizing system performance, installing upgrades/patches, creating backups, establishing system monitoring and maintaining security protocols
• Made recommendations and developed technical design for new application features.
• Oversaw teh daily performance of computer systems across all teh lifecycle of DEV, SIT, QA and PROD
• Ensureproper installation and functioning of services, domainsand clients
• Maintained records of daily data communication transactions, problems and remedial actionstaken.
• Developing Unix shell scripts to automate processes
• User management and LDAP configuration of teh user.
• Creating new database creations as per requirements.
• Referred major hardware and software problems and defective products to vendors or technicians for service
• Perform data migration between different environments as requested.
• Followed internal procedures for change management, incidentmanagement and escalation.
• Evaluated and conducted technical and functional research and analysis.
• Escalated unresolved issues to appropriate level.
• Participated in special projects, external audits, evaluations and process improvements.
• Provided after-hours support for applications and project efforts when needed.
• Applied performance tuning techniques.
• Ensuredproper release and maintenance of all systems.

BI Developers

Confidential

Responsibilities:

• Cleansing, Transformation and Validation of teh data received from teh client end.
• Extraction of data and Processing of data using sql and plsql codes, functions and procedures.
• Validate and test teh processed data using Macros before forwarding it to teh next team.
• Help team create conceptual, logical and physical data model using teh tool Erwin
• Involve in business requirement meeting and workshop wif teh business stake holders and use to co-ordinate wif different teams to work on teh business solutions.
• Creating scalable, automated solutions for our customer base writing several automated scripts using Shell scripting.
• Developing codes in Oracle PLSQL to monitor teh quality of code received and converting them to system recognizable format for further processing.
• Enhancing code to ensure compatibility and stability.
• Creating User Acceptance test cases.
• Documentation and demonstrates solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code to teh Clients and business.

BI Developers 

Confidential

Responsibilities:

• Cleansing, Transformation and Validation of teh data received from teh client end.
• Extraction of data and Processing of data using sql and plsql codes, functions and procedures.
• Designing and developing PLSQL codes
• Creating web-based interface in Oracle Apex to create various critical reports for Confidential internal project.
• Documentation and demonstrates solutions by developing documentation, flowcharts, layouts, diagrams, charts, code comments and clear code to teh Clients and business.