OBJECTIVE
- The opportunity to utilize analytical, written, and verbal skills as a BI System Analyst/Data Engineer/Report Writer.
TECHNICAL SKILLS
- MotioCI.Visual Basic
- Visual FoxPro and Java Scripts.
- Transformer
- PowerPlay.
- Visual Basic and Crystal and Oracle Reports.
PROFESSIONAL EXPERIENCE
Confidential
Business Intelligence Consultant
Responsibilities:
- Data modeling ( Normalized and Denormalized)
- Oracle/Teradata/SQL Server data retrieval and Query Tuning
- Cognos reporting
- Cognos Cubes architecture
- Cognos MDX
Confidential
Sr. Business Intelligence Developer/Data Analyst
Responsibilities:
- Developing Business Intelligence solutions in support of the Internal and External clients.
- Expertise with Cognos Series 8, 10.2, 11 Framework Manager modeling, Report Studio, Query Studio, Analysis Studio.
- Creating and publishing packages/multidimensional models using Framework Manager from multiple data sources.
- Developing complex Report Studio reports involving drill up, drill down and master/detail queries.
- Creating Scorecard as well as Dashboard reports.
- Knowledge of and experience with Relational Database architectures, specifically Oracle, Teradata and/or MS SQL.
- Supported the following Cognos Software: PowerPlay, Transformer, and Impromptu.
- Created IBM Cognos 8 GO Office reports.
- Coaching and mentoring the offshore team of 5 members.
Software: Cognos 11.1.1 Framework Manager, ReportNet, Query Studio, and Analysis Studio, Oracle 10g, Informatica8, Microsoft .NET, Microsoft Office 2010, Windows Scripting, JavaScript, HTML, and Windows XP.
Confidential
Programmer/ Analyst
Responsibilities:
- Maintenance and enhancement of existing Visual Basic 6.0 and Web applications (BRC 2kAire, PMS Tracking System.
- Online Initiatives, BRC Export, MRLCP3 - Clinical Trial Home, MICZR5 - Zocor Rebates, Impact, Trex2 - Rebate system, using HTML, VBScript, JavaScript, Visual Basic 6.0 and the backend database is Oracle 8i.
- Responsible for ongoing maintenance, development and reporting capabilities of all Telerx Visual Basic 6.0 applications.
- Support, development numerous modules and forms in web applications using Active Server Pages, HTML, VB script, Java script, backend database is Oracle 8i.
Software: Microsoft Office 2003, JavaScript, HTML, and Windows XP, MS Visual Studio Suite 5.0/6.0: ADO 2.x, Crystal Reports, Cognos Impromptu, Quest Software Toad, And Oracle 8i.