Sr. PL/SQL Developer/Crystal Reports Developer Resume

Title
Sr. PL/SQL Developer/Crystal Reports Developer

Primary Skills
Financial, Business Intelligence and Data Warehousing having excellent people skills

Location
US-VA-Herndon

Posted
Jul-21-08

SUMMARY
An Assertive professional with over 12 years of experience in IT industry, specializing in Financial, Business Intelligence and Data Warehousing having excellent people skills, high-caliber analytical, leadership, documentation, presentation, negotiation, and closing skills with substantial experience in testing various of IT Business Management Applications / Interfaces.
My objective is to act as an individual contributor on a high level, a technical expert and a business systems provider adapting to the development of new principles and concepts in a specific discipline and will develop solutions to complex problems, there by, delivering a high quality software development/implementation projects by ensuring to SDLC guidelines, managing Project plan and action's, issues and working with developers/customers to define needs, gather and analyze quality data to assist management in making informed, high quality decisions enabling develop efficient business solutions.

FUNCTIONAL AND TECHNICAL SKILLS
Functions/Testing Skills:

* Requirement Gathering and Analysis
* Complete Software Development Lifecycle
* Software Engineering Methodologies
* Tools/Technologies
* Software Asset Management
* Project Management
* Risk Assessment
* Leadership
* Organization
* Documentation
* Presentation
* Team building
* Project Rollout

Technical Skills:

Planning Tools: MS Project, UML, MS Visio, ERWIN, MS Word, MS Excel, MS Project, PowerPoint, Protocols, MS Word Documentation
Databases: Oracle 10g/9i/8i/7.x, MS SQL Server 2000, Sybase, Informix, MS Access, FOXPRO,
DBASE IV
OS, technologies: Windows 98 / 2000/ ME / XP / NT, Unix, MS Dos, Java, C++, BASIC, COBOL, PASCAL, C, SQL, Transact SQL, PL/SQL, Visual Basic 6.0, HTML 4.0, DHTML, Active Server Pages 3.0 (ASP), .NET, Java Script, VB Script, VBA, MS COM, DCOM, DLL, EXE
Networking: LAN, WAN, Computer Networks, Networking Devices, TCP/IP Fundamentals, wireless networks, Intranet, VPN
Validations: SDLC, SOX
BI & ETL Tools: Business Objects XI/6.x, Web Intelligence 6.x, Hyperion Essbase 7.x, Oracle SQL*Loader, MS SQL Server DTS Packages, SQL Server Import & Export utilities
Analytical & Reporting Tools: Hyperion Essbase 7.x, Business Report Designer, Crystal Reports XI, 10, 8.x.
Software: PL/SQL Developer 7.2, MS Visual Interdev 6.0, UML, Erwin 4.0, VISIO 2000, TORA, TOAD 8.6.1, Rapid SQL, Humming Bird v8.0, Host Explorer, Mercury Quality Center v8.2, Adobe Products, and MS Office Suite.
Testing and Version Control: Mercury Quality Control v8.2/9, Rational ClearQuest Web 2003, Visual Source Safe, WinCVS.

EDUCATION & CERTIFICATIONS
* BS in Engineering

* Pursuing Master of Science in Information Systems, Stratford University, Falls Church, VA

* Microsoft Certified Professional in Visual Basic 5.0

* Post Graduate Diploma in Systems Management from NIIT.

* E-certification from Netvarsity (NIIT) in designing and developing UML data models in a Software Development Life Cycle (SDLC).

PROFESSIONAL EXPERIENCE
Sr. Programmer/Analyst - 2008 to Present
United Parcel Service, Scranton, PA
UPS is undergoing some critical updates to the existing Accounts Receivables, Global Invoicing and other financial applications to ensure smooth transition of the journal entry postings into their system. New enhancements include providing similar services to other countries like UK, Asia, Germany, and Netherlands upon successful implementation of Northern America updates.

Responsibilities:

