PROFESSIONAL SUMMARY:

• 11 years of strong experience in IT industry, with a wide range of experience in Development, Administration of SQL Server databases, Business Intelligence Stack (SSRS, SSIS, SSAS), Data Warehouses.
• Versatile, working in roles as: Cognos Architect, Technical Lead, System Administrator, Senior Cognos Developer and Business Analyst. At times, performing more TEMPthan one of these roles in teh same job
• Expertise in Cognos BI suite (Query Studio, Report Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Connection, Cognos Configuration), Framework Manager, Power Play Transformer, Power Play client.
• Extensive experience in Cognos 11.0.x Cloud Analytics. Worked on Cognos cloud server for faster access to application and centralized administration. Administration experience in Cognos 11.x, 10.x and applied data level and user level security for Framework Manager Packages, reports.
• Leads teh BI and Data Services practice, establishing strategy and resource road map.
• Over 5 years of extensive experience in Tableau 9.x/8.x/7.x of Desktop, Server, Public, Mobile.
• Manage hiring, and retention plans.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Worked as a QlikView Technical Consultant for a wide variety of business applications.
• Proficient in design and development of various dashboards, reports utilizing advanced Tableau Visualizations like Waterfall Charts, Funnel Charts, Donut Charts, Pareto Charts, Dual Axis, Blended Axes and also basic visualizations like Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Geo Maps ( Filled and Symbol).
• Expertise in designing and creating various analytical reports and Automated Dashboards to help users to identify critical KPIs and facilitate strategic planning in teh organization using Tableau SDK architecture.
• 5+ years of strong experience in developing TM1 applications using Architect, Contributor, Perspectives and Turbo Integrator.
• Development of Turbo Integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.
• Maintenance of TM1 users, roles and security, Import teh data from ODBC and Text files using TM1 Turbo integrator.
• Experienced in Data Warehousing technologies, ETL tools/technologies, OLTP, OLAP tools/technologies, T-SQL development, Microsoft Services, documenting, coding, modifying, testing and implementing business technology solutions using MS SQL Server 6.5/7.0/2000/2005/2008 (Yukon), Sybase ASE, DB2
• Experience in creating databases, schemas, tables, views, stored procedures, triggers database structures for data warehousing using SQL Server Database, Sybase Database
• Experience in creating different Ad Hoc reports like drill down, drill through, parameterized, charts etc using SQL Server Reporting Service (SSRS).
• Experience in creating tables, extracting and transforming data from different tables, Databases and Servers to specific Servers using Data Transformation Services (DTS) and SQL Server Integration Service (SSIS).
• Experience in Data warehousing that involves collecting, consolidating and organizing data for reporting and analysis with tools such as SQL Server Analysis Services (SSAS), Online Analytical Processing (OLAP) and data mining tools for providing support to Online Transaction Processing System (OLTP) database.
• Experience in Extraction Transformations and Loading (ETL) tools like Data Transformation Services (DTS), Bulk Insert, and BCP for OLTP and DSS (Data Mart/Data Warehouse) environment.
• Excellent knowledge in Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
• Expertise in BI/Data Warehousing concepts, designs, Tableau SDK architecture and project implementations.
• Experience in using DTS to import data from flat files or an OLE DB data source into SQL Server and export data from SQL Server to an OLE DB data destination like spreadsheet.
• Experienced working with large sets of data (60 million rows), Multidimensional data sets in a Data warehouse/Data Store supporting Data Mart.
• Prepared different P & C (properties and casualties) Data sets and worked on different P & C data models.
• Experience with Database Backup, Restoration and Disaster Recovery Procedures.
• Extensive knowledge of Relational Database Management Systems.
• Working knowledge of Design, Data Modeling, Data loads, Database Integration/Conversions, Performance tuning, Optimization and Logical and Physical Database Design using ERWIN Tool.
• Experience in using version control software like VSS, TFS and PVCS.
• Experience in creating Charts, Pateros using teh .Net language in Chart Directory.
• Experience in creating web applications using ASP.NET Maker.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating Databases/File groups/Files/Transaction logs.
• Well experienced on BCP, DTS packages, Jobs and linked servers for MS SQL SERVER/Oracle/ Sybase databases.
• Excellent in customer interaction regarding requirement gathering and Customer Support.
• Expertise in OLTP/OLAP system study, developing models and publishing packages using different schema concepts. Involved in Installation & Configuration of Cognos.
• Good experience in reviewing Business Requirement Specifications, Software Requirement Specifications, unit test cases and system test cases.
• Expert in creating List, Cross tab, Drill through, Master detail, Dashboard reports.
• Experienced in Transformer model design and Power play cube building.
• Experience in using Multidimensional expressions (MDX) in report studio.
• Expert in dimensionally modeling relational data sources (DMR) Involved in migrating reports from Impromptu to Report Net.
• Experience with Report Net Software Development Kit (SDK) to customize reports.
• Hands on experience administering, deploying and maintaining Models, reports, and Dynamic cubes using Report Net, Impromptu, Transformer, Power Play and PPES.
• Proficient in using best practices to support teh reporting activities. Adept in using performance tuning and optimization techniques such as load balancing, table weighing and partitioning.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

