Sql Server Management

Anirban Ghosh

www.linkedin.com/in/ghoshanirban

Cell: 813-***-**** Email: *******.*******@*****.***

Summary

• 4 years of professional work experience with databases such as Sql Server, Oracle & MongoDB, writing & optimizing SQL &

PL/SQL code & writing Test Plans

• Expertise in building Microsoft Business Intelligence & Corporate Performance Management solutions including Dashboards,

Score Cards, Query & Analysis reports and KPI using SSAS, SSIS, SSRS, IBM's COGNOS, tableau, R & SAS

• Exposure to building data warehouses based on STAR and or SNOWFLAKE schemas, Data marts, and Staging areas

• Proficient in multi-dimensional Data Analysis, Data mining and modeling, Data mapping identification & documentation, Data

Extraction and Load Process from multiple Data Sources, Data Verification, Data Cleansing, Transformation, Integration, Data Import,

Data Export and use of multiple ETL tools

• Certification from SAS in Analytics and Business Intelligence with specialization in data mining and predictive analysis

• Domain experience in Telecom, Civil Engineering, Finance(Banking & Capital Market) & e-Commerce

• Expertise in Business process automation, Providing end-to-end technology solutions & Operations support

• In depth knowledge of all phases of SDLC, SCRUM & Agile software development methodologies

• Skilled in advanced oral and written communication, including analysis, specification and database/system preparation and report

presentation

• Interest areas include - Database Modeling & Development, Data Science & Engineering, Big Data (Hadoop)

Technical Skill-set

Languages : SQL, PL/SQL, R, SAS, Powershell, XML, C#, Java, Java Script

Systems : Windows (All Versions), Unix/Linux

Databases : Oracle, MS Access, Sql Server, MongoDB

Tools/IDE : Sql Server Management Studio, Business Intelligence Development Studio, Sql Server Report Builder, Visual

Studio, SQL Developer, Toad, MongoVUE, Weka, SaS Enterprise Miner, Rattle, Tableau, Cognos, Remedy,

Eclipse, ArgoUML, MS Project, Microsoft Office Word, Excel, PowerPoint, Outlook, Visio, SSIS, SSAS, SSRS,

Master Data Services

Certifications: ITIL V3 Foundation, Analytics and Business Intelligence (SAS), Introduction to Anti-Money Laundering and

Intelligence Analysis (CITI)

Education

Master of Science in Management Information Systems (Business Intelligence) Dec 2013

School of Business, University of South Florida, Tampa, FL

• Completed coursework includes: Advance Systems Analysis and Design, Advance Database Management, Data Warehousing, Data

Mining, Statistical Data Mining, Enterprise Information Systems & Project Management

Bachelor of Engineering in Computer Science (Distinction) Aug 2009

University of Pune, Pune, Maharashtra, India

Professional Experience

Developer & Analyst, Raymond James Financial Inc, St. Pete, FL May 2013 – Dec 2013

• Designed Quality Center Status & Defect Tracker SSRS reports for the Higher Management during Data Center move to Denver

• Designed a database model using Sql Server 2012 which maps Project-CI-Releases for Raymond James IT

• Set up the database architecture & design for the Release Automation Manager in Sql Server 2012

• Wrote Powershell 3.0 Scripts to automate the creation of Active Directory Service Accounts & Groups

• Converted Powershell scripts to C# modules using .Net 4.0 Framework

• Automated the creation of Enterprise Password Vault's; Technology: Powershell 3.0, Pacli

Database Developer Intern, SiteWit, Tampa, FL Jan 2013 – May 2013

• Understood enterprise class marketing applications efficiently & extracted business insights from semi- structured data sets

• Designed & developed a Lead Management System using Sql Server 2010

• Once verified & validated against requirements, designed & scaled up the system using MongoDb (non-relational database)

DataWarehouse Developer & Data Analyst, CUTR University of South Florida, Tampa, FL Sep 2012 – Jan 2013

• Set up the DataWarehouse to house all the GPS information emitted by freights moving in USA & created civil engineering

