SUMMARY:

• Over 7+ years of extensive experience working with BI (SSRS, SSIS, and SSAS) and T - SQL using SQL Server 2000/2005/2008 R2/2012 .

TECHNICAL SKILLS:

Databases: SQL Server 2012/2008R2, 2005 & 2000/7.0, MS-Access 2000, Oracle 11g/10/9i, DB2

Database: Tools SSMS, BIDS/Visual Studio, TOAD

SQL Server Tools: SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, DTS, SSIS, SSAS, SSRS, Database Tuning Advisor, Congo s 10 BI tools (Report Studio, Analysis Studio, Query Studio, Congo s Connection), SQL* Plus

Languages: C, C++, VB.NET, C#.NET, JAVA, PHP, UNIX, SQL, T-SQL, PL/SQL, MDX, DAX, COBOL

RDBMS: SQL Server 2000/2005/2008 R2/2012, Oracle 11g/10/9i

IDE: Visual Studio 2003/2005/2008 R2/2012

OS: Windows 2003 Enterprise, Windows 2000 Datacenter, Windows NT & XP

Other Tools: Erwin/Power Designer (Data Modeling), Visio, Visual SourceSafe, MS Office suite, Quality Control(QC)

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Methodologies: Agile, Waterfall, Scrum, SDLC.

PROFESSIONAL EXPERIENCE:

Confidential

SQL Server BI /SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Experience in using SSRS gateway service calls to and from SSRS reports.
• Experience in modifying SSRS rdl (XML) which is the primary role of SSRS gateway.
• Created SSRS report templates for ease of report development.
• Created daily, weekly, monthly, quarterly, semi- annual and annual SSRS reports for Military commanders.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly, and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2012 using SSIS.
• Created list reports & cross tab reports using congas 10.1
• Extensive experience on Structuring Metadata and Congo’s Models using Framework Manager.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Generated Complex reports in Congo’s 10.1 report studio including Drill Down reports from DMR modeled Frame work model.
• Deployed different SSIS packages on test and production servers.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Upgraded existing packages developed using SSIS 2012 to SSIS 2008 packages.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2000/2005/2008 /2012) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2012 using SSIS.
• Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Created visualization dashboards for more than a dozen online reports helping clients identify opportunities to sell more advertising.
• Implementing Dashboards and Score Cards using Microsoft Performance Point Server and integrated with share point
• Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas.
• Writing various Stored Procedures, Triggers, Functions, and Views based on the functionality requirements for various teams and also to load data from the OLTP database .
• Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.
• Worked with Recently Introduced Power BI to create Self-Service BI capabilities and use tabular models
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Created a cube using multiple dimensions and modified the Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.
• Wrote MDX queries and expressions for use in Front End BI Applications.
• Created KPI Objects in line with Requirement Docs and Optimized cubes for better query performance.
• Created reports from cubes by writing MDX queries.
• Worked extensively on Dashboards to create the reports as per the client requirements. Used session and repository variables to control access and data. Used filters to restrict data.
• Create ad-hoc SQL queries for customer reports, executive management reports
• Created Reports, Report model Definitions, Scorecards, KPIs, and Dashboards utilizing Performance Point Server 2007/SharePoint Server

Environment: SQL Server 2012, SSIS (2012/2008), SSRS (2012/2008), Maestro Jobs, Visual Studio 2010/2013, MS Excel 2010, Congo’s 8.2/3/4 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Congo’s Connection), VB.Net, ASP.Net, C#, Power Designer.

SQL BI Developer/ETL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Experience in writing Stored Procedures, Views, and Functions in SQL using Oracle SQL Developer for data to SSRS reports.
• Create new SSIS Packages to export flat file for customer.
• Created and executed SSIS packages to populate data from the various data sources for different data loading operations for many applications.
• Gathered functional and non-functional client requirements in order to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
• Worked closely with visual design team to select the appropriate visualizations for BI deliverables.
• Created various complex Reports such as Tablix reports for static columns and matrix report types for dynamic pivot columns using SQL Server Reporting Services 2012/2008 using Oracle 11g as the data source.
• Created and designed solutions that use the SSRS gateway to interface between SSRS and a web front end (ideally flex) reports to make minimize the report execution time and to limit the no of records required.
• Designed and developed the reports as per the requirements in Congo’s 8.2.
• Published the Cubes to Congo’s 8 Analysis Studio using Framework Manager.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
• Experience in using SSRS gateway service calls to and from SSRS reports.
• Experience in modifying SSRS rdl (XML) which is the primary role of SSRS gateway.
• Worked closely with the business users in defining and documenting reporting requirements in order to design, develop and maintained in SSRS 2008 R2.
• Comfortable mentoring others in my team for complex SSRS reports.
• Data Transformation Activities using DTS Import/ Export for transferring data between different databases like Oracle.
• Created Power View Reports using the Tabular SSAS models in Excel 2010 and 2012.
• Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.
• Worked with Recently Introduced Power BI to create Self-Service BI capabilities and use tabular models
• Wrote MDX queries and expressions for use in Front End BI Applications.
• Created KPI Objects in line with Requirement Docs and Optimized cubes for better query performance.
• Created reports from cubes by writing MDX queries.
• Design new DTS packages as per needs, Resolve the problems.
• Migrated data from different environments to SQL Server 2008 R2 via SSIS and also applied conversion and transformation procedures according to business requirements.

Environment: SQL Server 2008, Business Intelligence Development Studio, SSRS 2008 R2, SSIS 2008 R2, VB.Net, ASP.Net, Congo’s 8.2, Congo’s Framework Manager, MS Visual Studio 2008

SQL Server Developer |SSRS|SSIS | T-SQL

Responsibilities:

• Used Workforce Central Management 6.1 version tied the SQL Database to the workforce management by using SSMS and verified the created 120 SSRS reports from user perspective to make sure right amount of data is processed.
• Developed the reports using stored procedures by adding variables such as Language translation and Time zone by considering different scenarios according to business requirement and Executed to get the required output.
• Worked on RDL‘s of the reports and promoted those RDL’S to WFC portal.
• Troubleshoot SSIS Packages and convert to SSRS Reports .
• Responsible for Debugging reports using Stored Procedures.
• Created Cross-Tab, Drill-down, Drill-through, Parameterized and Sub-Report using RDL.
• Promoted RDLs to Reporting Service Server.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Evaluate current reporting infrastructure to find bottlenecks and recommend improvements.
• Responsible for creating/migrating undocumented crystal/SSRS reports .
• Created and modified efficient Stored Procedure and functions which implement necessary business logic to support the front end application to facilitate pulling data.
• Developed and optimized stored procedures using input, output, table valued parameters and Query Analyzer .
• Create new SSIS Packages to export flat file for customer.
• Created and executed SSIS packages to populate data from the various data sources for different data loading operations for many applications.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created package to transfer data between OLTP and OLAP databases.
• Assisted front-end C#.NET and ASP.NET developers using Visual Studio 2008 (C#, ASP.NET).

Environment: SQL Server 2008, BIDS, SSIS, SSRS, Crystal Reports XI, Visual Studio, T-SQL, C#.NET, ASP.NET

MS SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Scheduled the packages to run automatically for incremental data and deploy them to their destination servers
• Developed tables, Views, Stored Procedures, Functions, Indexes, and Triggers using SQL Server Management Studio.
• Understanding the OLAP processing for changing and maintaining the data warehouse, optimizing dimensions, hierarchies and adding aggregations to the cube.
• Deployed SSIS package into production environment and used package configuration to export various package properties to make package environment independent.
• Developed SQL scripts to insert, update and delete data in MSSQL database tables in OLTP environment.
• Worked in extracting transforming and loading (ETL) data across multiple databases using SSIS packages.
• Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Improved data load performance by analyzing database design and query plans.
• Deployed and uploaded the SSRS reports to Report Manager & SharePoint server for the end users and involved in enhancements and modifications.
• Performed changes in the schema of the proposed database as required and informed those changes to the application development team.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Created and Configured OLAP cubes (star schema and Snow flake schema) using SQL Server 2008 Analysis Services (SSAS).
• Documented different stages of data transformation, procedures and scripts.
• Optimized the query performance with modification in T-SQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, establishing necessary joins, creating useful clustered index and non-clustered indexes.

Environment: SQL Server 2005(Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), Crystal Reports 8.0, XML, ASP.Net, VB Script.

MS SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Involved in the support the specific needs of hedge funds, fund-of-funds and private equity funds and registered investment products.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Created Project Expense Statements in all Data marts and other Financial Reports using SSRS.
• Developed yearly and quarterly company expense reports.
• Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.
• Actively supported business users for change requests.
• Responsible for creating the reports basing on the requirements using SSRS.
• Identified the database tables for defining the queries for the reports.
• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Defined the report layout.
• Developed SSIS solution for developing a fully-fledged data warehouse solution
• Developed, monitored and deployed SSIS packages.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports.
• Identified and added the report parameters.
• Formatted the reports using the Global variables and expressions.
• Administered and enhanced SQL Server Integration Services (SSIS) data loads
• Deployed the generated reports on to the server.
• Maintained data integrity by performing validation checks.
• Optimized queries, tuned and monitored server performance.
• Created views as per design needs.

Environment: MS SQL Server 2005, MS SQL Reporting Services 2005, MS SQL Server Analysis Services 2005, MS SQL Server Integration Services 2005

SQL Developer

Responsibilities:

• Actively involved in Normalization & De-normalization of database.
• Installed and Configured SQL Server 2000 on servers for designing and testing. Designed DDL and DML for MS SQL Server 2000/2005.
• Using SQL Server Integration Services (SSIS) to populate data from various data sources Developed web based front-end screens using MS FrontPage, HTML and Java Script. Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimized query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Created scripts for tables, stored procedures, and DTS and SSIS, writing T-SQL statements for retrieval of data and Involved in performance tuning of TSQL.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Create joins and sub-queries for complex queries involving multiple tables.
• Used DML for writing triggers, stored procedures, and data manipulation.
• Taking Database Full Backup, Transaction log backup & differential backup in daily routine.
• Monitor production Server Activity.
• Worked with DTS packages to load the massaged data into Data warehousing system. Tuned the SQL queries using SQL profiler and involved in tuning the database.
• Very pro-actively identifying the problems before user complaints.

Environment: Windows 2003 server, SQL Server 2000/2005, SSIS, FrontPage, IIS 5.0

MS SQL Server Developer

Responsibilities:

• Responsible for creating the reports based on the requirements using SSRS 2005.
• Identified the database tables for defining the queries for the reports.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Defined report layouts.
• Identified and defined the Datasets for report generation.
• Wrote queries for drill down reports.
• Identified and included report parameters
• Created scripts for tables, stored procedures, and DTS and SSIS, writing T-SQL statements for retrieval of data and Involved in performance tuning of TSQL.
• Formatted the reports using Global variables and expressions.
• Deployed generated reports on to the server.
• Maintained data integrity by performing validation checks.
• Optimized queries tuned and monitored server performance.
• Created T- SQL queries for data retrieval.
• Fine-tuned the database objects and server to ensure efficient data retrieval.
• Created views as per design needs.
• Created and modified stored procedures.
• Created other database objects like tables, views and indexes.

Environment: MS SQL Server, MS SQL Reporting Services, MS SQL Server Analysis Services, MS SQL Server Integration Services