Sofia Sultana

Summary:

. Over *+ years of IT experience in the Analysis, design, development,

testing and Implementation of Business Intelligence solutions using

Data Warehouse/Data Mart, ETL, OLTP, OLAP, and Client/Server

applications.

. Solid testing experience in all phases and stages of Software

Development Life Cycle (SDLC) with good working knowledge of testing

methodologies, disciplines, tasks, resources and scheduling utilizing

different ETL skills that include Informatica 9.5/9.1/9.0/8.6,

Datastage, SSIS and Ab Initio 2.14

. Extensively used ETL methodology for supporting Data Extraction, Data

Transformation, Data Analysis and Data Loading, in a corporate-wide

ETL Solution using Informatica Suite.

. Experience in Dimensional Data Modeling utilizing Erwin, Star/ Snow

Flake Schema, Fact and Dimension tables, Physical and Logical data

modeling; as well as Kimbell/Inman methodologies.

. Strong working experience in the Data Analysis, Data Governance,

Development, Implementation, Installation of the projects in mission

critical applications within HealthCare, Finance domains.

. Working with various relational databases Oracle 11g/10g/9i, MS SQL

Server, DB2, Unix Shell Scripting and expertise knowledge in

scheduling tools like AutoSys, Tivoli and CA-7

. Hands-on identifying and eliminating duplicates in datasets through

IDQ 8.6.1 components of Edit Distance, Jaro Distance and Mixed Field

matcher for cleansing, data conversion, exception handling and

reporting.

. Good knowledge in Master Data Management (MDM) concepts and

Informatica MDM tool -Informatica MDM

Hub Console, Hierarchy Manager (HM) and Informatica Data Director

(IDD).

. Good understanding and experience in creating source to target mapping

using different data feeds edit rules, validation, Transformations and

business rules.

. Expertise in Automation, CA Workload Control Center and involved in

Production on-call support 24X7 during the batch process and Issue

Resolutions by analyzing Session Logs and Workflow Logs.

. Excellent Communication and interpersonal skills with clear

understanding of business processes and ability to work as part of

team or individually.

Technical Skills:

ETL Tools : Informatica (Power Center/ Power

Exchange, IDQ, IDE, IDD, MDM, DA), DataStage, SSIS

Testing Tools : Quick Test Pro (QTP), HP Quality Center, HP

ALM, Test Director, Test Link

Reporting Tools : Business Objects, Cognos, Hyperion

Languages/GUI tools : Java, SQL, HTML, Java Script

RDBMS / Databases : SQL Server, Oracle, Teradata, DB2, MySQL

Web Tools : SOAP UI, XML, web services, MS-IIS,

Apache, MS Commerce Server

Operating Systems : UNIX, Windows, MS-DOS, Linux

Configuration Tools : MS PowerPoint, Excel, Visio, VS, PVCS, Rational

Clear Case, MS Visual Source safe

Automation Tools : AutoSys, Tivoli, CA-7

Servers : JBoss, WebLogic, WebSphere

Methodologies : RUP, SDLC, DAMA

Education:

. Bachelor of Science - Electrical Engineering, JNTU, Hyderabad, India

Professional Experience:

Client: Health Spring, Nashville TN,

Sep2012 - Present

Role: Sr. ETL Consultant

Health Spring is a leading health care company that offers a wide range of

insurance products and health wellness services; it provides Medicare

Advantage plans and prescription drug coverage. The main objective of this

project shared data Repository is to capture new vitality program

customers' data, policies, group policies, Medicare plans. Data is coming

from various sources like SQL Server, Mainframe, Flat file which will be

loaded in to EDW based on different frequencies as per the requirement. The

entire ETL process consists of source systems, staging area, Data warehouse

and DataMart.

Responsibilities:

. Analyzing, designing and developing ETL strategies and processes,

writing ETL specifications, Informatica development, and

administration and mentoring other team members.

. Involved in gathering business requirements, logical modeling,

physical database design, data sourcing and data transformation, data

loading, SQL and performance tuning.

. Defining the schema, staging tables, and landing zone tables,

configuring base objects, foreign-key relationships, complex joins,

and building efficient views.

. Used Informatica Power center client tools - Source Analyzer, Mapping

designer, Transformation Developer, Workflow Manager, Workflow

Monitor; extensively used Informatica Power exchange to extract data

from multiple sources and to build Change Data Capture (CDC) mechanism

