SUMMARY

• Around 7+ years of experience as SQL Server Developer/Admin/Business Intelligence Developer. Experience includes requirements gathering, development, design, testing, deployment and maintenance of SQL Server technologies.
• Experience in OLTP, OLAP/Data Warehouse, and Data Mart and ODS Data Bases.
• Experience in installing, upgrading, configuring, managing, monitoring and troubleshooting of Microsoft SQL Server and Databases.
• Experience with SQL Server 2000, 2005, 2008 and Denali 2012.
• Proficient in T - SQL queries using Store Procedure, Dynamic SQL, joins, Views, User defined functions, Triggers, Cursors, CTE, DML, and DDL etc.
• Proficient in Performance Tuning of SQL query.
• Good Understanding of Isolation Level, MOLAP, ROLAP, HOLAP, Normalization, De Normalization,
• Partitioning, ACID Property, Data Warehouse, Bill Inmon methodology, Ralph Kimball methodology, Star flake schema, Snowflake Schema, SSAS Dimension Attribute Properties and etc.
• Excellent in MS SQL Server 2005/2008 suite of products like SSIS, SSAS and SSRS.
• Good experience in developing reports using SQL Server (SSRS)
• Good experience in creating pivot tables and charts in Excel using data sources (SQL Server, SSAS cubes, Access) and power pivot.
• Experience in Visual Studio Team Foundation Server, Visio
• ETL experience across Oracle, Access, MySQL and Excel
• Proficient in writing MDX query and good knowledge of all MDX Functions
• Experienced in Database Administration
• Experience in making formal and informal presentations to technical and non-technical staff
• Expert in Creating and managing roles for security in SSRS reports.
• Experience developingBI/dashboard components using tools like BIDS, PerformancePoint and Power Pivot.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Experience in implementing different types of Replication Models like Snapshot, Merge and Transactional.
• Experience in implementing high availability process like log shipping, Mirroring, and Clustering.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows NT/XP/Vista/7/2008, Mac

Programming Languages: C, Java, C#, T-SQL

Database: MS Access, MS SQL Server 2008/2005/2000 Internet

Technologies: ASP.NET, JavaScript, VBScript, XML, CSS, HTML

Tools: Rational Rose, MS Office, VisualStudio2008/2005DTS, SSAS, SSIS, SSRS, VSTF.

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

SQL/SSRS/SSIS Developer

Responsibilities:

• Participate in being a member of ICIS team helping users create data, monitoring and resolving issues in the area of Data Management and Integration Services.
• Perform System and Requirement Analysis, design and writing technical design documents and test plans.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services
• Worked on creating SSIS packages to upgrade SQL Server 2005 to SQL Server 2008.
• Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
• Design and develop mappings, sessions and workflow as per the requirement and Wells Fargo standards
• Communicate with business user to understand their problem if required and send workaround /step to solve the issue and find the root cause and advice if required to any enhancement.
• Dealing with Change Requests and making the required customization changes.
• Responsible for making changes in the existing configuration wherever required, making
• Customizations according to the business requirements, testing and successfully moving the changes into production.
• Design and develop SQL Server 2008 Database, Tables, Indexes, Stored procedures, Views, Triggers.
• Develop the application based on Wells Fargo enterprise architecture framework, which includes Understanding and implementing the Enterprise Architecture Best Practices, Guidelines and Standards, ETL framework and Enterprise Scheduling.
• Utilized a combination of stored procedures and Integration Services to enable required data extract, transform and load procedures and packages (ETL).
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational Drill-through and Drill-down reports using SSRS
• Experience inMicrosoft Visual C#in script component of SSIS.
• Troubleshooting and fixing Bugs/issues in the enterprise level web application using C#. NET, ADO.NET, ASP.NET.
• Providing SIT, UAT support and production rollouts.
• Production, customer issues, ad hoc request resolution.
• Preparation of deployment scripts of SSIS and database server in various environments like development, SIT, UAT and Production.
• Technical activities include developing code in SSIS and T-SQL (SQL Server).
• Review code delivery and manage the version in Team Foundation Server.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services.
• Technical Documentation and Perform reviews, design and data manipulation.
• Production Support and resolving the issues.