computational cubes & roll-ups on the fact tables

• Lead the lifecycle development of the Freight Travel Application

Pl/Sql Developer & Data Analyst, Application Maintenance & Support, TechMahindra, Pune, India Mar 2011 – Jul 2012

• Developed pl/sql scripts (procedures & functions) that took care of bulk tasks and resulted in process-performance improvement

• Developed utilities to simplify or automate internal project management / tracking tasks & improve process workflows

• Modify/Create/maintain and optimize ETL processes

• Assessed, analyzed & resolved error cases in Order Provisioning System DSLRP & Client Interfacing Systems BTH -MSH

• Lead daily task-effort co-ordination with Client & Team

Database Developer, TechMahindra, Pune, India Dec 2009 – Mar 2011

• Part of the delivery team of lifecycle development of Order Provisioning System DSLRP

• Employing AGILE methodology, worked in all the project development phases: from requirement-gathering to Deployment &

Go-Live

• Managed the product and user acceptance test cycles including defect analysis, collaborating with client, and fixing the reported

issues, resulting in 20% effort savings

• Handled critical Go-Live issues and reported status to higher management on a daily basis

• Prepared and organized regular knowledge-transfer sessions on DSLRP for the Application Maintenance & Support Team

• Developed utilities to simplify or automate internal project management / tracking tasks & improve process workflows

Academic Experience/Projects

Graduate Assistant, University Of South Florida, Tampa, FL Jan 2013 – Dec 2013

• Proctored exams and grade projects for the coursework "Computers in Business"

• Assisted more than 500 undergraduate business and finance majors, to be power users in Microsoft Office Suite and Windows

Blue Book For Bulldozers - Statistical Data Mining Apr 2013

• Project goal - Predict the sale price of a particular piece of heavy equipment at auction based on its usage, equipment type &

configuration; Technology: R, SAS

Real Time Stock Market Apr 2013

• Designed a stock market based on the S&P 500 stock market index; Technology: Sql Server 2012, Tableau, Cognos, SSRS

Our Own UNIX Shell (The TechM Shell) Mar 2010

• Designed a Unix Shell to implement 15 user commands. (Command Interpreter); Technology: C++

Cell Phone Security Using Fingerprint Recognizer May2009

• Implemented Hilditch's Algorithm for Skeletonization, Hit-and-Miss Algorithm and Minutiae-based Algorithm for fingerprint

recognition; comparison threshold: 70% ; Technology: Java, Oracle

Instant Services System (Cloud Computing in Windows Azure Platform) Aug 2008

• The idea behind Instant Services System was to provide a one-stop answer to all household requirements; Technology: ASP.Net &

Cloud

Database Management System for an Education Board Aug 2006

• The project involved developing a user interface which is customized to the needs of every individual part of an Education

System; Technology: Visual Basic 6.0, Oracle

Honors

• Talk-Talk HEROES Award by the client Talk-Talk for re-design & development of "BTH-Opal Middleware" Mar 2012

• Awarded PAT ON THE BACK Award for helping Internal Delivery Unit achieve highest Capability Index (CI) score at Tech

Mahindra Limited Oct 2010

• Recipient of RAJYAPURASKAR Award from the Government of Assam, as a member of The Bharat Scouts & Guides

Movement Mar 2002

Leadership & Membership

• Chief Technology Officer, Management Information Systems Society, University of South Florida Dec 2012 - Dec 2013

• Engaged in Rural Reach Program (Nanhi Kali) which is a part of Corporate Social Responsibility (CSR) initiative of TechMahindra

Limited. It facilitates easy learning in rural schools which lack the amenities and curriculum for information technology basics

Jan 2010 - Jul 2012

• Vice President, Association of Computer Engineers (ACE) – Organize Student-Corporate network sessions & engage in

student employability initiatives Aug 2007 - Jul 2008

• Vice President, Student Coordinator – Organized a national level technical event, coordinating a team of 50+ members within a

time span of a month, inviting other Engineering colleges, delegating work to different teams Jul 2006 - Jun 2009

Contact this candidate