SUMMARY

• Excellent Communication and interpersonal skills, highly organized and efficient in multitasking environments; able to prioritize effectively to accomplish objectives with enthusiasm; able to coordinate tasks to finish projects with creativity and timeliness.
• About 8 Years of experience in IT with primary skills on the Analysis, Design, Development and Support of Client/Server application using Microsoft SQL Server 2014,2012, 2008, 2005, 2000 and BI suite.
• Experience in Database programming in writing T - SQL Stored Procedures, User Defined Data Types, Triggers, Constraints (Check, Unique, Primary Key, Foreign Key) Indexes and Batch Scripts using various DDL and DML commands, Views, Cursors.
• Experience in developing BI Solutions in SQL Server Services - Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS).
• Expertise in SQL Server Reporting Services (SSRS) with Report Designer (SSDT), Report management, Report delivery.
• Experienced in building Data Integration, Workflow Solutions and ETL - Extract, Transform, and Load solutions using SSIS.
• Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Experience in Scheduling Jobs and Alerts using SQL Server Agent.
• Experience in highly analytical & detailed reports that include Drill Down, Drill Through, Parameterized (Cascading parameters), linked and sub reports and filters, charts in SSRS 2012/2008.
• Experienced in Migration of Data from Excel, Flat file, Oracle to MS SQL Server using MS SQL Server DTS and SSIS.
• Experienced in Migrating DTS packages to Integration Services.
• Experienced in Data Warehouse Modeling with SSAS.
• Created Write back functionality in SSAS to write the data back into the cube to make changes to the data those changes return in to the cube.
• Developed Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS) projects.
• Expertise in SQL Server Analysis Services CUBE design, development and deploying.
• Exposure towards Power BI, knowledge of Visualization, power pivot, power query, power view.
• Built a Tabular Model cube from scratch data and by MDX queries fetched data to SSRS and Power BI reports.

TECHNICAL SKILLS

RDBMS: Microsoft SQL Server 2 /, Oracle 9i/10g, MS Access.

SQL Server Tools: SQL Service Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS), SQL Profiler, Query Analyzer, Export & Import.

IDE: Microsoft Visual Studio 2013/2012/ 2008.

ETL Tools: SSIS (SQL Server Integration Services), DTS (Data Transformation Services).

Reporting Tools: SQL Server Reporting Services (SSRS), Tableau, Power BI

Web Technologies: HTML, XML, CSS, PHP.

Other Tools: MS Access, MS Excel, MS Office Suite

Operating Systems: Windows 2000/XP/7/8, MS-DOS, Windows 2003/2008/2012 Server.

PROFESSIONAL EXPERIENCE

Senior SQL BI Developer

Confidential, OH

Responsibilities:

• Scope, plan and manage Business Intelligence application projects including Dashboard enhancements.
• Installed SQL Server 2012/2014 and all necessary tools in Development, Staging and Production environments.
• Upgraded SQL Server 2000 and 2005 to the SQL Server 2014 and troubleshoot the compatibility issues.
• Created all types of database objects like Tables, Views, Triggers, Stored Procedures, Indexes, and User Defined Functions according to Business logic.
• Responsible for Creating and Monitoring SQL Agent jobs and Scheduled Tasks on all environments.
• Created SSIS packages by using various Transformations, Containers to import and export data.
• Developed many Tabular Reports, Matrix Reports, Drill down Reports, and Dropdown Reports, Sub Reports, Bar Graph Reports, and Cascading Parameters Reports using SQL SSRS 2010/2012.
• Experience in creating Multidimensional cubes using SSAS and designing DW schemas.
• Converted complicated Crystal Reports to Standard SSRS reports by creating stored procedures and mapping parameters thus by enabling Business Users easy access to one stop Reporting Solution via SSRS.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Involved in lot of installations/upgrades/deployments of new/updated tools and applications.
• Documented all the procedures for Crystal Reports Conversions, SSRS Onboarding and other Application updates.
• Experience with on-site / off-shore coordination by attending daily sync-ups and ensuring the deadlines are met.
• Interactive data visualization products focused on Business Intelligence such as MICROSOFT POWER BI.
• Extract and analyze data using Power Query, PivotTables, MS Excel, POWER BI.
• Created relationships between tables in Power BI using Star and Snowflake schemas.
• Created Power BI Dashboards using different type of Slicers and different Visualizations like Bar Charts, Line Charts, Graphs, and Pie Charts etc.

