Architect

Other

•   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.

• 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.

Data Engineer

• 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- Solution Architect

• 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.

BI- System Analyst

• 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.

ETL Architect

• 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.

Sr. Informatica Developer

Find out detailed information about sachin lokhande, Architect in bellevue, WA

sachin lokhande: Architect in bellevue, WA

sachin lokhande