using mapping variables.

. Worked on Slowly Changing Dimensions - Type 1, Type 2 and Type 3 in

different mappings as per the requirements.

. Wrote Stored Programs (Procedures & Functions) to do Data

Transformations and integrate them with Informatica programs and the

existing application.

. Developing as well as modifying existing mappings for enhancements of

new business requirements mappings to load into staging tables and

then to target tables in EDW. Also created mapplets to use them in

different mappings to support common functionality; and parameter file

with parameters and variables to pass among the sessions.

. Used various transformations like Filter, Expression, Sequence

Generator, Update Strategy, Joiner, and SQL, Lookup (File and

Database) to develop robust mappings in the Informatica Designer.

Different tasks in Workflows like sessions, events raise, event wait,

e-mail, command, worklets and scheduling of the workflow.

. Involved in performance optimization techniques and best practices of

Informatica to improve the processes; Exhaustive testing of developed

components.

. Exposure in Informatica MDM where data Cleansing, De-duping and

Address correction; interacting with Informatica Data Explorer (IDE),

and Informatica Data Quality (IDQ) tools.

. Used Hierarchies tool for configuring entity base objects, entity

types, relationship base objects,

Relationship types, profiles, put and display packages and used the

entity types as subject areas in IDD.

. Worked on Teradata SQL Assistant to analyze the existing data and

implemented new business rules to handle various source data

anomalies.

. Prepared ETL standards, Naming conventions and wrote ETL flow

documentation for Stage and ODS.

. Provided on call support during the batch cycles; strategies during

the crisis and been involved in disaster recovery (DR) exercise.

Environment: Informatica Power center 9.5(Designer, Repository Manager,

Workflow Manager, Workflow

Monitor), Power Exchange, Data maps, CDC, IDD,

IDQ, MDM Hub, Oracle 10G, TOAD, UNIX, PL/SQL

Developer, UNIX AIX 5.1, MS Office and Delimited

Flat files, AutoSys, Visio and batch scripts.

Client: MDM Informatix, Chicago, IL

May 2011 - Jul 2012

Role: Sr. Consultant

It supports a water utility project. It provides water facility to a

particular county. The main objective of this project is to maintain the

customer, vendor data in order to maintain a good payroll system. The data

is mainly residing in oracle applications and legacy systems. MDM hub is

to be made as a centralized store.

Responsibilities:

. Responsible for Analysis, Design, Installation, Development,

Deployment of master data solution of a key data domains

. Participated in the requirements gathering sessions along with

business and technical stake holders

. Responsible for MDM Hub development including Data Profiling, Data

modeling & Data Mappings (Landing, staging and Base Objects), data

validation, match and merge rules, queries and packages

. Configured entity objects, entity types, hierarchies, relationship

base objects, relationship types, and profiles in the Hierarchy

Manager.

. Configured Informatica Data Director (IDD) subject area groups, child

subject areas, workflows, validation and deployment, among other tasks

. Used Informatica Data Quality (IDQ) profiler and developer tool to

analyze source system data and discover underlying issues

. Configured address doctor tool to be used as part of the MDM solution

for validating customer and vendor addresses

. Worked with Java developers in setting up SIF for real-time

integration with MDM Hub

. Worked with ETL developers in integrating MDM Hub with source and

target systems

. Worked on Informatica Power Center tools - Designer, Repository

Manager, Workflow Manager and Workflow Monitor.

. Assisted in testing of the MDM solution including unit, integration,

regression testing

. Migrated the MDM code using repository manager to different

environments, administered MDM and IDD users

Environment: MDM Hub, Informatica Power center 9.1, Power Exchange, IDD,

IDQ, Oracle 10G, WinSCP, PL/SQL Developer, TOAD, UNIX AIX 5.1, CA-7, MS

Office and Visio

Client: Abbott Laboratories, Chicago, IL

Apr2010 - Apr2011

Role: ETL Developer

Abbott Laboratories is an American-based global, diversified

pharmaceuticals and health care products company. Abbott's broad range of

medical tests and diagnostic instrument systems are used worldwide by

hospitals, laboratories, blood banks, and physicians.

Responsibilities:

. Involved in the requirement definition and analysis in support of Data

Warehouse efforts.

. Investigated source systems to locate and understand existing subject

areas across the enterprise

. Developed ETL mappings, transformations using Informatica Power Center

