SUMMARY

• 8+ years of Experience as DataAnalyst working in E - commerce, Retail Sales lifecycle and theRetail E-commerceecosystem, OMS, Product Development, WMS, Fulfilment, TMS and Support.
• Extensive knowledge of the Data Profiling,Data Migration,Data Masking, Data Integration,Data governance and Metadata Management, MasterDataManagement and Configuration Management.
• Strong understanding and experience inData Analysis, Data Warehouseand with a solid understanding of Business Requirement Gathering, Business Process Flow, Business Process Modelling, Business Process Re - Engineering, Data Analysis, Data Mapping and Data Modelling.
• Expertise in Software Development Life Cycle (SDLC) methodologies such asRUP, Agile (SCRUM, KANBAN)/ Waterfall/ Spiral methodologies with hands-on experience in all of them.
• Experience in Change Management Process (Identify, Analyze, Evaluate, Plan, Implement, Review and Close)
• Extensive experience in UML using Flow Charts, Use Cases, Sequential diagrams, Activity diagrams and State Transition diagrams
• 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
• Excellent technical writing and documentation skills, Business Requirement Documented (BRD), Functional Requirement Documents (FRD) and System Requirements Specifications (SRS).
• Solid understanding of Business Process Modeling, Business Requirements Gathering, Business Process Flow, Systems Analysis, Data Analyst, Data Modeling, Data Profiling, Data Warehousing, Data Mapping and Testing.
• Expertise withsupply chain strategies/vendor manufacturing process methods to determine the level of procurement and strategic sourcing strategies/plans and worked with vendors/peers to determine lead times, schedules and cycle counts, established requirements needs.
• Strong Work experience in E-commerce portals web application developments,B2B, B2C, Content Management Systemsfor E-commerce likeATG and IBM WebSphere Commerce.
• Experience working with Content Management Systems (CMS), Order Management System (OMS) Supply Chain Management andUXteams.
• Skilled in converting legacy reports to more contemporary programs such as Crystal Reports, Business Objects, MS Excel, MS Access, SQL, MS SQL, PL/SQL and condensing number of reports to simplify processes
• Expertise and hands-on experience in SQL and RDBMS for Analysis, Reporting and testing purpose.
• Experience in writing and executing SQLQueries for Databases such asTeradata, Oracle, andMySQL.
• Experience in the Informatica, MSBI/ETL(Extract, Transform and Load) of data into a data warehouse/data mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Expertise in translating Business needs into end-user reports with Business Intelligence Tools likeTableau, Power BI.
• UsedRational Clear Questfor tracking and prioritizing defects and for enhancements after baselining the requirements.
• Experience in web analytics using different tools like Adobe/ Omniture Web Analytics and Google Analytics.
• Proficient in MS Office, MS Project and MS Visio and experienced in SQL.
• Responsible for initial phases of data integration for enterprise wide Application Using Service Oriented Architecture (SOA).
• Expert level knowledge in Data Profiling, Data Quality, Data Cleansing, Master Data Management, Data Governance, Predictive Analysis, Data Quality Dimensions, Data Mapping, Entity Resolution.
• Knowledge in the ETL (Extract, Transform and Load) ofdatainto adataware house/date mart andBusinessIntelligence (BI) tools likeBusinessObjects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Worked in the ETL Procedures and processes. Reconciled disparate master data from distributed systems and synchronized this reliabledatawith analytical and operational systems using masterdatamanagement (MDM) Data Governance solution.
• Expertise in analysis, design and implementation of data warehousing applications usingTableau,Teradata, Google Analytics, Informatica, Unix, DB2, Oracle, OBIEEtechnologies.
• Extensive experience in data warehousing tools and technology such as Informatica PowerCenter, PowerExchange, Metadata Manager, MDM, OBIEE,Qlikview, SSIS, SSRS, MicroStrategy etc.
• Strong Knowledge of SDLC methodology and project life cycle, UML, RUP and Rational Suite including Rational ClearQuest, ClearCase and RequisitePro. Experienced in full life cycle of system development.
• Proven strength in problem-solving, system analysis and strong analytical and product management.
• Solid Experience in the subject area of Business Intellignece Data warehousing, Reporting (Tableau) and ETL processasData Analyst
• Extensive knowledge on Data warehouse Concepts such as designing and implementation ofData MartswithStar, Snow flakeschemas and thorough understanding of new age Data warehouse concepts likeRDM,MDM,ODS, RDWs, File aid, JCL, SQL, QMF, MICROSOFT WORD and EXCEL
• Experienced in SQL, Access, Excel, AdobeDigitalMarketingSuit, and internally developedbusiness data andmarketingtools. Also experienced in UX design & testing and E-Commerce web production.
• Proficient across the entire pipeline fromdata wrangling, feature selection, model evaluation, API creation, up to data product.
• Worked on variety of tools including Tableau,Datameer,Spotfire,Informatica, Microstatergy and Nice Actimize
• Expertise in building complex SQL Queries to performdata mining, data analytics, and data extractionsacrossdatabases using WinSQL, Putty and Dbeaver
• Extensive experience on building dashboards usingTableaufrom various database( MELD, HIVE and Vertica )
• Proficient in preparingTest Scenarios, Test Cases, & Test Artifactsfor successful execution of the product.
• Performed in User Acceptance Testing(UAT) and in various testing strategies. Knowledge in software testing, process testing and quality control.

