PROFESSIONAL SUMMARY:

• Over 8 years of extensive work experience as a SQL Server Developer and in depth proficient experience in OLTP, Operational Data Source (ODS), Dimension Modeling, Data warehouse, OLAP and Database technologies.
• Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS and SSAS.
• Extensive experience in developing Stored Procedures, Views, Triggers, XML and Complex Queries on SQL Server 2000/2005/2008 .
• Over 2 years extensive reporting experience using SSRS and Crystal Reports, MS Reporting Services and MS ACCESS.
• Experience in utilizing ETL tools, including SSIS, DTS and Data Stage and ETL Package design.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Proven ability in utilizing ETL tools including SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and ETL package design.
• Experience in SSAS (SQL Server Analysis Services) in SQL 2005 and SQL Server 2008
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2005 Analysis Services.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Strong experience in various top ranked vendor BI specific tools such as Tableau& MS BI.
• Strong skills with Business Intelligence application stack including Tableau Desktop/Tableau Server/Tableau Public/SSIS/SSAS/SSRS, Performance Point Server, multi - dimensional cube building, OLAP/MOLAP and have the solid experience in data warehousing/BI environments.
• Worked with Microsoft Power BI, Datazen, DAX expressions, Power View and Power Query integrated with Share Point.
• Expert in Data Visualization and Data Analyzation, Mobile dashboard creation and implementation using PowerBI
• Set-up Enterprise Gateway and SSAS Connector on Azure VM for POWER BI Report Deployments
• Generation of Dashboards with Quick filters, calculated Fields, Groups, Parameters and Sets to handle views more efficiently in Tableau.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Performed Data Cleaning, Data Validation, and Data Analysis using data analysis expressions (DAX).
• Experience in Data Modelling (Logical and Physical Design of Databases), Normalization and building.

TECHNICAL SKILLS:

Tools: SQL Server Management Studio 2012, Enterprise Manager, Query Analyzer, SQL Server Profiler, Data Base Engine Tuning Advisor, Oracle 9i Data Transformation Services, Tableau, Visual Studio 2012, Red gate, Source Control, Team Foundation Server and JIRA.

Data warehousing: Business Intelligence Tools: Parallel Data ware House (PDW), SQL Server 2012/20, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SSMS, DTSX Packages, MDX Queries, ETL, Performance Point Server, OLAP, OLTP, and Visual Studio,Tableau and Power BI Tools.

Database Design Tools: Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inman Methodologies, MSX, MS Access, MS Project, ProClarity, Oracle 10g/9i/8i

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Sr. SQL/BI Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Create reports using SSRS for the Internal team
• Created Full backup’s, Differential backup’s, Transactional Log back up’s
• Created Maintenance Plans. (All User DB backup, Remove Old back up’s).
• Created Replication of databases on a different server.
• Have done Restores of databases using Full backups and Differential backups.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Performance tuning, query optimization and execution plan of queries for better performance.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
• Migrated Data from Post Gre SQL and Oracle Databases to MS SQL 2008 and Bulk data migration using SSIS from flat files.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS/DTS using various features like data conversion etc.
• Created report models and deployed on report server.
• Designed and implemented several complex reports and administration modules
• Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.
• Designed SSAS cube to hold summary data for Target dashboards. Developed Cube with Star Schema.
• Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Created derived columns from the present columns for the given requirements.
• Migrated DTS packages to SSIS using DTS Exchange.

Environment: MSSQL Server 2012/2008/2005 , Visual Studio 2008/2005. BI tools - Reporting Services (SSRS 2000/2005/2008 ), Business Intelligence Development Studio (BIDS), Crystal Reports, Office 2007, MS Access, ETL, MS Excel, TFS (Team Foundation Server 2010), SQL Server Integration Services (SSIS), Source Control, Red Gate tool etc.

Confidential, Madison, WI

Sr. SQL Data Warehouse Developer

Responsibilities:

• Installed and Configured SQL Server 2012 along with SQL Server Business Intelligence Development Studio in new server
• Gathered business requirements for creating the new mission-critical databases from business analyst, project manager, other internal employees as well as customer feedbacks.
• Collaborate on the global data architecture design and planning for the physical structure and implementation of data warehouses and data marts.
• Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation and impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize by following the Normalization standards to maintain data consistency and by performing data validation.
• Migration of all the databases from old servers to new server. Loaded stored procedures and user defined functions into the databases.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services to overcome transformation constraints.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups.
• Involved in Data Staging includes importing data, parsing, scrubbing by using SSIS tools.
• Migrated DTS packages to SQL Server Integration Services and modified the existing packages by using the advanced features and tools (pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate)
• Extracted, cleaned and validated from XML file into database using SSIS task (XML source).
• Used Query Analyzer to optimize SQL Queries and shortened lengthy queries.
• Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2012 database and performed tuning on it.
• Support and enhance a financial and enterprise Data Warehouse with OLAP reporting functionality.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.