Environment: SQL Server 2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, C#, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003, TIBCO.

Confidential, Pleasanton, CA

SQL/ SSIS/SSRS Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems.
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Involved in ETL architecture enhancements to increase the performance using query optimizer
• Experience inMicrosoft Visual C#in script component of SSIS.
• Troubleshooting and fixing Bugs/issues in the enterprise level web application using C# .NET, ADO.NET, ASP.NET.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Developed a High-level dashboard using SSRS 2008.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• 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.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2005 to SQL Server 2008.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, C#, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

Confidential, Sunnyvale, CA

SQL Server SSIS/SSRS Developer

Responsibilities:

• Migrating SQL Server 2005 databases into SQL Server 2008.
• Designing and developing SQL Server 2008 Database, Tables, Indexes, Stored procedures, Views, Triggers.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services
• Worked on creating SSIS packages to upgrade SQL Server 2005 to SQL Server 2008.
• Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
• Took part in the preparation of Project plan, user acceptance testing. Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Troubleshooting and fixing Bugs/issues in the enterprise level web application using C#.NET, ADO.NET, ASP.NET.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Developed a High-level dashboard using SSRS 2008.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-Hocreports as per the client requirements.
• Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality Test Plan which was used by testing team while doing their testing process.
• Designed the packages in order to extract data from SQL db, flat files and loaded into Oracle database.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Developed user defined financial reports to provide on demand financial data analysis using SSRS.
• Performed data conversions from flat files into a normalized database structure
• Developed numerous ad-hoc reports using SSRS for day to day financial reporting
• Installed and configured the components required to integrate SSRS with MOSS Enterprise Edition
• Experience in creating and maintaining MS SQL Server installation, performance tuning, backup, restore, security and disaster recovery.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional Tables and Operational Data Store (ODS).
• Monitored database status including CPU, memory, I/O, space and dead lock using SQL Server Utilities.
• Wrote DTS scripts for data transfer and Involved in System testing.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
• Worked on SSIS and DTS Packages, DTS Import/Export for transferring data from Heterogeneous Database (Text format data) to SQL Server
• Data migration (import & export - BCP) from Text to SQL Server.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Involved in design, programming, deploy and Unit Testing of requested Reports

Environment: MS SQL Server 2008, MS SQL Server Management Studio, SSIS-2008, SSRS-2008, .Net framework, C#, Microsoft Excel 2007, Windows 2000, Microsoft project.

Confidential, Framingham, MA

SSRS/ SSIS Developer

Responsibilities:

• Job includes performing various programming, developing, system support, software installations and hardware maintenance duties
• Recommend hardware specifications for new database servers
• Administered the operative system and the hardware of the SQL Servers
• Assists functional and technical users with functional and technical testing in all environments
• Helped students in SQL programming related issues in Lab
• Assists Students in writing complex SQL queries and also assist them in their Academic projects that uses SQL Server 2005
• Developed complex SQL queries as per requirement in T-SQL for the Office of Admissions.
• Troubleshoots and resolves database issues related to access modes, access times, device allocation of databases and applications, and validation and organization of the environment.

Environment: SQL Server 2008 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, C#, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003, TIBCO.

Confidential

SQL Server SSIS/SSRS Developer

Responsibilities:

• Installed, configured, maintained and supported SQL server 2000 and 2005 in different environments
• Measured database storage requirements and check current and projected data growth to provide advice to the responsible team about storage requirements in advance
• Administered the operative system and the hardware of the SQL Servers
• Provided support to development staff about database related issues.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL for SQL Server 2000 and 2005.
• Creating the new logins and users, changing the roles of the users.
• Alteration of tables and fields as per requirements and recreation of indexes.
• Create charts and pivot tables in Excel 2003
• Created ETL processes using Microsoft DTS and SSIS.
• Worked as Instructor for new Trainee.

Environment: MS SQL Server 2008, MS SQL Server Management Studio, SSIS-2008, SSRS-2008, .Net framework, C#, Microsoft Excel 2007, Windows 2000, Microsoft project.