Unique S Email & Phone Number

New York, Ny, Us

New York, Ny, Us

London, Gb

• Involved in the complete Software Development Life Cycle (SDLC) including Analysis, Design, Implementation, Testing, and Maintenance using Agile methodology.• Clean data and processed third party spending data into maneuverable deliverables within a specific format with Excel macros and Python libraries such as NumPy SciPy and Matplotlib.• Worked in using collections in Python for manipulating and looping through different user-defined objects.• Imported the claims data into Python using Pandas libraries and performed various data analyses.• Created Pie chart, horizontal bar plots, context filters, and labels on the data and aggregated to suit the target requirements using Tableau.• Responsible for different Data mapping activities from Source systems to Teradata.• Preparing dashboards using calculated fields, parameters, calculations, groups, sets, and hierarchies in Tableau.• Developed the required data warehouse model using Star schema for the generalized model.• Designed and deployed reports with Drill Down, Drill Through, and Dropdown menu option and Parameterized and Linked reports using Tableau.• Performed data analysis and data profiling using complex SQL queries, Facets as the source, and SQL Server as the database.• Designed Developed, Coded, Tested, and maintained objects such as Packages, Procedures, Functions, Triggers, Views, Sequences, PL/SQL Collections, etc.• Responsible for resolved data investigation issues and provide granular level information related to it and updated in Jira.Environment: SDLC, Agile, Python, NumPy, SciPy, Matplotlib, Tableau, Teradata, SQL Server, PL/SQL, OLAP, Jira.

• Developed business process models in Waterfall to document existing and future business processes.• Programmed a utility in Python that used multiple packages like SciPy, NumPy, and Pandas.• Worked on data that was a combination of unstructured and structured data from multiple sources and automated the cleaning using Python scripts.• Developed Python programs for manipulating the data reading from various Teradata and convert them as one CSV Files, update the Content in the database tables.• Designed, developed, and implemented Power BI Dashboards, Scorecards & KPI Reports.• Created notifications and alerts, subscriptions to reports in the Power BI service.• Used Aggregations, Set Operators like Union, Minus, and Intersect, CASE Expressions, and String expressions to retrieve data in a required form from multiple tables.• Wrote, executed, performance-tuned SQL Queries for Data Analysis & Profiling and wrote complex SQL queries using joins, subqueries, and correlated subqueries.• Worked on exporting reports in multiple formats including MS Word, Excel, CSV, and PDF.• Worked in importing and cleansing of data from various sources like MySQL, and SQL Server with high volume data.• Created Set, Multiset, Derived, Volatile, Global Temporary tables to retrieve the data from multiple tables.• Responsible for the creation of databases with Primary, Foreign keys, and Unique constraints for new clients.• Generated graphs using MS Excel Pivot tables and creating presentations using PowerPoint.Environment: Waterfall, Python, SciPy, NumPy, Pandas, Power BI, KPI, MySQL, SQL Server, MS Excel, Pivot tables.

Master'S Degree, Management Information Systems

Master Of Business Administration - Mba, Banking, Corporate, Finance, And Securities Law

Master Of Business Administration - Mba, Business, Management, Marketing, And Related Support Services

Master Of Business Administration - Mba, Business, Management, Marketing, And Related Support Services