Summary

• 8 years of IT experience in analysis, design, implementation administration of Business Intelligence solutions SSIS/SSRS/SSAS , Oracle OWB, Informatica, Cognos and SQL with MS T-SQL 2012/2008/2005 , Oracle 8i/9i, in development, testing production environment.
• Extensive experience in Requirement Analysis, Work flow analysis, Design, Development Implementation, Testing Deployment of complete software development life cycle SDLC in field of Desktop Applications, Microsoft web and client/server technologies.
• Exceptional versatility and adaptability, extremely diligent, strong team player with an ability to take new roles.
• Excellent communication and strong analytical skills.
• Expert database designer and fluent in all aspects of database development including, E-R modeling, Dimensional modeling, Star/Snowflake schema normalization and optimization using Kimball methodology.
• Strong concepts of Data Warehousing strategies for ETL, identifying metrics, dimensions, and implementing slowly changing dimension SCD etc.
• Extensive experiences in developing Stored Procedures, UDF, Views, CTE, Triggers, Cursors, and Complex Queries by SQL Server 2012/2008R/2008/2005, Oracle PL/SQL.
• Proficiency in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using SQL Profiler, Performance Monitor and DBCC Utilities.
• Good understanding in Database Backup, Recovery, investigating and applying necessary MS SQL Server Database Service packs, hot fixes and Security Patches
• Proficient in applying and setting up SQL Server Clustering Technology, Clustering Topologies Nodes and Database Mirroring
• Highly proficient in design and development of SQL Server Integration Services SSIS packages,
• Experienced in dynamic integration packages weather deploying with configuration catalog or file type configuring in SSIS 2012, Oracle OWB and Informatica.
• Successfully performed SCD transformation and deployed SSIS package with security.
• Hands on experience in cleaning and scrubbing of data with Lookup and Fuzzy Lookup, Logging, Error handling by using Event Handler, and Custom transformations.
• DTS applications moving data between different types of databases and legacy systems.
• Experienced in writing Scripts using C , VB.NET.
• Expertise in creating various type of reports such as Complex drill down drill through reports, parameterized reports, Matrix reports, Sub reports and Charts using SQL Reporting Services SSRS and Cognos based on Relational and OLAP databases.
• Hands on experience creating Report Server Manager with highly efficient assigned security level
• Highly proficient in scheduling Data Driven Subscription reports by e-mail delivery, file share or null value performance optimization.
• Extensive experience to work with OLAP cube in SSRS.
• Expert in dimensional data modeling, and cube development, partition, aggregation and optimization using SQL Server Analysis Services SSAS .
• Excellent command in deploying analysis projects using SQL Server Analysis services. SSAS
• Guided exploration around a business workflow analysis and action using Micro Strategy.
• Tested and debugged BI packages using standard tools such as, Qlikview and Teradata.

Technical Skills

MS SQL Server 2012/2008R/2008/2005, MS SQL Server Analysis and Reporting services 2010/2008/2005, MS Office 2010/2007/2003/XP/2000, Oracle 8i/9i,TalenD, DB2, C, C , C , VB, TOAD, T-SQL, ODBC, ADO.NET, RDO, DTS, MS Access-XP2000/97, ERWIN Platinum, MS Visio 2003, HTML, XML, ER-Designer, Informatica Power Center/Power Exchange, Cognos R10, MicroStrategy, Qlikview and Teradata.

Professional Experience

Confidential MS SQL/SSIS/SSRS/ BI Developer

Responsibilities:

• Involved in gathering user requirements, application design, analysis and testing debugging of hardware requirements to meet business needs.
• Responsible for creation of new database, and database objects like stored procedures, functions, cursors, tables, views, triggers, CTE, Cursors according business logics.
• Increased query performance, necessary for statistical reporting by more than 25 after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Worked on linked servers to run distributed queries between SQL server and other data sources like excel, Oracle using ODBC, OLE DB Drivers.
• Worked on Access to SQL database migration Project to implement data security.
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Used advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Responsible for the development of Dimensional models and staging area models from logical database into physical database using ERwin
• Developed a multi-dimensional database and OLAP cube using SSAS that stored and maintained the data.
• Created Data source, Data source views DSV's , cubes, dimensions, measures, measure groups, partition aggregations. Deploying and processing SSAS objects
• Extensively worked on Design and Strategy Projects to Design and develop SSIS ETL packages to validate, extract, transform and load data from multiple Sources like Oracle, Excel files, flat files to the SQL Server Data warehouse using different task and transformations like Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task and Send Mail task.
• Created Running SQL script to verify/validate data by using C
• Created SSIS package configuration using environment variables to make the packages dynamic.
• Created, Scheduled and maintained routine SSIS jobs, tasks, and alerts Daily/Weekly/Monthly basis for executing SSIS packages automatically without user interruption using SQL Server Agent.
• Implemented error handling of SSIS packages with event handler and configured Send Mail task to indicate the failure of task.
• Worked on SSIS Packages to stream SAP files from UTF-8 encoding version to Windows default encoding Version with script task C ,VB to make the SAP files compatible with Windows environment.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008 R2.
• Administered interface to organize reports and data sources with SQL parameters, schedule report execution and delivery in Report Server Manager, and track reporting history using SSRS
• Worked on creating versioning of data as the data changes, to create the snapshots of the data for reporting purposes using Data Driven Subscription Reports.
• Generated daily, weekly and monthly e-mail reports for the managers by Scheduled Subscription Reports.
• Used Team Foundation Server 2010 to source control, data collection, reporting, and project tracking Purpose.

