SUMMARY:

• Around 9 years of IT Experience with SQL server Developer, Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2012/2008/2005, SSIS, SSAS and SSRS
• Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2012/20 .
• Experienced in client requirement Analysis, Physical, Logical design, development, Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2012/20, DTS, SSIS, SSAS and SSRS.
• Expert in TSQL DDL/DML , perform most of the SQL Server Enterprise Manager and Management Studio functionality using T - SQL Scripts.
• Experience in writing complex SQL queries involving multiple tables Inner and Outer Joins.
• Experience in optimizing the queries by creating various clustered, non-clustered Indexes and Indexed Views.
• Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools (Star Schema, Data-Warehouses, OLAP cubes, Partitioning and Aggregations), ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services (SSAS), Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting.
• Expert in designing reports using SQL Server Reporting Services (SSRS) based on OLAP cubes.
• Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence in SSRS.
• Experience in developing Custom Reports and different types of Tabular, Matrix and Distributed reports into multiple formats with SQL Server Reporting Services (SSRS).
• Expert in enhancing the reports visually by adding the visual elements including charts, graphs, gauges and maps to SSRS reports.
• Experience in creating SSIS packages based on multiple data source including SQL Server, Flat File, Excel and MS SQL Server.
• Experience in data migrating between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Designed SSIS package to extract appropriate records and output them to DM Warehouse.
• Experience in developing scripts in SSIS to synchronize stored procedures, email output and log messages.
• Designing and maintaining data management and data processing solutions using SSIS, includes Error Handling and Slowly Changing Dimensions.
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages in SQL Server.
• Expertise in Developing and Extending SSAS Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Experience in normalize and de-normalize data in the process of building database and reporting.
• Familiar with process of testing, troubleshooting and debugging on each unit of work, including jobs, SSIS package, SSRS reports and SSAS cubes.
• Expert in migration of databases from older versions of SQL Server 2008 to SQL Server 2012.
• Extensive database programming Experience in developing complex T-SQL queries including Stored procedures, User Defined Functions, Triggers, Views, Temporary Tables Constraints and Indexes using various DDL and DML commands.
• Excellent Experience in monitoring SQL Server Performance tuning in SQL Server2008/2012 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.
• Worked Extensively on ETL process using SSIS package.
• Perform XML validations.
• Designed the front end of the application using Python, Java, HTML, CSS, AJAX, JSON and jQuery. Worked on backend of the application, mainly using Active Records.
• Use TDM tools to search, catalog and vend test data
• Excellent in Data Extraction, Transforming and Loading ( ETL) using SQL Server Integration Services (SSIS), DTS .
• Expertise in testing ETL Processes, Reporting, Financial Processes and Web Services
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Perform Data Profiling and Data Analysis on large volumes of Data.
• Used Tableau to visually analyze data and create concise and actionable dashboards
• Experienced in Database Testing and Automation
• Expertise in defining the business process flow and gathering Business Requirements.

TECHNICAL SKILLS:

Programming Skills: C, Java, TSQL, PL/SQL, .NET Framework

Web Technologies: HTML, CSS, XML, Java Script, Ajax, jQuery

Database: SQL Server 2012/2008/2005, Oracle

Management Tools: SQL Server Management Studio, SQL Server Query Analyzer, SQL Profiler, SQL Server Enterprise Manager, Import & Export Wizard

Development Tools: Visual Studio .NET 2012/2010, SSIS, SSAS, SSRS, DTS

Web Servers: IIS 7.0, Apache Tomcat, Web Sphere

Reporting Tools: ERWIN, Tableau, Crystal Reports, QlikView

Operating Systems: Server 2012/2008, Windows 97/XP/Vista/7/8/10, UNIX/LINUX

Bug Tracking: Bugzilla

PROFESSIONAL EXPERIENCE:

Confidential, Greenville, SC

Senior MSBI Developer

Responsibilities:

• Developed Logical and physical data model using ERWIN 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.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• 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.
• 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 .
• Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS .
• Worked with different methods of logging in SSIS.
• Experience in creating Table Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services2008 and SSRS 2012.
• Designed the front end of the application using Python, Java, HTML, CSS, AJAX, JSON and jQuery. Worked on backend of the application, mainly using Active Records.
• Built the SSRS reports from Different Databases like Oracle, Hyperion and SQL Server.
• Developed web sites using Django , Python , XHTML, CSS, and JavaScript.
• Tested and implemented applications built using Python.
• Developed and tested many features for dashboard using Python, ROBOT framework, Bootstrap, CSS, and JavaScript.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• 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 SQL Server Reporting services ( SSRS).
• 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.
• Diagnosing and tuning the server optimal performance using SQL Server 2008 SQL Profiler and Database Engine Tuning Wizards.

Environment: SSIS, SSRS, Python, MS SQL Server 2012/2008, C#, Visual studio 2008, MS Access, MS Excel, MS Office Access 2007.

Confidential

Senior MSBI Developer

Responsibilities:

• Designed and created various business reports using SSRS 2012 versions
• Created reports with stored procedures and involved in scheduling, creating snapshots and subscriptions for the reports in SSRS.
• Formatted reports according to End user needs.
• Created a wide variety of reports using report builder.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.
• Created reports using Excel and Microsoft Office 360.
• 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.
• Designed and developed matrix and tabular reports with drill down, drill through and drop-down menu option using SSRS.
• 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 SQL Server Reporting services (SSRS).
• 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.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Created several SSIS packages to load data from different sources like SQL server database.
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle, etc.) and loaded the data into the target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created SSIS packages using various control flow tasks like for each loop, File system task, Execute SQL task and Dataflow task etc.
• Developed web sites using Django, Python, XHTML, CSS, and JavaScript.
• Tested and implemented applications built using Python.
• Developed and tested many features for dashboard using Python, ROBOT framework, Bootstrap, CSS, and JavaScript.
• 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.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Loaded the data into database tables using SQL*loader from text and excel files.
• Developed data model, SQL Coding, SQL Query tuning process and Schemas.
• Developed SQL Scripts, Packages and Procedures for Business rules check to implement business rules.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
• Scheduled the jobs to run daily, weekly, monthly as per requirement.
• Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors using 2012 SSMS Versions.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2008) and stored the data into the intermediate Staging Database using the SSIS ETL tool.
• Design and create report models based on user requirements, explain and train users to use report builder to generate their own personalized reports.
• Wrote T-SQL code to extract data which answered business questions.

Environment: SQL Server 2012, Python, Visual Studio 2012,2010, SSRS, report builder, T-SQL, Windows Server, SQL Reporting services, ASP.Net, MS Access.

Confidential

MSBI Developer

Responsibilities:

• Worked on the file import framework process for the various flat files structures to get data imported into our database.
• Created the Stored Procedures, tables, Views depending upon the project requirement.
• Experience in monitoring SQL Server Performance tuning in SQL Server 2008R2/2012 using SQL Profiler, Query Analyzer.
• Extensively used VB Script to pass multiple parameters for Stored Procedures to read and write database table. Generated ASP.net objects from tables and presented these DOM objects which are capable for easy communication, to the Business applications.
• Created the deployment scripts after the development is done for every project.
• Automated the SSIS Packages using the SQL Server Agent Jobs.
• Troubleshooting the SSIS/SQL job Agent whenever necessary.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Have deployed packages on different servers by configuring it.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Used SQL server SSIS tools to build high performance data integration solutions including Extraction, Transformation and Load packages for data warehousing. Extracted data from the XML file and loaded it into the database
• Constructed cubes based on data volumes mostly adhering to Star Schema.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling for OLTP and dimensional modeling for OLAP.
• Involved in performance tuning and monitoring of T-SQL blocks.
• Used custom .NET assemblies for Script Task in SSIS
• Imported the various files provide by the clients into the relational database systems.
• Used the BCP to load the large volumes of data from files into tables.
• Worked with Business Analysts and Users to understand the requirement.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc., to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.
• Documentation for all kinds of reports and SSIS packages.
• Used Visual Source Safe as Version Control Tool.

