Sr Developer & Analyst

TEJ PATEL

Ph: 530-***-****

********.***@*****.***

SUMMARY:

• Over 5 years of MS SQL Server Development experience in IT Industry and Telecommunications domains with expertise in MS SQL Server 2005/2008/2008 R2 and Microsoft’s suite of products like SSIS, SSAS and SSRS.

• Experienced in Creating, Configuring and Fine-tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2005/2008/2008 R2 respectively.

• Implemented complicated transformations to be used in SSIS packages.

• Experienced in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.

• Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2005/2008 (SSRS).

• Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2005/2008.

• Expertise in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Deploying and Processing SSAS objects.

• Adept in defining referenced relationships and calculated members in SSAS and used MDX queries.

• Strong experience in Stored Procedure, Formulated Stored Procedure/TSQL coding, Performance Tuning and Query Optimization.

• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins.

• Developed a thorough knowledge and maturity in all the phases understanding business processes, gather requirements, and coordinate ongoing iterative development of Software Development Life Cycle (SDLC).

• Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance.

EDUCATION:

Stratford University, Virginia, VA, USA

Master of Science in Software Engineering, GPA: 3.40

Studies focused on Software engineering, Database application development, IT project management, web design, technical planning, business case analyses, computer networks and other communication networks.

AISSMS, PUNE University, Maharashtra, India

Bachelor’s of Engineering Computer Engineering, GPA: 3.50

TECHNICAL SKILLS

Windows NT/2000/XP/Vista/7, MS SQL Server 2008 R2/2008/2005, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), SQL Server Reporting Services (SSRS), SQL Server Analysis services (SSAS), MS SQL Server Integration Services (SSIS), SQL Query Analyzer, Bulk Copy Program (BCP), ERWIN, C,C++,MS Office suite (Word, Excel, Access, Power Point, Outlook Project), SQL Server Profiler.

EXPERIENCE:

Qualcomm, San Diego, CA Jan 2010 – Current

MS SQL Server Developer/SSIS/SSRS

Peracon is the leading Risk and Transaction Management platform for commercial real estate investors and lenders. Since inception, over 10,000 properties valued at more than $400 billion have been hosted by Peracon. Peracon’s Investor Risk Management solution provides clients with a secure, centralized location for the aggregation, normalization and analysis/reporting of all investment real estate data. The main aim of project was to develop a site and reports for history, current and forecasting solution for the LAMCO Corporation.

Tools & Technologies:

MS SQL Server 2008 R2, SSIS, SSRS, T-SQL, MS SQL Query Analyzer, SQL Profiler, Database Tuning Advisor and MS excel 2003, BIDS,SVN.

Responsibilities:

• Created SSIS package to extract, transform and load data into the Data warehouse and Report-Data mart.

• Created SSIS package to load data from Flat File to Flat File and Flat File to Data warehouse and Report-Data mart using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension. Extensively worked on SCD transformation in SSIS package.

• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.

• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.

• Developed and deployed data transfers packages to the appropriate destinations using SSIS.

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

• Created Tabular reports, Cross Tabs, Drill down, Charts, Maps, Functions and Maps using SSRS.

• Responsible for creating reports based on the requirements using SSRS 2008.

• Involved to write complex T-SQL queries and Stored Procedures for generating reports.

• Defined the report layout and identified Datasets for the report generation.

• Generated reports on wealth information, asset information, account information, research reports using adhoc reporting to be used by the clients and advisors.

• Created numbers of complex formula in sub report.

• Scheduled the monthly/weekly/daily reports to run automatically.

• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.

• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

• Performed development support, document reviews, test plan, integration of the system.

• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi Dimensional expression (MDX) to access them.

• Created reports that can be browsed at Summary level and can be drilled down to the detail level.

• Created cubes for determining quarterly sales for real estate using SSAS by determining dimensions and measures for star schema.

• Designed, developed and created Pivot table/Pivot chart reports based on OLAP cubes.

Peracon Inc., NYC, NY Jan 2009 – Oct 2010

Database Developer/BI Developer/SSIS/SSRS

Qualcomm CDMA Technologies (QCT) is the world's largest fabless semiconductor producer and the largest provider of wireless chipset and software technology, which powers the majority of all 3G devices commercially available today. The main aim of project was to develop the in-bound feed and reporting development for Database -supply/demand forecasting solution for the Corporation.

Tools & Technologies:

MS SQL Server 2008, SSIS, SSRS, T-SQL, MS SQL Query Analyzer, SQL Profiler, Database Tuning Advisor and MS excel 2003, BIDS,TFS.

Responsibilities:

• Designed a complex SSIS package for data transfer from three different firm sources to SQL Server 2008.

• Implemented data views and control tools for guarantee data transformation using SSIS.

• Extensively worked on SCD transformation in SSIS package.

• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.

• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.

• Developed and deployed data transfers packages to the appropriate destinations using SSIS.

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

• Created SQL server configurations for SSIS packages.

• Successfully deployed SSIS packages with defined security.

• Involved to write complex T-SQL queries and Stored Procedures for generating reports.

• Responsible for creating reports based on the requirements using SSRS 2008.

• Identified the database tables for defining queries to generate reports for analysis of data using SQL Server Reporting Services in Report Builder.

• Defined the report layout and identified Datasets for the report generation.

• Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.

• Generated reports on wealth information, account information, research reports using adhoc reporting to be used by the clients and advisors.

• Created numbers of complex formula in sub report.

• Designed and created Report templates, bar graphs and pie charts based on the financial data.

• Scheduled the monthly/weekly/daily reports to run automatically.

• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.

• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

• Performed development support, document reviews, test plan, integration of the system.

• Pivot table are used to provide structured to Reports in proper manner like months etc.

Infosys, Pune, India Jul 2005 – May 2007

MS SQL Server Developer

Infosys defines, designs and delivers technology-enabled business solutions for Global 2000 companies. Infosys also provides a complete range of services by leveraging our domain and business expertise and strategic alliances with leading technology providers.

Tools & Technologies:

SQL Server 2005, Erwin, T-SQL, SQL Profiler, Microsoft SQL Server Management Studio.

Responsibilities

• Involved Logical, Physical design and Development of the DSR (Data Staging Repository) for Beacon Database and AMS (Asset Management Reporting System) using Erwin.

• Define Check constraints, Business Rule, Indexes and Views.

• Worked with data modeling product support team on tool features, functionality and maintenance.

• Installed SQL Server 2005 and Management tools using SQL Server Setup Program.

• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions etc using T-SQL to provide structure to store data and to maintain database efficiently.

• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity and provide additional application functionality.

• Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.

• Used Performance Monitor, Query Analyzer and SQL Profiler to optimize queries and enhance the performance of database servers.

Contact this candidate