Business Intelligence Lead Designer Resume
SUMMARY
- Over 14 years of IT experience in Design, Development, Implementation and Testing of Database/Data warehousing/Client/Server, Object Oriented Programming and Legacy applications using Data Modeling, Data Analysis, ETL (Extraction, Transformation, Loading), Data Integration through Big Data/Hadoop Architecture and Data Visualization using Tableau
- 12+ years of extensive experience in System Analysis, Design, Development and Implementation of Relational Database (OLTP) and Data warehousing systems (OLAP), Data marts and Business Intelligence applications using ETL Tool DataStage 7.0/7.1r1/7.5/8.0.1/8.1/8.5/8.7/9.1/11.3
- Over 8 and half years of experience in teh new version of ETL Data warehousing tool, IBM InfoSphere/WebSphere DataStage 11.3/9.1/8.7/8.5/8.1/8.0.1.
- Over 4 years of experience in QualityStage 9.1/8.7/8.5/8.1/8.0.1/7.5 for Data Standardization, Verification and Data Cleansing.
- Over 2 years of experience in Information Analyzer 8.7/8.5 for Data Profiling, Column Analysis, Primary Key/Foreign Key Analysis, Base line reports and Cross Domain Analysis
- Over 1 and half years of experience on Big Data Architecture to integrate humongous volume of data using Cloudera Hadoop and IBM Big Data File Stage.
- Over 1 and half years of experience on Data Visualization tool Tableau 9.1/8.3/8.1.5 to create and present reports more intuitively in teh form of Bar charts, Pictures, Gantt charts and Histograms instead of reading numbers in rows and columns
- Over 14 years of exceptional background in Design, Development, Testing and Maintaining applications in Database/Data warehousing/Client/Server and Legacy Systems for Manufacturing/Chemical Distribution, Health Insurance, Financial, Entertainment (Movie theatres), Health - Care Provider/Hospital and Telecom Services provider industries
- Good noledge in Star, Snowflake schemas, Multi-Dimensional modeling and Fact/Dimension tables design used to build Data warehouse, Data marts and Operational Data Store (ODS).
- Worked on DataStage Client tools DataStage Designer, DataStage Director, DataStage Manager and DataStage Administrator.
- Experience in IBM InfoSphere ETL jobs migration/conversion projects from Windows operating system to UNIX/LINUX operating system
- Strong noledge in Data Extraction, Cleansing, Transformation, Integration and Loading (ETL methodology) processes in corporate wide Data warehouse using IBM DataStage/QualityStage and UNIX Shell Scripting.
- Experience wif IBM InfoSphere DataStage Parallel Extender for parallel processing to improve job performance while working wif bulk data sources and data loads.
- Extensive experience in teh integration of various Relational Database systems like Oracle, MS SQL Server, DB2 UDB, Netezza, Teradata, Sybase, Siebel and MS Access; and other Data Sources like XML files, CSV files, Flat files and Complex flat files into Staging area/Data warehouse/Data marts using several stages in IBM InfoSphere DataStage.
- Experience in Data extraction from several Legacy systems like SAP R/3, Mainframe Systems, WebService (Microsoft BizTalk), Netezza Enterprise/Netezza Performance Server (NPS) and Siebel CRM Systems.
- Worked wif most of teh InfoSphere DataStage Server job and Parallel job stages applying different partitioning techniques.
- Worked on teh migration of DataStage Projects and Jobs from DataStage version 7.5 to 8.0.1; 8.0.1 to 8.1; 8.1 to 8.5; 8.5 to 8.7; 8.7 to 9.1 and 9.1 to 11.3
- Proficient in Data warehousing techniques for Data cleansing, Slowly Changing Dimension (Type me, II, III, and IV) process, Surrogate Key assignment and Change Data Capture phenomenon.
- Experience in creating Dimension, Fact and Summary tables for several Data marts.
- Expertise in working highly scalable parallel processing infrastructure using InfoSphere DataStage Parallel Extender (alias DataStage - PX).
- Experience in generating teh Pattern report and Token report to identify Data Patterns and Inconsistencies in Source data using QualityStage.
- TEMPEffectively worked on building Customized rule sets for Standardizing Source data using QualityStage.
- Implemented a flow to integrate teh DataStage and QualityStage jobs to ensure dat they run in batches by using Sequencer Job and UNIX Shell scripting.
- Expertise on creating Information Analyzer Projects and Data rules at command line interface.
- Extensively worked on Data rule exception reports to identify Data and Format anomalies using Information Analyzer.
- Highly proficient in Data analysis, Data warehousing, Data Integration and Data Migration.
- Exceptional experience in Debugging, Troubleshooting, Monitoring, Optimization, Performance Tuning and Backup/Recovery process of teh ETL processes using InfoSphere DataStage.
- Excellent Software Engineering background, well verse wif SDLC, worked wif various traditional to agile software development methodologies.
- Exceptional background on all phases of Data warehousing development life cycle from Gathering Business requirements to Designing, Coding, Unit testing, Implementing, Migrating and Production support.
- Experience in scheduling ETL jobs and UNIX shell scripts using scheduler tools like Automic, UC4, Appworx and Autosys.
- Prepared Unit test case documents to ensure thorough testing while developing ETL jobs in Development environment/instance.
- TEMPEffective in working independently and collaboratively in team and versatile team player wif strong programming and problem solving skills.
- Programming experience using SQL, Core Java and UNIX Shell programming/scripting.
- Excellent communication, interpersonal, analytical and problem solving skills. Strong ability to perform as part of a team and independently. Flexibility and passion to learn new technologies towards company’s success.
TECHNICAL SKILLS
ETL Tools: IBM InfoSphere DataStage and QualityStage/Information Analyzer 11.3/9.1/8.7/8.5IBM WebSphere DataStage 8.1/8.0.1, Ascential DataStage 7.5/7.1r1/7.0/6.0XE/5.2 QualityStage 9.1/8.7/8.5/8.1/8.0.1/7.5
Big Data Integration: Big Data and Hadoop Architecture, HIVE, PIG, MapReduce, Oozie, ZooKeeper.
Reporting Tools: Tableau 9.1/8.3/8.1, OBIEE 11G R1/10G R3, Business Objects Enterprise XI R2/6.5/5.1.4, Cognos 8.3, Siebel Analytics 7.8.3, SQL Server Reporting Services (SSRS) 2012/2008/2005.
Data Modeling: ER Studio Data Architect 9.0/8.5/8.0.2/7.1 and ERwin 7.2/7.1/4.1/3.5.
Languages: C/C++, SQL, Shell Scripting and Core Java.
Operating Systems: IBM AIX, HP-UX, LINUX, Windows NT/95/98/2000/2003/XP/7, UNIX and MS DOS
Databases (RDBMS): DB2 10.1/9.7/9.1/7.1/6.1, Oracle 12c/11g/10g/9i/8i/7.0, Teradata 7.0/8.0/9.1/12/13.10Netezza 6.0, SQL Server 2012/2008/2005/2000/7.0/6.5, Sybase (Adaptive ServerEnterprise) ASE 12.5.2, Siebel 7.7/7.8/8.1 and MS Access.
Database Tools: Aqua Data Studio 10.0/7.5, Microsoft SQL Server Management Studio, TOADSQL Developer, Developer 2000, SQL Loader, WINSQL and SQL Navigator.
Legacy Systems: SAP R/3, Mainframe Systems, Siebel CRM Systems, Oracle Siebel 8.1, Microsoft BizTalk-WebService, Netezza Enterprise 4.0.3
Others: Automic Scheduler, UC4, TFS, Microsoft Visual Studio 2012/2010, Appworx, AutosysMS Visio 2010/2007, MS Office and Microsoft Visual Source Safe.