SUMMARY

• A proficient software professional, with a career expertise of 10 Years in providing Consulting, Analytics & data warehousing/BI solutions to reputed organizations in field of e - commerce, Finance & Banking, Gold Mining, Networking.
• Currently working as a Technical Lead with Confidential, (Past: Confidential, Confidential, UK)
• I specialize in creating solutions for people with IT problems.
• I work with end users, developers, business analysts & senior management to solve varied technology issues.
• In addition, I manage a diverse portfolio of technology projects for my business & development partners.

TECHNICAL SKILLS

Operating Systems: Unix,Solaris,Linux

RDBMS Packages: Sybase,Oracle 9i, 10G,11G,Teradata

Programming Languages: SQL, Unix shell scripting,J2EE,Java Application Server,Apache,Tomcat,JBoss

Tools: Autosys,Service Now(Snow), Informatica 9.6, Cronjob, Toad,Teradata SQL Assistant.

PROFESSIONAL EXPERIENCE

GPS IB Advisory Support Lead

Responsibilities:

• Expertise in ITIL V3, Managed Services, Incident, Problem Management, Frequent Failure Analysis and Continuous Service Improvements.
• Good knowledge of Investment banking, Equities, Securities, Trade life cycle, Front Office, Middle Office and Back Office trading.
• Handled multiple Severity 2 Incidents with huge impact to Users and managed to get them resolved with a large co-ordination level within a short duration.
• Singly handling Severity 2/3 type incidents and communications for the same.
• During my tenure in this roll I’ve successfully delivered:
• Data center migrations for our shared application infrastructure
• End user desktop rollout from Windows XP to Windows 7 (application remediation & testing, tool & process simplification, upgraded remote access platform (Citrix XenApp 6))
• Physical to virtual server migrations
• Reorganized offshore/virtual workers (75+ staff) desktop environment to improve day-to-day performance & increase productivity
• Reduced infrastructure costs via database consolidation, server decommissioning
• On boarded 5+ new applications into the global support organization
• Decommissioned 6+ legacy applications from the application portfolio
• Business Continuity Management (BCM) activities - including documentation improvement & standardization, BCP execution & testing
• Management of planned and unplanned application & infrastructure outages
• Analyzed incidents for problem management to prioritize bug fixes, shift left/out opportunities
• Subject matter expert guidance for the Global Research shared drive audit, monitored segregation of duties within the development department (UNIX, Wintel & LDAP)

Confidential

Team Member

Responsibilities:

• Currently leading a 7 member team who are responsible for L1/L2 Support.
• Leading team in any technical (SAS)/business side queries.
• Liaising with Business Team, understanding their requirement and getting work done from offshore with Minimal onsite assistance
• Learning new technologies and facilitating classroom training for other projects.
• Preparing daily stats/reports for higher management, to showcase how entire architecture is performing.
• Interacting with DBA team to fine tune long running jobs thus saving critical SLA time.
• Fully responsible for delivery of key feeds within the agreed SLA and 100% system availability.
• Work closely with project teams on technical design issues.
• Participate in Quarterly releases through release document review, deployment, setting up and configuring environments
• Working on cost based proposals to manage budget for application maintenance.

Confidential

Team Member

Responsibilities:

• Lead a team of 4 members (Data warehouse Production Support) who are primarily monitoring DWH jobs and helping them to sort daily issues.
• Expertise in analysis (by generating Graphs) and presenting key statistics to management which helps in taking business improvement decisions
• Checking for Data Quality and using DWH best backfill strategy to implement (Backfill) it across Oracle Clusters.
• Answering DW Users Queries about Best Backfill practices in DWH system
• Educating DW Users about SQL Query optimization and Tuning(For Example via adding hints to their query and analyse by running explain Plain)
• Creating SANDBOXES for DW Users and maintaining them till they are educated.
• Development of new datasets and integrating it with existing BI platform
• Modified existing subject areas to cater to customers’ reporting needs.
• Fine-tuned several long running complex ETL jobs and reports thus saving more than 100 hours/month of processing time.
• Resolving Costumer queries and Trouble Tickets
• Ensuring timely availability of reports.
• Development and up gradation of inbuilt tools using Unix shell scripts/Perl scripts.
• Troubleshooting errored jobs.
• Creating SOPs for how to solve any issue.
• Giving Knowledge Transfer (KT) to new joiners.

Confidential

Team Member

Responsibilities:

• L1-Involved in monitoring/(un)scheduling of real time feeds/workflows
• L2-Involved in resolving issues encountered in the running of the feeds.
• Providing Root Cause Analysis for the issues and delivering feeds within SLA (Service Level Agreement).
• Involves analysis of complex ETL mappings and UNIX scripts.
• L3-Involved in permanent fix/resolution for the recurring issues by making necessary changes in the mappings as per FDD after testing in UAT environment.
• This involves raise of Change Management Requests and taking Business Approvals.
• Handled multiple Severity 2 Incidents with huge impact to Users and managed to get them resolved with a large co-ordination level within a short duration.
• Singly handling Severity 2/3 type incidents and communications for the same.
• Supported critical trading application with different Databases
• Active interaction with both upstream and downstream users and Business clients.
• Enhancements in previously developed Shell Scripts.
• Monitoring System Status on different servers.
• Monitoring the jobs and resolving the errors.
• Ensure Onsite/Offshore communication.
• Maintaining Issue logs, Sending hourly reports.
• Monitoring and resolving the different applications issue.
• Co-ordination with the different teams for applications support.