DW Architect Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Software professional for Fortune 100 companies in the banking and brokerage financial firms, Healthcare and Manufacturing . Experienced in all facets of the software development lifecycle; Expertise as project manager, lead developer, architect, software designer, project manager, usability expert, and client liaison; Extensive skills in Cognos development. Adept at juggling client expectations while balancing technical considerations

       

·          Strong Experience in Implementing Cognos Applications in Windows and UNIX.

·          Strong experience with client interaction, understanding business applications, business data flow and data relations

·          15 years of experience in Software Design, Development, Analysis, Testing, Data Warehouse and Business Intelligence tools

·          13 years experience in building Business Intelligence applications.

·          5 years experience as a Manager , Team Lead and Architect in Developing , Implementing and Managing

Business Intelligence and Data warehouse applications using Cognos BI tools.

·          Extensive Experience in SQL Server, Oracle, DB2 and MS Access for building and implementing data warehouse

·          10 Years experience in ETL Process/Development.  2 Years using Informatica.

·          Experience in Integrating BI tools with Front-end applications using SDK & .Net

Development Tools	Development Languages	Database Tools
·Cognos 10, Cognos 8.x	·   C#.NET, Visual Basic.NET	·   Microsoft SQL Server
· Framework Manager	·   Visual Basic	·   Oracle, PL/SQL,Informatica
·Report Studio, Query Studio	·   ASP, ASP.NET	·   SQL Navigator, TOAD
·Analysis Studio, Metrics Studio	·   VBScript, JavaScript, Perl	·   Stored Procedures/Triggers
· Cognos (6 & EP series 7)	·    L,DHTML, XML	·   DB2
·Security & Administration	·   COBOL, CICS	·   Microsoft Access

Education:

   Bachelors in Engineering, Kakatiya University, India

Certifications/Training:   Cognos Certified Author and Administrator

·                      Certified in Cognos BI Level I

·                      Certified in Cognos BI Level II

·                      Cognos BI – Impromptu & PowerPlay

·                      Cognos 8/ Cognos 10 , SDK

·                      Citrix Metaframe Certified Administrator

·                      Windows 2000/NT Server Support and Administration

Other Tools & Technologies:

BI Tools	OS / Servers
·Impromptu, Powerplay	·   Windows NT / 2000
·Transformer, IWR	·   Unix
·Access Manager, Upfront	·   Citrix Metaframe
·Visualizer, Decision Stream

Work Experience

Client: Bank of America, NJ                            

Jan 2009 – Current

DW Architect / Team Lead

Business Intelligence Development:

·          Participated in Requirement Gathering, Business Analysis, User meetings, discussing the issues to be resolved and translating user inputs into technical design and to BI reports.

·          Designed and Developed Cognos Series 7 Reports and Powerplay Cubes and Implemented Security using Cognos Access Manager

·          Migrated Cognos Series 7 reports to Cognos Reportnet Environment and created new reports using Cognos Report Studio.

·          Designed and Developed Framework Manager Models and Implemented security using Access Manager.

·          Installed and Configured Cognos 8 environment and Migrated Cognos Reportnet Reports to Cognos 8.

·          Installed and Configured Cognos 10 environment and Designed and Developed reports using Cognos 10.

·          Converted Cognos Powerplay cubes to Dynamic reports in Cognos report studio.

·          Implemented Audit logging for Cognos reports and created custom Audit reports.

·          Improved report performance using advanced modeling and report techniques.

·          Integrated Cognos with Front-end applications using SDK and .Net.

·          Exported Cognos My Reports to front-end applications using Cognos SDK

·          Created Dynamic reports using Conditional layouts, Conditional blocks, variables, and scripting.

·          Generated dynamic reports which allowed users to select their choice of dimensions and measures to be included in the report and this gave the ability to the users to select the columns they would like to see in the reports at run time.

·          Created runtime filters and drill through, drill down and layouts.

·          Implemented security to Cognos 8/10 environment using windows authenticated Active Directory.

·          Created custom Prompt pages using .Net and linked to cognos reports and cubes.

·          Created Custom Cognos report pages by modifying XML files and other Configuration files.

·          Created Model/Packages for Query Studio Ad-hoc reports.

   

  Production Support:

·          Create users, groups, folders and granting the appropriate privileges and permissions to the users and groups.

