Description
PROFESSIONAL SUMMARY * About 8 years of IT experience in Software Analysis, Design, and Development for various software applications in client-server environment in providing Business Intelligence Solutions in Data Warehousing for Decision Support Systems, OLAP and OLTP Application Development and worked on the Database Application Development. * Six years plus experience in the Implementation of full lifecycle in Data warehouse, ODS and Data marts with Dimensional modeling techniques Star Schema and Snow Flake Schema using Kimball and Inmon. * Experience in data mart life cycle development, performed ETL procedure to load data from different sources into Data marts, Data warehouse and DSS using Informatica Power Center 10.1/9.6/9.1.0/8.6.1/8.1.1 - Designer, IDQ (Informatica Data Quality), IDE (Informatica Data Explorer), Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager and Workflow Monitor * Hands on experience in handling data from various source systems such as Flat Files, XML Source, Oracle, MS SQL Server, IBM DB2, Teradata and Excel Files * Expert Developer skills in TeradataRDBMS, initial TeradataDBMS environment setup, development and production DBA support, use of FASTLOAD, MULTILOAD, TPUMP, and Teradata SQL and BTEQ Teradata utilities * Experience involved in Performance Tuning, Error Handling, Production Support and debugging mappings. * Good experience in creating and using Stored Procedures, Functions, Triggers, Views, and packages in Different databases. * Experience in creating Tables, Procedures, Functions, Views, and other database objects using SQL and PL/SQL. * Experience in writing Complex T-SQL Queries, Sub queries, Co-related sub queries, Dynamic SQL queries. * Experience in tuning the performance of Stored Procedures and long running queries. * Experience in Requirement Analysis, Scoping, Developing, Debugging, Testing and Documentation of various phases in a project life cycle of Client/Server Applications. * Expertise in Production migration of new releases and Enhancements. * Experience in coordinating the work with offshore team. * Extensively worked on Monitoring and Scheduling of Jobs using UNIX Shell Script and BTEQ Scripts. * Expertise on tools like Toad, SQL*Plus and SQL Server Management Studio. * Involved in Manual and Automation Testing of applications in UNIX and Windows environment. * Good knowledge on ER Data Modeling tools like Erwin, MS Office Suite and Visio. * Good exposure to the Software Development Life Cycle (SDLC) and OOAD Techniques. * Have a clear understanding of Business Intelligence and Data Warehousing Concepts. * Worked with various clients in the Banking, Financial, HealthCare and Insurance industries * Experience in integrating data from various databases Oracle, SQL, DB2UDB and Teradata. * Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals
Accomplishments
Highlights:
Keywords
