With 9 years of experience as Senior Consultant in Infosys for Data and Analytics(DNA) Unit having experience in Development, Client Analysis, Database Design, Testing, Maintenance, Reporting and Presentation using databases like Snowflake, Netezza, Oracle, AWS, Shell Scripting, ETL and Various BI tools with Big Data Technologies.
Extensively worked on Data warehousing projects like Toyota Financial Services, WellsFargo, REI, Maximus, Target, both onsite and offshore. Has excellent Database skills along with BI reporting and Leadership skills. Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills, a good team player to ensure timely delivery of project.
Databases: Snowflake, Netezza, Oracle, MS SQL Server, Azure, MS Access
Technologies : AWS, DW/BI, SQL, PLSQL, Shell Scripting, Python
ETL Tools: SSIS, Azure Synapse
Reporting Tools: Tableau, BO, SSRS, OBIEE, Looker, Microstrategy, Power BI
Data Modeling: DataVault, Physical & logical data modeling, Kimball & Agile Scrum Methodologies
Sales/Marketing – MFS, TFS,BPSFS
Service Operations – MFS/TFS
Modernization (TFS) – Obiee to Looker/Tableau
Adhoc Reporting - Legacy & Compliance
Key Projects outside TFS:
Wells Fargo: Worked on Financial statements, Customer profile reports, Compliance reports, Risk Management Reports for Banking requirements by fine tuning specifications by ensuring that all database constraints are satisfied and perform impact analysis of changes. Developed reports in Tableau and Power BI for SharePoint list items. Created SQL stored Procedures, adhoc SQL queries to retrieve the data as per user requirements.,
REI Systems: Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model. Designed, developed, tested, and maintained Tableau functional reports based on user requirements. Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS. Deployed, Tested and Scheduled SSIS packages.
Maximus: Developed dashboards using Microstrategy/Tableau for CHIP, MEDICAID, Call center IVR data. Improved the performance of SSRS reports by tuning the Stored Procedures and T-SQL queries and created XML, PDF, EXCEL files using SSRS. Developed various reports like Charts, Tables, Matrix, Sub reports and reports using single value parameters, multi-value parameters with Queried and Non-Queried parameters. Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T- SQL code and SQL Joins for applications.
Target: Involved in analysis, design and development of large databases to solve complex business problems by Design of the Database and the Tables and built table relationships. Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T- SQL code and SQL Joins for applications. Developed reports for marketing, financial, sales reports.