We provide IT Staff Augmentation Services!

Sr. Architect Dwh / Bi Resume Profile

Schaumberg, IL


Seeking a challenging position in IT, R D DWH BI Visualization Analytics. Excited to learn and adapt the new technologies as and when needed in a fast pace. Highly motivated to excel in DW, ERP and CRM arena

Experience Summary:

  • Started career with RTB Run the Business and now working on CTB Change the Business . Extensive work experience in USA, Middle East, Singapore, Malaysia, Hong Kong Sri Lanka on various projects
  • 17 years of experience in various roles like Sr. Architect /Practice Manager- Technical /Project Manager /DWH Architect /BA /Technical Lead /Sr. ETL Developer /SAP Functional Analyst /PeopleSoft Consultant and Sr. Exe Customer Support In-Charge.
  • Gathered requirements by interacting with end users, analyzed, modeled requirements and documented as per the CMM standard and managed application development through User Requirement, Design, Data mining, Testing, Implementation, Training and Support.
  • Having excellent experience in Software Development / Data Warehouse Life Cycle SDLC / DWLC and very good in coordinating and developing many applications for customers.
  • Domain Experience: BIDW:Governance Regulatory GRC /ecommerce /CFS /Telecom /Logistics /Semi-Conductor IT /Healthcare Life Sciences /Marketing /Petroleum Gas by product Production
  • HRMS: Payroll, Time Labor / CRM:Air Travel Reservation CRS.

Soft Skills:

  • Abilitytowork well in a broad-based inter-departmental team with a broad spectrum of staff Architects, Designers, Project / Program Managers, Customer Stakeholders, QA and Functional Managers
  • Strong leadership and decision-making skills.
  • Ability to take both technical direction, make technical decisions and ability to negotiate to develop win-win situation.
  • Excellent customer management, strong negotiation and business communication skills.
  • Ability to develop and present executive level presentations.
  • Excellent self-management skills to work independently with minimal supervision, collaborative, imaginative, resourceful, and reliable technology savvy.
  • Developed, modified, maintained distributed project documentation, project communications and inter-team knowledge transfers.
  • Ability to manage projects aligned with business and IT strategy and in compliance with the organization's architectural standards like SEI-CMM, 6 , ISO, PMP and other International Quality Standards.
  • Worked on Onsite Offshore and vice versa.
  • 5 years of Pre-Sales activities like Proposals, Solutions, and Demonstration Presentations.
  • 10 years of experience in Project Management, Managed project worth 1-2 million USD.
  • 8 years of work experience in DWH / BI with Informatica / DataStage / BO / Cognos / SSIS.
  • Good knowledge in Data Warehousing Concepts Kimball and Inmon data warehouse philosophies, STAR, Snow Flake Schema and Galaxy Schema, Staging area, SCD Type 1, 2, 3, 6, Granularity, Dimension, Confirmed Dimensions, Fact Factless Fact , Dimensional Modeling, Bus Architecture/ UDM Unified Dimensional Model , Physical Logical Designs.
  • Proficient in Informatica Power Center 6.x / 7.x / 8.x.
  • Worked on heterogeneous sources, developed common reusable transformations and Mapplets logic to reduce the cost of Development time efforts.
  • 10 years of experience in differentdatabases like Oracle, SQL Server, DB2 and MS-Access2000.
  • 8 years of experience in Data Modeling CA-ERWin/ MS-Visio .
  • 10 years of experience in EDLM Enterprise Data Life Cycle Management .
  • Experienced in using TOAD, PL/SQL Developer and Win SQL and Handled data's in Terra bytes.
  • Research or experience in manipulating and analyzing complex, high-volume VLDB, large data sets , high-dimensionality data from varying sources.
  • Optimize, expand and transform the data and present it effectively through the lens of information.
  • Experienced in Data Warehouse Re-engineering.
  • Worked on Forward / ReverseEngineering in Modelling.
  • Worked on HP Quality CenterSite admin / Requirements / Test Plan / Test Lab Modules.
  • Worked on IBM Web Logic Web Content portal services...
  • Worked on Cognos Cloud for JN J, Belgium.

