SUMMARY

12 years in analysis, data modeling, design, development for Financial, Pharmaceutical and ERP Extensive experience interacting with system users and gathering business requirements and Logical and Physical Data modeling and ETL implementation for data centric systems.

SKILLS

• PL/SQL ETL Expert in SQL, PL/SQL, Stored Procedures, Packages, Knowledge of ETL using Datastage like Join, Funnel, Remove Duplicates, Merge, CDC, Lookup, SCD type1,2,3 and assist onshore/offshore development team, assign tasks and code review.
• Data Modeling Conceptual/Logical/Physical data modeling, Data Warehousing concepts including Star Schema e Schema, Data marts, conformed dimensions and facts, Surrogate keys, ODS, Warehouse database design and implementation Reverse engineer existing applications for enhancements, Generate dimensional model from relational data model.
• Databases Oracle, SQL Server, MS-Access, Skills in writing complex SQL, Procedures, Functions, Triggers, Cursors in Oracle and SQL Server, Performance tuning techniques including partitioning and indexing strategies.
• Reporting Crystal Reports, Data reports and OLAP.
• UNIX Shell Scripts, get and put files from/to FTP servers, Scripts to execute Datastage command line, stored procedures SQL loader scripts.
• Enterprise Scheduling
• Tool AutoSys to create jobs dependencies and schedules. File watcher token files job orchestration
• Primary Skills Data Architecture and Design, ER Modeling, Dimensional Modeling, ETL, Business Problem Analysis
• Languages/Tools SQL, PL SQL, Transact SQL, ETL, Autosys, ERWIN, Datastage, Visio, Java, J2EE, ASP.NET, C , VB.net and UNIX Shell Scripts
• Data Analysis Business Problem Analysis, Mapping document, Identify Data discrepancies, Create Data Flow Diagrams, Analyze Information flow between systems, Test Plans

EXPERIENCE

Confidential

Sr. Oracle Developer/Designer

• E2Ei is a End to End Integration application. Which will integrate all the application across the enterprise level. And provide a standardize view across the board. The standardized data will be into Global Customer Hierarchy, Legal Entity, Sales View and CRM.
• Responsibilities: Requirement analysis and Functional design.
• Conduct in-depth analysis of enterprise data and information architecture including analysis of business interactions with data, working with key business contacts as needed.
• Ensures consistency in Enterprise Schema across all applications.
• Analyzed the existing application and re-designed the Relational database according to new requirement
• Involved in migrating the application to new database framework.
• Develop, analyze and review PL/SQL stored procedures, packages and triggers, materialized views
• understand the database and propose model changes to integrate existing ETL applications
• High and detail level design activities including indexing, partitioning for optimal performance.
• Query tuning, explain plan, AWR reports.
• Unit Testing and data validation using JUnit test cases of applications.

Environment: Eclipse, Java 7, Oracle 11g, UNIX, TOAD, PL/SQL, Windows XP, SVN, ClearCase, ClearQuest, Fiddler, ER win, Wirshark.

Confidential

Sr. Oracle Developer/ Designer

• Hi Performance application caters the information that need to take strategic decision and make the future strategy to sustain and increase the growth of the organization. Hi Performance is focused on the generation of performance returns and Attribution return based on current backdated and amended transaction and valuation. It provides information in the form of various measurement and fact that make the organization to get quality information to make quick strategy and policy.
• Responsibilities:Conduct requirements gathering with users and design sessions with business analysts, application architect
• Created functional/technical specifications, testing scenarios, prepared test cases.
• Explore data-oriented structures from high-level conceptual models to logical dimensional modeling.
• Assist DBAs in physical implementation.
• Data flow, Data dictionary and Mapping documents.
• Develop, analyze and review PL/SQL stored procedures, packages and triggers, materialized views
• Used various Indexing and partition techniques to improve the query performance.
• Profiling and mapping sources into the target model.
• Query tuning, explain plan, AWR reports.
• Implemented SQL and PL/SQL stored procedures.
• Developed UNIX scripts and PERL Scripts.
• Created views, stored procedure, Packages.
• Generated Data extracts as per client and various business groups needed.
• Prepared test case and test results.
• Reviewed the test cases and code developed by team members.
• Environment: Datastage, Oracle 11g, UNIX, PL/SQL, Shell Script,ER win, PERL, TOAD, Windows XP, ER Win, Autosys, ClearCase, ClearQuest.

Confidential

Sr. Oracle Developer / Analyst

