SUMMARY

• 12+ years of experience in Information Technology which includes experience in Business Requirement Gatherings, Analysis, Design, Data Modeling, Database Development, Reports creation, Testing and Implementation of Data warehouse/Business Intelligence using Oracle 8i/9g/10g/11g/12c, Informatica 9.x/8.x/7.x/6.x/5.x, Crystal 2011/2008/XI, BOXI R4/R3.
• 10+years of professional experience as Oracle SQL/PLSQL developer, Analysis, Design and Modeling.
• 5+ years of experience in using Informatica ETL, Informatica Power Mart/Center 9.1/8.6/8.2/8.1 /7.1/6.2/5.1/4.7/1.7 , FACT Tables, Dimension Tables, Star Schema Modeling, Erwin 4.x/3.x.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Expertise with Data Migration, Data Mapping or Table mapping, Data loading and exporting by using Import Export, SQL*Loader and UTL File Utilities.
• Proficient in Oracle Development Tools like SQL Developer, TOAD and DB2 Visualizer.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re - Write and Transportable table spaces.
• Worked extensively on forward and reverse engineering processes. Created DDL scripts for implementingData Modelingchanges. Created ERWIN reports in HTML, RTF format depending upon the requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes.
• Extensive experience in designing theData modelsfor OLTP & OLAP database system.
• Experience with Oracle Supplied Packages such as DBMS SQL, DBMS JOB and UTL FILE.
• Extensively worked on Design, Development, Deployment & Maintenance of ETL process to Extract, Transform and Load (ETL) data from different sources (Flat/Excel/Access/XML SQL/ Oracle) to different targets (DB/Files).
• Worked extensively on Ref Cursor, External Tables, Dynamic SQL, Collections and Exception handling.
• Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.
• Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.
• Possess strong Conceptual and Logical Data Modeling skills, has experience with JAD sessions for requirements gathering, creating data mapping documents, writing functional specifications.
• Extensive experience working in Agile (Scrum) environment and Waterfall Model.
• Dimensional Data Modeling: 4+ years of experience in Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin 4.5/4.0/3.5/3. x, Oracle Designer.
• Experience in developing Informatica Mappings/Mapplets using various Transformations and Oracle PL/SQL programs.
• Extensive experience working inHP-UX, AIX and LINUX environment and also performingfile transfers,job schedulingand error handling.

TECHNICAL SKILLS

ETL Tools: Informatica Power Mart 5.1/6.2, Informatica Power Center 9.1/8.6/8.2/8.1 , 7.1,6.2

Business Intelligence: Crystal Reports XI R 2/2008/2011/2013 , Business Objects 5.x/6.1b/6.5/XI R2/XI 3.0 (Central Management Console, Designer, Desktop Intelligence, Info View, Web Intelligence)

Operating Systems: Windows NT/XP/95/98, Windows 2000/2003/2012 , MS-DOS, Unix/Linux/Solaris, Windows 7 Enterprise.

Business Analysis: MS Project 2000, User Interviews, Business Requirements Gathering, Process flow diagrams, Microsoft Visio.

Languages: C, C++, Java, SQL, PL/SQL, ASP.NET, JavaScript, VBScript and Shell Script.

GUI Tools: Visual Basic 5.0/6.0/2010 , Developer 2000, Forms and Reports 10.1.2.3

Database: SQLServer 2005/2008/2012 , MS Access 2003/2010/2013 , Oracle 8i/9g/10g/11g/12c, Teradata

Packages & Tools: MS-Office, TOAD 11.6.1/10.6.1 , SQL Developer, DB2 Visualizer, DBeaver

