OBJECTIVE 
To pursue a career as anETL developer/analyst which will allow me to continue to expand my skill set and knowledge base in a competitive and cutting edge environment.

SUMMARY OF SKILLS

• Informatica certified developer with expertise in design and development of ETL methodology for supporting data transformations & processing data in a corporate wide ETL solution.
• Involved in the complete life cycle of the data warehouse environment and led individual projects.
• Experience in Interactive media content, Revenue, Media Asset management, CRM and SEO domains.
• Experience in Data Profiling, Data Mining, Data Quality, Web Analytics (Omniture), Data Integration with Salesforce and Web Services.
• Familiarity with Master Data Management (MDM) concepts and Informatica MDM tool -Informatica MDM Hub Console, Hierarchy Manager (HM) and Informatica Data Director (IDD).
• Extensively worked on databases like SQL 2005/2000 and Oracle 9i/10g/11g and experience in writing complex queries and using Oracle analytical functions.
• Informatica Velocity methodology certified and extensively followed Velocity best practices and performance tuning measures.
• Experience using Talend for Data profiling and MS Excel for creating pivot tables to summarize and analyze large amounts of data using statistical, logical and database functions.
• Assisted in modeling various data marts and operational data stores using Dimensional modeling and Entity-Relationship modeling.
• Demonstrate self-reliance in researching technical solutions and product functionality and worked on critical projects as a lead developer.
• Served as a liaison between the business and the development team,
• Continuously improve upon existing approaches by seeking opportunity to creatively transform current business practices into fresh alternative solutions.
• Experience working with large datasets which includes online content and traffic statistics such as unique visitors, page view, average time on site, etc. for Food Network and HGTV websites.
• Experience in using Business Objects and testing reports.
• Experience in working with SOA architectureand SOX complaint data marts.
• Possess analytical and problem solving skills and capable of managing multiple projects.
• Experience in developing test cases, developing test scripts and analyzing bugs.
• Highly adaptable in quickly changing technical environments with very strong organizational, analytical and interpersonal skills.
• Experience using Agile methodology – both Scrum and Kanban.

EDUCATIONAL QUALIFICATION/CERTIFICATIONS

• Masters in Computer Science
• Bachelors in Electronics Engineering,
• Informatica Certified Developer
• Informatica Velocity Methodology Certified Professional
• 2 Week Boot camp on Informatica MDM tool

TECHNICALL SKILLS

