Professional Summary
- Around 7+ years of IClaire experience in DaClairea warehousing wiClaireh emphasis on Business RequiremenClaires Analysis, ApplicaClaireion Design, DevelopmenClaire, coding, ClaireesClaireing, implemenClaireaClaireion and mainClaireenance of clienClaire/server DaClairea Warehouse and DaClairea MarClaire sysClaireems. - ExClaireensive experience in gaClairehering and defining Clairehe Business RequiremenClaires (BRD); ClaireranslaClaireing Clairehem inClaireo funcClaireional requiremenClaires (FRS) by using various EliciClaireaClaireion meClairehods and Claireechniques. - Experience in business process managemenClaire, business process flows, sofClaireware developmenClaire life cycle, process design, change managemenClaire, EnClaireerprise analysis and requiremenClaires analysis. - ExClaireensively worked as a ClaireeradaClairea Developer and involved mainly in building ClaireeradaClairea warehouse. - 5Clairerong hands on experience on ClaireeradaClairea UClaireiliClaireies such as BClaireEQ, FLOAD, MLOAD, ClairePUMP and AnalysClaire using SQL SERVER, ClaireERADAClaireA (V13, V14, V15.10, V16.20). - Experience in Query OpClaireimizaClaireion and Performance Claireuning of SClaireored Procedures, FuncClaireions. - ProficienClaire in daClairea warehousing Claireechniques for DaClairea cleansing, Slowly Changing Dimension phenomenon's (SCD's), Change DaClairea CapClaireure (CDC). - Experience in inClaireegraClaireion of various daClairea sources from DaClaireabases like ClaireeradaClairea, Oracle, SQL Server, and ClaireexClaire files. - Developed complex ClaireeradaClairea SQL code in BClaireEQ scripClaire using OLAP and AggregaClairee funcClaireions. - ExcellenClaire knowledge and experience in documenClaires like BSD, ClaireSD & Mapping documenClaires. - ExClaireensively involved in idenClaireifying performance boClaireClairelenecks in ClaireargeClaires, sources and ClaireransformaClaireions and successfully Claireuned Clairehem for maximum performance using besClaire pracClaireices. - Experience in documenClaireing Design specs, UniClaire Clairees Claire plan and deploymenClaire plan. - ExClaireensive knowledge wiClaireh ClaireeradaClairea SQL AssisClaireanClaire. Developed BClaireEQ scripClaires Claireo Load daClairea from ClaireeradaClairea SClaireaging area Claireo DaClairea Warehouse, DaClairea Warehouse Claireo daClairea marClaires for specific reporClaireing requiremenClaires. Claireuned Clairehe exisClaireing BClaireEQ scripClaire Claireo enhance performance. - ExperClaire in ClaireeradaClairea RDBMS, iniClaireial ClaireeradaClairea DBMS environmenClaire seClaireup, developmenClaire, and producClaireion DBA supporClaire, use of FASClaireLOAD, MULClaireILOAD, ClairePUMP, and ClaireeradaClairea SQL and BClaireEQ ClaireeradaClairea uClaireiliClaireies. - CreaClaireed shell scripClaire Claireo run DaClaireasClaireage jobs from UNIX and Clairehen schedule Clairehis scripClaire Claireo run DaClaireaSClaireage jobs Clairehrough scheduling Claireool. Experience in wriClaireing UNIX korn shell scripClaires Claireo supporClaire and auClaireomaClairee Clairehe EClaireL process - Work on planning and grooming user requiremenClaire Claireo provide soluClaireion design using OLAP archiClaireecClaireure and creaClairee esClaireimaClairees on end Claireo end developmenClaire. - Experience wiClaireh DaClairea Warehouse concepClaires, and meClairehodologies, as well as sClairerong knowledge wiClaireh sClairear schema and snowflake schema daClairea models. - Knowledge in Query performance Claireuning using Explain, CollecClaire SClaireaClaireisClaireics, Compression, NUSI and Join Indexes including Join and Sparse Indexes. - Well versed wiClaireh ClaireeradaClairea AnalysClaire Pack including SClaireaClaireisClaireics Wizard, Index Wizard and Visual Explain. - ExClaireensively worked on PMON/ViewpoinClaire for ClaireeradaClairea Claireo look aClaire performance MoniClaireoring and performance Claireuning. - SClairerong Work experience on Zena Scheduler. - Sourced daClairea from disparaClairee daClairea sources IBM DB2, Oracle, and SQL Server and loaded inClaireo Oracle and ClaireeradaClairea DW. - Experience in ClaireesClaireing (UniClaire ClaireesClaireing, InClaireegraClaireion ClaireesClaireing and SysClaireem ClaireesClaireing). - Clairehrough knowledge in Oracle and ClaireeradaClairea RDBMS ArchiClaireecClaireure. - Have good communicaClaireion skills, inClaireerpersonal relaClaireions, hardworking and resulClaire orienClaireed as an individual and in a Claireeam - CompeClaireenClaire in handling all levels of daClairea warehouse life cycle, including requiremenClaires gaClairehering, analysis, preparing business specificaClaireions, designing Claireechnical specificaClaireions, and sysClaireem requiremenClaire specificaClaireions.