Environment: SQL Server 2012, BIDS 2010, SSRS, SSIS, SSAS 2008 R2, Access 2010, T-SQL, Oracle 10g, SAP, Sharepoint, Windows XP, TFS 2010, ERWin.

Confidential MS SQL Server /SSIS/ETL BI Developer

Responsibilities:

• Developed complex SSIS packages to import the data from Excel sheets for cleaning and scrubbing of data using Lookup , Fuzzy Lookup, conditional split, for each loop, multi cast, data conversion, Derived column, fuzzy grouping, script components transformations to validate and transform the data from staging to data mart tables.
• Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Created SSIS packages to load Excel files into stage tables by using Bulk Copy Program BCP
• Implemented error handling in SSIS packages using precedence constraints in control flow and different event handlers like On Error, On Package Failure etc.
• Involved in package configuration to make the packages dynamic for successful execution of packages in development and production environment.
• Successfully deployed SSIS packages with defined security.
• Scheduled database jobs for automation of tasks using SQL Server Agent.
• Worked on performance tuning of SSIS Packages and SQL queries for maximum efficiency and performance using execution plans.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Responsible to monitor performance and optimize SQL queries for maximum efficiency.
• Wrote new stored procedures and triggers, modified existing ones, and tuned them such that they perform well.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the database and SSIS applications
• Developed and provided C insights into streamlining the business intelligence processes. Research, define and deployed BI packages.
• Increased query performance by 20 , which is necessary for statistical reporting after monitoring, tuning, and Optimizing Indexes by using Performance Monitor and SQL Profiler.
• Reduced and obliterated unnecessary joins and indexes
• Created ETL packages .dtsx files to validate, extract, transform and load data to Data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Designed Aggregations, created groups, KPIs, and pre-calculating measures, in SSAS.
• Involved in calculating measures and dimension members using multidimensional expression MDX , mathematical formulas, and user-defined functions.
• Designed MDX queries in accessing cubes and hands-on experience in query structuring, performance optimization.

Environment: MS SQL Server 2008R2, Access 2010, MS SQL Server Integration services 2008 SSIS ,Informatica, TalenD, Micro Strategy, XML, SSAS 2008, T-SQL, MS Visio, Windows XP.

Confidential MS SQL Server BI/SSRS Developer

Responsibilities:

• Gathered functional requirements and Business requirements and wrote the technical specifications for building the highly efficient system.
• Involved to write complex T-SQL queries and Stored Procedures within C scripts for generating reports
• Responsible for creation of new tables, views, and optimizing with triggers according business logics.
• Created Clustered, Non-Clustered Indexes and constraints to the frequently used tables in application.
• Administered SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Generated plan for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.
• Inserted XML file parameter in to the database tables using Qlikview services.
• Acted as point of contact for BBFB business reporting and systems with using Qlikview and Teradata.
• Defined report layouts and wrote queries for drill down reports and identified and included report parameters using SSRS.
• Developed complex reports and provided to business people for further analysis. Responsible for making changes in application according to business logic.
• Migrated various types of report from different sources like Cristal Reports into .rdl SSRS file type.
• Designed and developed new Service Management Reports based on the requirements, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2008.
• Proficiently scheduled the Subscription Reports with the Subscription Report wizard.
• Used MDX queries for pre calculated measures.
• Extensively worked with OLAP cubes to generate drill through reports in SSRS
• Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• Worked on linked servers to run distributed queries between SQL server and other data sources like excel using ODBC, OLE DB Drivers.
• Provided JAVA script support to the application developers on the WEB application platform.

Environment: MS SQL Server 2008R2/2005, MS SQL Server 2008 Reporting Service SSRS 2008,Analysis Services SSAS 2008, Business Intelligence and Development System 2008, ASP.Net 2005, C ,XML, T-SQL, MS Visio, Windows XP.