TECHNICAL SKILLS

• SQL Server
• Oracle
• MS access
• DB2
• UDB
• TERADATA
• Sybase
• MySQL
• Erwin
• Power designer
• Oracle Designer
• ER/ Studio
• Rational Rose
• MS Visio
• Embarcadero
• OBIEE
• Micro Strategy
• Qlikview
• Crystal Reports
• Cognos
• SSRS
• Informatica
• SSIS
• C
• C++
• Java
• UNIX shell
• Visual Basic
• COBOL
• Microsoft Windows
• CRM
• Google Analytics
• Linux and UNIX
• MS Office (Word
• Excel
• Power Point)
• MS Project.

PROFESSIONAL EXPERIENCE

Confidential, Dublin, CA

Sr. Business Data Analyst

Responsibilities:

• Analyzed the large sets ofdatausing 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 endsystemslike 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 performingdatacompiling,miningand analysis required to evaluate the givendata
• Maintain the research database, update and upgrade it from time to time and ensure safe storage ofdata.
• Carry out analysis of the givendataand draw correct inferences, in keeping the objectives of the analysis.
• Review current operationaldatastructures and recommend optimized database design for newdata requirements, with integration into the enterprisedatamodels, and MasterDataServices in a federated framework architecture.
• UsedDataBlending techniques, parameters, table calculations, bins, action filter and highlighting for thedatavisualization. Used Excel fordatacleaning and preparation.
• Calculated the specified problem and examine for solutions usingdataanalysis practices and arrange analysis reports.
• Monitored company’s website UX and traffic usingGoogle Analyticsto improve inefficiencies and identify trends.
• Actively managed the product development and other required regulatory compliances.
• Used Pandas API to put the data as time series and tabular format for east timestamp data manipulation and retrieval.
• Gathereddatathat is necessary to accomplish analysis from a number of sources accumulate it together in prearranged format and enter thedatain severaldataanalysis software.
• Perform in-depth sourcedataanalysis and source-to-target gap analysis. Document the source-to-targetdatamappings for ETL design.
• Performed in developing all the ETL processes developed for fetchingdatafrom OLTP systems to the target Market Data warehouse using complex SQL queries.
• Assisted in developing PL/SQL procedures that were developed to load thedatafrom temporary tables in staging to target tables in thedatawarehouse
• Maintained all the SQL documents which included installation anddataconversion Procedure documents.
• Extracted thedatafrom the different sources and stored thedatainto the intermediate Staging Database using the SSIS ETL tool.
• Hands on experience on working with the Customer Relationship Management (CRM) tools to meet the requirements of the clients/end users.
• Extracteddatafrom 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 Inputdata(Text files, XML files) before loading into target database.
• Expertise in project management, product development, object modeling, data modeling, data analysis, gap analysis, content analysis, software quality assurance testing, and user acceptance testing.
• Acted as Subject Matter Expert and Alteryx Advisor for AGILE Team and used Alteryx as a rapid prototyping and quality assurance tool using workflows to perform ETL and data cleansing for Enterprise “Big Data” CRM initiative.
• Wrote complex Stored Procedures, coding and triggers to capture UPDATED and deleteddatafrom OLTP systems.
• Developed SQL Joins, SQL queries, tuned SQL, views, test tables, scripts in development environment.
• Developed test cases and wrote test plans to help developers locate and fix the defects, as well as tracking issues with JIRA and discover possible gaps in corporatedatawarehouse on project scope.
• 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 visualizedataand customized SAP Crystal Reports tool to generate different report layouts to satisfy stakeholders’ needs as aDataAnalyst.
• Utilized Oracle SQL queries to accessdatastored in thedatawarehouse 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, New York, NY

