SUMMARY

• 8+ years of experience as a Data Analyst in Retail & ecommerce industry working with Data Profiling, Data Migration, Data Integration,, Master Data Management and Configuration Management.
• Experienced in SQL, Access, Excel, Adobe Digital Marketing Suit, and internally developed business data and marketing tools. Also experienced in eCommerce web production.
• Experience working on Merchandising, Point of Sale (POS) Systems, Ecommerce and Supply chain systems.
• Broad knowledge of multi - channel retail business and systems, Warehouse Management/Distribution Systems, and Inventory Systems (stores and warehouses).
• Expert in Data Analytics, DW/ETL, BI report development, data mining, data cleansing, analysis and database programming.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export through the use of MS SQL Server and Informatica Data Quality tools.
• Extensive experience with data mapping, testing, training, conversion, system upgrade and post-conversion support involving strong analytical and problem-solving skills.
• Strong Work experience in E-commerce portals web application developments, B2B, B2C, Content Management Systems for E-commerce like ATG and IBM WebSphere Commerce.
• Experience working with data modeling tools like Erwin, Power Designer and ER Studio.
• Experience in support of IBM Mainframe applications - MVS, COBOL, CICS, VSAM, JCL, PROCs, VSAM, IMS, File aid, JCL, SQL, QMF, MICROSOFT WORD, EXCEL.
• Experience with the technical integration requirements which included the Warehouse Management System (WMS), Retail Management System (RMS), Point of Sales (POS) System, Order Management System, Omni-Channel, Inventory Management, E-Commerce Ship from Store, and the BI data warehouse.
• Extensive experience in data warehousing tools and technology such as Informatica PowerCenter, PowerExchange, Metadata Manager, MDM, OBIEE, Qlikview, SSIS, SSRS, MicroStrategy, etc.
• Expertise in implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Server Reporting Services (SSRS).
• Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS.
• Expertise in importing data from COBOL Files, EDI, Flat Files (Fixed Width and Delimited), and XML files and different relational sources like Oracle, DB2, and SQL Server.
• Advanced knowledge of Excel for using Pivot tables, Power Pivot.
• Experience in creating interactive dashboard and Reports in Tableau for monitoring the operation performance on day to day basis.
• Well versed in Normalization / Denormalization techniques for optimum performance in relational and dimensional database environments.
• Very proficient with Data Analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration.
• Experience in Data Scrubbing/Cleansing, Data Quality, Data Mapping, Data Modeling, Data Profiling, DataValidation in ETL.
• Experience in creating and documenting Metadata for OLTP and OLAP when designing a system.
• Extensive Data Warehousing experience using Informatica as ETL tool on various data bases like Oracle, SQL Server, Teradata, MS Access.
• Extensive experience in development of T-SQL, DTS, OLAP, PL/SQL, Stored Procedures, Triggers, Functions, Packages, performance tuning and optimization for business logic implementation.
• Experience in data transformation, data mapping from source to target database schemas and datacleansing procedures using Informatica Power Center and SSIS.
• Familiarity with Crystal Reports, Cognos and SSRS -Query, Reporting, Analysis and Enterprise Information Management.
• Proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Well versed with Data profiling, Data Migration and Data Conversions.
• Expertise in analysis, design and implementation of data warehousing applications using Tableau, Teradata, Google Analytics, Informatica, Unix, DB2, Oracle, OBIEE technologies.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).

PROFESSIONAL EXPERIENCE

Confidential, NY

Sr. Data Analyst

Responsibilities:

