SARBANI BHATTACHARYA

703-***-****

Alexandria, VA

adwqav@r.postjobfree.com

Active Secret Clearance

Summary

Apply extensive years of overall technical experience, strong software development and project leadership by transforming, leading and contributing to a software development team in the Washington DC metropolitan area utilizing lessons learned from a high impact rapid release cycle environment

Business Intelligence (BI)/Data Warehouse (DW) Management Consultant with extensive experience in leading, designing, implementing, migration, and rollout of BI Apps analytical applications. Full life cycle implementation experience using Oracle e-Business Suite (EBS), PeopleSoft Financial, Oracle Business Intelligence (OBIEE), BI Apps OBIA, SAP Business Objects(BODS), Informatica, Oracle Data Integrator (ODI), IBM Cognos Analytics BI, IBM InfoSphere Data Stage. Expertise includes leading Data Warehouse implementation, logical and physical data model design, data architecture, multi-dimensional data modelling, star and snowflake schema modelling, ETL load plan design and OLAP.

PROFESSIONAL SKILLS

•Multiple major implementations serving as Technical/Project/Team Lead for projects Integrating EBS R12(Asset Management, Financial, Inventory and Bill of Materials) with online service scheduling and third-party vendor applications including front end and back end modification

•Extensive experience in data modeling using ER Studio/Erwin

•End-to-end full life cycle software development using technical project management including specifications, QA process, release management, implementation and reporting with iterative and incremental software development based on SEI/CMMI standards.

•Excellent analytical skills allowing for thorough consideration of all aspects associated with project implementation(s) including interaction with the end user through vice presidents in a matrix team environment allowing for effective translation of customer requirements into functional technical specifications.

•Experience with application database design and database platforms including 12C Industry verticals including insurance, retail, call center, health care and federal government

•Lead off shore and on shore development team including on boarding, knowledge transfer and daily touch point calls

•Team player and Excellent communication skills with Business Teams, End Users and Training Teams

Education:

B.S (Computer Science), Mary Washington College. Fredericksburg, Virginia 1995

Certification: Certified Scrum Master (ScrumAlliance)

CDMP Certification is in process. (Udemy)

SOFTWARE SKILLS

Enterprise Business Systems

EBS (Oracle E-Business Suite Release 11.5.10 CRM Suite of Applications /Oracle E-Business Suite 11i/R12.1.3)

•SAP BODS

•BI Publisher

•OBIEE

•Core Contracts (INVENTORY and BOM)

•EAM

•Service Contracts

•Depot Repair

•TCA (Oracle Trading Community Architecture)

•XML Publisher

•Web ADI

Development Tools

•Oracle Application Object Library

•Oracle System Administrator

•Oracle Forms R12 Reports R12

•Oracle Workflow Builder

•SqlDeveloper

•TOAD

•WinSCP/PuTTy

•Eclipse/STS

•GitHub

•AWS Cloud

Database, Modeling & Performance

•Oracle 12 C

•ODBC, JDBC

•Rational Rose

•ERWin

•Explain Plan

•TKProf

•PRISM6.5

Business Tools

•MS Office

•MS Excel

•MS Project 2003

•MS Visio

•MS Access

Development Methodology

•Agile

•Oracle AIM 3.1

Release Management

•Sharepoint

•QuickBase

•JIRA

•ALM

•Visual Source Safe

•Perforce

•Subversion

•PVCS

•Dimesion

Programming Languages

•PL/SQL, SQL

•Pro*C, C, C++

•JavaScript, CSS, XML, JSP, HTML, DHTML

Unix Shell scripting

Experience:

09/20– Present Sr.Data Modeler/IT Consultant (RighIT Solutions)

DOD iPPSA

Overview Army’s legacy systems and databases are stove-piped and (mostly) do not talk to each other. The Integrated Personnel and Pay System Army (IPPS-A) will modernize Army Human Resources (HR) and develop a system for managing talent, reduce IT and military pay costs, and improve Soldiers’ lives through transparency and mobile capabilities. IPPS-A is innovative and represents a revolutionary leap forward in Army HR and IT.

Responsibilities

Collaborate with business stakeholders to develop and document policies and procedures surrounding Data Governance

Determine the rules and workflows that define and monitor the process of creating, modifying, storing and deleting data

Worked on backend packages, procedures, triggers to load data into staging tables and data warehousing.

Developed backend packages using complex pl/sql to load huge volume of data using Oracle 19C

Integrated data from any format into Autonomous Data Warehouse. Used its data transformation tool i.e. Data Transform, Data Preparation.

Used Erwin to create high quality data models that enable DoD to organize and standardize data infrastructure and produced detail documentation.

Worked on conceptual and logical data modeling so it can be easily shared with stakeholders to explain and can be enhanced