Data Modeling: Erwin 4.1/3.5.5/3.5.2 (Dimensional data Modeling, Star Join Schema and Snow-Flake Modeling, FACT and Dimension Tables, Physical and Logical Data Modeling

Scheduling Tools: Autosys, Crontab, BMC Control M

Version Control Tools: PVCS, Tortoise SVN, Team Foundation Server

PROFESSIONAL EXPERIENCE

Confidential, Alexandria, VA

Oracle Application DBA

Responsibilities:

• Perform database-related activities for software code projects at Confidential .
• Created triggers to audit the column and table specific changes in the database.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Handled errors usingException Handlingextensively for the ease of debugging and displaying the error messages in the application.
• Monitor and perform DBMS stats for high volume tables and schema’s if necessary to improve SQL performance.
• Created functions to perform certain business logic based on the need, which will be used in an SQL or a procedure when needed.
• Create necessary subprograms to synchronize data across multiple databases using Golden Gate.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Extensively usedbulk collectionin PL/SQL objects for improving the performing.
• Createdrecords, tables, collections(nested tables and arrays) for improving Query performance by reducingcontext switching.
• Created procedures to read data from csv files and then do the necessary bulk updates in the tables.
• Assist in the data model design, create logical and physical data model and then transform the physical model into the actual database design by adding necessary constraints.
• Created materialized views in order to replicate the same type of data in different databases.
• Created DDL and DML scripts to create new database objects and also do the necessary inserts and updates when necessary.
• Performed performance tuning of the queries and logic used in the existing Java applications using Explain Plan, TKPROF and AWR.
• Recommended certain changes to the SQL Queries used to improve performance of the long running queries and also what type of changes can be made to the logic used in some of the procedures for better performance and throughput.
• Create and Monitor the compare scripts used to do the data comparison across two different databases and fix the differences accordingly.
• Create procedures and SQL scripts to perform the data migration from multiple sources to target database.
• Created and modified severalUNIX Shell Scriptsaccording to the changing needs of the project and client requirements.
• Created procedures to do bulk inserts from csv file into different tables which would allow for bulk test data creation to facilitate the testing of new domain services like Domestic Continuity, Patent Reference domain etc.,.
• Monitor any application specific jobs and if any of the jobs resulted in a failure, examine the logs and do the necessary review of logs with the application developer.

Environment: Oracle 11g/12c, SQL, PL/SQL, Toad 11.6, SQL Developer 4.1.3, Windows 7 Enterprise, SVN, Crystal Reports 2011, Win SCP, Linux, Agile (Scrum), Java, Oracle Golden gate 11.1.1, CA ERwin Data Modeler Mart v9.5.0.

Confidential, Reston, VA

Sr. Developer / Analyst

Responsibilities:

• Worked as an Analyst / Data Modeler to generate data models (logical and physical) using Erwin and SQL Developer which are used in the creation of tables and for the respective referential integrity constraints.
• Responsible for developing an automated process that will be used to identify different types of deficiencies for a given assessment with in enterprise database.
• Wrote Complex PL/SQL procedures and functions to efficiently perform complex business logic to insert data into tables.
• Wrote SQL queries efficiently to narrow down the subset of records to analyze and then do the necessary data reconciliation.
• Created theConceptual Modelfor the Data Warehouse usingErwinData Modeling tool.
• DevelopedScripts that automated DDL and DMLstatements used in creations of Databases, Tables, Constraints, and updates.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Created scripts to create new tables, views, Materialized views and Queries for new enhancements in the application using TOAD and SQL Developer.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.
• Migrated reports from version Crystal XI to Crystal 2008.
• Created Crystal reports using SQL query or a Package and exported them to PDF of Excel.
• Responsible for building scripts necessary to fix the data quality issues.
• Responsible for helping out the Cognos team with the back-end related issues and making improvements to the database query or Package logic used.
• Responsible for building excel reports based on a SQL Query and sending them across to the Confidential Counselors and other users.
• Extensively used DML error logging for one of the automated process as the process involves inserting bulk records on a daily basis.
• Debugging Packages, Stored Procedures and documenting the existing process.
• Intensivedataanalysis on the error log tables to ensure that the clean datagets in the table created.
• Responsible to understand and apply dataquality rules and assess the impact in terms of business and technical risk.
• Created a Work Flow design to determine resolution steps for each type of deficiency and then work with respective teams on resolution.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Developed procedures to retrieve data from different source systems and load them into the data warehouse.
• Performed Data analysis and Data Profiling using Complex SQL on various source systems.

Environment: Oracle 11g, SQL, PL/SQL, Toad 11.6, SQL Developer 4.1.3, Windows 7 Enterprise, SVN, Crystal Reports, IBM Clear Quest, JIRA, Win SCP, Data Flux, Linux, Agile (Scrum), CA ERwin Data Modeler Mart v9.5.0.

Confidential, Warren dale, PA

Sr. Application Developer/ Analyst

Responsibilities:

• Wrote larger and complex PL/SQL procedures and functions to efficiently perform complex business logic to summarize data.
• Involved in the Agile (Scrum) methodology project framework where the project is divided into 4 week sprints.
• Responsible for preparing test plans, unit testing, System integration testing, implementation and maintenance of the new modules (Packages, Procedures, and Triggers etc.).
• Used Team Foundation Server to monitor and asses the User Stories under each sprint and also to update the status of each user story accordingly depending on the progress.
• Worked on SQL*Loader to load data from csv files obtained from business and third party vendors.
• Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements. Created shell scripts to automate repetitivedatabase processes.
• Worked with DBA to create the physical model and tables. Scheduled multiple brain storming sessions with DBAs and production support team to discuss about views, partitioning and indexing schemes case by case for the facts and dimensions.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Create spreadsheets and reports using oracle PL SQL, Toad, SQL Developer and SQL.
• Created scripts to create new tables, views, Materialized views and Queries for new enhancements in the application using TOAD and SQL Developer.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files or excel using UTL FILE package.
• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Developed the LogicalDataModel (LDM) & PDM and assisted the DBA to create the physical database by providing the DDL scripts including Indexes, Data Quality checks scripts and Base View scripts, keeping adherence to database optimization.
• Used FTP Reflection to transfer the files into different servers as needed by the business users, also to transfer files from local desktop folder to the Linux server location.
• Used Attachmate Reflection tool to connect to the Linux server in order to run and test the SQL scripts through SQL Plus.
• Worked on Scheduling and Modifying Batch Jobs using BMC Ctrl M.
• Created new batch jobs using existing workspace in Control M or by creating new workspace.
• Involved in setting up calendars for new batch jobs and also modify some existing calendars accordingly.
• Created Standalone SQL scripts to be run through batch for performing certain tasks.
• Worked on processing the files received from BNYM and JPMC.

Environment: Oracle 10g / 11g, SQL, PL/SQL, Toad 11.6, SQL Developer, SSRS 2012, Windows 7 Enterprise, C#.NET, VB 6.0, PVCS, XML, Excel VBA, Edit Plus, Control M v8.0/7.0, Linux, TFS(Team Foundation Server), Agile(Scrum), Attachmate Reflection.

Confidential, Omaha, NE

Application Developer

Responsibilities:

• Developed stored procedures and complex packages using PL/SQL.
• Wrote larger and complex PL/SQL procedures and functions to efficiently perform complex business logic to summarize data.
• Created scripts to create new tables, views, Materialized views and Queries for new enhancements in the application using TOAD.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Extensively involved in using hints to direct the optimizer to choose an optimum query execution plan.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Used Pragma Autonomous Transaction to avoid mutating problem in database trigger.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Created PL/SQL scripts to extract the data from the operational database into simple flat text files or excel using UTL FILE package.
• Solved implementation problems in PL/SQL and database related issues with ETA less than 30 minutes.
• Extensively involved in Fine-tuning the Informatica Code (mapping and sessions), Stored Procedures, SQL to obtain optimal performance and throughput.
• Developed Packages, customized functions and Triggers in PL/SQL based upon the business logics.
• Extensively used the concept of DBMS error logging for insert, update and delete operations in order to ignore certain number of errors while data loading.
• Built and maintained SQL, PL/SQL scripts, indexes, reports and queries for data analysis and extraction.
• Responsible for Integrating VB application with C# Library.
• Extensively worked with Source Analyzer, Warehouse Designer, Transformation Designer, Mapping Designer and Mapplet Designer.
• Interacted with business users to analyze the business process and requirements and transforming requirements into Conceptual, Logical and Physical Data Models, Designing Database, Documenting and Rolling out the Deliverables.
• Developed Logical/ Physical Data Models using ER Studio toolacross the subject areas based on the specifications and establishedReferential Integrityof the system.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level. Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Design ETL process involving data quality, testing and information delivery and access to the data warehouse.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, Query Re-Write and Transportable table spaces.
• Incorporating logic from different set of stored procedures in PL/SQL to be used in the new stored procedure for the new reporting requirements.
• Extensively used the concept of Bulk Collect in Cursors to load huge volume of data into variables for reuse.
• Troubleshooting, Optimizing, and fine-tuning the SQL Queries using Explain Plan, tkprof etc. utilities for better performance.
• Involved in the upgrade of Oracle 9g to 11g and then validate the applications against Oracle 11g.
• Responsible for following the Enterprise WIP(Work Implementation Process) process when working on enhancements that involves requirements gathering, research and analysis, design, construction, testing and deployment.
• Extensively used Subversion (SVN) to deploy code across different environments and also created repositories in SVN for the reporting needs.
• Extracted Source Data using Informatica tools and stored procedures from Source Systems.
• Interacted with users to gather reports requirements and designed technical and functional specifications.
• Responsible for regression testing of UNIX shell scripts on the new Linux Server while migrating from AIX.
• Responsible for the successful migration of shell scripts from AIX to Linux Server.
• Creating shell scripts from scratch in UNIX to trigger some of the batch processes.
• Identifying the errors received from the file sent by the third party vendor and then modifying them accordingly in Unix Production Server.
• Responsible for creating and scheduling command and box jobs in Autosys to run batch processes on a daily and monthly basis.
• Responsible for creating filters and Calendars in Autosys to restrict jobs from running on specific days.

Environment: Informatica 9.0.1, Bugzilla, Oracle 10g / 11g, SQL, PL/SQL Toad 11.6, Crystal Reports 2011/ 2008, VB 6.0/2010, ASP, Windows XP Professional, Java/J2EE, Erwin, VB 6.0, PVCS, Tortoise SVN, Info View, Edit Plus, Autosys, Unix, HP-UX/AIX/LINUX.

Confidential, Winston-Salem, NC

Sr. SQL, PL/SQL Developer

Responsibilities:

• As a part of merger transition process was responsible for smooth transition of reports to the reporting environment.
• Managed the database and performed the basic tasks like creating users, assigning roles and privileges, creating new tables etc.
• Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions.
• Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions.
• Developed and modified triggers, packages, functions and stored procedures for data conversions and PL/SQL procedures to create database objects dynamically based on user inputs.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Used principles of Normalization to improve the performance. Involved in ETL code using PL/SQL in order to meet requirements for Extract, transformation, cleansing and loading of data from source to target data structures.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams.
• Partitioned Sessionsfor concurrent loading of data into the target tables.
• Involved in identifying the bottle necks and tuning to improve the Performance.
• Created workflowsusing Workflow manager for different tasks like sending email notifications, timer that triggers when an event occurs, and sessions to run a mapping.
• Executed Workflows and Sessions using Workflow Monitor.
• Developed UNIX Shell scripts to automate repetitive database processes.
• Extensive use of Oracle External Tables new feature of Oracle 9g, which is useful to load the Data from flat file.
• Responsible for extracting data from flat files to oracle tables using SQL*loader.
• Extensively involved in the Modification and Performance Tuning of the existing codes and making changes according to the customer requirements.
• Extracting data from different sources like Oracle, Flat files, External files and transformed the data based on Business requirements and loading into Oracle target database.
• Writing database triggers and stored procedures to support business logic.
• Responsible for rewriting queries to improve the performance of the application.
• Involved with DBA in creating schema and related privileges and roles.
• Created PL/SQL packages containing procedures and functions that were shared by multiple forms, reports and data management applications.
• Experience in performance tuning of targets, sources, mappings and sessions.
• Modifying existing reports and to develop new reports by analyzing databases, data sources, and structures for the benefit of internal users.
• Responsible for asserting data needs data analysis, data extraction, report maintenance and design.
• Responsible for report development, report testing and report implementation for Credit Risk and Performance Measurement.
• Created table spaces in Oracle to manage space for database sort operations and for storing global temporary tables.
• Demonstrating familiarity with standard business reporting processes and also to refine data needs in a changing environment to meet specific business objectives.
• Responsible for both recommended and completed detailed report customizations to narrow report focus to meet specific business needs for the Credit Risk team.
• Creating complex queries against Oracle, SQL Server and the MS Access database.
• Responsible for taking care of the additional reporting requests that were not part of the initial Merger transition plan.
• Worked with different data sources and when the need arises had to combine data from different sources to generate a single report.
• Responsible for dealing with ADW (Active Data Warehouse) which houses several databases and then based on the request pertaining to each database generate reports.
• Worked with Teradata SQL Assistant to access different databases in ADW from different environments like SIT/UAT, PROD and DEV.

Environment: Oracle 10g, Informatica 8.6, Crystal Reports 2008, Windows XP, UNIX, MS Access, SQL Server, DB2 Visualizer, Crystal Enterprise 10, Xcelsius and PL/SQL.

Confidential, Baltimore, MD

Sr. SQL/ Business Objects Developer

Responsibilities:

• Worked as a SQL/Reports Developer in generating reports for financial teams and customers across Advertising.com.
• Worked with the business analyst team to interview the business users and capture simple, moderate and complex business requirements. Collaborated with business technicians to research existing business and system processes.
• Responsible for re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.
• Created table spaces in SQL to manage space for database sort operations and for storing global temporary tables.
• Responsible for Creating Views in SQL to protect some of the columns of a table from other users, to hide complexity of a query and to hide complexity of calculations.
• Responsible for maintaining data integrity in SQL through a set of rules that restrict the values of one or more columns of the tables based on the values of primary key of the referenced table.
• Performed Administration tasks for our Project, Which Included Creating Folders, creating users/ Groups giving Appropriate Access levels.
• Involved in table redesigning with implementation of Partitions Table and Partition Indexes to make Database Faster and easier to maintain.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
• Review the business requirements with the Analysts, Business Users and Developers to construct SQL queries for implementing the same in PL/SQL packages.
• Construct complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD).
• Published and scheduled the reports in Crystal Enterprise using Crystal Management Console so that reports are accessed from Front-end application.
• Created customized existing reports using sub-reports and charts to present information.
• Created the Crystal reports using tables and tested the reports by cross checking and verifying data against the reports generated from the legacy system.
• Wrote formulas to calculate the group summaries based on the group levels in Crystal Reports.
• Created reports across the channels (Sub Reports Drill-down, dynamic grouping, Master/Detail, Cross-Tab, graphical, aging reports etc.).
• Extensively involved in creating Parameters and Record Selection Formulas to allow the users to filter the data in Crystal Reports.
• Created Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Cross-tab reports.
• Develop the Stored procedures to be able to customize the report according to specifications.
• Installed and Configured BO XI R2 on windows platform and dealt with troubleshooting issues during installation.
• Installed Business Objects XI 3.0 in Dev and QA environment and Migrated Reports, Universe, Users, Groups and Security from XI R2 to XI 3.0.
• Created Users, User Groups. Granted access to BOE applications to users and added security restrictions (Application level, Folder level, Object level) based on the user profile and user groups.
• Created Universe with available tables from Auth Data mart. Created Dimension, Measure and Condition objects in Universe and named the objects as per the business naming standards and filled in the Meta-Data for objects. Setup Custom Hierarchies for Drill down Reports.
• Created, Managed and involved in delivery of both traditional, paper-oriented reports and interactive, Web-based reports using SSRS.
• Responsible for deploying interactive Web-based reports to deliver information to customers or partners over extranets or the Internet in SSRS.
• Worked with Report Builder, an ad-hoc reporting tool that enables business users to create their own reports and explore corporate data in SSRS.

