Sql Server Data

PRIYANK RANA

Email: qwzywb@r.postjobfree.com Phone no :- 201-***-****

CAREER SUMMERY:

• Hands-on experience in RDBMS (SQL Server 2005/2008 R2, Database Design & Development)

• Expert level skills in Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.

• Experience in SQL Replication models, Stored Procedures, Triggers, Indexes, and Views, Locking, Backup and Reporting services.

• Hands on experience in database modeling using Erwin Data Modeling tool.

• Experience in developing, deploying, managing, securing and troubleshooting SSIS Packages.

• Hands on experience in Creating, Deploying and Securing Simple, Tabular, Matrix, Drill-Down and Parameterized Reports using SSRS.

• Experience in Deploying, Securing and Troubleshooting SSAS 2008 Cubes.

• Experience in creating Database maintenance Plans, jobs, schedules, alerts and operators.

• Experience in managing security at database and server level.

• Experience in creating Roles and managing user permissions.

• Experience in handling change requests at the application, database and server level.

• In-Depth understanding on how SQL Server handles concurrency and integrity aspects of the database.

• Experience in Performance tuning Queries and Databases. In-depth knowledge of T-SQL (DDL and DML), Scripts and Batches.

• Very good experience in Creating SSIS Packages and migrating DTS Packages from 2000 to 2005.

• Hands on knowledge of Informatica 7.0

• Extensive experience in OLTP/OLAP environment.

• Experience in maintaining wired as well as wireless network.

• Experience in Electrical/Telecomm industry.

• Excellent communication, presentation and interpersonal skills.

• Self-learning ability, self-motivated and Leadership Quality.

TECHNICAL SKILL:

• Microsoft SQL Server 2005/2008, BI tools like SSIS, SSRS, SSAS & Informatica 7.0, TCP/IP, C, C++, Telecommunications, Windows, Microprocessor, Microcontroller, Networks, Firewall, LAN/WAN.

ACADEMIC QUALIFICATION:

• Master of Electrical Engineering Aug 2007-Dec 2008

University Of Bridgeport, Bridgeport, Connecticut. Overall GPA 3.37/4.0

• Bachelor of Electronics & Communication Engineering Sep 2002-June 2006

Gujarat University, Gujarat, India Overall GPA 3.50/4.0

WORK EXPERIENCE:

MURTHY CONSULTANCY SERVICES, Dec 2010 -- Current

Client: CHEVRON, as SQL Analyst, Concord CA

• Discuss with business analyst and manager to gather requirements to design profitability management operating system.

• Created Data warehouse using Ralph-Kimball Data warehousing methodology for long term Profitability Analysis Solution.

• Used Erwin/Visio for data modeling. Responsible for logical and physical design of Data warehouse and ETL process.

• Performing Database Maintenance tasks like Backup, Recovery, Replication, Performance tuning.

• Writing DML Stored procedure, triggers, User defined functions.

• Creating Tables, Views according to system requirement using DDL Command.

• Involved with business analyst, data architect, .Net developer, ETL Developer to design product.

• Running the series of stored procedure which I have designed to extract and transformed the data to meet the business requirement and then load it to data warehouse.

• Discussed with User Interface and External Interface over the performance issues and provided solutions.

• Developing, deploying & Scheduling SSIS Packages & Jobs.

• Worked with the team in building the Daily, Monthly, Quarterly, Yearly and adjustments reports.

• Daily Production support remedies.

• Reducing the overall Performance Time by SQL Query Performance Tuning.

• Involved in monitoring daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates.

• Involved in table partitioning to be used for quarterly reporting purpose.

Environment: MS SQL Server 2008, SSMS, SSIS, Data Stage, SharePoint.

QUADGEN WIRELESS SOLUTION, King Of Prussia, PA Aug 2010 – Nov 2010

RF Data collector Engineer

Responsibility:

• 3g UMTS Radio Planning and optimization.

• Responsible for the design, development and execution of test cases specific to Rogers wireless using GSM/UMTS handsets.

• Experience in testing new site using TEMS & Agilent kits.

