Sql Server Data
Resume:
Archit Purohit
Pittsburgh, PA - 15222
Email: **********@*****.***
Phone: 631-***-****
Summary
To obtain a position in the field of Information Technology that allows me to utilize my education and skills while gaining valuable work experience in team oriented environment. I am looking to stay, grow and learn with a company.
Strong logical and analytical skills.
Self-motivated and Flexible
Inquisitive and Determined.
Excellent communication and Interpersonal skills.
Professional Experience
Western Reserve Group, OH July 2015 - Present
MS SQL SSIS Developer
Built and developed ETL processes to move legacy data from the landing zone to the staging area.
Developed SSIS packages from the scratch.
Modified/altered existing SSIS packages to improve efficiency and performance.
Developed and modified SQL scripts using Transact SQL in SSMS (SQL Server Management Studio).
Worked with TFS (Team Foundation Server) to keep a track of all the packages.
Used SSIS transformations such as lookup, cache, data conversions and many more for the ETL processes.
Analyzed, aggregated, summarized and managed large data sets related to all aspects of the business including Revenue Accounting data.
Identified data inconsistencies and made data performance recommendations.
Built, reviewed, and maintained complex queries.
Developed Integrations between ERP systems.
Used T-Sql to develop many complex store procedures for the SSIS packages.
Used transactions in SSIS packages to roll back any changes made to the production database in case of any execution errors.
Wells Fargo, Charlotte, NC Aug 2014 – Dec 2014
MS SQL SSIS/SSRS Developer
Worked with the project lead on a migration project to transfer the system from CISCO ICM to CISCO UCCE.
Designed, developed and deployed SSIS packages, ETL work flows and SSRS reports.
Worked on a team that designed, transformed and deployed over 400 SSRS reports during this migration project.
Developed stored procedure, triggers and functions in T-SQL that were used to invoke transfer of data and dimensions from fact tables to target tables using ETL processes.
Also developed SSIS packages to extract a list or a table from a SharePoint site.
Conducted detailed analysis of certain SQL server jobs and was responsible for the error handling and analyzing data loss for some important SQL server jobs.
Worked with various SSIS transformation tools to design ETL processes that extracted data from SharePoint sites and or fact tables in different databases.
Worked as a part of the team that designed and developed rules and dimensions for the new UCCE database.
Analyzed and studied MDX queries to view data from SSAS cubes and data marts.
Education
Completed: B.S. in Computer Science (6.29/10.00 CGPA) June 2008 - May 2012
North Maharashtra University, Maharashtra, India
Completed: M.S. in Computer Science (3.63/4.00 GPA) Aug 2013 - May 2015
University at Albany, SUNY, USA
Computer Skills
MS SQL Server 2005,2008-R2/2012, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Microsoft SharePoint, Microsoft InfoPath, SharePoint designer, Microsoft Visual Studio 2008/2010, Business Intelligence, Basic C/C++, Java, Python, Asp.net, T-SQL, PL-SQL.
Academic Projects
Masters Project Jan 2015 – May 2015
Successfully developed an Android application “File Search” which helps users to view and manage files and folder on any Android device. The application was developed in the Java programming language using the Android Software Development Kit and Eclipse IDE. Android offers a unified approach to application development for mobile devices which means developers need to develop only for Android, and their applications should be able to run on different devices powered by Android. This application enables users to select and manage all the files on their device.
Technologies used: Java, Java SDK, Android SDK.
Independent Research & Study Aug 2014 - Dec 2014
Successfully carried out an Independent Research on “Distributed File Systems” which focused on the file systems used at big firms like Google – Google File System (GFS), Facebook – Hadoop Distributed File System (HDFS) and Microsoft – Windows Azure Storage (WAS). I concentrated my study on the architecture, design features, data flow and replication process for each of these Distributed File Systems.
Web Application Development (Software Engineering) Jan 2014 - May 2014
Designed a car pooling web application called “Rideshare” that takes multiple stops as input. It also has different login options for drivers and customers and recommends drivers based on different criteria.
Technologies used: Java, HTML, jsp, java scripts, j-query and MySQL for database.
Web Application Development (Data Mining) Jan 2014 - May 2014
Deigned a recommendation application for products that scrolls tweets from twitter and processes them to determine the sentiment of users towards the product. The sentiments were further used to determine whether the product is recommended or not.
Technologies used: Python, Flask framework for python and HTML
Independent Research & Study Jan 2014 - May 2014
Successfully carried out an Independent Research on “Data warehousing & Data centers” which focused on the Big Data storage, Data warehousing techniques and Data centers of big companies like Facebook and Google.
Software Application Development Jan 2012 - June 2012
Developed a software application called “Data scope – Viewing databases in Google maps ways” that provides an easy and convenient way to view large dynamic databases on a single page.
Technology Used: Asp.net (frontend) and MS SQL.
Professional Trainings and Seminars (2008 –2012)
Training in C & C++ from HCL K2 Academy, India.
5-day training program on “Leadership and Human Resource Development”, by CLHRD AIM INSIGHT, the HRD Group, India.
Basic training in Java from Seed InfoTech, India.
Basic training in Android.
Training in Oracle Database 10g & Introduction to SQL from ITS Data Solutions Pvt. Ltd., India.
Seminar on “PTS Wireless Mesh Network Solutions.”
Seminar on “Human Area Networking - REDTACTON.”
Seminar on “Business Intelligence & Analytics.”
Seminar on “Fuzzy Logic and Fuzzy Networks.”
References
References will be provided upon request.
Contact this candidate