*Excellent ETL Developer Consultant available immediately for Projects*
*Please do send the requirements to **[email protected]*<[email protected]> * and reach me at* *732-470-8387* Dear Recruiter, Let me present my available consultant Surendar,* *ETL Developer** * * *Please add my ID in your list and send your direct client requirements*** * * *EXPERIENCE SUMMARY * - *7+ years* of strong Data Warehousing experience using *Informatica* *PowerCenter 8.1.1/7.x/6.2/5.1 *(Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer), Informatica PowerMart 7.0/6.2/5.1, Power Connect, Power Exchange.** - *3+ years of BI* experience using Cognos 8.1, Cognos Impromptu 7.0/6.x (Impromptu, PowerPlay, Transformer, Impromptu Web Reports (IWR), PowerPlay Enterprise Server), Business Objects XIR2/6i/5.1, Business Objects Designer 5.1, Business Objects Reporting, Micro Strategy. · Experienced in *Installation, Configuration*, and *Administration*of Informatica Power Center/Power Mart Client, Server, Cognos and BO products.** · Experienced in complete life cycle Implementation of data warehouse.** · Experienced in *OLTP/OLAP* *system study, analysis and ER modeling *, developing Database schemas like *Star schema* and *Snowflake schema*used in relational and multidimensional modeling. ** · Involved in all activities related to the *development, implementation, Testing* and *Production support* of ETL processes for large-scale data warehouses using *Informatica* *Power** Center** and Informatica Power Mart*.** · Thorough knowledge of *Data warehouse* *concepts* with complete hands-on experience in conceptualizing designing, building, testing and building Enterprise Data Warehouses from multiple source systems using *Informatica Power Center 8.x/7.x/6.x/5.x, Power mart 5.x.* · Experience in Performance Tuning of sources, targets, mappings, transformations and sessions. · Ability to write complex SQLs needed for ETL jobs and analyzing data, and is proficient and worked with databases like *Oracle 10g/9i/8x/7x, SQL Server 2005/2000/7.0/6.5, DB2, and MS Access*.** · Hands on experience in writing *stored procedures (PL/SQL)*, *triggers *and* Packages*.** · Extensive Shell scripting experience for scheduling, Process Automation and periodic job scheduling. · Good exposure to *Development, Testing, Debugging, Implementation, Documentation, End-user training and Production support.* · An excellent team member with an ability to perform individually, good interpersonal relations, strong communication skills, hard working and high level of motivation. A quick learner with an aptitude for taking responsibilities. · Developed e*ffective working relationships with client team* to understand support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations. ** *CORE TECHNICAL SKILLS* *- Informatica PowerCenter 8.x/7.x/6.x - Cognos 8/ Cognos Impromptu - Business Objects XIR2/6.5/5.0 * *- Oracle 10g/9i/8i - MS SQL Server 2005/2000 * *INDUSTRY * *- Finance - Insurance * *- Pharmaceuticals - Banking * * * *SUMMARY OF COMPUTER SKILLS* * * *Data Warehousing* *:* Informatica Power Center 8.x/7.x/6.x/5.x Power Mart 6.2/5.1, Informatica Power Analyzer, * *Informatica Power Connect, Informatica Power Exchange *BI Tools :* Business Objects XIR2/6.5/5.0, Cognos 8, Cognos Reportnet 1.1, Cognos Impromptu 7.0/6.x *Languages : *C, C#, Visual Basic, SQL, PL/SQL** *RDBMS / Database : *Oracle 10g/9i/8i, MS SQL Server 2005/2000, DB2, MS Access** *Modelling Tools :* Erwin 4.x/3.5, MS Visio** *Inter Net : *HTML, XML, Java Script** *RDBMS Utility :* Toad, SQL *Plus, SQL Loader** *Operating System : *Windows VISTA/XP/2000/NT/98/95, UNIX, MS-DOS, Ubuntu** *Technologies : *Dot Net** *Others : *MS Office Please feel free to contact me any info. Thanks and Regards *Anil** * *LIGHTNING **MINDS** **Phone L 732-470-8387** **Email :* [email protected]* **Web* <[email protected]>*: **www.lightningminds.com*<http://www.lightningminds.com/>
