• Utilized Microsoft Azure and ETL techniques for data migration, enhancing data governance and strategies.• Conducted data modeling and analysis, delivering insights and recommendations.• Enhanced data analytics capabilities to gain customer insights, optimize efficiency, and drive decisions.• Created business and functional requirement documents through discussions with users and SMEs.• Developed complex DAX calculations for advanced data analysis and visualization.•… Show more • Utilized Microsoft Azure and ETL techniques for data migration, enhancing data governance and strategies.• Conducted data modeling and analysis, delivering insights and recommendations.• Enhanced data analytics capabilities to gain customer insights, optimize efficiency, and drive decisions.• Created business and functional requirement documents through discussions with users and SMEs.• Developed complex DAX calculations for advanced data analysis and visualization.• Managed project backlogs and tracked tasks using JIRA.• Designed and implemented Power BI dashboards and reports with SQL Server & Tabular SSAS.• Gained hands-on experience with Azure Data Factory, Databricks for data processing.• Utilized Apache Spark for data ingestion and analysis.• Employed various visualization tools including table, card, gauge, slicers, and custom visualizations.• Designed and documented data models using ERwin.• Reviewed and provided feedback on ETL packages and SSRS reports.• Created detailed data discovery documents and source-to-target mappings.• Drafted user stories and created data flow diagrams and flowcharts using MS Visio.• Executed complex SQL queries for data analysis.• Facilitated workshops to identify business rules and requirements.• Utilized Presto, Hive, and Jupyter notebooks for data querying.• Employed normalization and de-normalization techniques for database performance.• Collaborated with the Enterprise Data Warehouse and BI architecture teams.• Conducted detailed data, quality analysis, and profiling on source data.• Maintained technical documentation for ETL processes.• Conducted data profiling and validation using HQL and Spark-SQL.• Prepared and shared project status reports, highlighting progress, milestones, risks.Environment: SQL, Hadoop 3.1, Spark-SQL, MS Project, MS Office, SharePoint, DAX, Hive, Databricks, Visio, MS Outlook, Azure, PowerBI, Agile, Git, Jenkins, JIRA, Data Governance, Documentation. Show less

Led advanced customer segmentation development using agile methodology.• Collaborated with the front store team for requirements gathering and translated into technical specifications.• Extracted data from Teradata and Oracle, and utilized tools like Tableau, SQL, SAS, and web analytics tools.• Developed complex SQL statements using stored procedures and common table expressions (CTEs).• Implemented Tableau for visualizations, crafting complex reports and interactive… Show more Led advanced customer segmentation development using agile methodology.• Collaborated with the front store team for requirements gathering and translated into technical specifications.• Extracted data from Teradata and Oracle, and utilized tools like Tableau, SQL, SAS, and web analytics tools.• Developed complex SQL statements using stored procedures and common table expressions (CTEs).• Implemented Tableau for visualizations, crafting complex reports and interactive dashboards.• Created automated Tableau dashboards for various metrics like Extra Care, Weekly Ad, and Digital Circular.• Conducted A/B testing and performance evaluation of segmentation models.• Analyzed weekly KPI dashboards and generated reports on eCommerce metrics.• Involved in development phases using Agile Scrum methodology.• Built data pipelines for data-informed decision-making.• Developed data mapping, governance, transformation, and cleansing rules for MDM architecture.• Created a long-term data warehouse roadmap, ensuring data quality compliance.• Maintained referential integrity and normalized data structures.• Performed data profiling and quality maintenance.• Compared self-hosted Hadoop with GCP's Data Proc and explored Big Table use cases.• Built Python programs with Apache Beam for data validation in cloud Data Flow.• Used REST API with Python to ingest data into Big Query.• Performed data transformations in Hive, utilizing partitions and buckets.• Designed Google Compute Cloud Data Flow jobs for a 200 PB data lake.• Implemented scripts for loading and querying Google Big Query data.• Provided traffic reporting, conversion analysis, and ad-hoc traffic analyses using Hitbox.Environment: Hadoop 3.3, Spark 3.1, Python, Google Cloud Platform: Data Proc & Big Query, Data Lake, GCS, Hive, Rest API, Agile Methodology, Tableau, SQL Assistance, Adobe, SAS, Web trends, BI tools, Data Governance, Data Mapping, ad-hoc, Data Pipelines, Master Data Management . Show less

