SUMMARY:

• I have 15+ years of experience in Data Warehousing and Business Intelligence as a Sr. DW Business Intelligence Consultant, in verticals like Retail, Marketing, Pharma, Accounts, Finance, Banking and Telecom etc. I have good understanding of ETL and BI Architecture. I worked with SSIS/SSAS/SSRS, MSBI Architecture, Visual Studio, SqlServer including Data Modeling. I worked in DW Development, Maintenance and Production
• Support Projects. I have worked in various roles such as ETL/BI Developer, DW Architect, Data Modeler, Project Manager and have good understanding of many business processes and technical fields. I have keen eye to Detail and focused on the objectives of client. I have 5 years of experience working in USA and more than 10 years of experience working with USA based clients. I am Oracle Certified and PMI Certified Project Management Professional (PMP)

TECHNICAL SKILLS:

ETL Tools: SSIS 2012, Informatica 8.x/9.x, DataStage 8.x, Abinitio, OWB 10.x

BI Tools: SSAS/SSRS 2012, Visual Studio 2012, Business Objects, BO XI R2/R3, Excelcius, Cognos 8.x/10.x, Microstrategy 9.x, OBIEE, Qlickview 9, Hyperion Essbase 9.x, SSAS, SSRS, Siebel Analytics, Crystal Reports 11, SAP BW/BI, Cognos PowerPlay, Cognos Reportnet, SAS, Advanced Analytics

Data Modeling: IBM WCC (MDM), OLTP, OLAP, ROLAP, MOLAP, Star Schema, Snowflake Schema, Dimensional Modeling, Data Modeling, Physical and Logical Data Modeling, Erwin, ER/Studio, Toad, SQL Navigator DB Artisan

Databases: Sql Server 2012, Oracle 10g/11g, Sybase, Informix, Teradata V2R12,Microsoft Access,Netezza

Other Applications and Tools: MS Project, Oracle Applications, Siebel CRM ApplicationsOperating Systems: Sun Solaris 7/8, HP - UX, DEC ALPHA UNIX, Win 2000/98/95, Win NT 4.0/5.0, Mainframe Systems

Programming: SQL, PL/SQL, T-SQL, HTML, C, PRO*C, UNIX Shell Script, Java, XML, COBOL, JDBC, PERL

PROFESSIONAL EXPERIENCE:

Confidential, Redwood City, CA

ETL/BI Architect

Responsibilities:

• Responsible for Data Architecture, Data Model
• Responsible for ETL development/maintenance using SSIS, SSAS
• Responsible for development of SSRS reports including Facility Report Card
• Responsible for development of SSAS cubes and Excel Reports using SSAS
• Responsible for development/maintenance of T-SQL stored procedure to refresh SqlServer database and supply data to SSRS Reports
• Develop and deploy SSRS reports to Report Server
• Migrate Visual Studio, Sql Server, BI to 2012 from 2008

Environment: Visual Studio 2012, BIDS, SSIS/SSAS/SSRS 2012/2008, Sql Server 2008

Confidential, Mettawa, IL

ETL/BI Specialist

Responsibilities:

• Responsible for Data Architecture, Data Model
• Responsible for ETL using SSIS packages
• Responsible for building OLAP cubes using SSAS
• Responsible for Performance Tuning of SSAS Cubes
• Responsible for Requirement gathering and Analysis
• Responsible for Stored procedures using T-SQL

Environment: MSBI, SSIS/SSAS/SSRS, Sql Server 2008

Confidential, Plano, TX

ETL/BI Specialist

Responsibilities:

• Develop SSIS packages for ETL purposes
• Develop SSAS cubes and SSRS Reports
• Develop Data dictionaries and database schemas
• Responsible for Requirement gathering and Analysis
• Develop Stored procedures using T-SQL

Environment: MSBI, Sql Server 2008, SSIS/SSAS/SSRS, Teradata

Confidential, Fruitland, ID

ETL/BI Architect

Responsibilities:

• Developing ETL/BI solutions as identified by the Business.
• Working with the Business to resolve project and operational Issues
• Develop, Test and Maintain SSIS, SSAS Packages, T-SQL stored Procedures
• Develop and Support SSIS Jobs to load dimensions, facts into data warehouse using Error Handling, Auditing, Slowly changing dimensions, Data Profiling, Data Cleansing
• Responsible for developing KPIs using Performance Point
• Responsible for developing reports using Power Pivot
• Develop and Support SSAS cubes,

Environment: Microsoft SSIS/SSAS 2008, Performance Point, Power Pivot,ORACLE 10g/9i, Share Point 2010, SQL, PL/SQL, UNIX

Confidential, Mooresville, NC

DW Architect

Responsibilities:

• Responsible for Performance Tuning of their ETL Process in their MDM
• Responsible for Preparing Project Plan
• Responsible for converting the DataStage code from Server to Parallel
• Worked on Single View of Customer or MDM
• Worked with Quality Stage, Performance tuning of DataStage Jobs, Server Jobs to Parallel jobs conversion
• Worked with Testing of MDM features like Suspect Duplicate Processing, Ever greening
• Develop SSIS packages, SSAS Cubes and SSRS Reports
• Worked with Data Quality, Data Cleansing, Data Enrichment,
• Manage quality through best practices, development standards

Environment: DataStage 8.x, Teradata V12, Sql Server 2008, ORACLE 10g/9i, SSIS/SSAS/SSRS, SQL, UNIX

Confidential, Peapack, NJ

DW Architect

Responsibilities:

• Responsible for Gathering Requirements
• Responsible for Performance Tuning of their ETL Process
• Responsible for Study and Recommendations
• Responsible for Production Support of ETL Process
• Responsible for ETL/BI minor Enhancements
• Coordinate with offshore PASCI team at Chennai
• Responsible for Minor Enhancements in SSAS cubes
• Responsible for developing KPIs using Performance Point

Environment: Sqlserver 2008, ORACLE 10g/9i, SSIS/SSAS/SSRS, SQL, PL/SQL, UNIX.

Confidential, Stamford, CT

DW Architect

Responsibilities:

• Working in Centre of Excellence for BIDW department
• Responding to RFP, POC, Effort Estimation, Presales for Clients
• Working on Data Warehouse Architecture initiative for building expertise
• Working towards competency development and environment set up
• Manage quality through best practices, development standards
• Responsible for developing SSIS packages, SSAS cubes, SSRS Reports

Environment: BO XI R2, Excelcius, MS BI, Informatica 8.x, DataStage 8.x, Teradata v9

Confidential, Morristown, NJ

DW/BI Architect

Responsibilities:

• Lead internal customers with Requirements definition, Project definition and Project Planning
• Gather Business Requirements
• Responsible for Installation and configuration of Informatica 8.1.1 client tools, Informatica Server and Repository Server, Migration of Informatica from 7.1 to 8.1.1
• Responsible to Migrate the mappings from Development to Test and then to Production environments.
• Responsible to Design, Develop mappings, Process Flows, Packages using SSIS
• Responsible for Designing Business Intelligence using Business Objects Reporting.
• Responsible to Create Universes, Generate reports using Web Intelligence, Desktop Intelligence, Publish reports to Repository, Schedule Reports, Use Crystal Reports
• Responsible for developing SSAS cubes
• Responsible for developing SSRS Reports
• Responsible for building and maintaining SAP Business Intelligence using Info Cubes, Info Objects
• Responsible for developing Dashboard Reports using Siebel Analytics

Environment: INFORMATICA 8.1.1, SSIS, SSAS, SSRS, Business Objects,, MS Project, SAP BI, Teradata v9, Oracle 10g/9i, Sql Server 2005

Confidential, Irving, TX

ETL/BI Architect

Responsibilities:

• Coordinate with Business Analysts and Business users, to gather requirements
• Identify gaps in data requirements between ODS and Target Applications
• Identifying Risks, prioritizing them and develop Risk Response Plans
• Managed Vendor Interface, Oversee development team and Business analysts and report progress to Senior Management
• Responsible for running the batches to run on Daily, Weekly and Monthly basis using UNIX CRON.
• Responsible to Create and maintain schema for Microstrategy like facts, attributes, project source, projects, metrics, prompts, filters etc.
• Responsible for Security, Scheduling and Performance Tuning for Microstrategy Reports
• Responsible for Logical and Physical models for the Data Warehouse.
• Responsible for maintaining Data Warehouse in SSIS/SSAS/SSRS environment
• Responsible for developing Reports using Siebel Analytics
• Worked with BTEQ, MLOAD, Fast Export, TPUMP utilities of TERADATA
• Provided 24x7 Production Support and Maintenance for the applications

Environment: INFORMATICA 7.x/8.x, Microstrategy 7.x, Siebel Analytics, SqlServer 2005, Teradata V2 R5, ORACLE 10g/9i, SQL, PL/SQL, UNIX, MS Project, SSIS, SSAS, SSRS

Confidential, Rye, NY

ETL/BI Architect

Responsibilities:

• Conduct the initial system study and prepare the High Level Design.
• Prioritize Business/Technical requirements
• Participate in client meetings, to review Integrated data approaches and interpret results
• Communicate Project findings, Conclusions and Recommendations with peers and clients
• Conduct the initial system study and prepare the High Level Design
• Define Requirements by understanding Business needs by interacting with key business Representatives, Prepared ETL requirement documents to transfer data from Central Master to MAPS and ODS
• Responsible for Logical and Physical models for Data Warehouse.
• Responsible to Design and Run Datastage parallel jobs
• Use Framework Manager to create project, develop and publish package to Reportnet Server,
• Use Cognos Connection to access Corporate Data and Schedule reports, Use Query studio to generate ad-hoc reports, Use Report studio to generate managed reports.
• Designing Business Intelligence using Business Objects Reporting.
• Create Universes, Generate reports using Desktop Intelligence, Publish reports to Repository, Schedule Reports
• Responsible for building and maintaining SAP Business Intelligence using Info Cubes, Info Objects

