Software Developer
Chitrangada Chouhan
Phoenix, AZ � ------------ � ------------
Work Authorization: Optional Practical Training(OPT)
No Sponsorship required in future
SUMMARY
� Analytical expertise to interpret, envisage and provide solutions to client specifications via Software Development Lifecycle (SDLC) including design, development, testing, implementation, maintenance and support
� Skilled in identifying long term goals and making strategic efforts to realize those goals
� Dependable team player with excellent communication and interpersonal skills
EXPERIENCE
Satin Solutions LLC March 2019 �Present
Big Data Intern
� Developed data pipeline using Sqoop and Pig to ingest data into HDFS for analysis.
� Importing and exporting data into HDFS and AWS S3 using Sqoop
� Exporting the analyzed and processed data to the RDBMS using Sqoop for visualization and for generation of reports for the BI team.
� Analyzing large amounts of data sets to determine optimal way to aggregate and report on these data sets.
� Used Hive to analyze the partitioned and bucketed data and compute various metrics for reporting on the dashboard.
� Functional and non-functional requirements gathering.
IBM India, Bangalore, India August 2013 � September 2013
Associate System Engineer
� Collaborated with the entire software development team to brainstorm and custom-develop clinical automation software which aimed to provide efficient solutions for medical clients
� Used C#.NET to develop the software that aligned well to meet the requirements
� Worked on MS-SQL as the database for the backend of the software.
� Used SSIS(Sql Server Integration Services) for data integration and work flow application
� Used SSRS(Sql Server Reporting Services) for report generation
� Designed the software with an intent to minimize the cost of manual transactions up to 40% based on the size of business
� Performed unit testing using NUnit and coordinated with users to efficiently accommodate change requests for enhancing product performance
Asian Plywood Industries, Hajipur, India July 2010 � July 2013
Software Developer
� Collaborated with the business and technical team to understand the requirement
� Designed and developed a website and software for online ordering using Advanced PHP and MSSQL - from initial conception through implementation(which increased the clientele by 20% within the first year)
� Transitioned the company successfully from file system to relational database management system using MSSQL, enhancing the efficiency of multiple departments and shrinking the annual cost by 30%
� Used SSIS(Sql Server Integration Services) for data integration and work flow application
� Used SSRS(Sql Server Reporting Services) for report generation
� Performed unit testing using PHPUnit and resolved issues quickly and efficiently that arose during the reporting lifecycle
� Provided support in the implementation and knowledge transfer for efficient usage of the applications
TECHNOLOGY SUMMARY
MSSQL, SSIS(Sql Server Integration Services), SSRS(Sql Server Reporting Services), SSAS(Sql Server Analysis Services), Python, Base SAS Programming, Advanced SAS Programming, Tableau, R Programming, ETL, Data Warehousing, PHP, Core Java, Scala, Spark(SparkStreaming, SparkSQL), Hadoop, HDFS and MapReduce Architecture, HBase, Hive, Pig, Sqoop, Amazon Web Services, C#.NET, JavaScript, TFS, SubVersion, BitBucket, SDLC, Business Analysis Tools, Scrum Framework, Agile Methodologies, Sharepoint, MS Visio, MS Office, JIRA, Asana, HTML, Windows, Linux, MacOS
EDUCATION
University of Cincinnati, Lindner College of Business, Cincinnati, OH August 2018
Master of Business Administration
� Relevant Coursework: Leadership and Organizations, Managing Across Cultures, Economics, Accounting for Managers, IT Management, Operations Management, Marketing for Managers, Financial Management
� Executive Secretary, National Association of Women MBAs - UC Chapter
Graduate Certificate in Data Analytics April 2018
� Relevant Coursework: Data Analysis Methods with R, Data Warehousing & Business Intelligence, Data Mining
for Business Intelligence, Statistical Computing, Data Visualization with Jeffrey Shaffer- Tableau Zen Master, Data Management with SQL, Big Data(Hadoop, HBase, Pig, Hive, Scala, Spark, Cassandra,Sqoop)
Banasthali University, India March 2014 Master of Computer Applications
Banasthali University, India January 2011
Bachelor of Computer Applications
ACADEMIC PROJECTS
Streaming Analytics Spring 2018
� Developed a project for realtime analytics of data streams inorder to detect fraud which could report irregularities and elicit suitable actions
� Employed high speed data processing with Apache Spark over a data store using HBase
Data Mining for Business Intelligence Spring 2018
� Used SPSS Modeler to fit different Machine learning algorithms and test it against the labelled data, finally choosing the best model in order to support the oenologist wine tasting evaluations and improve wine production
Data Visualization Fall 2017
� Developed a Visualization of Baltimore parking citation data with about 3 million rows and 21 columns using Tableau. The visualization was aimed at highlighting the regions with highest parking citations, determining the reason for the same and ultimately determining solutions to minimize these citations. (Data Source: Open Baltimore)
Data Analysis Methods Fall 2017
� Performed Data Analysis and developed a predictive model for College and Universities dataset to show the factors that most significantly affect the admissions and graduation (Data Source: Business Analytics Book by James R Evans) using R
Website Development Spring 2012
� Used PHP and MySQL to develop a website(similar to grub hub) for browsing and ordering food from multiple local restaurants
� Used PHP and MySQL to develop an intra-mail service which facilitated mailing and connecting with friends in a small closed network
Case Competitions
Monsanto Olin International Supply Chain Competition Sept 2017- Feb 2018
� Designed a framework to determine the product portfolio for upcoming crop cycles of seed corn
� Predicted the optimal quantity and price of corn seed hybrid using Supply Chain Strategy and Analytics
Centric Consulting Case Competition Feb 2018
� Proposed a robust solution for fraud monitoring and prevention in the e-commerce transactions
� Strategized to mitigate losses from the surge of �Card Not Present� transactions
EXTRA CURRICULARS
� Workshop of Cloud Computing organized by IBM
� Certificate of participation in workshop of Ethical Hacking by Kyrion Digital Securities
� Certificate of participation in workshop of Android by Geeks Lab
� Certificate for six weeks Training in Core PHP from DUCAT
� Certificate for six weeks Training in Advanced PHP from DUCAT
� Certificate for Advanced Diploma in Networking (CCNA) through CISCO till fourth semester
VOLUNTEERING EXPERIENCE
Dayton Library July 2016 � March 2017
� Volunteered at Dayton Library as homework helper, conversation partner and chess club coordinator
National Service Scheme July 2008 � December 2012
� Informed citizens about cleanliness and afforestation
� Educated over 200 children, eradicating them from child labor and into the mainstream educational system
� Lead a team to motivate women about entrepreneurship and laid out a business setup plan to help them start home-based business creating a surplus income opportunity for their household
Chitrangada Chouhan
Phoenix, AZ � ------------ � ------------
Work Authorization: Optional Practical Training(OPT)
No Sponsorship required in future
SUMMARY
� Analytical expertise to interpret, envisage and provide solutions to client specifications via Software Development Lifecycle (SDLC) including design, development, testing, implementation, maintenance and support
� Skilled in identifying long term goals and making strategic efforts to realize those goals
� Dependable team player with excellent communication and interpersonal skills
EXPERIENCE
Satin Solutions LLC March 2019 �Present
Big Data Intern
� Developed data pipeline using Sqoop and Pig to ingest data into HDFS for analysis.
� Importing and exporting data into HDFS and AWS S3 using Sqoop
� Exporting the analyzed and processed data to the RDBMS using Sqoop for visualization and for generation of reports for the BI team.
� Analyzing large amounts of data sets to determine optimal way to aggregate and report on these data sets.
� Used Hive to analyze the partitioned and bucketed data and compute various metrics for reporting on the dashboard.
� Functional and non-functional requirements gathering.
IBM India, Bangalore, India August 2013 � September 2013
Associate System Engineer
� Collaborated with the entire software development team to brainstorm and custom-develop clinical automation software which aimed to provide efficient solutions for medical clients
� Used C#.NET to develop the software that aligned well to meet the requirements
� Worked on MS-SQL as the database for the backend of the software.
� Used SSIS(Sql Server Integration Services) for data integration and work flow application
� Used SSRS(Sql Server Reporting Services) for report generation
� Designed the software with an intent to minimize the cost of manual transactions up to 40% based on the size of business
� Performed unit testing using NUnit and coordinated with users to efficiently accommodate change requests for enhancing product performance
Asian Plywood Industries, Hajipur, India July 2010 � July 2013
Software Developer
� Collaborated with the business and technical team to understand the requirement
� Designed and developed a website and software for online ordering using Advanced PHP and MSSQL - from initial conception through implementation(which increased the clientele by 20% within the first year)
� Transitioned the company successfully from file system to relational database management system using MSSQL, enhancing the efficiency of multiple departments and shrinking the annual cost by 30%
� Used SSIS(Sql Server Integration Services) for data integration and work flow application
� Used SSRS(Sql Server Reporting Services) for report generation
� Performed unit testing using PHPUnit and resolved issues quickly and efficiently that arose during the reporting lifecycle
� Provided support in the implementation and knowledge transfer for efficient usage of the applications
TECHNOLOGY SUMMARY
MSSQL, SSIS(Sql Server Integration Services), SSRS(Sql Server Reporting Services), SSAS(Sql Server Analysis Services), Python, Base SAS Programming, Advanced SAS Programming, Tableau, R Programming, ETL, Data Warehousing, PHP, Core Java, Scala, Spark(SparkStreaming, SparkSQL), Hadoop, HDFS and MapReduce Architecture, HBase, Hive, Pig, Sqoop, Amazon Web Services, C#.NET, JavaScript, TFS, SubVersion, BitBucket, SDLC, Business Analysis Tools, Scrum Framework, Agile Methodologies, Sharepoint, MS Visio, MS Office, JIRA, Asana, HTML, Windows, Linux, MacOS
EDUCATION
University of Cincinnati, Lindner College of Business, Cincinnati, OH August 2018
Master of Business Administration
� Relevant Coursework: Leadership and Organizations, Managing Across Cultures, Economics, Accounting for Managers, IT Management, Operations Management, Marketing for Managers, Financial Management
� Executive Secretary, National Association of Women MBAs - UC Chapter
Graduate Certificate in Data Analytics April 2018
� Relevant Coursework: Data Analysis Methods with R, Data Warehousing & Business Intelligence, Data Mining
for Business Intelligence, Statistical Computing, Data Visualization with Jeffrey Shaffer- Tableau Zen Master, Data Management with SQL, Big Data(Hadoop, HBase, Pig, Hive, Scala, Spark, Cassandra,Sqoop)
Banasthali University, India March 2014 Master of Computer Applications
Banasthali University, India January 2011
Bachelor of Computer Applications
ACADEMIC PROJECTS
Streaming Analytics Spring 2018
� Developed a project for realtime analytics of data streams inorder to detect fraud which could report irregularities and elicit suitable actions
� Employed high speed data processing with Apache Spark over a data store using HBase
Data Mining for Business Intelligence Spring 2018
� Used SPSS Modeler to fit different Machine learning algorithms and test it against the labelled data, finally choosing the best model in order to support the oenologist wine tasting evaluations and improve wine production
Data Visualization Fall 2017
� Developed a Visualization of Baltimore parking citation data with about 3 million rows and 21 columns using Tableau. The visualization was aimed at highlighting the regions with highest parking citations, determining the reason for the same and ultimately determining solutions to minimize these citations. (Data Source: Open Baltimore)
Data Analysis Methods Fall 2017
� Performed Data Analysis and developed a predictive model for College and Universities dataset to show the factors that most significantly affect the admissions and graduation (Data Source: Business Analytics Book by James R Evans) using R
Website Development Spring 2012
� Used PHP and MySQL to develop a website(similar to grub hub) for browsing and ordering food from multiple local restaurants
� Used PHP and MySQL to develop an intra-mail service which facilitated mailing and connecting with friends in a small closed network
Case Competitions
Monsanto Olin International Supply Chain Competition Sept 2017- Feb 2018
� Designed a framework to determine the product portfolio for upcoming crop cycles of seed corn
� Predicted the optimal quantity and price of corn seed hybrid using Supply Chain Strategy and Analytics
Centric Consulting Case Competition Feb 2018
� Proposed a robust solution for fraud monitoring and prevention in the e-commerce transactions
� Strategized to mitigate losses from the surge of �Card Not Present� transactions
EXTRA CURRICULARS
� Workshop of Cloud Computing organized by IBM
� Certificate of participation in workshop of Ethical Hacking by Kyrion Digital Securities
� Certificate of participation in workshop of Android by Geeks Lab
� Certificate for six weeks Training in Core PHP from DUCAT
� Certificate for six weeks Training in Advanced PHP from DUCAT
� Certificate for Advanced Diploma in Networking (CCNA) through CISCO till fourth semester
VOLUNTEERING EXPERIENCE
Dayton Library July 2016 � March 2017
� Volunteered at Dayton Library as homework helper, conversation partner and chess club coordinator
National Service Scheme July 2008 � December 2012
� Informed citizens about cleanliness and afforestation
� Educated over 200 children, eradicating them from child labor and into the mainstream educational system
� Lead a team to motivate women about entrepreneurship and laid out a business setup plan to help them start home-based business creating a surplus income opportunity for their household