Environment: Windows 2010, MS SQL Server 2012, ETL, SSIS, T-SQL, Microsoft Visual Studio.Net 2012 and VB.Net

Confidential, San Francisco, CA

SSIS/SSRS/SSAS Developer

Responsibilities:

• Implemented Complex Logging in SSIS Packages.
• Used various transformations in SSIS like Lookup, Fuzzy grouping, Row count Transformations.
• Played role in design of scalable, reusable, and low maintenance ETL templates.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 slowly changing dimensions.
• Created SSIS packages and used Analysis Services processing task to update the cube with current data.
• Created SSIS/DTS packages for Finance application that would transfer data among servers and perform other data transformations; scheduled the same SSIS packages by creating the corresponding job tasks.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2008 .
• Generated parameterized/Drilldown reports using SSRS and Crystal Reports .
• Created Report Snapshots to improve the performance of SSRS .
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services.
• Identified the dimension, fact tables and designed the data warehouse using star schema
• Used Script Logic Quest Lite Speed dramatically to reduce storage costs by quickly compressing data up to 95%.
• Migration of an MS Access application to SQL Server 2012.
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
• Constructed SSAS Cubes based on data volumes mostly adhering to Star Schema.
• Created Perspectives of the cube to simplify the process of browsing for the end users.
• Used MDX to create calculated members in the cube.
• Used to support the data processing engine in database intensive operations like query
• Performance tuning, parallel query algorithm, data mining by writing stored Procedures.

Environment: MS SQL Server 2012/2010, Windows 2010, SSIS, SSRS, SQL Server, Management Studio, SQL Server Business Intelligence Studio,MSIIS, MDX,SAP BPC,MS Access 2003/2005,VB.NET,C#, SQL Profiler, Sybase, COBOL, Oracle 9i.

Confidential, Chicago, IL

SSIS/SSRS Developer

Responsibilities:

• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Performed cost benefit analysis of different ETL packages (SSIS) to determine the optimal process.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Used the SSIS Import/Export, migrated the Heterogeneous Database such as Oracle and Access database, flat files to SQL server 2008.
• Applied conditional formatting in SSRS to highlight key areas in the report data
• Used Report Builder to do Ad-hoc Reporting.
• Created report links to refer other reports in a particular report.
• Resolved any deadlocks issues with the Databases/Servers on a real-time basis.
• In-Depth working knowledge of ODBC.
• Created multiple hierarchical aggregates for faster performance.
• Installed SQL server 2000 on Windows 20003 servers and involved in Physical and logical Database Design using Erwin tool.
• Created database objects like tables, users, roles, stored procedures, triggers.
• Worked on solving issues by doing data recovery in existing database.
• Used various formatting techniques like interactive sorting, grouping to created user friendly reports.

Environment: SQL Server 2005, Windows 2000/2003,MS Access 2000/2003,T-SQL, SQL LiteSpeed, Windows 2000 Advanced Server, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services, Oracle 9i.

Confidential

SQL Server Developer

Responsibilities:

• Coded the SQL Server stored procedures for the enhancements.
• Tuning and optimization of the stored procedures.
• Created databases, tables, relationships, constraints. Wrote SQL Queries, views, Stored Procedures for the interaction of transferring data to and from screens to the backend, at optimum performance.
• Enhancement involved implementation of SQL Server with the usage of Stored Procedures, SQL Execution Statistics / Plans, Optimizer and SQL Profiler for back end.
• Planning & organizing the work structure, configuration, risk and delivery management.
• Administered various applications like Maintenance Management and Financial Account System.
• Maintained the client's policies and customer databases and tuning of the database instances.
• Worked with all database objects, including tables, clusters, indexes, views, and procedures.
• Troubleshoot problems concerned with the databases, applications, and development tools.
• Created new databases for users as required. Checking the alert logs daily for oracle errors.
• Tuning of I/O to reduce disk contention by distributing I/O.
• Data modeling, normalization, de-normalization, physical database design, and relational models.
• Creating and maintaining roles and profiles for security and limited access of data. Design and implementation of Backup & Recovery strategies.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Creation of logins and user ids and setting up privileges and procedures for protection of data. Designed screens and reports layout.

Environment: MSSQL Server 2008/2005, Visual Studio 2005,Windows 2005,, Business Intelligence Development Studio (BIDS), VB,C#, Office 2007, MS Access, MS Excel.