SUMMARY:

• Having 10+ years of IT experience in all phases of Application Software Development, Testing, Implementation, Production Support, Maintenance and Upgrades.
• Extensive experience in Extraction, Transformation and Load (ETL) data from various sources using IBM Infosphere DataStage.
• Familiar in using highly scalable parallel processing infrastructure using parallel jobs.
• Used Enterprise Edition/Parallel Extender stages like Datasets, Sort, Remove Duplicate, Join, Lookup, Merge, Change Capture, Funnel, Row Generator and many other stages in accomplishing the ETL Coding
• Worked on extraction of data from various database sources Oracle 10g/9i/8i, DB2, SQL Server, Teradata, Sequential files, etc.
• Experience in creating Reusable jobs which performs data extracts and loads.
• Experience in Oracle,SQL, Teradata databases using SQL (Stored Procedures, Functions, Packages and Triggers), PL/SQL and Teradata Utilities (Fast Load, Multi Load etc).
• Strong Knowledge and Hands on Experience in Object oriented programming using Java / .Net technologies (VB .Net, C# .Net and ASP.Net).
• Experience in using UNIX and Shell commands to create jobs, automate processes and monitoring processes.­­­
• Experience in writing Excel Macros with VBA.
• Experience in Code Migration/Conversion from one environment to other Environments like Pro*c to Datastage.
• Experience in Job scheduling tools to create, modify, troubleshoot jobs, schedule and automate daily/weekly/monthly/quarterly jobs.
• Experience in Charles River (Investment Management and Asset Management) Applications, Eagle and PAM applications. Also involved in their application upgrades.
• Active team player with commitment to work to meet deadline, strong communication, good analytical, time management, decision making and problem - solving skills.
• Experience in Agile (Using JIRA and RTC) and waterfall Development Methodology.
• Participating in technical code reviews and providing suggestions in terms of code reusability and Performance improvements.
• Proficient in preparing high/low level design documents and functional specifications.
• Ambitious, self-motivated, ability to work independently as well as in teams, possess multi-tasking skills, results oriented engineering professional.
• Good domain Knowledge in Brokerage Investments, Portfolio Management, IIA and Manufacturing Domains
• Proven ability to quick learn and adapt to new Technologies

TECHNICAL SKILLS:

DBMS/RDBMS: Oracle 11g/10g/9i, SQL Server 2000/2005, Teradata

Tools: ETL (IBM Infosphere Data stage), Visual studio, RTC, Visio, Putty, SQL Developer, JEdit, XMing, Beyond Compare, smart bear, WinFTP, Snagit, BOX, Crystal Reports, Control-M.

Operating Systems: UNIX, Windows 10, Windows 7, XP

Version/Source Control Systems: RTC, Borland StarTeam

Application Software’s: MS Office, Visual Studio 2010/2012/2015

Languages: SQL, PL/SQL, UNIX Shell Scripting, Perl, Pro*c, VBA, C# .Net, VB .Net, Core Java, Java Scripting

WORK EXPERIENCE:

Confidential, Austin, TX

Technical Lead - Onsite

Responsibilities:

• Working with Business Analysts and collecting the Business requirements.
• Analyze and Design the appropriate solutions.
• Extracting data from various source systems using reusable datastage extract jobs and Teradata utilities.
• Designing the load jobs to feed data into Staging and Base tables.
• Identifying and Fixing the job failures
• Technical lead for offshore team.
• Creating the integration test plan and Implementation plan
• Documenting the best practices in internal WIKI and creating the knowledge documents.
• Production support activities
• Supporting Application software upgrades.

Summary of Technologies Used: Datastage 11.7, SQL, Teradata, UNIX Shell scripting, Perl Scripting and Agile (using JIRA).

Confidential, San Antonio, TX

Technical Lead - Onsite

Responsibilities:

• Working with Business team and collecting the requirements.
• Extracting data from various source systems using reusable extract jobs.
• Segregating the Mutual fund data and ETF data
• Designing the load jobs to feed ETF schema
• Deriving the logic for Top 10 Regions, Sectors and Industries
• Technical lead for offshore and near shore teams.
• Creating the integration test plan
• Creating the rollout plan
• Documenting the best practices in internal WIKI and creating the knowledge documents.
• Production support

Summary of Technologies Used: Datastage 11.5, SQL, Teradata, UNIX Shell scripting and Agile (Using RTC).

Confidential, San Antonio, TX

Sr. Datastage Developer - Onsite

Responsibilities:

• Understand the new functionalities came along with the new version of Charles River.
• Designing the required Jobs/Modifying the existing jobs for better performance
• Creating the working environment for testing the jobs without disturbing the current existing system.
• Creating reusable Datastage scripts to refresh Test environment Data
• Agile Team Interactions and Maintaining status documents
• Creating reusable scripts to send production files to Prod QA servers for parallel testing.
• Creating the test plan without impacting the existing system
• Working on UDA’s creation as well as test automation for reports.
• Working on various application teams like Oracle team, Control M team, Security team (for SSH Key Configurations) and Business 2 Business (B2B) Integrations.
• Designing the rollout plan and Deploying the new code changes
• Production Parallel Testing and Support to QA testing
• Creating Rollout plan as well as back out plan
• Monitoring Production jobs through control M and supporting for the failures
• Preparing business documents for the existing and new system. Upload the required documents into internal wiki.
• Coordinating offshore team and solving their questions in terms of Technical and Business.

Summary of Technologies Used: Charles River IMS, SQL, UNIX Shell scripting, Datastage 11.5, Testing and Java Batch jobs.

Confidential, San Antonio, TX

Sr. Datastage Developer - Onsite

Responsibilities:

• Understand the new features/compatibilities of Datastage.
• Designing the required Jobs/Modifying the existing jobs as per the compatibility issues.
• Creating the working environment for testing the jobs without disturbing the current existing system.
• Validating the new environment with existing environment and make sure all jobs and scripts were copied.
• Working with B2B to setup file transfers to new system
• Creating reusable scripts to refresh Test environment Data
• Agile Team Interactions and Maintaining status documents
• Creating reusable scripts which can modify the oracle version in all datastage jobs at once.
• Creating the test plan without impacting the existing system
• Working on various application teams like Oracle team, Control M team, Security team (for SSH Key Configurations) and Business 2 Business (B2B) Integrations.
• Designing the rollout plan and Deploying the new code changes
• Production Parallel Testing and Support to QA testing
• Creating Rollout plan as well as back out plan
• Documenting the Best practices which will be used for next upgrades
• Monitoring Production jobs through control M and supporting for the failures
• Coordinating offshore team and solving their questions in terms of Technical and Business.

Summary of Technologies Used: Datastage 11.5, Datastage 9.1, SQL, UNIX Shell scripting, testing.

Confidential, San Antonio, TX

Sr. Datastage Developer - Onsite

Responsibilities:

• Understand business requirement Specifications and Functional Specifications
• Designing the Jobs/Modifying the existing jobs for better performance
• Ensure all quality related activities are logged and shared
• Deploying the code in client environment
• Support QA testing and Monitoring Production jobs
• Preparing business documents for the existing system and upload in internal wiki.
• Designed and developed Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions in PL/SQL, and Dynamic SQL.
• As per business requirements, designed solutions using macros in VBA.
• Fixing the issues in migrated applications from VB to .Net, as well as implementing the new modules in .Net applications.
• Coordinating offshore team and solving their questions in terms of Technical and Business.

Summary of Technologies Used: Charles River, SQL, UNIX, Datastage 9.1, Java Batch, VB.Net, VBA.

Confidential, San Antonio, TX

Sr. Datastage Developer - Onsite

Responsibilities:

• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Analysis and Development of enhancement requests.
• Created reusable interfaces like extract, load and FTP jobs.
• Extracted data from source systems Oracle 10g, Sequential files and Flat files to Oracle.
• Created test cases and recorded test results for all Requirements.
• Extensively used DataStage Designer for creating new job categories, metadata definitions and data elements, import/export of projects, jobs and DataStage components, viewing and editing the contents of the repository as well as writing routines and transforms.
• Used DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
• Used several stages like Sequential file, Aggregator, Join, Merge and Lookup during the development process of the DataStage jobs.
• Setup the Environments for QA's and coordinate in testing.
• Responsible for version controlling, code movements and components deployment to integration system and production system.
• Gathered system design requirements, design and wrote system specifications.
• Agile team interaction.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements

Summary of Technologies Used: Datastage 8.1, Charles River, Oracle 10g, SQL, PL/SQL, Pro*c, Unix

Confidential

Sr Developer - offshore

Responsibilities:

• As a Data Stage ETL consultant & PL/SQL developer, lead the design and development of Brokerage Replatform - FMO team.
• Working closely with the business users to understand the requirements and converting them into project level technical capabilities.
• Worked with business analysts to identify the appropriate data elements for required capabilities.
• Working with System Analysts to identify the proper sources for required data elements and to determine the accuracy of the data.
• Constructed complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD).
• Designed and developed Oracle objects such as Stored Procedures and Functions in PL/SQL, Packages in PL/SQL, Materialized Views, and Dynamic SQL.
• Designed and developed Batch Control process to run the Data Stage sequences in batches for restart ability and recoverability.
• Identifying the common functionality between the processes and created reusable code using PL/SQL procedures and Unix scripts.
• Automated data fetch using FTP and UNIX shell script.
• Extracted the data from various sources like Flat files and Database using Data Stage Parallel Extender and loaded into the ORACLE database.
• Created the Data Stage parallel jobs and sequences for extracting and loading the data using various stages like Flat File, Data Set, RDBMS, Transformer, lookup, sorter, remove duplicate, Change Capture, joiner.etc.
• Created UNIX shell scripts to execute the external programs through Data Stage.
• Performed the performance and tuning at source, Target and Data Stage job levels using Indexes, Hints and Partitioning in ORACLE and Data Stage.
• Analyzing the dependencies between the jobs and scheduling them accordingly using the Control-M Scheduler.
• Facilitated the Production move ups of ETL components from Acceptance to Production environment.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements.

