SUMMARY:

• A Data architect/analyst with 8 years of experience in various RDMBS applications, MDM ( Confidential Master Data Management), ETL Applications, Reporting tools and Business Analysis.
• Extensive experience in Data Warehouse/Data mart concepts and knowledge of data modeling for OLAP & OLTP systems. Design, analysis & implementation; representation of logical and physical data models in ERWIN and defining the relationships between the entities.
• Strong understanding of relational database design concepts such as Slowly Changing Dimensions - SCD 1 / SCD 2 and Star/Snowflake schema architecture in depth knowledge of OLAP solutions.
• Worked extensively on the Confidential Master Data Management (MDM) that enables the business user to bring vital data together into an integrated, consistent and accessible central set.
• Experienced with Informatica Power Center - Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Good experience in end-to-end ETL specifications/design, development and testing.
• Professional experience in designing and developing SAP Business Objects & Business Intelligence reporting and have worked with reporting teams that use IBM Cogons as a reporting application.
• Experienced in gathering and reviewing business requirements and translating BRD using MS office.
• Good knowledge of Agile methodology and Scrum sprint process and experienced in working with large teams that follow enterprise performance life cycle (EPLC) principles

TECHNICAL SKILLS:

RDBMS Applications: Confidential MDM | Confidential V2R5/13.0 | Confidential BTEQ, winddi, SQL Assistant | Confidential Utilities | Aprimo CIM, Oracle 10g, Toad for Oracle 11

ETL Applications: Informatica Power Centre 8.x

Reporting Applications: SAP Business Objects (XI 3.1), SAP Business Intelligence 4.0 IBM Cognos 8, IBM Cognos 10

Languages & Frameworks: JAVA, JavaScript, PL SQL, HTML, DHTML, CSS, Ajax, JDBC, Confidential PGL, MySQL

Tools: Eclipse, Weblogic, Tomcat, Erwin, MS Visio

Database: ER Design, Data warehousing and Integration, ETL Process, Stored Processes

OS: Windows, UNIX, DOSBug/Defect tracking HPQC, HPSM, JIRA, Tortoise SVN.

Big Data: Cloudera (Hadoop), Pig, Oozie, Hive, Map - Reduce transformation.

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles, CA

Data Architect

Responsibilities:

• Designed a logical star schema for the new bank based on the vendor’s source extract files (input files to the data warehouse)
• Understood the business requirements to factor in the key metrics/counts in the facts for these data marts.
• Built 3 data marts from the scratch (Customer DM, Account DM, and Transaction DM) and integrated 2 data marts (existing compliance DMs) with the new data.
• Developed ETL source - target specs for the dimensional data warehouse for the flow of data from the source (vendor/enterprise data hub) to target (dimensional data warehouse).
• Created a logical ERWIN diagram for the team to better understand the design and for the ETL team to code the mapping in Informatica.
• Created process flow and data flow diagrams using MS Visio for the data marts from source files to the target reporting facts and dimensions.
• Supported Business Objects Universe for data warehouse analytical reporting
• Interacted with business users and other stakeholders to determine expected business reporting requirements and ensured the data warehouse answers all of the requirements.
• Created DDL scripts for the designed data marts for Oracle database.
• Optimized DDL creation (bitmap index, partition - range and hash, no validate foreign keys and column index) for all of the data marts that were designed.
• Responsibilities also included creation and execution of the unit test scripts to ensure the data warehouse is build - to - last the growing data that would be stored in the respective data marts and the efficient retrieval of this large data set.
• Supported & guided QE teams through the SIT and UAT process of the project.
• As a data analyst, was responsible to understand the design of existing data marts (transactional/accounts/balances/customer data marts) to ensure the data processing met the business requirements that were presented as Business requirement documents and Functional design documents. This understanding was vital to sustain proper data quality throughout the project.
• Created Detail design document as per bank’s guidelines for the DDW (dimensional data warehouse) team and ensured that all of the business requirements were met.
• Designed data flow diagrams for the tracks that require data processing.
• Created multiple sessions with the corporate data warehouse/enterprise data warehouse teams to understand the bank’s operational data systems that have evolved over a span of 2 decades.
• Built an overall Visio process flow diagram to establish a clear understanding of the complex data movement involved in the project.
• Developed ETL source - target specs for the processing/staging tables in the data warehouse for the flow of data from the source (multiple data warehouse instances/enterprise data hub) to target (reporting data warehouse).
• Created complex and efficient DDLs for the tables with partitioning and indexes in Oracle for the optimum performance.
• Designed SQL queries to extract data from various sources using the right indexes and partitions that were defined in the source.

Environment: Oracle, ERWIN, Visio, Toad for Oracle, UNIX (Shell scripts), Windows, SAP Business Objects 4.2, Informatica, MS Visio, JIRA, HPQC, HPSM, SharePoint.

Confidential, Richmond, VA

Sr. DW Reports Analyst

Responsibilities:

• Based on requirements, developed Source-To-Target mapping document with business rules and also developed ETL specification document. Created tables, views in Confidential, according to the requirements.
• Designing, creating and tuning physical database objects (tables, views, indexes, PPI, UPI, NUPI, and USI) to support normalized and dimensional models. Maintain the referential integrity of the database
• Created proper Primary Index taking into consideration of both planned access of data and even distribution of data across all the available AMPS
• Incorporated scheduling using flags to run ETL batch processes.
• Handled migration of ETL codes from development to test to production.
• Unit test ETL mapping codes and validated the result set data by writing SQL queries on Oracle database.
• Developed Functional Design Documents and Technical Design document and documented validation rules, error handling and test strategy of the maps.
• Created test cases to unit test the code prior to the handover process to QA.
• Helped the team in developing Standard Reports, List Reports, Cross-tab Reports, Charts, Drill through Reports and Master Detail Reports Using Report Studio.

