OBJECTIVE:

To pursue a challenging career in a field where I can effectively contribute my skills as a Business Intelligence professional, leveraging technical and project management skills.

SUMMARY:

• 8+ years of IT experience within business requirement gathering, analysis, design, data modeling, analytics and building BI solutions.
• Extensive experience in IBM Cognos TM1 successfully delivering business performance and process management solutions within a fast - paced, intellectually challenging and analytical environment.
• Developing ETL processes in Turobointegrator using modular approach, importing from various data sources including, cubes and SQL tables and creating cubes, dimensions, load actual data, calculating percentages and moving data from cube to cube(ODBO) and back to Relational Database(ODBC).
• Proficient in writing complex business rules, optimizing rules via appropriate feeders as well as effectively writing conditional feeders for better performance by reviewing against set benchmarks.
• Extensive experience in carrying out all phases of SDLC including Requirement Gathering/Analysis, Planning, Design, Development, Testing and Implementation of complex Planning, Budgeting, Forecasting, Recoveries and Reporting solutions based on technical solutions to strict deadlines.
• Understanding requirements, processes, architect solutions, and system design through effectively communicating with senior management.
• Identifying and analyzing key risks/issues involved in the projects and documenting as well as managing weekly status reports and stand-ups including implementing needed changes.

TECHNICAL SKILLS:

BI Tools: Cognos BI 10.2 (Framework Manager, Report studio, Query studio, Event Studio), Cognos TM1 10.1 - 10.2 (Architect, Perspectives, TM1 Web and Turbointegrator), OBIEE 10.1.3.3.1 to 11.1.1.6

Languages: SQL, PL/SQL, HTML, Microsoft Visual Basic

Databases: Oracle 11g, Oracle 12c, Microsoft SQL SERVER 2000, 2005, 2012 Server R2

OS: Windows 95/98/2000/XP, 2008

Other Tools: Oracle Data Integrator (ODI), SQL Developer, Rally, YARDI Voyager.

PROFESSIONAL EXPERIENCE:

Confidential

TM1 Architect / Developer

Responsibilities:

• Lead technical discussions on the translating business requirements to technical solutions.
• Designed and built Cognos TM1 models via rapid prototyping.
• Reduced the size of organization wide reports by creating Cognos reporting templates (Active forms)
• Run daily data validation reconciliation with source systems to ensure consistency and accuracy.
• Performed system admin tasks; (user account creations, Security & authentications, Clients install, user training)
• Optimized existing model for system performance (Cube optimization and check for overfeeding in rules)

Cognos TM1 Architect / Developer

Confidential

Responsibilities:

• Built and delivered successful technical solutions that involve all TM1 components e.g. cubes, dimensions, TI processes, rules, securities, workflows, applications, web deployments, etc.
• Executed the completion of the TM1 architecture and support TM1 models through all stages of the project life cycle.
• Integrated third part source data into TM1 solution and automated the exchange of data with other internal systems
• Fine-tuned TM1 the model to maximize the application performance and hardware utilization.
• Experienced in creating views for dynamic excel reporting templates.
• Expert in writing TM1 rules with feeders
• Hands on experience in creating dynamic subsets using MDX in dimension editor and in turbo integrator scripting.
• Implemented security at application level, Cube level, Dimension level, Element level and Data level.
• Experience in scheduling the turbo integrator process using chores
• Responsible for daily financial data validation to ensure accurate and current data.
• Provided production support as well as troubleshoot any incident.

Confidential

Software Engineer, GE

Responsibilities:

• Participated in the requirements process to help elucidate business and technical requirements for various financial applications.
• Utilized Complex SQL queries to pull data from multiple sources to meet defined requirements.
• Created, enhanced and implemented Turbointegrator processes and Cognos TM 1 solutions to automate and build GE Real Estate Global Debt Forecasting application, which reduced cost by $2+ million.
• Developed and scheduled chores and processes to load, process and retrieved data from database tables and other data sources to feed Cognos TM 1 applications and other downstream applications.
• Published Cognos objects to be utilized to build reports within framework manager.
• Created web forms and reports to enable managers to make effective, real time resource and financial decisions.
• Automated deployment processes between environments to reduce cost, eliminate human error and to simplify processes.
• Enhanced, optimized and streamlined current financial models in production.
• Created user groups and roles to manage security and access rights of objects and reports to end users.

OBIEE Analyst/Developer

Confidential

Responsibilities:

• Gathered business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Developed and customized metadata repositories (Physical layer, BMM layer, & Presentation layer) including creation of connection pools, setting alias tables, BMM, applying business logic, dimensional hierarch modeling, time series modeling, aggregation, creating logical column, and calculation wizards.
• Created connection pools, imported physical tables and defined joins in the physical layer of the repository.
• Created dimension hierarchies, aggregates, and keys in the BMM layer to improve system performance.
• Modified presentation layer to add presentation tables and columns to meet the business user needs.
• Setup usage tracking option to monitor frequently run reports in order to provide caching for the reports and perform database optimization by analyzing query performance using SQL.
• Customized reporting with OBIEE answers and integrated them into the dashboards.
• Generated reports and created dashboards with global prompts, column selectors, navigation, and automatic drill-down using report features like pivot tables, charts and view selector.
• Created user level security for intelligence dashboards based on Business Requirement.
• Performed data validation of the reports and dashboards to ensure completeness and accuracy.
• Prepared and documented Unit Testing (UT) and User Acceptance Testing (UAT) for all components in OBIEE and documented and reviewed test results with the business to confirm expected results.
• Evaluated Oracle BI Enterprise Edition updates including new utilities such as BI Server, Answers, Delivers and Publisher.