Summary of Technologies Used: SQL, UNIX, PRO*C, IBM Data Stage Info Share

Confidential

Developer - offshore

Responsibilities:

• Involved in Complete Software Development Lifecycle Experience (SDLC) from Business Analysis to Development, Testing, Deployment and Documentation.
• Analyzed the requirements and developed the logic.
• Worked on web service implementation.
• Created test cases and recorded test results for all Requirements.
• Setup the Environments for QA's and coordinate in testing.
• Responsible for version control, Movement code and components from deployment area to integration system and production system.
• Gathered system design requirements, design and wrote system specifications.
• Coordinated with the business analysts and developers to discuss issues in interpreting the requirements

Summary of Technologies Used: VB. Net, SQL, PL/SQL, Web Services, Microsoft Visual Studio 2010.

Confidential

Developer - offshore

Responsibilities:

• Execute the Conversion wizard, fix the compilation and runtime issues.
• Functionality and appearance should be same in both versions of applications.
• Developed reusable procedures in .Net to handle various functionalities.
• Created and documented various migration steps which will be used for all applications migration.
• Successful migration of Applications with zero defects.
• Developed a reusable tool for removing the commented code.
• Creating Performance improvement procedures.
• Creating MSI and deploying the applications to Users.

Summary of Technologies Used: VB6.0, VB.Net, Microsoft Visual Studio 2008.