PROFESSIONAL SUMMARY

About 10 years of experience in the software industry involving Database and Business Intelligence development. Worked on full Software Development Life Cycle from Analysis, Design, Development, and Implementation of different IT Systems using agile and waterfall methodologies. Worked as senior Business Intelligence developer, Data Modeler, and Database/ETL developer for different commercial and federal government clients including DHS, and IRS.

TECHNICAL SKILLS

Languages/Tools: SQL, PL/SQL, Oracle Business Intelligence OBIEE tools, Transact SQL, Sql Loader, ERWin, Informatica ETL tools, Powercenter, Informatica B2B, Cognos Reportnet, Cognos Framework Manager, Cognos Query Studio, Cognos Power Play, Crystal Reports 8.5/9, Crystal Enterprise, SAS ETL Studio, Visio, TOAD, TOAD Data Modeler, SQL Navigator, XML

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2005/2000

Environments: Windows 7/XP/2003/2000, UNIX/Linux

PROFESSIONAL EXPERIENCE

Confidential

Software Engineer / Senior Oracle Developer

• Work for this leading data storage company involves developing database solutions using Oracle.
• Working as Senior Oracle Developer in the design, development, implementation and maintenance of database applications in Oracle 11g.
• Working as the lead data modeler/developer in designing a new normalized and optimized OLTP relational database for the company's new bug tracking system that has the capability of preserving and maintaining the data integrity and consistency.
• Designed the data loading strategy and created several db objects including Pl/Sql packages, stored procedures, and functions, to build the ETL process and migrated the legacy file based data into Oracle.
• Developed a robust solution to properly version control database releases and defined naming conventions and standards for db objects and functioned as the key person in data modeling, design, development and deployment of database releases to test and production.
• Created Sql Loader scripts to bulk load data into the staging area as part of the ETL process and loaded master data to build and maintain cardinality in a normalized db.
• Analyzed existing legacy data to understand the relationship among data points to design the future system and to ensure the data quality and prepared the data for data migration.
• Created data flow and process flow diagrams to explain the new database system.
• Created stored procedures using Oracle analytical functions to build data for metrics reports.
• Provided code reviews and alternate solutions on development paths related to Oracle.

Tools/Technologies Used:

Oracle 11g, PL/Sql, ETL, ERwin, Linux shell script, Toad, Toad Data Modeler

Confidential

Data Architect

Work for this Federal Government contracting company involved IT projects for several government clients including IRS, DHS, NLRB and OEA details and duration of all the projects for Booz Allen are listed below .

Confidential

Informatica ETL Developer

• Worked on the Electronic Fraud Detection System EFDS project as Informatica ETL Developer.
• Developed data mappings using Informatica B2B to parse large XML files that contain IRS tax return data, and created fixed width data files to load the data into the Oracle database.
• Analyzed IRS XML schema and functional requirements and defined data parsing techniques and coding rules and created documentation to support the data mapping requirements for IRS.
• Developed B2B services and Informatica workflows for the timely and optimized processing of the tax return data files, to provide data files for the automated fraud checking algorithm, to assist with the decision making process to produce the tax refund check or to flag the return as fraud and to subsequently prevent the refund check from getting mailed.
• Created Linux shells scripts to automate the data loading process and Sql Loader control files to load the data files into the Oracle staging tables.

Tools/Technologies Used:

Informatica ETL tools, Informatica B2B, Oracle 11g, PL/Sql, Linux shell script, Toad

Confidential

OBIEE Lead Developer/Oracle Data Modeler/PL/Sql Developer/Informatica Developer

• Worked on the Risk Assessment and Management Program RAMP for DHS as Lead OBIEE Developer, Oracle Data Modeler, PL/Sql Developer and Informatica ETL Developer.
• Lead the Business Intelligence reporting effort for RAMP and designed and developed the entire BI reporting functionality.
• Worked on modeling the Logical and Physical database model using Erwin.
• Modeled and developed the reporting database and created more than 50 Oracle materialized views for the optimized data retrieval and functioning of reports.
• Developed the RPD and designed several subject areas in OBIEE for various business areas.
• Worked with the government stakeholders and analyzed and defined the BI requirements, and created several reports and dashboards using the Answers tool.
• Created iBots to schedule reports to be delivered via email and to produce alerts on the dashboard.
• Presented several demos of the OBIEE reporting tool to the federal client and internal Booz Allen project team members to proide a good understanding of the tool. Worked as the subject matter expert on OBIEE for the RAMP team.
• Worked on integrating the single sign on for OBIEE with the application and administrating the OBIEE server.
• Conducted data profiling and analysis on legacy systems to analyze the data quality and gathered requirements for the data migration from legacy systems.
• Created several Informatica mappings, workflows, and Oracle PL/Sql procedures and migrated the legacy data from several sources including Oracle database, and Excel files into the new RAMP database.
• Contributed towards the authoring of the RAMP Data Management Plan DMP , Data Conversion Plan DCP , System Design Document SDD and Version Description Document VDD according to Federal Government standards.

