Sql Server Data
Resume:
Pratik Patel
**, ******* **, ********, ** *****
**************@*****.***
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