Environment: Oracle 10g, Business Objects, SSRS, Crystal Reports XI, Windows XP, UML, and PL/SQL.

Confidential, SFO, CA

SQL/ Crystal Reports Developer

Responsibilities:

• Worked as a part of the team responsible for generating reports for the End users and different business teams across Bare Escentuals.
• Responsible for handling numerous queries with complex criteria using Snowflake schema.
• Responsible for Data abstraction in PL/SQL that will extract the essential properties of data while ignoring unnecessary details.
• Responsible for using dynamic SQL in PL/SQL which is an advanced programming technique that makes the applications more flexible and versatile.
• Extracting the data from the existing systems and loading it into the repository.
• Troubleshooting, Optimizing, and fine-tuning the SQL Queries using Explain Plan utilities for better performance.
• Responsible for Writing Stored Procedures in PL/SQL for better performance.
• Responsible for Coordinating with Application Developers in the integration and utilization of Crystal Tools in the development of applications.
• Modify report content and export reports in multiple formats based on user input in Crystal XI.
• Reviewed User Requirements. Created detailed Functional Design Documents and Report design details documents for the reports.
• Created parameterized Crystal reports and customized existing reports for presentations using Cross-Tab reports, sub-reports, Running Totals, Sorting.
• Interacted with customer support regularly, in order to generate the reports required and to resolve the existing issues.
• Study the existing system, analyze the existing reports, understand the data and derive business rules for the new system for cross channel reporting.
• Used Cross-tab expert to generate aggregate (SUM, Count, MAX, MIN) functions for a field or a column.
• Configured and trained users to use Crystal Reports XI.
• Involved in Trouble Shooting all the issues in Crystal Enterprise 10 and Business Objects Enterprise XI.
• Involved in re-designing or customizing the existing Views and Stored Procedures to suit the reporting needs.
• Developed Reports using Sub reports and Sub report Links.
• Responsible for Installation and Configuration of Crystal Reports XI.
• Responsible for preparing requirements, dependency scenarios documents for the reports.

