SUMMARY:

• Cognos BI Developer with around 9 years of experience in core design and development. Expertise in Report designing, Data Warehousing, Testing, Production, Implementation, Troubleshooting and Maintenance, Efficiency, Quality Assurance, Validation and Performance Tuning.
• Experience in the Data Warehouse software like PL/SQL, OWB (Oracle Warehouse Builder), SQL Developer, SQL Loader, SQL *PLUS, TOAD.
• Experience in failure analysis, troubleshooting activities and problem correction.
• Experienced in Cognos 8.4 and Cognos 10.2 version development (Cognos BI Administration, Query Studio, Report Studio, Analysis Studio, Metrics Studio, Business Insight, Business Insight Advanced, Dashboards and Framework Manager, Transformer, Analytics and Cubes etc).
• Worked on Manhattan Associates WMOS 2011 and SCI 2014.
• Implementation of Analytics into Manhattan Associates SCI.
• Involved in Cognos version upgrades from 8.4 to 10.1, 10.2, 10.2.1.
• Implemented ETL process and reports using SSIS and SSRS.
• Cognos BI Development in business requirement analysis, application design, data modeling, development, implementation and testing of data warehousing and database business systems in various domains including Healthcare and Supply Chain. Also involved in performing calculations and studies.
• Strong skills developing DMR models in Framework Manager and dimensional reports in Report Studio.
• Skilled at users to use Query Studio and Report Studio, Cognos Workspace.
• Experience in gathering requirements, designing layer, high level & detailed report designs.
• Experience in programming as an Oracle PL/SQL Developer.
• Developed Complex database objects like Stored Procedures, Functions and Packages using SQL and PL/SQL.
• Involved in all aspects of Software Development life Cycle (SDLC) which includes analysis, design, development and testing.
• Created Tables, Views, Constraints, Index and loaded Data into Oracle Tables using SQL Loader and PL/SQL Procedures and packages.
• Experience in Framework Manager Modeling Star Schema, joins, Physical layer, Presentation Layer, developing dimensional hierarchies and publishing packages to Cognos Connection.
• Experience in Developing Prompts, Filters, Cross Tab, Graphs, Chart, Dynamic Reports, Multi Query Reports, Ad - hoc Reports, Bursting and Drill-Through Reports in Cognos 10 Suite.
• Extensive experience in Developing Reports by using Calculations, Conditional Formatting, Filters and Cascading Prompts.
• Excellent Knowledge on Data warehousing concepts - star schema, snow flake schema.
• Created Packages and Procedures to automatically drop table indexes and create indexes for the tables.
• Involve in debugging Shell Scripts.
• Interacted with Customers for requirement gathering, effective analysis and also to provide end-user .
• Project management skills and proven knowledge of projects based on software and core industries.
• Hands on experience on projects based on software like Pro-E, Ansys 11, Star CCM+, MATLAB, and Expertise in working with MS office. Also experienced in Implementation and optimization of designs using Pro-E Wildfire computer aided design tool.
• A keen planner and strategist with skills in team building, organization building capability and proven abilities in planning and managing resources.
• Excellent Communication and strong Interpersonal skills with ability to work successfully as a part of team and lead the team as well as client interaction.
• Strong time management and project coordination skills with simultaneous projects and meeting user requirements with uncompromising detail.
• Self-motivated and ability to adapt to new technologies quickly with excellent interpersonal, communication and presentation skills.

TECHNICAL SKILLS:

Technology and Tools;: Cognos 10.x Suite Cognos 8.4 Suite Framework Manager Report Studio Tableau Crystal Reporting Oracle PL/SQL Query Studio SSIS ETL Metrics Studio SSAS Crystal Reports Event Studio SSRS SQL Developer Analysis Studio TM1 Unix / window server MS Office TOAD SQL Loader SQL * Plus Manhattan Associates Supply Chain Intelligence Business Insight Business Insight Advanced Cognos Administration Cognos Content Active Reports Visualization Scheduling Dashboard Store Procedure Packages Cognos Configuration Framework Configuration Cognos Packages Power Play Transformer Informatica Java MSSQL T - SQL Unix shell script Microsoft Projects

