SUMMARY

• 13+ years of success in delivery of technical strategies and solutions to fit the business needs and goals that have consistently led to increased revenue, customer retention and productivity, decreased operating expenses and error rates, improved business processes and better quality systems.
• Expertise in tactical and strategic solutions such as relational and multi - dimensional data marts, which take rapid advantage of OLAP and data mining technology.
• Multi-dimensional data modeling, design, sizing, development, implementation, and rollout in multi- platform environments utilizing DB2, SQL Server, and Oracle database technologies
• Strong experience in analyzing source systems and business requirements,
• Identifying and documenting business rules and design.
• Strong experience as BI Developer in developing/modifying repositories and reports using OBIEE/Siebel Analytics.
• Good understanding of functional specs and converting them into technical specs.
• Strong experience in Metadata Modeling at all three layers (Physical, Business
• Model and Presentation) using the OBI Administration Tool.
• Strong experience in Business Model development with Dimensions, Hierarchies, Measures, Aggregation Rules, Time Series.
• Good experience in creating OBIEE Reports & Interactive Dashboards with prompts
• Good experience in setting up Object level and data level security. Configured OBIEE Actively

TECHNICAL SKILLS

Applications / Modules: OBIEE 10g/11g, BI Publisher 10g/11g

Languages: SQL, HTML, XML

Methodologies: Oracle AIM, SDLC, Agile

Operating Systems: MS Windows, UNIX

Software: Microsoft Office Suite, including MS Project, XML, WebServices

Databases / Tools: Oracle SQL Developer, Toad Informatica Power Center

PROFESSIONAL EXPERIENCE

Confidential, Suitland, Maryland

OBIEE Developer

Responsibilities:

• Gathered Business requirements by interacting with the business users.
• Performed gap analysis and feasibility study for given requirement.
• Created mock up reports and dashboards for review by the business users
• Extensive experience in OBIEE repository (Physical, Business Model and Mapping and Presentation layers) for both Stand-Alone and Integrated OBIEE implementations.
• Extensively worked in creating hierarchies, level-based measures, Time series metrics and aggregates in the BMML.
• Excellent proficiency in data and object level Security in OBIEE.
• Extensive experience in customizing OBIEE dashboards and reports.
• Extensive experience in Repository and Reports performance tuning.
• Built Report prototype based on initial business requirements.
• Create custom resource Catalogue and Manage content in the resource Catalogue
• Built Analyses and created Dashboards with Global prompts, column selectors, navigation and automatic development Documentation drilldown.
• Performed testing and Data Validation of data in reports against the databases using SQL Developer and Toad.
• Performed post-upgrade documentation.
• Designed and Customized OBIEE dashboards and reports / Dashboards with different analytic views (Drill-Down/Dynamic, Pivot Table, Chart, Column selector, Tabular with local and global filters) using OBBIE/Siebel Analytic Web.
• Created interactive maps using the new OBIEE 11g “Map Views” feature

Confidential, Columbia, MD

Sr. Business Systems Analyst/ Data Warehouse Architect

Responsibilities:

• Render extensive analytical and technical acumen via research capabilities in the areas of report management, data procurement and project development.
• Organize joint application development (JAD) sessions for requirement gathering, with the stakeholders, dealers and super dealers, senior managements and end users.
• Analyze business requirements documents and develop flow chart diagrams and activity diagrams.
• Develop and support a set of standard software processes utilized by agencies
• Work with team to review and develop data standards, data exchange, XML data standard and data sharing model
• Train, manage, and evaluate both temporary and permanent employee workforce.
• Monitor and track success of process improvements.
• Analyze business risks, identify mitigating controls, plans and perform onsite testing.
• Determine effectiveness of control systems.
• Manage a multilevel responsibility matrix providing senior leaders with a thorough operative report
• Play key role in call center turn around project resulting in reducing caller waiting time, improving call response times and increasing first call resolution by 48%
• Gather requirements and turn them into design suitable for Business Intelligence.
• Perform COGNOS Implementation - Serve as an Analyst supporting the Sales team for the integration of global sales data from various ERP systems into COGNOS as a single repository, replacing several different reporting tools with one global analytical tool.
• Lead strategic planning initiative to secure proposed budget for the consolidation of six call centers by identifying CRM and process improvements opportunities.
• Evaluate the need of different programs and help determine the most efficient allocation of the Organization’s limited resources
• Assist in the creation, collection, analysis and reporting of performance metrics.
• Advise team and client on tools and techniques to improved existing business processes.
• Serve as the key participant in ongoing strategic planning, workforce analysis, resource allocation and performance measurement efforts.
• Utilized 3.0 years of SAP R/3 experience as FICO Functional Consultant with three full project life cycle implementation and post live production support.
• Identity and document SAP business requirement
• Organize business requirement gathering workshops with various business functional users.
• Lead team through structured business functional questionnaires
• Understand the existing business processes and identify and document the requirements in the wake of new implementation
• Work with implementation team to break down business processes, Identifies and configures the SAP settings.
• Check baseline configuration and testing of the functionality of the system
• Suggest changes to the baseline configuration if necessary after testing
• Collaborate with team to resolve all open issues and analyze for proper system configuration
• Support daily, monthly and yearly reporting and closing activities.
• Gained experience in Data Warehousing, Database design, Data modeling and Database triggers.

Confidential, Baltimore, MD

Business Analyst/Developer

Responsibilities:

• Partnered with the Business to identify IT needs, solve IT problems and deliver IT solutions consistent with the company strategy and developed from an in-depth knowledge of the functional areas.
• Facilitated Business Process Re-Engineering and Best Practices standards in compliance with Sarbanes-Oxley.
• Analyzed portfolio performance incorporating quantitative and qualitative research utilizing cash flow projections, expense forecasting, and rate of return (ROI) comparison to relevant benchmarks.
• Created functional requirement specifications (FRS) for Engineers, Provisioning and Pricing Modules and transformed guidelines into pricing rules.
• Conducted training sessions for the end users and documented various training manuals.
• Interfaced TIRKS and Visual Basic to produced Managers monthly reports
• Developed TASK MADE AUTOMATE programs

Confidential, Silver Spring, MD

Business Analyst/Account Manager

Responsibilities:

• Provided technical advice on all aspects of the installation and use of computer software systems and network, both before and after the sale of systems.
• Worked with client and IT Architect to ensure proper transaction of business requirements into IT solution requirements.
• Furthered the development of sales within existing major accounts and increased service levels by 70% to existing accounts.
• Worked with Director of Sales to develop and execute business plans to achieve assigned sales profitability and quality objectives.
• Assisted clients in the phases of migration into their production environment.
• Built business process models, data flow diagrams and entity relationship diagrams to maximize sales potentials.