Priya Vyas

• Big Data & Multiple Datawarehouse Projects –In order to process and visualize data at a faster rate DOE receives the request from other departments, the Superintendent, Chief of Staff to implement Cloudera/Hadoop in the DOE data warehouse
• We used Hadoop components Hive, HBASE,HDFS and Talend to build new Warehouse with the business knowledge of existing warehouse build using SQL component SSIS and SSRS
• Responsibilities:
• Talend jobs performed for all ETL tasks
• Sqoop ingestion from Oracle The data that receive from application is being loaded into Oracle the Sqoop is used to extract that data into talend
• Directory monitoring and ingestion of vendor files receive for different test
• Validation of all input files (Oracle, Vendor, Web logs)
• Notification of errors or other issues for resolution
• We used Talend to implement data governance processes
• Data curators assigned and they receives automated process reports via email
• Data management statistic reports produced
• Transformation and integration of all data
• Loading from HDFS raw files into Hive
• Loading of summarized data from Hive into into HBase
• Push of data back into SQL Server (at least initial staging)
• To perform Oracle Data Ingestion Design processe created that used master data joins on the database side, Use Sqoop SQL statement rather than full table
• To Perform Vendor Data Ingestion Design , New files are loaded into a new Hive table where the column names and data are examined
• Validation code is written, Number of fields, required headers, Data formats, ranges, lookups, etc
• A new table matching a standardized Vendor file metadata format is then populated with a sub-select and this is inserted into the Vendor Score master table (Hive or Impala – TBD)
• Records are extracted from the Warehouse and appended to HBase table records (later)
• Everything is packaged into a single Talend workflow
• Directory monitors be set up to monitor data arrival (tWaitForFile)
• Exception reporting and load messages are sent to data curators
• Data Storage Design, Data storage will use Hive to store base data tables
• Plays to a weakness in Hive and Impala dealing with slowly changing dimensions
• Uniform structures built for all major entities
• ETL processes mapped to these structures and will cleanse, validate, and notify curators of results
• The process built to accommodate high speed, low latency ingestion
• Hive Design Considerations Partitioning / Bucketing
• Improve Query performance, Organize data
• Speed queries by limiting scans to the correct partitions specified in the WHERE clause
• Data Storage Design, HBase NoSQL tables created that utilized dynamic column appending to store repeating transaction data
• Students record – holds basic student information, events (suspensions, criminal, achievement, etc.), medical or behavioral history, and test scores
• Teacher record – holds basic data, accreditation and licensing, events (suspensions, criminal, achievements, etc.)
• School and Corporation records – holds basic information, attendance, enrollment, event data, etc
• Vendor record – holds basic information, test information
• Supporting existing SSIS and SSRS work
• Environment:
• Hadoop, Hive, Hbase, HDFS, Sqoop, Talend,SQL 2008, SSIS, SSRS, Shell Script, Export, Import, SQL, PL/SQL, ERWIN, My SQL,Windows 2003, SQL Developer

Key Achievements/Tasks:

• Successfully led and managed the team responsible for AWS Data Lake, AWS Athena, Informatica, Data Bricks, Cognos, PowerBI, and the latest data and AI/digital trends. This team has been instrumental in driving data-driven initiatives and delivering impactful data solutions.
• Effectively collaborated with stakeholders and cross-functional teams to ensure the seamless delivery of projects and alignment with business objectives. Your team's management and leadership have played a crucial role in achieving project success.
• Leveraged your technical expertise and management capabilities to challenge existing solutions, drive improvements, and optimize the utilization of cutting-edge data technologies.
• Empowered the AES Data Science team with the right data and solutions, enabling them to make informed and data-driven decisions. This collaboration has enhanced data insights and driven business outcomes.

