Jan 2021 – Jan 2022 · 1 yr · Hyderabad, Telangana, India · On-site

• Served as a primary contact for data management engagement on strategic company initiatives, and cross-departmental projects, contributing to design decisions, documentation, and information.
• Delivered data cleansing solutions, data lineage diagrams, mapping and transformations rules, data integrity solutions for applications, conversion, integration, and production support issues.
• Created common naming and ubiquitous language for data elements which enabled integration, communications, and clarity between applications by composing, establishing, publishing, and socializing models and definition standards.
• Established enterprise data architecture, data warehouse best practices and standards; database, ETL, and BI architecture and performance tuning techniques, design/develop dimensional data models and ETL processes.
• Define and maintain the architectural frameworks/patterns, processes, standards, and guidelines related to systems, business, and data architecture.
• Created data governance framework for master data (customer, prospect, and products) across corporate functions.
• Worked on the migration of the previous history into the new disposition codes tables for enabling full historical analysis.
• Experienced in creating Triggers on the TAC server to schedule Talend jobs to run on the server possessing excellent knowledge in the deployment process from DEV to QA, UAT, and PROD.
• Authored comprehensive documentation and metadata supporting the data warehouse and validated the design anomalies.
• Headed the design and implementation of Databases over MS SQL Server right from monitoring, tuning, and analyzing DB performance and allocating server resources to achieve optimum DB performance through various query-optimization techniques.

Jan 2011 – Jan 2021 · 10 yrs · Hyderabad Area, India · On-site

• Involved in gathering, analyzing, and documenting business requirements, functional requirements, and data specifications for Business Objects Universes and Reports.
• Possess excellent analytical thinking in shifting raw data into meaningful insights using Power BI, to build interactive and visually appealing dashboards and reports with extensive knowledge of DAX.
• Advanced knowledge working with DAX Functions & M-Query.
• Expertise in implementing row-level security on data and understanding application security layer models in Power BI.
• Headed the automation of various tasks in Power BI (Data Gateways, Scheduling, Power BI Data Flows, Refreshes, etc.)
• Led the designing and development of multi-dimensional objects like Cubes & Dimensions using SQL Server Analysis Services (SSAS) and multi-dimensional eXpressions (MDX) to create the required metrics as per the requirements.
• Generated reports using SSRS, and Excel (Pivot) that could be used to send information to diverse groups of users, clients, and managers.
• Analysed the functional needs for BI and Data Analytics, interacting with Source SMEs to capture business rules and data transformation roles.
• Documented end-to-end flows including business rules, security/governance, and audit the usage.
• Implemented the processes and procedures in support of data mart/data warehouse performance tuning, optimization, backup, and recovery, operation manuals, checklists, change management, change control, and data governance documentation.
• Headed the design and implementation of Databases over MS SQL Server right from monitoring, tuning, and analyzing DB performance and allocating server resources to achieve optimum DB performance through various query-optimization techniques.
• Developed SQL Dashboard for monitoring servers using PowerShell, SSRS, SSIS, and TSQL and developed packages for gathering Server level information and automating database-level tasks

Jul 2009 – Jan 2011 · 1 yr 6 mos · Hyderabad, Telangana, India · On-site

Jan 2009 – Jun 2009 · 5 mos · Chennai Area, India · On-site

Feb 2007 – Jan 2009 · 1 yr 11 mos · Chennai Area, India · On-site