Environment: SQL Server 2012, SQL Server Business Intelligence Development Studio 2012, SSIS, SSAS, SSRS, T-SQL, EXCEL, Performance Point Server, T-SQL, C#, Visual Source Safe, SQL prompt.

Confidential

SQL Server Developer (SSAS/SSIS/SSRS)

Responsibilities:

• Involved in building cubes from scratch using Microsoft SQL Server Analysis Services (SSAS) 2008R 2/2008/2012/2014
• Create dimensions and members based on the business requirements and modify them accordingly whenever change control documents are updated.
• Developed SSIS packages to run daily jobs in the control system and ran extracts using BCP process.
• Created various ETL processes to modify the configuration files and ran batch files to run the extract files and load data into cubes.
• Designed Pivot table, drill through and many other complex reports using SSRS 2008R2, 2012, 2014 for client to check the final data for reporting.
• Involved in writing scripts in Teradata to export the source data into SQL database. Created many calculated measures using MDX scripting in SSAS.
• Involved in writing complex stored procedures, creating views, triggers, Joins, Constraints, DDL, DML and functions based on the requirement.
• Involved in upgrading of SQL server 2008R2 to 2012 and Visual Studio . Created usage based and normal aggregations for the cube to improve the performance.
• Used SQL Profiler to monitor the performance of queries, which are causing deadlocks and made performance tuning to the databases by removing historic query list.
• Designed pivot charts and provided links from spreadsheet to the database through excel for client to connect to the database to view the reports and select required data.
• Modified data flow tasks in SSIS Packages to configure them with new bill cycles or any new change requests and add them to the loop containers.
• Worked on automating daily jobs, monthly jobs and scheduling them in Control system. Configured error messages of daily loads through SSIS packages and sent them manually sometimes when the notification or processing is done through BCP.
• Involved in moving the fast export extract from Teradata as a source to SQL server database destination tables and views.
• Created hierarchies, partitions and base measures in cube as per client requirements. Majorly responsible for development and management of SSAS and SSIS projects
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2008, MS SQL Server- 2014/2012/2010/2008 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Performance Point Sever, Office-2010, MS Excel, C#.NET, Teradata SQL Assistant 14.10, JEdit 5.0, Putty 0.60.0.0, Business Intelligence Development Studio 2014/2012/2008.

Confidential

MSBI Developer

Responsibilities:

• Installation and configuration of SQL Server 2008 R2.
• Managing of database objects like Tables, views, indexes etc.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Developed DTS Packages to transfer the data between SQL Server and other database and files.
• Well experienced with tools like Query Analyzer, SQL utility.
• Implementation of data transfer through DTS and setting guidelines to automate recovery scenarios.
• Creation and management of Database maintenance plan for various database consistency checks.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
• Automation and execution of data transformation scripts.
• Used SQL Loader as an ETL tool to load data into the Staging Tables
• Used DTS packages as an ETL tool for migrating data from the SQL Server 2000 to Oracle 10g
• Improved the performance of the application by rewriting the SQL queries
• Worked on various levels of SDLC (Software Development Life Cycle) including system analysis, high level design, coding and testing.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
• Optimized SQL queries for improved performance and availability.
• Designed, analyzed and upgraded databases.
• Developed Transact-SQL scripts to enforce business rules.

Environment: MS SQL Server 2008, Windows 2008, MS Access, T-SQL, DTS, VB 8.0.

Confidential

Jr. SQL Developer

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.
• Provided database security by using role base authorization on accessing data.
• Used System tables and stored procedures to retrieve metadata.
• Administered the database using SQL Server Enterprise Manager.
• Performed troubleshooting operations on the production servers.
• Monitored SQL Server jobs, and developed queries to perform database operations.
• Developed user friendly GUI using HTML and ASP.NET to display and access data.
• Implemented database programming by using the ADO.NET object Model.

Environment: SQL Server 2005, DTS Package, SQL Server Enterprise Manager, SQL Server Query Analyzer.