• Involved with Data Analysis Primarily Identifying Data Sets, Source Data, Source Metadata, Data Definitions and Data Formats.
• Worked on identifying existing Product Data and Inventory Data attributes and mapping them with redesign requirements and came up with suggestions on new Product Data and Inventory Data attributes that were needed to meet new requirements and Available in Store.
• Involved in Data Analysis, Data Validation, Data Cleansing, Data Verification and Identifying Data Mismatch.
• Participate in defining and establishing the Client Master Data management (MDM) organization within the Enterprise Data Office
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Assess and coordinate the prioritization of requirements of cross enterprise business segments for in corporation into the enterprise master data management (MDM) solution.
• Performed Count Validation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Performed data analysis and documented Source to Target mapping, Data quality checks, Datasharing agreements and documents.
• Involved in migration projects to migrate data from data warehouses on Oracle and migrated those to DB2.
• Performed data auditing, validation and cleansing as well as metadata mapping and migrations.
• Involved in migration of various objects like, stored procedures, tables, views from various data source to SQL Server.
• Work with Data Migration team in determining the data elements and period for data migration
• Performed the analysis and visualization of the data through Qlikview.
• Involved in developing Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing.
• Extensively used PL/SQL tables and Bulk loader programs for processing data and loading into Oracle tables.
• Conducted meetings with Data conversion team in order to provide source-to-source staging data requirements/ definitions/ for mapping purposes.
• Conducted Data Cleansing for migrating data from legacy system to the new data warehouse and performed Data conversion validation testing to make sure there is seamless conversion of data from current system to new System.
• Perform Data Conversion/Data migration using Informatica PowerCenter.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Provided technical Expertise on the use of Rational Clear Case, Rational clear quest and Requisite pro, which were used for Data archiving and Requirements Management.
• Involved in data conversions and extracted data using SSIS packages (ETL) to transfer data from different server locations and heterogeneous sources like Oracle, Excel, CSV, flat file, XML and Text Format Data.
• Worked on SQL queries to retrieve data from Oracle for white box testing.
• Creating SQL Queries to validate data between source and target systems
• Experienced in writing complex SQL queries for extracting data from multiple tables.
• Used SQL Queries to verify and validate Data populated in Front-End is consistent with that of Backend, used Insert, Update, Aggregate and Join queries.
• Used BEA (BPM Tool) to map Process flows and migrated Visio Process flows into BEA Tool.
• Created Data Dictionary and ER diagrams for data mapping purposes.
• Performed source data profiling to verify that data meets the business requirements.
• Worked on issues with migration of Data from development to QA-Test Environment
• Understood core processes of the departments to provide input on re-engineering or Streamline opportunities.
• Worked on different modules and analyzed the bugs in Defect manager in the Test Director reported by the users during the UAT.
• Proposed solutions to reporting needs and develop prototypes using SQL and Business Objects that address these needs.

Confidential - Syracuse, NY

Data Analyst

Responsibilities:

• Analyzed the large sets of data using various techniques such as quantitative analysis, advanced analytics and statistical modeling to find solutions.
• Interfaced and integrated middleware APIs with Front end clients like QuikView, Retail .Net platform, Magenta UI and back end systems like Identity Access Management, Customer Hub, Documentum, etc.,
• Analysed the PCI DSS to create an additional level of protection for card issuers by ensuring that merchants meet minimum levels of security when they store, process and transmit cardholder data.
• Assist the organization in performing data compiling, mining and analysis required to evaluate the given data
• Maintain the research database, update and upgrade it from time to time and ensure safe storage of data.
• Carry out analysis of the given data and draw correct inferences, in keeping the objectives of the analysis.
• Review current operational data structures and recommend optimized database design for new data requirements, with integration into the enterprise data models, and Master Data Services in a federated framework architecture.
• Used Data Blending techniques, parameters, table calculations, bins, action filter and highlighting for the data visualization. Used Excel for data cleaning and preparation.
• Calculated the specified problem and examine for solutions using data analysis practices and arrange analysis reports.
• Gathered data that is necessary to accomplish analysis from a number of sources accumulate it together in prearranged format and enter the data in several data analysis software.
• Perform in-depth source data analysis and source-to-target gap analysis. Document the source-to-target data mappings for ETL design.
• Involved in developing all the ETL processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
• Assisted in developing PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Maintained all the SQL documents which included installation and data conversion Procedure documents.
• Extracted the data from the different sources and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Extracted data from Mainframe databases using Power Exchange and loaded into SQL Server Database tables.
• Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS.
• Performed Verification, Validation and Transformations on the Input data (Text files, XML files) before loading into target database.
• Wrote complex Stored Procedures, coding and triggers to capture UPDATED and deleted data from OLTP systems.
• Developed SQL Joins, SQL queries, tuned SQL, views, test tables, scripts in development environment.
• Effectively explored solutions within and outside the scope and brainstormed new solutions for the problems, and maintained Requirement Analysis Report, Preliminary Design Specification, Detailed Design Specification, Workflow Specification, Future Operational Procedures, and other documents.
• Utilized IBM Cognos Business Intelligence to visualize data and customized SAP Crystal Reports tool to generate different report layouts to satisfy stakeholders’ needs as a Data Analyst.
• Utilized Oracle SQL queries to access data stored in the data warehouse for analysis and test the proper implementation of the database. Implemented ETL processes for enterprise migration system.
• Developed the mappings using various transformations according to business partners' requirements.
• Generated Matrix Reports, Drill Down, Drill Through, Sub-Reports, and Chart Reports using SQL Server Reporting Services (SSRS).

