PROFESSIONAL SUMMARY:

• 7+ years of experience in Design, Development and business intelligence of Microsoft SQL server 2012/2008/2005 wif various business domains.
• Proficient hands on working noledge wif SQL ServerIntegration Services(SSIS) and SQL ServerReporting Services(SSRS).
• Strong working noledge in creating databases, tables, indexes, stored procedures, views, triggers, T - SQL, SSIS using MS SQL Server 2012/2008/2005 .
• Used SSIS Control Flow items (for each loop, execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion. Fuzzy Lookup, Union all).
• Experience in working wif Normalization/De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects including tables, Constraints and Indexes using DDL, DML, DCL commands.
• Extensive Data Warehousing experience in Requirement Analysis, Design, Development, Testing, Implementations, Loading, Maintenance, Enhancements of Data warehouse, and ODS systems using Informatica 9.x/8.x, Oracle 11g/10g, DB2, SQL Server, Teradata, PL/SQL, and well versed wif Data Warehousing Architecture, Operational Data Store, and Dimensional Data Modeling.
• Experience in MS SQL Server Migration from SQL Server 2005 to SQL Server 2008.
• Very good noledge in scheduling and deploying reports on report manger.
• Experience in query optimization and performance tuning.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using SSRS in Business intelligence development studio (BIDS).
• Expertise in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS andSSISservices.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Implemented complex business logic wif User-Defined-Functions, Indexed Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP
• Scheduled and monitored all maintenance activities of SQL Server to meet business requirements activities including database consistency check.
• Expert in T-SQL, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
• Ability to work in-groups as well as independently wif minimal supervision.
• Good team player, strong interpersonal and communication skills combined wif self-motivation, initiative and teh ability to think outside teh box.

TECHNICAL SKILLS:

Databases: - MS SQL Server 2012/2008/2005, MS Access, Oracle 9i/10g, MySQL

Programming: - SQL, T-SQL, PL/SQL, Unix Shell Scripting, Java, Hadoop and Hadoop echo systems, XML.

Environment: - Windows 98, 2000/XP, Windows 2000 Advanced Server/Server 2003, Windows 7, Linux

Database Tools: - T-SQL, Enterprise manager, Query Analyzer, SQL Agent, SQL Trace, Performance Monitor.

Reporting Tools: - SSRS, Microsoft Excel, Excel Power BI, Crystal Reports, exposure to Tableau, OBIEE

WORK EXPERIENCE:

Confidential, Atlanta, GA

SQL Server Developer

Responsibilities:

• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making teh system more modular, secured and extensible.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Responsible for rebuilding teh indexes and tables as part of performance tuning
• Monitored performance and optimize SQL queries for maximum efficiency.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from Heterogeneous sources such as Oracle and Access database, DB2, and flat files for theSSAScubes.
• Created SSIS packages using lookup transformation, conditional split, data conversion, derived column, join, merge join, slowly changing dimension.
• Extensively worked on Control Flow tasks like for-each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Worked wif SSIS packages involving FTP tasks, Fuzzy Grouping, Merge, and Merge joining.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Worked on logging, package configuration and event handling in SSIS.
• Used Text Files/ SQL Server Logging for all SSIS packages.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked wif SSIS packages involving Transactions, Restartability and rollback techniques.
• Designed Cubes wif Star Schema using SQL Server Analysis Services (SSAS). Created several Dashboards and Scorecards wif Key Performance Indicators (KPI) in SSAS.
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• Created On demand (Pull) and Event Based delivery (Push) of reports according to teh requirement.
• Generated periodic reports based on teh statistical analysis of teh data using SQL Server Reporting Services (SSRS).
• Created dashboards using power view, power map, and power pivot.
• Deployed and configured teh reports in teh Report Server.
• Used SQL Server Agent for scheduling jobs and alerts.
• Schedule teh packages to keep extracting teh data from OLTP at specific time intervals using SQL Jobs.
• Used Notification services to generate error messages and send them to teh user through e-mails, pager messages, and PDA as well as window messengers.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.

Environment: MS SQL Server 2012, SSRS 2012, SSIS 2012, SSAS 2012, T-SQL, Visual studio 2010, MS Access, Excel.

Confidential, Boston, MA

Sr. SSIS/MSBI Developer

Responsibilities:

• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Optimized queries by using Execution Plan for better tuning of teh database.
• Involved in complete SSIS life cycle (creating, building, deploying and executing teh packages in different environments.
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server and Flat files. Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Applying business logic and data cleaning in staging server to maintain child and parent relationship.
• Used different transformation controls like Look up, Conditional split, data conversion, un-pivot, Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command and etc.
• Created package configurations for dynamic connection string to enhance teh ease of package deployment. Implemented Event Handlers and Error Handling in SSIS packages.
• Involved in Dimensional modeling by identifying teh fact and dimension tables based on teh user and reporting requirements.
• Developed SSAS cubes wif multiple fact measures and multiple dimension hierarchies based on teh OLAP reporting needs.
• Involved in building Data Marts and multi-dimensional models like Star and Snowflake Schema.
• Defined Schemas, i.e. relationships between Measure groups and Dimensions in SSAS.
• Calculated measures and dimension members using multi-dimensional expression (MDX).
• Defined Key Performance Indicator metrics to create scorecards.
• Understanding teh OLAP processing for changing and maintaining teh Warehouse, Optimizing Dimensions, Hierarchies and adding teh Aggregations to teh Cube.
• DevelopedDrill Down, Drill through, Cross tab reports, Parameterized Reports and Report Modelsfor generatingAd-Hocreports as per teh client requirements.
• Involved in scheduling, creating snapshots and subscriptions for teh reports using SSRS 2012.

Environment: SQL Server 2012 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office SharePoint Server, XML, MS Visual Source Safe.

Confidential, San Francisco, CA

Sr. SSIS Developer

Responsibilities:

• Involved in teh Installation and Configuration of SQL SERVER 2008 wif latest service packs.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins, Temp tables for applications.
• Created and modified various Stored Procedures used in teh application using T-SQL.
• Migrated DTS packages from SQL Server 2005 to SQL Server 2008 asSSISPackages.
• Created ETL packages wif different data sources (SQL Server, Flat Files, Excel files, XML files) and loaded data into destination by performing different kinds of transformations using SSIS packages.
• Used various Data Flow Transformations like Lookup, Lookup Plus, Union All, Multicast, Cache Transform, and Conditional Split while developing teh packages by implementing rules provided by Business in teh mapping document.
• Build efficientSSISpackages for processing fact and dimension tables wif complex transforms and type 1 and type 2 changes using teh TF Dimension Merge Slowly Changing Dimension.
• Identified teh potential Issues dat occur during teh package execution by redirecting teh rows from source component to Error Output by TF Error Output Description (Task Factory Tool).
• Identifying teh mapping issues and discussing them wif business analysts in team.
• Handled teh database components (Code migration, Change control) for application releases.
• Developed teh packages wif monitoring features and logging so dat information of teh packages and their execution results are loaded into teh designed error table.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.

Environment: SQL Server 2008/2005, Windows Server 2003, SSIS, SSAS, SSRS and TFS, ProClarity/PPS, EDW, ODS

Confidential, San Francisco, CA

ETL/MSBI Developer

Responsibilities:

• Involved in complete SDLC life cycle.
• Understand user requirements and Data Model designed and developed by teh business analysts and data architects.
• Created complex Stored Procedures, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing teh performance of teh databases.
• Maintained teh physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Created ETL process usingSSISto transfer data from heterogeneous data sources.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package usingSSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Responsible for Deploying, Scheduling Jobs, Alerting and MaintainingSSISpackages.
• Extract, Transform and Load source data into respective target tables to build required data marts.
• Developed SSAS Cubes, partitions, aggregation from scratch wif Star Schema.
• Responsible for gathering business requirements to create business user reports.
• Created SSRS Reports on teh top of teh cube using some MDX queries.
• Responsible for scheduling teh subscription reports wif teh subscription report wizard.
• Performed unit and system testing, troubleshooting and bug fixing in Prod and QA environments.

Environment: Windows Server 2003, SQL Server 2008/2005, SSIS, SSAS, SSRS, ProClarity/PPS, EDW, ODS

Confidential

Jr. SQL Server Developer

Responsibilities:

• Installation of MS SQL enterprise servers on test and development boxes.
• Designed and Created databases, tables, views, stored procedures and triggers.
• Optimizing Database Queries for performance enhancements, Writing T-SQL Views and triggers.
• Worked to tune teh SQL queries using SQL Profiler.
• Monitored and scheduled existing/new jobs on production environment.
• Tested backup and recovery strategies in a test environment before and after moved to production environment.

Environment: Windows Server 2003, SQL Server 2005, BI studio 2005, Microsoft windows XP