SUMMARY:

• Over 10 years of IT experience focused on BI and custom database applications.
• Expertise in Reports Development using Cognos BI product stack with strong knowledge in SDLC phases encompassing requirements, analysis, Design, Development, testing, and production.
• Hands on experience working with Cognos 10.2 BI Suite (Report Studio, Analysis Studio, Query Studio, Business Insight, Framework Manager), and Cognos 8 series.
• Created Metadata models (relational and DMR) and implemented ‘best practices’ while modifying relationships, resolving the loops, creating database views, business views, and publishing Packages.
• Expertise in Report Studio for advance reporting, Active reports, multi - page reports, dashboards, bursting, Master/detail, Drill-through, workspace Advance, and Query Studio for ad-hoc reporting. As well in Analysis & Event Studio, Cognos Connection, and Administration.
• Worked on the Performance Analysis for the reports created and optimized the reports for performance by creating views and indexes in the database.
• Experience in Performance Analysis, and optimized the reports for performance by creating summary tables and indexes in the database and reducing local processing and prompt query caching, and recommended tuning techniques for very large sets of data.
• Proficient in creating complex report against Cubes and DMR.
• Expertise in Teradata, SQL Server 2005/08 (T-SQL, DML, DDL, Stored Procedures, Functions, triggers, database constraints, and logical & physical design, and Performance tuning.
• Experienced with Oracle 10g, PL/SQL, Visual Studio Team System, and Cognos transformer. Good knowledge of databases, including performance tuning, backup and recovery processes.
• Proficient in Star Schema design methodology, ETL methodology, dimensional modeling, multi- dimensional databases, and modeled Fact and Dimension Tables for the Warehouse using Erwin.
• Involved in development of relational database (OLTP), reporting databases (OLAP), and DataMart.
• Proficient in installation of various Cognos components and SQL Server services on windows environment.
• Expert in all stages of Software development life cycle (SDLC) which includes requirement analysis, Installation, design, development, testing and documentation.
• Excellent communication skills, strong Aptitude to learn new technologies and adapt to new tools/environments.

TECHNICAL SKILLS:

BI tools: Report studio, Query Studio, Analysis studio, Active reports, Business Insight, Cognos Administration, Transformer and Dynamic Cubes, Framework Manager, Transformer, OLTP, OLAP, Visio, SQL Assistant, IBM DB, Business Objects, Excel, Access

RDBMS: SQL Server 2005-12, Management Studio, Oracle, Teradata 13, DB2

Languages: SQL, T-SQL, PL/SQL, VBA, Java Script, HTML

O/S: Windows 2000/XP/7/10- Server 2003

Other: ERWIN, UNIX, IIS, HP Application Lifecycle Management, Service Desk, Office 2016, SQL Assistant, MS Project & Visio.

PROFESSIONAL SUMMARY:

Confidential, Charlotte, NC

Sr. Cognos Developer

Responsibilities:

• Delivered an intuitive departmental report template via java script, classes, and render variables to standardized reporting, improving development time and user experience.
• Performed analysis on the existing data sources design, stored procedures and data security structure to implement report logic and cross reference with business rules.
• Recommended best practices for reports designs, models designs that would meet baseline performance requirements for analytics team.
• Managed & enforced performance thresholds, standards recommendations & tuning results - Eg: Recommending Master-detail query functionality for (pre-run) reports, increasing concurrent connections enabled in On-demand reports by coordinating with operation team and diagnosing the required server changes.
• Improve report performance with advance report design strategies i.e. drill-through, cashing, execution methods, database processing, limiting custom joins, reducing join paths, summary tables, active reports and improve system performance in different layers.
• Coordinated with enterprise database development team to build the aggregate tables using in-database recommendation.
• Developed interactive repots for user consumption, and scheduled report with advance calculations for auto distribution.
• Created interactive dashboards with charts, graphs and drill through reports.
• Executed stress testing for schedule reports to formulate effected strategies better utilize system resources for object using large amount of data.
• Tested results querying SQL Server 2012, and wrote scripts to resolve data quality issues.
• Conducted Analytics team training and instructions on how to create reports views and schedule report and job to attain self reliance.
• Planned and integrated Cognos Configurations setting require to reduce out of the box solution and better development.
• Created mapping source to target document, field matrix, Loading scripts, tables definitions, system performance audit reports.
• Utilize Application Lifecycle Management (ALM) to streamline defect management process.
• Worked with DBAs, Network administrators for data warehouse patch installations.

Environment: Cognos 10.2.1(Report Studio, Query Studio, Administration), SQL Server 2012, Windows 7 & 10, HP Application Lifecycle Management (ALM), Office 2016.

Confidential, EL Segundo, CA

Sr. Cognos Developer

Responsibilities:

• Worked with business analysts and SMEs to understand business requirements and provided solution in different subject matters i.e. Sales and Marketing, Hardware, customer retention, customer experience, Incentive Program.
• Working closely with Data Model and BI architects to make sure we are providing the best practices for the FM modeling for BI reporting needs.
• Used Teradata SQL Assistant and Oracle SQL developer to create complex SQL queries for pass-through-sql reports, SQL for requirement Analysis & to validate the report's data.
• Updated database layer and business layer and defining appropriate relationship between query subjects and tuning models for very large sets of data.
• Developed/enhanced prompted & active reports, standardized them to company template.
• Used Teradata SQL Assistant and Oracle SQL developer to create complex PL/SQL queries for pass-through-sql reports, SQL for requirement Analysis & to validate the report's data.
• Converted existing custom pass-through SQL reports to FM model base reports
• Setup data sources for cubes and Packages in Cognos connection against Cognos power cube, Teradata, and Oracle.
• Configured dynamic cube configuration parameters in server configuration file (Cache Sizing) & published a framework package for reporting using FM application.
• Created complex scorecards and interactive dashboards containing chats for number of different metrics against Dynamic cubes.
• Created daily, weekly, monthly sales, orders and activation reports for different market segments, and worked with Cognos Admins on report deployment.
• Analyzed data models and created report for new hardware and their pilot programs.
• Worked with FM OLAP teams to update Framework Manager Packages and cubes.
• Provided report to engineering department containing list reports and charts related to system usage to improve system capacity as well as efficient load balancing.
• Collaborated with analysts to study an Oracle base OLTP system to rewrite reports for fraud monitoring department. Involved in Teradata SQL review meeting and performance review.
• Updated sources for cube and developed MTD, QTD, YTD sales and marketing reports.
• Performance tuned badly performing SQL queries and Cognos reports and data validations.
• Developed Multi-page reports, Multi-query, List & crosstab reports using sections and render variable, Charts, and Master-Detail reports within Report Studio.
• To reduce the maintenance efforts removed hard coding and made the report dynamic and created prompted reports and their report views that can be scheduled for different distribution lists. Managed multiple priorities, assessed and provided task's ETAs.
• Customized data by adding the filters, calculations, functions, tuple, sets, and complex Conditional formatting. Organized folders and other contents on Cognos Connection.
• Involved in end client discussion to make sure UAT go through successfully.
• Responsible for writing various documentations like report specification document and production release forms and database mapping documents in Excel.

Environment: Cognos 8.3- 10.1& 10.2(Report Studio, Analysis Studio, query Studio, Framework Manager, Transformer, Dynamic Cubes, Teradata, SQL Assistant, Service Desk, Oracle

Confidential, Camp Hill, PA

Sr. Cognos Developer

Responsibilities:

• Reviewed Business Requirements Document (BRD) with data analysts and project managers. Participate in meetings with end-users and different IT teams; perform ad hoc analyses, and provided documentation, training and guidance to customers as needed.
• Reviewed design documents (PDM), and provided feedback to enhance and the current design to meet customer requirements, and created FM model packages.
• Created technical specification from Functional specification for FM modeling and Cognos report development team, and mentored team on technical and functional aspect.
• Tested the Join Strategy for Framework Manager’s models by creating list reports, and ensured proper auto-grouping and summary are performed as anticipated.
• Created standard template to be used for the Healthy-PA Project.
• Involved in adding business rules & defined different kinds of calculations and filters on Query Subjects.
• Performed testing and migration of reports /cubes between environments in releases.
• Developed the List Reports, Charts, Master Detail Reports Using Report Studio and Query Studio. Linked reports by setting up drill-through access.
• Created Static choice value prompts, conditional variable (Boolean and String) and conditional blocks associated with these variables to display / hide columns and queries based in user’s selection in prompt pages.
• Developed prompt pages and conditional variables, creating query prompts, calculations, conditions and filters.
• Created the Charts and Cross tab reports using Cognos Report Studio & Analysis studio.
• Closely worked with ETL Developers (Informatica), during design, data load and testing phases. Query database using PL/SQL for validation and ad-hoc reporting.
• Tested solutions for accuracy of data and reliability of performance, troubleshoot and resolve issues within reports and supported deployment efforts.
• Used TOAD to run PL/SQL queries and validate the reports, performed Unit and system integration testing (SIT).

Environment: Cognos 10.1.2, Cognos Connection, Report Studio, Query studio, Windows XP, SQL, Oracle10g, Informatica, Oracle SQL developer, SQL Server 2008.

Del Monte, Pittsburgh, PA

Cognos Developer

Responsibilities:

• Worked with project managers, business analysts and end users to understand business requirements performed GAP analysis and translating them to technical specifications.
• Developed standard reports and analytics to meet the needs of business analysts.
• Built Relational & DMR Models using Framework Manager and created & published packages to the Cognos Server.
• Redesigned and created new reports according to the user requirements.
• Built ad-hoc and complex reports using prompts, Cascaded input prompts, and parameters in Report Studio.
• Developed Multi-page reports, Multi-query, List reports, Charts, Drill through, and Master-Detail reports using Report Studio.
• Customized data by adding the Filters, Calculations, Summaries, Functions and Conditional formatting.

Environment: Cognos 8.4 (Report Studio, Cognos Connection, Event Studio), Framework Manager, Informatica, TOAD10.0, Windows 2003/2008, PL/SQL.

Confidential, Bentonville, Arkansas

SQL Server Developer/ Cognos Report author

Responsibilities:

• Contributed in impact analysis and documentation of changes in hierarchy in data mart for the Sales and financial reports in Retail Link Portal reporting application (DSS).
• Worked on different phases of software development life cycle (SDLC) including analysis, design, development, testing deployment and production.
• Utilized MS Project to plan, track task process, and assigned tasks to resources based on discussions with managers and technical leads.
• Created list, drill through and crosstab reports for Weekly and Monthly Sales consist of Prompts, Filters, Calculations, and Summaries in Report Studio.
• Created Year-End Reports for year wise data comparison, and YTD, QTD, MTD reports consisting of Cascade Prompt in Report Studio.
• Created trend and Ranking analysis which help in Performance management of the individual vendors and suppliers aiding critical business assessments.
• Deployed multiple reports from UAT environment to Production for newly added country in the system and created new data source connections.
• Collaborated with teams of SQL developer and Data Warehouse to load test data utilizing load utility and SSIS during ETL process upgrade.
• Created data mapping documents and data flow diagrams in excel for ETL process.
• Upgraded SQL jobs and procedures that loaded data to the reporting databases from OLTPs and data Warehouse.
• Documented performance Analysis documents recommending improvements and comparing old and new code for DBA to review.
• Created and modified stored procedures to optimize system performance for Dashboard, Category Financial and Business at a Glance reports.
• Created reports and complex T-SQL queries with using ERF tool.
• Updated around 200 stored procedures to optimize performance, resolving issues concerning temp tables, sub-query, and data types.
• Documented rollout documentation, and perform task distribution to Developers, DBAs and other team members after rollout sign off.
• Rolled out to production, by following change control process in remedy, data and code backups, documented rollout and rollback plans.
• Assisted DBAs during code deployment and performance testing.
• Performed knowledge transfer on any new changes and development.
• Presented the code review walk through to merchandising department, by showing color-coded side by side comparison created in Windiff utility, and implemented their suggestion.
• Performed unit, functional and Integration testing.
• Presented code, new system functionality to technical and non-technical managers.

Environment: SQL Server 2005, Transact SQL, Query Analyzer, BCP, SSIS, VB.NET, Cognos Report Studio, Cognos Connection, Framework manager, Queryman, Teradata, Oracle, Windows XP, UNIX, MS Office (Word, Excel) & Project, Visio, Windiff, SharePoint Server, BMC Remedy IT Service Management Suite.

Confidential,Tucson, Arizona

BI Developer

Responsibilities:

• Evaluated on hand systems to comprehend the business requirement and gather requirement from end users for effective reporting solutions.
• Created a range of Lists, Crosstab, and Charts reports using Filters and Prompts techniques based on requirements.
• Developed new reports using functionalities like layout Component reference to reuse report header and footers.
• Scheduled and Distributed reports through schedule management in Cognos Connection.
• Created standard Calculation, Filters, and Prompts for Ad-hoc queries.
• Created multi page report based on multiple queries using Prompts and Parameters.
• Developed Complex Executive Dashboards with multiple charts and cross tab reports and drilling down from the graphs.
• Trained power users to effectively use the reporting tool to build and customize their ad-hoc reports using Query Studio.

Environment: Cognos 8 - Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Report Net 1.1, DB2, Excel, Windows XP

Confidential, Issaquah, Washington

SQL Server Developer

Responsibilities:

• Analyzed the existing database design, and proposed new schema changes and document to be system.
• Attended client meetings along with business analysts, technical leads to discuss technical design for new features.
• Reviewed Business Requirements Document (BRD) and created technical specification from Functional specification.
• Created logical design, ER diagrams in Visio and mapping the data into database objects.
• As a Site Navigation feature team member delivered Site Navigation and Portal Preview features, and resolved issues regarding inconsistency among Preview, Site Map and Portal.
• Implemented physical design by DDL scripts including tables, views, and changed existing objects to synchronize with changing business rules.
• Modified existing objects and removed redundant object to complement new business process and improve system performance.
• Wrote complex Stored Procedures involving OPENXML and truncations, and Functions to implement Site navigation feature and modified Triggers for the systems alerts.
• Created scripts to transfer data from old schema to new schema, and created data scripts to implement custom error handling and action bar features.
• Tuned the store procedures that were identified as bottle neck in application and used SQL Profiler for activity monitoring to debug the application.
• Used Visual Studio Team System (VSTS) for version control and work item tracking, perform peer code reviews through code review tool.
• Performed unit testing and wrote scripts that can be utilized for automated Unit Testing.

Environment: SQL Server 2005, T-SQL, C#, .NET 2.0, Windows Server2003, Management Studio, Profiler, Visual Studio 2005 Team System, MS Office 2007 & Visio, SharePoint.