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.
• TEMPEffectively 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 teh requirement, published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply teh 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 noledge 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, TEMPhas 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 teh column and table specific changes in teh database.
• UsedPragma Autonomous Transactionto avoid mutating problem in database trigger.
• Handled errors usingException Handlingextensively for teh ease of debugging and displaying teh error messages in teh 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 teh need, which will be used in an SQL or a procedure when needed.
• Create necessary subprograms to synchronize data across multiple databases using Gloden 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 teh 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 teh necessary bulk updates in teh tables.
• Assist in teh data model design, create logical and physical data model and then transform teh physical model into teh actual database design by adding necessary constraints.
• Created materialized views in order to replicate teh same type of data in different databases.
• Created DDL and DML scripts to create new database objects and also do teh necessary inserts and updates when necessary.
• Performed performance tuning of teh queries and logic used in teh existing Java applications using Explain Plan, TKPROF and AWR.
• Recommended certain changes to teh SQL Queries used to improve performance of teh long running queries and also what type of changes can be made to teh logic used in some of teh procedures for better performance and throughput.
• Create and Monitor teh compare scripts used to do teh data comparison across two different databases and fix teh differences accordingly.
• Create procedures and SQL scripts to perform teh data migration from multiple sources to target database.
• Created and modified severalUNIX Shell Scriptsaccording to teh changing needs of teh 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 teh testing of new domain services like Domestic Continuity, Patent domain etc.,.
• Monitor any application specific jobs and if any of teh jobs resulted in a failure, examine teh logs and do teh necessary review of logs with teh 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 Gloden 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 teh creation of tables and for teh 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 teh subset of records to analyze and then do teh necessary data reconciliation.
• Created theConceptual Modelfor teh 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 teh 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 teh application using TOAD and SQL Developer.
• Extensively involved in using hints to direct teh 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 teh data quality issues.
• Responsible for helping out teh Cognos team with teh back-end related issues and making improvements to teh database query or Package logic used.
• Responsible for building excel reports based on a SQL Query and sending them across to teh Confidential Counselors and other users.
• Extensively used DML error logging for one of teh automated process as teh process involves inserting bulk records on a daily basis.
• Debugging Packages, Stored Procedures and documenting teh existing process.
• Intensivedataanalysis on teh error log tables to ensure that teh clean datagets in teh table created.
• Responsible to understand and apply dataquality rules and assess teh 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 teh 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 teh Agile (Scrum) methodology project framework where teh project is divided into 4 week sprints.
• Responsible for preparing test plans, unit testing, System integration testing, implementation and maintenance of teh new modules (Packages, Procedures, and Triggers etc.).
• Used Team Foundation Server to monitor and asses teh User Stories under each sprint and also to update teh status of each user story accordingly depending on teh 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 teh changing needs of teh project and client requirements. Created shell scripts to automate repetitivedatabase processes.
• Worked with DBA to create teh 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 teh 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 teh application using TOAD and SQL Developer.
• Extensively involved in using hints to direct teh 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 teh advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for teh ease of debugging and displaying teh error messages in teh application.
• Created PL/SQL scripts to extract teh data from teh operational database into simple flat text files or excel using UTL FILE package.
• Used principles of Normalization to improve teh 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 teh LogicalDataModel (LDM) & PDM and assisted teh DBA to create teh physical database by providing teh DDL scripts including Indexes, Data Quality checks scripts and Base View scripts, keeping adherence to database optimization.
• Used FTP Reflection to transfer teh files into different servers as needed by teh business users, also to transfer files from local desktop folder to teh Linux server location.
• Used Attachmate Reflection tool to connect to teh Linux server in order to run and test teh 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 teh 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 teh application using TOAD.
• Created indexes on teh tables for faster retrieval of teh data to enhance database performance.
• Extensively involved in using hints to direct teh 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 teh advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for teh ease of debugging and displaying teh error messages in teh application.
• Created PL/SQL scripts to extract teh data from teh 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 teh 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 teh business logics.
• Extensively used teh 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 teh business process and requirements and transforming requirements into Conceptual, Logical and Physical Data Models, Designing Database, Documenting and Rolling out teh Deliverables.
• Developed Logical/ Physical Data Models using ER Studio toolacross teh subject areas based on teh specifications and establishedReferential Integrityof teh 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 teh data warehouse.
• TEMPEffectively 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 teh new stored procedure for teh new reporting requirements.
• Extensively used teh concept of Bulk Collect in Cursors to load huge volume of data into variables for reuse.
• Troubleshooting, Optimizing, and fine-tuning teh SQL Queries using Explain Plan, tkprof etc. utilities for better performance.
• Involved in teh upgrade of Oracle 9g to 11g and then validate teh applications against Oracle 11g.
• Responsible for following teh 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 teh 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 teh new Linux Server while migrating from AIX.
• Responsible for teh successful migration of shell scripts from AIX to Linux Server.
• Creating shell scripts from scratch in UNIX to trigger some of teh batch processes.
• Identifying teh errors received from teh file sent by teh 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 teh reporting environment.
• Managed teh database and performed teh 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 teh 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 teh 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 teh target tables.
• Involved in identifying teh bottle necks and tuning to improve teh 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 teh Data from flat file.
• Responsible for extracting data from flat files to oracle tables using SQL*loader.
• Extensively involved in teh Modification and Performance Tuning of teh existing codes and making changes according to teh customer requirements.
• Extracting data from different sources like Oracle, Flat files, External files and transformed teh 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 teh performance of teh 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 teh 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 teh Credit Risk team.
• Creating complex queries against Oracle, SQL Server and teh MS Access database.
• Responsible for taking care of teh additional reporting requests that were not part of teh initial Merger transition plan.
• Worked with different data sources and when teh 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 teh 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 teh business analyst team to interview teh 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 teh existing Views and Stored Procedures to suit teh 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 teh 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 teh values of one or more columns of teh tables based on teh values of primary key of teh d 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 teh business requirements with teh Analysts, Business Users and Developers to construct SQL queries for implementing teh same in PL/SQL packages.
• Construct complex SQL queries with sub-queries, inline views as per teh functional needs in teh Business Requirements Document (BRD).
• Published and scheduled teh 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 teh Crystal reports using tables and tested teh reports by cross checking and verifying data against teh reports generated from teh legacy system.
• Wrote formulas to calculate teh group summaries based on teh group levels in Crystal Reports.
• Created reports across teh 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 teh users to filter teh data in Crystal Reports.
• Created Report templates, Summary Reports, Master/Detail Reports, Parameterized Reports and Cross-tab reports.
• Develop teh Stored procedures to be able to customize teh 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 teh user profile and user groups.
• Created Universe with available tables from Auth Data mart. Created Dimension, Measure and Condition objects in Universe and named teh objects as per teh business naming standards and filled in teh 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 teh 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 teh team responsible for generating reports for teh 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 teh essential properties of data while ignoring unnecessary details.
• Responsible for using dynamic SQL in PL/SQL which is an advanced programming technique that makes teh applications more flexible and versatile.
• Extracting teh data from teh existing systems and loading it into teh repository.
• Troubleshooting, Optimizing, and fine-tuning teh 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 teh integration and utilization of Crystal Tools in teh 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 teh 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 teh reports required and to resolve teh existing issues.
• Study teh existing system, analyze teh existing reports, understand teh data and derive business rules for teh 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 teh issues in Crystal Enterprise 10 and Business Objects Enterprise XI.
• Involved in re-designing or customizing teh existing Views and Stored Procedures to suit teh 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 teh 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 teh reports.
• Involved in gathering requirements and requirements study, design reviews and analysis of input/output flow.
• Created Crystal reports using teh 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 teh Crystal reports & E-mail them to teh necessary departments through Info view.
• Converted teh reports into different formats like Excel, PDF and HTML based on teh 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 teh different functionalities of BO like Breaks, Filters, Sorts, and Query Prompts.
• Created reports (Canned & Ad-hoc) based on teh 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 teh 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 teh database design and Created SQL queries for extract data from oracle data base.
• Resolved teh Performance issues/Data issues with in teh 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 teh 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 noledge for teh 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 teh web using Crystal Enterprise 9.0 and Crystal Reports 9.0.
• Extensively involved in writing various formulas for calculations and combining teh data.
• Created various charts using teh Chart Expert in Crystal Reports 9.
• Involved in writing Custom Functions to be used in other functions in Crystal Reports.
• Published teh reports to teh Folders in CMC.
• Involved in generating teh reports in PDF and Excel Formats depending on teh user requirements.
• Scheduled teh 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 teh files.
• Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of teh application.
• Used stored procedures in Oracle for retrieving teh data from teh 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

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 teh 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 teh 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 teh uploading and downloading flat files from UNIX server using FTP.
• Involved in debugging and Tuning teh PL/SQL code, tuning queries, optimization for teh 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 teh entire software development process, established teh goals and requirements of teh application, data collection and analyzing teh data as well as business flow.
• Extensively worked with stored procedures in Oracle for retrieving teh data from teh database for solving complex queries. Wrote Unix Shell Scripts, undertook Code Optimization and Performance tuning of teh application. Developed job queues, which work similar to Queue series for running teh program asynchronously.
• Created Stored Packages, Procedures and functions in Oracle 9g using SQL and PL/SQL for teh 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 teh 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 teh Primary reports.
• Troubleshooting for all teh issues in Crystal Enterprise and Reports.

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