• Scope: portal for Shop Premium Outlets(https://www, )-
• The retailer will provide products with inventory and price data to the SPO marketplace
• SPO will combine that data with additional merchandising elements to provide the shopping experience to the customer
• The customer will shop and place orders on the SPO website
• SPO will interact with the retailer’s web site to create that order via a headless browser
• The retailer will process the customer’s payment directly, and the order will go through the retailer’s fulfillment and delivery process
• Lead development team in designing/migrating AWS cloud based solutions for Migrating retailer
• Work directly with other product managers, system engineers, program managers, developers, testers, and customers to define features and technical requirements
• Create and execute a strategy to build mindshare and broad use of AWS within a wide range of retailers and customers
• Work with onboarding internal and external clients/retailers
• Support an Agile Software Development process, working in conjunction with end users / stakeholders and technical delivery team
• Create objectives, strategies for the SPO site(retailer business) and apply data to help inform and make business decisions
• Lead/support/coordinate relationships with web design/development teams
• Identify product gaps, process improvements, and solutions
• Help to build and execute upon a product roadmap using Jira tool
• Led the team to on-borad new retailers on to the site
• Monitor and analyze new technologies and make recommendations to management on their potential applications to the business
• Created business cases by leveraging data retailer data
• Work collaboratively & drive the launch of the projects under SPO site
• Make thoughtful decisions on the fly, constantly clearing roadblocks to get the retailer on board
• Work closely with counterparts in Product Management to align on the vision, program backlog, and roadmap
• Acting as stakeholder of specific product backlog items, work closely with development teams to ensure the output to be aligned with expectations
• Designing and executing A/B testing to drive product development using data and metrics
• Developing forecasts, financial objectives and specialized business analysis reports in collaboration with the sales team
• Following emerging technology, consumer, and societal trends for prospective product enhancement or expansion.

• Scope: Managing program level integration and outcomes measurement and advance the Lilly USA’s Customer support capabilities toward the future with all therapeutic platforms
• Based on business needs, Managing or leading special projects as needed to quantify and measuring the outcomes of patient support programs and services
• Attention to detail, customer experience focus, technical knowledge, and strong communication skills are critical in implementing, managing against baseline operating procedures
• Work directly with other product owners, system engineers, program managers, developers, testers, and customers to define features and technical user stories
• Support an Agile Software Development process, working in conjunction with end users / stakeholders and technical delivery team
• Work closely with counterparts in Product Management to align on the vision, program backlog, and roadmap
• Acting as stakeholder of specific product backlog items, work closely with development teams to ensure the output to be aligned with expectations
• Being the voice of the customer and providing a business perspective on value during day-to-day development
• Work with a diverse set of contractor and government personnel to track, manage, and resolve technical issues
• Assist in customer workshops and strategies
• Created and managed product backlog, and continue refined it
• Experience in Project management, project coordination, change and problem management, quality assurance and compliance project
• Provide week-to-week tactical objectives to scrum team, and provide quick JIT decisions to system level questions and defect triage
• Proven ability to effectively translate business requirement into technical specification
• Possibly work with 3rd party system integrators to drive process on schedule and on budget
• Defining the road map and prioritizing the backlog of work to meet the vision in a timely manner to meet market and customer demands
• Created test metrics and detailed test cases
• Drive and own backlog grooming and management, prioritize the iteration and drive acceptance testing and delivery of iteration
• Relating & Networking
• Continuously seek opportunities to improve Lilly’s people, processes and systems
• Identify, test, measure, codify and share key learnings
• Track budget and delivery of engineering projects and releases
• Working on Data Analytics using Tableau platform
• Client:

• Scope: DOE receives the Grant request Form from public school corporation and charter schools in the state of Indiana
• DOE requires an analysis of that request and process that request if it is appropriate to do that, once the process is completes the account payable Voucher file can be created so that distribution can be fulfilled
• The New process will create a web form for the School as well as for the DOE.So, the school can access the web form to enter their request and check once they get the Dollaramount
• DOE can use the web application to process and verify the request and make changes in their accounts
• Responsibilities:
• Determine if additional software is needed to fulfill project’s technical requirements
• Develop Technical Specifications
• Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports
• Responsible for installation and Configuration of SQL Server 2008 database and configuration of Report manager
• Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports which take longer time in execution with SQL Server 2008
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load for the Vendor File as well as data that’s reported by school
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems
• Developed, deployed, and monitored SSIS Packages
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008
• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports
• Created reports with Analysis Services Cube as the data source using SSRS
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS)
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users
• Prepared the complete data mapping and Report Definitions for the project which involved around 40 reports
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data
• Worked on formatting SSRS reports using the Global variables and expressions
• Created parameterized reports, Drill down and Drill through reports using SSRS
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008
• Prepared the complete data mapping for all the migrated jobs using SSIS
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and
• Environment:
• SQL 2008, SSIS, SSRS, Shell Script, Export, Import, SQL, PL/SQL, ERWIN, My SQL,Windows 2003, SQL Developer 1.1), MS Visio.

