SUMMARY:

• More than 13 years of IT experience in developing Business Intelligence solutions include Design and Implement Enterprise Data warehouses using IBM WebSphere Datastage
• Strong ETL/Reporting work experience using BI tools namely Datastage, Informatica, Cognos and Tableau
• Highly experienced with strong record of excellent teamwork and specializes in problem identification and proposal of alternative solutions
• Experience in interacting with Business users in analyzing the Business process requirements and transforming them into documenting, designing, and rolling out the deliverables in agile project methodology
• Excellent knowledge of studying the data dependencies using Metadata of Datastage and preparing job sequences for the existing jobs to facilitate scheduling of multiple jobs
• Expertise in Software Development Life Cycle projects - System study, Analysis, Physical and Logical design, Coding, testing and implementing business applications.
• Experienced in integration of various data sources (DB2, Oracle, Teradata,flat files, COBOL files and XML files) into data staging area. Used several stages in Datastage to accomplish the business requirement
• Experience in using highly scalable parallel processing infrastructure using parallel jobs and multiple node configuration files.
• Experienced in UNIX shell scripts for the automation of processes and scheduling the Data Stage jobs using wrappers
• Experience in troubleshooting of jobs and addressing production issues like data issues, ENV issues, performance tuning and enhancements.
• Has involved in Analysis, Design, Development and Implementation phases of the data warehouse projects and client server applications in the business domain of Investment Banking, Financial services and Sales, Retail and Manufacturing
• Excellent communication skills, problem solving skills, Leadership qualities and an attitude to learn the new cutting edge technologies.
• Able to work independently and collaborate proactively & cross functionally within a team

TECHNICAL SKILLS:

ETL Tool: Datastage 11.5, 9.1/8.5/8.1/7.5, Informatica 8.x

Reporting Tools: Cognos, Tableau 9.1

Scheduling Tool: Autosys, Control-M, Load Leveler

Database: Hive Big data, Oracle 8i/9i/10g, Teradata 12.0, DB2, Sql Server

Dimensional Modeling: Data Modeling, Star Schema Modeling

Operating System: UNIX, LINUX, Windows XP/NT/2000/98

Languages: UNIX shell script, VB script, PL/SQL, Visual Basic 6.0

Monitoring tool: App Dynamics, Autowatch plus

PROFESSIONAL EXPERIENCE:

Technical Lead

Confidential, Tampa

Responsibilities:

• Interpret written business requirements, functional requirements to design and develop technical solutions that meet business needs.
• Develop the logical and physical ETL design documents from the source to target mapping document.
• Develop ETL jobs using IBM Infosphere Datastage 11.5 to load historical and delta data from Oracle and Teradata databases, Flat files and XML files to Target warehouse
• Work with different upstream & downstream system teams to extract & send the data.
• Participate in system design reviews and code review sessions.
• Responsible for deploying App Dynamics monitoring tools to onboard on all Core Compliance server and analysis on Alerts on server, application and business transactions
• Reviewing the Scripts/User Reports for high quality output to maintain high level of customer satisfaction and also will be responsible to do RCA (Root Cause Analysis), will understand the problem synopsis that user reports and do fix.
• Work with L2 for Prod release activity, COB and support prod Parallel run
• Coordinate with offshore team with business process and domain specific knowledge to ensure a quality deliverable

Environment: Datastage 11.5, UNIX Shell Scripting, PL/SQL, Autosys, Oracle, Sql Server

Confidential

Responsibilities:

• Build data model for various system to have report generated with low level granularity
• Involved in design and build RDS metric hub using Datastage by integrating different system to get Transaction logs, Services log, IIS Audit log and Autosys instance log to load RDSG data warehouse(Dimension and fact tables) for reporting
• Create and review Application Design document. Understanding the requirements and then provide an efficient design for the application. Also review the design created by peers.
• Create and review Application technical specification. Understanding the high level design and create and efficient low level design using the technical knowledge of Datastage tool. Review the technical specifications prepared by peers.
• Create and review Application Mapping Document. To do a source system analysis and hence prepare a source to target mapping document applying the business rules and logics.
• Database query tuning and performance tuning. To tune the queries used in Datastage jobs so as to improve the performance of the application.
• Coordinate with offshore team to deliver the Datastage Project on time.

Environment: Datastage 9.1, UNIX Shell Scripting, PL/SQL, Autosys, Tableau 9.1

Confidential

Responsibilities:

• Involved in Code review and provide architecture solution to development team for effective use of platform with maximum utilization and less cost on server and CPU
• Involved in GPFS file system migration and Datastage migration from 8.5 to 9.1
• Involved in building Data quality management governance(DQMG) frame work for all inbound and outbound files involved in CSDP server

