Summary:

• MS SQL Server Developer 2008R2 / 2008 / 2005 / 2000 with 11 years of IT experience in various Industries like Health Care, Finance, Insurance and Service.
• Extensive Experience in MS SQL Server 2008 with Business Intelligence in SQL Server Analysis Services, SQL Server Reporting Services and SQL Server Integration Services.
• Expert in writing T-SQL and creating database objects Tables, Views, Triggers, Indices, Stored Procedures, User Defined Functions and Dynamic SQL.
• Strong experience in SQL Server DTS and SSIS Integration Services package design, constructing, and deployment.
• Experience in migration of Data from Excel, Flat file to MS SQL Server by using MS SQL Server DTS and SSIS.
• Expert in creating SQL Server Reports using SSRS 2005/2008 in designing stylish report layout parameterized performance, Chart Reports and ad-hoc reports.
• Extensively used Report Builder and Report Manager for developing reports and deploying reports in SSRS. Experience in report writing according to the business requirement in SSRS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages.
• Handled huge financial data, expert level query optimization and performance tuning experience.
• Excellent Knowledge of RDBMS, Data Warehouse Data Modeling concepts.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO
• Conversant with all phase of Software Development Life Cycle involving Systems Analysis, Design, Development and Implementation.
• Extensively used Repositories like Team Foundation Server TFS and Visual source safe VSS for Data Archival.
• Complete knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Able to manage changing responsibilities and deliver time critical projects on schedule.
• Quick learner, Strong communication skills and ability to work in a team and individually.

Technical Skills:

Professional Experience:

Confidential

Senior SQL Developer

Responsibilities:

• Created SSIS packages to migrate data from legacy systems to the Data Warehouse environment.
• Developed SSIS packages to create reports in various formats like Excel, CSV, Text and XML.
• Scheduled SSIS Packages as SQL Jobs using SQL Server Agent.
• Involved Interaction with Project Managers and Business Teams for requirement gathering.
• Designing Dimension and Fact tables based on the requirements and specifications.
• Developed different types of SSRS reports like Linked Reports, Sub Reports and Drilldown Reports.
• Developed Expressions in reports to control content and report appearance by using Report Functions.
• Deployed the reports to the Report Manager by applying the specified Security settings.
• Training the end users to run and export the reports using the Report Manager
• Reduced manual effort/hours by developing SSIS packages to automate the process of importing data from external interfaces Excel, CSV, Text files to Dim/Fact tables
• Creating SSRS reports that use Cubes as data sources
• Developed Multidimensional Expressions MDX to retrieve data from SSAS cubes.
• Created Stored Procedures, User defined Functions, Triggers, custom views and TSQL Scripts in SQL server database.
• Analyzed and optimized existing stored procedures and functions leading to performance improvement and faster payment processing.
• Designed and Developed applications in C 3.0 to monitor folders and start SSIS packages.
• Worked on project to upgrade SQL Server 2005 to SQL Server 2008.
• Conducted training session with product support team before all releases help them in handling trackit's.
• Perform code reviews for peers.
• Used MS Visio for data modeling.
• Used Team Foundation Server for version control.
• Used Redgate tool SQL Test to test Stored Procedures and functions.

Environment: Visual Business Intelligence Development Studio 2008, SQL Server Management 2008, SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS , Report Builder, SQL Profiler, .Net, C , Windows Server 2008, Team Foundation Server 2010.Redgate SQL Test, SQL Dependency and SQL Prompt.

Confidential

SQL Developer

Responsibilities:

• Involved in complete development life cycle of projects using SQL Server, SSIS and SSRS.
• Designed, Created Tables using Normalization techniques , Stored Procedures, Functions and Triggers for both reporting and client server architecture using Transactions and Error capture technique.
• Improved performance by tuning existing Stored Procedures and report queries.
• Created SSIS packages to import the daily feed from Business Teams into the system tables. There are different types of data imports like Prod Schema Data Ingestion, which originates new loans in the system, Call Center Data Feed to capture Call Center Activity on a daily basis, FedEx Data Feed to capture Tracking Numbers and Shipping Exceptions.
• Developed various reporting functionalities using SSIS packages like Creating reports in different formats .txt, .csv, .xlsx , Compressing/Zipping the reports, uploading the reports to shared drives as well as client's FTP location.
• Using SQL Server Reporting Services SSRS different kinds of reports were created depending on the user requirements and specifications. Thoroughly tested the results and deployed the reports to the Report Manager.
• Created Drill down, Parameterized and Sub Reports based on the requirements provided
• Created/Maintained/Scheduled different kinds of Report Subscriptions in Report Manager like Email, Web Archive and File Drop.
• Created and scheduled Jobs using SQL Server Agent.
• Collaborated with DBA's to create Maintenance plans and Backup jobs
• Extensively worked with SQL Sentry for SQL Server Database Performance Monitoring, Deadlock/Blocking Detection, Tuning, Job Scheduling, and Alerting.
• Involved in complete software development life cycle SDLC of projects using ASP.Net, C .Net and VB.Net
• Designed and developed .Net front end console applications.
• Used Microsoft Visual Source Safe for version control.
• Worked on both Waterfall and Agile type development project.
• Responsible for providing production support and fixing production issues.
• Good experience in finding bugs and giving impact analysis of the application
• Guided junior developers to adhere to the quality coding standards.
• Used CA Erwin for data modeling.