Environment: Confidential 12.0, Informatica, Confidential SQL Assistant, BTEQ, MLOAD, FLOAD, FASTEXPORT, UNIX (Shell scripts), Windows, Cognos Business Suite (Framework Manager, Report Studio).

Confidential, IL

Sr. DW BI Analyst/Developer

Responsibilities:

• Facilitated sessions to determine data rules and conducted Logical Data Modeling (LDM) and Physical Data Modeling (PDM).
• Responsible for analyzing the business requirement Document & converting into functional specific document.
• Participated in data analysis and data dictionary and metadata management - Collaborating with business analysts, ETL developers, data quality analysts and database administrators.
• Developed relational model design, dimensional modeling in Data warehouse (DWH). Validated and maintained the enterprise-wide logical data model for Data Staging Area.
• Participated SCRUM sessions to develop Extended Logical Models and Physical Models for Confidential .
• Created DDL scripts including Data Quality checks and Base View Scripts. Created proper UPI&NUPI after going through Extended Logical Models. Created USI&NUSI if necessary after looking at the usage patterns and performance issues.
• Multiload, BTEQ, Created & Modified databases, performed capacity planning, allocated space, granted rights for all objects within databases, etc.
• Created proper Confidential Primary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS.

Environment: Confidential 12.0, Confidential SQL Assistant, BTEQ, MLOAD, FLOAD, FASTEXPORT, UNIX, Windows, Shell scripts, Business Objects universe, Business Objects Web Intelligence.

Confidential

DB/MDM Software Engineer

Responsibilities:

• Primarily worked on the Confidential Master data Management (MDM) that enables the business user to bring vital data together into an integrated, consistent and accessible central set.
• Hands on experience in developing tools enabling clients’ ETL processes/mappings in MDM. Used stages for the data transformations, conversions, mappings and business rules for data within each stage.
• Designed and implemented the Confidential MDM’s (Master data manager) leading ETL feature LRDM (Lookup reference data management) that synchronizes disparate values in the data warehouse and creates a tightly controlled, workflow-driven data stewardship environment for ongoing management of lookup reference data. Awarded an IDR upon the completion of LRDM and integrating it into the MDM.
• Worked extensively on data modeling of logical data models and correlating with the physical database of the MDM ecosystem; helping create custom workflows which navigates the data through various stages.
• Worked on integration of Aprimo Marketing Studio, knowledge on Aprimo’s some of the features including Activity management, Campaign management, Reporting and analysis.
• Planned, designed, implemented and maintained the UPGRADE scripts for every MDM release which has served each and every customer by allowing them to effortlessly upgrade their current version of MDM to the latest version without suffering any data loss.
• Created a process of publishing the data in the Confidential database in various forms such as excel/CSV, publishing tables. Implemented a scheduler for publishing this data in defined intervals of time. IDR was awarded for the implementation of the publishing module in the MDM.
• Enhanced various user interfaces for the modules in MDM such as user security, user navigation, favorite creation. These are the modules that let the business user create various user groups/roles/activities for its users and maintain a high level of authentication and authorization amongst them
• Ability to transform customer requirements into workable design and technical definitions. Created numerous workflows and data flows for the MDM modules.
• Integrated Ajax in the MDM Web UI screens that would allow asynchronous data calls and enable robust responses from the server. These Ajax implementations were a base to many of the modules such as matching/mapping/LRDM/CRDM within the product. They were used across the product by the other members of the team, allowing them to enhance their own UI screens have an asynchronous calls.
• Worked as a Confidential core R&D team member contributing towards conceptualizing and providing POCs for the pre sales team. Coordinated with the services team to create customized UIs for various Confidential clients.
• Overall involvement in the Software Development Lifecycle (SDLC) - Gathering requirements from the product management team and creating a scope document and POC, high level design of the requirement, detailed technical design with the team, coding of the modules, creating unit test cases by interacting with the QA team and pre sales team, integrating with the product, deployment and creating adequate upgrade scripts for the customer

Environment: Confidential 13.0, Confidential SQL Assistant, Confidential Manager, Confidential Master Data Manager BTEQ, TPT, MLOAD, FLOAD, FASTEXPORT, Aprimo Marketing Studio, UNIX, UNIX Shell Scripts, Erwin, JIRA, Tortoise SVN.

Confidential

Internship/Software Engineer

Responsibilities:

• Responsibilities included: Technical system design, initiating daily status calls, sending daily status emails, unit testing and documentation of the project
• Developed the various transformations in Informatica which performed multiple complex business calculations on the data to generate summary details of the data that was loaded from different sources.
• Worked with Business Analyst to gather functionalities to for the development of data modeling and new mappings and workflows using Informatica.
• Developed standard reports using Web-Intelligence and scheduled report generation.
• Preparation of Unit test cases and documented all of the reports for the Universes and web reports.

Environment: Informatica, Oracle 8i, PL/SQL, TOAD, Windows XP, SAP Business Objects, Windows