TECHNICAL SKILLS

• COGNOS
• ORACLE HYPERION
• OBIEE
• SAP BI
• SSRS
• ORACLE DB
• DB2
• MS - SQLSVR
• Jazz CLM Suite
• Clear Quest
• Clear Case
• Primavera
• Confidential Websphere
• MS-SharePoint
• Lotus LDAP
• MS-Active Directory along wif TOAD
• SQL navigator
• Data Studio
• Data Architect for ORACLE
• MS-SQL
• DB2 mySQL via Windows (Srvr/Sys) and Unix

PROFESSIONAL EXPERIENCE

Confidential

Senior Data Warehouse Specialist

Responsibilities:

• Served as teh lead Cognos Expert and adviser on a VERY LARGE DATABASE business intelligence project;
• Developed ETL code via PL/SQL or talend mapping jobs to move data from transactional system to teh data marts;
• Created numerous Cognos BI reports to address customers’ data quality issues;
• Converted Oracle PL/SQL reports to Cognos canned reports.

Confidential

Senior Associate

Responsibilities:

• Served as team lead for teh reporting and data quality groups and therefore also handles all project management related duties for these teams to include performance evaluations, time-card signing, interviewing and hiring evaluations.
• Defined current contract control and management system ( Confidential ) requirements in regards to Reporting; utilized relational, dimensional design of teh reporting packages. Designed teh implementation map and architecture for deployment using best practice determining teh hardware items that were available to teh team.
• Generated application models diagram, workflow diagram, design approach diagram aligned against System Requirements Specification bridging teh gap between teh planning and reporting during client meetings. Generated first and second batch reports to establishing Business Analytics and Optimization wifin teh organization using primary BI tool.
• Brought out teh executive level insightful data by creating contract CO level and ETO level dashboard for executive and task order level manager displaying financial information, performance information, and contract management analytics.
• Administered teh entire reporting platform for teh FAA ATO contract management operations. Deployed COGNOS Enterprise Business Intelligence wif Websphere Application Server 8.5.
• Manned Confidential 3 production and lower level oracle database as teh DBA for create, update any information in teh application as well as create analytics query to support teh ad hoc requests.

Confidential

Senior Consultant

Responsibilities:

• Built analytics solution using COGNOS business intelligence suite for several projects including using Query Studio, Report Studio, Analysis Studio, Event Studio, COGNOS administration, Framework Manager, Virtual View Manager, Map Manager
• Integrating solutions using COGNOS components and other software like Websphere, SharePoint, Acitve Directory accessing data via API(Mashup wif Google map, Bing), wif data coming from BMC Remedy, Streetscape, Disney Motion Pictures.
• Developed a series of dashboards and reports for monitoring KPIs on high level using drill up/down, drill through, bursting techniques. Created Dimensional Model Relational Framework Manager model for teh purpose of easy reporting including logical and business layers.
• Helped junior developers to work wif end users to build a Patient Care Dashboard and a Collaborative Care Dashboard. Contributed on several proposal effort in relating to analytics future opportunities in technical sections
• Coordinated and advised development effort for creating single solution bridge wif partner firms like GDIT, CSC, Deloitte.

Confidential

Senior Consultant

Responsibilities:

• Implemented 3 full projects involving full phases of SDLC life cycle including conceptual design, requirement gathering, implementation, maintenance, wif one project for Budget Formulation, Planning, Execution and Forecasting, another two projects on Performance and Resource Management.
• Led on teh development teh entire data mart, Extract Transform Load (ETL) process, metadata layer, and 40 + complex BI reports in less than a 2 month time frame producing Confidential Performance Management Division in teh OCFO monthly performance charts by slashing teh time by 99.83%. dis allowed Confidential to produce performance charts 600 times faster, improving and streamlining resource management status reporting.
• Led teh technical team on its daily and development tasks providing exclusive expertise on planning application model and BI report design approaches wifin client’s requirements and expectation on an intensive, rapid changing Enterprise Planning and Business Intelligence implementation of teh Corporate Planning Tool in teh US Patent and Trademark Office.
• Defined and educated clients wif application models diagram, workflow diagram, design approach diagram aligned against System Requirements Specification bridging teh gap between teh planning and reporting during client meetings. Conducted and facilitated training sessions wif client’s employees to support teh usage and understanding of teh solution.
• Solely designed and managed Personnel Planning BI application to report IMF FTE and Dollar plans to halp 38 different departments to better internally manage their Billion dollar budget. Also, provided strong effort to teh IMF for their downsizing initiative in halping teh OBP department carrying out teh mission. Significantly reduced stand-alone departmental databases/ spreadsheets, and associated risks. Discovered several reporting tool bugs such as granularity differing display functions etc. and created work-around / solutions.
• Acted as ETL developer and Report Developer for teh Veterans Benefits Administration(VBA) EDW - VETSNET data warehouse, which integrates data from nearly all VBA offices and programs around teh world into a single repository for thousands of users across teh agency.

Confidential

Systems Analyst

Responsibilities:

• Provided and defined business intelligent automation development process for DOD * department of program management. Successfully resolved transition issues from version 1 to version 2 regarding server connectivity, peripheral compatibility, and report design efficiency inquiries for teh BI solutions
• Adjusted new Hyperion Server Architecture from configuration adjustment to connect ORACLE and managed installation and configuration following clients’ needs guideline, successfully integrating repository using converted ORACLE databases wifin Windows XP/2003 servers connecting Windows workstations, clients, and printers) through two web servers
• Provided demo and training on functionalities wif Hyperion Interactive Reporting in html and web client in order to pass client satisfactory requirements and getting thumb-up granted by teh client’s program director for teh contract’s continuation.
• Administered Hyperion BI system and User Management through three project cycle phases to meet all clients and internal needs for BI web portal. Maintained its running status and varieties of report data models including creating original, multi-dimensional BI report models retrieving data in Essbase.

Confidential

Business Consultant

Responsibilities:

• Played one man show for providing business intelligent support for clients. Successfully resolved customer issues regarding connectivity, peripheral compatibility, and standard software usage questions for products on teh following BI Server: COGNOS ReportNet Server, Framework Manager, PowerPlay Transformer, and provided exclusive training on functionalities wif ReportStudio, QueryStudio, AnalysisStudio
• Architected and managed installation and configuration following clients’ needs, successfully integrating CS connecting ORACLE and SQL server databases wifin Windows XP/2003 servers (connecting Windows XP/2003 workstations, clients, printers, and terminals wif remote access) through two IIS web server manager via ISP wif worldwide points-of-presence
• Administered COGNOS BI server and Internet Information Server to meet all management, employee, and customer needs for BI web portal. Set up security parameters for BI system, maintained its content and administration.

Confidential

Operation Analyst

Responsibilities:

• Conducted thorough research to identify inefficiencies in CCO’s reporting procedures & developed new reporting and analytical solutions by consistently managing cash transaction accounts of daily average of 5 million dollars
• Served as team leader compiling and distributing competitive various funds inventory, production analysis, based on key performance by day, week, month and quarter by creating reports in Crystal Reports or SQL
• Utilized analytical skills and tools (Crystal Reports) working wif other transfer agents, bank operations, finance department and investment companies assisting resolving trades’ reconciliation issues, and reduced discrepancy to minimum. Worked closely wif finance department and investment firms investment account reconciliations and frequently received appreciation from various clients and investment companies