SUMMARY

• Over 8 years of experience in data Warehousing focused on BI and custom database applications.
• Expertise in Reports Development using Cognos BI product stack wif strong noledge in SDLC phases encompassing requirements, analysis, Design, Development, testing, and production.
• Hands on experience working wif Cognos 10.2 BI Suite (Report Studio, Analysis Studio, Query Studio, Business Insight, Framework Manager, Event Studio), and Cognos 8 series (8.4 - 8.1).
• Experienced on Framework Manager. Created Metadata models 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, multi-page reports, dashboards, bursting, Master/detail, Drill-through, and Query Studio for ad-hoc reporting. As well in Analysis & Event Studio, Cognos Connection, and Administration.
• Experience in trouble shooting report and query problems and performance improvement techniques and skilled in data analysis for complex data sets.
• Proficient in creating complex report against Cubes and DMR.
• Expertise in SQL Server 2005/08 (T-SQL, DML, DDL, Stored Procedures, Functions, triggers, database constraints, and logical & physical design, and Performance tuning.
• Experienced wif Oracle 10g, PL/SQL, Visual Studio Team System, and Cognos transformer. Good noledge 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 Datamarts.
• 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

Cognos 8 & 10 tools: Report studio, Query Studio, Analysis studio Cognos Connection, Business Insight, Event studio, Cognos Administration

Databases: SQL Server, Management Studio, Oracle, Teradata 13

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

Operating Systems: Windows 2000/XP/Server 2003/7

Confidential Tools: MS Office 2010, Project, Outlook, Team Foundation Server

Data Modeling & Tool: Dimensional Data Modeling, Star Schema Modeling, Snow- Flake Modeling, Fact and Dimension Tables, Physical And Logical Data Modeling, Framework Manager, Transformer, OLTP, OLAP, Visio, SQL Assistant

Knowledgeable About: ERWIN, UNIX, VB.NET, IIS, APACHE, SSRS, SSIS, and Informatica.

PROFESSIONAL EXPERIENCE

Confidential, EL Segundo, CA

Cognos Developer

Responsibilities:

• Worked wif 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.
• Developed enhanced reports and standardized them to company template.
• Converted existing pass-through SQL reports to framework model base report.
• Created complex scorecards and prompted dashboards containing chats for number of different metrics against TM1 cubes in company's effort to improved customer experience.
• Created daily, weekly, monthly sales, orders and activation reports for different market segments.
• Perform data analysis and created reports for new hardware and their pilot programs.
• Worked wif 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 wif analysts to study an Oracle base OLTP system to rewrite reports for fraud monitoring department.
• Updated IQD sources for cube and developed MTD, QTD, YTD sales and marketing reports for Pay-Per-View programs.
• Performance tuned badly performing SQL queries and Cognos reports.
• Developed Multi-page reports, Multi-query, List reports, Charts, and Master-Detail reports using 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.
• Customized data by adding the filters, calculations, functions, tuple, sets, and Conditional formatting.
• Created and Organized Reports, Folders and other contents on Cognos Connection.
• Involved in end client discussion to make sure UAT go through successfully.
• Used Teradata SQL Assistant and Oracle SQL developer to create complex SQL queries for pass-through-sql reports and to validate the report's data.
• Responsible for writing various documentations like report specification document and production release forms.

Environment: Cognos 8.3- 10.1& 10.2(Report Studio, Cognos Connection, Analysis Studio, query Studio), Framework Manager, Teradata 13, SQL Assistant, Service Desk, Oracle

Confidential, Camp Hill, PA

Cognos Developer

Responsibilities:

• Reviewed Business Requirements Document (BRD) wif data analysts and project managers.
• Reviewed design documents (PDM), and provided feedback to enhance and the current design to meet customer requirements.
• Created technical specification from Functional specification for FM modeling and Cognos report development team.
• 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 wif 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 organized and formatted reports, folders and other contents on Cognos Connection Portal.
• Created the Bar Charts and Cross tab reports using Cognos Report Studio & Analysis studio.
• Closely worked wif ETL Developers (Informatica), during design, data load and testing phases.

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

Confidential, Pittsburgh, PA

Cognos Developer

Responsibilities:

• Involved in Installation and configuration of Framework manager and Cognos 10 server.
• Worked wif 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.
• Tested the Join Strategy for Framework Manager’s models by creating list reports, and ensured proper auto-grouping and summary are performed as anticipated.
• 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.
• Designed complex dashboards using the Business Insight in Cognos 10.1.
• Customized data by adding the Filters, Calculations, Summaries, Functions and Conditional formatting.
• Created reports using multiple data sources like Packages, personal data files, stored procedures and pass-through SQL.
• Created and Organized Reports, Folders and other contents on Cognos Connection.
• Created Report Views wif saved prompts and Schedule according to the Business requirements.
• Unit tested all the reports and packages built in the project.
• Involved in end client discussion to make sure UAT go through successfully.
• Scheduled reports in Cognos Connection based on the reports to run Daily, Weekly or Monthly basis.
• Used TOAD to run SQL queries and validate the reports, performed Unit and system integration testing (SIT).
• Deployed reports (import-export) from development to QA and then Production servers.
• Responsible for writing various documentations like report specification document and user manual.

Environment: Cognos 8.4 - 10.1 (Report Studio, Cognos Connection, Business Insight, business Insight Advanced, Analysis Studio, Event Studio), Framework Manager, Informatica, TOAD10.0, SQL Server 2008, HTML, Windows 2003/2008, SQL, PL/SQL, T-SQL.

Confidential, Bentonville, Arkansas

Cognos Developer / SQL Server Developer

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 wif managers and technical leads.
• Made changes to the models in framework manager and publish packages.
• 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.
• Created Drill through reports for merchandising department.
• Deployed multiple reports from UAT environment to Production for newly added country in the system and created new data source connections.
• Collaborated wif 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 wif 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 noledge 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 2000/05, 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

Cognos 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.
• Implemented Drill through, Conditional formatting and parameters for customizing the reports.
• 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 wif multiple charts and cross tab reports and drilling down from the graphs.
• Presented data in multiple formats based on requirements (HTML, PDF, and CSV).
• Developed efficient SQL queries and performed Unit Testing to ensure the accuracy of data displayed in the report.
• Trained power users to effectively use the reporting tool to build and customize their ad-hoc reports using Query Studio.
• Preparation of Mapping document for database fields for its source and destination

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 wif 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 wif 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.