SUMMARY

• Highly committed and hardworking individual with 5+ years of experience in financial services sector in development, maintenance of various database and data warehousing applications along with business analysis experience.
• Significant experience and proficiency in all aspects of Oracle PL/SQL programming including Cursors, Ref - cursors, Oracle procedures/packages, Collections, Partitioned Tables, Triggers, Table Indexing.
• Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function.
• Highly skilled at database performance and tuning, troubleshooting and query optimization.
• Hands on experience on Python programming.
• Strong Hands on experience in Tableau development.
• Experience working on version control tools like GitHub and hosted web applications on Heroku.
• Good knowledge on AWS cloud Platform (Redshift, RDS, S3, EMR, Kinesis)
• Strong knowledge on Microsoft excel, word and PowerPoint.
• Good understanding of financial instruments like Fixed Income, Equity, Derivatives and Alternative Investments.
• Strong experience as a Business Analyst and worked as a point of contact for 40 business partners in USA, UK and India.
• Ready, willing, and has a strong ability to pick up new technologies and pitch in on tasks.
• Served as a subject matter expert for 2 financial applications related to Fixed Income attributions.
• Proficient troubleshooting and problem-solving skills.
• Strong experience working in Agile methodologies and SCRUM execution.
• Worked as a Graduate Assistant and Teaching assistant at Northwest Missouri State University.
• Excellent oral, verbal and visual Communication with good presentation skills and strong ability to perform as part of a team.

TECHNICAL SKILLS

Programming Languages: Python, Pandas, Matplotlib

Databases: MySQL, Oracle, SQL Server, PostgreSQL, PL/SQL

Data Warehousing: Informatica PowerCenter 9.6

Data Visualization: OBIEE, Power BI, Tableau, Excel

Web Development: HTML, CSS, JavaScript, jQuery, Bootstrap

Development Tools: Visual Code, Atom, Notepad++

Version Control: Git, Bitbucket

Financial Skills: Equity, Fixed Income, Derivatives

Cloud Platform: Amazon Web Services (AWS)

PROFESSIONAL EXPERIENCE

Confidential

BUSINESS ANALYST

Responsibilities:

• Worked closely with the business users to gather requirements for all the enhancements for the Fixed Income applications.
• Documented designed, specifications, and flow diagrams to assist in efficient development, support, and problem analysis
• Worked on Tableau data visualization tool to actively monitor the incidents and enhancements our team is working on.
• Strong involvement with Fixed Income analytics team and primary point of contact.
• Hosted weekly status call which includes all the developers and business partners.
• Worked on several optimization techniques in PL/SQL and fine-tuned the process to reduce run time of several process.
• Created multiple process documents and troubleshooting steps to hand over the business recovery tasks to Level 1 teams.
• Extracted data from various heterogeneous sources like Oracle, SQL Server , flat files using Informatica used SQL loader to load data from flat files into Oracle database.
• Served as an SME for Barclays Point, fund performance system and primary point of contact for over 40 clients across the globe.
• Worked on troubleshooting issues, and process documentation to pass on the tasks to L1 teams.
• Gather and translate business requirements, convert into technical specification.
• Automated several monotonous tasks performed by my business partners and optimized the run time.
• Worked on the data warehousing project “Fixed Income Dashboard”. This application is developed using Informatica , MySQL database and Tableau as a reporting tool.

Confidential

SOFTWARE ENGINEER

Responsibilities:

• Worked on a project, Market data Dashboard. This project gives an insight to the higher management on the amount spent by all departments across Confidential .
• Built charts, dashboards and various graphical representations for Senior Leadership.
• Holding historical data, Market Data Dashboard shows graphical representation of data on the fly. Technologies used for the project are Informatica , SQL server , Autosys and OBIEE .
• Developed an Application, Fixed Income Dashboard for the Fixed Income team using Informatica, Tableau and Python.
• Working in Global performance measurement and risk team , developed several reports related to attribution and contribution.
• Developed contribution and attribution reports using Tableau.
• Scheduled batch processes to run daily which extracts data from external data sources like Bloomberg, FactSet and loaded into our internal databases using Informatica.
• Developed Fund performance system which shows the top 10 high performed stocks in each portfolio based on sector, country and type.
• Fund performance system is developed using oracle PL/SQL , bat script and AutoSys for scheduling.
• Worked on the application Fund Performance system using Oracle PL/SQL programming including Cursors, Ref-cursors, Oracle procedures, packages, Collections, Partitioned Tables, Triggers, and Table Indexing .
• Maintained the OBIEE dashboards developed for Fixed Income dashboard and fixed issues in case of any.
• Participated in several Hackathons to automate multiple monotonous tasks performed by the business users and saved 500 hours of human effort per month.
• Got a hackathon champion award at Confidential for automating the manual tasks performed by my business partners.