SUMMARY

• Over 8+ years of extensive experience in database development, Client Analysis, Database Design and Presentation with Microsoft SQL Server 2012/2008/2005 and Microsoft’s suite of products like SSIS, SSAS and SSRS
• Proven Expertise in SQL Server T - SQL programming.
• Extensive exposure to T-SQL Performance Tuning.
• Experience in providing development and Database Administration for Confidential Global Supply Chain Business Intelligence Decisioning R2.0 application using Microsoft SQL Server 2008 R2 and 2012 BI stack
• Good experience in the physical Database design aimed at high performance
• Proven expertise in design and development of SSIS packages, SSRS packages and SSAS OLAP Solutions
• Experience in all the phases of the Software Development Life Cycle
• Excellent Analytical, Technical, Communication, Leadership, Interpersonal and Problem Solving capabilities.
• Proven ability in generating all types of reports - Drill down, Drill through reports, Parameterized reports, sub-reports, navigation reports (Hyperlink) etc. in SSRS 2005/2008.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Strong SQL Server developer skills including writing stored procedures, user defined functions, views, triggers, CTE (Common Table Expressions).
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc).
• Experience in managing Alerts, notifications and Jobs through SQL Server Agent.
• Experience in writing Procedures, Functions, Triggers and other database objects using SQL and PL/SQL.
• Good understanding of RDBMS and design of database architecture.
• Very Good Knowledge in Logical and Physical Data modeling, creating new data models, data flows and data dictionaries.
• Knowledge on different reporting tools (SSRS, Crystal Reports, Cognos, B.O)
• Expert in of various source transformations, including flat files, XML and relational systems.
• Experienced in designing report layouts inSSRSand deployed cubes using SSAS.
• Generated reports usingSQLServer Reporting Services integrated and deploying them using web applications onto the web servers.
• Good working knowledge with Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Facts and Dimensional tables and Operational Data Store (ODS).
• Experience in creation of logins, users and configuring permissions and assigning roles to users.
• Expertise in designing and implementing ETL & BI solutions using SQL Server 2012/2008/2005 SSIS, SSRS.
• Utilized Access, Excel and SSRS to create, modify, run, export, print, distribute, deploy, and troubleshoot reports.

TECHNICAL SKILLS

RDBMS: MS SQL Server, MS-Access

Web Technologies: HTML, DHTML, ASP.Net, XML, Java Script and VB Script

Languages: C, C++, Java, T-SQL, VB.NET, ASP.NET, XML, PHP

Operating Systems: Windows 2008R2, 2003, Windows 2000 server

Version Control Tools: Visual Source Safe, Rational Clear Case and SVN

Reporting Tools: Crystal Reports, Microsoft Reporting services, Cognos Reporting, Macros

Modeling Tool: ERWIN, Microsoft Visio

PROFESSIONAL EXPERIENCE

Confidential, Sanjose, CA

SQL Server Developer SSIS/SSRS/SSAS

Responsibilities:

• Generated multiple Enterprise reports using SSIS, SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler
• Created different Parameterized Reports (SSIS, SSRS 2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Experience working with VB application where application was built on a VB 6.0 front-end consisting of class modules and some forms.
• The backend resided on mainframe DB tables which interfaced with via VB.
• Created complex stored procedures, Triggers, User-defined Functions, Views and Cursors for handling business logic and functionality of various modules.
• Worked with other database administrators, report writers, and project teams to refine reporting requirements based on customer's business needs.
• Create ad-hoc SQL queries for customer reports, executive management reports
• Scheduled reports to refresh and run on daily, weekly and monthly basis in the report manager.
• Worked on SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Created data loads and Upgrade scripts for data migrations and validations.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Provided documentation about database/data warehouse structures and updated functional specification and technical design documents.

Environment: Microsoft SQL Server 2005/2008, MS Windows Server 2003/2008, SSAS, SSIS, SSRS, Visual Studio 2008, ASP.NET, T-SQL, XML, Cognos

Confidential

SQL Server Developer SSIS/SSAS/SSRS

Responsibilities:

• Created report models for Ad-hoc reporting. Created Ad Hoc reports in Report Builder.
• Created parameters for the required fields using the report designer in order to see the dropdowns in the end report.
• Used various types of report layout options like charts, images, sub reports, hyperlinks etc. to make them more attractive and understandable.
• Designed various reports using different reporting features such as group by, drilldowns, and drill through.
• Worked with Business Analyst & Users to understand the requirements.
• Involved in System Study analysis for logical/physicaldata model there by defining strategy for implementingStar Schemawith Fact & Dimension tables.
• Expertise in writing and debugging Stored Procedures, Triggers, Cursors and T-SQL coding.
• Responsible for optimization & tuning complex Transact SQL queries for better performance.
• Created constraints and triggers to ensure the consistency of data in the database and staging database.
• Creation of all database objects as desired standards and setting permissions and wrote DDL & DML Statements.
• Created SSIS packages to transfer data between OLTP and OLAP databases.
• Created cubes using SSAS and populated facts and dimension tables and generated reports from cubes using SQL Server Analysis Services.
• Involved in checking database consistency, data integrity and data redundancy.
• Involved in snapshot replication of the production database
• Implemented transactional replication to meet reporting services requirements.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports.
• Monitored database system resources and performance. On-call during off hours and weekends on a rotation basis.
• Coordinated database system upgrades with IT team, end users, and vendors.

Environment: MS SQL Server 2008, VS2008, SQL Server Reporting Services (SSRS 2008), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), T-SQL, MS Excel.

Confidential

SQL / SSIS / SSRS/ETL Developer

Responsibilities:

• Involved Automation of BackOffice project and Migration of SQL.
• Create tabular and summary reports for data validation
• Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server T-SQL stored procedures within SQL Server 2012 environment.
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Created Position and Transaction OLAP Cubes for mortgages Loans for various measure groups and dimensions (Loan Position, Commitment Schedule, Loan Journal Entry, Loan journal Entry Period Zero, Time Period, Loan, Account, Portfolio, Property, Business Unit, Borrower, Journal Entry Demographic, Journal Entry Line Item etc. ) to address the business needs using SSAS
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Developed crystal reports.

Environment: MS SQLServer, 2008/2005, SQL Server Integration Services (SSIS) 2008, T-SQL 2008, MS Office and, Windows Vista.

Confidential

Jr. SSIS/SSRS Developer

Responsibilities:

• Worked with other database administrators, report writers, and project teams to refine reporting requirements based on customer's business needs
• Created Triggers that produces primary key (unique) automatically when a new record is inserted into the database. The intention is to maintain unique records to eliminate duplicate records.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Create ad-hoc SQL queries for customer reports, executive management reports
• Scheduled reports to refresh and run on daily, weekly and monthly basis in the report manager.
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like SSIS, BCP, BULK INSERT etc. and used configuration files and variables for production deployment
• Created data loads and Upgrade scripts for data migrations and validations
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Provided documentation about database/data warehouse structures and Updated functional specification and technical design documents.

Environment: MS SQL Server 2008, VS2008, SQL Server Reporting Services (SSRS 2008), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), T-SQL, PL/SQL, Oracle 9i, Toad, MS Excel