SUMMARY

• 13+ years of consolidated professional experience working with technologies like Oracle PL/SQL, AWS, Big Data, Hadoop, Data Modeling using Toad data Modeler, Oracle Performance Tuning, Cognos, Informatica, Autosys, Unix, SAS, Pro*C.
• Created dashboards in Tableau.
• Hands - on experience on SQL-Server 2012, MySQL.
• Worked as Application Support Specialist for 3+ Years.
• Oracle Database 11 g: SQL Fundamentals I Certified.
• Worked in upgrading Oracle database from 10g to 11g.
• Worked in migrating database server from SUN SOLARIS to AIX.
• Extensive experience working in Unix Environment and Unix Shell Scripting.
• Extensive experience in Batch Scripting.
• Good understanding with hands-on experience in Informatica PowerCentre 7.x/8.x/9.x.
• Web Page designing using ASP .NET, PHP and HTML.
• Experience in working on Life-Science Domain and Finance Domain.
• Experience in application development from defining user requirements to Analysis, Design, Development, Testing, Implementation and Maintenance.
• Have clear understanding of Business Intelligence and Data Warehousing Concepts with emphasis on ETL and Life Cycle Development
• Excellent Communication and interpersonal skills. Demonstrated ability to quickly grasp new concepts, both technical and business related.
• Experience in developing the Data handling and Data warehouse designing.
• Knowledge of the Test Process using Quality Centre. Executed different Installation Verification (IV) Test case as well as Functional Verification (FV) Test Cases.
• Actively involved in co-ordination with the Testing Team to develop the test scenarios for the business requirement.
• Actively involved in developing, executing and managing User Acceptance Testing (UAT).
• Strong experience in documenting existing process, analyzing business requirements, working with requirements traceability matrix, re-engineering business processes and designing.
• Efficient in MS Project for planning and status reporting.
• Ability to handle multiple tasks and work independently as well as in a team.
• Ability to meet deadlines and handle pressure coordinating multiple tasks in project.

TECHNICAL SKILLS

Process/Modeling Tool: MS Visio, Toad, SQL Navigator

Databases: MS Access, SQL server 2000, Oracle 9i/10g/11g/12c

ETL Tool: Informatica 7 .x/8.x/9.x, Abinitio

Languages: SQL-PLSQL, Shell Scripting, Windows Batch Scripting, C, C++, Visual Basic, Java, .Net, XML and HTML

BI Reporting Tool: Cognos, Tableau

Operating Systems: WINDOWS 2000/NT 4.0/XP/Vista/7, UNIX

Office Tools: MS Office 2007/2003/2000 , Word, Excel, PowerPoint.

Project Management: MS Project 2007/2003/2000 .

Version Control: VSS, Git, TFS

PROFESSIONAL EXPERIENCE

Confidential, Fort Worth, TX

Responsibilities:

• Provide requirements to the team and provide design requirements.
• Provide business logic and give technical inputs to complete the requirement.
• Review the code developed by the team and give sign off.
• Deploy the code in required environment.
• Work closely in an SSP Migration that was one of the challenging projects for GM Financials.
• Develop Automation to complete the validation of the files generated by the processes that was being reported to SEC.
• Develop multiple Batch Scripts to automate processes in order to meet SEC and Audit guidelines.
• Develop Batch Scripting to integrate with Oracle Objects.
• Develop multiple PLSQL scripts and automated various areas in the project.
• Review the data and the files sent to SEC on monthly basis.
• Complete coding for RegAB2 project that generates XML files to be sent to SEC.

Environment: Unix, Cognos, Informatica, Batch Scripting, Oracle 12c, Toad, SQL Developer, TFS, Git, Toad

Data Modeler Application Developer

Confidential, Plano, TX, USA

Responsibilities:

• Develop Shell Scripts.
• Develop Batch Scripting to integrate with Oracle Objects.
• Schedule jobs using Autosys.
• Star Schema Data Warehouse design.
• Develop Oracle Objects such as Package, Functions, Stored Procedures as per the business requirement.
• Analyze and re-engineered developed Oracle Objects for performance improvement.
• Debug issues with Cognos reports.
• Develop SQL queries to extract the data from the warehouse and supply it to the downstream applications.
• Provide Support to the users and resolve their queries on daily basis.
• Co-ordinate with the other developer/programmer and the QA Team to resolve system related issues.
• Capture logical flow of system/business specific to report navigation by creating use case diagrams and flow charts using Microsoft Visio.
• Work closely with the business cross functional teams throughout the Software Development Lifecycle Phases in order to ensure the product meets end user expectation.
• Conduct unit testing and system testing related to Shell Script and PL-SQL code in order to ensure the product meets all the requirements specified for the end user.
• Involve in Installation Verification Testing and Functional Verification Testing of the developed code and helped the testing team and quality team to develop the test scenarios.