• Scope:MDwise requires a rapid remediation of its enrollment process
• In addition it also requires analysis and redesign of its technology and data management tools, techniques and processes to support remediation of processes throughout the business
• It is intended that these redesign efforts will establish the basis for Continuous Improvement as a regular management discipline
• The development involves the normal cycle from business analysis, designing, coding, testing and implementation till the end user support
• Responsibilities:
• Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs
• Performed Database code Migration from SQL Server 2000 to 2005 in SDLC environment using Bridging Scripts, Column Mapping Tool and Source Control Explorer in Visual Source Safe (VSS) and finally passing all triggers, views under Unit Testing for validating data insert, update and delete
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries
• Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts for the Enrollment data receive from State
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS
• Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services
• Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams
• Environment:
• SQL 2008, SSIS, SSRS, Shell Script, Export, Import, SQL, PL/SQL, ERWIN, My SQL,Windows 2003, SQL Developer 1.1), MS Visio.

• Scope: BMS, which stands for Business Management System
• Cummins Distribution business, previously known as DPS, purchased this application from Avalon Systems
• This project is all related with customizing and supporting the Avalon developed application further
• The project has two aspects, changes and enhancement to the existing system and production support
• The development is done in set of releases, which are planned to occur every 6 months
• The development involves the normal cycle from business analysis, designing, coding, testing and implementation till the end user support
• We develop and support for US, Canada, Mexico and Singapore
• Responsibilities:
• Designing the Application & Developing SQL PL/SQL code using Oracle
• Release of backend scripts/program units, which have been developed/ enhanced
• Performing Periodic Cleanup activities, such as dropping objects, which are no longer used and estimating space requirements
• Analysis of different source systems according to business needs
• Transformation of Data from main ERP systems and other sources to Stage and from Stage to Target using ODI/OWB
• Data Mapping of Common data model, Integration and standardization, end to end data mapping
• Putting business Rules in extraction while using ODI interface
• Scheduling the auto run of packages and other scheduled jobs through the scheduler tool called “Appworx”
• Subject area analysis for data mart, Analysis of fact, dimension table with granularity according to business need
• Creation of business report using SSRS
• Incorporating user/role based security in RPD based on LDAP connection
• Preparation of dashboard based on KPI and KPA for top management as well as auto individual Dashboard as per user Role
• Scheduling the auto response of different reports through IBOT setup
• Configuring BI publisher especially for the application using Apex for showing some invoicing reports to general customers
• UTC preparation for specific modules
• Creation of defect log and getting it reviewed, then solving them up
• Coordination for System Integration testing
• Coordination and preparation of install packets for Production move
• Solving day to day production tickets(Prod Issues)
• Environment:
• Oracle (8i, 9i, 10g, 11g) Shell Script, Export, Import, SQL, TOAD, PL/SQL, Forms, Report, APEX 3.0, Windows 2003, SQL Developer 1.1), MS Visio, (Solaris 5.8, 5.9).