Technical Skills:

  • DBMS RDBMS: Teradata 14 V2R5/ Oracle 7.x / 8.x / 9.i / 10g, SQL Server 2005, DB2, Access and Foxpro-2.5.
  • Teradata Tools: BTEQ, FastLoad, FastExport, MultiLoad, and Teradata SQL Assistant
  • ETL: Informatica 6.x / 7.x / 8.x / 9.x, Designer / Workflow Manager / Workflow Monitor / Repository Manager
  • ETL: BO Data Integrator 11.5-XI R2 / Designer / Microsoft DTS / SSIS 2008 R2/ SAS EG 4.3 / Data Stage 8
  • BI: Crystal 8, Cognos10.1.1 / 8.4 / Framework Manager / Report Studio / Query Studio,
  • Tools: Toad, Win SQL 5.0, ER Win 3.0, 4.0, Visio, and UMLEnterprise Architect, IBM Web Logic Web Content.
  • MDM: Stratature EDM 4.1 Microsoft
  • ERP: SAP ver.4.6 C HRASAP Methodologies / People Soft ver.7.5 / 8.0 HRMS
  • People Tools, People Code, SQR, Application Engine, PS-Query, Data Mover, Import Manager, Security Administrator
  • Testing: HP Quality CenterALM 11, QTP 9.2
  • O/s: Windows Family, UNIX and Dos / Packages: MS-Office Adobe.


  • Prepared / Posted DW/BIpaper in Oracle Open World 2012 conference
  • Conducted number of DWH / BI Workshops for various customers
  • Successfully completed PeopleSoft to SAP ERP Data Migration in YASH Inc
  • Successfully completed ISO-19011-2002 and secured Internal Auditor Certification in Prolease.

Professional Experience:








Manufacturing Rebate DWH

Feb'14 Mar'15

Sr. Architect DWH / BI


Nov'13 Jan'14

Sr. Architect BI



Sr. Architect DWH


Jul'12 Mar'13

Sr. Architect BI


Fertilizers, DWH BI

PM / DWH Architect


ETL / Data Warehouse


Business / Data

Warehouse Analyst

Sr. DWH Consultant /


Lead Informatica


Jan'07 May'07

Lead DWH Consultant / BA

Sep'06 Dec'06

Sr. ETL Developer / BA

Mar'06 Sep'06

Sr. ETL Developer / BA



Oct'05 Feb'06

SAP HR Functional


Payroll HRMS

May'05 Oct'05

Business Analyst

Payroll PeopleSoft


Nov'03 Mar'05

Technical Co-ordinator

Payroll HRMS

Nov'02 Nov'03

PeopleSoft Consultant

Legacy ERP applications

Aug'2k Oct'02

Apr'98 Jul'2k

Functional Consultant

Exe Customer Support In charge

