SUMMARY

• 8 Years total IT experience in Design, Development, Testing, Deployment, Troubleshooting, documenting Specifications, Support and Validation of Applications in Real Time Environment.
• 6 years of experience in Business Intelligence(BI) Applications like Oracle Business Intelligence (OBIEE) / Oracle Business Intelligence Apps (BI Apps)/SAP Business Objects 4.x(SAP BO), CMC, WEBI, DESKI, IDT, MS SSRS, Tableau.
• Expertise in ETL process to facilitate Extraction Transformation and data Load from OLTP systems to OLAP systems.
• Expertise in Data Modeling design, analyze and implement - conceptual, logical and physical data models.
• 6 Years of strong experience in creating entity relational & dimensional models with Dr. Ralph Kimball Methodology i.e., Star and Snowflake Data warehousing.
• Expertise in creating rich interactive graphics and data visualization of business-critical reports, dashboards & KPI’s.
• Expertise in designing, developing and managing the BusinessObjects Universes and OBIEE repository.
• Expertise in Client and Server-side technologies Webservices, HTML, CSS, XML, Java Script, UNIX, JSP, J2EE, AJAX and RMI.
• Expert knowledge and experience in Java, PHP, C, C++, OOD, Oracle 12c/11g/10g, mySql, MS SQL server 2008 SQL, PL/SQL.
• Multi-Role Release Engineer for many Application projects writing Technical Specifications, Functional Specification Documents, Project Estimations, Unit Tests, and Manuals after the release.
• Strong Implementation knowledge of OOAD, UML Design Patterns, Software Development Life Cycle(SDLC), Software Testing Life Cycle (STLC), Agile and Scrum methodology.

TECHNICAL SKILLS

• J ava, PHP, Python, C, C++, UNIX Scripting, SQL, PL/SQL, T-SQL and Visual Basic 6.0(VB),Scala.
• RMI, AJAX, J2EE, Java Servlets 2.3, JSP 1.2, ASP, XML, XSLT, HTML, CSS, DJTM, Java Scripts, Node JS, Webservices, AWS, Red Shift, Amazon RDS. OBIEE 11g/12c, OBIEE Repository builder, BI publisher, OBIEE Console, OBIEE Enterprise Manager(EM), OBIEE Catalog manger, Oracle Warehouse builder(OWB), Oracle Data Integrator(ODI), IBM Cognus, SAP BO 4.1 - Information Design Tool(IDT), Universe Design Tool, Web Intelligence(WEBI), Web Intelligence Rich Client, Central Management Console(CMC), Central Management Service(CMS), Promotion Manager, Report Conversion Tool, Desktop Intelligence(DESKI), SSIS, SSRS, SQL Server Business Intelligence Studio.
• IDEs, Tools & Framework: Myeclipse, WinCVS, WinSCP, Toad, PM Smart, Rational Rose, JXplorer, EMacs,
• Matlab, Netbeans, JEdit. TWiki, Microsoft Visual C++, XFW Framework (struts framework), Erwin,PL/SQL 10.0.5, Putty, SQL developer, MS Office, Visio, MS Office 365, MS-Project 2000’s, SQL* Plus, Oracle designer, SQL*Loader, Launchpad, SVN,GIT, Trello.
• Web Logic Server, Apache Tomcat 6.0, IIS SOAPUI Pro, LoadUI Pro.
• Oracle 12c/11g/10g, MS-Access 2005, mySql, NoSQL, MS SQL server 2005,2008.
• UNIX, LINUX, Windows 2000’s, Windows visa, Windows XP.

PROFESSIONAL EXPERIENCE

Confidential

Senior Application Developer

Platforms used: OBIEE 12c/11g, OBIEE repository manger, OBIEE Catalog manager, OBIEE Console, OBIEE EM, Oracle warehouse builder(OWB), Oracle Data Integrator(ODI), Web Logic Server, Oracle 12c/11g/10g, SQL, PL/SQL, SQL* Plus, Unix, Windows 7, SQL Developer, ERwin 4.1, Tableau, AWS, Red Shift, Agile.

Responsibilities:

• Data modeled business requirements gathered from Business Users, Department heads and Managers. Also optimized data models for better performance and implementations like Star and Snow-Flake Data warehouses(DW). o Designed, developed and implement a series of ETL processes to populate data in to the Data warehouse(DW)(Star and Snow flake) and Data Marts. o Worked in transferring data from multiple sources (Oracle, Flat files, MS access/excel, mysql, SQL server, CRM) to multiple targets. o Designed Schema/Diagrams using Fact, Dimensions, Physical, Logical, measure objects, Alias and Extension tables. o Configured and created OBIEE Repository, involved in designing of physical, BMM, and presentation layers of metadata repository using OBIEE Administration Tool. o Created mappings as per the business requirements using Transformations like Lookup, slowly changing dimensions, Router, Aggregator, Source Qualifier, Joiner, Expression, and Update Strategy. o Extensively worked with performance tuning of mappings, sessions and stored procedures. o Involved in the design, development and testing of the PL/SQL stored procedures and packages for the ETL processes. Developed UNIX scripts to automate chronological loads and Maintained MDM. o Work closely with business users in designing reports, dashboards and KPI’s and suggested better ways of reporting in OBIEE / Tableau so that the required information is better visualized by end users. o Developed Reports / Dashboards with different Analytics Views (Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, with global and local filters) using Oracle BI Presentation Services / Tableau. o Customized users, groups and assign privileges for the users to access the data from the warehouse in web logic console of OBIEE 11g. Setup Multi User Development Environment (MUDE) in OBIEE. o Managed security privileges for each subject area, dashboards, groups and roles according to user requirements. o Experienced in Unit and System testing by building Test Scripts and involved in UAT testing with Business users. o Designed, Created and Implemented KPI’s using BI Publisher. o Prepared Technical design, Source to target (S2T), Review checklist and Technical Specifications documents. o Setting up LDAP authentication to enable SingleSign on for Users in Development environment leveraging Analytics Repository. Created script in linux to take a backup of catalog and RPD file at the end of every day. o Implemented skins, styles and usage tracking in OBIEE 11g. o Developed and monitored Incremental & Full load through DAC. o Responsible for migrating repository and catalogs from Development to Test and production Environments o Worked in production support and seen through the phase of the developments in the production and done various bug fixes during ETL run and dashboard implementation. o Analyze datasets through Tableau to provide strategic direction to the department heads.

Senior BI Analyst

Confidential

Platforms used: Oracle 12c/11g/10g, PL/SQL, SQL, SQL Developer, UNIX, SAP BO 4.x - Information Design Tool(IDT), BI Launchpad, Web Intelligence(WEBI), Web intelligence Rich Client, Central Management Console(CMC), Central Management Service(CMS), Import Wizard, Promotion Manager, Report Conversion Tool, Desktop Intelligence(DESKI), SQL*plus, Agile.

Responsibilities:

• Worked with Business Analyst, Business Users and Managers for gathering, analyzing, documenting Business Requirements, Functional Requirements and technical Specifications for Business Objects universes and reports. Established effective working relationships with cross teams to ensure timely delivery of services. o Responsible for Designing, Modifying and Building of Universes, Classes, Measures, Prompts and objects in Business Objects Information design tool. Generated various Analytics Reports using global, local filters, multiple queries and combined queries in WEBI. o Analyzed all tables and created various indexes to enhance query performance working with DBAs. o Responsible for generating and developed different type of reports on request, Ad-hoc, Summary, Sub Reports, Tabular, dynamic grouping, Cross-Tab, Drill down reports, Graphical reports with drilling capabilities in tables, complex calculations, Variables, Breaks, Sorting, Parameter prompts and Alerts using WEBI/DESKI. o Created cascading List of Values (LOVs) for better understanding of prompts by the end users. o Set up conditions to restrict data based on report requirements at Universe level and Object level security in the CMC. Created Periodic reports: daily report, weekly, monthly and annual reports, till and employee reports. o Involved in Unit Testing, Integration Testing and Performance Testing of reports and Universes. o Validated and exported Universes to Repository for making it available for users. o Trained the users on the Ad Hoc reporting and on navigating the Business Objects tools. o Created Derived tables and Aggregate tables to enhance the SQL performance of the universe. o Involved in the troubleshooting of universe schema with loops, fan trap, chasm traps and cardinality problems using Contexts and Aliases.
• Administered, Maintained and Managed SAP BO security, services, folders, groups, roles and user profiles using SIA, CCM and CMS.

Application Developer

Confidential

Platforms used: Oracle 11g, mySql, SQL, Java, PHP, HTML, XML, JSON, RESTful, SOAP, JavaScript, NodeJS.

Responsibilities:

• Developed an automated solution to integrate the university databases and QMP (Assessment tool) database with improvised database performance. Enabled a single sign -on by collaborating with LDAP
• Responsible for coding, testing and documenting various packages, procedures, and functions for libraries.
• Application Management (Bug identification and fix, Testing, Release, Future Proofing, Risk analysis).
• Provided support to develop customized discoverer reports and technical specification documents.
• Used SOAP and webservices to extract data from QMP server.

Confidential

Software Engineer

Responsibilities:

• Supported Banking and Trade applications 24/5, adapting changes and satisfying the client requirements. o Troubleshooting the applications and fixing the issues immediately for the customers with ITIL methods. o Enhanced the existing applications as per client requirements and Testing in multiple levels for damage control of the issues in real environment. Given Knowledge Transfer Sessions to peers regarding Existing Errors((Known -Error Database) and client application as a primary resource for GODOT and CPD RANREC applications.
• Designed, Developed and implemented the IBAN validation functionality, Bank Search utility, Quick Payments, mobile banking for corporate banking, template migration and created a new concept called locks for Standard Chartered Bank payments and Inquires.
• Worked on SDLC including Designing, Developing, Testing, debugging, configuring, deploying and documenting multiple new and existing modules using Java, J2EE(Struts), HTML, XML, PL/SQL, CSS, JavaScript. o Developed Authentication for templates using RAS algorithm. Used RMI technologies to bring FOREX (FX) rate from the server located in UK.
• Designed and developed Use Cases, Class diagrams and Sequence diagrams using UML. o Trained resources on the Client Applications and Exhibited excellent problem solving and troubleshooting skills. o Performed Technical Reviews and configuration Control activities and supported SIT, UAT and Production