SUMMARY

• Over 7 Years of IT experience in MS SQL Servers databases Design, Development, Analysis and Reporting. Experience in installing, configuring, managing, upgrading and migrating, Backup/Restore, monitoring and troubleshooting MS SQL Server 05/08/08 R2/12.
• Strong experience with T - SQL(DDL & DML) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency.
• Experience in SQL Server Suite of products (SSRS/SSIS/SSAS) and involved in all phases of Software Development Life Cycle from gathering requirement, development, implementation, testing and support.
• Well versed with Data Warehousing - star schema, snow flake schema and relational database experience including MS SQL Server, MS Access and Oracle.
• Proficient in creating ETL packages using SQL Server 05/08/08 R2/12 Integration Services (SSIS).
• Experience in High Level Design of ETL Packages for integrating data using OLE DB connection from heterogeneous sources by using multiple transformations.
• Experience in incremental data migration from various data sources (Flat Files, Excel, MS Access, oracle) using ETL.
• Hands on experience with performing various SSIS data transformation tasks like Lookup, Conditional Splits and Event Handlers, Error Handlers etc.
• Proficient in design and development of enterprise reports using SQL Server Reporting Services (SSRS) and reporting out of SSAS cubes using MDX queries.
• Specialized in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports, Charts, Dashboards using SQL Server Reporting Services(SSRS).
• Extensive Knowledge in email subscriptions for data driven reports by using Report Manager.
• Created SSAS cubes with multiple Fact tables and Cube calculations and cube localization, KPI’s, Cube partitions.
• Expertise in designing/creating several reporting services reports that have been formatted specifically for dashboard displays, i.e. with charts, KPIS, tables, etc
• Experience in Tuning T-SQL queries and improving the performance of the Database.
• Expertise in using tools like SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Good understanding of Agile/Scrum, Waterfall Methodologies.
• Experience in Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.

TECHNICAL SKILLS

SQL Server Tools & Packages: SQL Server Management Studio(SSMS),DTS,SSIS,SSRS,SSAS,SQL Server Business Intelligent Studio (BIDS),Enterprise Manager, SSMA, SQL Profiler, Visual Studio.

Database: SQL Server05/08/12,ORACLE 10g/11g,DB2,MS Access, MY SQL, Teradata

Languages & Web Technologies: T-SQL,PL/SQL, C,C++,Java, HTML, XML, Java Script, CSS

Operating System: Windows, Unix, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Morton Grove, IL

SQL BI Developer

Responsibilities:

• Involved in the business interaction with the users and gathered the requirements that neededto exist in the Project.
• Created various Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server 2008 R2 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Developed DTS packages to copy tables, schemas and views and to extract data using SSIS.
• Created SSIS process design architecting the flow of data from various sources to target.
• Performed efficient tuning of SQL source queries for data load/usage of stored procedures for performance.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Designed ETL structures for data imports from various sources such as Oracle, TeraData & Excel .
• Extensively imported data from various sources such as MS Excel and MS Access using Import Export Wizard and also using SSIS.
• Developed SSIS packages to transform data from MS SQL 2008 R2 to MS SQL 2012 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Created Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Implemented query for Drill Down and Ad Hoc Reports using SQL Server 2008 R2/2012 Reports Services (SSRS).
• Worked on Analysis services (SSAS) to create multidimensional cubes to slice and dice the data.
• Used ETL Transformations to meet the business requirements while created SSIS Packages.

Environment: SQL Server 2008R2/2012, SSIS 2008 R2, SSIS 2012, T-SQL, Excel, Microsoft SQL Reporting Services 2008 R2 (SSRS), MS SQL Analysis Services(SSAS), Windows XP, Oracle 10g, Teradata 14.10,Agile.

Confidential, Irving, TX

SQL Server BI Developer(SSIS/SSAS/SSRS)

Responsibilities:

• Involved in development and implementation of SSIS,SSAS and SSRS application solutions for various business units across the organization..
• Worked on Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Used DTS/SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including SharePoint integration.
• Created highly complex SSIS packages using various Data transformations like Conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, Column conversion, Fuzzy Grouping, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2008 and develops and unit test SSIS load processes for performance check.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Created various complex reports and manage them using SQL Server Reporting Services (SSRS 2008/2012).
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server.