·          Content Administration from one environment to the other and Maintain Content Store and Audit DB.

·          Maintain Cognos Application and Web Servers.

·          Maintain Cognos Framework Manager Model Changes and Upgrades.

·          Monitor monthly data loads from multiple data sources (Feed files, External DB) and maintained DW environment.

·          Resolve Bugs/Issues with data and reports.

·          Maintain users and data level security.

·          Create Ad-hoc reports and monthly data analysis.

·          Analyze business requirements and prepared functional specifications / system technical design documentation

·          Integrated Cognos with Front-end applications using SDK, .Net.

·          Supported Data-loads, Data Warehouse, Outgoing and Incoming feeds using Oracle, PL/SQL, SQL*Loader and UNIX shell scripts.

·          Interacted with Business users for gathering requirements, training and supporting reporting environment.

·          Installed and Configured BI Tools and Implemented Security.

     

Database Development:

·          Designed and Developed Data Warehouse, Data marts and Automated load process.

·          Designed and developed stored procedures, functions, packages, Materialized views using Oracle 10g.

·          Automated the incoming and outgoing feeds

·          Implemented efficient and effective performance tuning procedures.

·          Used external loaders (SQL*Loader) to load the data into the target tables.

·          Optimized SQL queries for better performance.

·          Developed mappings using Informatica to transform and load the data from various source systems to Oracle DW.

·          Developed UNIX shell scripts and created Autosys jobs for data loads.

Client: Gulf Stream, Savannah, GA

Employer: Computer Sciences Corp (CSC)                                                                

Apr 2004 – December 2008

DW Architect / Team Lead

     Gulfstream Aerospace Corporation, a wholly-owned subsidiary of General Dynamics, designs, develops, manufactures, markets, services and supports the world's most technologically-advanced business jet aircraft. Designed and Developed Cognos BI reports and cubes for the enterprise reporting of various business applications.

Client: Pfizer, Exton, PA

Employer: Computer Sciences Corp (CSC)

Mar 2003 – Apr 2004

Cognos BI Level I & II Engineer / Lead

Pfizer is a largest pharmaceutical company in the US.  Sales Analysis System for the animal health group provided regional managers, area managers and territory managers with detailed handy analysis data to check sales made by each area. Separate cubes were built for managers to send and analyze data. The users leveraged and explored the multi dimensional cube data for strategic and tactical planning to plan accurate strategic directions, promotion and business decision-making.

Client: DuPont, Wilmington, DE

Employer: Computer Sciences Corp (CSC)

Jul 1998 – Mar 2003

Cognos BI Level I & II Engineer / Developer

Global Training Information System supported the Human Resource Department and  required a reporting structure that would enable them to view reports and cubes via web browser.  Data in Oracle Data warehouse used for reports and cubes.

Client: DuPont, Wilmington, DE

Employer: Computer Sciences Corp (CSC)

Jul 1998 – Mar 2003

Cognos BI Level I & II Engineer / Developer

XMS is Dupont Travel and Non-Travel expense reimbursement system. This system provided US based employees to submit travel and non-travel business-related expenses on-line and send the reimbursement directly to AMEX or to the employee’s direct deposit account.  Cognos products (BI Tools) used in XMS to build the information environment to support business requirements and create custom reports.

Client: DuPont, Wilmington, DE

Employer: Computer Sciences Corp (CSC)

Jul 1998 – Mar 2003

Citrix Engineer/ Windows 2000 Server Administrator

Citrix enables the porting of Windows and other operating systems to “thin client” over network .Citrix software builds on Microsoft’s Windows Terminal Services, a part of Windows 2000 Server.

Client: DuPont, Wilmington, DE

Employer: Computer Sciences Corp (CSC)

Feb 1998 – Jun 1998

Citrix Engineer/ Windows 2000 Server Administrator

Vendor Payment and Control system is a corporate computer system that provides a method for all domestic DUPONT sites to

Centrally pay vendor invoices that have been verified and approves for payments.

Quality Information Systems (QIS)

July 1995 – Dec 1997

Customized software is being developed for Client. The work involved the analysis, design and coding. Daily transaction reports give the details of all the transactions that took place on a day. Monthly reports generate the complete transaction details that took place in a month.

References furnished upon request.

Download Resume Format