Environment: SQL Server, PL/SQL, TOAD, Business Objects, Crystal Reports XI.

Confidential, Chicago, IL

SQL/ Crystal Reports Developer

Responsibilities:

• Reviewed User Requirements, Created detailed Functional Design Documents and Report design details documents for the reports.
• Involved in gathering requirements and requirements study, design reviews and analysis of input/output flow.
• Created Crystal reports using the legacy Requirements Documents.
• Responsible for developing and maintaining required standards including security, application integration, naming conventions, report version control and delivery formats.
• As an Admin responsible for preparing all required documentation for standards, projects and SEMM requirements.
• Responsible for Installation and Configuration of Crystal Reports 10/XI.
• Responsible for Upgrading Reports from Crystal 9.x to Crystal Reports XI.
• Created complex report using with 46 Sub reports, cross tab, custom functions, formulas and Suppressing conditions and Used advanced features like Dynamic and cascading Prompts.
• Exported Reports into PDF, Excel, word & RTF from Enterprise and resolved formatting issues.
• Scheduled the Crystal reports & E-mail them to the necessary departments through Info view.
• Converted the reports into different formats like Excel, PDF and HTML based on the user’s requirement using Business Objects.
• Performed Administration tasks for our Project, Which Included Creating Folders, creating users/ Groups on Central Management Console and giving Appropriate Access levels.
• Worked extensively with the different functionalities of BO like Breaks, Filters, Sorts, and Query Prompts.
• Created reports (Canned & Ad-hoc) based on the business requirements using Web Intelligence.
• Installation and Configuration of BO & Web Intelligence applications for different developers.
• Review data transformation rules and provide technical suggestions in data transformation logic and pseudo code (PL/SQL).
• Performed Unit testing and System Integrated Testing and Documented test results.
• Based on Requirement Created Complex Crystal report using the data from Sybase, SQL Server and Oracle server data base.
• Responsible for preventing client applications from manipulating sensitive Oracle data using stored procedures in PL/SQL.
• Coordinating with Database team for the database design and Created SQL queries for extract data from oracle data base.
• Resolved the Performance issues/Data issues with in the Reports and Procedures in PL/SQL.

