Technical Summary:

• 7 Yrs of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2012/2008 R2/2005/2000 in Development, Test and Production Environments with various business domains like Finance, HealthCare, Banking.
• Migration of SSRS reports from SQL 2005 to SQL 2008 and SQL 2008 to SQL 2012.
• Developing reports on SSAS SSRS on SQL Server 2005/2008/2008R2 . Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
• Experienced in integrating different Microsoft BackOffice Components such as SharePoint and IIS with MS SQL Server.
• ETL implementation using SQL Server Integration Services SSIS in OLTP and Data warehouse Environment.
• Working Experience on slowly changing dimensions and creating SSIS packages using Active X scripts with Error Handling.
• Created complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008 and Transformation
• Used MDX to interact with the back end OLAP Services.
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Extensive experience with data modeling techniques, logical and physical database design.
• Expert Knowledge of Integration Services SSIS , Reporting Services SSRS and Analysis Services SSAS .
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to 2005/2008
• Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server SSAS .
• Expert ETL design.
• Expertise in migrating data from MS-Access, MS-EXCEL and other external data sources.
• Experience in Creation and deployment of cubes on SSAS.
• Good understanding in Oracle9i/10g Database.
• Experience in creating Jobs, Alerts, SQL Mail Agent, scheduling DTS/SSIS Packages and Backup/Restore of a database
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Experience in Tuning SQL queries and T-SQL queries, MDX improving the performance of the queries.
• Worked Extensively on ETL process using SSIS package.
• Expert in Database Normalization, designing and creating Indexes, planning and implementing Server Security and authentication, Develop Queries and T-SQL Scripts in MS SQL 2012/2008/2005/2000.
• Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins, stored procedures.
• Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi site development.

TECHNICAL SKILLS

Work Summary

Confidential

Sr.BI Developer

Responsibilities:

• Created SQL Server Reports based on the requirements using SSRS 2012.
• Involved in migration of SQL Server 2005 to 2008R2/2012.
• Identified and documented all the reports, tables subject areas and ETL for each Business units.
• Documented the current and Gap Analysis across all the business units for ETL, Reports and Data.
• Identified the underline reports tables which are touching non- replicated tables.
• Create Naming standards and Data dictionary for EDW Phase.
• Create the EDW server with project plan
• Create Data mart/ Dashboard/ KPI server with project plan.
• Participated in the Software Development Life Cycle SDLC processes including Analysis, Design, Programming, Testing and Deployment.
• Extensively used all features of MS SQL Server 2008 R2/2008/2005 as a SQL Developer.
• Created Cubes with Dimensions and Facts and calculating measures and dimension members using Multidimensional expression MDX .
• Upgrade enhancements, maintenance, production support and bug fixes for the project and the data models.
• Created SQL objects like Tables, Stored Procedures, Functions, and User Defined Data-Types.
• 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.
• Developed ETL jobs to load information into Data Warehouse from different relational databases and flat files.
• Generated different reports using MS SQL Reporting Services and Crystal Reports.
• Created various Tabular and Matrix Reports using SSRS.
• Created reports to retrieve data using Stored Procedures that accept parameters. And also converted various Stored Procedure based reports into SSRS based reports to improve the efficiency and flexibility of reports
• Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Strong Experience in developing reports using Query Studio Report Studio.
• Designed and developed customized Cognos reports for the client: Impromptu, Power Play Cube, Ad-hoc and Cognos queries using Cognos 7.4 Reporting platform.
• Schedule, Monitor and control Access of users by creating groups in Cognos Connection
• Worked on for loading data from source to destination.
• Extract Transform and Load ETL source data into respective target tables to build the required data marts.
• Created Stored Procedures, used complex queries involving join and union of multiple designing and developing Data Warehouses, Data marts and Business Intelligence.
• Worked with SSRS to generate reports like Drill Down and scheduled SSIS Packages.
• Involved in using Informatica transformations tables.
• Created SSIS packages to Extract and Load data from diverse source flat file, excel, xml and oracle
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Wrote optimized T-SQL Stored Procedure to improve performance, preserve referential integrity and provide application functionality.

Environment: SQL Server 2012/2008 R2/2005 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2008/2003, Oracle 9i, Crystal Reports, Performance Point Server 2007, vb6.0, Informatica, Excel, XML,.NET,Cognos 8.4/8.2, Framework Manager, Cognos Connection.

Confidential

Sr.BI Developer

Responsibilities:

• Efficiently helped in the Software Development Life Cycle SDLC processes including Analysis, Design, Programming, Testing and Deployment.
• Installation and configuration of SQL Server 2008 R2/2005.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Functions, User Defined Data-Types, Rules, And Defaults.
• Upgrade enhancements, maintenance, production support and bug fixes for the project and the data models.
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• cDeployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Built ad-hoc reports using SQL Server Reporting Services SSRS .
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using Sql Server Reporting Services 2008 R2.
• Involved in Migration of SSRS 2005 to SSRS 2008 R2.
• Good understanding of Data Marts, Data warehousing, OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.
• Using SQL server reporting services SSRS delivering enterprise, Web-enabled reporting to create reports that draw content from a variety of data sources.
• Designing and implementing a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services SSAS .
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Designed and developed packages for data warehouse using Integration services SSIS SQL Server 2005/2008.
• Used Informatica for ETL process.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Installed and configured Cognos 8 BI products, tuning and testing.
• Designed, developed and modified Cognos reports using Cognos Report Studio and Query Studio.
• Collaborated with Cognos defined best practices for reporting architecture to evolve enterprise products.
• Defined and enhanced the Cognos reporting architecture.

Environment: MS SQL Server 2008, T-SQL, SSRS, SSAS, SSIS Packages, SSRS, MDX, ETL, Erwin, Informatica, ASP.Net 3.0, Ado.Net 3.0, C .Net, Excel, MDX, OLAP, OLTP, Access, Windows 2003 Server.Cognos 8.3, FrameWork Manager, Transformer, Cognos Connection, ReportStudio, QueryStudio,vb6.0

Confidential

SQL/BI Developer

Responsibilities:

• Installation and configuration of SQL Server Reporting Services SSRS 2008.
• Created Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Adhoc reports through Report Builder.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports. SSRS 2005/2008 .
• Involved in creating report models and applying row level security filters for report model.
• Build the Dimensions, cubes with star schema using SQL Server Analysis Services SSAS .
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Extract Transform Load ETL development using SQL Server 2005, SQL 2008 Integration Services SSIS .
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling
• Installed and configured Cognos 8 BI products, tuning and testing.
• Designed, developed and modified Cognos reports using Cognos Report Studio and Query Studio. .
• Experience in moving the data from heterogeneous data sources like oracle, xml etc to sql using SSIS.
• Created subscriptions in SSRS to deliver reports to a shared file.
• Implemented logical and physical modeling using ERWIN data modeler
• Reports using SQL Server Reporting Services 2008
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Involved in migration of crystal reports to SSRS 2008.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Advanced extensible reporting skills using SQL Server 2005 Reporting Services SSRS .
• Played a major role in the production support of SSAS cubes and SSIS jobs.
• Developing the User-interface Front-end screens in .Net 3.5 environment using C .Net, Asp.Net, JavaScript ,HTML and DHTML

Environment: SQL Server 2005/2008 Enterprise Edition, .Net 3.5,SQL BI Suite SSAS, SSIS, SSRS , ProClarity Server , Crystal Reports, XML, MS PowerPoint, MS Access 2003 UNIX, Shell Scripting, Oracle.

Confidential

SQL Developer

Responsibilities:

• Developed the Functional specification documentation for the modules to be developed.
• Worked with SQL and PL/SQL to create Tables, Views, and triggers and stored Procedures.
• Created various database objects tables, indexes, views, stored procedures and triggers and implemented referential integrity constraints for enforcing data integrity and business rules
• Responsible for tuning T-SQL procedures, triggers and other database objects.
• Fine tuned and checked the performance of existing objects in SQL Server and implemented transactional logic for them
• Designed and developed DTS packages for transferring data from flat files and Access files
• Created linked servers between different SQL Servers and also created linked server with different access files used across various departments
• Created complex reports in Crystal Reports using procedures from SQL Server by passing in stored procedure parameters
• Responsible for SQL Server 2000 database development, database modeling, database program, database administrator
• Performed DBA tasks through Enterprise Manager, Query Analyzer, English Query, Import Export wizard
• Involved in designing and writing Stored Procedures, functions and packages using T-SQL for SQL Server 2000.
• Maintain and implement the database using SQL Server 2000 back-end tools and DTS.
• Design, develop and administer the E-Work platform website
• Involved in complete SDLC, which includes requirement gathering, analysis, design, development, Implementation,
• Upgrade enhancements, maintenance, production support and bug fixing for the product.

Environment:T-SQL, SQL Server 2000, OLAP Services, Windows 2000 Server, Query Analyzer, DTS,MS Access 2000, Oracle, VB.net 2003, Erwin Data Modeler.