Senior Analyst Programmer Resume
4.00/5 (Submit Your Rating)
SUMMARY
- Over 7 years of experienceas Oracle Business Intelligence Developer and Data Analyst
- Skilled in BI Architecture, Data Visualization, Analytics, BI Reporting, and Dashboard Designs
- Proficient in Data extraction Transformations, ETL, Data warehouse and RDBMS implementation, Dimensional Data Modeling using Star/Snowflake Schema and OLAP Technologies
- Excellent verbal and written communication skills to liaise with all Business Stakeholders including Senior Management, Clients, SME’s and Technical teams and a self - directed team player
- Strong management, development skills used to deliver projects on time following Agile/Scrum methodologies in multinational/multicultural on-shore/off-shore teams
- Working towards Professional Scrum Master (PSMI) certification - completed pre-requisite training
TECHNICAL SKILLS
Reporting Tools: OBIEE 10g/11g/12c, BI Publisher, Siebel Analytics 7.8, Tableau
ETL Tools: Informatica Power Center 8.x, 9.x
Languages: SQL, PL/SQL
Scheduling/Monitoring: Control-M, DAC
Data Virtualization: Denodo 5.5
Project Tracking: Jira, Confluence, HP Service Manager
DevOps/Process Modeling: Bamboo, SVN, Crucible, Visio, Microsoft office 365, Toad
Knowledge of: SSRS, MS SQL, Denodo, Unix
PROFESSIONAL EXPERIENCE
Confidential
Senior Analyst Programmer
Responsibilities:
- Led and successfullydelivered UK Offshore regulatory audit project utilizing OBIEE, BI Publisher, Informatica for KPMG and HMRC within deadlines in fast-paced Agile environments
- Managed team of 6 overseeing task assignments, project timeline, and progress tracking, interactions with SME’s to capture business requirements, as well as facilitated training for graduate programmers,end-users and client demonstrations
- Prepared technical design specifications documents and implementation plans for Prod releases
- Analyzed and accurately identified issues, risks and created the technical plan for Oracle BI implementation to replace existing WebFOCUSreports
- Created Dimensional Hierarchies, Level-Based Measures, and adding multiple sources to business model objects.
- Proficient in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience.
- Defined session and repository variables and initialization blocks to streamline administrative tasks and modify metadata content dynamically.
- Promoted to Senior Analyst Programmer for successful implementation of investor tax regulatory project on time and without production issue leaks utilizing OBIEE, BI Publisher & Informatica (Awarded Spot On 2016 award)
- Created BI publisher and BI reports, dashboards and Repository semantic layer designing and development and metadata modeling, also responsible for performance tuning of reports
- Assisted business users in testing Regulatory Reports and data mart in analyzing and improving data (UAT support) as well as created and performed test cases for QA testing
- Development of DATAMART to store the customized data into Mart tables for the required dates and Portfolios.
- Planned and supervised code deployment to the higher environments and prepared pre and post-release activities process document templates to establish best practices
- Designing Scheduler Draft for the Batch to run end to end (Control-M)
- Development of Informatica mappings to load and fetch the data from the databases and store them in respective staging tables
- Creating Data Services Layer in Denodo Express & feeding it to downstream Dashboard systems
Confidential
OBIEE Developer
Responsibilities:
- Coordinated the development, testing, and deployment of modules between onshore-offshore teams
- Prepared and defined user requirement and technical specifications documents
- Customized and developedrepository, Oracle BI answers and dashboards, configured metadata objects,and web catalog Objects
- Implemented LDAP securitymodel for OBIEE users and published daily status reports on Sharepoint using BI Publisher
- Worked on performance tuning of reports using aggregate tables, caching and event polling tables
- Customized BI screens as per the UI/UX designs standards followed by the company
- Implemented Variables, Hierarchies, Usage tracking, Opaque views, Pipeline functions & Direct SQL
Confidential
Senior Software Engineer
Responsibilities:
- Promoted to Senior Software Engineer for Successful re-building of DWH for analytics environment utilizing Informatica and PL/SQL from Siebel CRM DB (Awarded STAR performer 2012)
- Received Customer Service Appreciation Award in 2011, 2012 and 2013 by client Confidential Healthcare
- Development of ETL jobs for the creation of Data warehouse required for the end reports. Developed stored procedures using PL/SQL
- Customized and Programmed DAC workflows
- Configured Siebel Analytics, OBIEE 10g at the repository level and web catalog level
- Developed and Scheduled Ad-hoc and Canned reports using Answers and Dashboards
- Designed dimensional data modeling at all three layers (physical, BMM, and presentation) of RPD
