It Development Analyst Resume
Houston, TX
SUMMARY
- Around 12+ years of extensive IT industry experience in Data warehousing experience using Cognos 10.x/8.x/7.x, Tableau 9.0, Business Objects XI 4/R3/R2, Designer, Crystal Reports XI/2008, Web Intelligence, SSIS, SSRS and Actuate Reporting 8.x/7.x
- Expert in the development of Universe, Framework manager Model, Packages and reports using Cognos 10.x/8.x/7.x and ReportNet 1.02/1.1 with Framework Manager, Report Studio, Business Insight, Workspace Advanced, Power Play, Cognos Connection, Business Objects(Designer, BODS, Web Intelligence and Crystal Reports) and MS - SSIS.
- Experience in Installation and configuration, Creation of repositories and security domain with user groups and security implementation.
- Strong design and programming technical skills, ability to learn new emerging technologies and adapt quickly.
- Well-versed in developing reporting applications using Cognos Business Intelligence components like Framework Manager, Report Studio, Business Insight, Workspace, Business Insight Advanced, Query Studio, Analysis Studio and Cognos Connection.
- Experience in Creation of Models, Project and Publishing Packages using Framework Manager.
- Good working and practical knowledge in all aspects of SDLC such as requirement analysis, design, development, testing, implementation & maintenance of Projects
- Extensive experience in analysis to design the Universes and Business Objects Reports to support the user requirements.
- Created, developed and deployed SSIS packages.
- Created complex views to overcome loops and contexts. Used aggregate awareness in universes and Created Reports employing functionality like Queries, Slice and Dice, Drill down, Functions, Formulae etc.,
- Good grasp of Decision Support Systems and data warehousing concepts and exposure to Data Mining methodologies and tools.
- Involved in testing universes and reports for correct mapping of the objects and data correctness. Did performance tuning for efficient report generation.
- Proven problem solving skills with excellent analytical, communication and interpersonal skills.
- Ability to work independently as well as a team member.
- Experience in building multidimensional models and creating Power Cubes for distribution using Power Play Transformer.
- Experience on Conditional Formatting using Filters, Report Bursting using Schedulers with the help of ReportNet.
- Excellent understanding of data marts and multi-dimensional models like Star and Snowflakes-Schema Modeling.
- Extensive experience on Transformer Models for corporate data for building Multidimensional Cubes.
- Expertise is in the area software design and programming of Client/Server and Web applications using ASP.
- Experience in coding using SQL, PL/SQL, and Procedures/Functions.
- Worked on different Databases like Oracle 12c/11g/10g/9i, SQL Server 2000/2005, MS Access
- Possessing good understanding of business procedures, problem solving, interpersonal and communication skills.
- Highly motivated team player with an ability to work under tight deadlines and minimal supervision.
- In-Depth industry experience in Telecom, Banking, Financial Services and Insurance.
TECHNICAL SKILLS
Products Tools: Cognos 10.x/8.x (Framework Manager, Business Insight, Business Insight Advanced, Report Studio, Analysis Studio), Tableau 9.x/8.x, BusinessObjects XI R4/R3/R2, Designer, Crystal Reports XI/2008, Web Intelligence, SAP BOData Services 3.0/4.0, Cognos 10.x/8.x/7.x, QlikView 11, MSBI (SSIS, SSRS),NOtA and Actuate Reporting 8.x/7.x
Applications: Java Script, XML, HTML 4.0, ASP
Application Servers: IIS 4.x/5.x/6.x, Apache, Weblogic
Software: Business Objects XI R3/R2, Designer, Crystal Reports XI/2008, WEBI, Cognos 10.x/8.x/7.x, Cognos PowerPlay Transformer, Impromptu 7.x/6.x, QlikView 11, SSIS, SSRS, Actuate Reporting 8.x/7.x and Tableau 8.x
Languages: Java, C++, C, SQL, PL/SQL
Databases: Oracle 11g/10g/9i/8.x, MS-SQL Server 2005/2008 R2, DB2, Netezza and MS Access.
CRM Tools: Siebel 6.x/7.x
Operating Systems: Windows 95/98/NT/2000/XP/2003/7, UNIX
PROFESSIONAL EXPERIENCE
Confidential, Houston, TX
IT Development Analyst
Responsibilities:
- Involved in Analysis and Design of the requirements specification provided by the clients.
- Built Framework Manager Model, and established the cardinalities to suit the business needs and also to enhance the existing Models.
- Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database view and presentation view, defining appropriate relationship between query subjects.
- Created folders, standalone filters, prompts, business calculations and applied Data security using Framework Manager Model.
- Worked with Transformer to create models by using IQD as data source.
- Defined dimensions, levels, measures and calculated members.
- Implemented multiple Time dimensions, Regular dimensions, Calculated Columns, Measures, Calculated Dimensions, Levels, and Manual Levels.
- Generated OLAP Cubes in Cognos Transformer and analyzed the data using Cognos Analysis Studio.
- Extensively used prompts, master-detail query relationships, and summaries, conditional formats, grouping and sorting features of Report Studio to generate efficient and user-friendly reports.
- Created User Classes, Restricting the user access with the help of User Class Privileges.
- Created complex reports using report studio with calculated columns and conditional formatting.
- Designed Complex Dash board reports with multiple tabs and used global filters for dynamic filtering of the data.
- Designed Active reports using various types of objects and also designed Dash Board Reports using Business Insight.
- Involved in unit testing of the reports on verifying the correctness of report data with the data from the back end.
- Monitor and support production issues and resolved them within the deadline based upon severity.
- Enhancing the existing reports as per the new requirement.
- Developed Dashboard reports using Tableau Desktop 9.x.
- Hands on experience in developing & publishing dashboards to Tableau Server.
- Installed and configured the whole Cognos suite In Development, UAT and Production environments.
Confidential
Reporting Analyst
Responsibilities:
- Involved in Analysis and Design of the requirements specification provided by Client and prepared data mapping documents.
- Worked on Cognos10 framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos 8 server.
- Used Cognos Connection as Web Portal for managing reports.
- Creation of Complex Multi-Object Report Studio Reports using Lists, Crosstabs.
- Used Cognos 10Report Studio to create Professional Reports &Query Studio to create Ad-hoc Reports.
- Involved in forming joins, Segregating Tables in Folders according to reporting needs of users.
- Hands on experience in using various query components of Report Studio including Join and Union .
- Created various Prompts and Cascading of Prompt pages, Filters, Calculations and used Conditional Formatting accordingly.
- Worked in designing complex reports in Report Studio.
- Create processes for new system and attend to ad-hoc issues related to day to day activities throughout project implementation and testing phases.
- Schedule, Monitor and Control Access of users by creating groups using Cognos Connection.
- Implemented Drill Through and Prompts for better utilization of reports.
- Creation of complex Report Studio reports using Conditional Blocks and Conditional Layout.