Environment: O/s: Oracle 9i, Data Stage 7.x, SAS, SAP BW, Business Objects 6.x, Cognos Reportnet, Oracle Applications, MS Project

Confidential, Minneapolis, NY

ETL/BI Architect

Responsibilities:

• Work closely with Business Analysts and Business Users to gather Requirements
• Responsible for coordinating between Client and Offshore development team.
• Work closely with Business Analysts and Business Users to gather Requirements
• Responsible for coordinating between Client and Offshore development team.
• Responsible for Designed and Developed additional modules in Data Warehouse
• Responsible for Data modeling is done using Star Schema
• Define logical and Physical models for Data Warehouse.
• Get the change Requests from onsite, Analyze them with the team, do time/cost Estimation
• Prepare test plans and test cases
• Defect tracking and Monitoring
• Created and maintained schema for Microstrategy like facts, attributes, project source, projects, metrics, prompts, filters etc ...
• Maintained Security for users
• Coordinated and deployed Microstrategy report changes
• Done Performance Tuning for Microstrategy Reports
• Define Logical and Physical models for the Data Warehouses
• Worked with BTEQ, MLOAD, Fast Export, TPUMP utilities

Environment: O/s: Informatica Power Center 6.x, Microstrategy 6.x, Cognos Impromptu, PowerPlay 6.x, TERA DATA V2R4

Confidential, Horsham, PA

ETL Architect

Responsibilities:

• Gathered Requirements from Business users to prepare Requirement document
• Designed and developed standards for overall architecture of data warehouse systems
• Designed and develop Star Schema based on Kimball’s Methodology involving Facts, Conformed dimensions, Surrogate keys and Aggregate tables.
• Developed complex mappings for loading data from source tables to staging tables and then to target tables using transformations like Source Qualifier, Expression, Filter, Aggregator, lookup, Update Strategy, Sequence Generator, Router and Joiner.
• Created UNIX Shell scripts for Pre-Session and Post-Session runs in Workflow Manager
• Direct project team on Standards and Architecture
• Used Informatica Debugger to apply break points while session is running
• Worked with multiple sources such as Relational Tables, Flat files, Excel Sources, ERP Sources for Extraction using Source Analyzer and Source Qualifiers
• Worked with Mapping Variables and Mapping Parameters
• Designed and Populated Aggregate tables
• Setup folders, groups, users, permissions and Performed Repository
• Administration using Repository Manager.
• Tuned the Mappings and Sessions for better Performance
• Created Test cases, Test Reports and supported users during User Acceptance Testing

Environment: O/s: UNIX SOLARIS S/w: SQL, PL/SQL, UNIX Shell Script Tools: Informatica PowerMart / Power Center 5.1, DTS, Oracle 8i/9i, ERWIN 3.x, BUSINESS OBJECTS 5.X.

Confidential, Shelton, CT

ETL Architect

Responsibilities:

• Installed and Configured Oracle databases for Click Stamp Online
• Owned and Maintained Oracle Schema for Click Stamp online
• Developed PL/SQL Procedures
• Developed and Maintained UNIX Shell Scripts

Environment: O/s: Windows 2000, Windows NT S/w: SQL, PL/SQL, UNIX Shell Script Tools: Oracle 8i, ERWIN 3.x.

Confidential, Lansing, MI

Consultant

Responsibilities:

• Worked with Business Analysts and Business users to get the Requirements
• Developed and maintained the MFOS Application using Power Builder
• Analyzed and Estimated Change Requests
• Developed and Maintained PL/SQL Procedures, Packages and Triggers
• Developed and Maintained UNIX Shell ScriptsOwned and Maintained Oracle Schema for MFOS

Environment: O/s: UNIX SOLARIS S/w: SQL, PL/SQL, UNIX Shell Script Tools: Oracle 8i/9i, ERWIN 3.x, Power Builder 6.x

Confidential

Responsibilities:

• Prepared Software Requirement Specification and Software Development Specification
• Designed the Physical model of database after translation from logical model.
• Develop Logical data model
• Developed PL/SQL Procedures, Packages and Triggers.
• Developed Oracle Forms and Reports
• Converted code from IBM COBOL to TANDEM COBOL
• Done data modeling using ERWIN
• Database Backup/Restore is done using Export/Import, Tar and CPIO
• Developed UNIX Shell Scripts

Environment: O/s: UNIX SOLARIS S/w: SQL, PL/SQL, UNIX Shell Script Tools: Oracle 5.x/6.x, ERWIN, ORACLE FORMS, REPORTS.