PROFESSIONAL SUMMARY:

• I have total of 9+ years of experience in software development with exposure to Banking Financial Services and Insurance sector ( Confidential ) in Oracle Business Intelligence Enterprise Edition ( Confidential ),Oracle Financial Service Analytical Application( Confidential ), D Confidential warehousing domain and Oracle EPM solutions ( Confidential products) with implementation, design, build, deployment, performance tuning, transition, and support.
• Has experience in analysis of business requirements gathering, defining strategy to customize out of the box Business Intelligence solutions to answer business questions.
• Strong understanding of Dimensional D Confidential Modeling, D Confidential Warehousing Concepts, and Designing Star & Snowflake Schemas for OLAP Systems.
• Expertise in developing Confidential repository with Physical, Logical and Presentation layers build reports/dashboards from the repository using Confidential Answers and troubleshoot various technical issues and bugs.
• Extensive knowledge of creating dashboards and reports using Confidential 11g/12c.
• Experience in Confidential features (i.e. Usage tracking, Dimensional hierarchy, Variables/Initialization Blocks configuration etc.), converting Snow - Flake Schema to Star Schema, Dim Hierarchies, Dim Extensions, Physical & Logical D Confidential Modeling
• Worked on creating Users and provided necessary security privileges in the Administration Console.
• Developed various Dynamic and Interactive Dashboards/Reports with variables.
• Business understanding of banking services and good understanding of relational d Confidential base management systems like Oracle server, Oracle Exad Confidential D Confidential base, SQL Server and Terad Confidential .
• Experience in Installation, Configuration, and Administration of Confidential 11g and 12c.
• Good knowledge in upgrading Confidential 11g to Confidential 12c.
• Worked on D Confidential Integration using Informatica for the Extraction transformation and loading of d Confidential from various source systems.
• Familiar with DAC (oracle d Confidential warehouse administrator console) for automation of ETL processes.
• Experience in Implementing and configuring Confidential D Confidential Quality framework implementation.
• Experience in building T2T (Table To Table) transformations in Confidential .
• Experience in Creating the test cases and Unit testing documents.
• Experienced in working with different software development methodologies like Agile and waterfall.
• Experience in application production support environment for a mission critical system.
• Excellent communication and inter-personal skills, accustomed to working in both large and small team environments and ability to think out-of-the-box.
• Quick at learning new technologies and frameworks.

TECHNICAL SKILLS:

Power Center Informatica (ETL tool) - Designer, Workflow Manager, Workflow Monitor, Repository Manager

D Confidential bases: Oracle 9i/10g d Confidential base, Oracle 11g d Confidential base, Oracle Exad Confidential d Confidential base,Terad Confidential, MS SQL Server 2008

Operating System: Linux, Windows Server 2008

ALM, JIRA, Version One, SVN, Gitbub, Jenkins, AnthillPRo, uDeploy, PAC2000-Change Management.

Linux shell scripting.

Undergone in Tableau.

Undergoing in Big d Confidential /Hadoop Ecosystem.

WORK EXPERIENCE:

Lead Developer

Confidential, Charlotte, NC

Environment: Confidential 11g, Confidential 12c, Informatica, Oracle Exad Confidential, Confidential,, Terad Confidential, Linux server, Oracle SQL developer, Putty,Github,AnthillPro,uDeploy,ALM, JIRA,PAC2000 change Management.

Responsibilities:

• Collaborated with business areas and d Confidential owners to successfully implement and maintain an enterprise level business analytics and d Confidential warehousing solution.
• Designed the metad Confidential (repository) which involves Physical, BMM and the Presentation Layers. Designed hierarchies to support level based metric/navigation/drill-down, created functionalities in the BMM layer in order to suffice business needs.
• Implemented security throughout dashboards at both object and d Confidential levels.
• Responsible for performance tuning of the existing subject areas - with the help of aggregate tables, caching strategy, indexes, view and other techniques.
• Defined and developed physical and logical d Confidential models to support departmental and functional reporting needs.
• Developed Ad-hoc and standard Reports/Dashboards with different Analytics Views (Drill-Down, Cascading Style Sheets, Pivot Table, Chart, Column Selector and Tabular with prompts, global and local Filters), contextual navigation, business rules with user identity and roles within Confidential .
• Actively involved in production support by resolving tickets for the reports and dashboards in order to support new business requirements.
• Analyzed and validated the business model in Confidential Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.
• Creation of page/dashboard/reports prompts in UI to provide dynamic filter condition to the Business user.
• Responsible for Managing Confidential technical, infrastructure related queries from client and offshore team and guiding the development team.
• Worked on implementing and configuring Confidential DQ framework for the profitability management.
• Worked on Confidential Re-run metrics.
• Implementation of Confidential security matrix in line with Confidential security matrix.
• Building T2T (Table to Table) transformations in Confidential .

Lead Developer

Confidential,Charlotte,NC

Environment: Confidential 11g, Confidential 12c, Informatica, Oracle 11g, Linux server, My SQL server, SSRS Package for ETL, Oracle SQL developer, Putty,ALM, VersionOne,PAC2000-Change Management.

Responsibilities:

• Responsible for designing OBI Architecture, d Confidential modelling, Dashboard and Report Development
• Extensively used Confidential Administrator Tool for customizing and modifying the Physical Layer, BMM Layer and Presentation Layers of the Repository (RPD).
• Created Dimensional Hierarchies (Drill down), Level Based Measures and Time Series measures for comparing business performance with previous time periods using Ago and To Date Functions.
• Developed various output formats such as Tables, Charts, Pivot Tables and other views as per Business requirements.
• Designed Dashboards Prompts, Pages, Links, Images, Embedded content, Text, Folders and Guided navigation links as per Business requirements.
• f end users and analyst, helping them to understand the reports, how to navigate the reports, and understand the report requirements.
• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.
• Involved in Admin related tasks like deployments, migrations, upgrades, debugging server related issues, security, creating users/groups, assigning roles & responsibilities.
• Responsible for status reporting and updating the stake holders on the progress of the project

Lead Developer

Confidential

Environment: ,Linux,oracle 11g D Confidential base,OBIApps7.9.6.3,DAC,Informatica,HRSM9.1,Oracle SQL Developer, Putty

Responsibilities:

• Customizing Informatica mapping, DAC and OBA warehouse as per the source system customization.
• Building Confidential Repository (RPD) Modeling, Dimensional hierarchies. Designed and Developed BI Analysis and dashboards and BI Security to the user base.
• Work with dashboard prompts to filter your dashboard and variables (Created Session & Repository & Presentation)to achieve desired functionality.
• Involved in all phases of the project lifecycle.(Requirement,Design,Build,testing,production implementation, Post production implementation and support)
• Understand the client and project requirements (both functional and non-functional) by studying the existing documentation and assimilating inputs from Business Analysts/SMEs and seeking clarifications, if any, to participate efficiently in the Development and Testing phases of the project.
• Create program specifications and unit test plans for software programs by studying functional and non-functional requirements and the application architecture document and converting the assigned functionalities into pseudo code/algorithms/test cases.
• Develop code using knowledge of relevant technology as per design specifications and document artifacts such as unit test scripts, etc. independently and support peers in identifying code defects and ensuring that the output is as per the given specifications and SLAs.
• Create the user documentation for the reports developed.
• Perform testing - self and independent (Functional, Integration, System) - as per defined processes and guidelines to ensure accurate program output; identify and resolve defects, if any.
• Work on Go Live activities as per the Implementation plan and manage any issues related to functionalities, user interface, performance, etc. that may arise.
• Participate in and prepare content for KT sessions, document the understanding, take on Shadow Support.
• Respond to the issues assigned, conduct analysis of the issues assigned, identify and evaluate different workarounds/ solution alternatives, implement the most optimal solution, support other team members on issue resolution in areas of expertise as required, manage stakeholder communication and close the issues assigned IN ORDER TO ensure support availability as per agreed SLAs.
• Interface with internal team and other stakeholders, if any, IN ORDER TO undertake onsite-specific activities of the project.
• Conduct Impact Analysis, create Design Specifications as per the high-level design, and create Unit Test Plans IN ORDER TO develop / validate / maintain the application as per the requirements.
• Understand application architecture document and seek inputs from the architecture / design team to understand the overall architecture IN ORDER TO provide deliverables that are in line with architectural requirements.