• Confidential is having multiple applications which need to maintain databases and support day to day applications.
• This ERP system has various modules Accounts Payable, Accounts Receivables, Employee Management, Vendor Management and CRM.
• Risk SQL where the ACCION gets data from multiple financial institutes and it will load to ACCION centralized database and need to implement PL/SQL in order to generate reports.
• Responsibilities:Involved in all phases of SDLC as active participant.
• Work with the overall Enterprise Architecture team to define the future state architecture vision for the organization.
• Hands on experience on Relational database design, STAR schema design, and ETL development.
• Based on requirements estimations provided for new development and enhancements.
• Ensures consistency in Enterprise Schema across all applications.
• Strong Finance Accounts background from a business perspective.
• Developed excel reports using sql and PL/SQL stored procedures.
• Performance tuning on existing SQL to improve application performance.
• Created Materialized views for summary tables for better query performance.
• Used various Indexing and partition techniques to improve the query performance.
• Developed UNIX scripts.
• Developed Queries for various report generation and Data extraction.
• Used Explain Plan and AWR reports to tune the complex queries and debug the queries to provide exact solution.
• Participated actively to migrate database from other source system to ERP system.
• Conducted brainstorm meetings and suggested performance improvement techniques and proposed designs.
• Performed code review and mentored junior developers.

Environment: Datastage, Oracle 10g, TOAD, UNIX, PL/SQL, Shell Script, Windows XP, XML, XSLT, HTML, DHTML, Java, J2EE, VISIO, Autosys, ClearCase, ClearQuest, ASP.NET, VB.NET, C , Fiddler, Wireshark.

Confidential

Anti-Money Laundering Software

Sr. Oracle Developer/Analyst

• The system will deliver precise detection of suspicious activity using a combination of comprehensive detection scenarios, profiling analytics and matching techniques. The system will bring together the power of straight forward name matching and watch list monitoring with the robust analytical techniques of multi parameter detection scenarios and behavioral and peer group profiling. The system will prioritize alerts delivered directly to investigators desktops fully populated with all the information need for investigation. Comprehensive case management capabilities make light work of complexity, uncovering common inks across suspicious activity and ensuring fast effective resolution.
• Responsibilities:
• Developed Customized screens by using screen configurator and XML.
• Implemented Workflows with workflow configurator tools.
• Implemented Scenario manager and AML.
• Debug the application s with help of log files and suggested logged applications issues with suggestions.
• Hands on experience for performance tuning on existing SQL / PL SQL to improve application performance.
• Created tables, views, stored procedure, Indexes, Packages PL /SQL .
• Used various Indexing techniques to improve the query performance.
• Tuned the complex queries and debug the queries to provide exact solution.
• Created stored Procedures using EXECUTE IMMEDIATE and REF CURSORS Native Dynamic SQL .
• Used SQL Loader and UTL FILE to read and load data into report schema from different flat files.
• Worked as Oracle Admin to execute DDL, DCL commands.
• Generated various reports.
• Prepared test case and test results.
• Review the code and test cases within team members.

Environment: Norkom 5.8 Version, Oracle 10g, UNIX, PL/SQL, CVS, Shell Script, Windows XP, ER win, XML, HTML, DHTML, XSLT, TOAD, SQL Loader.

Confidential

Sr. Oracle Developer

• This is a Decision Making tool for Research and Development department in Philip Morris, the Leaf department to supply tobacco to the Manufacturing facilities that meets requirements at the best possible cost. Leaf needs to better understand the tobacco markets and gain grower insight that will drive Leaf strategies. Leaf will conduct research by analyzing and utilizing individual grower data, operation data, and geographic data. This type of research insight along with Agricultural trends, socio economic trends, and competitive activity will allow Leaf to drive strategies to optimize offerings, to optimize the supply chain, to establish PMUSA as a preferred purchaser, minimize risk, and to increase the security of tobacco supply both immediate and long term.
• Responsibilities:
• Hands on experience for performance tuning on existing SQL to improve application performance.
• Strong experience to analyze the existing and proposed systems.
• Based on requirements estimations provided for new development and enhancements.
• Proactively came up with innovative methods to improve software quality, test coverage, efficient and regression coverage.
• Exposure on reporting tool Crystal reports.
• Exposed on UNIX scripts and environment.
• Hands on experience to create views, stored procedure, Packages PL /SQL
• Interacted with business analyst and software developers for bug reviews and participated in QA meetings.
• Participated actively to migrate database from other source system to ERP system.
• Conducted brainstorm meetings and suggested performance improvement techniques and proposed designs.
• Prepared test case and test results.
• Review the test cases and code developed by team members.

Environment: Oracle 10g, UNIX, PL/SQL, OEM, Shell Script, Windows XP, ERWIN, TOAD, SQL Loader.

Confidential

Sr. Software Engineer

• The project deals with support maintenance of 4 applications PROMIS, EMMIS, eQCMS DIRMIS with .NET, JAVA as the technology stack. The primary functions of these applications currently supported are procurement and R D. The project involves acknowledgment, analysis and resolutions of the problem tickets within the defined SLA and also to handle the enhancement requests for these applications as requested by the business groups.
• Responsibilities:
• Involved in all phases of SDLC as active participant.
• Involved in project plan and Risk plan.
• Based on requirements estimations provided for new development and enhancements.
• Proactively came up with innovative methods to improve software quality, test coverage, efficient and regression coverage.
• Exposure on reporting tool Crystal reports.
• Developed excel reports using sql and PL/SQL stored procedures.
• Used admin console to monitor queue s .
• Used Eclipse, logging files for troubleshooting and debugging Java applications.
• Exposure in running the java unit test cases of JUnit by configuring the JUnit testing environment to ensure the functional flow if the application throw any run time exceptions or application break.
• Used Weblogic admin console to monitor queue s .
• Experience in building small java module in Eclipse IDE.
• Exposed on Unix scripts and environment.
• Hands on experience to create views, stored procedure, Packages.
• Interacted with business analyst and software developers for bug reviews and participated in QA meetings.