Environment: Microsoft SQL Server 2005/2008/2014 , SSIS-2012, SSRS-2012, Power BI, Crystal Reports, Periscope Data

SQL BI Developer (SSIS, SSRS, SSAS)

Confidential, TX

Responsibilities:

• Involved in the life-cycle of the project, i.e., requirements gathering, design, development, testing and maintenance of the database.
• Setup new SQL Server instances.
• Developed SQL Server objects such as tables, materialized views, clustered and non-clustered indexes, stored procedures, cursors, triggers and constraints.
• Performed query optimization and tuning, debugging and maintenance of stored procedures.
• Used System tables and stored procedures to retrieve metadata.
• Created DTS packages to copy tables, schemas, views and to extract data from Excel using SSIS.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Worked on designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
• Worked on migrating some of the DTS packages in to SSIS.
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Developed reports using SSRS and Crystal reports. Used table control, matrix control for cross tab reports.
• Generated reports using the Reporting Services analyzed using Server analysis (SSAS).
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services.
• Creating multi-dimensional cubes using SSAS.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.

Environment: MS SQL Server 2005/08, SSIS 2005/08, SSRS 2005/08, Windows NT, UNIX, DTS Package, SQL Server Enterprise Manager, SQL Server Query Analyzer, Power BI.

SQL Server Developer (SSIS, SSRS, SSAS)

Confidential, Woodbury, MN

Responsibilities:

• Monitored testing servers for long running stored procedures, queries using profiler and recommended clustered and non-clustered indexes using DTA.
• Created DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS.
• Experience in mapping multiple related systems.
• Designed the system architecture that is used to structure, plan, and control the process of developing an information system
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Used BCP command line utility to replicate a database.
• Extensive experience in designing, creating and deploying SSIS packages for transferring data from flat files, excels spreadsheets and heterogeneous data to and from SQL Server.
• Used Erwin tool to visualize complex data structures, inventory information assets and establish enterprise-wide standards for managing data.
• Experience in migrating some of the DTS packages in to SSIS.
• Used Recompile and with option query hints to avoid parameter sniffing problems.
• Improved query performance by adding covered indexes, adding file groups.
• Creating and managing schema objects such as tables, views, joins, clusters, indexes, functions, procedures, triggers & maintaining Referential Integrity.
• Implemented SSIS data transformations scripts, created maintenance procedures and provided data integrity strategies.
• Developed reports using SSRS 2005 and Crystal reports. Used table control, matrix control for cross tab reports.
• Configured Reporting Services in SQL Server 2005.
• Created standard Reports and Cross Tab Reports and Drill Through reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Troubleshooting performance issues with Fragmentation using Profiler, System Monitor and DMV’s.
• Configured nodes and virtual server to set up Active/Active Clustering.
• Import Data from MS-Access Database and XML to SQL Server Database.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: SQL Server 2000/2005, Enterprise Edition, MS Access, SQL, Visual Studio 2008/2012, Enterprise manager, SSRS 2005, SSIS 2005.

SQL Server BI Developer/Analyst (SSIS, SSRS, SSAS)

Confidential, WA

Responsibilities:

• Created tables, temporary tables, table variables, indexes, procedures, views and triggers for automating various tasks in TSQL.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard and SQL Sentry plan explorer.
• Involved in database design of the project and integration with third party tools like Power Designer 15.
• Worked on internal project to develop a performance Data warehouse.
• Created SSIS Packages to generate flat file report for different customers based on the User requirement.
• Created SSIS Packages to load data to the Staging DB and from Staging DB to the Destination DB with necessary transformations to the data by using different tasks.
• Monitoring and Releasing reports in a timely manner to ensure the correct reports are reached to end users without data discrepancy.
• Designed and worked with cubes having star schema using SQL Server Analysis Services (SSAS).
• Developed Dimensions, Data source views, SSAS Cubes, deployed and processed SSAS objects, created SSAS storage and partitions and aggregations.
• Designed and deployed various complex reports using MS Reporting Services.
• Created Tabular reports, Cross Tab Reports, Matrix, Sub Reports and Parameterized reports.
• Analyzed reports and fixed bugs in stored procedures.
• Designed and implemented stored procedures and triggers for automating tasks.
• Fine-tuned SQL queries for maximum efficiency and performance.
• Configured the report viewing security for various users at various levels using Report Manager.
• Used SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Monitoring and Releasing reports in a timely manner to ensure the correct reports are reached to end users without data discrepancy.