ETL Tools:Informatica Power Center 8.x/9.1 (Repository Manager, Designer, Server manager, Workflow Monitor, Workflow Manager, Informatica Quality Center, Informatica Power Exchange, Informatica MDM Hub Console, Informatica Hierarchy Manager, Informatica Data DirectorDatabases:Oracle 11g/10g/9i, Pl-SQL, MS SQL Server 2000/2005 Data Modeling:Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, Erwin, OLAP.Miscellaneous Tools:Business Objects, TOAD, SQL Developer, SQL*Plus, SQL*Loader,Autosys, Putty, WinSCP, Filezilla, XMLspy, Subversion, Jira, RallyGeneral Software & Programming:Excel, Word, PowerPoint, Visio, C, Unix shell scripting, SQL.Operating Systems:Windows 2000/98/XP/NT, UNIX, LINUX

EXPERIENCE 

Employer: Confidential, Atlanta GA
Client: Confidential May 2011 - present
Position: Sr. Data Services Developer/Analyst in Data Services team

Confidential is a leading developer of high-profile, lifestyle-oriented content for many media platforms including television, digital, mobile and publishing. The company\'s media portfolio includes popular lifestyle brands HGTV,DIY,FoodNetwork,CookingChannel,Travel Channeland Great American Country(GAC). My projects involved designing and developing ETL processes to load application data into reporting databases for media asset management for different internal applications such as Media Request, Show track Pro, Esearch etc. They also involved generating complex XML’s for Recipe Management, calling web services and integrating Salesforce with Informatica to load the data in Salesforce and create dashboards for revenue data.

• Design and develop data integration processes using Informatica Power-Center to load application data into Media Asset Management (MAM) reporting databases.
• Assist in the architecture, implementation and deployment of an enterprise operational reporting database warehouse.
• Design and develop data structures for mining and information retrieval applications which support small scale information needs as well as enterprise wide strategic initiatives.
• Work with subject matter experts to derive data requirements and design appropriate data models.
• Design and develop ETL processes for cleansing and loading data into the operational warehouse, as well as developing batch and real-time solutions to support application and integration initiatives.
• Perform data profiling tasks including column analysis, structural analysis, simple rule analysis, and complex rule analysis.
• Successfully implemented a large scale project involving integration with Salesforce to create dashboards for revenue data in Salesforce.
• Assist with resolving data anomalies and data quality issues.
• Perform performance tuning based on Informatica velocity best practices.
• Assist with writing and maintaining project documentation, including but not limited to formal requirements, design documents and test plans.
• Interact with UNIX/Windows system administration and DBA groups to resolve issues.
• Support development initiatives by working with application design and development teams to reach optimal data design, quality, and integration patterns.
• Support development of ad-hoc and canned reports to support business initiatives and objectives.
• Took responsibility of individual projects and ensured timely completion without data quality issues.
• Being a part of the data services team and the nature of work, had to work on varied projects simultaneously.
• Participated in design reviews, code reviews and brain storming sessions for various projects and tasks.
• Co-ordinated with offshore teams and remote teams to ensure smooth functioning of a project and resolve data issues.
• Gave presentations and documented various Informatica processes and best practices for enterprise level reference.
• Worked on R&D projects and implemented them successfully as a part of the Data Services Center of Excellence (COE).

Employer: Confidential, Atlanta GA
Client: Confidential Feb 2010 – April 2011
Position: Data warehouse Developer in Interactive BI team

I worked as a Data Warehouse Developer in the Confidential. My primarily responsibility was of design and development of data integration processes using Informatica tool in order to support reporting for analysis purposes. I dealt with projects which involved enhancement work for Interactive media content and Revenue data marts and developing the new SEO data mart. I was also involved in data analysis, data profiling, building processes, performance tuning, testing and production support.

• Involved in the design and development of ETL processes to load data for analytical purposes.
• Was responsible for building new data marts (SEO data mart) as well as enhancing the current ones with new features.
• Automated processes using the Unix shell scripts.
• Since processing of huge files from Omniture was involved, performance tuning of the mappings, sessions and workflows played a huge role in bringing down the running time.
• Co-ordinated with Omniture to resolve source file related issues.
• Wrote test cases for integration testing.
• Performed data profiling of the sources using Talend open source tool before beginning the development work. That helped me identify the data patterns.
• Analyzed data related issues and proposed possible solutions and picked the best one after the consultations based on ROI.
• Worked on the Revenue data mart which involved a lot of mappings with complicated data calculations where the totals have to absolutely precise.
• During development work, focused on reusability and simplicity to get the best performance.
• Used advanced mapping techniques to make the most of the Informatica tool.
• Worked with the users directly for requirements as well as any data related issues.
• Documented all the processes for the ease of understanding for the new recruits as well as for the existing ones.
• Have provided production support and resolved critical issues.
• Have worked on deployment documentation and coordinated with all the teams involved for a smooth deployment.
• Have tested Business objects reports as a part of the overall test plan.
• Worked with heterogeneous sources and targets and also with third party vendors.
• Have the experience of working with a huge data warehouse with sizes typically upto 10-15 GB and hence been involved in trying to find faster data retrieval methods for analysis purposes.

Employer: Confidential, Los Alamitos CA Sept 2007 – Dec 2008Role: Database Admin/ETL DeveloperBrief Description:

• ETL development using SQL Server Integration Services.
• Handled large table loads using SSIS and sqladhoc queries.
• Created SSIS packages for data movement and database maintenance
• Assisted data architect for implementing physical databases from logical design.
• Have written complex queries and stored procedures as per business needs.
• Designed, constructed and implemented physical databases.
• Installed, maintainedand administered SQL Server 2000/2005 instances and databases.
• Scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency check and index defragmentation.
• Conducted and participated in model reviews ensuring that models accurately reflect the business rules and policies to satisfy the business requirements
• Involved in performance tuning,resolving deadlock issues, normalization and de-normalization processes.

Confidential, Long Beach CA Sept 2006 – Dec 2007 Role: Database Admin/Developer Brief Description:

• Maintained the inventory of all the AV equipment’s being used in the University.
• Created new database users as required and grant them appropriate rights and privileges.
• Performed capacity planning to create and maintain databases.
• Installed new versions of the Oracle RDBMS and its tools.
• Planned and implemented the backup and recovery of the Oracle database.
• Managed sharing of resources among applications.
• Troubleshoot problems related to databases and applications.
• Implemented and enforced security for the databases.
• Maintained database constraints to ensure referential integrity.
• Have written queries to retrieve information as and when needed by the stakeholder.