PROFESSIONAL SUMMARY:

• 7+ Years of experience in IT, as MS SQL Server 2000/2005/2008 Developer with expertise in SSIS/SSRS/SSAS.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS 2008.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Proficient experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to 2005/2008.
• Experience in writing MDX queries to pull data from SSAS cubes.
• Experience in Building SSAS cubes with KPI’s, Actions, Calculations and Hierarchies.
• Experience in performance tuning SSAS cubes for faster retrieval of data.
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008.
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in Performance Tuning and Query Optimization.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Used Power Pivot in Excel 2010.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

Technical Skills:

• SQL Server Tools : Enterprise Manager, Profiler, Query Analyzer,Export & Import (DTS), SSIS, SSRS, SSAS.
• RDBMS : MS SQL Server 2000/2005/2008, MS Access.
• ETL Tools : DTS, SSIS, Data Stage.
• Languages : Transact SQL, C, Visual Basic 6.0, VB.Net, ASP.NET, HTML .
• Operating Systems :Windows2003/2008/NT, MS DOS.
• Reporting Tools : Crystal Reports 11,10,9, SSRS.
• Other tools : Microsoft Visual Studio 2005, Crystal Reports, ProClarity ODBC, and MS Office, Erwin4.0.

Professional Experience:

Client : Confidential, Fort Lauderdale, FL Oct '11- Till Date
Role : Sr.SQL Server BI Developer(SSIS/SSRS/SSAS)
Responsibilities:

• Worked with business users to understand business processes, gather and document project requirements and translate them into functional and technical specifications for BI reports and applications.
• Provided guidance and decision-making on client reporting needs oversee and participated in the development of the report technical designs as well as participate in the implementation of reports and testing activities.
• Worked under different departments such as Credits and Collections, Materials, Operations, Accounting, etc., and was a part of Supply chain management team.
• Extensively used Indexes, triggers and stored procedures with complex joins, temporary tables and Sub-Queries to simplify complex queries involving multiple tables.
• Used CTE’s, Analytical functions and Merge statements to write queries.
• Created SSRS reports using Sql Server 2008 and Cubes as data source.
• Created Parameterized reports, Cross-tab reports, Drill – down reports and drill –through reports using SSRS 2008.
• Created Subscriptions and Data Driven Subscriptions in SSRS 2008 to automate the report execution.
• Developed reports in SSRS 2008 R2 and deployed reports into SharePoint Server 2010 (MOSS)
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc
• Created SSIS process design and architecting the flow of data from various sources to target.
• Performed data conversions and source, destination mapping while loading data from different sources to Sql database using SSIS.
• Created SSIS packages using various data transformations like conditional split, Multi Cast, lookup,data conversion and derived column transformations.
• Created packages in SSIS with error handling using event handlers and implemented custom logging.
• Deployed the SSIS Packages from Dev/Staging/Production using SSIS Package Configurations.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Maintained data from different departments and implemented to show it in dashboard.
• Worked on SAP R/3 and Siebel CRM for extracting different reports which are used by database.Developed some queries in SAP R/3 to extract data.
• Performed some manual tasks which included reconciliation of sales orders and imported data from SAP R/3 with specified queries corresponding to their transactions.
• Validated data in dashboard against database. Performed some validations to show the discrepancies and managed to rectify discrepancies in data.
• Handled many issues with dashboard.
• Created and scheduled jobs to run on a daily and weekly basis including the maintenance of the jobs.
• Involved in taking backups and restoring of crucial databases involved in the business.
• Writing queries which involve various joins in order to perform a thorough analysis on the missing sales on a daily and cumulative basis.
• Involved in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Created report models using the report model designer to support Ad hoc reporting.
• Created and managed users, roles and groups to handle database security.
• Tuned database by creating proper indexes.

Environment: SQLServer 2008 R2, Business Intelligence Studio (SSAS, SSIS, SSRS), XML, SharePoint 2010, T SQL, MS Excel, MS Access, Birst (Dashboard), SAP R/3, Siebel CRM.

Client : Confidential, Dallas, TX July '10 – Sept '11
Role : Sr.SQL Server BI Developer(SSIS/SSRS/SSAS)
Responsibilities:

• Worked closely with business analysts to transform business requirements to Technical solutions for BI reports.
• Provided guidance and decision-making on client reporting needs oversee and participated in the development of the report technical designs as well as participate in the implementation of reports and testing activities.
• Used Team foundation Server 2005/2010 as a Source Control.
• Implemented various DDL,DML modifications and developed Scripts for generating Sql Objects.
• Developed complex SQL Scripts for various data manipulations and validations across ETL, Reporting and OLTP systems.
• Extensively used Indexes, triggers and stored procedures with complex joins, temporary tables and Sub-Queries to simplify complex queries involving multiple tables.
• Used CTE’s, Analytical functions and Merge statements to write queries.
• Involved in performance tuning of queries and Stored Procedures using Execution Plan.
• Created SSIS process design and architecting the flow of data from various sources to target.
• Performed data conversions and source, destination mapping while loading data from different sources to Sql database using SSIS.
• Created SSIS packages using various data transformations like conditional split, Multi Cast, lookup,data conversion and derived column transformations.
• Created packages in SSIS with error handling using event handlers and implemented custom logging.
• Designed Master-child packages to execute a package from another package.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Extensively involved in the SSAS storage, partitions, and Aggregations,
• Defined KPI’s, Calculations in SSAS 2008 using Muti dimension expressions(MDX).
• Understanding the OLAP processing for changing and maintaining the warehousing, optimizing Dimensions, Hierarchies and adding the Aggregations to the cube.
• Responsible for Processing the CUBE Partitions and Dimensions.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of Reports.
• Created reports with Conditional hiding and conditional formatting using Expressions in SSRS 2008
• Used Sub-reports, Table, Matrix , List and Chart data regions in SSRS 2008.
• Created Parameterized reports, drill- down and drill through reports using SSRS 2008.
• Create Report models using BIDS and used Report Builder 2.0/3.0 versions to generated reports from report models.
• Deployed reports to Both SSRS Report Manager and Share point 2010
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).

Environment: SQLServer 2008, Business Intelligence Studio (SSAS, SSIS, SSRS), XML, SharePoint 2007, T SQL, Erwin, MDX, Oracle 10g, ProClarity, MS Excel.

Client : Confidential, Lafayette, LA Apr'09 - June'10 Role :SQL Server BI Developer(SSRS/SSAS/SSIS) Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Experienced in Designing stylish report layout.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2005
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-hoc reports as per the client requirements.
• Converted reports from Crystal reports to SSRS 2008.
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS)
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created Sql table configurations and managed the connection strings dynamically in SSIS
• Developed Multi dimensional Objects (Cubes, Dimensions) using MS Analysis Services 2008(SSAS).
• Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse (ETL).
• Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment.
• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
• Experience in writing MDX queries to pull data from SSAS cubes.
• Managed the security of SSAS cubes and deployed from Dev/Staging/Production
• Coordinated with front-end for implementing logic in Stored Procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
• Experience in optimization of queries by looking at Execution Plan for better performance.

Environment: SQL Server 2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

Client: Confidential , Nashville , TN Feb '08 –Mar’09
Role: SQL Server Developer(SSIS/SSRS)
Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complexSSIS packages using proper control and data flow elements.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Wrote store procedures to generate account statements for different types of accounts
• Involved in migration of SSRS from SQL 2000 to SQL 2005
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 9i, Sybase.

Client: Confidential, Chicago, IL May'07-Jan'08
Role: MS SQL Server Developer(SSIS/SSRS) 
Responsibilities:

• Created SQL server objects like Indexes, Indexed Views, Stored Procedures (dynamic and static), effective Functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency
• Created Joins, Sub-Queries, Views and User Defined Functions for complex queries involving multiple tables and developed User Defined Functions
• Migrated DTS Packages of SQL Server 2000 to SQL Server 2005 as per Business requirements
• Used SSIS to create Dynamic ETL Packages to validate, extract, transform and load data to data warehouse databases and involved in Data cleansing in the data transfer
• Implemented Data Cleaning, Incremental Data Loading, Event Handling and Error Handling
• Developed Query for generating Drill Down and Drill Through reports in SSRS 2005
• Generated Tabular, Sub reports and Parameterized reports for the Business users
• Formatted the reports using the Global variables and expressions
• Maintained the client relationship by communicating the daily statuses and weekly statuses of the project
• Managed requests that came from the client as well as the development teams
• Involved in Design and Developed the Logical and Physical Model of the database
• Worked on Complex Data Loading (implemented the batch data cleansing and data loading)
• Creating and automating the regular Jobs
• Rebuilding Indexes and Tables as part of performance tuning exercise
• Managed the Backup and Recovery of the team

Environment: SQLServer2000/2005, MS Access, Query Analyzer, DTS, BCP, MS Access, SQL Profiler, Import & Export Data.

Client : Confidential Feb ’05 -May'07 
Role : SQL DEVELOPER
Responsibilities :

• Created and maintained database objects.
• Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Created various reports using MS Reporting Services 2000.
• Tuned complex SQL Queries.
• Loading data from various data sources using MS Data Transformation Services.
• Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general trouble shooting.
• Involved in various phases of SDLC.
• Analyzed the estimated execution plan of complex stored procedures and tune the badly or slowly performing queries to improve performance.
• Participated in report authoring, used conditional formatting to make the reports more user friendly.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Wrote and integrated stored procedures to generate the reports.
• Provided on-call support for various projects.

Environment:SQL Server 2000, MS Excel 2003, ASP.Net, VB.Net, MS Access 2003, MS SQL Query Analyzer, SQL Profiler, MS SQL Server Reporting Services.