SUMMARY

• 6+ Years of Strong experience in the IT industry as a SQL server developer in financial, and education domain.
• Highly experienced with all phases of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation using Water fall model and agile methodology.
• Extensively experienced in database activities like Database Design and Development, Implementation, Maintenance and Performance Monitoring and Tuning using SQL Profiler .
• Excellent working experienced with BIDS.
• Extensive experience in MS SQL Server 2008/2008R2/2005.
• Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Developed Drill through, Drill down, parameterizes reports using SQL Server Reporting Services (SSRS).
• Strong in ETL, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies.
• Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server.
• Expert in Creating, Configuring and Fine - tuning ETL workflows designed in MS SQL Server Integration Services (SSIS).
• Experience with SQL in constructing the triggers, tables, functions, user defined datatype, etc
• Strong SQL Server 2005/2008 Developer Skills including writing Stored Procedures, User Defined Functions, Views, Query writing.
• Experience with web servers (IIS), application servers and TCP/IP Protocol.
• Experience in Database Backup, Recovery and Disaster Recovery procedures (Log shipping, Mirroring, Clustering and Replication).
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• In-depth knowledge of T-SQL, SQL (DDL, DML, and DCL).
• Defined and administered database standards, controls, procedures and documented the same.
• Excellent communication skills, experience with client interaction, providing technical support and knowledge transfer and take new roles in minimum time and little training.
• Good business and Systems Analysis skill to understand the requirements customize the client application.

TECHNICAL SKILLS

Operating Systems: Windows Server 2000/2003/2008 Windows XP/Vista/7

Languages: T-SQL, PL/SQL, C, Java, C#, VB.Net

Tools: /Utilities: Enterprise Manager, SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2005/2008, SQL * Plus

Databases: MS SQL Server 7.0/2000/2005/2008, Oracle10g/9i, MS Access

Software: MS Office, Adobe Dreamweaver, Adobe Photoshop, Ms Excel, MS-Project 2000

Reporting Services: Excel, SQL Server Reporting Services.

Front end: Visual basic 6

PROFESSIONAL EXPERIENCE

Confidential, Plano, TX

SQL Server Developer

Responsibilities:

• Created schemas in SSAS and developed a report using SSRS.
• Developed Drill through and Drill down reports using SQL Server Reporting Services (SSRS). Responsible for report generation using SSRS based on business requirements.
• Used various dataflow and control flow controls for the ETL and Implemented Data Transformation Services Packages in SQL Server Integration Services (SSIS) for transferring data and Data Loads.
• Highly experienced with all phases of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation using agile methodology.
• Stored configuration information in SQL Server table for the migration from development server to the production server.
• Optimized the performance of queries with modification in T-SQL, queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
• Return the stored procedure for the ETL functionality from ODS to Data mart in SQL Server. Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Designed the usage summary and detailed reports in SSRS from the requirement document and the old report Mock-Up in MS Excel.
• Experienced in Activity Modeling phase in Data warehousing design- creation of tables and choosing indexes in Teradata
• Scheduled reports using report manager and scheduled jobs using SQL server job agent.
• Responsible for the reports deployment on the reporting services website and created subscription for the windows file share. Returned the stored procedure and the UDF for the reports.
• Writing SQL Scripts to load the relevant data in QlikView Applications.
• Generated periodic reports based on the statistical analysis of the data using SQL Server reporting Services (SSRS).
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Monitored the database to identify and resolve the performance issues using SQL Server.

Environment: MS SQL Server Reporting Services, SQL Server Integration Services, Crystal Report, MS SQL Server 2008R2/2008/2005, Teradata, MS SQL Server Analysis Service, C++, Visual Studio 2005, MS Access, MS Excel.

Confidential, Fairfax, VA

SQL Server Developer

Responsibilities:

• Designed, coded, tested and implementeduser interfaces, procedures and functionsfor new and existing softwareapplication requirements.
• Designed the usage summary and detailed reports in SSRS from the requirement document and the old report Mock-Up in MS Excel.
• Generated periodic reports based on the statistical analysis of the data using SQL Server reporting Services (SSRS)
• Created Business Requirements, Design, Functional Specifications and Flowcharts.
• Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Database creation; database tuning, performance planning, backup planning and database administration.
• Capacity planning in estimating and sizing of tables.
• Created OLAP and performed Business intelligence concepts.
• Generated report using Microsoft report analyzer.
• Materialized views, dimensions and stored outlines for optimal performance.
• Wrote Triggers and Stored Procedures.
• Actively involved in Normalization (4NF) & De-normalization of database.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Created complex variables, multiple breaks, sorts in the reports.
• Created Objects, Predefined Conditions, Joins in the Universe.
• Created generic Measure class for generic measures, and created separate class for conditional objects.
• Extensively used Oracle SQL and PL/SQL to write Stored Procedures, Functions, Packages and Triggers.
• Decided upon the locking strategy that could be used for various batch Programming structures & Transactions.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2000 Enterprise Edition, BO XI, Enterprise Manager, Teradata, ERWIN, UML, MS Project, MS Access 2000 & Windows 2K platform, IIS and XML

Confidential, Warsaw, Indiana

Sr. SQL Server Developer

Responsibilities:

• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.
• Generated periodic reports based on the statistical analysis of the data using SQL Server reporting Services (SSRS)
• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.
• Developed ETL packages with different data sources (SQLServer, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Applied various data transformations like Aggregate, sort, Multicasting, Conditional Split, Derived column etc.
• Created Packages by testing and Cleaning the Standardized Data by using tools in Data.
• Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages.
• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Developer and implement web service that runs on local machine and call that web service remotely.
• Optimized and modified SQl store functions, procedures, user base datatype etc.
• Deployed and administer web-based email applications using IIS
• Created business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Implemented perspectives, partitions, aggregations, roles, calculated members, calculated measures.
• Generated SQL Server Drill down, Drill through, Adhoc, Cross tab report using SSRS to fit business requirements
• Reports parameters included single valued parameters, multi- value parameters which also consisted of different parameter like hidden, default, internal
• Responsible for database tuning using normalization and application tuning.
• Documentation for all kinds of reports and SSIS packages.

Environment: MS SQL Server 2008, T-SQL, SQL server Integration service 2008, SQL server reporting service 2008,SQL server Analysis service 2008, Erwin, Query Analyzer, Index Tuning wizard, SQL Profiler Windows server 2003, Oracle 10g

Confidential

Technical Associate

Responsibilities:

• Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs, Agile methodology was implemented.
• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.
• Performed Database partitioning and created jobs.
• Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages.
• Created and scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.
• Developer and implement web service that runs on local machine and call that web service remotely.
• Optimized and modified SQl store functions, procedures, user base datatype etc.
• Deployed and administer web-based email applications using IIS
• Created business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Implemented perspectives, partitions, aggregations, roles, calculated members, calculated measures.
• Generated SQL Server Drill down, Drill through, Cross tab report using SSRS to fit business requirements
• Reports parameters included single valued parameters, multi- value parameters which also consisted of different parameter like hidden, default, internal
• Responsible for database tuning using normalization and application tuning.
• Documentation for all kinds of reports and SSIS packages.

Environment: MS SQL Server 2008, T-SQL, SQL server Integration service 2008, SQL server reporting service 2008,SQL server Analysis service 2008, Query Analyzer, Index Tuning wizard, SQL Profiler Windows server 2003, Oracle 10g