Priyanka Pathak Email & Phone Number

Seattle, Wa, Us

Seattle, Wa, Us

Seattle, Washington, Us

• Developer on an Agile team planning and implementing database solutions to ship critical features for clients in fast paced sprint cycle • Determining database structural requirements by working with internal business stakeholders, application developers, and identifying optimal database specifications to determine business need and apply industry standards to all database solutions created • Design and implement complex stored procedures and views to facilitate requirements such as PowerBI reporting needs and support backend task • Catered to the data needs of internal customers with data retrieval and manipulation as per client’s adhoc requests • Demonstrated strong SQL development using SSMS on Azure Sql databases , ASD Databases ,Reporting and Diagnostics databases and ETL development using SSIS • Work on structured and unstructured streams on COSMOS using SCOPE Scripting to create and customize streams as per client request • Create measures, metrics, relationships between tables, dimensions and facts using DAX to query OLAP cubes and perform processing and recalc operations on it • Automated ~80% of ad hoc reporting across multiple teams, reducing query request and development time from hours to minutes Technologies Used: SSIS,SSMS,DAX, COSMOS,SCOPE,TFS,PowerShell,Microsoft Azure, SQL Server 2008 R2, 2012,2014

Bloomingdale, Illinois, Us

• Developed a publicly accessible, in-house managed, relational database system for data organization & site architecture for the research center based on end user scenarios, technical constraints and business requirements • Designed and developed a compatible front-end to implement search functionality on existing resources in the form of articles, manuscripts, books and external links • Final product replaced existing paper-based workflow and on-premise library center , making the process completely paperless. Technologies Used: JavaScript, HTML & CSS, MySQL, PHP

Developed an effective marketing strategy for the client by identifying key metrics, performing competitive analysis, developing features for the website and recommending steps to reboot their marketing efforts in order to achieve the target sales figure

Chicago, Il, Us

• Designed a functional web platform framework to position the firm as the go-to partner for buyers and sellers in the marketplace to find quality deals • Identified data fields, metrics, workflows, use cases and designed website wire frames from the landing page to the activity pages to ensure appropriate representation for the firm

Bangalore, Karnataka, In

• Designed, developed and automated data Stage jobs to perform ETL (Extract, Transform and Load) on varied files and databases: Teradata and Oracle, of financial data for the investment management firm.• Used SSRS to create reports leading to Wipro’s contract term extension from 2 to 6 years with revenue uptick in the range of $1.1-$1.3 million• Roles and responsibilities mainly included designing, development, requirement gathering and analysis, providing estimations, interaction with the offshore development team and active participant in peer reviews• Spearheaded various team building initiatives for better work environment and to facilitate knowledge sharing among peers

Master'S Degree, Management Information Systems And Services

Bachelor Of Technology (B.Tech.), Computer Science

Senior Secondary Certificate, Physics, Chemistry And Mathematics