Summary:

• Over 8 years of IT Professiona experience in Development, Client Analysis, Database Design and Presentation using SQ Server 2005/2008/2008 R2/2012.
• Having IT experience on IBM Mainframe environment working in Development and maintenance applications.
• Expert in using tools like MS SQ Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQ Server performance.
• Expertise in Data Conversion, Normalization and Data Modeling, Multi-Dimensiona Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensiona schema using Erwin Tool.
• Strong experience in Stored Procedure, Formulated Stored Procedure/TSQ coding, Performance Tuning and Query Optimization.
• Conduct T-SQ Query performance tuning of T-SQ query by using SQ server tuning advisor and by analyzing execution plan.
• Highly proficient in the use of T-SQ for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relationa Database models, Data integrity, query writing and SQ joins.
• Highly experienced in Creating, Configuring and Fine-tuning ET workflows designed between Homogenous and Heterogeneous Systems using SSIS of MS SQ Server 2008R2, MS SQ Server 2008 and MS SQ Server 2005 respectively.
• Experienced in creating complex SSIS and DTS packages for ET purposes. Implemented complicated transformations to be used in SSIS packages.
• Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating dril down reports using MS SQ Server Reporting Services 2008R2/2008/2005 SSRS .
• Experienced with client server application where XM feeds were consumed and Store Procedures were called using ADO.NET
• Experienced in writing Parameterized Queries for generating Tabular reports and Sub reports using Globa variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008R2/2008/2005.
• Expertise in SQ Server Analysis Services SSAS to deliver online analytica processing OLAP and data mining functionality for business intelligence applications.
• Experienced with creating SSAS cubes and SSAS perspectives.
• Extensive knowledge in developing and implementing log-shipping, database mirroring and replications.
• Involved in index rebuilding and reorganization.
• Strong experience in ful backup, transactiona backup and differentia backup.
• Using SQ server agent to schedule jobs and alerts for SSIS, SSRS and administrative tasks.
• Monitor database using DBCC command, system catalog and DMF and DMV.
• Ability to handle multiple tasks and responsibilities independently as wel as a proactive team member.
• Excellent communication and inter-persona skills with ability to develop creative solutions for challenging client needs using agile methodologies.

Skillset:

MS SQ Server 2012/2008R2/2008/2005/2000/7, MS Access, SQL, Transact-SQ T-SQ , PL/SQL, C, C , XML, MS SQ Server Integration Service SSIS , MS SQ Server Analysis Services SSAS , MS SQ Server Reporting Service SSRS , SQ Profiler, SQ Query Analyzer, MS SQ Server Index Tuning Wizard, Visua Studio 2008/2005, DTS SQ Developer, ERWIN, Crysta Reports 8.5, BIDS, DTS, Import/Export Data, Bulk Insert, BCP, Enterprise Manager, Management Studio, Replication, SQ Agent, Oracle 10g/11g, SQ Developer, MS Visua Source Safe 6.0/8.0/2005, Visua Basic 6.0, T-SQL,PL/SQ ,HTML, CSS, XML, VB.Net.

Projects Summary:

Confidential

MS SQ Server BI Developer / SSRS/SSIS/

Responsibilities:

• Involved in planning, design, analysis, implementation and maintenance of SQ server database.
• Analyze technica and functiona design documentations to develop SSIS packages and SQL
• Server Stored Procedures, to transform and load extract legacy data based on business rules and
• Field leve mapping.
• Involved in designing ER diagrams and mapped the data into database objects.
• Executed data conversion ET packages and generated the appropriate execution reports.
• Developed stored procedures, views, and other objects required to transform, translate, retain
• Aggregate data for complex data conversion requirement
• Involved in transferring data from various data sources such as MS Excel, XML, Flat files, and CSV files into SQ server 2012.
• Designed many SSIS SQ server integration packages for migrating data using various
• Complex transformations such as derived column, lookup, and merge join.
• Scheduled the system and user database backups and restored them whenever necessary.
• Monitored SQ Server and tuned poor performing SQ scripts.
• In the SSIS packages used various contro flow tasks such as for each loop, sequentia container and bulk insert and execute SQ tasks.
• Extracted data from XM files and used various transformation techniques to cleanse the Data as per business requirement.
• Designed and maintained various types of reports using SSRS SQ server reporting services.
• Designed and implemented parameterized, drilldown and cascading reports using SSRS
• Involved in deploying reports to report manager and trouble shooting for any errors occurred in deployment.
• Designed partitions in Cubes on time for improvement in performance using SSAS.
• Created the structure of the mode and cube in SSAS and reviewed Cube with end user and changed the cube and documentation according to their requirements.
• Using DBCC for database maintenance, and database validation.
• Using SQ Server tuning advisor to analyze T-SQ and indexes.
• Replicated database objects to other server for developer purpose.
• Using SQ server agent to schedule jobs and alerts for SSIS packages.

Environment: Microsoft SQ Server 2012, MS Windows Server, SQ Server Analysis Service SSAS , SQ Server Integration Service SSIS , SQ Server Reporting Service SSRS , Visua Studio, T-SQL, XML, IIS 6.0/7.0, ERWIN, Visua Basic, ASP.Net.

Confidential

MS SQ Server BI Developer.

Responsibilities:

• Worked with business stakeholders, application developers, production teams and across functiona units to identify business needs and discuss solution options.
• Agile methodology was used throughout the project, Performed pivota role in planning and developing as wel as aligning with the assigned sprints.
• Developed and deployed SSIS packages for ET from OLTP and various sources to staging and staging to Data warehouse using Fore Each Loop Container, Execute Package task, Execute SQ Task, Sent Mai task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more. Performed ET mappings using MS SQ Server Integration Services.
• Wrote complex SQ queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Created/Updated database objects like tables, views, stored procedures, function, packages.
• Designed Change data capture to capture insert, update, and delete activity applied to SQ Server tables, and to make the details of the changes available in an easily
• Consumed relationa format.
• Rigorously tested and debugged the Stored Procedures and used Triggers to test the validity of the data after the insert, update or delete.
• Deployed reports on Report Server and SharePoint Server also scheduled reports using SSRS to generate al daily, weekly, monthly and quarterly reports including current status.
• Developed and delivered dynamic reporting solutions using MS SQ Server 2008 Reporting Services SSRS .
• Generated Dril down, Dril through, Matrix Reports, parameterized reports, cascading parameterized Reports using SSRS.
• Designed and developed monthly, quarterly and yearly reports at branch and company level.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues monitoring and tuning to ensure database optimization.
• Monitored the overal performance of the database to recommend and initiate actions to improve/optimize Performance.
• Used SQ Server Profiler to trace the slow running queries and the server activity.
• Monitored and tuned report performance by analyzing the execution plan of the report.
• Supported Production Environment with scheduling the packages and making the package dynamic with SQ Server Package Configuration.

Environment: Microsoft SQ Server 2005/2008R2 ,SQ Server Management Studio SSMS , SQ Server Business Intelligence Development Studio BIDS , SQ Server Reporting Services SSRS , SQ Server Integration Services SSIS , SQ Server Analysis Services SSAS , Oracle 10g/11g, Visua Studio 2008, C , ASP.NET, T-SQL, JAVA, XML, IIS 6.0/7.0, ERWIN.

Confidential

MS SQ Server BI Developer/SSIS/SSRS

Responsibilities:

• Created Star schema dimension modeling for the data mart using Visio and created dimension and fact tables based on the business requirement.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytica Cube or an Exce pivot table
• Designed SSIS packages to Extract data from different sources like SQ server 2012/2008R2,MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS .
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Cache Transform, Conditiona Split and Derived column etc.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQ Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Exce Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Developed SSIS packages using for each loop in Contro Flow to process al exce files within folder, File System Task to move file into Archive after processing and Execute SQ task to insert transaction log data into the SQ table
• Produced operationa reports in SSRS 2012/2008R2 i.e. drill-down, drill-through, dashboard and matrix reports.
• Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
• Converted manua reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2012/2008R2
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually
• Translated XM Input file data to another XM from consumed by UI.
• Developed functiona and technica documentation to assist in the design, development and/or maintenance of deliverables
• Created SSRS Data Mode projects using Microsoft Visua Studio 2010/2008 and using Report Builder for report server to create reports
• Responded to ad hoc requests and specia projects that require immediate attention while at the same time maintaining deadlines on existing requests.
• Developed and maintained system documentation, diagrams and flowcharts.
• Worked with project manager and technica leads for resolution of technica issues.
• Migrated data from Development to UAT servers and deployed packages to different servers.
• Configured the report server and generated the report models for user interactions

Environment: Microsoft SQ Server 2005/2008, SQ Server Business Intelligence Development Studio BIDS , SQ Server Reporting Services SSRS , SQ Server Integration Services SSIS , Oracle 10g, Visua Studio 2005, C , ASP.NET, T-SQL.

Confidential

MS-SQ Developer/Software Developer

Responsibilities:

• Worked closely with business unit s to understand key business drivers and then identify the individua business metrics and key measures that support them
• Designed and configured, including parameters, settings, metrics, data elements and objectives
• Worked with management to develop strategies to support company needs
• Resolved data conflicts and inappropriate use of data
• Wrote complex SQ queries using joins, stored procedures, used defined functions to verify the data from the database to generate reports based on the business requirement.
• Wrote SQ Stored Procedure for checking Insert and Update on particular tables and created Transactions and Error Handling in it.
• Utilized SSRS reports from different source formats and satisfying clients by representing reports and presentations
• Generated matrix reports, tabular, drill-down, drill-through, sub reports, chart reports, multi parameterized reports
• Created ad Hoc and parameterized various reports using SQ server 2008 reporting Services
• Implemented multiple grouping into severa reports using visibility and toggle options
• Administrated and scheduled mailing subscriptions on SSRS reporting server
• Developed dependent, dynamic menu objects to allow end-users selection and data filtering capabilities
• Structured conditiona formatting logic to contro components behavior and appearance
• Produced parameter driven, matrix, sub-reports and integrated report hyper-link functionality to access externa applications.
• Customized SQ queries to create RD Datasets and create SQ reports.
• Created Tabular and Matrix Reports with al aggregate functions and expressions
• Produced dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.
• Developed functiona and technica documentation to assist in the design, development and/or maintenance of deliverables
• Created SSRS Data Mode projects using Microsoft Visua Studio 2008 and using Report Builder for report server to facilitate Ad-hoc reporting by the business users

Hardware/Software: MS SQ Server 2008, MS Access, Query Analyzer, Toad, Enterprise manager SQ Profiler, MS Reporting Service, Windows 2003,Visua studio 2005, ASP.NET.

Confidential

MS SQ Server BI Developer

Responsibilities:

• Used SSIS and T-SQ stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used various SSIS tasks such as Conditiona Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Responsible for creating reports based on the requirements using SSRS 2005.
• Identified the database tables for defining queries to generate reports for analysis of data using SQ Server Reporting Services in Report Builder.
• Defined the report layout and identified Datasets for the report generation.
• Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
• Designed and created Report templates, bar graphs and pie charts based on the financia data.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Used VSS to store, run, view, edit and revert back to different versions of the design in case of a system crash.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Created jobs, Alerts, SQ Mai Agent, and schedule SSIS Packages.

Hardware/Software: MS SQ Server, SQ server Reporting Services 2005, SQ Analysis Server SSAS , VSS, Microsoft Visua Studio, SQ Server Management Studio, MS Excel, T-SQL, ERWIN, ASP.NET.