Raj Bushan
Livermore,CA
Summary
Qualified Business Intelligence Analyst versed in data mapping and user acceptance testing to solve complex problems in high-pressure environments. Activates strong analytical skills to investigate trends in large amounts of data and formulate conclusions based on findings. Excels at cultivating, managing and leveraging client relationships to foster extended engagements and business opportunities. Solutions-oriented Business Analyst possessing unique combination of business analysis, quality assurance testing and applications development experience in top-tier organizations. Solid SQl query writing skills paired with familiarity of visualization tools and techniques. Successful provider of financial services with 11 years of comprehensive experience. Organized and motivated employee eager to apply time management and organizational skills in various environments. Seeking entry-level opportunities to expand skills while facilitating company growth.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Business Analyst/Data Analyst
BOTW
California City, CA
02.2020 - Current
- Developed and modified programs to meet customer requirements
- Served as team leader for cross-functional teams, making decisions on team-wide goals, timelines and personnel assignments
- Designed, documented and developed extract, transform, load (ETL) processes to ensure accessibility of data from business systems for reports or use by other systems
- Optimized data sources and processing rules to enhance data quality through design and development phases
- Developed Software Code Using AWS (Amazon Webservices) to move files from EC2 to S3 bucket
- Worked on Data modeling, Advanced SQL with Columnar Databases using AWS
- Worked on Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD)
- Involved in Requirements Gathering and properly documenting it
- Developed and expanded user stories for Agile Development and participated in Agile Scrum, Collaborated with Product Owners for Release Planning
- Worked with product manager and other business stakeholders to understand the business rules and logic we are working on
- Worked closely with Product Management group to provide data solutions to issues impacting users
- Using Python and Snowflake's Snow SQL, create end-to-end ETL pipelines that guarantee flawless data transfer across various data warehouse stages
- Conveniently debug, resolve, and fine-tune queries while speeding up access to the Snowflake data warehouse
- Resolved user queries on the data present in Data Warehouse and AWS Cloud and help the users in providing the definitions and data usage
- Experienced in advanced data transformation techniques like window functions, CTEs, and partitioning in SQL and Python to optimize data processing efficiency and accuracy
- Responsible for Data Cleaning, features scaling, features engineering by using NumPy and Pandas in Python
- Developed ETL scripts in Python to get data from one database table and insert, update the resultant data to another database table
- Working with EC2, Lambda and S3 bucket in AWS using Cloud
- Led data analysis projects on AWS, utilizing services such as Amazon S3 for processing and analyzing large datasets, enabling data-driven decision-making
- Acted as liaison between clients and technical associates, translating complex ideas into easy-to-understand explanations
- Documented data warehouse architecture to guarantee capacity met current and forecasted needs
- Completed quality reviews for designs, codes, test plans and documentation methods
- Performed systems and data analysis using variety of computer languages and procedures
- Coordinated troubleshooting support for warehouse personnel
- Collaborated with multi-functional roles to communicate and align development efforts
- Skilled at working independently and collaboratively in a team environment
- Cultivated interpersonal skills by building positive relationships with others.
Business Data Analyst
Indus Ind Bank
India
08.2016 - 01.2020
- Designed, developed, and maintained various data warehousing systems for business insights from multi-node globally distributed deployment environments
- Analyzed complex data and identified anomalies, trends, and risks to provide useful insights to improve internal controls
- Developed, implemented, and maintained data analytics protocols, standards, and documentation
- Designed and implemented effective database solutions and models to store and retrieve data
- Troubleshot and performance-tuned queries accessing Snowflake data warehouse for optimal query performance
- Involved in SQL Scripting, Transactional Data Analysis and Reporting on MS SQL database
- Carried out queries from customer data base using SQL
- Involved in developing Banking Web Portal Application for Retail Banking
- Ability to understand current business processes and implement efficient business process
- Worked on Star and Snowflake schemas, using scheduling tools like Control M
- And Expertise on SQL, Unix Shell Scripting and Python
- Created optimal technical solutions to user needs with in-depth system analysis
- Analyzed business reports for prompt communication, follow-up, and ongoing support
- Analyzed existing SQL queries to identify opportunities for improvements
- Involved in writing python scripts to extract data from different API’s
- Utilized Snowflake SQL, Python Jupyter notebooks, NumPy, pandas, SQL alchemy, and sci-kit packages for effective data extraction, transformation, and loading
- Built data integration solutions to introduce new sets into asset repositories
- Designed and developed analytical data structures
- Used GDP on validation protocols, test cases and changed control documents
- Explained data results and discussed how best to use data to support project objectives
- Built databases and table structures for web applications
- Modelled predictions with feature selection algorithms and leveraged mathematical techniques to develop engineering and scientific solutions.
Business Analyst
Micron
India
08.2014 - 07.2016
- Effective member of a small high-energy team gathering and reporting network related statistics on arguably the biggest private network
- Collaborated and devised an algorithm for monitoring customer bandwidth utilization patterns and proactively
- Expertise in defining scope of projects based on gathered Business Requirements including documentation of constraints, assumptions, business impacts & project risks
- Identified research, realize, investigate, analyse, define and document business processes and Use Case scenarios
- Analysis and review of Software and Business Requirement Documents (BRD)
- Involved in designing the Test Plans and Test Scripts based on the User Requirement Specification and conducted UAT - Integration Testing, Unit Testing
- Developed a dynamic reporting tool to analyze communication circuit's database using PHP and MySQL
- Tested data prediction algorithms based on historical data
- Analyzed transactions to build logical business intelligence model for real-time reporting needs
- Integrated new products and entities into business structure
- Integrated BI assets into customer relationship management tasks, improving service personnel's available intelligence
- Designed customized data collection models for specific visualization tasks
- Analyzed complex data and identified anomalies, trends and risks to provide useful insights to improve internal controls.
Associate Data Analyst
Polaris
India
08.2012 - 07.2014
- Monitored incoming data analytics requests and distributed results to support strategies
- Contributed to internal activities for overall process improvements, efficiencies and innovation
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity, and verifying pipeline stability
- Built databases and table structures for web applications
- Employed data cleansing methods, significantly Enhanced data quality
- Generated detailed studies on potential third-party data handling solutions, verifying compliance with internal needs and stakeholder requirements
- Communicated new or updated data requirements to global team.
Education
Bachelor of Technology - Information Technology
JNTU - India
06.2012
Skills
- MS-SQL
- Snowflake
- Cloud (AWS, Azure)
- Python ,Pyspark
- NET
- JIRA
- Waterfall,Agile
- Data Architecture and Modeling
- Database Management
- Automation and Orchestration
- Data Governance
- Testing – ETL, Selenium, API, Manual
- Power BI,TableAU
- Data Mining
- Product Management
Certification
- Microsoft MCSA, 01/01/17
- CBAP, 02/01/18
Languages
English
Full Professional
Key Responsibilities
- Digital Channel Management
- User Experience Enhancement
- Product Development
- Customer Engagement
- Security and Compliance
- Training and Support
- Data Architecture and Modeling
- Data Integration and ETL Processes
- Database Management
- Automation and Orchestration
Accomplishments
- Successfully led the implementation of a new mobile banking app, resulting in a 45% increase in mobile transactions within the first month.
- Played a key role in achieving a Data analytics improvement in customer satisfaction scores related to digital banking services.
- Recognized as the "Digital Banking Innovator of the Year" in 2021 for outstanding contributions to digital banking advancements.
Affiliations
- Data Innovation Recognition
- Database Optimization Champion
- ETL Process Enhancement Award
- Data Security Excellence
- Continuous Learning Achievement
References
References available upon request.
Timeline
Business Analyst/Data Analyst
BOTW
02.2020 - Current
Business Data Analyst
Indus Ind Bank
08.2016 - 01.2020
Business Analyst
Micron
08.2014 - 07.2016
Associate Data Analyst
Polaris
08.2012 - 07.2014
Bachelor of Technology - Information Technology
JNTU - India
Similar Profiles
Usha RaniUsha Rani
Sr. Database Administrator at BOTW-BMOSr. Database Administrator at BOTW-BMO
SHARON HAMPTONSHARON HAMPTON
Account Manager at Astro Green Ventures Group LLCAccount Manager at Astro Green Ventures Group LLC
Kenny LeKenny Le
Cashier/Head Waiter at Saigon CafeCashier/Head Waiter at Saigon Cafe
Mathias LanglotzMathias Langlotz
Fire Sprinkler Foreman- RSI Department at Cosco Fire ProtectionFire Sprinkler Foreman- RSI Department at Cosco Fire Protection
Elsa LuvianElsa Luvian
Donation Attendant at Good WillDonation Attendant at Good Will