| Skills Abilities | - 7 years SSRS reporting experience: 1 knowledge of creating stored procs, 2 using Visual Studio 2008 R2 to design reports .rdl , 3 knowledge of deploying reports to Reporting Services Server, 4 knowledge of major facets of report design including headings, footers, detail lines, drill-down, and charts. Gather requirements from end-users from start to finish.
- 3 years OBIEE Answers experience: 10g, 11.x g . 1 ad-hoc reporting and delivery to end-users via Excel, 2 dashboard creation of analyses reports , dashboard creation, links, and Delivers delivery. Knowledge of administration tool to view running queries, monitor database loads, etc.
- Expert knowledge of MS Office, Excel, Word, Outlook, etc.
- Databases: MS SQL Server 2008 R2, Oracle OBIEE 10g, 11g.
- Operating Systems: MS Windows 2007 Enterprise, Windows 8.1.
|
| Experience | Sr. business intelligence data analyst, Confidential - Responsible for full lifecycle Business Intelligence BI development, using Microsoft SQL Server Reporting Services 2008 R2 , and using BIDS Business Intelligence Development System .
- Designed ad-hoc reports, dashboard reports, and similar reports using OBIEE Oracle Business Intelligence Enterprise Edition . Performed minor administrative duties creating folders, monitoring jobs , and security related tasks.
- Collaborated with development teams, infrastructure, and business users to deliver product through highly iterative intra-week cycles.
- Communicated with internal clients in order to understand business processes, gather requirements, and coordinate ongoing iterative development.
- Analyzed, designed, developed, and documented BI solutions based on Scottrade standards and best practices.
- Analyzed, diagnosed, and resolved issues.
- Provided higher tier support of production solutions.
- Coordinated with other developers on the team to build and share knowledge, ensuring consistent delivery of information.
- Recommended process improvement ideas based on availability of new technology.
- Performed other duties as assigned.
- Expert knowledge of MS Office, Excel, Word, Outlook, etc.
Databases: MS SQL Server 2008 R2, Oracle OBIEE 10g, 11g. Sr. Programmer/analyst, Confidential - Provided analysis, design, coding, and maintenance of several hundred COBOL batch and online programs.
- Implemented several regulatory projects within project deadlines.
- Utilized analysis/design skills, developed system flowcharts, evaluated and wrote specs, performed programming and analyzed unit tests, which resulted in smooth production implementations.
Sr. Programmer/analyst, Confidential - Designed high volume 401 k statements for both internal and external customers utilizing COBOL on Wang and IBM mainframes.
- Assisted end-users with training of statement report generator, which reduced monthly statement processing time.
|