Developed physical data modeling using fact and dimension tables

Peoplesoft HRMS modules used for HR related activities for entire Army and also talent Management, CRM.

Developed ETL backend packages which collects data from various sources and optimized data

Monitored the business rules had applied to the ETL process.

Developed process to clean Anomaly data which is part of ETL using pl/sql.

Developed dashboards using OBIEE to show the results with the scheduled data changes from different sources

Documented all the requirements and validated with users as part of UAT

04/19– 08/20 Sr.IT Consultant/BI Developer (OnPoint Consulting, Inc)

DOS CA/CST/NSDD

Overview OCS Project has various modules (ARREST, ABDUCTION, etc.) Data had been sent from different posts which had been used to developed OCS Global reports.

Responsibilities

Responsibilities

Worked on ETL extensively to load data into SAP/CRM from various source systems including Flat Files, Legacy Systems using SAP data services (BODS).

Used data integration transform Table comparison with Map operation in SAP BODS. Which handles Slowly Changing Dimensions (SCD) scenarios, duplicate data issue.

Used the Case Transform to branch logic in data flows by consolidating case or decision-making logic in one transform. Also, run the job to load data as per Case transform logic.

•Extensive experience in data warehousing using strong knowledge of entity-relationship concepts and dimensional modeling (Star and Snowflake schema)

•Reverse engineering old models in Oracle to ER studio for updates of the model.

•Developed packages using complex pl/sql to load huge volume of data.

•Developed Views and Materialized Views also using pl/sql for robust reporting.

•Development/enhance BODS jobs. Monitored Daily BODI ETL schedules.

•Implemented new error handling methods with common workflow for standardization.

•Developed ETL components for bring in missing data on targets from source

• Implemented Data Provisioning for HANA using Data services to load billions of rows.

• Experience in creating stored procedures in HANA.

Experience in using HANA studio for creating Calculation view.

• Implemented new error handling methods with common workflow for standardization.

•Involved in Optimizing performance of processes and queries.

•Developed testing docs for QA and users to understand the requirements. Engaged with users to resolve any issue.

02/18– 4/19 Sr. IT Consultant

DoD ARMY DPAP (RighIT Solutions)

Overview This project is about External Source Systems push CSV and XML data files over to ALTESS SFTP file server every day. GPC(Govt. Purcahse Card) ETL process extracts, parses, transforms, and load files into PBIS database. Records from the input daily transaction files, variance files and scoring files temporarily stored into an Operational Data Store (ODS) first. These records compared against each other. All matched records will be moved to Data Warehouse. Unmatched records will be moved to variance repository. The unmatched GPC records in the ODS for a predetermined number of days and looked at daily against new records loaded until that point that that period closes and afterwards move into variance repository.

Responsibilities

•Handing the ETL process for ingesting CSV files, utilizes external tables for mapping the CSV fields to Oracle Staging tables, processes the CSV files into staging tables, then transforms the data, compares the data to identify daily variances and then loads matched/unmatched data into separate GPC repository tables. Afterwards, data-marts built on top these repository tables to get the consolidated data out to report and data consumers.

•Used web services to connect with different resources.

•Developed packages using pl/sql with modularity for the ETL process.

•Applied business rules to manipulate data in the staging and data warehouse schemas.

•Worked on performance issues to run the ETL process efficiently.

•Developed stored procedure using pl/sql

•Developed shell scripts to run the job.

•Monitor the scheduler job. Automated the status of the job via email.

•Worked heavily on design and technical documents.

•Used Teradata for another module for ETL process.

08/16– 01/18 Sr. BI Consultant,

Navy Shipyard at Maine, Information Gateways (Accenture)

Overview The U.S. Navy has four shipyards (Portsmouth, Norfolk, Puget Sound and Pearl Harbor) that refit ships between deployment. The process of refitting a ship is complex, time consuming, expensive and potentially life threatening (if done wrong). The Navy treats refitting a ship similar to NASA building/launching a space shuttle.

eTWD application (electronic technical working document) is a technical working document is a complete package of all the paperwork necessary to perform work during a refit.

Responsibilities

•As a tech lead assisted in requirements gathering and technical planning to design solutions that meet client (US NAVY) needs and follow the Navy protocols. Worked with team to deliver tasks in timely manner. Worked on gap analysis proactively that helped tasks to be finished and delivered to client as forecasted.

•Adhered to best practices for design and implementation of BI requirements as established by the client.

•Used custom Oracle forms. Used pl/sql pacakges.

•Used BI Publisher for various reports. Used complex queries to develop data models for rtf files. Created rtf files in Microsoft word. Build the xml files thorough data model to load data in report.

•Managed OBIEE caching for efficient report generation.

•Created custom reports, dashboard, enhanced UI features.