Environment: Crystal Reports XI R2, BO XI, Info View, Pl/SQL, Oracle 10g

Confidential, Gaithersburg, MD

SQL/ Crystal Reports Developer

Responsibilities:

• Designed standard reports and cross-tab reports according to the specifications using Crystal Reports 9.0.
• As an Administrator responsible for providing technical assistance, problem resolution and integration designs to developers and users as required.
• As an Administrator responsible for acquiring and maintaining required technical knowledge for the technologies supported.
• Responsible for Upgrading Reports from Crystal 8.5 to Crystal Reports 9.
• Created linked and unlinked Sub Reports to create applicants experience/qualifications reports.
• Published reports on the web using Crystal Enterprise 9.0 and Crystal Reports 9.0.
• Extensively involved in writing various formulas for calculations and combining the data.
• Created various charts using the Chart Expert in Crystal Reports 9.
• Involved in writing Custom Functions to be used in other functions in Crystal Reports.
• Published the reports to the Folders in CMC.
• Involved in generating the reports in PDF and Excel Formats depending on the user requirements.
• Scheduled the reports to run for each month and quarter by using CMC.
• Involved in migration of Business Objects 5.1.3 reports to 6.5.1.
• Used UNIX Shell scripts (KORN Shell) for Extracting and Parsing data from the files.
• Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application.
• Used stored procedures in Oracle for retrieving the data from the database for solving complex queries.
• Responsible for using specific stored procedure to create a customized error message in PL/SQL.
• Extensively involved in coding Views and Queries in Oracle using TOAD.
• Involved in creating functions and Stored Procedures in PL/SQL for Reports.