• Collaborated with business units, clients, vendors, SMEs, and end users for requirements gathering, translating business needs into measurable and implementable requirements.• Defined project scope, built relationships with vendors and end users, and aligned designs with senior management's business strategies.• Prepared source-to-target mapping documentation and created Functional Specification Documents (FSD) for healthcare data conversion.• Troubleshot production defects… Show more • Collaborated with business units, clients, vendors, SMEs, and end users for requirements gathering, translating business needs into measurable and implementable requirements.• Defined project scope, built relationships with vendors and end users, and aligned designs with senior management's business strategies.• Prepared source-to-target mapping documentation and created Functional Specification Documents (FSD) for healthcare data conversion.• Troubleshot production defects, analyzed regulatory changes, and implemented system fixes.• Ensured HIPAA compliance through stringent data protection measures, regular audits, and staff training.• Enhanced EHR systems to integrate HITECH Act requirements, ensuring data integrity and secure health information exchange.• Monitored GDPR compliance for international data transfers and provided GDPR training.• Reviewed and updated data protection policies with legal and compliance teams to align with HIPAA, HITECH, and GDPR.• Regularly reviewed and updated Business Associate Agreements for HIPAA and HITECH compliance.• Implemented FTP/SFTP connections with PGP encryption and coordinated vendor communication for new SFTP server migration.• Managed migration of 150+ client accounts into EFX using IBM SFG and Anthem FTP.• Used FileZilla for testing connectivity with vendor accounts, addressed connectivity issues, and supported release management activities.• Utilized Visual Studio for running SSIS packages, rerunning failed SQL, and weekly SQL DB refreshes.• Automated manual processes in production with complex SQL queries, creating project automated workflow guidelines.• Coordinated with offshore teams, stakeholders, SMEs, and various project teams.Environment: MS Visio 20028, Word, Excel, PowerPoint, MS SQL Server 2008R2/2012, Windows Server 2003, Windows 2000 / XP, Windows 7, Test/Use case modeling, SDLC, FTP/SFTP, PGP, FileZilla, Putty, TSRM, UNIX, SNOW, HP Quality Center, Share point, Clear Case. Show less

Experienced in Agile and waterfall methodologies, actively participating in daily stand-ups, scrum planning, and managing user stories.• Proficient in requirements management using Microsoft Visio to construct and track workflows/diagrams, and linking them with codes and test cases. Managed Requirements Traceability Matrix.• Skilled in technical tasks including testing and implementing automated notifications for SQL Server Agent Jobs, executing SSIS Packages, and conducting data… Show more Experienced in Agile and waterfall methodologies, actively participating in daily stand-ups, scrum planning, and managing user stories.• Proficient in requirements management using Microsoft Visio to construct and track workflows/diagrams, and linking them with codes and test cases. Managed Requirements Traceability Matrix.• Skilled in technical tasks including testing and implementing automated notifications for SQL Server Agent Jobs, executing SSIS Packages, and conducting data profiling.• Effective liaison between business owners, technical teams, production teams, and end users, organizing meetings to resolve issues and discuss business requirements.• Proficient in technical documentation with expertise in preparing Business Requirements Documents (BRDs) and Functional Requirements Documents (FRDs).• Strong project management skills within Systems Development Life Cycle (SDLC), including process planning, documentation, and creating project plans based on estimates.• Hands-on experience in Quality Assurance with development of test cases, test scripts, entity relationship diagrams, and flow charts using MS Visio. Supported system integration testing (SIT) and user acceptance testing (UAT).• Skilled in data analysis using SQL scripts for verification and validation, and generating reports using SQL Server Reporting Services, Crystal Reports, MS Excel with Power Pivot.• Familiarity with data visualization tools such as Tableau, QlikView, and Crystal Reports for effective data presentation.• Conducted risk analysis and ensured User Interface (UI) consistency and application functionality through rigorous testing.Environment: MS SQL Server, DB2-Main frames, Waterfall, SDLC, UAT, SSRS, Crystal Report, MS SharePoint, SSIS, MS office 2010, Agile, Scrum, Risk Analysis, MS excel 2010, MS PowerPoint 2010 and MS Visio 2010, SharePoint, UNIX, SQL server 2008/2012, Adobe Acrobat XI Pro, Tableau, QlikView, Crystal Reports. Show less

Gathered information and gathered business requirements, designed functional specifications and flowcharts,implementation and integrated it into IT System and new developments. Performed GAP analysis for the modules in production and also conducted feasibility study for the performanceimpact analysis. Worked with business users and technical staffs of all levels and developed test plans for major productionimplementation and release management. Created business flow… Show more Gathered information and gathered business requirements, designed functional specifications and flowcharts,implementation and integrated it into IT System and new developments. Performed GAP analysis for the modules in production and also conducted feasibility study for the performanceimpact analysis. Worked with business users and technical staffs of all levels and developed test plans for major productionimplementation and release management. Created business flow diagram, sequence diagram using different software tools MS Visio, Excel, Word,PowerPoint. Worked with QA team to develop the test plans, test scenarios, test cases, test data to be used in testing based onbusiness requirements and conducted User Acceptance Testing (UAT). Created various reports, reconciled project data, generated project reports and shared with business and testers,developers, SME in order to provide them with critical information about business status. Strong experience with SQL Server and T-SQL in implementing and developing Stored Procedures, Joins, Views,Indexes, Trigger, Normalization and User Defined Functions. Used Performance Monitor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries. Worked on defect tracking management systems Quality Centre, Bugzilla and JIRA. Worked on Agile methodology /environment to produce various User Stories to facilitate offshore projectdevelopment.Environment: MSOffice (Word, PowerPoint, Excel, Visio, Outlook), Jira, SQL Server 2008/2008R2, Reporting Services(SSRS), Integration Services (SSIS), DTS, T-SQL, MDX, Windows 2000/2003, XML, SAS, Linux, SDLC (Agile), UML,Quality Control. Show less