SUMMARY:

• Over 7 years of IT experience in teh analysis, design, development, tuning, administering, implementing and testing Client/server applications and various segments of SDLC, using MS SQL Server 2005/2008/2008 R2/2012, SQL Server Integration, Reporting, and Analysis Services.
• Extensive SQL Development experience in a Banking, Healthcare environment, and Financial with a strong understanding of data & analytics.
• Experienced in logical, physical, and dimensional data modeling, data mapping, and data normalization, Proficient in creating Transact - SQL (DDL, DML, and DCL), Indexes, Views, Table Variables, Complex Stored Procedures, User and System defined functions to facilitate efficient data manipulation and consistent data storage.
• Strong technical knowledge in Integration and Analysis Development including Reporting, Designing logical/physical databases, Troubleshooting, Maintaining Backup, and Recoverability.
• Experienced in Extracting, Transforming and Loading (ETL) tasks using SSIS including and its application such as BCP utility and SSIS ( 2005/2008/2008 R2/2012) Packages with proper control & data flow elements.
• Excellent experienced in using transformations such as Aggregate, Lookup, Fuzzy lookups, conditional splits, derived column, error handlers, Data conversion, OLEDB Command, and other necessary transformation tasks in SSIS Packages.
• Good knowledge of Datasets, Data Marts, Data warehousing, FACT and Dimensions Data Modeling, Star Schema Modeling, Snow - Flake Modeling.
• Expert in SQL Server 2005/2008/2008 R2 OLAP database development, including KPIs, Data mining, and Slowly Changing Dimensions.
• Resolved SQL Reporting Services issues and Proficiency in creating different types of reports such as Conditional, Drill-down, Summary, Form, and Sub reports.
• Created and deployed SSRS Reports from SSAS cubes and various data sources on teh portal for teh user accessibility.
• Knowledge in developing a dashboard using Performance Point and SQL Analysis Services.
• Excellent problem solving, analytical, technical, interpersonal and communication skills with strong leadership abilities. Extremely diligent, strong team player with an ability to quickly adapt to new roles.

TECHNICAL SKILLS:

• Microsoft SQL Server 2005/2008/2008 -R2/2012
• SQL Server Management Studio (SSMS)
• SQL Server Business Intelligence Development Studio(BIDS)
• SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS), MS-Access
• MS-Excel, SQL, T-SQL
• HTML, XML, Visual Studio 2005/2008
• Crystal Reports, SQL Profiler, MS Visio, SharePoint.

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

MS SQL/ BI Developer

Responsibilities:

• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases. Created Indexes for teh quick retrieval of teh data from teh database.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance teh performance of databases.
• Created SSIS Packages using fuzzy lookup, derived columns, conditional split, Term extraction, aggregate, execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for teh reports and to export data from Excel Spreadsheets, Text File, MS Access and CSV files.
• Deployed teh packages on staging and production. Created SSIS packages for data Importing, Cleansing and Parsing. Extracted, cleaned, and validated data from XML file into database using XML source.
• Set SQL server configurations for SSIS packages and configured logging including windows event log and XML source.
• Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat files, Excel source files, XML files etc.) and tan loaded teh data into destination tables by performing different kinds of transformations using SSIS.
• Used Event handlers for Custom Logging using Complex Store Procedures for various events (On Warning, On Pre and Post Execution, On Task failed etc.)
• Generated parameterized / Drilldown reports using SSRS and Crystal Reports. Created snapshot reports. Used dynamic parameters in SSRS to enable/ disable teh parameters based on user selection.
• Scheduled daily and weekly jobs using SQL Server Agent.
• Used MDX to create calculated members in teh cube.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild teh Dimensions and cubes in Analysis Services.
• Extensively involved in teh SSAS storage and partitions, and aggregations, calculation of queries with MDX, data mining models, developing reports using MDX, and SQL.
• Exported and generated teh tabular report using excel power pivot.

Environment: Microsoft SQL Server 2012, TSQL,SQL Integration Service (SSIS), SQL Reporting Services (SSRS), Data Warehousing (SSAS), MSIIS 7.0, MDX, MS Office 2010, Oracle 10g, Crystal reports.

Confidential, Katy, TX