Confidential - Monroe, MI

Data Analyst

Responsibilities:

• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Involved in Data mining, transformation and loading from the source systems to the target system
• Involved in defining the source to target data mappings, business rules, business and data definitions
• Provided quality data review for completeness, inconsistencies, erroneous and missing data according to data review plan
• Prepared High Level Logical Data Models using Erwin, and later translated the model into physical model using the Forward Engineering technique.
• Made data chart presentations and coded variables from original data, conducted statistical analysis as and when required and provided summaries of analysis
• Was responsible in using MDM to decide how to manage their life cycle, cardinality, complexity and Collect and analyze metadata about the master data.
• Loaded operational data from Oracle, flat files, XML files, Excel spreadsheets into Oracle target data mart and used
• Informatica Power Exchange for mainframe sources, such as COBOL files.
• Extensively used Informatica Power Center Designer to create a variety of mappings including expression, sequence generator, source qualifier, router, joiner, update strategy, aggregator, stored procedure, and lookup transformations with embedded business logic.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Contributed to the initial data mining work and development of tools and technology
• Initiated detailed discussions/functional walkthroughs with stakeholders
• Produced system documents, functional requirements, ETL mapping and modeling deliverables Worked with root cause of data inaccuracies and improved the quality of data by using Data Flux
• Resolved conflicts between business and system teams
• Wrote complex SQL, T/SQL Testing scripts for Backend Testing of the data warehouse application.
• Assisted developers and testing teams to ensure that the requirements are communicated accurately and that the system being developed is verifiable against the requirements
• Involved in Documenting/Executing business test cases
• Wrote SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.
• Tested whether the reports developed in Business Objects and Crystal Report are as per company standards.
• Tested Ad-hoc reports, drill down and drill through reports using SSRS.
• Tested different detail, summary reports and on demand reports.
• Involved in pre and post session migration planning for optimizing data load performance.
• Facilitated periodic data loading by using reusable transformations, mapplets and worklets.
• Used parameter files to define values for mapping parameters and variables to provide flexibility.
• Implemented the Slowly Changing Dimensions (SCD) of type 1 and type 2 (flag, date) for the purpose of incremental Loading of target database.
• Worked on performance tuning of the SQL queries, Informatica mappings, sessions, and workflows to achieve faster data loads to the data mart.
• Extensively used SQL DDL/DML commands with TOAD environment to create target tables and perform different testing for accuracy & quality.
• Provided status reports to supervisor on a weekly basis and on-call supports.

Confidential - Milwaukee, WI

Business/Data Analyst

Responsibilities:

• Created high quality functional requirement specifications and supporting documents for business systems.
• Performed in E-Commerce POS testing Product Search, Payment System, Online transaction processing
• Documented and Designed UI to help Development team know how Business Requirement gets translated into Application Functionality
• Evaluated and designed data mapping logic to support governance and overall data quality management goals.
• Used data models and designed business Intelligence reports from data warehouses
• Provided product support to Enterprise, Supply Chain, Omni Channel and Order management applications.
• Created and executed SQL queries to find clues on what may be causing the opportunity.
• Performed in implementing Omni channel point of sale (POS) and upgrading Sterling Order Management System (OMS) with third party vendor support.
• Primarily supported data management and business rules when transferring data between systems within the data governance group.
• Maintained Burn down Charts, Sprint Backlog and Product Backlog Sheets; used all SCRUM rituals such as Stand-Up Meeting, Sprint Planning, Sprint Review and Sprint Retrospect.
• Created Functional Unit/String test cases for Sterling Order Management, Warehouse & Inventory Management, and Planning & Procurement.
• Worked on MS Project in scheduling the test plans and release management of project deliverables.
• Developed functional specification and implements store-side order entry system that interfaced with electronic catalog and POS system.
• Designed, created and maintained the project related documentation using MS SharePoint.
• Gathered requirements for Order management, Warehouse management system (WMS), E-commerce B2C and B2B portals.
• Performed presentations using MS Excel and SQL Server / Data analysis
• Performed in CRM processes such as Design, development, planning, testing and integration of Salesforce
• Created internal monitoring alarms and reports by designing queries using SQL.
• Prepared screenshots, UI interface diagrams and wireframes using MS word, PowerPoint and MS Visio.
• Worked with key business stakeholders, engineering development, and PMO on developing system enhancements.
• Participated and provided signoff based on User Acceptance Testing (UAT) results.
• Offered post implementation support on enhancements that have been introduced into production.
• Tracked and reported upon testing activities, including testing results, test case coverage, defects discovered and their status on a weekly basis.

Confidential - Framingham, MA

Data Analyst

Responsibilities:

• Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data profiling on source Data.
• Normalized the database to put them into the 3NF of the data warehouse.
• Provided technical support during delivery of MDM (Master Data Management) components.
• Identified and understood the business function activities, entities, data attributes, table's metadata and documented detailed design specifications for new system.
• Generated reports (SSRS/Crystal) from SQL Server Database and Cubes and included parameterized and cascading parameterized reports to populate drilldowns, drill through, and sub-report.
• Ensured that Business, Data Governance and Integration team leads are deeply involved in critical design issues and decisions
• Closely interacted with developers to understand application functionality and navigational flow and keep them updated about Business strategies.
• Extensively used both Star Schema and Snowflake schema methodologies in building and designing the logical data model in Dimensional Models.
• Created intricate set of SQL tables to hold user login and user access information with constraints and access errors were logged in to error tables.
• Responsible for creating weekly and monthly reports for management based on Cognos data.
• Perform gap analysis of current state to desired state and document requirements for control gaps identified
• Changed existing data model as per business requirements.
• Ensured production data being replicated into data warehouse without any data anomalies from the processing databases.
• Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
• Wrote requirements for designing data marts that were used as a source for the various reporting systems in the company. Performed Data Analysis, Data profiling and Data validation by writing SQL queries using TOAD.
• Involved in defect management, including root cause analysis, solution recommendations (s), and next step coordination.
• Conducted UAT for data integrity. Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes.
• Responsible for supporting the Operations support team with releases deployed to Production. Helped Business in ad-hoc reporting request and data pulls.
• Synthesized test data through various sources, Records/enusers/SME/BA/meetings and facilitated Testing Performed functional, integration, system, UAT and regression testing Identified problems and isolated software defects, data issues and user issues.
• Queried database using SQL queries to ensure data integrity and to validate the inserted and updated data.
• Assisted the team to build DDL's from physical database structures using forward engineering technique from Data model and worked with DTG group to get it executed on Database.
• Provided production support and performed enhancement on existing projects. .