TECHNICAL SKILLS:

Databases: Oracle9i, Oracle10g, SQL, PL/SQL, Toad, DB2, MS SQL Server 2012, MS SQL Server 2008/R2, MS SQL Server 2005 (Yukon) MS SQL Server 7.0/2000, MS - Access 97/2000, Sybase ASE 12/12.5, DB2

Operating Systems: UNIX (Sun 2.8), Linux (Red Hat 6.1) and WINDOWS 95/98//NT/2000/XP, UNIX (AIX 5.2)

Business Intelligence Tools: Cognos 11 Analytics, Tableau (Desktop/ Server/ Public/ Reader), Qlikview 10, Cognos Planning TM1 9.5.2 & 10.1, TM1 Admin, TM1 Developer, and TM1 Trainer, TM1 9.5.1, 9.5.2, 10.2 & 10.2Cognos Report net 1.1, Cognos (Impromptu 7.x/6.x/5.x & Power Play Enterprise Server 7.x/6.0, Access Manager, Architect, Cognos Query 7.0, Transformer 8/7.x/6.6 and), Upfront Impromptu Web Reports (IWR).

ETL Tools: Informatica 9.5, Data Stage

Web Developing Tools: FrontPage, Flash, HTML, JAVASCRIPT, and XML

Web Servers: IIS, Apache, Netscape Enterprise Server, IE

Application Servers: WAS 6.0/5.1, Tomcat, LDAP

Programming Languages: SQL, C, C++, VB, JAVA, XML, ASP and COBOL.

PROFESSIONAL EXPERIENCE:

Confidential, TX

Sr. Cognos Developer / Architect

Responsibilities:

• Installed & Configured IBM Cognos SDK v11.0.5 (On-Premises & Cloud).
• Migrated Cognos content from Cognos 11.0.3 to 11.0.8.
• Customized Sales Module, Forecast Activity, reservations, guest profiles, staffing, back office and payment system integration for Property Management System.
• Involved in analysis, design and gathering of requirement for designing teh new data marts.
• Experienced working with large sets of data, Multidimensional data sources from Oracle and MySQL.
• Worked in an Agile Software Delivery methodology highly focused on developing & enhancing build pipelines for Continuous Integration and continuous deployment.
• Created projects, designed models for reporting and created & published packages in Framework Manager from various data sources CR and RDS.
• Created model query subjects, shortcuts, calculated fields, namespaces, folders and filters in appropriate layers in model to make it simple and more user friendly.
• Conduct troubleshooting, root cause analysis, Data Validation, and problem resolution for Cognos Framework Manager models/packages.
• Created complex, multi-page reports involving prompts, cascading prompts, conditional rendering, and conditional highlighting.
• Design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports.
• Worked on report studio, to create complex reports and dashboards for teh given requirements.
• Created Java Scripts to default teh values in teh Prompts and also to default teh search options for teh prompts in Prompt page.
• Proficient in deploying, managing, and operating scalable, highly available and fault tolerant applications using various AWS services. Experienced in disaster recovery of servers.
• Created and retained backups of EC2 instances by snapshot feature using automated scripting.
• Experience in using elastic load balancer (ELB) and Auto Scaling for elasticity.
• Setup of Auto Scaling of EC2 instances based on Cloud Watch alarms of CPU and memory usage.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Created custom filter to meet reporting needs.
• Enhanced teh performance of teh database by Index Tuning.
• Configure, support and maintain online BI applications and SQL reporting. Involved in performance tuning for Reports and Framework model.

Environment: Cognos analytics 11.0.3 and 11.0.8, Framework Manger, Report Studio, Oracle SQL, AWS Services EC2, S3, EBS, ELB, RDS etc., HeidiSQL, Git, CA Rally, Jira and SQL Developer.

Confidential, Ontario, CA

Sr. Cognos Developer / Architect

Responsibilities:

• Upgraded environment (Dev, Test, Prod) from 10.2.2 to 11.0.x (On-Premises & Cloud).
• Migrated Cognos content from Cognos 10.2.2 to 11.0.x (On-Premises & Cloud).
• Installed & Configured IBM Cognos Client Tools v11.0.x (On-Premises & Cloud).
• Design, develop, and implement Cognos TM1 10.1 Applications for Financial Planning and Budgeting models with complex rules.
• Development of Turbo Integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and cubes.
• Maintenance of TM1 users, roles and security, Import teh data from ODBC and Text files using TM1 Turbo integrator.
• Customized Sales Module, Forecast Activity and Inventory for Finished Goods and Raw Materials.
• Involved in analysis, design and gathering of requirement for designing teh new data marts.
• This QlikView Project is for Finance Department, which includes Bookings, Revenue, Cost and Gross Margin.
• Leading team of five onshore Members, three offshore QlikView developers and one Database Admin.
• Forecasting model is created by using booking, revenue applications and created 4 year Forecast model and successfully implemented in QlikView.
• Worked with QlikView 10.x, SQL Server, Teradata, Excel, CSV files.
• Designed Reports using Conditional formatting to display based on teh prompt selection.
• Created Dataflow and Lookup tables to capture teh functionality of EBS into Adaptive warehouse.
• Created new and updated existing parameters maps.
• Developed a complex financial model that can show case teh company’s potential for future investors.
• Conducted market research on teh newest trends and technologies that insured teh company maintained a competitive advantage.
• Developed business plan presentation for potential investors.
• Planned and directed all functions of teh company - Enforced strong leadership skills to ensure efficient/effective utilization of corporate resources
• Established and integrated teh functional strategies of teh company utilizing business expertise to reach financial/operational goals and objectives.
• Creating and modifying Business Intelligence analytical reports using Tableau.
• Major integration with web applications using JavaScript API, Asp.Net and IIS Server.
• Gathered Business Requirements, interacted with teh Users, Project Manager and SMEs to get a better understanding of teh Business Processes.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Core member for integration of Tableau Reports with Asp.Net web application and usage of JavaScript API for performance improvement.
• Created custom filter to meet reporting needs.
• Enhanced teh performance of teh database by Index Tuning.
• Configure, support and maintain online BI applications and SQL reporting. Involved in performance tuning for Reports and Framework model.
• Done load managements using CDC filters for Fact and Dimensions.
• Experienced working with large sets of data, Multidimensional data sets in a Data warehouse/Data Store supporting Data Mart.
• Created customized framework model and applied package and object level security for Adhoc reporting.
• Designed and Implemented metadata models in Framework Manager and Power play cubes in Transformer.
• Developed various types of reports in Report Studio using dimensional (Cube & DMR) and Relational data sources.
• Implemented data level security to secure teh data in reports and dashboards.
• Implemented report bursting to distribute reports more effectively.
• Used Cognos Event Studio to manage scripts, Dynamic cubes refresh and notifications.
• Managed Appworx for scheduling database scripts and Cognos Dynamic cubes.
• File Transfers using command line tool, PuTTY for UNIX platform.
• Validated AW models to EBS source by writing SQL queries.
• Designed and Developed Sophisticated, interactive Dashboard reports.
• Designed and applied conditions and created functions based on teh requirements.
• Creation of conditional variable to hide, highlight of teh column information on teh reports.
• Provided critical information for business decision making by designing and developing various reports at teh executive and analytical levels.
• Used conditional variable to hide, highlight of teh column information on teh reports.
• Used java script to customize reports to meet report needs.

Environment: Cognos 11 analytics, Cognos 10.2.2, IBM Cognos TM1 10.1, Cognos Adaptive Warehouse 10.2, Adaptive Analytics, Report Studio, Analysis Studio, Query Studio, Cognos Connection and Framework Manager, Transformers and Event Studio, Oracle ERP Applications, and Oracle 11g.

Confidential, Fort Worth, TX

Sr. Cognos Developer / Architect

Responsibilities:

• Analyzing teh business requirements provided by teh business users on all Trackwise Cognos reporting requests.
• Designing, maintaining, and developing all Adhoc and Standard Trackwise reports using IBM Cognos 10.1 Suite.
• Designing and executing Installation Qualification (IQ) and Operational Qualification (OQ) scripts for teh Electronic Change Requests (ECR) required deploying Standard and Periodic Safety update reports (PSUR’s) as part of validation and testing.
• Acted as a TM1 expert to create budget input templates to upload data, make version copy, consolidated market level's budget submissions, created cube views, subsets, active forms, in-spreadsheet models for ad hoc analysis.
• Administered Cognos TM1 security using LDAP/ Access Manager and monitored teh overall performance.
• Applying Advanced IT theories and methods Generate Cognos business reports with high performance.
• Created Report Studio Reporting widgets for use with Workspaces
• Created Report Studio Filter Widgets for use with Workspaces
• Used advanced techniques to integrate multiple data sources share same filter widgets in Cognos workspace.
• Prepared different P & C (properties and casualties) Data sets and worked on different P & C data models.
• Mixed Dimensional and relational based reporting widgets onto same workspace and could share same report studio built filter widgets across relational and Dimensional widgets.
• Integrated Cognos Report Studio Reports into MS Office PowerPoint Slides for Presentations
• Cognos Report Studio
• Cognos Briefing Book Solution - Built Briefing Book solutions that included multiple reports that used Table of Contents for navigation and book marks to get back to table of Contents
• Cognos Report Booklets - Similar style solution as Briefing book but this type of solution allows you to call a separate reporting objects and bring them into a single report with a Table of Contents as well. In addition, I expended teh functionality to call reports outside of Cognos from table of contents as well.
• Identifying and gathering user requirements and business requirements from different groups, end users for developing reports
• Designed and developed Tableau Dashboards for critical Projects, i.e. CEO Scorecard & OBIEE to Tableau Reports Conversion. Particularly CEO scorecard, for which teh scope of Workbook included 10+ dashboards.
• Performing yearly analysis and business risks using different line charts.
• Analyzing teh future trends and provide business ideas to manage wealth, investments.
• Designed Ad-Hoc reports across various verticals as per teh Business Users requirements.
• Created drill down, drill through, sub and linked reports using MS SSRS 2008/2010 as well as maintained subscriptions.
• Created tables, views, triggers using DB Visualizer.
• Enhanced teh performance of teh database by Index Tuning.
• Configure, support and maintain online BI applications and SQL reporting. Involved in performance tuning for Reports and Framework model.
• Used Team foundation server for report version control and PVCS for database related version control.
• File Transfers using command line tool, PuTTY for UNIX platform.
• Coordinate with data architecture and modeling team to define and develop solutions to teh business requirements.
• Analyze requirements and create functional securities and technical specifications.

Environment: Cognos 10.1.1, Cognos Connection, IBM Cognos TM1, Report Studio, Query Studio, Analysis Studio, event Studio, Business Insight, Business Insight Advanced, SQL Server 2008 R2 SP1/2010, T-SQL, BIDS 2008/2012, DB Visualizer, PuTTY, Unix, Team Foundation Server, PVCS Tracker PL/SQL.

Confidential, King of Prussia, PA

Technical Lead/ Cognos Developer/Admin

Responsibilities:

• Developed Adaptive Dashboards for various Business groups using Cognos Active Reports.
• Designed and Implemented metadata models in Framework Manager and Power play cubes in Transformer.
• Developed various types of reports in Report Studio using dimensional (Cube & DMR) and Relational data sources.
• Implemented data level security to secure teh data in reports and dashboards.
• Implemented report bursting to distribute reports more effectively.
• Used Cognos Event Studio to manage scripts, Dynamic cubes refresh and notifications.
• Managed Appworx for scheduling database scripts and Cognos Dynamic cubes.
• Wrote stored procedures and PL/SQL scripts to load, update data tables.
• Worked on MS SQL Server tasks such as Data Loading, Batch Jobs, BCP-Bulk Copy, DTS and Indexes.
• Created and automated regular Jobs such as Daily/Weekly Report Generations.
• Involved in building and maintainingSSIS Packagesto import and export teh data from various data sources usingBIDSbased on teh design data models.
• Designed and Build Dynamic Cubes with Star schema and Snowflake schema using SQL Server Analysis Services (SSAS) 2008 for analyzing purpose.
• Created many complex stored procedures / functions and used them in Crystal Reports directly to generate reports on teh fly.
• Used Crystal Reports v 11 to create drill down reports.
• Provided to different business users to develop dashboards in workspace and workspace advanced.

Environment: Cognos 10.1.1, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio, Business Insight, Business Insight Advanced, Windows NT/2000/XP, SQLSERVER 2005/2008, DB2, T-SQL, SSIS, SSAS, SSRS, COBOL, Share Point Portal Server, Enterprise Architect, Visual Source Safe.

Confidential, Rosemead, CA

Sr. Cognos Developer/admin

Responsibilities:

• Design, develop, and implement Cognos TM1 10.1 Applications for Financial Planning and Budgeting models with complex rules.
• Development of Turbo Integrator (TI) Processes to load and retrieve data from database tables and other data sources, for creating dimensions, hierarchies, and Dynamic cubes.
• Maintenance of TM1 users, roles and security, Import teh data from ODBC and Text files using TM1 Turbo integrator.
• Created relational and dimensional Framework Manager Models, packages and configured them with appropriate security.
• Involved in creating portal pages for various departments and assigned security to portal pages and reports in Cognos connection.
• Worked on Framework manager to Import metadata from multiple data sources and to create various Query Subjects, create and publish packages to Cognos 10.1
• Involved in deployment of teh Reports, Framework manager packages, Cubes from development to Integration, QA and Production.
• Configure, support and maintain online BI applications and SQL reporting. Involved in performance tuning for Reports and Framework model.
• Performed Unit testing of teh reports by checking teh report output to teh SQL output and prepare Unit Test Document.
• Conducted teh session for teh employee and users on TM1 10.1, Cognos 10.

Environment: IBM Cognos TM1 10.1,Cognos 10,8.4,8.3 - Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Transformer 8.3,Power Play 7.3, SQL.

Confidential, Hillsborough, NJ

Cognos/BI Developer

Responsibilities:

• Interacted with business users to identify key Dimensions and Measures for custom development of Supply Chain Warehouse.
• Developed professional reports in Report Studio and ad hoc reports in Query Studio. Created list reports, cross tab reports, chart reports and reports with features like conditional formatting, multiple drill through and has extensively used teh new features in Cognos 8.4
• Used TOAD to run SQL queries and validate teh data in Data warehouse and Data Marts.
• Involved in teh Setup security both at package level and at query subject level
• Used conditional formatting and conditional blocks to display different sets of data based on different conditions in Report Studio.
• Created multi page report based on multiple queries using Prompts and Parameters.
• Created Various Dashboard Reports for different business areas based on Cubes and DMR’s.
• Performed Unit Testing to ensure teh accuracy of data displayed in teh report.
• Created documentation for all teh processes involved.
• Provided technical assistance by responding to inquiries regarding errors, problems, or questions with programs/interfaces.
• Created reports using reporting services SSRS.
• Worked as a lead developer in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Developed complex TSQL code for teh application.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
• Design and implementation of stored procedures and triggers for automating tasks.
• Worked on complex data loading (implemented teh batch data cleansing and data loading).
• Creating and automating teh regular jobs.
• Manage and monitor teh system utilization.
• Manage teh backup and recovery of teh team.

Environment: Cognos 8.4,8.3 - Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Transformer 8.3,Power Play 7.3, Oracle10g, Toad 9.1, MS Access, DTS, SSIS, Query Analyzer, BCP, SQL Profiler, Windows 2003 Server, Client Network Utility.

Confidential

Cognos developer/admin

Responsibilities:

• Created list, cross tab, chart and dashboard reports including features as such drill-thru, slice and dice, conditional formatting, master/detail, bursting and automated reports distributions with e-mails using report studio, query studio and analysis studio.
• Worked on Framework manager to Import metadata from multiple data sources and to create various Query Subjects, create and publish packages to Cognos 8.4.
• Configure, support and maintain online BI applications and SQL reporting.
• Acted as a TM1 expert to create budget input templates to upload data, make version copy, consolidated market level's budget submissions, created cube views, subsets, active forms, in-spreadsheet models for ad hoc analysis.
• Administered Cognos TM1 security using LDAP/ Access Manager and monitored teh overall performance.
• Conducted teh session for teh employee and users.

Environment: IBM Cognos TM1, Cognos 8.3 BI (Framework Manager, Report Studio, Query Studio, Transformer, Cognos Connection), Oracle 10g/11g, TOAD, Erwin Data Modeler r7.4, Windows vista/X

Confidential

Cognos developer/admin

Responsibilities:

• Involved in understanding teh Business and all Departments within Prudential Financial.
• Designed teh Model according to teh Business Requirements by creating a Presentation Layer.
• Built teh Model using Framework Manager and published packages to Cognos Connection for Reporting.
• Created filters within teh Model for improving teh performance of teh Model.
• Developed standard Templates, Standard Reports, Charts, Drill through Reports, Master Detail Reports.
• Created Query Prompts, calculations, Conditions & Filters.
• Created Stored Procedures for Updating and Inserting data into teh database.

Environment: Cognos 8.x (Framework Manager, Query Studio, Report Studio, Analysis Studio, Event Studio), Report Net 1.1, Cognos EP series 7.3, Cognos Decision stream, Power play, Oracle 9i/10g, SQL Server 2005/2000, Windows XP/2003, Unix.