OBJECTIVE:

It’s a data world and as a data enthusiast, I aspire for an opportunity in DW and BI arena to provide efficient solutions for accurate decision support.

SUMMARY:

• Over 8+years in all aspects of Data Warehousing System Development Lifecycles (SDLC) including, requirement gathering, data modeling, development, Testing, deployment, maintenance, and enhancements using Reporting & ETL tools - OBIEE, Oracle BI Apps, Informatica etc.
• Areas of Experience include Business Analysis, Development, Testing, Project Management, and Operations using Agile, Waterfall & Tollgate Iterative development methodologies.
• Proficient in developing OBIEE Repository (RPD) including the Physical, BMM, and Presentation Layers and Developing Custom User Interface Dashboards, Answers and Alerts for various levels of users
• Knowledge on Bill Inman and Ralph Kimball methodologies in Data Warehouse implementation.
• Implemented data lineage reports as part of yearly Federal audit requirements to substantiate the quality of data elements/quality in the Warehouse.
• Formulated cost-effective strategies as part of Data Capacity analysis according to different subject matters/operational policies in the firm.
• Designed Data warehouse including star schema design, DW capacity planning, MySQL performance and tuning. Implemented Orders and Points DW using star schema, Orders and Points Business domain using Pentaho Metadata.
• Developed Pentaho jobs and transformations to transfer data from heterogeneous database (Oracle, SQL server, MySQL) & different files format (Text File, CSV, Spreadsheet, xml).
• Strong knowledge in Extraction, Transformation, Conforming and Loading (ETL) techniques and applied various ETL modules namely, Operation Data Stores (ODS), Change Data Capture (CDC) and Slowly Changing Dimensions (SCD- Type1, Type2, and Type3).
• Researched and Identified Dimensions, Descriptive attributes, Facts in the legacy data set and Engineered Dimensional modes (Star and Snowflake schemas) with Data modeling group using Erwin.
• Designed ETL mappings using various DI tools, viz., Alteryx, Informatica and Pentaho.
• Designed Dashboards and various types of Reports using Tableau and OBIEE features according to the business needs.
• Enhanced and Instituted standards to maintain Metadata layer to capture the ETL generated, Operational and Technical Metadata in the Warehouse.
• Extensively worked on Performance Tuning on Relational Database, SQL’s and Data Integration mappings and measured performance indicators on the ETL and Infrastructure side.
• Orchestrated change request/management tasks and end to end application life cycle in DW using different quality managements tools.
• Expertise in performance tuning, fine-tuning SQL queries for improved performance and Query Optimization.
• Worked on all kinds of dynamic SQL formats, connectivity and exception handling.
• Review project components for adherence to standards (Project plans, requirements documents, design documents, test plans and other work products as the parts of the SDLC)
• Experience in development, testing, production support and maintenance of projects.
• Creating and executing SQL queries to perform data Integrity testing on an Oracle database to validate and test data using TOAD.
• Experience in working in AGILE environment, and ability to work in pressurized environment with tight deadlines. Formulated cost-effective strategies as part of Data Capacity analysis according to different subject matters/operational policies in the firm.
• Produced Businesses intelligence dashboards using OBIEE Answers, Dashboards, Delivers, BI etc. to produce project wise Reports for top management reporting. PMO quality tracker extracts data from oracle database and produces portfolio intelligence dashboards.
• Orchestrated change request/management tasks and end-to-end application life cycle using different quality management’s tools.

TECHNICAL EXPERTISE

BI Tools: OBIEE 11x, OBIA, Tableau.

Database: Oracle 10g & 11g, MS SQL Server, DB2, TOAD, MYSQL.

ETL: ODI, DAC, Informatica, Alteryx

Languages: PL/SQL, MS SQL, Unix Shell Scripting.

Automation: SVN, GITHUB.

Tools: New Relic, JIRA, GIT, Putty, AWS Console, DB Visualizer, Eclipse, Excel.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr.Data Analyst

Tools: Sql Server 2016, Vertica 7.2X, SSIS, JASPERSOFT

• CCAR is federal report that is developed via ALMIS where ALMIS acts as
• Data repository or Data warehouse for aggregating Bank’s balance sheet.
• Feeds data to downstream analytical applications for modeling, business analytics and risk calculations
• For generating Regulatory/Fed reports as well as internal senior management reports.
• For converting the CCAR reports to be sourced from ALMIS, studied and analyzed each segment of the report i.e. Loans, Securities, and Deposits etc.
• Coordinated with the business team to understand the Reporting requirements and documented the same in the BRD.
• Coordinated with various teams to understand the logic behind each segment of the report and created the same logic using ALMIS attributes
• Architect and design the CCAR Datamarts.
• Designed the CCAR reports using the ALMIS front end.
• Designed and built a front end system where a user can make adjustments to the balances At a GL level.
• Worked with the data team to design, implement, and test and integrate the data flows for the reports.
• Created workflows using the in—house EDS (electronic data service) workflow tool.
• Created a comparison procedure where it lists out all the differences between any two tables both structural and data level differences.
• Coordinated with the development team to source data from Vertica into ALMIS.
• Architect and design the data marts to store the data brought in from Vertica.
• Documented and tracked ever step and process using JIRA and BRD’s & FRD’s.

