Sql Server Pl

Alekanti Lokesh Reddy

Senior Lead BI Developer/Administrator

Ph: 201-***-****

Professional Summary:

12+ years of IT experience. This includes Data Warehousing technologies, Requirement and Data Analysis, Requirements Gathering, Application Design and Development in Insurance, Pharma, Retail, and Healthcare Domains.

Experience in Cognos 11.0.8 Analytics, Cognos 10.2.1, 8 BI and Report Net with Framework Manager, Analysis Studio, Cognos Connection, Report Studio, Query Studio, Matrix Studio, Transformer, and Cognos Configuration.

6 years Hands on Experience with Tableau which include configuration, development, and scheduling of reports. Tableau Desktop 10,9.x/8.x, Tableau Server 9.x/8. x.

Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.

Experience in Cognos 7.x Series with Access Manager, IWR Powerplay, Impromptu Administrator, PPES.

Used Guidewire products like Claim Center, Policy Center for the insurance domain.

Experience in using ETL (Extraction, Transformation, and Loading) utilizing Informatics 7.x (Power Center).

Worked extensively with complex mappings using expressions, Routers, Lookups, ERP source qualifiers, aggregators.

Data mining on data warehouse to fill the business requirements with GRC (Governance, Risk and Compliance).

Expert in creating and publishing packages in the Framework Manager from various data sources. Generated different kinds of reports in Report Net, created templates and multilingual reports.

Created Standard filters, calculations, single select, multiselect cascading prompts, conditions, and Master-Detail Relationship Report.

Expertise in Creating Dashboards, scorecards and Prompt Pages in Cognos Report Studio and Analysis Studio.

Involved in migration of the applications from Cognos EP Series 7 to Report Net and 8BI.

Experience in production support and performance tuning with servers and reports.

Created and published Models on to Cognos Connection Portal.

Extensively worked on Transformer for Data Modeling of the corporate data for building up of Multidimensional Cubes (DMR).

Worked on Peoplesoft to Cognos conversion

Scheduled the reports and performed report bursting.

Created new jobs in Cognos Connection for scheduling a group of reports.

Administration involved Installation and configuration of Cognos servers, implementing security, managing users, user groups and roles in the organization.

Designing multidimensional architecture for Extract, Transform, Load environment with Informatics.

Used MDX functions in Cognos cubes

Extensive experience in Data Warehousing tools including TOAD, Data Modeling Tools like Erwin and PL/SQL Stored procedures, Triggers, packages using Oracle and SQL Server Databases.

Expert in writing complex SQLs and creating views and Tables in database

Experience in Microsoft SQL Server, Microsoft SSIS and SSRS.

Experience in developing applications using Oracle 9.x/8.x/7.x, Forms, Reports, SQL*Loader, SQL, PL/SQL, SQL Server, Crystal Reports 6.0/9/10/XI and MS Access.

Experience in writing the test Plan and test cases for Unit Testing and System Testing.

Good team player with excellent communication skills, analytical and learning new technologies.

Highly motivated, result oriented professional with a short learning curve.

Worked on Smartsheet’s,Power BI and Tableau

TECHNICAL SKILLS:

OLAP Tools: Cognos 11.x,10.x (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Designer, Metric Studio), Cognos Report Net 1.1(MR2), Cognos 7.3 (Impromptu, Power Play, Transformer, Architect, Access Manager, IWR, Power Play Enterprise Server, Visualizer, Smartsheets,Scheduler, Power Prompts, Tableau Desktop 10,9.x/8.x, Tableau Server 9.x/8.x,)

ETL Tools: Informatica 10.2, Data Stage 6.0, Cognos Data Manager, Oracle Warehouse Builder 9.1.X

Databases: Oracle 9i/8i/7.x, SQL server 7.0/2000/2005,2008 Sybase, MS Access 97/00/ XP/03

Operating Systems: Windows 2003 Server, Windows NT4.x/9X/2000/XP and CISCO (IOS), UNIX and Linux. UNIX (HP, AIX), Red Hat Linux

Programming skills: C, C++, SQL, PL/SQL, Java, JavaScript

Microsoft Tools: MS excel, MS word, MS Visio, MS Project, MS PowerPoint