Environment: Datastage 9.1, Datastage 8.5, UNIX Shell Scripting, Autosys

Confidential

Responsibilities:

• Participated in all phases of CDPH- Customer Data Provisioning Hub Project life cycle including Requirement Analysis, Client Interaction, Design, Coding, Testing, Production Deployment and Documentation
• Solidifying the environment to improve data quality and traceability
• Design jobs to replicate the existing system using Datastage, Simplification of the environment to reduce complexity.
• Extensively worked on building Datastage jobs using various stages like DB2 Connector, Funnel, Transformer stage, Sequential file stage, Lookup, Join, Sort, Aggregator, Dataset and Remove Duplicates stages
• Created error handling and reject file process to capture rejects for data analysis and data re-process
• Developed job sequences to execute a set of jobs with restart ability, check points and implemented proper failure notification
• Reduction in the number of Batch jobs executed and Effective utilization of System Resources using parallelism & Grid technology
• Involved in unit testing, system integration testing, implementation, maintenance and performance tuning
• Establish, Design and build a solution that can be replicated to different Customer System SOR’s
• Develop Autosys Jobs for Datastage jobs scheduling and other processes scheduling

Environment: Datastage 9.1, 8.5, Fastrack, Information Analyzer, UNIX, Windows 2000 Server, DB2, Autosys

Confidential

Responsibilities:

• To thoroughly understand the client model and all the applications for which we need to provide Production Support.
• Provide uninterrupted high quality production support and at the same time to look for scopes of supportability improvement.
• Strictly follow the guidelines under Workplace security and deliver the work accurately and on time.
• Ensure Compliance with BOA norms regarding IT Security and data privacy.
• Support the business as usual (BAU) activities in production environment of our clients ensuring and maintaining the high availability of production systems
• Analysis on production issue impact, find the root cause and fix the issue
• Provided production support and Involved in performance tuning of Datastage Jobs and schedule change to improve performance

Environment: Datastage 8.5, Autosys, DB2, Maximo, UNIX

Senior software engineer

Confidential

Responsibilities:

• Developed Data Stage applications(Jobs) based on the Design and Mapping Documents and also tuned them for better performance
• Developed Unix Menu for Production team to automate all File Handling, database and Datastage operations.
• Provide uninterrupted high quality production support and at the same time to look for scopes of supportability improvement
• Monitoring the Jobs, raising Prodexes, resolving the tickets, update job failure in abend tracker, follow up with upstream for file delay, sending Status report on time, support hardware upgrade activities, software upgrade activity, Coordinating with onsite coordinator and effective mail communication and shift handover
• Support the application by troubleshooting the issues and Update clients/users about the run status
• Write Autosys Jils to schedule the Monthly, Weekly & Daily runs
• Provided production support and Involved in performance tuning of Datastage Jobs and schedule change to improve performance
• Created RFC for new implementation in production and done verification after the implementation
• Share Application knowledge with team members and interact with project manager for getting more business knowledge

Environment: Datastage 7.5, Autosys, Oracle 9i

Confidential

Responsibilities:

• Requirements gathering from the client
• Preparing technical design document
• Used Datastage as an ETL tool to extract data from UNIX log file to load into EDW System.
• Designed and developed jobs using Data Stage Designer to extract data from Unix log file, applied various Business rules and logic at transformation stage and loading data into data warehouse
• Fine-tuned Datastage jobs for optimal performance.
• Worked in scheduling Control - M jobs for setting up production job cycles for daily, weekly monthly loads with proper dependencies.
• Documented the Purpose of jobs so as to facilitate the personnel to understand the process and in corporate the changes as and when necessary.
• Coordination for RFC (Request for Change).
• Coordination with team for Identify the projects and request for New RFC
• Attend the CAB(Change Advisory Board) meeting for RFC approval
• Responsible for QA review and getting CMO(Change Management Office) approval

Confidential

Responsibilities:

• Monitoring the jobs Scheduled to run using Control M. Identifying the root cause and provide quick solution on production Job Failures
• Checking the Service Calls which were raised against our team, Resolving them with in the SLA's
• Provided production support and Involved in performance tuning of Datastage Jobs and schedule change to improve performance
• Closing the tickets based on the priority using HP Open view (support tool)
• Documenting all the tickets as part of quality process.
• Preparing Status reports to analyze the areas which needs performance tuning
• Preparing possible solutions for improving the job performance

Environment: Datastage, Control - M, Oracle 8i

Programmer

Confidential

Responsibilities:

• Requirements gathering from the client
• Build technical and functional knowledge
• Code and test components
• Ensure quality standards of deliverables, Maintaining proper documentation of work requests

Environment: Visual Basic 6.0, Sql Server 2000