PROFESSIONAL EXPERIENCE:

Confidential, Piscataway NJ

Sr. Cognos Developer/WMOS Support

Responsibilities:

• Developed reports through SCI 2014 and SQL for KPIs (key performance indicators) and daily productivity tracking.
• Installation and Implementation of Analytics (Power play transformer cubes) into Manhattan Associates SCI.
• Supported Dashboard for report development, configuring alerts for warnings, and maintenance for update.
• Created multiple KPI reports using Active reporting and visualization.
• Active KPI Report are been delivered to the Presidents and Executive directors of Confidential Inc.
• Developed system for Confidential boutique for advanced shipment Number ASN.
• Created reports and alerts in warehouse to track Inventory adjustments.
• Improvement of preexisting reports by tuning and convert them into active reporting.
• Created SQL to calculate time consumption between manufacturing plant to move the finished good into inventory and active picking location and ultimately to improve inventory movement performance.
• Created manual for users on SCI query studio.
• Delivered demo on active reports and trained users on query studio.
• Manhattan Associates user’s configuration changes.
• Testing on Waving Order, Run Order and Cycle Count.
• Worked on the shipping component to change into SmartBOL to reduce manual effort.
• Clear Understanding of Confidential ’s Warehouse Management by Manhattan Associates.
• Worked under very dynamic environment.
• Requirement gathering from users also closely coordinate between vendors in any issues.
• Identifying areas that can be improved.
• WMOS support on pick season in case of any issues in warehouse operation.

Environment: Manhattan Associates' Warehouse Management for Open Systems (WMOS) 2011, Supply chain Intelligence 2014, Unix, SQL Developer, SQL Plus, SQL, PL/SQL, Oracle v.11g, IBM Cognos BI Suite 8.4 & 10.2.1 Versions: Report Studio, Query Studio, Framework Manager, Powerplay Transformer, Analysis Studio, IBM Cognos Configuration, Cognos Content Store, Cognos Administration.

Confidential, Richmond VA

Systems Development Specialist

Responsibilities:

• Developed the form system using Framework manager, stored procedure and report studio so user can update/merge/insert into database using Cognos Reporting tool this results in drastically reduction in manual work and errors.
• Develop complex ETL mapping processes for the system using Informatica for developing complex ETL processes, including retrieving/transferring and loading data.
• Responsibilities include requirement gathering, analysis, design, development and testing of job processes also Unit Testing.
• Installation and configuration of OWB (Oracle Warehouse Builder), Oracle, SQL developer, SQL loader, Cognos 8.4 and 10 versions and framework managers.
• Know the business process and apply appropriate business rules to develop processes.
• Created database layer, physical layer and presentation layer defining relationship between query subjects.
• Setting up cardinalities to suit the business needs.
• Created new system using Report Studio which reflect the Metrics Studio Functionality this end up in cost saving.
• Create SQL Scripts, Stored Procedure and Functions. Scheduling the Store procedure using SQL Developer and oracle utility functions.
• Coded Stored procedures and PL/SQL scripts to load, update and merge data tables using SQL Developer.
• Worked on SQL*Loader to load data from flat files obtained from various sources also Build import rules.
• Create complex queries testing and validation of Ad-hoc report. Involved in testing, debugging and deployment of the application.
• Created the test cases and performed unit testing using for any modules.
• Experience in creating master details reports using drill through definition in report studio.
• Involved in maintenance and load the metrics values for service level agreements (SLA) in metrics studio.
• Involved in analysis of business requirements in Query studio for its best possible output.
• Creation and contribution to technical specification documentation of development projects.
• Know the business process and apply appropriate business rules to develop processes.
• Created Model Query Subjects, Data Source Query Subjects and Customized data by adding Stand alone and Embedded filters in Framework Manager.
• Developed hierarchies and measures to support Ad-hoc Reporting, Multi-Dimensional Reporting.
• Created several different types of Ad-hoc Reports like Simple List, Grouped List, Section Heading, Cross tab and Nested Cross tab and represented data graphically by Charts utilizing Query studio.
• Created Prompt Pages and Cascaded input Prompts to display only the selected entrees in the report.
• Created Value Prompt, Text box Prompt, Select & search Prompt, Date & Time Prompt, Tree Prompt.
• Creating Page breaks using Page set property, Conditional Rendering on reports using Render variable
• Developing Drill-Through reports to navigate from a parent report to its associated child reports or target reports.
• Applied Master-Detail Relationship on reports to easily migrate from a Master report to its associated Detail report.
• Extensive knowledge on My Data set. Publishing Data Set packages as source of Excel files and set up security based on individual user groups.
• Estimate and plan development work, track and report on task progress, and deliver work on schedule.
• Firsthand experience in migration project when Cognos upgraded from 8.4 to 10.x version.
• Experience with Cognos version upgrades.
• Developed a Framework Manager model by importing Meta data, preparing business logic, setting up object level security and developing and publishing package.
• Handled object level security in FM level; Security is applied to all levels of hierarchy in the model which includes package, Folders, Query Subjects and Query Items.
• Worked with Business Intelligent (BI) and data warehousing and Hands on experience with Oracle relational databases.
• Designed and Implemented new dashboards using Portlets pages and Cognos workspace.
• Involved in configuration changed for Cognos BI based on the user requests. Developed Active reports for users to use offline also RAVE dashboards.
• Designed and Implemented metadata models in Framework Manager and Power play cubes in Transformer
• Established an audit reporting system for the internal team to monitor, analyze performance and usage of different reports.
• Successfully designed and implemented security on different levels including object and low level security.
• Worked closely with different business teams to gather requirements, prepare functional, technical documents and UAT Process.
• Provided to different business users to develop dashboards using Business Insight/Advanced in workspace and workspace advanced also create User Manuals for users.
• Designed and implemented various Materialized Views in Oracle to use in Cognos Reporting.

Environment: SQL Loader, SQL Developer, OWB, SQLServer 2005, TOAD, SQL Plus, SQL, PL/SQL, Oracle v.10g, v.11g, IBM Cognos BI Suite 8.4 & 10.1 Versions: Report Studio, Query Studio, Framework Manager, Analysis Studio, Metrics studio, IBM Cognos Business Insight, Business Insight Advanced, IBM Cognos Configuration, Cognos Content Store, Cognos Administration.

Confidential, Piscataway NJ

Programmer Analyst

Responsibilities:

• Extensively worked on PL/SQL for creating triggers, stored procedures and Complex Queries.
• Hands on experience in Migration of Data from Excel files to SQL 2005 using SQL Loader by creating scripts.
• Experience in cubes, dashboards, scorecards and reports using Framework Manager, Transformer, Report Studio, Query studio, Metric studio, Analysis Studio, and Power Play.
• Experienced in Informatica for developing complex ETL processes, including retrieving/transferring and loading data.
• Work with dimensional data warehouses in Star and Snowflake schemas.
• Installation and configuration of Oracle Warehouse Builder, Oracle, SQL developer and SQL loader in local for web portal development team.
• Generated complex reports using Cognos Reporting Tool also involved in validation of report using SQL Developer and performance tuning of Cognos SQL.
• Analyze and Create reports using Query Studio and Report Studio. Bursting Reports and using Report Studio and Query Studio.
• Experienced in creating complex reports using Report Studio & performing ad-hoc queries using Query studio.
• Experienced in Complete Data Warehouse and Framework Manager to develop Cognos reports.
• Involved in prompts, drill-through, master-detail query relationships, conditional formatting, grouping and sorting features of Report Studio also end user and support.
• Experienced in Decision Stream, portal, dashboard and report development using analysis.
• Analyze and troubleshoot the issues regarding performance.
• Scheduled reports and with different output formats.
• Developed advanced dashboards for users for different departments weekly dynamic Activities. Implemented reports in Report Studio using dimensional and relational models.
• Developed models in Framework Manager and Power play Transformer. Provided to power users in Dashboards, Query Studio and Report Studio.
• Worked on performance tuning of existing reports and dashboards. Estimate and plan development work, track and report on task progress, and deliver work on schedule.
• Developed dynamically build the visible prompts by filtering the corresponding hidden prompts with those values currently selected.
• Implemented Dynamic Filters and Dynamic sorting functionality to give users ability to sort and filter the data in Report Viewer.