•Worked on the development of the business intelligence application using Oracle OBIEE 10g, OWB, SQL, PL/SQL, ODI, Oracle10g DB and Red Hat Enterprise Linux 5 platform.

•Regularly communicate status on progress, problems and plans to

•leadership; adapt to changes in the project plan and customer requirements

•Created and modified OBIEE physical, business and presentation layer components.

•Optimized OBIEE report performance.

•Used EAM(Asset Management in EBS R12) modules architecture to build the data model. Used various APIs to capture data in interface tables

•Data had been passed through SOA messages. Broke down SOA messages and expose them in DB packages while validating business rules so it can be populated in customs and EAM related tables.

•integrity. Passing errors to SOA is important part of the development. Handles exception scenarios properly so it can be showed in user friendly error messages

•Architected solutions, designed and implemented packages, stored procedures. Developed and maintained functional documents for new requirements and existing. Documents have all mapping describes as per EBS architecture.

•Created clean, well-documented, efficient, and standards-compliant code to optimize the performance.

•Used Shaprepoints to track on updates for the project. All current versions of various files (Data model, Unit Test Documents, Test Design documents.) had been saved there.

4/15– 08/16 Sr. IT Consultant, TekSystems (International monetary Fund) Washington, DC

Overview: IMF does not have an integrated application to manage

activities related to agreements and contributions to the Fund or Fund-operated Trusts.

While the idea of developing a dedicated application to track agreements and contributions has been considered since 2003, when FIN moved to a new suite of applications called iFIN, the dynamic nature of the Fund’s operations resulted in shifted priorities postponing the development of a viable tool. Post recent resource mobilization efforts, the Fund’s financing structure is relatively clearer, but increasingly complex. Given these conditions, FIN determined that it is timely and necessary to develop a robust and integrated application that will provide.

Financial Contributions and Agreements Tool(FCAT) is the new tool had been developed

Responsibilities

•Designed and Developed ORACLE SQL/PLSQL programs to support TGSIFMFS team’s ETL activities, including: data analysis, data preparation, data cleansing, data quality analysis, data lineage, data standardization, data migration and transformation.

•Supported and developed FCAT application development in .NET environment. Used odp.net for fetching data. Developed various packages and database objects to optimize the application.

•Developed materialized views, stored procedures to support SAP BO tool. Tune the query to enhance the performance, so report can be easily pulled up with graphs.

•Maintained various MFS applications viz., What if, LPS, External web (member financial pages) and Secure web that accessed the IFIN data warehouse, and participated in the logical and physical design of database tables, views, stored procedures, and triggers.

5/13 – 3/15 Sr. DBA/Sr. Oracle Developer, Sevatec (The Bureau of Alcohol, Tobacco, Firearms and Explosives (ATF)) Falls Church, VA

Overview: The eTrace system, which is critical to ATF’s mission, is a web-based application that provides designated law enforcement agencies with a portal to the Firearms Tracing System database. The eTrace portal provides real-time capabilities to electronically submit firearm trace requests, monitor the progress of traces, retrieve completed trace results, and query firearm trace-related data that resides in the Firearms Tracing System database. The primary mission of the National Tracing Center (NTC) is to trace firearms recovered from crime scenes or criminal suspects in the United States.

Responsibilities

•Worked as part of development team to perform the database tasks related to application enhancements, such as creating new tables and/or columns, writing and tuning PL/SQL, SQL scripts and stored procedure, procedure triggers, audit trail issues and debugging production database issues.

•Builds and unit tests database scripts and works with Configuration Management to ensure the builds are successfully and accurately promoted to QA/UAT environment for testing and then to the production environment using Agile Software Development practices.

•Used EAM modules to track firearms. Track the Firearm till it dispenses. All associated asset information such as asset details, bill of material, work orders, asset activities had been used.service requests, and work order history for those assets

•Worked with clients to gather requirements and responsible for designing and building Oracle database that comply with existing database standards and established design patterns.

•Monitored the database for performance issues.

•Performed complex Oracle database administration assignments essential to the production and development of Database Management Systems (DBMS) applications.

•Demonstrated the ability to interface equally well with various levels of Technical personnel, web portal developers, Subject Matter Experts (SMEs), and senior level stakeholders as required.

•Implemented all assigned patches for all supported environments within assigned timeframes to mitigate all security vulnerability alerts

DBA/Sr. IT Specialist, CRGT Inc. (National Park Services) Herndon, VA

Overview: The National Park Service (NPS) will be using the new Financial and Business Management System (FBMS). The accounting system Administrative Finance System 3 (AFS 3) will be converted to AFS 4. Oracle 10g and Oracle Forms/Report 10g is used for various financial modules for 5000 users.

Responsibilities

