PROFESSIONAL SUMMARY:

• 7 years of IT experience which includes System Analysis and Design, Development Support of MSBI stack technologies including SSIS, SSRS and SQL Server
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle SDLC .
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services SSRS based on client requirement.
• Experience in Software Analysis, Design, Development, Testing, Implementation and Production, support of Client/Server and Web based applications.
• Experienced in RDBMS concepts, Creating Databases, DDL/DML Triggers, constructing normalized and de-normalized tables, user defined functions, complex and dynamic stored procedures, views, synonyms, cursors and Indexes.
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema in implementing Decision Support Systems.
• Experience in Optimizing the Database by creating various Clustered and Non-Clustered Indexes.
• Excellent in High Level Design of ETL DTS Packages SSIS Packages for integrating data using OLE DB connection from heterogeneous sources Excel, CSV, flat file, Text file by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Experience in creating reports using SSRS SQL Server Reporting Services .
• Knowledge of Server Components using .NET Framework and Visual Studio 2005.
• Created Parameterized reports, Sub reports and thorough knowledge of reporting server architecture. Table, chart and matrix reports .
• Highly motivated and adaptive with the ability to grasp things quickly and posses excellent interpersonal, technical and communicational skills.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.

TECHNICAL SKILLS:

• RDBMS
• SQL Server 2012/2008 R2 /2005/2000, Oracle 11g/10g/9i/8i and MS Access 2003/2000/97

• SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS , SQL Server Integration Services SSIS , Business Intelligence Development Studio BIDS , Visual Studio.

• SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio BIDS , Crystal Reports, Web Services, SOAP.

PROFESSIONAL EXPERIENCE:

Confidential Role: SQL BI Developer

Responsibilities:

• Using the technical specification and understanding the source system, designed and developed a Data ware house in SQL server with all the required Dimension and Fact tables with proper indexing, partitioning and file groups
• Extracting data from Oracle source and transforming, cleansing, validating and loading data into SQL server Destination
• Performed several T-SQL operations like Joins, Sub queries, stored procedures, functions, temporary tables, CTE's and performance tuning on complex queries
• Designed packages Using Control Flow Tasks like For Loop Container, Execute SQL Task, Script Task and Data Flow Tasks
• Extracted data from sources and transformed the data using different transformations like data conversion, derived columns, look up, Conditional Split, Aggregate, Union all, merge join and multi cast transformations.
• Created Event Handlers, precedence constraints and Data flow Error paths in Packages for Error Handling.
• Created Package Configurations and Environmental variables to pass the values dynamically to the variables in parent and child packages from outside and within the solution
• Maintained log information to track Errors and process flow to record package execution status
• Built and Deployed packages to SQL server using SSIS catalog and Scheduled Packages for Incremental data loading using SQL Server Agent
• Performed Unit Testing during and after development to ensure proper data loading with minimal issues during production movement
• Performed post deployment activities like monitoring and supporting the data loading process in production and fixing bugs
• Provided task level documentation of the entire process including development, deployment and scheduling activities

Environment: SQL Server 2012 Enterprise Edition, SSIS, T-SQL, SSRS, Windows Server 2003, Team Foundation Server, Visual Studio 2010 Ultimate TFS , Oracle 10g.

Confidential Role: SQL Server Developer/Analyst

Responsibilities:

• Gathered business requirements from users and translated them as technical specification for development.
• Identified various data sources, formulated data dictionaries, design and develop data models based on the given specs and requirements.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS.
• Expert in creating various type of reports such as Complex drill down and drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services SSRS based on Relational databases.
• 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 .
• Created ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Migration of stored procedures and database objects between development and test environments.
• Author concise functional/technical documentation and provide status and project updates using Visual Studio Team Foundation Server.
• Attend regular project meetings and weekly status meetings.

Environment: SQL Server 2008/2008R2 Enterprise Edition, SSIS, T-SQL, SSRS, Windows Server 2003, Team Foundation Server, Visual Studio 2010 Ultimate TFS .

Confidential