Environment: Unix, Cognos, Batch Scripting, Oracle 11g, HP Quality Centre 9.2/10.0, Toad, SQL Developer, TFS, Toad Data Modeler

Oracle PL-SQL Developer

Confidential, PA, USA

Responsibilities:

• Develop Shell Scripts to call the Oracle Packages and handled error using Shell Script.
• Design of DataMarts using Toad Data Modeler.
• Develop Batch Scripts to call Informatica job and do perform file processing.
• Develop Oracle Objects such as Package, Functions, Stored Procedures as per the business requirement.
• Analyze and re-engineered developed Oracle Objects for performance improvement.
• Develop Control files to load data in database from Unix.
• Extracted data from oracle database and spreadsheets and loaded in Oracle Database after applying business logic.
• Used Informatica Power Center 9.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Created procedures to truncate data in the target before the session run.
• Extensively used Informatica debugger to figure out the problems in mapping. Also involved in troubleshooting existing ETL bugs.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Develop SQL queries to extract the data from the warehouse and supply it to the downstream applications.
• Create Informatica Jobs to load data in ACCTAGG and provide it to required targets.
• Provide Support to the users and resolve their queries on daily basis.
• Co-ordinate with the other developer/programmer and the QA Team to resolve system related issues.
• Work with QA Team to develop test strategies and test scenarios. Also help clarify specific requirements to System Tester/s to help develop test cases.
• Capture logical flow of system/business specific to report navigation by creating use case diagrams and flow charts using Microsoft Visio.
• Work closely with the business cross functional teams throughout the Software Development Lifecycle Phases in order to ensure the product meets end user expectation.
• Conduct unit testing and system testing related to Shell Script and PL-SQL code in order to ensure the product meets all the requirements specified for the end user.
• Involve in Installation Verification Testing and Functional Verification Testing of the developed code and helped the testing team and quality team to develop the test scenarios.

Environment: Unix, Informatica 9.6, Batch Scripting, Oracle 11g, HP Quality Centre 9.2/10.0, Toad, SQL Developer, VSS, TFS, Toad Data Modeler.

Confidential, NJ, USA

Responsibilities:

• Used Informatica Power Center 9.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Developed Shell Scripts to call the Stored procedure and handled error using Shell Script.
• Developed Oracle Objects such as Package, Functions, Stored Procedures as per the business requirement.
• Analyzed and re-engineered developed Oracle Objects for performance improvement.
• Developed SQL queries to extract the data from the warehouse and supply it to the downstream applications.
• Create Materialized View for the downstream application to fetch the data from the database.
• Provide Support to the users and resolve their queries on daily basis.
• Co-ordinate with the other developer/programmer and the QA Team to resolve system related issues.
• Work with QA Team to develop test strategies and test scenarios. Also help clarify specific requirements to System Tester/s to help develop test cases.
• Capture logical flow of system/business specific to report navigation by creating use case diagrams and flow charts using Microsoft Visio.
• Work closely with the business cross functional teams throughout the Software Development Lifecycle Phases in order to ensure the product meets end user expectation.
• Conducted unit testing and system testing related to Shell Script and PL-SQL code in order to ensure the product meets all the requirements specified for the end user.
• Involved in Installation Verification Testing and Functional Verification Testing of the developed code and helped the testing team and quality team to develop the test scenarios.

Environment: Unix, Abinitio, Informatica, Oracle 10g, HP Quality Centre 9.2/10.0, Toad, SQL Developer, MS Project, Sub-Version and Dimensions, Oracle Application 11i, JAVA

Application Support Specialist

Confidential, NJ, USA

Responsibilities:

• Develop new processes using PRO*C, PL-SQL and Unix Shell Script as per business needs.
• Enhance the existing processes, PRO*C, PL-SQL and Unix Shell Script, with the change in the business requirement.
• Monitor and Support scheduled processes and provide the fix on daily basis.
• Upgrading Oracle database from 10g to 11g.
• Migrating database server from SUN SOLARIS to AIX.
• Analyze and resolve the failure in the processes and provide the optimum solution to the business.
• Provide support to more than five hundred users from around the globe on daily basis.
• Analyze and provide solution to business queries on the pre-defined SLA.
• Developed automated shell scripts to run each hour to provide the status of the jobs running in the system. Support team had to monitor the jobs by logging in the system and find out the status of the job. With this tool developed, the status of the job was automatically emailed to the support and business users.
• Developed Control files for SQL-Loaders to load the files in the database.
• With the help of Shell Scripting, files in the different server was downloaded, processed and then the error file and log file were uploaded in the server.
• Develop PRO*C to do call other stored procedures and generate reports in CSV files.
• Performed performance tuning for the queries with degraded performance.
• Work with QA Team to develop test strategies and test scenarios. Also help clarify specific requirements to System Tester/s to help develop test cases.
• Work closely with the business cross functional teams throughout the Software Development Lifecycle Phases in order to ensure the product meets end user expectation.
• Conduct unit testing and system testing to ensure the product meets all the requirements specified for the end user.
• Review and sign off of system design deliverables.
• Work with Business System Analysts and program managers in order to translate business requirements into functional and technical requirements.
• Responsible for producing High Level Design Documents (HLD), Technical Requirement Documents (TRD) and User Manuals.
• Work with other Business System Analysts for any Gap Analysis.
• Responsible to provide day to day status of projects and communicate the project schedules, open issues, and project risk/mitigation plans to all the impacted teams.
• Write and execute PL-SQL blocks for automation of the daily task.
• Write and execute SQL Statements using SQL-Plus, Toad, SQL Developer to verify and fetch data in Oracle database. Use Toad to load data in the database.
• Wrote functional doc and design doc.
• Troubleshoot any problems found in database while validating against the business rules.

