• 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

Management Information Generator is a Repository consisting of central data ware house system which loads data from various transcription platforms like sharepoint, web,sqlserver, amazon redshift by using an ETL tool and also pull data from Replicate DB source and then providing the data for Qlik view reporting Responsibilities: Involved in understanding the BRD (Business Requirement Document) which includes mapping document with databases Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse Understanding the Conceptual model based on the business process and identified the entities, attributes and relationships and Physical and logical data model Used various transformations like Update Strategy, Filter, Expression, Sequence Generator, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer Developed mapping parameters and mapping variables to support SQL override Developed mappings to load into staging tables and then to Dimensions and Facts Used existing ETL standards to develop these mappings Worked on different tasks in Workflows like sessions, events raise, event wait, e-mail, command, worklets Was also involved in development of Unix scripts for doing some basic operations like merging of files, removing header from files etc Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse

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.

The Regulatory Expert System (REx) also known as Regulatory Compliance Web application (RCW) initiative is a step in direction towards achieving the compliance status of a project by automating lot of complex and manual time consuming tasks. It is envisioned to build a repository of knowledge base and business rules in automating the tasks associated with establishing the compliance status of a project. REx provides end-to-end compliance workflow functionalities to achieve process compliance. Designing and deploying Table reports, Matrix (or Cross tab) reports, Drilldown reports, Drill-through reports, Sub reports etc using data sources like SQL Server databases. Created both subscriptions and data driven subscriptions using Report Manager. Involved in design, coding and unit testing. Created different SSIS Packages to export client metadata from spread sheets to database tables. Created Data Flow task packages using various Data transformations like Derived Column, Lookup, Union All, Conditional Split transformations etc. Created complex stored procedures, functions, views to handle different reports.

Shell eServe enables users to place orders and access a wealth of information 24 hours a day. Using Shell eServe alleviates paperwork and saves you valuable time, plus it has the added advantage that you can do business at a time that is most convenient for you. Shell eServe gives users much greater functionality and freedom including the ability to: · Place an order · View account information · View order status · View and download sales amount and volume report · View order history · View and download Product Information. As a Developer, I am responsible for: Involved in the development and designing of different modules using C# and ASP.NET. Created various reports using complex queries to be accessed by different groups of users like knowing the order status, information on various products in various countries and their daily prices, Order history details. Made use of SSRS snapshots for frequently used reports, thereby reducing the overhead on the SQL Server without the need to execute the report each time for data that is not changed very frequently. Error Detection, Static code analysis, Code Merging.

Data Migration Tool is a data profiling tool used for data migrations. Using this legacy data is received, consolidated, cleansed and converted into SAP standard formats by applying business rules. Final cleansed data is reconciled and exported in SAP readable format and uploaded into SAP using standard SAP tools. As a Developer, I am responsible for: Developing code for Production plan and quality managements Analysis of Data Consolidation and translation of the data by running different SSIS packages Created various chart and tabular reports by using SSRS Database management and connectivity Preparation of Technical Design Documents. Preparing Test cases for Unit Testing and execution

HCU– ADMS is pools of experts who help project teams across Satyam deliver best-in-class applications to its customers. We are a team of professionals with expertise in the area of Open Source, Application Management, High End Mainframe Consulting, Microsoft Technologies Service Oriented Architecture Competency, and Application Transformation. HCU-ADMS collaborates with various verticals to help bring business, win large deals and architect solutions by offering high end consulting and showcasing competencies. The unit is constantly working on the above mentioned lines of services and competencies. ADMS manages alliance partnership with several emerging technology vendors and is working with different units to standardize tools being used across the Organization to reduce cost. The unit has also conducted several associate enrichment programs aimed at improving competency levels across Satyam. Today, HCU–ADMS is helping different verticals bring out one Satyam experience to the external world - customers, analysts etc. ADMS is constantly building assets, which can be used and leveraged by units across Satyam. We are collating methodologies, best practices and tools that can help you deliver better. As a Software Developer, I am responsible for: Sharing sessions with the project teams. Showcasing new MS technology developments through prototypes, whitepapers and Web casts. Developing the SSRS Reports and Integration with the UI. Developed the SSIS Packages and Integrated with the UI. Developed the SSIS packages and SSRS Reports using Analysis Services cubes with the MDX queries. In addition would participate in carving our course contents for various learning programs for associates in collaboration with Satyam Learning Center. Involved in preparing the documentation on all the new .Net technologies. Design and Develop database objects and structures for data storage, retrieval and reporting according to project specifications including the creation, modification, testing, performance tuning, and review of tables, stored procedures, database functions, and triggers.