Environment: Microsoft SQL Server 2012, SQL Server Reporting Services 2012 (SSRS), SQL Server Integration Services 2012 (SSIS), SQL Server Analysis Services 2012 (SSAS), Microsoft Excel 2010, Power Pivot, Team Foundation Server (TFS), Windows 2008.

MS-SQL Server Developer

Confidential - Lansing, MI

Responsibilities:

• Gather requirements and design of data warehouse and data mart entities·
• Built Data marts (Fact and Dimension tables) from the warehouse tables.
• Designed Multi-Dimensional models, DATA MART/ WAREHOUSES and SSAS cubes.
• Performs design/code reviews to make sure that the design/code adheres to customers’ standards and meets industry’s best practices
• Responsible for the data and metadata management and Business Intelligence (BI) solutions using Microsoft SQL Server 2005 Integration Services (SSIS), SQL Server Reporting Service (SSRS), and SQL Server Analysis Service (SSAS).
• Used SSIS (SQL Server Integration Services) for transformation of data in to staging tables and to extract data from database tables and write the data to text files.
• Deployed SSIS packages and Scheduled Jobs.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Designed OLAP Star and Snow-flake schemas and then Dimension and Fact Tables.
• Generated test cases to meet the functionalities deliverables in the project documentation and specifications.
• Developed and optimized Stored Procedures, Indexes, Views, Triggers (DDL & DML), Cursors and User Defined Functions.
• Ensure database integrity, indexing, segmentation and recovery and update database design over time.
• Performed DBA functions, installing, configuring and supporting SQL Server based database systems.

Environment: SQL Server 2000/2005 Enterprise Edition, Enterprise Manager, UML, MS Project, Windows 2003 Server, SSISSSRS, SSAS.

SQL Developer

Confidential

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects likeProcedures, Functions, Packages, Triggers, IndexesandViewsusingT-SQLinSQL Server 2005.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Created theDTSPackagethroughETLProcess to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Involved in the development of a normalized database using Data Definition Language (DDL) in T-SQL.
• Performed job scheduling in the SQL Server Environment.
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
• Modified database structures as directed by developers for test/develop environments and assist withcoding,designandperformance tuning.
• Managed user access. Created and managed new security accounts.
• Backupandrestoredatabases.
• Developed and implemented database and coding standards, involved in improving performance and maintainability of corporate databases.

Environment: SQL Server 2000/2005/2008 , T-SQL, DTS Designer, MS-Office, Ms-Excel, VSS

Programmer/ Analyst

Confidential

Responsibilities:

• Interacted with end users to gather Requirements, Created technical.
• Studied and designed the system.
• Install, Update, Configure and Maintain the MS SQL Server.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user define functions.
• T-SQL queries for the retrieval of the data.
• Created a report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filter reports.
• Tuning front-end applications like Visual Basic, which query the SQL Server databases.
• Used SQL Statements to Present Query responses.
• Imported data into Performance point server from SQL Database through csv files
• Consolidated data from OLTP databases in to OLAP using SSIS as ETL.
• Created parameterized stored procedures to implement business logic.
• Involved in the Data modeling, Physical and Logical Design of Database.
• Helped in integration of the front end with the SQL Server backend.
• Trouble shooting Problems by using SQL server profiler.
• Created the DTS interfaces to vendors in which records were loaded daily, also to other data resources such as Excel, Access, and flat file, XML to create and maintain a centralized data warehouse.
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS)
• Write T-SQL statements for retrieval of data.

Environment: SQL Server 2000/2005/2008 R2, T-SQL, UNIX, Microsoft Excel, Management Studio