Saveetha Sellakani – SQL Server/SSIS Developer – H4EAD –   10+ years Exp – Ready to relocate anywhere in US

Consultant's Details: 

Consultant Name: Saveetha Sellakani

 H4 EADVisa: 

Employer Details:

 Nextgen Technologies IncEmployer: 

 KushalContact Person: 

 Email: kushal@nextgentechinc.com

Note: Please call between 08:30 AM PST to 06:00 PM PST

 4134240484 / 4087692596 Ext. 1007Phone: 

Resume

Professional Summary:

• Over 10+ years of IT experience in Data Warehousing Business Intelligence reporting, Analysis, Design, Development, Testing, Implementation, Enhancement and Support of BI applications for various industries like Retail, pharmaceutical and healthcare.

• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.

• Experience in ETL processes involving migrations and in sync processes between two databases.

• Experience in Microsoft Visual C# in script component of SSIS.

• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).

• Experience in creating configuration files to deploy the SSIS packages across all environments.

• Experience in developing ETL mappings and scripts using Informatica PowerCenter 8.x.

• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.

• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.

• Experience with Cognos Tools such as Cognos 10.x/8.8 BI suite (Framework manager, Cognos connection, Report Studio, Analysis Studio, Query Studio, Metric Studio and Event Studio) Cognos Report net 1.1 and Analysis Tools such as Cognos Power play transformer 8.x, Business Object XIR2, Informatica Powercenter 8.

• Expertise in Framework manager modeling which includes creating relational and dimensional models. (Database layer, Business Layer, presentation layer and Packages)

• Created security groups and implemented data level, object level and package level security.

• Expertise in developing Multidimensional Cubes using Cognos PowerPlay Transformer.

• Created simple to Complex Reports using Report studio (Drill through, Drill down, Master detail, Report level Joins, conditional formatting, scheduling and bursting the reports) and Analyzed data using Analysis Studio.

• Experience in developing standard and complex dashboards and implemented dynamic grouping using Report Studio.

• Experience in migrating reports from Impromptu to Report Net, and upgrading reports from Report Net to Cognos 8 BI and also upgrade previous version to latest versions (Cognos 8.4 to 10)

• Involved in Installation and Configuration of Cognos 8 BI (All components including Power Play and Framework Manager) in Distributed Environment (Development, Test and Production)

• Extensive experience with database languages such as SQL, and PL/SQL which includes writing queries, Stored Procedures, Functions and View Experience in databases like Oracle 10g/9i/8i MS SQL Server 2005/2000.

• Expertise in Business Object reports and Designer. Created various Webi and crystal reports and involved in various support activities.

• Proficient with Informatica Powercenter.

• Developed Informatica mappings from scratch using Informatica Powercenter 8.

• Strong understanding of Data warehouse concepts (Star schema, snow flake schema, facts and dimensions) and SDLC methodologies.

• Experience in gathering and documenting end-user business requirements.

• Experience in team management (Task allocation and coordination)

• Excellent team player and self-starter with good ability to work independently, proficient at developing& implementing User Training programs and possess good analytical, problem solving and logical skills with ability to meet deadlines, multitasking and flexible in work schedules.

• Excellent in communication skills.

 

Technical Skills

BI Reporting Tools	Cognos 10.x, Cognos 8.x, Report Studio, Query Studio, Analysis Studio, Framework Manager, Cube Designer, Cognos Report Net 1.1, PowerPlay Transformer, ImpromptuWebeports, Business Objects XIR2.
ETL Tools	Informatica Power Center 8.x, Data Stage,Transformation Services (DTS), MS SQL Server IntegrationServices (SSIS). ETL Tools Data
Operating Systems	Windows 2000/2003 Enterprise Server/Windows XP Professional