Business Data Analyst

Responsibilities:

• Perform DataAnalysis Primarily IdentifyingDataSets, SourceData, Source Metadata,Data Definitions andDataFormats.
• 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 for new Facets, BOPUS, BOSTS, Pre-sell and Available in Store.
• W inDataAnalysis,DataValidation,DataCleansing,DataVerification and IdentifyingData Mismatch.
• Participate in defining and establishing the Client MasterDatamanagement (MDM) organization within the EnterpriseDataOffice
• 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 masterdatamanagement (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.
• Performed 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.
• Performed in migration of various objects like, stored procedures, tables, views from various data source to SQL Server.
• Extracted data from multiple data source, write python (scrapy package, selenium) scripts to scrape data and images from ecommerce websites (web API scraping)
• 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.
• Performed in developing Oracle PL/SQL and Shell Scripts,DataImport/Export,DataConversions andDataCleansing.
• Extensively used PL/SQL tables and Bulk loader programs for processingdataand loading into Oracle tables.
• Conducted meetings withDataconversion team in order to provide source-to-source stagingdata requirements/ definitions/ for mapping purposes.
• ConductedDataCleansing for migratingdatafrom legacy system to the newdatawarehouse and performedDataconversion validation testing to make sure there is seamless conversion ofdatafrom current system to new System.
• Worked with the clients and end users to gather and understand the business requirements by using Microsoft Dynamics as the CRM tool.
• PerformDataConversion/Datamigration using Informatica PowerCenter.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Hands on experience in Data Warehouse/Analytics product development experience covering all phases of SDLC including using both Agile and Waterfall Methodology. Experienced on Talend Bigdata Integration Suite for Design and development of ETL/Bigdata code and Mappings.
• 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.
• Responsible for executing User Interface Testing, System Testing, Data Quality Testing on the configuration design and prototypes.
• Performed indataconversionsand extracteddatausing SSIS packages (ETL) to transferdatafrom different server locations and heterogeneous sources like Oracle, Excel, CSV, flat file, XML and Text FormatData.
• Worked on SQL queries to retrieve data from Oracle for white box testing.
• Creating SQL Queries to validatedatabetween source and target systems
• Experienced in writing complexSQLqueries for extracting data from multiple tables.
• Used SQL Queries to verify and validateDatapopulated in Front-End is consistent with that of Backend, used Insert, Update, Aggregate and Join queries.
• Experties in an assortment of technologies Extract Transform Loading ETL, Scripting Languages, Customer Relationship Management CRM.
• 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.
• Proposed solutions to reporting needs and develop prototypes using SQL and Business Objects that address these needs.
• Set up definitions and process for test phases including product test, integration test, and system test. Work to fully implement test phase entry and exit quality criteria, standard test reporting metrics and standard test artifacts.

Confidential, Chicago, IL

Data Analyst

Responsibilities:

• Document alldatamapping and transformation processes in the Functional Design documents based on the business requirements.
• Performed inDatamining, transformation and loading from the source systems to the target system
• Performed in defining the source to targetdatamappings, business rules, business anddata definitions
• Provided qualitydatareview for completeness, inconsistencies, erroneous and missingdata according todatareview plan
• Prepared High Level LogicalDataModels using Erwin, and later translated the model into physical model using the Forward Engineering technique.
• Madedatachart presentations and coded variables from originaldata, 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 masterdata.
• Loaded operationaldatafrom Oracle, flat files, XML files, Excel spreadsheets into Oracle targetdatamart and used Informatica Power Exchange for mainframe sources, such asCOBOLfiles.
• 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.
• Performed in extensiveDATAvalidation using SQL queries and back-end testing
• Contributed to the initialdatamining 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 ofdatainaccuracies and improved the quality ofdataby usingDataFlux
• Resolved conflicts between business and system teams
• Wrote complex SQL, T/SQL Testing scripts for Backend Testing of thedatawarehouse 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
• Performed in Documenting/Executing business test cases
• Wrote SQL queries to validate sourcedataversusdatain thedatawarehouse 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.
• Performed in pre and post session migration planning for optimizingdataload performance.
• Facilitated periodicdataloading 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 fasterdata loads to thedatamart.
• 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, New York, NY

Data Analyst

Responsibilities:

• Responsible for evaluating various RDBMS like OLTP modeling, documentation, and metadata reporting tools including Erwin, and Power Designer Developed logical/ physicaldatamodels using Erwin tool across the subject areas based on the specifications and established referential integrity of the system.
• Utilized Informatica toolset (InformaticaDataExplorer, and InformaticaDataQuality) to analyze legacy data for data profiling.
• Performed DetailedDataAnalysis (DDA),DataQuality Analysis (DQA) andDataprofiling on sourceData.
• Normalized the database to put them into the 3NF of thedatawarehouse.
• Provided technical support during delivery of MDM (MasterDataManagement) components.
• Identified and understood the business function activities, entities,dataattributes, 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,DataGovernance and Integration team leads are deeply performed 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 logicaldatamodel 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 Cognosdata.
• Perform gap analysis of current state to desired state and document requirements for control gaps identified
• Changed existingdatamodel as per business requirements.
• Ensured productiondatabeing replicated intodatawarehouse without anydataanomalies from the processing databases.
• Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about thedatamodel and business requirements.
• Wrote requirements for designingdatamarts that were used as a source for the various reporting systems in the company. PerformedDataAnalysis,Dataprofiling andDatavalidation by writing SQL queries using TOAD.
• Performed in defect management, including root cause analysis, solution recommendations (s), and next step coordination.
• Conducted UAT fordataintegrity. 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 anddatapulls.
• Synthesized testdatathrough various sources, Records/enusers/SME/BA/meetings and facilitated Testing Performed functional, integration, system, UAT and regression testing Identified problems and isolated software defects,dataissues and user issues.
• Queried database using SQL queries to ensuredataintegrity and to validate the inserted and updateddata.
• Assisted the team to built DDL's from physical database structures using forward engineering technique fromDatamodel and worked with DTG group to get it executed on Database.
• Provided production support and performed enhancement on existing projects.

Confidential, Framingham, MA

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
• Responsible for store development tasks; oversaw the opening of 50+ new stores from an IT perspective. This included the installation of in-store POS, EMV card reader, WAN connectivity and inventory management equipment. Ensured PCI (DSS 3.0) compliance was maintained throughout
• 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.