Environment: Unix, Shell Scripting, Toad, SQL Developer, SQL Navigator, Oracle 9i, Oracle 10g, Quality Centre (QC), Sub-Version and Dimensions, MS Project.

Application Support Specialist

Confidential, NJ, USA

Responsibilities:

• Created ER Diagram for the tables in MS-Visio.
• Developed Shell Script to automatically find the shell scripts and the related dependent Shell Script and load in the Oracle Table using Shell Script.
• Developed Shell Script to find the PRO*C file and dependent PRO*C files and load the database table.
• Developed Shell Script to find the Stored Procedure called in the PRO*C and load in the Oracle database.
• Developed Stored Procedure to find the dependent tables and objects in the Stored Procedure and load in the database table.
• Designed Web interface for select the parameter for the User Query and send the data according to the parameter selected.
• Developed automated shell scripts to run as per User Query and email the requested data in a CSV File automatically to the user submitting the query in the Web Interface.
• Work with QA Team to develop test strategies and test scenarios. Also help clarify specific requirements to System Tester/s to help develop test cases.
• Work closely with the business cross functional teams throughout the Software Development Lifecycle Phases in order to ensure the product meets end user expectation.
• Conduct unit testing and system testing to ensure the product meets all the requirements specified for the end user.
• Review and sign off of system design deliverables.
• Responsible for producing High Level Design Documents (HLD), Technical Requirement Documents (TRD) and User Manuals.
• Wrote functional doc and design doc.
• Troubleshoot any problems found in database while validating against the business rules.

Environment: Unix, Shell Scripting, Toad, SQL Developer, SQL Navigator, Oracle 9i, Oracle 10g, Quality Centre (QC), Sub-Version and Dimensions, MS Project,

Cognos Software Developer

Confidential, NJ, USA

Responsibilities:

• Developed SAS Script to Convert the ODM to SDTM data as per the business requirement.
• Developed Shell Script to run the SAS Script and create SAS datasets.
• Created SAS Script to read the XML file for processing the data using SAS Macros.
• Created SAS Script to generate the graph and statistics for the business report.
• Worked closely with the QA team and Testing team to create the test cases/scenarios and setup data for the test.
• Created SQL-Loader to load the test data for rigorous testing in the Oracle Database.
• Test/validate system tables/files in System Test environment, UAT environment and finally in Production environment in order to check the functionality of the tool is meeting the required standard.
• Co-ordinate with process team and senior Business System Analysts for any Gap Analysis.
• Prepare technical document (report detail design) based on approved HLD by business.
• Organize meetings with business users and walk-though developed HLDs for final business approval.

Environment: BASE-SAS, SAS/STAT, SAS/ODS, SAS/ACESS, SAS/GRAPH, SAS/SQL, SAS/STAT, UNIX, Shell-Scripting, Oracle 9i, SQL-Server 2005, MS-Access, XML, SQL-PLSQL, Toad, SQL Developer, SQL Navigator, Sub-Version and MS Project.

Software Developer

Confidential, USA

Responsibilities:

• Developed Automated Shell Script to find the email address and password from the SAS codes and load it in a parameter file.
• Developed Automated Shell Script to parameterize the email address from the SAS codes.
• Modified SAS Script to use the file generated by the Shell Script instead of hard-coded email addresses and passwords.
• Developed SAS Macro to automatically generate system folders with the timestamp.
• Extensively used SAS/SQL to load the Datasets in Oracle Database.
• Involved in analysis and developed High Level Design Document for the SAS macros.
• Closely worked with the QC Team and Testing team to rigorously test the modified SAS code and processes.
• Resolved issues like duplicate records found in parameter file.
• The Automated Script when executed modified around 600 SAS scripts with a single run, eliminating any human errors.