Environment: Crystal Reports 9, SQL Server 2000, UNIX, Pl/SQL and Windows XP.

Confidential, Michigan

Application Support Developer

Responsibilities:

• Developed GUI using Oracle Forms.
• Developed Reports using Oracle Reports.
• Developed Reports using dynamic cascading parameters.
• Developed Batch Reports using SQR.
• Developed Database Triggers, which checks the data integrity.
• Responsible for writing simple Unix Shell Scripts for base automation of processes for loading and testing.
• Create various scripts for enhancing loading process and techniques for restart ability of jobs.
• Identified and mapped the various entities, referential integrity constraints and relationships.
• Loading data from flat files into to database tables using SQL* loader.
• Responsible for code migration of existing application from SQL Database to Oracle Database.
• Performed the uploading and downloading flat files from UNIX server using FTP.
• Involved in debugging and Tuning the PL/SQL code, tuning queries, optimization for the Oracle database.

Environment: Oracle 8.1.6/9g, Oracle Developer (Forms 6i, Reports 6i), PL/SQL, SQL, UNIX, Windows, Oracle Application Server.

Confidential

PL/SQL Developer

Responsibilities:

• Played key role in Design and Development of Database.
• Involved in the entire software development process, established the goals and requirements of the application, data collection and analyzing the data as well as business flow.
• Extensively worked with stored procedures in Oracle for retrieving the data from the database for solving complex queries. Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of the application. Developed job queues, which work similar to Queue series for running the program asynchronously.
• Created Stored Packages, Procedures and functions in Oracle 9g using SQL and PL/SQL for the Audit Trail using Oracle 9g as backend.
• Worked on table partitioning (Range and List) and deploying various methods of indexing like local indexes and global indexes on portioned tables.
• Extensively worked on Explain plans and various hints for Performance tuning.
• Involved in extracting Data from the Heterogeneous databases residing on Mainframe, UNIX.
• Used Oracle 9g new features such as merge for various transformations.
• Involved in creating procedures for Raw Data Reports using PL/SQL.
• Created linked sub reports (regular and On-demand) as well as unlinked Sub-Reports along with the Primary reports.
• Troubleshooting for all the issues in Crystal Enterprise and Reports.

Environment: SQL Server 2000/2005, SQL and PL/SQL Oracle 8.X/9g, Crystal Reports, TOAD.