SUMMARY

• Over Eight years of extensive experience in database development with Microsoft SQL Server 2012/2008/2005 and Microsoft’s suite of products like SSIS, SSAS and SSRS.
• Strong Transact - SQL Query writing skills (DDL- data definition language and DML- data manipulation language).
• Proven ability in generating all types of reports - Drill down, Drill through reports, Parameterized reports,sub-reports, navigation reports (Hyperlink) etc. in SSRS 2005/2008.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Strong SQL Server developer skills including writing stored procedures, user defined functions, views, triggers, CTE (Common Table Expressions).
• Have good working knowledge using visual studio 2010 to build VB.net application forms.
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc).
• Experience in managing Alerts, notifications and Jobs through SQL Server Agent.
• Experience in writing Procedures, Functions, Triggers and other database objects using SQL and PL/SQL.
• Good understanding of RDBMS and design of database architecture.
• Experience in data modeling using MS Visio and Erwin tools.
• Good working knowledge of Performance tuning of Stored Procedures and T-SQL Queries.
• Good working knowledge with Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, Facts and Dimensional tables and Operational Data Store (ODS).
• Experience in creation of logins, users and configuring permissions and assigning roles to users.
• Expertise in designing and implementing ETL & BI solutions using SQL Server 2012/2008/2005 SSIS, SSRS.
• Utilized Access, Excel and SSRS to create, modify, run, export, print, distribute, deploy, and troubleshoot reports.
• Excellent in High Level Design of SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Experience in migration of data using BCP Utility, Bulk Insert command, SSIS and DTS Packages and Import/Export Wizard
• Overall database design, such as creating normalized databases, query tuning, assigning proper indexes, partitioned views, creation of triggers, and stored procedures.
• Experience in supporting huge databases, troubleshooting problems, and documenting root cause analysis.
• Proficient in monitoring SQL Server performance using SQL Profiler and Windows Performance Monitor.
• Effectively can work individually or as a team to accomplish teh assigned tasks Confidential allocated time.
• Experience in working with various source controls such as TFS, Vault and SVN.
• Experience working in Agile / scrum environment.

TECHNICAL SKILLS

Operating System: Windows XP, Windows 2000/98/95/NT, Windows Vista

RDBMS: MICROSOFT SQL SEVER 2012/2008/2005

ETL Tools: SSIS 2008/2005

Reporting Tools: SSRS 2008R2/2008/2005

Programming Languages: C#, Unix, C++,VB.NET, ASP.NET, PL/SQL

Business Intelligence: SSIS, SSRS, SSAS

Documentation Tools: MS Office ( Word, Excel,Access)

Internet Tools: Internet Information Server (IIS), TCP/IP, LAN, WAN

Version Control: Visual Source Safe, Team Foundation Server,Vault

Data Modeling: Erwin

PROFESSIONAL EXPERIENCE

Confidential, PA

Microsoft SQL Developer ( SSRS / SSIS / SSAS )

Responsibilities:

• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2008) which consist of report Criteria in various reports to make minimize teh report execution time and to limit teh no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non queried parameters).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Experience working with VB application where application was built on a VB 6.0 front-end consisting of class modules and some forms. Teh backend resided on mainframe DB tables which interfaced with via VB.
• Created complex stored procedures, Triggers, User-defined Functions, Views and Cursors for handling business logic and functionality of various modules.
• Worked with other database administrators, report writers, and project teams to refine reporting requirements based on customer's business needs.
• Create ad-hoc SQL queries for customer reports, executive management reports
• Scheduled reports to refresh and run on daily, weekly and monthly basis in teh report manager.
• Worked on SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Created data loads and Upgrade scripts for data migrations and validations.
• Implemented security to restrict teh access to users and to allow them to use only certain reports.
• Provided documentation about database/data warehouse structures and updated functional specification and technical design documents.

Confidential, Redmond - WA

SQL Sever developer ( T-SQL / SSIS / SSAS/ SSRS Developer )

Responsibilities:

• Created report models for Ad-hoc reporting. Created Ad Hoc reports in Report Builder.
• Created parameters for teh required fields using teh report designer in order to see teh dropdowns in teh end report.
• Used various types of report layout options like charts, images, sub reports, hyperlinks etc to make them more attractive and understandable.
• Designed various reports using different reporting features such as group by, drilldowns, drill through.
• Worked with Business Analyst & Users to understand teh requirements. Involved in System Study analysis for logical/physicaldata model there by defining strategy for implementingStar Schema with Fact & Dimension tables.
• Expertise in writing and debugging Stored Procedures, Triggers, Cursors and T-SQL coding.
• Responsible for optimization & tuning complex Transact SQL queries for better performance.
• Created constraints and triggers to ensure teh consistency of data in teh database and staging database.
• Creation of all database objects as desired standards and setting permissions and wrote DDL & DML Statements.
• Created SSIS packages to transfer data between OLTP and OLAP databases.
• Created cubes using SSAS and populated facts and dimension tables and generated reports from cubes using SQL Server Analysis Services.
• Involved in checking database consistency, data integrity and data redundancy.
• Involved in snapshot replication of teh production database
• Implemented transactional replication to meet reporting services requirements.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports.
• Monitored database system resources and performance. On-call during off hours and weekends on a rotation basis.
• Coordinated database system upgrades with IT team, end users, and vendors.

Environment: MS SQL Server 2008, VS2008, SQL Server Reporting Services (SSRS 2008), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), T-SQL,MS Excel

Confidential, Irving, Texas

Microsoft SQL Server Developer

Responsibilities:

• Worked with Business Analyst & Users to understand teh requirements. Involved in System Study analysis for logical/physicaldata model there by defining strategy for implementingStar Schema with Fact & Dimension tables
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL, Triggers Scripting and Jobs.
• Managed teh migration of SQL Server 2005 databases to SQL Server 2008.
• Expertise in writing and debugging Stored Procedures, Triggers, Cursors and T-SQL coding.
• Used Execution Plan, SQL Profiler and Database Tuning Advisor to optimize queries and enhance teh performance of databases
• Optimized teh performance of queries by modifying teh existing index system and rebuilding indexes.
• Created SSIS packages to transfer data between OLTP and OLAP databases.
• Created SSIS packages to transfer data from heterogeneous sources to SQL server using different SSIS components and used configuration files and variables for production deployment.
• Created master ETL packages which include various packages in them and scheduled them to execute based on teh given requirement time.
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task to generate underlying data for teh reports & to export cleaned data from Excel Spreadsheets, Text file, MS Access & CSV files to data warehouse.
• Created SQL Server Reports using SSRS 2008.
• Designed various reports using different reporting features such as group by, drilldowns, drill through.
• Used various types of report layout options like charts, images, sub reports, hyperlinks etc to make them more attractive and understandable.
• Created report models for Ad-hoc reporting. Created Ad Hoc reports in Report Builder.
• Created weekly and monthly reports as per requirement using SSRS.
• Scheduled Reports to be delivered to User on demand Basis in SSRS report Manager.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server
• Helped teh users to test teh reports created and optimized teh performance of teh end reports getting data from SQL server Databases.
• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application. Cleansing and solving Database troubles.
• Suggested, developed & implemented Scaling out solution with Data partitioning.

Environment: VS2008, MSSQLServer 2008/2005/2000, Reporting Services (SSRS 2008), Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SSAS, ETL, Oracle 9i.

Confidential, Oklahoma City, OK

SQL server developer ( SSIS / SSAS / Report Developer)

Responsibilities:

• Worked with other database administrators, report writers, and project teams to refine reporting requirements based on customer's business needs
• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for handling business logic and functionality of various modules
• Created Triggers dat produces primary key (unique) automatically when a new record is inserted into teh database. Teh intention is to maintain unique records to eliminate duplicate records.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2008) which consist of report Criteria in various reports to make minimize teh report execution time and to limit teh no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non queried parameters).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Create ad-hoc SQL queries for customer reports, executive management reports
• Scheduled reports to refresh and run on daily, weekly and monthly basis in teh report manager.
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures
• Worked on Huge Data Transfers from & to SQL Server Databases using utilities / tools like SSIS, BCP, BULK INSERT etc and used configuration files and variables for production deployment
• Created data loads and Upgrade scripts for data migrations and validations
• Implemented security to restrict teh access to users and to allow them to use only certain reports.
• Provided documentation about database/data warehouse structures and Updated functional specification and technical design documents.

Environment: MS SQL Server 2008, VS2008, SQL Server Reporting Services (SSRS 2008), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), T-SQL, PL/SQL, Oracle 9i, Toad, MS Excel

Confidential, Middletown, NJ

Microsoft SQL server Developer

Responsibilities:

• Actively involved in creation of database, modified tables, triggers, procedures to clean and validate teh data about teh table layout, so as to meet teh company specifications.
• Installation and configuration of MS SQL Server on Windows 2000/2003 Servers.
• Migration of databases from MS SQL 2000 to MS SQL 2005.
• Logical and Physical design of database for projects on basis of user requirement.
• Writing stored procedures to extract source data.
• Converting teh extracted source data to text files using BCP.
• Creating stored procedures to load teh target databases.
• Created stored procedures, tables, triggers, indexes and views using Detail design specifications.
• Fine tuned queries, assigned proper Indexes for better performance.
• Assisting teh development team in fixing teh defects.
• Participating in teh knowledge transfer process and share teh knowledge with teh client team.
• Optimized teh performance of queries by modifying teh existing index system and rebuilding indexes.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Migrated DTS packages to SSIS (SQL Server Integration Services) using DTS migration wizard.
• Developed standards and guidelines to maintain and develop and administer teh SQL Server database.
• Data transformation activities using DTS Import/Export for transferring data between different Databases like Oracle, Sybase.
• Applied schema change scripts to existing objects to synchronize with changing business rules by adding or enhancing relevant entities/tables, columns etc.
• Implemented database consistency and security by creating groups, roles, users, and triggers on views.

Environment: SQL Server 2000/2005, T-SQL, SSIS, Management Studio, Query Analyzer, Windows 2000/2003, Oracle 9i.

Confidential 

SQL Server Developer

Responsibilities:

• Interacting with Business Analysts & Developers in identifying teh business requirements, designing & implementing teh database schema.
• Developed a data model and implemented teh same using ERWIN.
• Created Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T-SQL (DDL, DML) statements for application.
• Used joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers & stored procedures and enforced business rules via checks & constraints.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Designed & created data marts, databases, indexes, views, aggregations, store procedures, partitions & data integrity
• Transformed data from various data sources using OLE DB connection by creating DTS packages.
• Analyzed & tuned complex Queries/Stored Procedures in SQL Server 2000 for faster execution & developed database structures.
• Mentored team members to optimizing SQL queries.
• Scheduled and monitored all maintenance activities, database consistency check, index defragment
• Provided technical support to internal developers and external clients.

Environment: MS Access, SQL Server 2000, XML, MS Visio, SQL Profiler, ERWIN 4.0, Windows NT/2000 server & Professional.