• Created business requirement document and functional requirement document by gathering requirements through frequent discussions with the business users and SMEs.• Created detailed data discovery documents for each source. • Documented the Source to Target mapping documents with data transformation logic.• Wrote user stories and created process/Data Flow diagrams and flowcharts using MS Visio.• Wrote and executed complex SQL queries for accessing, analyzing and manipulating the schedule data.• Facilitated various workshop and session to identify business rules and requirements.• Experience using Presto, Hive and Jupyter notebooks to query the datasets.• Involved in Normalization/De-normalization techniques for optimum performance in relational and dimensional database environments.• Performed data cleaning based on imputation methods including regression imputation.• Analyzed the pattern on data and found the best suited algorithm for predictive analytics.• Built a Structured Analytical Data Framework in terms of relational and dimensional databases using SQL, Python and Excel and created a standard metadata for the HR team.• Worked with Enterprise Data Warehouse team and business intelligence architecture team to understand repository objects supporting business requirement and process• Performed detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data Profiling on source data• Hands on experience working with Snowflake database.

• Interact with Business, SME, Design team to understand business requirement and prepare BRD, Data Mapping and Technical Design documents. • Attending various meetings with business/clients on requirement clarifications, design walk through sessions for the projects.• Crated Jira stories for sprints and also maintained backlog of the user stories.• Actively participated in all the sprint ceremonies.• Understood business processes from data perspective and converting business logic to SQL, PL SQL codes to facilitate reporting.• Responsible for handing and understanding complex to very complex business logic and writing back end blocks (procedures/functions/packages) to run in Oracle database.• Responsible for the creation of executive dashboards, business requirement documentation, data mapping, data cleansing and data governance processes for monthly business reviews.• Coordinated with Data Architects for designing of business area specific schemas, data modelling and data mapping.• Worked on building a near real time streaming solution using data bricks, Kafka and spark structured streaming that can be used for reporting.• Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2008R2 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained daily and weekly loads of data by creating the corresponding job tasks.Connected to Athena Data source from Tableau and published the tableau data sources.Used Databricks notebooks to do data profiling and also run regression suites after deployments.

• Involved in Performance Measurement to develop measurable indicators that can be systematically tracked to assess progress made in achieving predetermined goals.• Participated in requirement gathering meeting along with the product owner and translated the Business requirements to engineering team.• Analyzed the data collected and process maps to determine the root causes and identify opportunities.• Involved in Performance Measurement of ongoing data collection to determine if a program is implementing activities and achieving objectives.• Create business requirements, technical specifications documents, create use case documents, create test case and manage project work cycles as a member of the ServiceNow development team.• Perform data mining on data using very complex SQL queries and discovered pattern and used extensive SQL for data profiling/analysis to provide guidance in building the data model.• Acquired appropriate business rules in coordination with users to understand the business functionality.• Developed Validation Rules for the Custom Objects and Approvals for some fields. • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.• Designed and implemented report layouts according to reporting standards of the department.• Used MS Visio to develop end-to-end entity relationship diagrams.• Worked with SQL queries using MS Access for data manipulations.

• Involved in requirement gathering and performed ETL Process.• Integrated various sources into the Staging area in Data warehouse to Integrate and for cleansing data.• Involved in building of the Data Warehouse which includes the Design of Data mart using Star Schema• Created the Source and Target Definitions in Informatica Power Center Designer• Optimized the performance of the mappings by various tests on sources, targets, and transformations. Identified and removed bottlenecks in mappings and sessions to provide maximum efficiency and performance.• Worked with PowerBI to build the dashboards.