sachin lokhande
Architect · T-Mobile
bellevue, WAIn My Own Words
• 17+ years of IT experience in the software development life cycle.
• Substantial experience in telecom, insurance, health care & finance industries.
• Expertise in data governance, data quality, data modeling, data classification & BI Reporting.
• Design & developed conceptual, logical & physical DWH-BI data model & data flow diagrams.
• Developed star and snowflake schema diagrams as per the business and project goal.
• Create source to target mapping to extract data from legacy systems & implement business logic.
• Design & developed ETL solutions, BI reports, dashboard and perform data analysis.
• Experience with data pipeline technical architectures, ETL/ELT, and reporting/analytic tools.
• Performing data & system analysis, data profiling & querying large data sets to analysis business
technical requirements.
• Experience in developing BI solutions using Informatica ETL and Power BI technology.
• Extract data from legacy systems, build data pipeline and upload to the Azure Data warehouse.
• Experience in Microsoft Azure Data Factory, Data Lake, Azure SQL Database & HDInsight.
• Maintaining data repository with data definitions, relationships, cardinality and sources.
• Communication between business and technical team to prioritize business needs.
• Data Analyst with strong experience in data validation, prepare UAT, developing test scenarios.
• ETL Data Loading, SQL Performance tuning and DWH-BI implementation best practices.
• Evaluate & improve existing BI systems data pipeline, developed Power BI data model
Participate in design and code review to ensure quality and error free code.
• Developing visual reports, dashboards and KPI scorecards using Power BI desktop.
• Mentor ETL team & review developed code as well as suggested best ETL practices.
• Experience of Agile Spring life cycle (user stories, planning, execution, release & retrospection).
• Working experience in Agile & waterfall model, used JIRA for agile projects.
Work Experience
Architect
T-Mobile2018 – Present
• 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.
Data Engineer
AT&T2016 – 2018
• 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.
BI- Solution Architect
T-Mobile2015 – 2016
• 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,
BI- System Analyst
T-Mobile2012 – 2015
• 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.
ETL Architect
HCA2010 – 2012
• 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.
Sr. Informatica Developer
Marsh and McLennan2003 – 2008
• 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.