SUMMARY:

• Around 7+ years of IT experience in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) and Data Design and Development as SQL Server database developer involving in analysis, design, creation and implementation of project requirements for Data Modeling and Data Management.
• Extensive programming, installing, configuring, managing, monitoring and troubleshooting experience in MS SQL Server 2005/2008R2/2014 and Business Intelligence Studio.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS Import Export Data, Bulk Insert and DTS/SSIS Packages.
• Worked in delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Expert in Designing and developing OLAP Cubes and Dimensions using SSAS
• Experienced in working with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Well - versed in disaster recovery solutions including Database mirroring, Log shipping and clustering.
• Designed and developed database applications and data warehousing for business intelligence.
• Extensive experience in using tools like server objects (linked servers), Index Tuning Wizard, SQL Profiler, CLR Functions and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Excellent and in depth knowledge in Data Migration from different databases to SQL Server Database
• Experience in Co-ordinate user testing, implementation and post production support
• Highly motivated and conceptually strong individual with exceptional analytical and design skills
• Maintain good Communication with all levels of organization and good interpersonal skills.

TECHNICAL SKILLS:

Languages: Transact SQL, PLSQL, VB Script Visual Basic, C, C++

Databases: MS SQL Server 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008, 2008R2,2014, MS Access 97/2000/2003/2007

Operating Systems: Windows 8/7/XP/2003/2000/NT/98/95

ETL Tools: SSIS, DTS, ERWIN

Other Tools: MS SQL Server Reporting Services, Cognos 8 and crystal reports 8.5/9/10, ODBC MS Office, ERWIN

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

BI Developer

Responsibilities:

• Involved in entire product life cycle development from the requirement gathering through implementing of Data warehouse.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures to load the Data Warehouse.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Designed SSIS Packages to transfer data from various sources like Text Files, SQL Server, and Excel to SQL Server using Business Intelligence Development Studio.
• Implemented Event handlers to the events raised by a package, task or container in SSIS and Checkpoints while loading Dimensions and Fact data with the SSIS to avoid re- running the package from starting during the errors.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse
• Configured Connection Manager Files and CMD files for SSIS packages to dynamically execute on QA Server and Production server
• Created and Configured OLAP Cubes using SQL Server 2014 Analysis Services and Performance tuning and scaling to large numbers of users.
• Created Excel Pivot for end users to create self servicing reports.
• Involved in creating SQLstored procedures,Functions,Views, Indexes in Microsoft SQL Server and Optimized the Stored Procedures, Functions, views using appropriate business rules, standards for better performance and Identifying and tuning the slow running queries in a poorly performing application.
• Involved in designing and implementing the De-identification of Production Database for performance testing.
• Involved in configuring the Report Server in 2014/2008R2 and managed adding logins, roles, groups to the Window NT and MS SQL Server and maintaining roles based security procedures.
• Created various SSRS Reports involving variety of features like Graphs, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters using MS SQL Server SSRS 2014/2008 R2 to business requirements in time restricted environment.
• Created reports by using various components likeGrouping, Sorting, Filters,andNavigation.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created report models for ad hoc reports and deployed on report server.
• Developed reports with Charts, Grouping, Sorting and Multiple Datasets using Reporting Services (SSRS).
• Train and manage developers, advising other groups in organization on SSIS development, SSRS reports and data warehouse development, and documenting the best practices.
• Conduct code walkthroughs and review peer code and documentation.
• Provide on-call support to production system to resolve any issues.
• Involved in database tuning, performance tuning, backup planning and database administration jobs.
• Involved in Unit Test cases preparation and performed Unit testing.

Environment: Microsoft SQL Server 2014/2012/2008 R2, SSIS 2014/2008 R2, Visual Studio 2010, SSMS (SQLSERVER Management Studio),2013 Excel Pivot,T-SQL, VB.Net,C#, Github,TFS,Windows7, .NET Framework 4.0

Confidential, Milpitas, CA

SQL BI Developer

Responsibilities:

• Involved in Database design by creating database objects like tables, views, stored procedures and Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures
• Assisted with the design and implementation of workflow applications to update and insert data.
• Coordinate with business users in gathering business requirements and translating them to technical specifications.
• Created SSIS packages to move the data from Oracle toSQL Server staging Database and from Oracle to Flat files.
• Created SSIS packages and executed using SQL Agent jobs to move the Data from Dev, QA to Production Servers.
• Involved in creating SQLstored procedures,Functions,Views, Indexes in Microsoft SQL Server and Optimized the Stored Procedures, Functions, views using appropriate business rules, standards for better performance and Identifying and tuning the slow running queries in a poorly performing application.
• Created packages by using multiple transformations in SSIS to meet the business requirements by extracting data from heterogeneous source systems, transform and finally load into the Staging Data base.
• Documented and maintained database system specifications, diagrams, andconnectivity charts.
• Written and executedcomplex T-SQL queries using SQL Management Studio for back end data validation testing.
• Involved in database tuning, performance tuning, backup planning and database administration jobs.
• Involved in Unit Test cases preparation and performed Unit testing.