Role: SQL Server Developer/SSIS/SSRS

Responsibilities:

• Identified various data sources, formulated data dictionaries, design and develop data models physical/logical data models based on the given specs and requirements.
• Developed dashboard reports to populate data using SSRS
• Involved in automaton of payment history
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Involved in SSIS/DTS packages
• Collected business requirements from users and translated them as technical specs and design docs for development.
• Designed models using Framework Manager and deployed packages to the Report Net Servers.
• Created pages in the reports to display depend on Prompt values.
• Generated multiple Enterprise reports 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 Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.
• Bulk data migration using SSIS from flat files and xml.
• Developed Query for generating drill down reports in SSRS 2008 and Crystal Reports 9.0.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default queried and non queried parameters .
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Involved in accounting code module to populate general ledger code by writing complex T-SQL queries, stored procedures.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created different Parameterized Reports SSRS 2005/2008 which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports and etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.
• Environment: SQL Server 2008, DTS, SSIS, SSRS, Microsoft Visual Studio 2005, SQL Server OLAP 2005, Reporting Services 2005, T-SQL, MS Access, Windows 2003 Server.
• Confidential
• Role: SQL Server BI Developer
• Responsibilities:
• Designed, coded, tested and implemented stored procedures and functions for new and existing software application requirements.
• Proficiency in Transact-SQL, stored procedures and writing efficient code in an OLTP and OLAP environment.
• Defined and developed data migration strategy between different sources and platforms using DTS and SSIS Platform.
• Scheduling Jobs on various stored procedures and packages.
• Login and User Management: Worked on authentication by Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Experienced on Database creation, database tuning, and performance planning, backup planning and database administration.
• Created custom reports, matrix reports, drill down reports and reports with graphs.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2000 Enterprise Edition, Enterprise Manager, ER-Studio, UML, MS Project, Windows 2003 Server, .NET

Confidential

Role: SQL Server Developer

Responsibilities:

• Involved in gather user requirements and system specifications.
• Developed stored procedures, functions and database triggers.
• Maintained referential integrity and implemented complex business logic.
• Involved in installation and configuration of SQL Server 2000 and SQL Server 2005 with latest service packs.
• Created and executed SSIS packages to populate data from the various data sources.
• Created SSIS packages using SSIS Designer for export heterogeneous data from OLE DB Source Oracle , Excel spreadsheet to SQL Server 2005.
• Migrated DTS packages to SSIS packages by modifying those packages.
• Designed ETL packages dealing with different data source and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Migrated and recreated existing dimensions and cubes using Star Schema on SQL Server 2005 to achieve the efficiency of SSAS.
• Build MDX queries and data mining expression DMX queries for Analysis Services and Reporting Services.
• Experience in creating multiple reports SSRS in Drill mode using tables, cross tabs and charts.
• Design, deployment and maintenance of various SSRS in SQL Server 2005.
• Designed and implemented parameterized and cascading parameterized reports using SSRS and Crystal Reports with .NET applications.
• Worked with SQL Profiler for troubleshooting, monitoring and optimization of SQL Server and non production database code as well as T-SQL code from developers and QA.
• Responsible for backup, restore systems and other databases as per requirements and also scheduled those backups.
• Managed the security of servers, creating the new logins and users, changing roles of users.
• Involved in developing logical and physical model of database using Erwin.
• Worked with SQL Profiler to trace the slow running queries and tried to optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2005, SQL Server Business Intelligence Development Studio 2008/2005, Procalrity, MS Access, MySQL, Postgre SQL, DTS to Import Export Data, VB Script, Windows XP.

Confidential

Role: SQL Server Developer/DBA

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, deployment and user training.
• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Configured Server for sending automatic mails to the respective people when a DTS process failure or success.
• Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous Database Oracle and Text format data to SQL Server.
• Data migration import export BCP from Text to SQL Server.

Environment: SQL Server 2000, T-SQL, SQL Server 2000 Reporting Service, VSS, Windows 2000 Server, Enterprise Manager, Query Analyzer, SQL Profiler.