• Testing parameters like RSCP, EC/IO, Scrambling code, Throughput, Central Frequency.

• Troubleshoot networking related issues and related problems.

• Troubleshooting IRAT, IFHO, SHO issues.

OASIS BIZ SOLUTION LLC, Lyndhurst, NJ Dec 2009 – Aug 2010

SQL Developer

Responsibility:

• Understanding Customer requirement via interaction and writing functional specification.

• Created different objects: Stored Procedures, triggers, script to populate data into different tables according to different parameters specified.

• Used data modeling tool Erwin to configure tables and define relationship.

• Debugs the procedures, triggers, views by using debug tool, monitor the system and SQL server job schedule and record any error logs.

• Design SSIS packages to transfer data from heterogeneous database & different files format to SQL Server.

• Created SSIS packages to load the data from SQL Server source to staging server and from staging server to Data warehouse.

• Migration of Database from SQL Server 2000 to SQL Server 2005.

• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time..

• Scheduled the ETL Process using Jobs. Created Alerts to notify the status of the process. As a Production support person, monitored every day’s ETL Process, and fixed the data issues.

• Reduced the overall ETL Time by SQL Query Performance Tuning. Discussed with User Interface and External Interface teams over the performance issues and provided solutions.

• Created Backups for databases and automated the process. Executed DBCC commands like CHECKDB before backing up the databases.

• Created Sub-Reports, Drilldown-Reports, Cross Tab reports using MS SQL Reporting Services(SSRS)

• Testing and Tuning SQL query for better performance.

• Created indexes and proper re-indexing for intensive OLTP system to ensure best performance.

Environment:

MS SQL Server 2005, SSRS, SSAS, T-SQL, DTS, SSIS, Windows 2003 Server, and Erwin

SPICA COMPUTERS LLC, Florham Park, NJ Jan 2009 – Nov 2009

Junior Programmer Analyst

Responsibilities:

• Meeting with business analysts, gathering the requirements for new application.

• Evaluate the plan formulated by project leader, Use flexible reusable object-oriented design.

• Develop the final code structure and user interface for the project.

• Writing and altering the SQL object in most satisfying manner.

• Involved in writing Stored Procedure, Views, and Triggers.

• Designed SSIS packages to load data from different sources like Text file, Excel, SQL table to staging and staging to Data warehouse.

• Applied different transformations, control, lookups, SCD, Derived column to easily migrate SSIS package from one server to another.

• Designed and developed various complex Profit and Loss reports using SSRS.

• Created charts, tabular and matrix reports using SSRS with/without Drill down.

• Managing, Deploying and troubleshooting the application.

Environment: MS SQL Server 2005, T-SQL, DTS, SSIS.

RELIANCE INFOCOMM LTD, Surat, India July 2006 – June 2007

Database Developer/Application Developer

Reliance Infocom is India’s biggest private information and communications services provider. Dotsoft is a Software development & Services (SDS) division of Reliance Infocom. The raw detailed calls data from different exchanges is converted into text format using C programs. The data is processed for periodical billing using SQL Server 2000.

Responsibilities:

• Actively participated in all phases of project life cycle.

• Extensive participation in logical and physical database design, and normalizing the database to accommodate possible changes in OLTP.

• Enforced Referential Integrity of data by creating different constraints.

• Successful migration of the data from text files to SQL Server database using BCP and DTS packages for the processing telephone bills.

• Excellent participation in development including triggers, stored procedures and functions created using T-SQL to implement the business logic.

• Participated in monitoring performance and trouble-shooting at the server and database level.

• Responsible for report generation using Crystal Reports based on business requirements.

• Participated in generating Backup and Maintenance plan.

RELIANCE INFOCOMM LTD, Surat, India Jan 2006 – June 2006

Trainee Telecomm Engineer (co-op student)

• Took training in Fixed-Access Department in which I have learnt installation of DLC, Broadband Internet Complaint solution & Telephone complaint solution.

• Copper & Ethernet Cable Troubleshooting and Maintenance.

• Learnt about Fiber planning for fixed-access wire line service.

References: Furnished upon request

Contact this candidate