Tools/Technologies Used:

OBIEE tools, Oracle 11g, PL/Sql, Informatica ETL tools, ERwin, Linux shell script, Toad

Confidential

OBIEE Business Intelligence Analyst

• Worked on the Next Generation Case Management System NGCM project as the OBIEE Business Intelligence Analyst, to convert several existing legacy applications.
• Interacted with the federal govt. client and analyzed all the existing legacy systems, involving Access/Sql Server Databases, and Crystal Reports, to gather the BI requirements and helped in the decision making process of how to redesign and build a new set of BI reports using OBIEE tools.
• Authored the reporting requirements document and created a presentation deck for the NLRB client to show an overview of the different features available through OBIEE.

Tools/Technologies Used: OBIEE Oracle BI tool , SQL Server 2005

Confidential

SQL Server DBA/ Database Architect

• Worked on the OEA Clearinghouse Web-based Clearinghouse System OWC project as SQL Server DBA. OWC is a web-based information and reporting application that will be used to disseminate accurate, unclassified information about planned increases and decreases at Department of Defense DoD installations affected by numerous initiatives including BRAC 05, GDP, and Grow the Force.
• Responsibilities included installing the database server software, design, develop and maintain the database for the web based data portal using SQL Server 2005.
• Designed a normalized database model using ERwin, created scripts to build the database, users and roles, backups of the database and created database objects like tables, views and stored procedures as needed by the project.
• Worked on formulating a standard data transfer format to gather data from different departments and agencies under DoD and also analyzed the sample data to design the database model and to decide the best strategy to load the data into the database.

Tools/Technologies Used: SQL Server 2005, Transact Sql, ERwin

Confidential

Oracle Developer / ETL Developer / Cognos BI Developer

• Work for this pharmaceutical company involved developing Business Intelligence applications using Oracle 9i, PL/SQL, Cognos Business Intelligence Tools, Sql Server 2000, VB.net and Crystal Reports.
• Worked as the lead developer in the design, development, implementation and maintenance of a datamart in Oracle 9i database and Business Intelligence reports using Cognos BI tools.
• Designed, created and maintained tables, constraints, relationships, views, triggers, stored procedures, packages, and materialized views in Oracle as part of the design and development of the datamart.
• This newly developed datamart served as the enterprise wide repository for storing all the clinical trial data, needed for FDA submission, received from different outside vendors hosting the clinical trial applications and this datamart also serves as the data source for the new set of BI reports developed using Cognos BI tools.
• Successfully implemented a project for migrating existing Crystal Reports to Cognos and developed several reports and dashboards using Cognos BI tools for different IT applications and Clinical Research applications.
• Designed and developed the BI framework using Cognos Framework manager for the reporting application.
• Worked with the end users to gather and analyze their BI reporting needs and assisted in testing and documenting the report migration process.
• Designed and developed the ETL process using Oracle PL/Sql, SAS ETL Studio, and Sql Loader, to Extract, Transform and Load data into the Oracle datamart from several source systems including Oracle/Sql Server db, XML and Excel data files.
• Developed Oracle and Java components to parse XML data to load into the datamart.
• Used Sql Loader to bulk load flat files into Oracle database.
• Created windows batch scripts and FTP scripts to automate and schedule the file transfer and data loading process.
• Standardized the data transfer specifications for collecting patient data from outside clinical trial vendors for the datamart and worked as the main point of contact.
• Analyzed multiple clinical trial data sources to identify any potential data quality issues that might arise later on in the project and conducted detailed source data analysis to determine the consistency and accuracy of the data available from multiple sources.
• Developed Oracle views, functions and stored procedures for the popular Clinical trial management application Impact CTMS .
• Developed and published reports using Crystal Reports 9 and Crystal Enterprise.
• Automated data transfer process using VB.net to transfer data to and from Sql Server based Electronic Data Capture EDC system and Oracle based Impact CTMS system and created web services program to integrate the Site Management Portal Interface with Impact system.

Tools/Technologies Used:

Oracle 9i, PL/SQL, Sql Plus, Sql Loader, TOAD, Cognos Reportnet 1.1, Cognos 8, Cognos Framework

Manager, Cognos Query Studio, SQL Server 2000, Transact Sql, VB.net, XML, SAS ETL Studio,