Environment: SQL Loader, SQL Developer, OWB, IBM Cognos BI Tool, SQL Server 2005, Oracle Data base Oracle v.10g, IBM Cognos BI Suite: Report and Query Studio 8.4, Framework Manager 8.4, Analysis Studio 8.4, Metrics studio 8.4, IBM Cognos Business Insight, Dashboards.

Confidential, Bridgeport, CT

Teaching Assistant

Responsibilities:

• Performed a variety of administrative tasks including preparation of Power Point presentations, data entry and analysis, web site development, collating marketing materials and presentations.
• Assisted a faculty member with grading of student assignments. Lead a discussion section.
• Posted materials in "My Courses" and respond to students' questions posed verbally and electronically.
• Assisted in grading student work, Tutor students, Assisted with the administration of a course.
• Conducted 4 hours per week of classroom instruction.
• Facilitate projects in an office with other students; served on short-term college project teams.

Confidential

Jr. Program Analyst

Responsibilities:

• As a developer, responsible for the Decision making support solutions using reporting tool that provides accurate, actionable information for the management.
• Experience withleadershipandtechnicaldirectionas a team.
• Explores the multi-dimensional data into powerful Impromptu reports and Attended business sessions with the business users.
• Involved in the testing of manufacturing products also the stress analysis using ANSYS and STAR-CCM+ software package.
• Created and maintained Catalogs, Organizing Folders, Prompts, Calculations, Conditions, using Impromptu Administrator.
• Developed reports using Cognos ReportNet based on Business user requirements. Reports are of Sales representatives, including the sales organizations they are assigned to, the territories they cover, and the products they promote. Customers, the territories they work in, and the products they market based on Geography, including territories and their respective regions, zip codes.
• Developed technical document for the metadata model in Framework Manager, which includes all the design elements, design considerations and architectural overview.
• Developed separate document for each report, which provides design specification for each report with Report Net.
• Developed Model query subjects in FM manager and materialized views in the database in order to accommodate the report net requirements.
• Developed reports using Customized prompts, advance filters and conditional formatting.
• Wrote scripts using SQL loader utility to populate the sample data for Unit Testing.
• Used TOAD and SQL Navigator for data analysis and query optimization.
• Created List reports, Sub-reports, Cross-tab reports using Impromptu Administrator.
• Maintaining the material tracking and requirement in data warehouse using SQL.
• Involved in testing of instrumentation equipments data also validating reports.
• Performance tuning and optimizing and evaluated report effectiveness by tuning query data.
• Impromptu reports tuning by eliminating loops and isolated tables in catalogs.
• Packages were created, enhanced and maintained as per the business requirement.
• Created business Models, calculated Measures, and Drill through facility using Transformer.
• Design module and modification of module using AutoCAD and Pro-E.
• Through knowledge and experience of teams including Power Systems and technology.
• Making project reports and maintaining important documents and records. Maintain inspection documents. Man power management and their safety. Also material follow up, conduction vendors and client meeting for target set up and planning.

Environment: Oracle, PL/SQL, TOAD, Report Net, Windows NT, UNIX Shell Scripts, Sun Solaris, Developer 2000 (Forms & Reports), PL/SQL, Oracle, SQL* Loader, ANSYS, AutoCAD and Pro-E and STAR-CCM+ software package.