Data Sql Server
Resume:
Satyajit Deshpande
********.***********@*****.*** 913-***-**** Queens, NY 11432
Objective
Seeking a Full time position in Data Analytics and Software Development which will allow me to contribute for the benefit of organization, learn new technologies and improve personal skills.
Summary
Professional with 3 years of work experience in Data Analysis, Software Development, SQL Programming, Web technologies, Software Testing.
Good exposure to work on inter-company (EY, Moody’s, Santander) business requirements and perform Gap analysis and coordinate efforts of all parties to achieve the goals.
Understanding of Financial & Bank industry, Healthcare industry, Social Networking Media industry.
Strong with RDBMS concepts, ETL process, MS Excel features.
Expertise to work closely with clients on various stages of Software Development Life Cycle (SDLC).
Experience with Software development methodologies like Agile environment and Ticketing tool - Navigator Service.
A quick learner that strives for new technical knowledge. Also, strong communication and presentation skills.
A team player with strong leadership skills.
Education
Master of Science in Computer Science May 2012
State University of New York at Binghamton New York, USA
Bachelor of Engineering in Information Technology May 2008
University of Pune (Pune Institute of Computer Technology) Pune, India
Technical Skills
Programming Languages
PHP, HTML, CSS, PERL, C, C++, Java, Java-script, Visual Basic
Database Technologies
Microsoft SQL Server 2005/2008, SSIS, SSRS, DTS, Oracle 11g, MySQL, MS Access, PL-SQL, SQL-based CCL.
Software Tools
SSMS, BIDS, Putty, SVN, MS Excel, Filezilla, Quality Center, Intellinet, Navigator, VersionOne, Eclipse, Winrunner, Winscp, Bullzip, Wireshark, UML Rational Rose, Discern Visual developer.
Web Development tools
WAMP Server, PHP CodeIgniter, WordPress, PHPBB3
Operating Systems
UNIX/AIX, Windows
Professional Experience
Argus Information & Advisory Services, LLC September 2014 to Present
Data Analyst (SSIS, SSMS, DTS) White Plains, NY
Ernst & Young - Work closely with EY teams to receive requests of data and mapping documents for Santander client. Perform Gap analysis, co-ordinate current state and future state with expected capabilities. Perform ETL data loading into EY workspace with desired database schema and format. Also, perform knowledge transfer to EY point of contact.
Moody’s – Understand business logic and implement requirements for FRY report Stress Testing of Santander. Communicate updates to Moody's team promptly and provide logic and create Data Mapping documents on time. Work with Off-shore team and explain them tasks needed and review upon completion.
Analyze and Process large financial data sets to generate performance reports for Financial institutes and Banks to achieve strategic solutions for marketing and risk management.
Prepare Wallet Linkages every month using data from Bank and TransUnion/Experian. It also involves creating Syndicated Data.
Analyze Data Migration between CIBC and TD banks. Prepare monthly Netting reports to explain accounts & customers flow direction.
Create SSIS and DTS packages to process the data. Write a SQL queries using SQL Server Management Studio 2008R2(SSMS), SQL Server Business Intelligence Development Studio 2008(BIDS).
Perform Data Validation to ensure the integrity of client data. Also, create Master packages for Automation purpose.
Prepare client reports using Microsoft Excel worksheet. Use features like VLOOKUP and PIVOT.
Responsible for Testing Troubleshooting and fixing bugs.
Work closely with higher management like VPs and interact with clients to explain reports and answer their questions.
Cerner Corporation July 2012 to September 2014
Software Engineer (SQL based CCL, Oracle) Kansas City, MO
Write SQL scripts for Data extraction and Data Processing like ETL for Healthcare IT domain.
Report generation to display the processed data.
Understand requirements, implementation of new algorithms and write Design documents.
Write complex SQL queries to manage high volumes of data.
Perform Query Optimization and Performance Tuning for queries.
Write Stored Procedures, Triggers and Cursors.
Analyze Explain plans and Execution plans for Cost Based Optimizer(CBO) and Rule Based Optimizer(RBO) modes for SQL queries.
Perform Indexing and Hint the queries.
Perform Unit testing, Functional testing, Regression testing.
Follow Agile environment and involvement in improving code quality.
Work on highly paced work environment and meet the hard deadlines.
Mentor the new members on the project and provide them guidelines to build their good learning curve on the project.
Work independently to identify and resolve client side critical issues. Perform troubleshooting and bug fixing.
Nearbid.com July 2011 to September 2011
Software Developer Intern (PHPBB3, WordPress, CSS, PHP, MySQL) Scranton, PA
Design variety of forums and blogs using PHPBB3 and WordPress.
Implement and Test new features for Finance domain application where users can bid for jobs.
Work in a start-up culture in fast paced environment to meet hard deadlines.
Zest Infotech October 2008 to January 2010
Software Engineer (PERL, PHP, MySQL, HTML, CSS) Pune, India
Write bots (scripts) for email lookup of Orkut, Facebook, Bebo and LinkedIn using MS SQL Server 2008 and PHP.
Write a script which involves fetching large amount of data from different Social Media sites and process the data and store into databases.
Design and implement data models and SQL tables with all considerations of Primary key, Foreign key, Unique key, indexes, constraints.
Designed application for Orkut social site called zNotes to upload, download and sharing of files, pdfs etc.
Perform White box testing and Black box testing. Also write and document Test Cases.
Used MVC architecture and followed Object Oriented approach using PHP CodeIgniter.
Completed professional training of Software Testing.
Extra Curricular activities
Won 3 prizes for final year project of B.E. in national level technical competition.
Participation in theater activities.
Contact this candidate