Sonali Limaye Joshi Email & Phone Number

Greater Chicago Area

Greater Chicago Area

-Integration of Student Loan Origination system into a Datamart. Leading the BA team’s efforts in migrating pre-existing operational data stores, enhance database procedures, extract tables, and lookups in the production Teradata environment with the objective to meet near term and future business needs.-Gathered and documented data requirements, phasing plans.-Created Business Process Specifications, HLD and Implementation Plans, in line with the clients standards.-Identified and ensured data from the Origination system is being sent to and catalogued in Clients Enterprise Data System (EDS.)-Performed data profiling to identify foreign key relationships, unique keys, data value ranges, nulls etc.-Worked with Data Modelers to identify and resolve duplication/redundancy in the Datamart.-Documented business definitions, availability, completeness, and accuracy of metadata.-Created Source to Target mappings for the Student Loan Originations Datamarts.-Developed functional test case scenarios and facilitated UAT sessions.-Collaborated with onsite, off-shore development teams to ensure project milestones were met as per project plan.In short, perform full SDLC from requirements gathering, solution design, test case generation, user acceptance testing, and documentation and training.

Pune Area, India

-End-to-end project development using Lotus Notes that included requirement gathering, project planning, design and conceptualization of the solution, approach for problem solving, presentation of final results and pre/post install testing.-Influence decision making for the clients by showcasing value-add in the projects by generating insights and sharing recommendations.-Provide scalable and agile business solutions to clients for problems ranging from forecasting, network optimization and buyer analysis.

Bachelor’S Degree, Electronics And Communications Engineering

Activities and Societies: Had been a student representative for couple of years. Have participated in debates and organized cultural.

Post Graduate Diploma, Wireless And Mobile Computing

Developed a mobile based online railway booking app which is compatible with Android OS.