Job Involved:

  • Studied the as-is business process and gathering system requirements by interacting with SME, prepared documents and standards
  • Analyzed Data Growth volume.
  • Worked on Bus Architecture / Unified Dimensional Model UDM .
  • Architecture / ETL Model Design Planning Snowflake schema design, Logical / Physical
  • Developed new data models that support the ongoing growth of the business ensuring that model approvals.
  • Done Physical Data / Logical Design Model through ER Win
  • Done Data analysis Designed mappings in such a way to do Cleansing and Profiling after data extraction from flat files
  • Designed to capture Meta Data for auditing, analyzes and reporting purpose
  • Done Data Masking in ETL using DataStage Informatica.
  • Data Masked for precaution from a business security standpoint and in many cases it was a legal obligation.
  • Defined Rules sets for Data Masking to run as and when necessary
  • Implemented SCD Type II for fact tables.
  • Mastered Finance as part of Master Data Management
  • Communicated effectively with all users, at different levels of hierarchy for all EDM related queries
  • Mentored EDW team in their ongoing development issues, best-practices, performance tuning etc.
  • Mappings Optimized for performance and data movement scheduled.
  • Extracted data from legacy Sources, XML Flat files transformed and loaded into Oracle and Flat files Targets using Power Center
  • Involved in managing Informatica backup and restores
  • Identified what data is used by which departments to prioritize resources
  • Used Workflow manager / Monitor for Workflow, SessionMonitoring, and database connection
  • Used extensively Stored Procedure for creating/dropping of constraints
  • Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically. It reduced the cost of Development time
  • Monitored and provided visibility to who uses which data at what time, to identify dormant and unused data
  • Coordinated the development effort with the system designers and developers
  • Now the entire migration process in place and it's very helpful for the new person who ever step in to the project
  • Overseen all technical aspects of the company's DWH / BI Development and Delivery.
  • Automated wherever possible and suggesting solutions for automations.
  • Onsite to Offshore transition.
  • Managed a team in offshore.
  • Done Unit Testing and validated in line with design
  • SPOC Single Point of Contact for Quintiles JNJ from Technosoft Prospects on all BI activities.
  • Reviewed the existing product range and, through value-engineering, look for opportunities to reduce costs / improve efficiency.
  • Done Cognos Framework Model Design
  • Foster a workplace culture amongst the technical team that inspires performance and is generally more outward looking.
  • Development and Delivery of Product Demonstrations
  • Customer Evaluation and Implementation
  • Technical Writing and Solution Training
  • Created folders, user groups and users within them and assigning selective privileges.
  • Designed various types of reports like List, Drill-through, Cross-tabs, Column charts Bar charts.
  • Developed Detail and Summary reports based on management hierarchy with Drill Down and Drill through capability.
  • Developed reports using Master Detail Relationship.
  • Developed prompted reports using different prompts like Value Prompt, Date and Time prompt etc.
  • Developed reports using Conditional Layouts and condition expression like String Variable and Boolean Variable.
  • Enhanced Existing Reports as per change request.
  • Bursted reports based on hierarchy and groups. Bursting reports, event handling, scheduling jobs using CRN
  • Tested newly developed reports enhanced existing reports.
  • Maintained documentation for each activity process.
  • Served as a liaison between SD, Dev, Testing and OPS in order to implement corporate requirements
  • Served as a liaison between deployments, COE, offshore team, and functional team in order to implement corporate requirements for our Onsite - Offshore project Model
  • Communicated effectively with all users, at different levels of hierarchy and provided technical support for all migration related queries
  • Managed client expectations and responsible for final deliverables within the specified scope, budget and time.
  • Done Peer-Review for other projects
  • Conducted Survey on Project Research Analysis on post implementation for userrating
  • Taken care of Pre-Sales activities / proposals RFI / RFP's R D on new tools in DWH/BI.
  • Prepared proposal for KSE and got the deal too.
  • Done POC / Prototype data models Quintiles, USA / Johnson Johnson, Belgium
  • Represented Solution to Prospects at Events
  • Prepared Templates for Data Migration
  • Data Migration Planning from Ingress to Oracle database
  • Process Mapping Migration Planning from PeopleSoft HRMS to SAP HR
  • Generated Pay slips, Journal vouchers Salary, PF, ESI, Perks JV's CSV files and delivering the same for mining in to PeopleSoft Web Portal
  • Enhancements done in Administration Workforce GBL
  • Involved in designing, testing customization of reports through Crystal Reports
  • Provided solution for the applications done in Client Server Architectures Foxpro-2.5
  • Organized training programs for the support staff employees of Think Soft Global
  • Managed Client's individually
  • Implemented, Tested and Troubleshooted GUI based applications
  • Handled more than 70 clients and 5 Products
  • Diagnosed and resolved customer product issues using phone and e-mail as the primary means of communication.
  • Provided consulting level services for how to type of questions
  • Act as the interface between Development Engineering and Technical Support/ Customers to manage product support related issues
  • Developed and managed action plans for customer specific and general bug fixes, product enhancements and other development engineering activities
  • Replicate customer issues and work with Development/QA to determine rootcauses. Coordinate engineering activity to support key accounts
  • Develop, track schedules for issue resolution
  • Worked with marketing/sales to prioritize support issues
  • Act as back line to and assist in the training of other support engineers

Hire Now