• FMS Project IS gathering all the data from Kate spade brand which was sitting in Oracle and File system to SAP Hana & S4 database and also gathering data from Stuart Witzmen brand from SQL server and loading into to Centralized repository

• Fetching historical data from Netezza production to S4 Database for coach brand and finally Sap hana & S4 will act as common repository to build all the reports needed by management

• Responsibilities:

• Analyze the data coming from multiple source systems such as SAP S/4 HANA, Google Analytics, ShopperTrack and other Master data which sits on multiple platforms such as HANA, Oracle, Netezza, and SQL Server or coming in the form of XMLs, flat files API Calls.Understand the statistics, metrics and Aggregation level needed for reporting and achieve the same using wide variety of Database Analytical Functions and procedures

• Identify the Inbound and Outbound data feeds required to support the integration

• Understand the technical requirements and design/ develop the interfaces using Informatica, design the batch schedules Cisco Tidal Job scheduler, perform various Job handling, file handling and data validation tasks Unix/Shell Scripting, PLSQL and MFT (Managed file transfer)

• Creating the detail design and building the Informatica ETL mappings, sessions and workflows to transform the source data according to data warehouse/reporting requirements

• Apply multiple kind of transformations including but not limited to Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL, Normalizer and update strategy, transaction control, Java, SQL, User Defined, Web Services to meet business logic in the mappings and get the data to desired level of granularity

• The project is building an Enterprise Data Warehouse, which would integrate Prescription data for Sales purposes

• Data is sourced from different systems, which include calls information, what are the discussion topics, key messages, medical enquiry and surveys, Flat Files, Oracle tables and Excel spreadsheets are part of the source data for the present on Oracle, which came in on a daily, weekly and monthly basis

• Projects capabilities include extracting and cleansing data from Oracle System to datawarehouse Repository and then providing the data for Qlik view reporting

• Responsibilities:

• Defines the business process flow in a standard manner and describes the process logic of invocation of the involved web services

• Developed Unit Test cases for each case in specific modules to test the functionality

• Created Conceptual model based on the business process and identified the entities, attributes and relationships and converted the conceptual model to the Physical and logical data model

• Converted the logical model to Physical Model by giving accurate data types, created indexes on keys and forward engineered the DDL

• Worked with business Analyst to gather the business requirements and created functional and non-functional requirements documents

• Experience in loading Dimension, Fact stage and Fact tables

• Developed mappings using various transformations like Update strategy, Lookup, Router, Filter, Sequence Generator, Joiner,JAVA Expression

• Worked with different sources such as Oracle, Flat files

• Using Workflow manager for Workflow and Session Management, database connection management and Scheduling of jobs

• Performing source data analysis and data validation, producing requirements gathering and writing functional specifications, performing workflow analysis

• Performed many multiple tasks effectively and involved in troubleshooting the issues

• Experience in deploy informatica objects Dev,UAT and Production Environments

• Helping the reporting Qlik view team to understand the functionality and monitor the reports

• Experiencing in performance tuning by using PDO in target level

• Created references tables, applications and workflows and deployed that to Data integration service for further execution of workflow

• Was also involved in development of Unix scripts for doing some basic operations like merging of files, removing header from files etc

• Responsible for cleansing the legacy data by discussing with state people and making them aware of data issues and finding the logics to convert the legacy data in order to fit the target tables Environment: Informatica Power Center 9.x,8.x, (Source Analyzer, Warehouse Designer, Mapplet Designer, Mapping Designer and Transformation developer) SQL, TOAD, Windows

This Dashboard which covers Company's main Production Database Information
It covers mainly about Volume, TAT and Quality Scores, Many Adhoc reports developed to cover various range of statistics , The Dashboard Tab provides an executive summary reflecting data from the current month (MTD operational statistics) and also provides the flexibility to drill down at various levels by making specific selections or combinations of selections.

Gathering requirements and designing solutions for business
Design Dashboards for Medical Transcription business using Qlikview
Optimizing the current Qlikview Dashboards
Enhancements and improvements in the current reporting system
Build, design, test, optimize and deployment of applications on to server
Technical and deployment document creation for the projects
Mentoring the team and internal training for team on Qlikview
Worked on NPrinting Designer to Schedule the HTML Reports

This module consisting of management reports along with payroll related reports which is used by management for analysis of future growth. Payroll software is based on an ‘open architecture' creating ease of integration with other applications.

Module 1: Downloading data from website and loading into oracle database by passing links using Windows Application.
Module 2: Getting data from Sql server of one server to another server and load into oracle database using WCF Service.
Module 3: Downloading data from Outllook mail and loading into oracle database using console application.
Module 4: Downloading data from SFTP using winscp and loading to oracle database using oracle Loader.
Module 5: Importing various platforms data to Qlikview Report tool for several Dashboard reports.
Module 6: Developing and Maintains MIG Website to handle all payroll related and as well as Reports.