Database Tools: TOAD 9.0

EDUCATION/CERTIFICATIONS:

1P.G.D MISCA from Osmania University, India

2Bachelor of commerce from Osmania University, India

3Cognos Certified BI Author

Professional Experience:

American Electric Power (AEP) Jan 2022 to Till Date

Lead BI Developer/Administrator

Roles and Responsibilities:

Migrated to Cognos Analytics 11.1.7 from Cognos 10.x and Cognos 8.x

Cognos 11.x installed on multi-tier architecture.

Found and fixed Cognos 11 report issues when migrating.

Worked with Smartsheet functional areas like control center, workspaces, power apps, sheets, reports, dashboards, etc

Used Task List, forms, Grids,Projects,Cards for Dashboards in Smartsheet’s.

Used different widgets to create reports.

Interacting with the Business users, documenting their requirements, business analysis, and reporting needs. Data analysis to understand the business logic underlying the requirements.

Created security and deployments (exports and imports).

Migrated Reports and Packages.

Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.

Created folders, filters, prompts, and complex calculations in Framework Manager and Report Studio.

Set up data level, object level and package level security in Framework Manager models.

Used Java Scripts Extensively in Report Studio for the Performance and Out of the Box functionality.

Created warehouse data models using Erwin tools.

Provided training to users on Cognos 11 Reports and new features.

Mercedes-Benz (DTFS) June 2021 to Jan 2022

Lead Cognos 11.x/Developer/Administrator

Roles and Responsibilities:

Upgraded from Cognos Analytics 11.1.4 to Cognos 11.1.7

Managed Linux server installations and configuration

Monitoring daily jobs and reports posting to EOS

Providing user access to roles and groups as per there access requests

Month end activities to run daily, Monthly jobs and posting to EOS and shared drives

New cognos environment setup created when DTFS and MBFS company Split.

Autosys jobs creation and monitoring on daily basis.

Cognos 11.x installed on multi-tier architecture.

Found and fixed Cognos 11 report issues when migrating.

Interacting with the Business users, documenting their requirements, business analysis, and reporting needs. Data analysis to understand the business logic underlying the requirements.

Created security and deployments (exports and imports).

Migrated Reports and Packages.

Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.

Set up data level, object level and package level security in Framework Manager models.

Created warehouse data models using Erwin tools.

Provided training to users on Cognos 11 Reports and new features.

GEODIS America Jan 2021 to June 2021

Lead Cognos 11.x/Developer/Administrator

Roles and Responsibilities:

Migrated to Cognos Analytics 11.1.7 from Cognos 10.x and Cognos 8.x

Cognos 11.x installed on multi-tier architecture.

Found and fixed Cognos 11 report issues when migrating.

Interacting with the Business users, documenting their requirements, business analysis, and reporting needs. Data analysis to understand the business logic underlying the requirements.

Created security and deployments (exports and imports).

Migrated Reports and Packages.

Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.

Created folders, filters, prompts, and complex calculations in Framework Manager and Report Studio.

Set up data level, object level and package level security in Framework Manager models.

Used Java Scripts Extensively in Report Studio for the Performance and Out of the Box functionality.

Created warehouse data models using Erwin tools.

Provided training to users on Cognos 11 Reports and new features.

Alcon, Fort Worth TX Sep 2018 to Dec 2020

Lead Cognos 11.10 Developer

Roles and Responsibilities:

Developed Cognos Reports for government pricing (GP).

Developed reports on different price types.

Used Model N as our source system to match data as part of UAT testing.

Created complex reports with various Cognos functionalities.

Created metadata models for business reporting needs.

Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.

Created folders, filters, prompts, and complex calculations in Framework Manager and Report Studio.

Data mining on data warehouse to fill the business requirements with GRC (Governance, Risk and Compliance).

Created Reports using Pl/Sql Stored Procedures.

Created Data Models using Erwin tool.

Created Cognos reports to help business to identify the any leaks in GRC (Governance, Risk and Compliance).

Used informatics repositories to verify business logics for reporting tables.

Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.

Created folders, filters, prompts, and complex calculations in Framework Manager and Report Studio.

