Shreya Bedi Email & Phone Number

United States

Community Banking (Data Science)Experienced Technical Business Analyst with over 5 years of expertise in requirements analysis, process improvement, data analytics, and business intelligence. Skilled at translating complex business needs into clear requirements and enabling data-driven decision-making.At Flagstar Bank, I work as part of the IT Data Science team, leading initiatives that leverage advanced analytics, data visualization, and automation to drive strategic initiatives. Key achievements include: • Gathering requirements from multiple business units to develop a new automated incentive compensation system, authoring 10+ use cases, BRDs, FRDs, and user guides. • Creating custom BI dashboards and management reports to improve data-driven decision-making across the organization. • Automating 8+ manual data feed processes, retiring the previous manual system used by the HR team. • Collaborating with external vendors to integrate a variety of datasets into Flagstar's Snowflake data cloud.Proficient in Python, Tableau, PowerBI, SQL, and Agile methodologies, I thrive on bridging the gap between business and technology. I'm passionate about leveraging data to drive meaningful organizational change and impact

Mumbai, Maharashtra

Data Analytics - Privileged Access Management Program:-Initiative to analyze the Privileged accesses of all the employees of the bank aiming at remediating the potential risks at Enterprise Level. The work involved data manipulation, statistical modelling, data visualization using tools like Python, SQL, Tableau, Arcadia Data, Neo4j (Graph database). This program was initiated to address the conflicting permissions that resources retained at the Enterprise level. Using graph technology, one could easily identify permissions which helped in revoking all unnecessary accesses inherited or provided to the resources. A basic assessment of Segregation of Duty could be attained by this program. Using graph technology, the models helped the organization identify a resource having developer access along with production deployment access.ETL/Database Developer:-Worked with the ETL development team on specific projects including working directly with the Senior Managers and the Stakeholders.Understanding Stakeholder requirements and converting them to use cases.Developing a source to target mapping and ETL development.Developing workflow and data flow to support different file structures and business processes using tools like Informatica and Autosys.Developing and supporting database architecture to create and enhance the Enterprise Applications.Perform tasks related to performance tuning of the ETL jobs. o Following Agile methodology for timely delivery of use cases.

Mumbai, Maharashtra

Business Intelligence:-Worked with cross-functional teams to convert their problem statements into use cases, identify and connect to the data source, extract data from the source and develop integrated information delivery solutions.Created and maintained data visualization reports using tools like Tableau, Arcadia Data, Platfora. Converted Stakeholder requirements to use cases. These reports were used by the Stakeholders to analyze key metrics and performance of teams.Following Agile Methodology for timely delivery of the requirements.Hadoop Development and Production Support:-Weekday 14*5 Production Support on Cloudera and MySQL Platforms.100% support to various jobs (For Instance, Qualys Processing).Supporting job failures of different engines currently deployed in Production Server being utilized by the BAU processes within the Bank for daily reporting and analytics.Migration of Legacy scripts from Perl to PHP framework to support a constant end to end data processing. The legacy scripts were the jobs that were running on a daily routine for critical data flow.Connecting to several internal as well as external databases for the data to flow to the Cloudera Platform. Data is used for Business Intelligence, Analytics, Reporting, Development and Support.Following Agile Methodology for timely delivery of the requirements.OPERATIONAL EXCELLENCE: (Self-Identified Risk) - Unmapped Owner Consequence Model: that aimed to reduce the number of unmapped ownership of Bank of America devices. The model aimed to strategize a better device type mapping on all the infrastructure reports and standardize the existing consequence model for all the infrastructure work streams

Pune, Maharashtra

Description: Prime Helpdesk Ticket Management SystemSkills Learned: Project development, Software development life cycle, Database management, Data analysis and designing, Code development using Perl, Javascript and PHP.

Mumbai, Maharashtra

Description: Bank AccountingSkills Learned: Risk Management, Market Research, Database Management, Project Development and Analysis, Customer data analysis, Technical planning and code development.

Pune, Maharashtra

Description: Business Development InitiativesSkills Learned: Market Research, Market trend and data analysis, Database Management, Project Development and Analysis, Risk Management, Customer data analysis (to start customer business in India from different parts of the world).

Master'S Degree, Masters Of Information Systems Management

Bachelor'S Degree, Information Technology, Gpa: 3.95/4

Activities and Societies: IEEE Power and Energy Society, VIT University, Vellore Campus 2014-2017 Activities: Co-ordinator and organizer.

Education record

Activities and Societies: Student exchange program in the year 2010-2011 (German Exchange). Visited Germany for a month in 2011 which.

Cbse