Environment: Business Intelligence Development Studio BIDS , SQL Server 2008/2005, SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS , Microsoft Management Studio, Microsoft Visual Studio 2005, ASP.NET 2.0, C Net 2.0, Windows Server 2008/2003,CA ERWIN Team Foundation Server, SQL Profiler, SQL Prompt, SQL Test .

Confidential

SQL Server BI Developer

Responsibilities:

• Worked on complete SDLC system development life cycle including system analysis, high level design, detailed design, coding and testing, deployments and production support activities.
• Extensive interaction with cross team members for gap analysis and product integration activities.
• Along with partial Database design activities, was also involved in coding, unit testing all kinds of SQL Server objects.
• Developed multiple SSIS packages to support Shared Services operated by company to bring in Staff , student ,scores etc data from wide variety of sources to support various front end applications , Data ware house and Operational Data store. All SSIS packages were thoroughly configured for supporting multiple environments, alerting and logging purposes.
• Designed and developed SSRS Reports. Most of the reports are configured with subscriptions and snapshot features .All security strategies for report access was designed based on Windows Group s or depending front end login.
• Provided estimates LOE and Proof of concept POC / mockup for all fore mentioned activities
• Review and Validation of Test cases based on user requirements.
• Involved in opening and updating tickets for release management activities with all references to code base, approvals, Go/No Go etc involved for the deployments.
• Offsite QA and DEV team co ordination.

Environment: SQL Server 2008, Windows 2003 Server, SSIS, SSRS, Microsoft Visual Studio2008/2010 with TFS, Nevron Charts, Test track Pro and MOSS Share point .

Confidential

SQL Server Developer

Responsibilities:

• Involved in migration of SQL Server 2000 databases to SQL Server 2005 databases.
• Extensively worked on DTS to SSIS migration.
• Involved in creating and deploying cubes using SSAS.
• Involved in Database Design, Performance Analysis, and Production Support for Large VLDB and Complex Databases.
• Tuning Databases and servers by using SQL profiler for better performance.
• Implemented and monitored a large-scale and time-sensitive production loading processes.
• Involved in Source Data Analysis, Design and Development of SSIS Packages to load the Data from various Data sources.
• Developed stored procedures/Packages using T-SQL programming to meet the business requirements.
• Analyzed long running queries and tuned the same to optimize application and system performance.
• Successfully loaded data from an EXCEL, Access into a SQL Server database Table.
• Used MS Visio for data modeling.

Environment: SQL Server 2005/2000, C , .NET, Windows Server 2003, VSS, SQL profiler, T-SQL, SQL, SSIS, SSRS, Toad, MS Visio, SQL Test.

Confidential

MS SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in all the phases of SDLC.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of Constraints and Triggers for Data Consistency.
• Used Stored Procedures for updating Servers.
• Used SQL Server Integration Services SSIS and its tools to Extract, Transform and Load data into Data Ware House.
• Developed, deployed and monitored SSIS Packages. Involved in creating log files for SSIS packages.
• Enabled Check points in SSIS package. Created break points in order to view the status of data, variables and over all status of SSIS package.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Developed and Deployed different types of Reports like List, Matrix, and Chart and Sub Reports etc.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Used SSRS to create interactive reports with an ability to drill down into details.
• Create OLAP cubes with SSAS based on multidimensional database with star schema or snow flake schema
• Extensively involved in the SSAS storage and partitions and Aggregations, Calculation of queries with MDX, developing reports using MDX and T-SQL.
• Created MDX script for representing Cube Calculation using SSAS.

Tools Technologies:

MS SQL Server 2005, SSIS, SSRS, T-SQL, Visual Studio 2005, MS Office 2003, SQL Profiler, Windows 2000/2003.

Confidential

Jr. SQL Developer

Responsibilities:

• Defined and designed the data sourcing and data flows, data quality analysis.
• Identified the data source and defined them to build the data source views.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Developed and deployed SSIS packages to load data from OLTP to Data Warehouse system.
• Designed ETL packages dealing with different data sources SQL Server, CSV, Flat Files etc. and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services SSIS .
• Worked on a project to convert DTS to SSIS packages.
• Used SQL Server Agent to automate the SSIS 2005 package execution.
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access, and SQL Server using SSIS 2005 and then created reports using this data using SSRS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2005.
• Tested and managed the SSIS 2005 and SSIS 2005 packages and was responsible for its security.
• 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.
• Involved in optimized exciting stored procedures and improving performances.
• Developed reports using efficient data retrieval techniques and tested the reports.
• Created Cross-Tab, Drill-down and Sub-Report using SSRS 2005.

Tools Technologies:

MS SQL Server 2005, MS SQL Server Reporting Services, MS SQL Integration services, T- SQL, Erwin, MS Excel, MS word, Visual Studio 2005, MS Visio.

Confidential

Junior SQL Server Developer

Responsibilities:

• Created and maintained database objects.
• Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic using TSQL.
• Created various reports using MS Reporting Services.
• Assisted in writing and optimizing complex SQL Queries.
• Analyzed the existing application programs and tuned SQL queries using SQL Profiler.
• Involved in writing scripts for the programs.
• Loading data from various data sources using MS Data Transformation Services.
• Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general trouble shooting.
• SQL performance tuning by modifying SQL or adding/changing indexes.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML etc.
• Wrote and integrated stored procedures to generate the reports.
• Provided on-call support for various projects.

Environment: SQL Server 2000, Sybase, DTS, Excel, MS Access 2000, ASP, MS SQL Reporting Services.