* Currently, working on enhancements to the existing business/functional requirements that cater to the needs of Accounts Receivables Desktop application, Accounts Reporting and Global Invoicing groups in UPS.
* Various daily and monthly Unix ksh scripts are created or modified to include the new enhancements, accordingly Oracle stored procedures, functions and packages are either created or modified to meet to the business user's expectations.
* Actively ensuring the production implementation of the new enhancements with smooth transition of the project by adding value to the team in filling the gap where required as an analyst, programmer and QA tester.
* Providing IT expertise and Involving in the complete life-cycle of the development, support and maintenance of the ARDT project.
* Some critical jobs that I have undertaken were related to the creation and modifications of Unix ksh scripts which includes calls to various business processes that are executed using Oracle stored procedures, functions, packages and DML operations.
* Executing, monitoring various Unix ksh scripts, escalating and bug fixing the related issues as required, providing solution's, implementing code logic as per functional, adhoc requirements.
* Creating/coding reports that meet user requirements, validating reports, supporting data and technical requests, and supporting strategic data analysis. Analyze, extract, transform, load, and integrate data into consumable formats, meeting all critical milestones using data warehouse techniques.
* Providing financial reports using VBA Macros created in MS Excel as adhoc requirements to ensure quality decision making to Accounts and Global Invoicing project members.
* Successfully implemented various financial reports using VBA Macros, also modified existing Macros to ensure performance and quality data.
* Proactively participating in various project discussions concerning new implementations to various other countries like Canada, Europe, UK, Asia, Netherlands, and Germany.
* Contribute to a high-performing workgroup by applying interpersonal and collaboration skills to achieve corporate goals. Provide high level of attention to detail while completing multiple tasks demonstrating a commitment to quality while meeting project deadlines.
* As a key PL/SQL developer, identify and define required analytics to design, develop financial routines, and assist various work streams in identifying, and resolving data irregularities, and establish management reporting processes and requisite supporting technology.
* Construct complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD).
* Review the business requirements with the Analysts, Business Users and Developers to construct SQL queries for implementing the same in PL/SQL packages. An Excel Add-In would be used to generate the results in a cross-tab using OLAP Cube query functionality.
* Created comprehensive documentation for the data mapping elements by identifying the various data sources and mapping each line item within the reporting requirements to the specific database column thus deriving stand-alone SQL queries for each of the same as developer's notes.

Environment: Oracle 10g, UNIX, PL/SQL Developer 7.2, Ultra Edit, MS Access 2000, Crystal Reports XI, Business Objects XI, Oracle SQL Developer 1.0, MS Visio 2000, TOAD 8.6.1., Mercury Quality Center v8.2/9, Rational ClearQuest Web 2003

Sr. Developer/Analyst - 2006 to 2008
Fannie Mae, Washington D.C/Herndon
Responsibilities
* Responsible for developing complex backend database applications using Oracle technologies.
* Create and develop highly complex applications using Oracle as back-end with expertise in design and development of Oracle PL/SQL Packages and Procedures. Superior skills in designing and developing Oracle objects such as Tables, Views, Indexes, Stored Procedures and Functions in PL/SQL, Packages in PL/SQL, Materialized Views, and Dynamic SQL.
* Analyze System Requirements to create a Technical Design with the assistance of other Sr. Developers/Architects/Tech. Leads. Have a good understanding of analytical functions with an ability to convert the business requirements to technical understanding, instantiate, iterate, and terminate the code logic to meet the user needs.
* Responsible for helping set development standards for database development within PL/SQL.
* Act as a technical resource, with a high level of technical and analytical expertise in programming languages, data communications and a strong understanding of the business operation/customer. Implement and support code migration into production.
* Contribute to a high-performing workgroup by applying interpersonal and collaboration skills to achieve corporate goals. Provide high level of attention to detail while completing multiple tasks demonstrating a commitment to quality while meeting project deadlines.
* Expertise in designing, developing Extraction, Transformation, and Load (ETL) scripts utilizing SQL, PL/SQL utilities and provide solutions to critical issues enhancing performance and productivity to the project.
* Adhere to the functional design, policies, and procedures of the project with a very good understanding of architecture and concepts of ETL and database design.
* Analysis of business requirements, preparation of source-target mapping documents, develop data load components using ETL procedures, conduct unit testing and code walkthroughs to ensure there are no missing elements, and perform integration testing.
* Usages of MS Access and Microsoft excel in data analysis and reports leveraging VBA.
* As a key PL/SQL developer, identify and define required analytics to design, develop financial routines, and assist various work streams in identifying, and resolving data irregularities, and establish management reporting processes and requisite supporting technology.
* Definitive work flow related code logic were analyzed and designed to cover all the possible scenarios for creating the various complex analytical, financial, functional and reporting capabilities that were developed and implemented using robust technologies like Oracle 9i/10g, Business Objects XI, and Hyperion Essbase 7x on Windows and UNIX operating systems.
* Construct complex SQL queries with sub-queries, inline views as per the functional needs in the Business Requirements Document (BRD). Create SQL scripts to perform unit testing financial calculations such as, Weighted-Average, Portfolio Walkforward dollar amounts, roll up of dollar amounts for Y-T-D and M-T-D calculations.
* Review the business requirements with the Analysts, Business Users and Developers to construct SQL queries for implementing the same in PL/SQL packages. An Excel Add-In would be used to generate the results in a cross-tab using Hyperion Essbase 7.x.
* Ability to create a centralized data mart that could support drill down analysis, drill through analysis, and management reporting for helps in deriving expected financial/accounting data using Oracle.
Environment: Oracle 10g, Sybase, MS Access 2000, UNIX, Crystal Reports XI, Business Objects XI, Hyperion Essbase 7.x, Oracle SQL Developer 1.0, MS Visio 2000, Rapid SQL, TOAD 8.6.1., Mercury Quality Center v8.2/9, Rational ClearQuest Web 2003