Sr.Data Analyst

Tools: Oracle Applications 11i/R12 General Ledger, Accounts Payables, Accounts Receivable, Inventory, Purchasing, Fixed Assets OBIEE 11.1.1.7.1 , Oracle BI Apps 7.9.6.4,BI Publisher, Peoplesoft, Informatica 9.1, DAC 10.1.3.4.1 , Oracle 11g, DB2, SQL Server, TOAD, UNIX, Business Objects, Crystal Reports, Microstrategy, Solaris, JIRA, Win XP Professional, SVN, HP ALM.

• Studied and Analyzed different source financial instruments for Regulatory reporting needs for Basel II & Basel III.
• Constructed General Ledger Reconciliation reports model, Manual Adjustments and Pseudo Instrument reports to substantiate the exposures posted by different legacy systems against Finance Ledger Model using Tableau.
• Performed the role of data analyst for Basel classification and Risk Weighted Assets (RWA) in Credit Risk Warehouse implementation.
• Created database tables, Indexes, triggers by writing SQL queries as per the database change request by the business.
• Created stored procedures, functions, and packages by writing SQL queries based on the client requirement as per the day to day updating of business logic.
• Worked on optimizing large complicated SQL statements to meet the client requirements.
• Created large complex SQL queries such as to pull the formulary data to generate tier level data of various kinds of formulary and benefit lists.
• Created SQL queries to facilitate the user to retrieve and create the formulary information of various drugs and plans.
• Worked on writing stored procedures and queries for migration and interim project.
• Worked on SQL performance tuning and done unit testing to check the performance when the data is migrated from Rx builder to INET SQL server database.
• Created required SQL queries to be integrated to Java code to meet the requirement for generating the user defined formulary reports.
• Deployed and done the debugging of the created stored procedures and done the unit testing.
• Coordinated with QA and Production team to make sure that we stick to the estimate for client.
• Generated and developed XSLT code to translate XML documents using graphical XML mapping tool to map schemas.
• Developed mapping routines to Map incoming XML to a Mapping document and deliver it to a queue and to map from a Mapping document to outbound XML and deliver it to the customer.
• Involved in transformation and representation of XML files using XPath and XSLT.
• Used service now tool for raising and addressing the tickets as per the requirement. Implemented Various Data Quality Rules in Data Analytical layer for the Credit Risk Warehouse Application.
• Worked with different portfolio groups (Retail, Wholesale, Securities, and Equities) to gather and identify Data elements for Institutional Credit Exposure (ICE) report.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Worked on parallel projects which are in various stages of Requirement gathering and Data Discovery.
• Worked as a liaison between IT team and Business Stakeholders pitching in to help all partners understand the scope and extent of requirements. Proper assumptions between the stakeholders are an important part of these discussions.
• Constructed flow diagrams and presentations for higher managements using MS Visio and other MS Office tools.

Confidential, New York, NY

Sr. Data Analyst

Solution Environment: OBIEE 11.1.1.7.1 , OBIA 11g, Oracle11g, ODI 11g, Quality Centre 11.0, UNIX shell scripting, Pentaho ETL, Alteryx, Tableau, Splunk, TOAD, SQL Server, MYSQL, UNIX - Solaris.

Tools: JIRA, GitHub, Win XP Professional, SVN.