Set up data level, object level and package level security in Framework Manager Models.

Set up data level, object level and package level security in Framework Manager Model.

Created charts, lists and cross tabs, using Report Studio.

Environment: Cognos 11.10 BI (Framework Manager, Report Studio, Data Modules, Dashboards,

Oracle SQL Developer 4.0.3.16.84, Model N, Irwin, PL/Sql

HISD (Houston Independent School District), Houston TX Feb 2014 to Aug 2018

Lead Cognos 11.x/Tableau BI Developer/Administrator

Roles and Responsibilities:

Migrated to Cognos Analytics 11.0.8 from Cognos 10.2.1

Found and fixed Cognos 11 report issues when migrating.

Interacting with the Business users, documenting their requirements, business analysis, and reporting needs. Data analysis to understand the business logic underlying the requirements.

Created security and deployments (exports and imports).

Migrated Reports and Packages using Motio tools.

Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.

Created folders, filters, prompts, and complex calculations in Framework Manager and Report Studio.

Set up data level, object level and package level security in Framework Manager models.

Used Java Scripts Extensively in Report Studio for the Performance and Out of the Box functionality.

Created warehouse data models using Erwin tools.

Provided training to users on how to use BIA (Business Insight Advance) to create Ad-hoc Reports

Motio tools were used to controlled report and Package versions.

Converted all the PeopleSoft data to Cognos reports for the higher management.

Created Report Studio Dashboards and used I frame to tune the performance.

Created Stored Procedures and used in the Cognos Framework Manager.

Used Tableau Prep for cleaning and grouping data.

Define, execute, and interpret complex SQL, PL/Sql queries and create geomean calculations in tableau.

Created HR dashboard report from PeopleSoft for the internal management.

Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop

Created metadata models for dashboard reporting.

Mentored business power users to create reports/dashboards using tableau desktop.

Trained End Users on Tableau & Tableau Prep

Used Data Blending, groups, combine fields, calculated fields, table calculations and aggregated fields and spotlighting to compare and analyze data in different perspectives.

Environment: Cognos 10.1.1 BI (Framework Manager, Analysis Studio Report Studio, Query Studio, Business Insight, Business Insight advance), SQL Server 2008/2005, PL/Sql, Windows 2003 Server, XP, Motio, Tableau 10.X,

Professional Experience:

MCFA (Mitsubishi Caterpillar Forklift America Inc), Houston TX Jan 2013 to Jan 2014

Sr. Cognos 10/Tableau BI Developer/Administrator

Roles and Responsibilities:

Lead technical team through data design, Development, Testing and Implementation in BI Data Warehouse Reporting and ETL environment.

Creating new Framework models and modifying the existing once as per the user requirements.

Deployment activities.

resolving the User issues as part of production tickets

Gathering the requirements and develop new/modify old reports as per the requirements.

New security setup for the client to make a secure environment.

Creating a SDLC process environment as part of improvement process.

Lead and develop technical standards and best practices for the Business Intelligence Environment.

Designed and Developed various analytical reports from multiple data sources by blending data on a single Worksheet in Tableau Desktop

Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.

Used different Mark types and Mark properties in views to provide better insights into large data sets.

Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once

Collaborate with application developers, business owners and operation engineers to ensure the creation of productive Business Intelligence designs and implementations.

Obtaining requirements from the client, experience in working with the customers to determine functionality needs and analyzing requirements.

Cognos upgrade from 10.1.1 to 10.1.2.

Published Workbooks and Dashboards to the Tableau server.

Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and Worksheets using Tableau

Analyzing reporting needs and designed the solutions in report studio.

Implemented security by creating roles & web groups, checks with LDAP Authentication in Tableau

Environment: Cognos 10.1.2 BI (Framework Manager, Analysis Studio, Event Studio, Report Studio, Query Studio, Business Insight, Business Insight advance), Tableau 9.x, SQL Server 2008/2005, Windows 2003 Server, XP, TFS Version Control.

Alcon Laboratories Inc, Fort Worth TX May 2012 – Dec 2012

Sr. Cognos 10 BI Developer

Roles and Responsibilities:

Worked with the ALCON for developing Sales and Marketing Dashboard reports for the Vision Care Project. Worked on Requirement gathering, Framework Manager Modeling, Dashboard Report development.

Implemented Agile methodology for Vision Care project.

Developed Vision Care Dashboard at various levels Territory, District, Region and Division.

Developed reports with complex logics for the Vision care sales Dashboards.

Used TFS (Team Foundation Server) for version control system.

Worked on Report Studio list, cross tab, repeater, chart, templates, and Drill-through reports

Created calculated data items, layout calculations and query calculations in the reports.

Developed reports with nested queries, nested objects, and variables.

Developed many drills through reports for using parameters, pass values from parent reports.

Worked on unit testing by writing SQL queries against the database to validate reports.

Environment: Cognos 10.1.1 BI (Framework Manager, Analysis Studio, Event Studio, Report Studio, Query Studio, Business Insight, Business Insight advance), SQL Server 2008/2005, Windows 2003 Server, XP, TFS Version Control.

Prudential Insurance, Newark NJ Dec 2010 – April 2012

Team Lead –Cognos 8 BI Developer/Administrator

Roles and Responsibilities:

Extensively worked on 8.3 to 8.4.1 upgrade project.

Developed Portal design for Portal restructuring project.

Developed new security model and implemented as a part of portal Restructure project.

Created new welcome Screen for the Actuarial business users as a part of Portal Restructure Project.

Worked closely with Senior Management for requirements gathering and understanding

needs.

Developed new Cubes using 8.4.1 Transformer for VP Annuities as POC.

Used MDX functions like aggregate, Children, closingperiod, cousin etc.

Leaded the Offshore team for Support and deliverables.

Created Dashboards for business to check the Audit Loggings.

Followed full SDLC process DEV, QA, UAT, PROD

PVCS used for version control.

Used informatica repositories to verify business logics for reporting tables

Used guidewire products Claim Center and Policy Center for the insurance data.

Remedy used for support Tickets.

Developed DMR and Relational models in Framework Manager.

Interacting directly with the business to understand their requirements.

Implemented SSAS Cubes for the Business.

Implemented SSIS packages.

Automated SSAS cubes processing through Autosys.

Supporting all SSAS Enhancements for the business.

Supporting all Cognos Enhancements for the business.

Environment: Cognos 8.4.1 BI (Framework Manager (DMR), Analysis Studio, Event Studio, Report Studio, Query Studio, Power play studio), Informatica ETL, Oracle 11, Claim Center, Policy Center, Windows 2003 Server, XP, PVCS Version Control, SQL Server 2005, SSIS, SSAS.

Golfsmith International, Austin, TX Aug 2010 – Nov 2010

Senior Cognos 8BI Developer /Administrator

Roles and Responsibilities:

Upgraded from 32 Bit to 64-bit Cognos 8.4.1 environment.

Installed and configured Cognos 8.4.1 BI in a distributed environment

Installation and configuration of COGNOS servers, implementing security, managing users, user groups and roles in the organization

Worked with Cognos 8 BI Framework Manager Modeling tool to create new dimensions, Measures, and filters.

Worked with dimensional model (DMR) to use Drill up and Drill Down features in Report Studio and Query Studio reports.

Worked on Crystal Reports project to convert the same in new Cognos reports

Created security and deployed entire 32 bit to 64-bit environment using export and import features in Cognos connection.

Created and configured Content store in SQL Server 2005.

Used Data manager 8.4 as ETL tools.

Restored Database Backup for the new content store in 64-bit environment.

Configured Active directory users.

Created repeaters, Master Detail Reports, Cascading Reports, Bursting Reports, Query Prompts, Calculations, Conditions and Filters in Report Studio.

Scheduled and Distributed reports using Schedule Management in Cognos Connection

Created Dashboard reports for the senior Managements using pages and portlets.

Created complex reports which made use of advance features such as ‘Tabular SQL’ available in report studio

Used Conditional Formatting and Conditional Blocks to display different sets of data based on different conditions

Provided training to users on how to use Query Studio to create Ad-hoc Reports

Provided production support by checking the integrity of the reports in the production environment.

Initiated and started Transformer cubes as a part of performance optimization.

Environment: Cognos 8.4.1 BI (Framework Manager (DMR), Analysis Studio, Event Studio, Report Studio, Query Studio), Oracle 10g, SQL Server 2000/2005, BRIO, DB2, LDAP, IIS 6, Windows 2003 Server, XP.

American List Council, Princeton, NJ July 2008 - July 2010

Sr. Cognos 8BI Developer /Administrator

Roles and Responsibilities:

Installed and configured Cognos 8 BI and worked with Cognos 8 BI modeling, Report Studio and Analysis Studio

Used Metric Studio for developing scoreboards and dashboards.

Installed Report Net Migration Tool and migrated Impromptu catalogs using impcat2xml command.

Migrated Impromptu reports to Cognos 8 BI using migrate to CRN command and deployed migrated reports to Cognos 8 BI using deploy to CRN command.

Interact with the Business users and documented their query, business analysis and reporting needs. Understood data and business logic underlying the requirements.

Involved in Creating Content store, installation, and Configurations of the Report Net.

Involved in creating security and deployment (exports and imports).

Created Projects, Models, and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.

Created folders, filters, prompts, and complex financial calculations in Framework Manager and Report Studio.

Set up data level, object level and package level security in Framework Manager model.

Tuned cube builds Impromptu Reports and Report Net reports and servers for better performance.

Created charts, lists and cross tabs, using Report Studio and ad hoc reports using Query Studio.

Provided security to the Report Net in Access Manager through LDAP Server and configuration settings in Cognos configuration.

Used JavaScript for validations.

Used JavaScript for removing dotted lines in a prompt and in creation of layouts.

Modified Power Cubes by adding new Dimensions, Levels and Measures.

Used MDX functions like count, Currentmember, default, firstchild etc.

Scheduled and Distributed reports using Schedule Management in Cognos Connection.

Provided production support by checking the integrity of the reports in the production environment

Involved in Unit testing and System testing for the Created reports

Documented to describe entire flow of the applications, program development, logic, coding, testing, changes, and corrections.

Environment: Cognos 8.2 BI (Framework Manager, Analysis Studio, Event Studio, Report Studio, Query Studio), COGNOS ReportNet1.1 (Framework Manager, Report Studio, Query Studio, Cognos Connection), Cognos Series 7 Version 3, Access Manager, Oracle Migration Utility, PL/SQL, Oracle9i/10g, Teradata, SQL Server 2000/2005, TOAD 9.0, BRIO, DB2, LDAP, IIS, UNIX and Windows 2003 Server, XP.

Intelligroup, Hyderabad, India Oct 2005 – Oct 2007

Cognos Developer

Roles and Responsibilities:

Responsible for interacting with users and develop reports for standard reporting and ad hoc requests using Powerplay.

Proficient in requirements gathering, Workflow Diagrams, process flows, technical documentation, managing requirements and requirements analysis; Experience with Use Case design and analysis.

Modeling data from SAP BW according to the requirements using Framework Manager.

Developed Query Subjects, Query Items and added filters to customize data.

Analyzed joins in Framework Manager to improve performance of reports.

Published Packages to Cognos connection for use in both Report Studio and Query Studio.

Converting all existing Crystal Reports to Cognos Reports.

Developed Standard List reports, Cross tab reports and Chart reports.

Implemented Drill Through, Prompts and HTML text for better utilization of reports.

Creation of complex Report Studio reports using Conditional Blocks, Conditional Layout and Sections.

Worked extensively on Powerplay Transformer to generate cube for OLAP analysis.

Used various kinds of Date Functions to analyze measures over a period.

Involved in design of Multi-Dimensional cubes to analyze performance parameters.

Deployed Powerplay Reports for both Powerplay for web and for use in Excel.

Scheduled reports for running at a certain time, such as week, month etc.

Environment: Cognos Report Net 1.01MR1/1.02MR2 (Framework Manager, Report Studio and Query Studio), Cognos Transformer 7.0, Cognos Powerplay 7.0, Powerplay Enterprise Server, and Windows NT/2000, UNIX, SAP BW, Oracle 9i, forms.

References: Available on Request.

Contact this candidate