Lakshya Bhat Email & Phone Number

New York, New York, Us

· Design, develop and support Data Pipelines that consume and provide accurate business data to other business groups within the Firm· Collaborate with Senior Stakeholders to understand new and changing business requirements, document them, and deliver software to drive business change· Curate data sets, models and processes, while identifying areas for further automation and efficiencies using modern methodologies· Drive adoption of Cloud technology for data processing and warehousing at the Firm· Provide data-driven insight and decision-making critical to the Firm’s business processes· Mentor and train junior staff in core technical skills; support swiftly-growing team in Data Engineering discipline

New York, New York, Us

=> ETL Pipeline Development, Data visualization, analytics, and metrics development at Goldman Sachs.Languages/ Tools - Python [ OOP, Flask (API) , Scripting, Pandas, NumPy ] , R, SQL, Tableau , Git & Gitlab (CI-CD), TerraformDatabases - Snowflake, Amazon Redshift, Sybase IQ, IBM DB2• Automated internal and external reporting process using ETL and Python Scripts that saved the company 110 weekly hours• Defined and managed SLA for all data sets in allocated areas of ownership• Designed, build and launched new data extraction, transformation and loading processes in production• Build data expertise, own data quality and data lineage for allocated areas of ownership• Worked across cross functional agile and global teams to continuously experiment, iterate and deliver on new product objectives• Worked with data infrastructure teams to triage infrastructure issues and drive to resolution• Identify and communicate data driven insights to increase process effectiveness• Creation of a composite metric framework score to tabulate the operational risk exposure of the firm and set threshold and limits for escalation to management at committee and board levels

New York, New York, Us

• Investigated four local and global divisional teams to collect requirements for evaluating 20 business processes and internal controls• Identified 18 key metrics, mapped the risk metrics to five internal and external data sources and negotiated with data owners• Retrieved data from firm’s Data Lake and various databases, processed, cleaned and verified the integrity of data using R and SQL• Created Real-time Business Resiliency Tableau dashboards for senior leaders globally to brief operational risks across the firm

Mumbai, Maharashtra, In

• Shared knowledge with a team of four peers while administrating 17 Oracle Databases on Linux and Windows servers• Gathered, documented and met service level agreement and client requirements thereby increasing client satisfaction by 100%• Collaborated with four remote teams and client for fast, innovative and accurate resolution of 150 system bugs and issues • Managed users to meet regulatory compliance and internal control process service thereby increasing security measures• Reorganized databases and sized database objects to meet standards and improve system performance by 30%• Automated DBA tasks utilizing SQL and Shell scripting thus decreasing report generation time by 85%• Performed database backup on daily basis using physical and logical backup for disaster recovery, testing and data migration

Mumbai, Maharashtra, In

• Tested 17 electric drives with a team of 10 to ensure reliability of the drives met Six Sigma standards • Assisted five system designers for designing the electric drive, validated using PSCAD and documented for vendor procurement

Cork, Ireland, Ie

• Designed, tested and implemented an early-alert system to ensure safety in cars from a major automobile manufacturer of Japan• Implemented the design in Microcontroller using LabView and embedded C.• Documented the results for process flow.

Master Of Science (Ms), Management Information Systems

Bachelor Of Technology (Btech), Electrical And Electronics Engineering

Education record