Sr. Developer/Test/Analyst - 2004 to 2006
Delta Dental Plan, Roanoke,VA
Supported IS Development team from an infrastructural architecture perspective in designing, developing, testing, and implementing Executive Information System (EIS). EIS repository provides the meta-data source for the Business Objects development life-cycle. Thus, helping the high-level executive management, marketing, underwriting and customer service departments in generating/viewing various adhoc, trend analysis and forecasting reports.

Responsibilities

* Created various logical and physical data models interacting with the business team, leads and developers using MS Visio.
* Gathered customer requirements working with the business and technical groups and converting them into simple business terms there by designing and developing fully operational Business Objects Universes. Performed query optimization and if necessary research and analyze the data model and schema design and provide architectural solutions.
* Worked closely with the Oracle DBA's in extracting and loading the fact and dimension tables with data size of approximately 6-10 GB per load.
* A reporting data mart was created to support the EIS capabilities by designing and developing Oracle PL/SQL packages, stored procedures, functions, and triggers.
* Actively participated in the Business Objects physical/logical architecture design changes, the Business Objects Universe, Reporting Application Design, development of standardized reporting applications, comprehensive design specifications with BI tools and their corresponding semantic layers.
* Articulated and documented best practices and standards for Business Objects and other Business Intelligence environments. Ensured that reporting applications comply with standards and assisted in the development of migration strategies.
* Assisted leads in marketing and demonstrated Business Intelligence applications and tools that lead to matrix teams of Business Objects Universe designers and report writers.
* Worked with team and other IS counterparts to isolate production issues quickly, using appropriate techniques to focus effort on areas of greatest concern and highest risk. Identified options and recommended the best solution.
* Created reports using Crystal Reports for mailing system where in high level of attention was paid to ensure the accuracy of the printing specifications.
* Designed and created Entity-Relationship diagrams, data models and other database related information by reverse engineering defined data dictionary, database entities, parent child relationship keys, identifying primary and referential integrity constraints, sequences, stored procedures.
* Managed entire deployment of reporting system to end-users, from development to production through a phased methodology, and process, in conjunction with internal IS staff.
* Administered business users using Supervisor and provided appropriate privileges to access BO Universe, documents, and other objects.
* Demonstrated business users with the Business Objects adhoc reports and provided comprehensive documentation to help them understand the reporting capabilities.


Environment: Oracle 9i/8.x, UNIX (SUN Solaris), Crystal Enterprise 8.x/XI, Business Objects 6.x, Erwin 4.0, MS Visio 2000, TOAD, Visual Basic 6.0 and PL/SQL Debugger tools etc.

Sr. Programmer/Analyst - 2002 to 2004
Bureau Of National Affairs, Washington, DC
Responsibilities:

* Participated in the analysis, design, and implementation of a multi-year data migration project, which involved migrating data from IBM (OS 390) legacy systems and other client-server systems to and ERP application based on Oracle 9i RDBMS. Designed and created Business Objects Universes using Designer for different business groups applying business intelligence for quality data.
* Built Dimension, Measure and Detail Business Objects by using calculations, variables, breaks, master detail, sorting, drill down, slice and dice, alerts, joins, hierarchies, ranking features to generate adhoc, automated and complex reports.
* Created aliases, contexts and short cut joins by resolving loops, cardinalities and integrity checks of the Universe before exporting. Improvised the performance of the Business Objects Universe and provided solutions to overcome intricacies related to data integrity.
* Involved in installation of WEBI module of Business Objects. Created Users and Groups for efficient report management there by assigning privileges, enabling ID's, resetting passwords and categorizing permissions to various Business Objects Reports as per departmental hierarchy.
* Applied security features of Business Objects modules at row, report, and Object and Universe level using Supervisor. Actively participated in installation and evaluation of Web Intelligence of Business Objects for future upgrades.
* Created ER diagrams, data models and other database related information by reverse engineering defined data dictionary, database entities, parent child relationship keys, identifying primary and referential integrity constraints, sequences, stored procedures, and triggers for source and target databases from source and target systems.
* Extracted data from multiple data sources and transformed data while performing data validation, data cleansing, data repair, data compare while loading the data into respective data stores.
* Designed comprehensive documentation by deriving requirements from many sources and formulating them into concise requirements. Also document all technical aspects of ETL processes, extensive SQL, PL/SQL stored procedures, Oracle packages as appropriate.
* Efforts were raised to keep data in synch across database schemas, data marts after every data migration cycle was executed end-to-end.
* Authored extensive SQL, PL/SQL stored procedures, oracle packages, ETL programs, partitioning, materialized views, functions and triggers, UNIX shell scripts and SQL*Loader programs to perform data migration while preparing Source Staging, Migration Staging and Target environments.
* UNIX shell scripts were coded to execute various Oracle processes, stored procedures, SQL/DDL scripts etc and capture all errors related to the Server and Oracle. Logged all transactions and generated exhaustive reports to identify process performance ratio, errors prioritized, and percentage of success and failure reports etc in an understandable cross-matrix layout enabling Business Intelligence staff to perform gap analysis.
* Assisted in maintaining and improving ETL processing efficiency for improved data quality, impact analysis and data validation. Ensured data availability to the departmental data marts on a requirement-demand basis.
* Defined database application specifications, authored scripts, created program specifications and SQL code, developed test plans and produced necessary documentation for the data migration project. Developed RAD applications using Visual Basic 6.0 helping data consolidation and analysis.

Environment: Oracle 9i/8.x, UNIX (SUN Solaris), IBM (OS 390) Mainframe Legacy Systems, Windows 2003 Server, Humming Bird v8.0, Host Explorer, Erwin 4.0, MS Visio 2000, TORA, TOAD, Visual Basic 6.0, Crystal Enterprise 8, Business Objects 6.x, Web Intelligence 6.0

Sr. Programmer/Analyst - 2001 to 2002
Merkle, MD
Responsibilities:

* Applied Direct Marketing strategies to a full life cycle Database Marketing Business Objects software development projects and meet their requirements of large Business Intelligence projects for clients such as ULLICO (Union Labor Life Insurance Corporation) and AEFA (American Express Financial Advisor).
* These BI projects involved some of the largest SQL Server databases in the world with large data operations in SQL Server.
* Designed and created complex Universes using Business Objects Architecture.
* Applied join conditions, cardinality checks, created aliases to resolve the loops, subdividing into contexts and cresting the Objects like Dimension, Measure and Detail. Updating the existing Universes to implement the merge/purge, data consolidation techniques exclusively designed for Merkle database Universes.
* Developed large database applications, which contained up to 1.39 million records in MS SQL Server 2000. Created Business Objects reports (Master/Detail, Cross tab, Chart templates) from Universes as the main Data Providers and writing complex queries including sub-queries. Resolved problems in Universes, Reports, Objects, Conditions and LOV's (List of values) to meet the requirements on demand.
* Generated Master/Detail summary reports depicted in a collapsed/expanded views. Customized reports by allowing end users to enter valid input in a prompt window to view corresponding data there by reducing overhead.
* Created complex queries in reporting model using cascading prompts, decode functions and other built-in Business Objects functions on demand.
* Authored stored procedures, functions in T-SQL and sub-routines in VBA as Macros for data validation checks and importantly boost SQL performance.
* Designed and created ER and Data Modeling diagrams using VISIO 2000 software.
* Created a MS Access 2000 application used to execute various Standard Report Analysis in MS SQL Server 2000 RDBMS for data analysis and process completion.
* Coded as batch processes with appropriate roll back and commit statements to ensure data integrity while capturing and logging every DML transaction committed to the SQL Server database and at the same time storing appropriate error messages used to generate Standard analysis reports for documentation.
* Designed various DTS packages using DTS Designer, performed ETL operations with DTS import and Export wizard, modify VB Script generated in the DTS packages and Column mappings to map the data as per requirements, scheduled timely job tasks and executed concurrent batch processes while monitoring their corresponding job statuses until completion on time.
* Performed SQL Server database development tasks including installation, security, Import/Export, and performance tuning by creating indexes on temp tables, and maintained the development, production and test instances of the database. Scheduled various program tasks to perform various jobs on a regular basis and created the appropriate technical documentation for the operational environment. Utilized Data warehousing, data mining, and OLAP technologies to implement all projects.
* Created Stored Procedures and Batch ETL Jobs to run on a regular basis.
* Trained End Users with the application.