•Lead this very massive effort to convert all the forms, reports, supporting

database objects and load routines in AFS.

•Analyzed old data structure and developed the protocol and format for new development.

•Lead Quality Assurance team to prepare test cases and review test data

•to validate specific requirements.

•Involved in UAT process.

•Responsible for Change Management Requests and version control

Build Unit Test documents to validate business rules and data

•process.

•Gathered business requirement from various NPS centers.

•Worked on ETL to migrate data from legacy system.

Monitored the performance on Database and worked on performance tuning.

06/05–1/12 Technical Team Lead, N.E.W Corporation Sterling, VA

Overview: NEW Corporation operates predominantly in the customer service industry providing a broad range of customer service products. Oracle CRM Contact Center module is utilized by more than 6000 Customer Support Representative users. This module customizes product protection, customer assistance and related services for the retail, financial and operational outsourcing markets, designing extended service, guaranteed replacement and physical damage plans for its customers.

Responsibilities

•Technical Team Leadership

•Lead design, development and implementation of Oracle CRM module modifications, enhancements and integration.

•Lead the conversion from legacy to oracle. TCA was the major part of the data conversion form legacy to Oracle CRM. There were few organization type clients. They had buy products in bulk but their point of contact will same but for different locations. So heavily worked on mapping on TCA to setup the one account for specific organization but have different site and location. Using hz-parties, locations, sites tables.

•Technical lead in charge of new enhancement request development and ongoing production support/maintenance of Service Contracts and Service Request applications that are part of Oracle’s CRM suite of 11i Applications. Used inventory and BOM for all the warranty sold. Inventory had been mapped to BOM as component-of.

•Also involved in financial modules included General Ledgers, Payables, Receivables and inventory. To determine the warranty price and the sale transaction.

•Used AP responsibilities to create invoices to link to GL.

•Worked on GL, AP and AR tables enabling flexfield attributes, segments.

•Lead Quality Assurance team to prepare test cases and review test data to validate specific requirements.

•Perform code reviews, make performance recommendations, and provide test case scenarios.

•Communication

Advise business team on the system impact and technical difficulties

•Based on review of business requirements.

•Create System Specification and Technical Design Documents.

•Gather business requirements

•Lead and mentor off shore team daily to update requirement changes, review code in a structured way and give timely feedback.

•Development

• Design, develop, lead and implement customized Online Dispatching application integrating with Oracle 11.5.10 CRM Applications with webMethods and WSDL.

•Create custom interfaces to Oracle Applications and web services. Build enhancements to the CRM applications writing packages

(procedures and functions).

•Modified Existing Discoverer reports and created new discoverer reports as part of Archiving project.

•Writing a custom Workflow process to auto adjudicate and process the claims.

•Configuration CRM configuration, Service Requests and Tasks, creating and modifying descriptive flex fields and value sets, creating and assigning responsibilities, menus, registering forms, reports, functions an concurrent programs.

•Module configuration, setting profile options, list of values

10/03-05/05 Sr. Oracle Developer & Technical Analyst, Westat (NIH)

Rockville, MD

Overview: The Cancer Trials Support Unit (CTSU) is a project sponsored by the National Cancer Institute (NCI) for the support of a national network of physicians to participate in NCI-sponsored Phase III cancer treatment trials. The majority of these trials are sponsored by the adult Cooperative Clinical Trials Groups.

CTSU Objectives:

•Increase physician and patient access to NCI-sponsored clinical trials

•Streamline and standardize trial data collection and reporting

Reduce regulatory/administrative burden on investigators participating in NCI-sponsored Cooperative Group clinical trials (phases 1-3)

Responsibilities

•Developed the Pre-Enrollment Certification PEC form to facilitate CTSU patient registrars to validate site/investigator eligibility, add/link the contact person for the accrual and enroll patients for any study, in the CTSU menu.

•Used Designer 6i and Oracle Forms 6i to develop the form using Oracle8i database

•Enrollment Validation Rules If one of the validation rules does not pass, then the specified error text will be included in the disapproval comments.

•This was done via PL/SQL packages and triggers

•Various reports were created using Oracle Reports to report on patient enrollment, clinical data management and investigator/site roster management

•Developed Technical Design Document based on NCI guidelines and regulations.

•Periodically met users from NCI to make the application robust.

Managed the project schedule and mentor junior developer.

07/95-10/03 Oracle Developer, US Customs Springfield, VA

Overview:

•Responsible for developing and implementing Oracle form used by US Custom boarder officer to import/export commodities.

•Designed user friendly forms using Designer 6i and Developer 6i based on sensitive data.

•Gathered requirements and Developed Technical Design Document

•Developed complex system in a configuration-managed environment

•Validated QA test data

prepared documentation for deployment under US Customs guidelines

Contact this candidate