SUMMARY

• Over 6 years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2000/2005/2008 R2/2012, SSIS, SSRS and SSAS.
• Experience in creating different types of reports using Power BI, Tableau, and crystal reports.
• Experience in exploratory data analysis (EDA) using R language.
• Experience in Installing, Upgrading and Configuring Microsoft SQL Server.
• Experience in Migrating data from SQL Server 2008 to SQL Server 2012.
• Participated all stages in SDLC to facilitate efficient software development and testing.
• Extensive experience working in various domains like Financial, Banking and health care Sectors.
• Experience in designing and creating Tables, Views, User Created Data Types, Indexes, Stored Procedures, Cursors, Triggers and more
• Expertise in designing and scheduling complex SSIS packages for transferring data from multiple data sources to SQLServer
• Knowledge in analyzing Data warehouse by building and deploying cubes using SQL Server Analysis Services (SSAS)
• Experience in generating OLAP cubes, Star schemas and MDX queries in SSAS
• Excellent Knowledge in generating reports like matrix parameterized and drill through reports using SSRS and developed stored procedures using functions to generate various using SQL Server Reporting Services (SSRS).
• Experience in creating different types of DAX queries for Power BI
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
• Skilled Confidential assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.
• Excellent analytical and logical programming skills with a good understanding Confidential the conceptual level and possess excellent presentation skills with a strong desire to achieve specified goals

TECHNICAL SKILLS

Languages: T - SQL, SQL, HTML, R, Python

SQL Server Tools: Enterprise Manager, SQL Profiler, SSRS, SSIS, SSAS, Business Intelligence Development Studio

RDBMSSQL Server: 2000/20

Applications: Microsoft Word, Microsoft Excel, PowerPoint, Access, R studio, Visual Studio 2013, Amazon AWS, Redshift

Reporting Tools: MS Office 2003/2007, SQL Server Reporting Services, Crystal Reports, Power BI, Tableau.

PROFESSIONAL EXPERIENCE

Confidential, Bellevue, WA

SQL Developer/DBA

Responsibilities:

• Gatheird and analyzed reporting requirements for the sales and marketing departments.
• Created complex SQL queries, stored procedures, functions, triggers, joins and SSIS packages.
• DevelopedSSIS 2012 Packagesto migrate data from Oracle, Access, flat files, and Excel into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations.
• Performed complex SSIS ETL operations to validate, cleanse, transform and load data to data warehouses.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Worked with SSIS Variables, Scripting, event-handlers, package configurations and deployment.
• Designed OLAP Cubes for analysis in SSAS
• Created star schema and snow flex schemas for better analysis in SSAS.
• Experience in MDX queries for creating different measure group tables in SSAS
• Developed Stored Procedures for parameterized, drill-down, and drill-through reports in SSRS.
• Formatted reports using Global Variables, Expressions, and Functions for the reports.
• Designed and developeddifferent type of reports including:Tabular forms, Matrix (crosstab report) form, Conditional, List items, Charts, Sub reports and Drill down reports.
• Createdcomplex expressions, calculations, sorting, filteringto enhance data presentationin reports.
• Createdinsert, update, and deletetriggers on some tables to capture anyDML activitieshappening on somecrucial and confidential data.
• Created graphical reports using Power BI, Tableau, and MicroStrategy Analysis
• Experience in DAX queries for Data Analysis Expressions in Power BI
• Uploaded reports on to the report manager and organized them into folders.
• Automate and enhance daily administrative tasks, including space management, object alteration, backup, recovery, and performance monitoring.

Environment: MS SQL Server 2008 and 2012, Windows Server 2008, SSIS, SSAS,SSRS, Power BI, T-SQL, ETL, MS Access, XML, Excel, Visual Studio 2008, Visual Studio 2012, MS office 2007, Outlook.

Confidential, Dallas, TX

SQL/BI Developer

Responsibilities:

• Interacted with functional and technical leads, other business users to conduct meetings with business representatives for gathering the Finance Team’s Reports / Dashboards business requirements.
• Developed Logical and physical data model and mapped the data into database objects.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• 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, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Create OLAP cubes, star schemas, snow flex schemas for analysis in SSAS
• Experience in MDX queries in SSAS
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Used MicroStrategy to analyses the data and generated reports.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using Power BI.
• Experience in DAX queries for Data Analysis Expressions in Power BI.
• Problem identification, troubleshooting, resolution, and index tuning databases.
• Taking Database Full Backup, Transaction log backup & differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.

Environment: SSIS, SSAS,SSRS, AWS, Redshift,EC2, MS SQL Server 2005/ 2008, Visual studio 2008, MS Access, MS Excel, Outlook, Power BI.

Confidential, Oklahoma

SQL Server SSIS/SSRS, Power BI Developer

Responsibilities:

• Support the Debt Collection Application specifically application related Payment Imports and skip tracing of the consumer address information.
• Responsible for creating Summary reports, Sub reports, Drill Down reports, Matrix reports.
• Developed Stored Procedures for parameterized, drill-down, and drill-through reports in SSRS.
• Formatted reports using Global Variables, Expressions, and Functions for the reports.
• Created different graphical reports using DAX queries for better stimulation of data in Power BI.
• Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily Confidential the server.
• Assess detailed specifications against design requirements.
• Responsibilities taken as a production support Developer for applications as on needed basis.
• Knowledge of financial instruments such as making payments to the account after splitting them to the accounts based on the commission rates and the bucket levels.

Environment: SQL Server 2000/2005 Enterprise Edition, SQL Enterprise manager, MS PowerPoint, MS Access 2000 & Windows 2003/2000 platform, DTS, SSIS, SSRS, Power BI.

Confidential

SQL Server SSIS/SSRS Developer

Responsibilities:

• CreatedDatabaseTables, Views, and Functions and developedprocedures for implementing application functionality Confidential the database side for performance improvement
• Wrote complex SQL queries usingall kinds ofjoins, sub queries to retrieve data from the database
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
• Extensively worked on error handling Confidential different levels of SSIS packages like control flow level and data flow level.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all.
• Deployed the created SSIS packages in Development and Testing environments
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS)
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS)
• Involved in Installation, configuration and setting of Database servers for various test and development environments including SSRS Installation configuration and administration
• Interacted with end users and customers and act as functional analyst /development member with various cross functional teams
• Gatheird requirements and design of data warehouse and data mart entities
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables

Environment: SQL Server 2008 R2/ 2012, Oracle, MS Access, MS Visual Studio, SSRS, SSIS, T-SQL, MS Excel.