Technology Analyst /Lead -HFM admin/ Developer

Confidential

Environment: Environment: Confidential 11g, Informatica, Oracle 10g, Windows server 2008, Oracle SQL developer, Putty, HFM Admin

Responsibilities:

• Handling the enhancements in production support according to the user requirements.
• Interact with clients to elicit architectural and non-functional requirements like performance, scalability, reliability, availability, maintainability.
• Involve in Unit testing, SIT testing and assisted in UAT during deployment.
• Maintain consistent delivery of reporting solutions by following development standards and project management methodology for project participation.
• Involve in Fixing Production Issues, Defects, End user support, issue analysis and bug fixing.
• Provide inputs on solution architecture based on evaluation/understanding of solution alternatives, frameworks and products.
• Responsible for overseeing 24x7 Support and Fixing the Issues Raised without any deviation in SLA.
• Taking Back-ups daily and validating, checking log files regularly to improve performance.
• Perform performance optimizations on Registry settings, configuration settings suggested by oracle.
• Created new Batch jobs and scheduled new automated batch scripts for overnight maintenance process.
• Prepare Documents for the process flow, regular daily activities and knowledge sharing documents for the incidents/defects resolution.
• Provide Knowledge transition session to teammates and other teams.
• Documentation of the on goings in the project for purpose.
• Effectively maintaining the project documents repository for the benefit of team members and the management.
• Coordinating with other team mates in recovery call for the quicker resolution of the issues.
• Extensively used Confidential Administrator Tool for customizing and modifying the Physical Layer, BMM Layer and Presentation Layers of the Repository (RPD).
• Created Dimensional Hierarchies (Drill down), Level Based Measures and Time Series measures for comparing business performance with previous time periods using Ago and To Date Functions.
• Developed various output formats such as Tables, Charts, Pivot Tables and other views as per Business requirements.
• Designed Dashboards Prompts, Pages, Links, Images, Embedded content, Text, Folders and Guided navigation links as per Business requirements.
• f end users and analyst, helping them to understand the reports, how to navigate the reports, and understand the report requirements.
• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements.
• Involved in Admin related tasks like deployments, migrations, upgrades, debugging server related issues, security, creating users/groups, assigning roles & responsibilities.
• Responsible for status reporting and updating the stake holders on the progress of the project.

Confidential

SQL Developer

Responsibilities:

• Based on the Functional Spec provided by the business requirement, will prepare the program specifications and Unit Test Plan.
• Develop the code based on the business requirement.
• Test the code for the various test conditions.
• Independent Unit testing and User Acceptance testing are planned for the signoff to move the code to production environment.
• Post production monitoring and resolving the issues.
• Customer Interaction and clarified the concept asked by the user and using tech10 tool.
• Responsible for explaining Program Functional flows,trouble shooting technical queries
• Fixing of the program aborts
• Resolving production issues
• SQL query preparation for the given user requirement
• Prepare Technical papers/articles on the Top Issue under Top 10 for each month
• Preparing PL/SQL one timer scripts
• Coordinating with D Confidential Center/DBA/SE,Business OPS units.

Confidential

SERVER Product Engineer

Responsibilities:

• Testing and Releasing of Server Mbds and RAID cards.
• Testing and Releasing of Server Memories by single handed.
• Non Standard Request testing of server Configuration.
• Preparing Line documents and taking care of production issues to resolve.