Jami Tarakeswara Rao

WORK HISTORY

EDUCATION

ABOUT JAMI TARAKESWARA RAO

7+ years of experience in business intelligence of Microsoft SQL Server 2008 R2, 2012, 2016, 2019 on various business domains like Insurance, Education, Finance. Good experience in MS SQL, SQL Server Integration services (SSIS). Experience in developing, monitoring, extracting and transforming data using SSIS, Import and Export Wizard. Good experience in designing and developing the SSIS packages with different control flow tasks and data flow transformations, scheduling and deploying the packages. Experience in High Level Design of SSIS Packages for integration data using OLE DB, ADO.NET connection from heterogeneous sources like (Excel, CSV, flat file, Text Format data) by using multiple transformations provided by SSIS such as Data Conversion, Derived Column, Conditional Split, Merge, Lookup, Multicast, Row Count and Union all. Good Understanding in creating Databases, Schemas, Tables, Stored Procedures, Views and Indexes using T-SQL. Good Knowledge in SCD (slowly changing dimensions) types. Good experience in dimensions, facts and bridges. Experience in maintenance and Administration of SSIS Packages by creating Jobs and schedule SSIS Packages. Good Knowledge on Star Schema and Snowflake Schemas and Data Modelling. Good Understanding of Data Warehouse concepts like EDW, ODS and Data Mart. Experience in Erwin Data modeler to design the data warehouse models. Experience in COZYROC third party library for SSIS to extract the data from application like Microsoft Dynamic Nav. Involved in various aspects of software development life cycle - gathering and analyzing the requirements, designing, developing, testing, implementing. Created Unit Test cases and implemented Unit test results. Handling client calls and Troubleshooting. Ability to work with a diverse team and contribute to the team spirit. Good at multitasking and worked well under tight deadlines with high efficiency.