Pratik Patel

**, ******* **, ********, ** *****

ab9m1y@r.postjobfree.com

848-***-****

Skills & Technical knowledge

• SQL Server database developing and implementing using SQL Server 2008 R2, Microsoft SQL Server integration

services (SSIS), Microsoft SQL Server Reporting Services (SSRS) and Microsoft SQL Server Analysis Services

(SSAS) for data warehouse and data mart solutions.

• Extensive knowledge with SQL Server and T-SQL in constructing Tables, Triggers, User defined functions, Views,

Indexes, user profiles, Relational database models, Data dictionaries and Data integrity.

• SQL database design, architecture, data modeling (Logical and Physical design) using ERWIN and TOAD DATA

Modeler.

• Thorough understanding and experience in data warehouse and data mart design, star schema, snowflake schema,

normalization and demoralization concepts and principles.

• Knowledge of Database tools like SQL Profiler, Database Engine Tuning Advisor, Erwin, and Visio.

• Strong knowledge in creating Indexes, Views, Triggers, effective Functions, and appropriate Stored Procedures to

facilitate efficient data manipulation and data consistency.

• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and SSIS Packages.

• Good knowledge in database activities like Database creation and Maintenance, Performance Monitoring, Tuning and

Troubleshooting.

• Expertise in generating reports using SQL Server Reporting Services (SSRS).

• Strong experience in creating various reports like Drill through, Drill down and Ad-hoc using the SQL Server

Reporting Services.

• Experience in scheduling and deploying reports on report manger.

• Hands on experience on SQL Server Notification Service, Service Broker.

• Solid experience in software development life cycle and n-tier applications development.

• Consistent, well-organized and dependable performer with the flexibility to adapt to constantly shifting priorities.

• Strong troubleshooting and problem solving skills. Strong ability to prioritize multiple tasks. Excellent

communication skills, proactive, self-managing and teamwork spirits.

• Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability

to adapt new technology quickly and a strong team player.

Education

• New York Institute of Technology, Manhattan, NYC, US

Masters in Computer Science, May 2012.

GPA: 3.65

• K.J. Somaiya Institute of Engineering & IT, Sion, MUMBAI, INDIA

University of Mumbai

Bachelor of Engineering in Computer Science, June 2010.

Skill sets

MS SQL Server 2008 R2, Reporting Services (SSRS) 2008 R2, Integration Services (SSIS) 2008 R2, Analysis Services

(SSAS) 2008 R2, IBM WebSphere DataStage and QualityStage 8.1, Netezza Enterprise, DTS, T-SQL, Business

Intelligence Development Studio (BIDS),Database Engine Tuning Wizard, Visual Studio, MS Visio, Erwin 7.x, TOAD

Data Modeler, C, C++, .Net Framework, ASP.Net, HTML, XML, Remote Desktop, Microsoft Office Suite, Windows

95/XP/Vista/7.

Experience

Revel Entertainment, Atlantic City, NJ April 2013 - Present

IBM Info Sphere Datastage /MS SSIS/SSRS Developer/ETL

Revel, is an entertainment resort, hotel, casino and spa in Atlantic City.

Responsibilities

• Initial responsibility was to problem and error solving of the Datastage jobs.

• Responsible for optimizing, Monitoring and stabilize the jobs to keep it up and running.

• Modified and added different functionality to the Datastage jobs as per requirement.

• Documenting all the jobs currently in production.

• In near future, planning for a migration from IBM InfoSphere Datastage Jobs to MS SSIS packages.

Fish & Richardson PC, Boston, MA July 2012 – April

2013

MS SQL Server Developer / SSRS/SSIS Developer

Fish & Richardson is a leading global law firm with more than 375 attorneys and technology specialists practicing

intellectual property strategy and counseling, Intellectual property litigation, and business litigation. Fish delivers

cutting-edge legal work for innovative clients that value their intellectual property at a cost that is an outstanding value.

For more than 130 years, Fish and Richardson has been serving great innovators protecting and defending big ideas and

helping clients build successful businesses on a foundation of creative ingenuity.

Responsibilities

• Creating physical and logical structure of the new data warehouse (SQL database) and process workflow by using

TOAD Data Modeler.

• Created several tables, views and stored procedures using SQL Server.

• Developed and stabilized SSIS packages and data flow tasks using SSIS.

• Extracted data from different sources and stored in to SQL Staging tables in BI Staging database.

• Successfully extracted data from staging to ODS, applying complex transformation and finally loading to DSS after

creating Dimensional and Fact tables.

• Good experience creating SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP

systems (SQL Server) and scheduled Jobs to call the packages and Stored Procedures.

• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Merge, Multicasting,

Conditional Split, Derived column.

• Developing several behavioral reports and data points creating complex SQL queries and stored procedures using

SSRS 2008, Excel 2007.

• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.

• Created all the SSRS report using Cube as data source.

• Extensively involved in generating reports like matrix, parameterized, Charts and Graphs like Bar Chart (Side by

Side, Stacked), Line graphs, Pie Charts and drill through reports using SSRS.

• Managed Roll based and Item level security in SSRS.

• Used Snapshots and Caching options to improve performance of Report Server.

• Designed and implemented user log in and security in SSRS.

• Involved in deployment of various SSRS Reports in Test and Production environments. Also, in charge of production

support.

• Created different data points and pulling those using SSIS package.

• Success several Ad-hoc reports by using MS Excel 2003 / 2007 and automate some of these Ad-hoc reports based

upon business demand.

• Hands on experience in creating several SSIS schedule tasks and monitor those tasks regularly.

• Analyzed the error output and error log of an automated process in case of failure of the process.

• Developed high level daily summary report and monthly business summary report (Monthly Management Report) and

distributed these reports across different business units.

Projects

Intelligent Knowledge Based Conversation

I-KBC allows user to interact with chat-bot that allows the user to ask any query and produces hand-craft responses. It

understands input and generates output from semantic representations. And it provides us basic human-to-human

communication abstracting mechanical aspects of it. It also had features that allows user to save and load the chat

conversation with the bot. Also, we can manage the volume level and the rate of speed.

Mobile phone operated robot

The basic idea was to design and develop the Mobile Robot that can be used to operate using wireless system that is

controlled by cell phone. Mobile phone operated robot was a project in which we build a robot that we can operate from

any where in the world provided that network is available. We used a concept of DTMF (Dual tone multiple frequency)

to guide the robot to move in the desired directions.

Contact this candidate