Environment: SQL Server 2014/2008R2, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), MS Visual Studio.NET, XML, VB.Net,C#

Confidential, Sanjose, CA

BI Developer

Responsibilities:

• Involved in implementing the logical design to the physical design by creating tables and Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Involved in designing and implementing the ETL solutions using SSIS.
• 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.
• Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables and indexes
• Created stored procedures for maintaining SQL Server and for supporting the Application Developers to get an easy access to data objects.
• Created and maintained database, tables, views, indexes, and constraints to implement business rules by using Query Analyzer and SQL Server Management Studio.
• Worked extensively in creating Stored Procedures, Views, and Functions for data retrieval and Involved in writing TSQL Code, including complicated joins and cursor loops.
• Maintained any existing reports within the Reporting Services solution projects and Designed different project solutions to handle the wide array of reporting needs.
• Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third party data source to transfer data.
• Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Used SSIS 2008 to create 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 and Developed several detail and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS-2008/2008R2
• Designed and developed various complex reports such as Tabular, Cross-tab, Pie Chart reports, Sub Reports, Drill down reports, and Drop down reports using MS Reporting Services (SSRS) and involved in managing the subscription and authentication of these reports.
• Involved in designing reports using Crystal Reports XI version using Oracle 11g version, SQL server and MS Access databases and SQL optimization to improve run time performance of reports.
• Reviewed the existing stored procedures and improved efficiency by critically evaluating the code or by replacing them with CLR stored procedures and UDFs to optimized performance of front end applications.
• Worked with the DBA to manage and configure the reporting database as well as securing the data warehouse and map users to their permissions and roles to enable them to operate effectively without affecting the integrity and security of the company height priority data.
• Automated and enhanced daily administrative tasks, including space management, backup & Recovery and performance monitoring.
• Created documentations of all objects and code created in support of the project as well as keeping records of all change request documents
• Involved in testing, bug fixing and documentation for the project.

Environment: SQL Server 2005/2008/R2, Integration Services (SSIS), Analysis Services (SSAS), Reporting Services (SSRS), MS Visual Studio.NET, XML, VB.Net,C#

Confidential, West Borough, MA

BI Developer

Responsibilities:

• Principal responsibility is to implement, support, maintain, monitor & tune highly available database systems.
• Developed logical and physical data models to support specific needs as requested by the company.
• Created Database Objects like Tables, Stored Procedures, Views, joins, Triggers, user defined data types and functions.
• Optimized the Stored Procedures, Functions using appropriate business rules, standards for better performance and Identifying and tuning the slow running queries in a poorly performing application.
• Used Normalization techniques for designing database applications using SQL Server 2005/2008.
• Created jobs and monitor job history for maximum availability of data and to ensure consistency of the databases.
• Designed high availability solutions and implemented database mirroring and replication for the data security.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and regular monitoring.
• Managing the use of disk space, memory and connections. Running DBCC consistency checks, fixing data corruption in application databases
• Developed packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2005 Integration Services (SSIS).
• Responsible for the creation and maintenance of Analysis Service objects such as Cube, Dimensions, MDX queries, and KPI’s and created a report model on SSAS cubes.
• Loading data from various sources like excel, flat files to SQL Server database Using SSIS Package and used customized script utilizing expressions and VB scripting to enhance tasks in SSIS.
• Involved in configuring Report Server in SQL Server 2005/2008 and implemented report builder to allow customers build their reports.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005/2008 for customized ad-hoc queries.
• Used Performance Monitor and SQL Profiler to monitor all the activities of the server by error logs enhanced the performance of database servers and used for optimize queries.
• Involved in migrating databases from SQL Server 2005 to SQL Server 2008.
• Security Administration included creating various user groups and assigning the accessibility according to requirement, monitoring the user accounts, creating user accounts, granting the privileges to users and groups.
• Monitoring all activities of the server by monitoring the daily SQL jobs, SQL Server error logs and Windows error logs.
• Implemented and Scheduled Replication process for updating our parallel servers.
• Foundation in database administration - space utilization, load balance, process scheduling.

Environment: SQL Server 2005/2008, SQL Server Integration Services (SSIS),MS Reporting Services (SSRS), SSAS, MS Visual Studio 2010,MS Access, Visual Source Safe

Confidential

T-SQL Developer

Responsibilities:

• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Involved in ER diagrams and mapping the data into database objects.
• Installed and Configured SQL Server 2000 successfully.
• Design of the database and the tables.
• Build table relationships and wrote stored procedure to clean the existing data.
• Coordinated with the front-end developer to put in the business rules. Wrote procedure to check some of the rules at the backend at the time of entering data.
• Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Developed the project using iterative approach.
• Managed database changes based on feedback.

Environment: MS SQL Server 2000/2005/2008 , Windows 7/XP, Oracle, Visual Basic 6.0, MS Reporting Services.