SUMMARY:

• 7 years of IT experience in Analysis, Design, Implementation and Administration of Business Intelligence Solutions with Microsoft SQL Server 2012/2008/2008 R2with various business domains like Financial, Banking, and Insurance Sector
• Experience in MS SQL Server 2012/2008R2with Business Intelligence in SQL Server Reporting Service and SQL Server Integration Service
• Experience in designing Logical and Physical Modeling using Visio, ERWIN Tool and ER Studio.
• Experience in High Level Design of ETL - DTS Packages &SSIS Packages - for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Involved in migration of SSRS reports from SQL 2005 to SQL 2012/2008 and migration with DTS to SSIS 2012/2008
• Proficient in OLTP, OLAP and Data Warehousing Design concepts
• Skilled in Data warehousing tools, Data Mapping, Unit Testing, Migration Conversions and Process Documentation
• Experience in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL
• Experience in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2012/2008
• Experience in dimensional data modeling and Cube development, partition, aggregation and optimization using SSAS
• Building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2008/2012 Analysis Services Business Intelligence (SSAS, SSRS).
• Experience in advanced reporting skills using SQL Server reporting services (SSRS).
• Created & formatted Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP, Sub reports, adhoc reports, parameterized reports, interactive reports & custom reports
• Experience in providing SSRS server level, item level Security & Accessibility to various reports in multi-user environment
• Experience in developing reports using Microsoft SharePoint Server Enterprise Edition.
• Experience using Microsoft Visual Studio to develop .NET code.
• Experience with .NET in script task and components in SSIS.
• Created SSIS packages with script task using .NET code to perform business requirements which are not provided by default SSIS components
• Exposed to all phases of software development life cycle SDLC including in-depth knowledge of Agile methodology, Enterprise Reporting Life Cycle, SQL Server Migrations, Change control rules, problem management and escalation procedures
• Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes
• Experience on TFS (Team Foundation Server), Visual Source Safe.
• Experience in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration, also created Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), DataStage

Reporting Tools: SQL Server Reporting Services (2012/2008), Power Pivot, Power BI, Tableau, QlikView

Database: MS SQL Server 2012/2008, MS Access, Oracle 11g/10g/9i/8i, MySql, PostgreSql

Programming: T-SQL, PL-SQL, C, LINUX (Shell Scripting), .NET

Web Technologies: HTML, DHTML, Visual Studio.

Operating Systems: Windows, Unix, Linux, Mac OS

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), ERWIN, Adobe Photoshop, Abode Flash, Mac Office Suite, Rational Rose

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Sr.SQL BI Developer/SSAS/SSIS

Responsibilities:

• Designed a complex SSIS package for importing data from SQL Server 2012
• Use ETL to implement the slowly changing dimension Transformation, to maintain Historical Data in Data warehouse.
• Created packages in SSIS with error handling and event handling
• Worked with different methods of logging in SSIS like flat file, sql server table and event viewer
• Implemented data views and control tools for guarantee data transformation using SSIS.
• Used .NET code in script task to check whether a flat file is empty.
• Used Visual Studio to write the .NET code.
• Used various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Successfully deployed SSIS packages with defined security
• Developed logical database and converted into physical database using Erwin
• Proficiently created Reports based on the requirements using SSRS 2012
• Involved to write complex T-SQL queries and Stored Procedures for generating reports
• Defined parameters for parameterized Reports using SSRS
• Analysis and data analysis using SQL and Excel involving the product attributes Successfully brought new analysis tools to the company, like Power Pivot, which is an Excel add-in that allows a workbook to hold and process more data
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2012
• Successfully worked with Report Server and configured into SQL Server 2012
• Created Batch files to run the script in development, production environment
• Developed a multi-dimensional database and OLAP cube using SSAS that stored and maintained the data
• Extensively worked with OLAP cubes to generate drill through reports in SSRS
• Designed MDX queries in accessing cubes and hands-on experience in query structuring, performance optimization
• Responsible to monitor performance and optimize SQL queries for maximum efficiency
• Proficiently scheduled the Subscription Reports with the Subscription Report wizard
• Involved in the analysis, design, development, testing, deployment and user training of analytical and transactional reporting system
• Extensively worked on TFS (Team Foundation Server) for version control
• Used stored procedures, wrote new stored procedures and triggers, modified existing ones, and tuned them such that they perform well
• Tuned SQL queries using execution plans for better performance
• Optimized by assigning relative weights to the tables in the Catalog and Query Performance

Environment: MS SQL Server 2012/2008, SSAS 2008, SSIS 2008, SSRS 2008, T-SQL, TFS, Visual Studio 2012.

Confidential, CA

Sr. SQL BI Developer/SSAS/SSIS

Responsibilities:

• Extensively worked on Data Flow tasks like Foreach Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Used Text Files/ SQL Server Table Logging for all SSIS packages.
• Used Excel Power Pivot and Power view to build Scorecards and Dashboards.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Created On demand (Pull) and Event Based delivery (Push) of reports per the requirement.
• Used Microsoft Visual Studio to write .NET code.
• Used .NET code in script task to perform some business requirements when dealing with images.
• Deployed and configured the reports in the Report Server.
• Extracted Data from various Heterogeneous Databases such as Oracle and Access database, DB2, flat files to SQL server 2008R2 using SSIS.
• 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.
• Designed and developed Tabular models for the relational data using SSAS.
• Designed MDX queries in accessing Tabular models.
• Experience in creating Tableau.
• Worked with various SSIS packages which involve Transactions, Restartability and roll back techniques.
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• 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 the system more modular, secured and extensible.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application
• Used SQL Server Agent for scheduling jobs and alerts.
• Configuration and Deployment of all reports across various SDLC environments.
• Deployed the packages to production using XML package configuration.

Environment: SQL Server 2012/2008R2/2008, SSRS 2008, SSIS 2008, Power BI, Power Pivot, Tableau, DB2, Oracle 9i/10g, .NET, XML, XSLT, MS Office and Visual source safe, Visual Studio 2012.

Confidential, Boston, MA

Sr. ETL Engineer

Responsibilities:

• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Deployment
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle& Sybase)
• Experience in creating Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps).
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, execute package task
• Worked on SSIS transformations like Lookup, Fuzzy grouping, Merge, Union All, Data conversion, Multicast, Pivot &UnPivot
• Created packages in SSIS with error handling
• Worked with different methods of logging in SSIS
• Experience in creating complex SSIS packages using proper control and data flow elements
• Designed cubes with star schema using SQL Server Analysis Services (SSAS)
• Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model
• Querying and manipulating multidimensional cube data through MDX Scripting
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports
• Developed stored procedures and triggers to facilitate consistent data entry into the database
• Wrote stored procedures to generate account statements for different types of accounts
• Upgrade enhancements, maintenance, production support and bug fixes for the project

Environment: SQL Server 2008 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2008r2, Oracle 9i.

Confidential, Dallas, Texas

Sr. ETL Developer

Responsibilities:

• Worked with project lead and business users to understand business processes
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2008
• Worked with T-SQL to create Tables, View and stored Procedures
• Created triggers on DML actions for security purpose
• Worked with Scalar and Table Value User Defined Function as per business requirement
• Used complex query statements like sub queries, correlated queries, derived tables, CASE functions to insert the data depending on the criteria into the tables
• Encapsulated frequently used SQL Statements into stored procedures and reduced the execution time
• Wrote MergeStatement to handle insert, update and delete within single statement between source and destination table
• Scheduled jobs to call the packages and Stored Procedures as per business requirement
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle)
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS
• Created SSIS Packages to move the data from tab delimited flat flies into SQL database
• Made dynamic SSIS packages which did data scrubbing, including data validation
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them
• Developed Cascading, Drill-down Reports to get monthly card details and profits using SSRS 2008
• Deployed, configured and managed reports using Report Manager and Report Builder
• Created Cross-Tab and Sub-Report using RDL
• Promoted RDLs to Reporting Service Server
• Used Visual Source Safe (VSS) for version control.

Environment: Microsoft SQL Server 2008, SQL Server Integration Services tools (SSMS, BIDS and SQL Server Manager), SSRS, SSAS, Business Objects, Windows Server, MS Visio, Oracle, MS Excel.

Confidential, San Ramon, CA

SQL Server / BI Developer

Responsibilities:

• Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2008
• Filtered and cleansed dirty data from legacy system using complex T- SQL statements in staging area, and implemented various constraints and triggers for data consistency
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot and UnPivot Transformation
• Successfully migrated old data from legacy systems (FoxPro) and external system including excel and oracle into SQL Server 2008 using SSIS Packages
• Created scripts to verify and reconcile the migrated data from legacy system to SQL Server.
• Developed interface stored procedure to upload Insurance Record from XML format to Customer Insurance System
• Developed complex Stored Procedures to process prospective customer information and balanced the processing load between front end and back end
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Designed the Forms, templates & created Reports using SSRS 2008 reporting services.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Performed Unit testing for the screens and code in SQL Server 2008

Environment: SQL Server 2008, Oracle 9i, T-SQL, Excel, Access, Report Builder 3.0, Windows Server 2003, .NET, Query Analyzer, SQL Server Profiler, Erwin 7.3/MS Visio 2007

Confidential, CA

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Upgraded to latest version from SQL Server 7.0 to 2005.
• Developed User Defined Functions for giving Scores and views for the application
• 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
• Wrote various Stored Proceduresfor application development
• Tuned SQL statements (e.g.: using Indexes) and Stored Procedures
• Worked on replication of data (Transactional method used)
• Designed and implemented data access stored procedures and triggers for automating tasks
• 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
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder
• Formatted the reports using the Global variables and expressions
• Performed job scheduling and alerts
• Designed and implemented user log in and security
• Resolved any deadlocks issues with the databases/servers on a real-time basis

Environment: SQL Server 2005, SSIS 2005, Management Studio, DTS, Windows 2003/NT.