sachin lokhande: Architect in bellevue, WA

• Highly interactive in business requirement sessions with project stakeholders, SME & DBA. • Translating business user stories in to technical specification for feasibility & offers. • Design, build and deploy BI solutions that provide accessible information for decision making. • communication with business/technical team to develop business capabilities, technical solutions & BI reporting solutions. • Design and developed logical & Physical data model & HLSD diagram from SRC to TGT. • Design & develop data pipeline rules to move on premises data to the cloud environment. • Design reporting data model, developed BI reports for subscriber life cycle analysis & resolution. • Writing STTM (Source-to-Target) mapping to extract data from legacy system, data analysis, data profiling & implement all business logic. • Performing Data Analysis, system analysis task and managing other team members with tight time line deliverables with quality. • Experience with Power BI data model to use for report generation. Write Power BI-DAX code to perform business logic and functionality calculations. • Experience to write custom programs to parse and manipulate structured & semi-structured data. • Experience to implement complex business rules/logic in program code. Experience with data quality practices and patterns in a DW environment. • Design and define Data Pipeline data load and testing process matches with business scenarios. • Mentoring development/testing team and resolving technical complexity & improve performance • Maintain requirement status open/close & approved in Quality Control (QC) on weekly basis. • Participate in design and code review to ensure quality and error free code Environment: Oracle, SQL server, Teradata, Informatica, Power BI, Azure Data Factory, Azure Data Lake, HDInsight.

• Collect requirements from Direct TV and ATT marketing business team. • Defined parameters to satisfy internal legal mandate to provide a data credit to certain customers. • Define SOC's rules to include in binge streamer reports & defined a standard MDE template. • Expertise is in data relationships, data profiling and data analysis. • Create STTM for loading data in to EDW data warehouse based on the business requirements. • Extract data from legacy systems, build data pipeline and upload to the Azure Data Lake. • Azure Data factory used to integrate on-premises and Data lake data and store in target database. • Design & Developed BI Reporting data model as per the client requirement. • Design, schedule to run, share the reports with business stake holders and review the BI reports. 2 • Design & developed gross add, customer churn rate, monthly usages activation summary & rate plan analysis BI reports. • Strong knowledge of Power BI data querying and modeling capabilities, such as creation of calculated columns, DAX, measures, and relationships. • Design reporting dashboard based on business reporting requirements. • Perform design and code review on ETL (extract, transform, and load) activities. • Taken care of data latency from legacy to destination with proper performance tuning. Environment: Oracle, Teradata, Erwin, SQL Server, SSIS, SSAS, Azure Data Lake, Azure Data factory, HD insight & power BI.

• Actively involved in service message reporting requirement gathering, planning & estimate of task of marketing business capability model. • Interact & prioritized business critical requirement by interacting with solution owner. • Prepared & reviewed HLSD solution with solution owner, program manager, business SME along with Data Architect. • Design IDW architecture repository diagram to break down it in to each business capability level which have Finance, sales, Marketing, HR, Product and customer support business group. • Design & developed each source system data flow diagram as well as data flow details including Hadoop eco component data flow. • Develop ETL audits and controls to ensure quality of data meets or exceeds defined standards and thresholds. Preparing STTM for each service message reporting. • Time to time updated to the solution owner and program manager about development cycle. • Actively involved in analysis, design on all the life cycle of IDW development & other projects. • Participate in design and code review to ensure quality and error free code. • Time to time updated to the solution owner and program manager about development cycle. • Working knowledge of HIVE for big data analysis. Environment: Teradata, Oracle, SQL Server, Informatica, SSIS, HIVEQL, UNIX, VISIO, Erwin,

• Worked with business team to conclude business requirement & SCMS Adapter reporting needs. • Analyzed and presented business processes & requirements to an Ericson team member. • Designed data models, based on CDC requirements and high-level design documents. • Expert in source to target (STTM) creation & review development team coding, • Maintain requirement status open/close & approved in Quality Control (QC) on weekly basis. • Participate in design and code review to ensure quality and error free code • Experience in analyzing data using SQL. Review & modified testing team test case scenarios. • Informatica ETL Mapping, Mapplet, Sessions, Workflow task, scheduling & workflow execution. • Defined mapping naming standards and define execution order based on business requirements. • Expert in understanding session log and ETL performance tuning. 3 Environment: Informatica, Oracle, Teradata, SSIS, Erwin, UNIX, Amdocs & Ericsson Billing system.

• Proficient in understanding the business issues and data challenges of the client's organization. • Produced LDM/PDM specifications and source to target mapping logic. • Documented ETL programs, business processes & made recommendations for improvements. • Developed several ETL jobs business logics as per the business requirement. • Migration from SSIS to Informatica for specific LOB database. • Developed data cleansing ETL mappings documentation deal with production environment performance tuning of ETL issues. Environment: Informatica 8.6, MS SSIS, Oracle, Teradata, Mainframe and UNIX scripting.

• Mapping developed to various dimensions. • Parameter files and mapping variables were used extensively to improve performance. • ETL tools used to design and develop mappings and loading data into different targets. • Written test cases and test scripts for testing the mappings. Environment: Informatica, SQL server 2005, Mainframe Copy book, flat files, Excel file, Windows XP.