• Reviewed, analyzed and created detailed documentation of business systems and user needs, including workflow, program functions and steps required to develop or modify application programs.
• Assisted in developing and maintaining business & financial reports and IT work/databases, which was required to support the various lines of business and specific projects.
• Consulted with IT Personnel to determine business, functional and technical requirements for specified applications.
• Used Pentaho Data Integration Designer v4.0 to extract data from various sources including flat files of fixed format, Excel, XML, CSVs and databases like IBM DB2, MySQL and SQL Server.
• Used several transformations in Kettle to cleanse, validate and improve quality of data before loading it into target schemas.
• Developed complex custom reports using Pentaho Report Designer which includes developing Business Views, Cascading pick-lists, Drill-through, Hyperlinks, sub-reports etc., functionality into these reports.
• Developed effective reporting tools for the business unit and completed existing projects from original concept through final implementation
• Organized chart-holding facilities and assisted in training staff. Assisted various projects from start to finish through the SDLC process.
• Create SplunkSearch Processing Language (SPL) queries, Reports, Alerts and Dashboards.
• Worked on various defects analysis and fixed them.
• Problem record analysis and solution providing.
• Helped release the Docker/Selenium based New Relic browser testing solution
• Field Extraction, Using Ifx, Rex Command and Regex in configuration files.
• Creating Reports, Pivots, alerts, advance Splunksearch and Visualization in Splunkenterprise.
• Participated in Code Reviews, System Testing and UAT followed by production verification, post production testing and support
• Performed internal & external reporting, cash management, cost reduction & efficiency.
• Gathered functional, business and technical requirements using individual and group meetings.
• Documented system functional and technical requirements.
• Developed detailed reports for a Credit Card Analysis study, for banking clients in SQL Server and Alteryx.
• Developed PL/SQL Stored Procedures, Functions, database Triggers and packages for implementing complex business logic and building hierarchical reports to the end users.
• Led ETL development (in Alteryx) for DW application that loads 10m records/day from external system such as data files and MQ (real time messages) in staging, ensuring data quality checks, data cleansing, business rules and fed into fact, aggregated summary tables used in creating credit card analysis reports.
• Designed robust data models using Erwin for Data Warehouse/Data Mart development, OLTP and Business Intelligence (BI) applications.
• Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
• Created and Scheduled the Full load and Incremental loads using ODI studio in Dev and QA.
• Created new LDAP groups and mapped them to the Application roles in Enterprise Manager.
• Monitored Performance Tuning of reports by identifying the indexes required on the backend tables and also from the data available in the Cache.
• Worked on the SQL query development for the testing of the different Dashboards and Analysis
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups
• Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE.
• Involved in configuring pre-defined SDE‘s and SIL’s in ODI studio.
• Configured Interactive Dashboard with drill-down capabilities using Filters, Metadata Objects and Web Catalog Objects.
• Created Aggregate Level facts to improve the performance in the reporting needs.
• Created Unit test cases for Analytics reports and Analytics dashboards and executed manually.
• Configured Row Level Security, Column Level Security and Object level security to allow users to view their respective data only according to the requirement.

Confidential, New York, NY

Sr. Data Analyst

Solution Environment: OBIEE 11.1.1.7.1 , OBIEE 11.1.1.6.2 , BI Apps 7.9.6.4,Informatica 9.1,DAC 10.1.3.4.1 , Oracle 11g, DB2, SQL Server, TOAD, UNIX - Solaris

Tools: JIRA, Win XP Professional, SVN, HP ALM.

Project Management tools: MS Project, MS Visio, MS Office, Waterfall, Agile techs.

• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Created technical documentation for various reports and made it available for Clients and End users.
• Experienced Informatica developing Source Objects and Target Objects including Source Dependent Extract (SDE) and Source Independent Load (SIL) mappings
• Performed preload configuration steps for BI Applications
• Use Data Warehouse Administration Console (DAC) to configure execution plans, manage, and run ETL routines to populate the OBAW and monitoring the results.
• Created Catalog Groups and set permissions for items in the presentation catalog and privileges and rights to users and groups
• Configured Interactive Dashboard with drill-down capabilities using Filters, Metadata Objects and Web Catalog Objects.
• Applied Cascading Prompts and Multi Level Prompts on Dashboards
• Identified issues, performance bottlenecks and optimized the Business Intelligence Dashboards and Reports.
• Actively involved setting up OBIEE and BI Publisher across multiple server locations
• Developed different kinds of reports (pivots, charts, tabular) using global and local Filters
• Trained End Users and Pilot Users about OBIEE Tools
• Defined the Dimensional Hierarchy and created the Dimensional Levels for each of the dimensions in the BMM layer for Drilldowns
• • Involved in the data analysis and Core ETL design for counterparty rating system CRIS in the Risk area.
• Extensively worked on the data load/cleansing using Informatica Power center 9.0.1 using various Client components and transformations (Remote Procedure, connected & unconnected lookups, Expressions, source qualifier, aggregators, filters, sequence generator etc.).
• Designed the batch process and developed Unix scripts to model the end-end load cycles according to the data dependencies.

Confidential

Oracle Developer

Solution Environment: Oracle Developer 2000, Oracle 8i, SQL *Loader, Informatica 7.x/6.x, Oracle 9i.

Tools: MS-Access, Windows NT.

• Extensively involved in coding of the Business Rules through PL/SQL using the Functions, Cursors, Triggers, Stored Procedures, and Packages in the server side.
• Participated actively in the technical and functional discussions.
• Extensively involved in designing the project and coordinating a highly professional team.
• Interacted with the user group on a regular basis to discuss requirements and updates.
• Used Forms to provide the interface for the application and Reports to take periodical reports.
• Responsible for the Instructor module user interface design, implementation and testing.
• Generated reports and graphs to study instructor utility percentage every quarter and display the feedback results.
• Was responsible for providing expertise training to end users on the new system and its user interface and reports running procedure.
• Optimal utilization of object-reusability features like reusable transformations, mapplets, copying objects from other repositories, using variable/parameters for simplifying complex mappings.
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units information in tables.
• Created and used Reusable Transformations to improve maintainability of the Mappings.
• Created various Reusable and Non-Reusable tasks like Session and other tasks like Decision and email tasks.