Sanjay Vedula

About the Candidate

PROFESSIONAL SUMMARY

• 9+ years of IT experience in Business Analysis, Certified Scrum Master, Data Analysis, Design, Modeling, Development, Implementation and Testing of Data warehouse applications.
• Have Public trust Clearance.
• Extensive experience as Business/Data Analyst on data warehousing projects and expert in Data Cleansing/Data Conversion/Data Mapping/Data Migration concepts.
• Involved in Full Life Cycle Development (Waterfall & Agile) of building a Data Warehouse for Financial, Mortgage, Mutual Funds, Banking Clients
• Experience working in Capital Markets, CMBS and Bond Administration projects
• Solid Understanding of MBS, CMBS, Debt, Derivate and Fixed Income concepts.
• Extensively used and translated requirements into the Requirement Traceability Matrix.
• End to End Expertise in SDLC Model ( with added experience of waterfall and Agile)
• Designed and Developed Data Marts by using Star Schema and Snowflake Schema Methodology.
• Data warehouse, ETL- Extraction/Transformation/Loading, Data Analysis, Data mining, Data migration, Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and Documentation.
• Solid experience in AGILE SDLC, writing user stories, creating backlogs and working on RALLY
• Experience in designing, developing, testing, and deployment of various custom reports using reporting tools.
• Exceptional data analysis and reporting skills using (Business Objects, SSRS, Crystal Reports and MS Excel).
• Expert in writing Adhoc SQL queries and writing stored procedures using SQL
• Proficient in creating Business Requirements Document (BRD), Use Cases, Requirements Traceability Matrix (RTM), Work Flow Diagrams, and Business Process Flow Diagrams.
• Experienced with business modeling tools such as Blueprint Requirement Center and MS Visio to generate data flow diagrams, process maps, flowcharts and UML diagrams.
• Ability to work in close co-ordination with the Testing team to develop Test Plan and Test Cases.
• Experience in assisting users to conduct User Acceptance Testing (UAT).
• Highly organized with the ability to manage multiple projects and meet deadlines.

TECHNICAL SKILLS

Requirements Management and Modeling Tools: Requisite Pro, Doors, Microsoft Visio. JIRA, HPQC
Change Management and Version Control: Clear Case, Remedy, Clear Quest, CVS
Database: MS SQL server, MS Access, Oracle, Teradata, DB2, Sybase
Project Management: MS Project
Other Tools: MS Office (Word, Power Point, Excel), RUP, Test Manager, HP ALM, TOAD, Rapid, Erwin, Data Flux, Business Objects Reporting, Tableau, MEGA HopeX, SharePoint 2016
Reporting Tools Business Objects, Business Objects Universe Developer, Advanced SAS, SSRS and Cognos Series 7.0