Environment: Oracle 9i, Windows NT, PL/SQL, SQL Loader, VISIO, TOAD, Java, Eclipse, ASP.NET, VB.NET, C , Java Script, JDBC, Java Servlets, JIRA

Confidential

Sr. Developer

• A workforce management system for the US based Intellikey Labs Corporation. Encompassing every aspect of the clients business, it manages data for every step of a sale, from receiving orders to final Reporting. Responsible for maintaining all the details of the business including but not limited to the Client details, Employee records, Inventories and even financial accounts. Its main component consists of an Auto-Scheduler, which manages human resource allocation and tracks the actual work flow.
• Responsibilities:
• Installed, Configured designed Oracle 8i databases on Windows NT, Solaris.
• Created logical and physical database as per specifications.
• Established and maintained Security and Integrity controls.
• Automated data loading into database tables from files using SQL LOADER.
• Taking the logical physical backups.
• Established database recovery procedures.
• Fixing faults in the Stored Procedures
• Performed automatic monitoring of users, tablespaces, tables, indexes Auditing of database.
• Fixing of various performance issues identified by the end users and testing team.
• Used Eclipse, logging files for troubleshooting and debugging Java applications.
• Exposure in running the java unit test cases of JUnit by configuring the JUnit testing environment to ensure the functional flow if the application throw any run time exceptions or application break.
• Used Weblogic admin console to monitor queue s .
• Experience in building small java module in Eclipse IDE.

Environment: Oracle 9i, Windows NT, PL/SQL, SQL Loader, TOAD, Java, Eclipse, Java Script, JDBC, Java Servlets, JIRA

Confidential

Sr. Developer

• GEG is a research group, this group study and analyze the financial markets across the globe. This group does in depth research about the financial vitals of the companies and makes good investment recommendations. Based on the recommendations portfolio managers invest in those companies by using various instruments such as secondary market, mutual funds, US fiduciary etc., GEG is a system for research, order generation, trading and back office operations. This application gives a stock recommendation to buy, sell or hold.
• Responsibilities:
• Installed, Configured designed Oracle 8i databases on Windows NT, Solaris.
• Created logical and physical database as per specifications.
• Established and maintained Security and Integrity controls.
• Automated data loading into database tables from files using SQL LOADER.
• Taking the logical physical backups.
• Established database recovery procedures.
• Fixing faults in the Stored Procedures
• Performed automatic monitoring of users, tablespaces, tables, indexes Auditing of database.
• Fixing of various performance issues identified by the end users and testing team.
• Used Eclipse, logging files for troubleshooting and debugging Java applications.
• Exposure in running the java unit test cases of JUnit by configuring the JUnit testing environment to ensure the functional flow if the application throw any run time exceptions or application break.

Environment: Oracle 9i, Windows NT, PL/SQL, SQL Loader, TOAD, Java, Eclipse, Java Script, JDBC.

Confidential

S/W Developer

• LIMWIZ Laboratory Information Management Wizard
• Laboratory Information Management Wizard is meant for research development on similar topics carried out at any of the globally spread corporate labs. It includes Transfer of sample details, analysis requirements, final data, images, spectra, and chromatograms from dedicated data acquisition systems of various instruments to the server.
• Responsibilities:
• Installed, Configured designed Oracle 8i databases on Windows NT.
• Integration with multiple RDBMS in a seamless manner.
• Used the OEM tools like Index Analyzer, Performance Manager, SQL Analyzer, Instance Manager.
• Created backend database tables, indexes and Stored Procedures
• Trouble Shooting errors and assist developers. Wrote stored procedures and triggers to maintain data integrity.
• Involved in Design, Coding and Testing

Environment: Java, Oracle 8i, PL/SQL, Crystal Reports 8.0

Confidential

Software Developer

• centralize all employee information, personnel records, document actions like hiring, promotions, reviews, terminations, alerts the legal significance of employee management issues, accurate attendance tracking, track leaves of absence, jury duty and more over chart each employee's leave status with visual bar graphs, summaries of attendance data adjustments, payroll packages, creates reports and charts employee information and provides expert human resource advice.
• Responsibilities:
• Design User interface by using VB 6.0
• Developed COM components
• Creating Tables and Stored procedures
• Develop the Data Reports and Excel Reports
• Implemented Client Server Architecture
• Involved in Unit testing, Integration testing and debugging

Environment: Visual Basic 6.0, Sql server7.0, Stored Procedures, Data Reports