. Extensively used Informatica client tools - Source Analyzer, Warehouse

designer, Mapping Designer, Mapplet Designer, Transformation

Developer, Informatica Repository Manager and Informatica Workflow

Manager.

. Created ETL processes to extract data from Mainframe DB2 tables for

loading into various oracle staging tables.

. Developed Informatica Mappings and Workflows for Data Integration.

. Organized the Workflows and Sessions for the Initial and Incremental

Data load runs.

. Prepared the Schedules for the Initial Load runs and Incremental Load

runs.

. Worked extensively on different types of transformations like source

qualifier, expression, Aggregator, Router,

filter, update strategy, lookup, sorter, Union, Stored

Procedure and sequence generator.

. Assisted in the developing for processes flows for data stewardship

with focus on consolidating common data domains like customer, vendor,

product & financial data across company divisions

. Fixed the invalid mappings and troubleshoot the technical problems of

the database.

. Good knowledge in Informatica Data Explorer (IDE), and Informatica

Data Quality (IDQ)

. Helped in documenting in data standards for customers, products,

vendors and other subject areas by studying the current state business

processes and analyzing data

Environment: Informatica 9.0(Designer, Repository Manager, Workflow

Manager, Workflow Monitor), Oracle 10G, UNIX, PL/SQL Developer, DB2.

Client: Qwest Communications, Chicago, IL

Oct 2009 - Mar 2010

Role: ETL Developer

This organization is a large telecommunications carrier. It provides long-

distance services and broadband data, as well as voice and video

communications globally. This project includes developing Data warehouse

from different data feeds and other operational data sources. Data comes

from different sources like oracle, SQL server and flat files and which is

extracted using ETL tool. Actively involved as a developer for extracting

the data and applied transform logic according to the business rules.

Responsibilities:

. Involved in the requirement definition and analysis in support of Data

Warehouse efforts.

. Investigated source systems to locate and understand existing subject

areas across the enterprise

. Developed ETL mappings, transformations using Informatica Power Center

. Extensively used Informatica client tools - Source Analyzer, Warehouse

designer, Mapping Designer, Mapplet Designer, Transformation

Developer, Informatica Repository Manager and Informatica Workflow

Manager.

. Created ETL processes to extract data from Mainframe DB2 tables for

loading into various oracle staging tables.

. Developed Informatica Mappings and Workflows for Data Integration.

. Organized the Workflows and Sessions for the Initial and Incremental

Data load runs.

. Prepared the Schedules for the Initial Load runs and Incremental Load

runs.

. Good knowledge in Informatica Data Explorer and Informatica Data

Quality

. Worked extensively on different types of transformations like source

qualifier, expression, Aggregator, Router, filter, update strategy,

lookup, sorter, Union, Stored Procedure and sequence generator.

. Assisted in the developing for processes flows for data stewardship

with focus on consolidating common data domains like customer, vendor,

product & financial data across company divisions

. Fixed the invalid mappings and troubleshoot the technical problems of

the database.

. Helped in documenting in data standards for customers, products,

vendors and other subject areas by studying the current state business

processes and analyzing data

Environment: Informatica 8.6,Power Exchange, Data Analyzer, PL/SQL, Oracle

10g/9i, Erwin, Autosys, SQL Server 2005, Sybase, UNIX AIX, Toad 9.0, Cognos

8., Oracle 10G, UNIX, PL/SQL Developer, DB2.

Client: System soft Technologies, Hyderabad, India

Aug 2007-June 2009

Role: Software Developer

Assisted in the design and development of user information solutions and

Internet applications for a leading financial services company.

Responsibilities:

. Wrote the computer programs used for everything from the systems that

allow computers to run properly to the latest software applications

for mobile devices.

. Analyzed the needs of clients and then designing a system to meet

those needs. Also recommend software upgrades to existing systems.

. Detailed work comes in the form of designing the step-by-step

flowcharts for computing systems that show how program code must be

written in order for it to work properly.

. Documented all of their tasks to ensure that subsequent users can

diagnose and fix any problems that might arise in a system, as well

perform any maintenance

. Reviewing current systems

. Presenting ideas for system improvements,

. Working closely with analysts, designers and staff

. Producing detailed specifications and writing the program codes

. Testing the product in controlled, real situations before going live

. Maintaining the systems once they are up and running.

Environment: Java, .net, C, Reporting Tools.

Contact this candidate