SUMMARY:

• Over 7 years of experience in Banking and Capital Markets domain in the field of Software Development.
• Has knowledge of data warehouse concepts, data modeling and schema design techniques such as Star, Snow Flake and multi - dimensional analysis using OLAP.
• All my projects required a significant amount of problem solving skills, multitasking ability.
• Worked with business users for requirements gathering and business analysis to develop, documents and to evolve data models based on user input and feedback.
• Experience in SQL and PL/SQL programming, oracle architecture and database design.
• Strong experience in developing, troubleshooting, Implementing and performance tuning of Oracle Procedures, Functions, Triggers, Packages, Cursors and complex queries
• The projects that I have worked on uses various other technologies & tools such as ETL Informatica, Shell Scripting, Unix, Autosys, Netezza and Vertica in which I have working knowledge as well as proficient level of expertise.
• Has knowledge of Qlikview.
• Familiar with tools like Confidential TFS (Team Foundation Server), Confidential Quality Centre, Perforce (version control).
• Has complete knowledge of SDLC and worked in Onsite-Offshore model. Strong analytical, written, oral and presentation skills.

TECHNICAL SKILLS:

Data warehouse: Oracle PL/SQL, Vertica 3.3, Netezza

RDBMS: Oracle 10g, 11g

Scripting Languages: UNIX Shell Scripting

Scheduling Tool: Autosys

BI Tools: ETL Informatica 9.1, QlikView

Other tools/Softwares: Confidential TFS, Confidential Quality Centre (QC), Perforce (Version Control)

PROFESSIONAL EXPERIENCE

Confidential, NJ

Oracle PL/SQL Developer

Responsibilities:

• Understanding the requirements, effort estimation and breaking work into modules, assigning work to individual team members.
• Participated in impact analysis, designed data structure, created tables, indexes, partitions.
• Created ERD diagrams of the data structures and flow.
• Developed packages that perform calculations/business logic and store data in end tables that transform data to downstreams.
• Worked with ETL team to embed the oracle part.
• Created iXp ausosys scheduling jobs and shell scripts to call PL/SQL scripts.
• Developed SQL queries for various testing scenarios.
• Created and maintained Excel sheets for all test cases.
• Involved in unit testing, Integration testing, regression and load testing phases.
• Maintained versions in version control tool Perforce.
• Reviewed and maintained code adhered to the standards with necessary comments.
• Project is well documented and knowledge transferred to dependent and support teams.

Environment: Oracle PL/SQL, ETL Informatica, iXp Autosys, .Net (UI).

Oracle PL/SQL Developer

Responsibilities:

• Worked with business users for requirements gathering and business analysis to develop, document and to evolve data models based upon user input and feedback.
• Designed, developed and maintained oracle database schemas, tables, standard views, materialized views, unique indexes, constraints, triggers, sequences, implicit cursors, explicit cursors, cursor for loops, reference cursors, and other database objects.
• Designed and developed Oracle PL/SQL batch and real time processes for loading data from internal and external systems using SQL Loader and External tables.
• Involved in table redesigning with implementation of Partitions, Table creations and Indexes to make the database faster and easier to maintain.
• Understanding ETL Informatica workflows, worklets, look ups, mappings to check data transformation.
• Created complex SQL queries for various report requirements on a day to day basis.
• Used Confidential Vertica to store the data and generate the reports for the users and Chief Operating Officer’s.

Environment: Oracle PL/SQL, ETL Informatica, iXp Autosys, Unix Shell Scripting, Vertica (Reporting Layer), .Net (UI), Netezza.

Comprehensive Source for Analytics & Reporting

Responsibilities:

• This is a host of many applications for sales, research and trading domains.
• Below are the different projects I have worked within this master project.
• I have worked parellely in one or more projects in CSAR.

Oracle PL/SQL Developer

Responsibilities:

• My key responsibilities are access control management for downstreams, data model, analysis, design, implementation and overall end to end delivery which involves coding in Oracle PL/SQL and Autosys job scheduling.
• Actively participated in all the phases of SDLC with timely delivery against deadlines.
• Had an opportunity to lead a team of 8 during high volume of periodic enhancements which were needed to addressed and delivered in a very short period of SDLC.
• Developed stored procedures, functions, Views and Triggers, Complex queries using Oracle PL/SQL.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Designed, implemented and tuned interfaces and batch jobs using PL/SQL.
• Developed Hierarchical queries for producing sales managers and research analysts to determine the revenues by team.
• Worked on SQL Loader to load data from flat files obtained from various facilities every day to populate the data into staging area and further populated onto Data warehouse.
• Worked on ETL Informatica Power Center 9.5.1 Repository Tool Manager for creating workflows and also in tuning of mappings for better performance.

Environment: Oracle PL/SQL, iXp Autosys, Unix Shell Scripting, Java (UI).

Oracle PL/SQL Developer

Responsibilities:

• Worked parallel with above project (Sales Hierarchy) as part of dev team and lead a team of 5.
• This was a new project and involved right from the requirements, effort estimation phase.
• Designed ERD flow diagrams, low level and high level test plans.
• Used array type data model since the reporting screen has multiple dimensions. Data was partitioned by year due to volume and for finer search of trades.
• Created PL/SQL packages, tables, indexes. Created various anonymous PL/SQL blocks for testing.
• Tuned queries and made changes in the process to complete the nightly batch by 1 hour earlier. This gave us more time for debugging in case of issues.
• Used ref cursor to check output for various testing scenarios.
• Maintained code with standards and version control tools. Well documented and provided knowledge transfer to teams.

Environment: Oracle PL/SQL, ETL Informatica, iXp Autosys, Unix Shell Scripting, Java (UI).

Technology Analyst

Responsibilities:

• Short Term Fixed Income (STFI Reports) migration from Java to Qlikview
• This was a java based UI for short term fixed income reports. There are different drop downs and filters provided to generate reports for any date/issuer/investor.
• QlikView is a BI tool with combination of UI design and backend coding. This was a challenging project since Qlik was very new to the complete team. We had to start from the scratch and deliver in 8 months.
• Attended sessions for Qlikview with knowledge pool teams at the beginning of the project.
• Created QVDs and QVWs, worked closely with onsite and offshore team in planning and designing model for the reports.
• Coordinated teams during migration and kept the related parties updated.
• Simultaneously analyzed and worked on improving data quality which is a value add.
• Created technical and functional documents.

Environment: Qlikview.

Software Developer

Responsibilities:

• Worked as a team member and technology used was Oracle PL/SQL and created autosys job schedules.
• Created sequential batches and concurrent batches for sessions.
• Created PL/SQL packages, stand alone procedures, and stand alone functions.
• Loaded data into tables using flat files and excel sheets.
• Created test cases, communicated with onsite counterpart, provided inputs.
• Participated in load testing, assisted QA, UAT teams to fix the issues in the testing phase.

Environment: Oracle PL/SQL, iXp Autosys, Java (UI).

Confidential

Software developer

Responsibilities:

• Worked on a POC for about 6 months using Application Systems 400. It was later presented to the client. I did not get a chance to work on this as I moved to a different project by then.
• Worked under a manager in Infosys Talent pool. Learnt about data analysis, Initial data modeling, understanding SDLC and normalization.

Environment: AS400.