Software Engg. Senior Analyst Resume
Cincinnati, OhiO
SUMMARY:
- BI Developer with almost 7.5 Years of experience in full life cycle development involving analysis, design, development, deployment, testing, implementation, maintenance and Support of large data warehouse applications in Web - based and Client/Server environment.
- Expertise in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 8/10.1/10.2, and Cognos Report Net.
- Experience in IBM Cognos 10.1 and 10.2 BI (Framework Manager, Report Studio, Query Studio, Metric Studio, Analysis Studio, Active reports, Business Insight, Work Space advanced.
- Expertise in designing and creating various analytical reports to help users to identify critical KPIs and facilitate strategic planning in the organization using Cognos. Good Experience with MDX Functions in Report Studio using Multi-Dimensional Sources
- Extensive work on Data Extraction with Oracle (8i, 9i and 10g), SQL Server & MS-Access.
- Experienced in Developing Data Marts, Star Schema, Snowflake Schema, Extract, Transform, and Loading of Data, Requirement Gathering, Analysis, Design, Development, Testing, Documenting and Implementation of Business Applications.
- Extensively worked on Tableau 9.x/10.x (Desktop, Server & Reader)
- Three years of experience in Tableau Desktop, Tableau Server in various versions of tableau including Tableau 8x and Tableau 9.0, Tableau 10x.
- Extensive Tableau Experience in Enterprise Environment and Tableau Administration experience including technical support, troubleshooting, report design and monitoring of system administration parameters.
- Experience in Data Warehousing and Business Intelligence area in various domains.
- Strong hands on experience implementing dash boarding, data visualizations, and analytics using Tableau desktop and Server.
- Expert in Data Visualization development using Tableau to create complex, intuitive, and innovative dashboards.
- Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
- Preparing Dashboards using calculations, parameters in Tableau 9 and involved in creating dashboards and reports in Tableau 10.1 Created report schedules on Tableau server.
- Proficient at developing and implementing training programs to enhance the efficiency, competency and motivation levels of the employees in line with organizational objectives.
- Ability to write and maintain technical documentation to describe Reports development, logic, coding, testing, changes, and corrections.
- Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem solving skills.
- Proficient in setting up IIS server website / Setting up Virtual directories / Knowledge of installing IIS certificates etc.
TECHNICAL SKILLS:
Reporting Tools: Cognos v11x/10x/8x BI Suite (Framework Manager, Cognos Connection, Query Studio, Dynamic Cubes, Active Reports, Work Space advanced, Business Insight, Cognos for MS Office, Cognos Analysis for MS Excel, Report Studio, Analysis Studio, Power play Transformer, Power play, SQL Server Reporting Service (SSRS) Windows/Web, and Upfront, Tableau 7.x/8.x/9.x Desktop and Server.
Programming Skills: R programming, JavaScript
ETL Tools: Data Stage, SSIS and Cognos Data Manager
Databases: MS SQL Server 2005/2012, Oracle 9i, 10g/11g
Web Servers: IIS, Tomcat and Apache
LDAP Servers: Active Directory.
Operating Systems: Windows 2003 Enterprise Server, UNIX, Windows XP/7 /8.
PROFESSIONAL EXPERIENCE:
Software Engg. Senior Analyst
Confidential, Cincinnati, Ohio
Responsibilities:
- Re-design the complete Cognos Security model for Sales and Procurement with BI process Lead.
- Automate the jobs with the help of SQL stored procedures which helped to give all AUDIT information related to Cognos environment like When the report was created, Created by, Last executed by, date, counts etc., without any third part tool. This info is not available with IBM also.
- Worked and installed IBM suggested tool MOTIO PI.
- Migration of SSRS report to Cognos Report
Confidential, Cincinnati, Ohio
BI Consultant
Responsibilities:
- Migrated the SQL server from V2010 to 2014 R2.
- Migrated few reports and Dashboard from Cognos to Tableau.
- Responsible of successful Migration as BI Team Lead.
- Cognos Migration from 10.2.1 to 10.2.2
- Data stage (ETL) Migration from 8.5 to 11.5
- Working as BI Technical lead with reporting of 5 developers including offshore.
- Responsible for several monthly reports submitted to management.
- Responsible to monitor ETL (data stage) and SQL agent jobs which are feeding data from SAP.
- Setting up IIS server website / Setting up Virtual directories / Knowledge of installing IIS certificates etc.
- Created multiple critical visualization and dashboard for the higher leadership.
- Introduce new visualization tool i.e. Tableau
Confidential, Cincinnati, Ohio
Cognos Consultant
Responsibilities:
- Created TOP 20 customer dashboard with Live RSS feed.
- Created Risk heat map report for the senior leadership and investors.
- Created and maintaining Revenue dashboard for Leadership.
- Created Multiple FM models including Sales, Procurement, Direct - Indirect spend and treasury
- Interacted with Client’s Demand Manager who provides the consolidated requirements from the users to understand the Report’s functionality
- Organize and drive all the client meetings for requirement analysis and development strategies as a data management analyst.
- Preparing data model and development strategy documents
- Development and modification of FM models and Cognos report studio reports and dashboard development
- Provided the detailed analysis of Pending and delayed policies using Cognos Reports
- Educated business users on ad-hoc reporting using the specified metadata
- Worked with management to generate reports that compared a variety of financial needs with revenue flow.
- Monitored and maintained data elements in SQL in-house built database system as a data management analyst.
- Created Data Level, Object level, Package level and Row Level Securities in Framework Manager Models
- Worked on Data Analysis, validate reports and find data quality issues.
- Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
Technology: Tableau, Cognos Report Studio 10.2.2, 11, Cognos Framework Manager 10.2.2, IBM Data stage (ETL), SQL server 2008R2
Confidential, Charlotte, South Carolina
Cognos Consultant
Responsibilities:
- Interacted with regional Service Delivery Lead to understand the new business requirement or enhanced the existing cubes and reports
- Prepared Technical Design as per the functional requirements
- Created ETL jobs after applying the business logic to extract the raw data from ERP to relational database SQL server 2005
- Developed Power play transformer cubes and Report studio reports for different regions to depict best view of their sales and inventory
- Educated users on comparing the budget data with actual data using Cognos cubes and Analysis studio reports responsible for developing dashboards and data solutions
- Design, build, and deliver new reports.
Confidential, Charlotte, South Carolina
Cognos Developer
Responsibilities:
- Gathering, understanding and analyzing the requirement in detail.
- Regularly updated company database programs to include new data gathering needs as a data management analyst.
- Developed a report that help the logistics team to cut down the shipping costs.
- Generating Cognos reports and dashboards as per client requirement.
- Responsible to develop, monitor ETL (data stage) and SQL agent jobs.
- Carrying out Unit testing of developed reports.
- Maintaining and modifying the existing Cognos reports and dashboards.
- Creating new and modifying existing Framework manager models.
- Created some critical visualization and dashboard for the higher leadership.
- Developing and customizing metadata packages from data warehouse using Cognos Framework Manager.
- Responsible for developing dashboards and data solutions.
- Design, build, and deliver new reports and visualization
Confidential, Charlotte, South Carolina
Cognos Developer
Responsibilities:
- Installed and configured Cognos and development work was being done in Windows-based Cognos 8.
- Developed 45 Report Studio reports
- Gathered business requirements by conducting user interviews and documented their query, business analysis and reporting needs.
- Worked with the ETL Datastage team, suggesting the transformations required for reporting and also the getting the data calculation and data items created at the database level.
- Involved with the ETL Datastage team in data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
- In Framework Manger Database layer resembles mostly Star Schema (sometimes worked with views and stored procedures) and business view includes user understandable tables and columns.
- While creating Framework Manager Model, worked on different possibilities like segmentation, links and shortcuts etc., to get the best model for the business.
- Created stored procedures and views and imported into Framework Manager to create some complex reports.
- Extensively used conditional block sections for creating multiple queries in a single Cognos Reports for reuse and layout.
- Responsible for creating the Cubes and Reports and Scheduling them accordingly
- Worked on complex reports using Static Prompt and mdx functions and union conditions
Environment: Cognos 8, Series7 (PowerPlay Transformer, Upfront and all Server Administration), Datastage, Tomcat 5.1 application Server, Java, DB2, PeopleSoft HR/Financials, UNIX (AIX).
Confidential, Charlotte, South Carolina
Cognos Developer
Responsibilities:
- Translated functional requirements into reporting requirements and subsequent reports.
- Developed Reports using Cognos report studio to achieve the different functionalities of the
- Created the technical design documents for the functionality requested by the client.
- Created, modified and customized metadata packages from data warehouse using Cognos Framework Manager.
- Responsible for developing dashboards and data solutions.
- Design, build, and deliver new reports.
- Built the entire ETL structure for ETL jobs which loads the updated data on daily basis.
- Monitored and maintained data elements in SQL in - house built database system as a data Management Analyst.
- Created some critical visualization and dashboard for the higher leadership.
Environment: Oracle 9i, Cognos Framework Manager, Cognos Report Studio, Microsoft SQL 2005, Cognos Data Manager
Confidential, New York, New York
Business Analyst
Responsibilities:
- Involved in identifying the unused process and objects.
- Designing the optimized approach by applying filters and dropping unused indexes, constrains.
- Worked along with DBA’s to ensure the indexes and primary keys are used while querying the database
- Involved in the design, analysis and coding and testing support.
- Involved in Implementation by making sure all the new indexes and constraints are properly utilized in the new setup
- Creating new dimensional tables to reduce the usage of look up tables
- Update the changes to FrameWork Model by adding new tables, creating new queries, and mappings to implement the changes in Cognos with minimal model modifications
Environment: Oracle 9i, Cognos Framework Manager, Cognos Report Studio, Microsoft SQL 2005.