Environment: MS SQL Server 2008/2012, BIDS, SQL Server Management Studio (SSMS) Visual Studio 2010, XML, SSIS, SSRS, SSAS, Windows 2003 Server, Agile.

Confidential, Kansas, MO

SQL BI Developer

Responsibilities:

• Involved in requirement gathering and involved in Data warehouse schema design (star schema and snowflake schema for multiple projects).
• Used SSIS 2008 created various packages to bring data into the staging area from various sources like text files, Excel and SQL Server databases.
• Created SSIS configurations using XML, SQL run tables and various dynamic expressions.
• Involve in entire cycle of BI process right from requirement gathering, design stage, ETL (SSIS), Building cubes, Reporting (SSRS) and Analysis (SSAS).
• Developed complex stored procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Developed SSAS Cubes and build KPI’s, create translations, cube calculations, cube partitions in SSAS cubes and cube localization concepts.
• Created hierarchies and pseudo relations in SSAS cubes, Fact less fact table concept, utilize various property parameters in SSAS.
• Concepts of show and hide cube members and ignore unrelated dimensions when more than one fact table exists.
• Involved in building dimensional cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.
• Involved in the process of upgrade from SQL Server 2005 to SQL Server 2008.
• Work and resolve support tickets on ETL, SSRS reports.

Environment: MS SQL Server 2005/2008, Windows 2003/2008, SSIS,SSRS,SSAS SQL Server Management Studio(SSMS), SQL Server Business Intelligence studio, Microsoft Excel and Access, Visual Studio.

Confidential, St. Louis, MO

SQL BI Developer

Responsibilities:

• Designed the migration plan in accordance with the business standards and practices and addressing the incompatibility and inconsistencies of the existing application.
• Worked closely with Database Architects in designing Data marts and Data warehouse.
• Involved in extracting the data from transaction system to staging area from various sources like MS Excel, MS Access, and Oracle using ETL (SSIS).
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Used various transformations while mapping the data from staging to destination and then deployed the packages to production.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified the requirements for generating dynamic and ad-hoc reports (Cross-Tab, Drill-down and Sub-Report) using SSRS .
• Designed and implemented Parameterizedand cascading parameterized reports using SSRS.
• Created cubes using SSAS as per business requirement.
• Used SQL Server Profiler and Performance Monitor, stored procedures, triggers, and functions to monitor and improve the performance of the database servers.

Environment: MS SQL Server 2008, SSRS, SSIS, SSAS, T- SQL, MDX, Erwin, MS Excel 2003 Visual Studio 2005Windows XP/2003.

Confidential, Jacksonville, FL

SQL BI Developer

Responsibilities:

• Hands on experience in installing, configuring, managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2005/2008 R2.
• Excellent in high level design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Data cleansing Conditional Split, Bulk Insert, Merge and Union all.
• Experience in performance tuning and query optimization.
• Experience in maintenance and administration of SSIS by creating jobs, alerts, SQLMail Agent, and schedule DTS/SSIS Packages.
• Experience in report writing usingSQLServer Reporting Services (SSRS) and creating various types of reports like drill down, parameterized, cascading, conditional, table, matrix, chart and sub reports.
• Experience in writing expressions in SSRS, expert in fine tuning the reports and also involved in production phase.
• Excellent knowledge in creating databases, tables, stored procedures, DDL/DML Triggers, views, user defined data types, functions, cursors and indexes using T- SQL.
• Hands on experience in creating star schema and snow flake schemas.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.

Environment: SQL Server 2008 R2/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio(SSIS,SSRS,SSAS),T-SQL,XML,MS Visual Studio, Windows Server 2003.

Confidential

SQL Developer

Responsibilities:

• Worked as a developer on databases like MS SQL Server 2005, MS Access.
• Used T-SQL, scripts, stored procedures and views to run routine reports.
• Managed requests that came from the client as well as the development teams.
• Designed and developed the logical and physical model of the database.
• Worked on MS SQL Server tasks such as data loading, batch jobs, and Indexes.
• Managed backup and disaster recovery of the team.

Environment: MS SQL Server 2005, MS Access, T-SQL, Windows.