Business Systems Analyst Resume
SUMMARY
- Multi skilled professional around 12 years of experience in IT, in various roles as a Team lead, Consultant, Business Systems Analyst, Developer, programmer/analyst working for major corporate clients, having in - depth knowledge in system study, design, development and implementation of applications in Business Intelligence and Client/Server technologies.
- Over 7 years of experience in design, development and deployment of Data Warehouses/Data Marts, Database Development, Logical Data Modeling, Physical Schema mainly using MicroStrategy V 9/8/7, Cognos 8.x/7x, Brio/Hyperion 6.x/8.x, Business Objects 6.x/XI, Informatica 8.x/7.x, Oracle, Teradata, DB2...
- Good Experience with MicroStrategy 7.X/8.X/9.x, MicroStrategy (Desktop, Web), MicroStrategy Intelligence Server, MicroStrategy Narrow Cast Server.
- Good understanding on Microstrategy SDK, Microstrategy Mobile and Freeform SQL
- Well experience in application tuning and security using all Admin tools like Command Manager, Object Manager, Enterprise Manager, Integrity Manager, Health Center, ScanMD, MD Doctor...
- Very well at Report Services Documents, Dynamic Dashboards design, development and Intelligent cube design
- Experience using Advanced datawarehouse design patterns of Microstrategy Best practices
- Extensive experience in Generating well tuned MicroStrategy reports and implementation of MicroStrategy projects.
- Well experience on Narrowcast Server to create objects like Services, Schedules, Subscriptions, Information Objects, Question Objects, Publications and Documents to distribute personalized business information to users via email, Web and file services.
- Defined and Created Microstrategy Reports, Documents by Creating Projects, Schema Objects(Attributes, Facts, Hierarchies), Public Objects(Metrics, Filters, Prompts, Drill Maps, Custom Groups, Consolidations, Reports, Documents and Templates), Project Objects(Security Filters)
- Good experience working with Cognos 8.x (Cognos connection, Report studio, Query Studio, Analysis Studio, Metrics Studio, Event Studio), Framework Manager, Transformer, Cognos Reportnet (Cognos connection, Report studio, Query Studio), Cognos 7.x (Impromptu, Powerplay, Transformer, Server Administrator).
- Well experience Creating DMR Models for the cubes and report development purpose using Framework Manager
- Good experience in generating well tuned reports using BusinessObjects 6.x/XI (Supervisor, Designer, Desktop Intelligence, WebIntelligence, Broadcast Agent etc)
- Good experience in developing reports using Brio/Hyperion Brio(Brio Explorer/designer, Insight/QuickView and Server Administrator(BroadCast Server and OnDemad server)
- Extensive experience in ETL methodology for supporting Data Extraction, transformations and loading processing, in a corporate-wide-ETL Solution using INFORMATICA (Power Mart/ Center 4.7/5.1/6.2/7.1/8.x, Meta Data Repository, Designer, Server Manager) and knowledge on Data Stage.
- Experience using ERWIN 4.0/4.1 as leading data modeling tool for Logical (LDM) and physical data model (PDM).
- Good experience in design and development of Data warehouse & Business intelligence solutions using BI tools like MicroStrategy, Cognos, Business Objects, Hyperion Brio and Informatica.
- Hands on experience on Java J2EE Technologies like Servlets, JSP, XML, XSL, XSLT and EJB.
- Proficient in Analysis, Design and Development of applications using ORACLE, Teradata, DB2, SQL Server, and MS Access.
- Good understanding of Hyperion tools like Hyperion (Essbase, Planning, Analyzer, Reports), Cognos Planning (Contributor, Analyzer), SSIS and SSRS.
- Good Analytical, Programming, Written and Verbal Communication Skills.
- Good understanding of all different domains like Finance, Banking, Insurance, Auto mobile, Healthcare and Retail.
- Quick learner Self-motivated, Team leader, player and have experience in different phases of System Life Cycle including Analysis, Design, Coding, Testing, and Implementation.
- Good experience in creating Project Plan, Technical & Functional specs, Conducting Business user Meetings for requirements gathering etc
- Good working experience in Onsite/Offshore model
TECHNICAL SKILLS
Area of Expertise: MicroStrategy 7.X/8.x/9.x, Cognos7.x/8.x, Brio 6.x/8.x, Business Objects 5.1/6.5/XI, Informatica PowerMart 4.7,PowerCenter 5.1/6.2/7.1/8.0, ERWIN 3.5/4.0/4.1, JAVA (JDK1.2/1.3), Enterprise JavaBeans, JSP, ASP, XML, XSL&XSLT, JDBC, JNDI, JFC Swing, java Script, Servlets, CORBA, MQ-Series, Oracle, People Soft (ERP)
BI Tools: MicroStrategy Product Suite 7.x/8.x/9.x (MicroStrategy Desktop, Architect, web, Agent, Intelligence Server, Narrowcast Server), Microstrategy(Object Manager, Command Manager, Enterprise Manager) Brio/Hyperion Brio (6.x/8.x). Business Objects 5.x/6.5/XI R1/R2, Web Intelligence, Cognos impromptu, Transformer, Powerplay 6.5/7.x, Cognos Reportnet1.1/1.0, Cognos 8.x
Data Modeling: ERWIN Platinum 4.0/4.1.
ETL Tools: Informatica (PowerMart 4.7, PowerCenter 5.1/6.2/7.x/8.x), DataStage 6.5
Design Tools: Rational Rose98, 2000 using Java, TogetherJ 3.2
OO Methodologies: Unified Modeling Language (UML)
Web Servers: Personal Web Server, IIS, and Java Web Server
Application Servers: Weblogic Application server 4.5.1/5.0, ATG Dynamo Application server 4.5, Jrun, Websphere Application Server 3.5/4.x
IDES: Symantec Visual Café 3.0, VJ ++ 6.0, JBUILDER 4.0, Visual age 3.5
Tools: Visual Interdev 6.0, MS-Front Page, Xml Spy 3.0/3.5
Operating System: WIN 95/98/2000/Me, XP, WIN NT 4.0, Sun Solaris
Languages: JAVA, C, PASCAL, COBOL, SQL, PL/SQL
RDBMS: Oracle 7.x/8.0/8i/9.x/10g, MS SQL Server, MS Access 97/2000/2005, Teradata V2R4/5/V12, DB2 UDB 8.X
GUI: Developer/2000, Report Builder
Data Base Connectivity: ODBC, JDBC
Web Technologies: HTML, DHTML, XML, XSL, XSLT, ASP, JSP, JavaScript and VBScript.