MS SQL/ BI Developer

Responsibilities:

• Created and configured teh database, with 2 file groups, created teh tables having required constraints.
• Analyzed business requirements and build logical data models that describe all teh data and relationships between teh data.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created SSIS packages through ETL Process to vendors in which records were extracts from Flat file an Excel sources and loaded daily at teh server.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and SCD I and SCD II changes.
• Participated in identifying Data migration issues and resolved them.
• Created Matrix, Drilldown, Snapshot Reports have been generated to identify teh best business vendors.
• Extensively worked with Monitoring and Analysis services of vendors to provide teh best possible KPIs, Analytical Grid and scorecards to build teh best possible Dashboards for teh Inventory Manager for better decision making.
• Designed BI portals in SharePoint server 2010 to vendor reports, dashboards and scorecards.
• Involved in deploying, configuring and managing teh reports using SSRS and used report subscription to publish reports.

Environment: MS SQL Server 2008R2, SQL Profiler, TSQL, SQL Integration Service (SSIS), SQL Reporting Services (SSRS), Data Warehousing (SSAS), MSIIS 6.0, MDX, MS Access 2003, Oracle 8i, Windows Server 2003.

Confidential, Southfield, MI

MS SQL Server/ BI Developer

Responsibilities:

• Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
• Created complex Stored Procedures, triggers, cursors, tables, views and SQL joins and statements for applications by using T-SQL.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Created teh automated processes for teh activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification, indexing and statistics updates.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008 from different environments for teh SSAS cubes using various task e.g. For Each Loop, File System Task, Execute SQL task, Execute Process Task, Execute Package Task, Send Mail Task..
• Involved in C# coding for script task for creating SSIS Packages. Involved in Loading Dimension with teh SSIS slowly changing Dimension Wizard.
• Involved in designing cubes in SSAS environment using Star Schemas. Involved in creating Dimensions, KPI, Measures and calculations.
• Assisted in production of OLAP cubes, wrote MDX queries to produce reports using SQL Server 2008 Analysis Services (SSAS) and Reporting service (SSRS).
• Created Drill through, Matrix, sub reports using SSRS.
• Created reports with Analysis Services Cube as teh data source using SQL Server 2008 Reporting Services.

Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, OLAP, OLTP, T-SQL, Stored Procedures, SQL Server Enterprise Manager, ETL, DTS, Performance Point Server 2007, C#, IIS 4.0, Visio 2000, SQL Server Query Analyzer, SQL Profiler, MS Access.

Confidential, Richmond, VA

MS SQL/ BI Developer

Responsibilities:

• Database planning in relation to physical and logical data architecture.
• Analyzed business requirements and build logical data models that describe all teh data and relationships between teh data.
• Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes).
• Designed new SSIS packages and deployed them, involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications.
• Created Drill down, Drill through, Snapshot, Sub-reports using SSRS.
• Deployed reports in teh report server.
• Provided support for in-house and offshore Development Team.

Environment: SQL Server 2005 Enterprise Edition, SQL, Enterprise Manager, T-SQL, MS PowerPoint, MS Project & Windows 2003 server, Visual Studio 2003, IIS 6.0, Report Builder.

Confidential

MS SQL Server Developer

Responsibilities:

• Performed server installation and configuration using SQL Server 2005.
• Created Dimensional Model (Data Mart) to provided data for reports.
• Developed backup restore scripts for SQL Server as needed.
• Replication of data using Transactional method.
• Migrated data from SQL server successfully.
• Created SSIS Packages using conditional split, execute Data Flow Task, and Execute Package Task etc. to generate underlying data for teh reports and to export data from Excel Spreadsheets, Text File, and CSV files.
• Data migration (import & export -BCP) from text to SQL Server, Used Scripts and variables, email notifications for ETL process using Data Integrator in SSIS.
• Created SSIS packages for data importing.
• Deployed teh packages on target computers.
• Data conversion from Text File into SQL Server Table.
• Generated teh Matrix report using SSRS.
• Created Windows Logins and privileges to User Accounts/ Groups and objects.

Environment: MS SQL Server 2000/ 2005, T-SQL, SQL Server 2005 Reporting Service, Excel 2000, Windows 2000 Server.