Environment: MS SQL Server 2000, Windows 2000 Server, DTS, MS Visio 2000, TOAD, Visual Basic 6.0, ASP 4.0, Crystal Enterprise 7.0, Business Objects 5.x/6.x, Web Intelligence 2.5

PROFESSIONAL EXPERIENCE
Sr. Application Developer and Web Developer - 2000 to 2001
Teligent Inc, Reston
Responsibilities:

* Undertaken an existing project Document Management System (DMS) and ensured its efficient functioning by revamping the whole system and enhancing performance by tuning SQL commands.
* Maintained Corporate/Intranet Source application and resolved all trouble ticketing issues.
* Actively participated in designing and developing various small projects meeting to the requirements of various departments providing the mentioned below services in parallel to Microsoft Share Server services: Corporate Directory, Document Management, Discussion Forum and Calendar.
* Configured IIS Server, MTS and Windows NT Server to configure COM Objects and GUI interfaces.
* Authored various COM Objects, configured MTS Server and registered these Object classes in the Server enabling multi-tier architecture.
* Invoking the registered DLLs, EXE and COM classes from within the Visual Basic applications.
* Developed a project in ASP 3.0, Java Script and DHTML for Sales Team to enlist their spreadsheets, documents and other information using their corresponding login id and password in an expandable and collapsible format with a header for each node.
* Registered ASP Components in Web Server and were authored using VB 6.0 (Active X DLL). Faster access to data from ASP web pages by allowing calls to these registered components in the MTS Server.
* Involved in upgrading the existing application to Portal App using .ASP architecture and .NET frame work.
* Coded various stored procedures and extensive SQL queries in MS SQL Server 7.0
* Scripted in VB/Java Script for Client side validation.
* Different mock-up screens, GUI/front-end interfaces were designed and created using HTML 4.0 and VB. Established communication link between Client/Server using ADO 2.5 Object hierarchy.
* Extensive code development done using ADO technology and MS Outlook Express.

Environment: ASP 2.0/3.0, VB 6.0, IIS 4.0, MTS Server, Windows NT 4.0 Workstation, MS SQL Server 7.0, MS Inter Dev 6.0, HTML 4.0, Clarify (for trouble ticketing issues).

Web Application Developer - 2000 to 2000
INTERLYNX, Fairfax
Responsibilities:

* The .Com project was developed as an information site service and information web site developed for INTERLYNX. The web site is a directory of information with services catering to a niche market. This project was developed using ASP 2.0 on a Windows NT platform using MS SQL Server and IIS 4.0. Advanced Application Design, accessing Stored Procedures, Data Encryption etc were incorporated. And also Client/Server application was developed using Visual Basic 6.0 for data integrity and to maintain the information used by the web site and simultaneously have full control over the user-entered data.

Environment: IIS 4.0, Windows NT, MS SQL Server 7.0, VB 6.0, ASP 2.0, VBScript, JavaScript, HTML

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Herndon, VA | Resumes in Virginia

View other Sr. PL/SQL Developer/Crystal Reports Developer resumes, Programmer / Developer resumes