SQL Server Developer Available Immediately

[Rizwan Khan]

Swapnil
219.561.7114
swapnil.b...@gmail.com



Summary
• 7 years of experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC), using MS SQL Server 2008/2005 DTS/SQL Server Integration, Reporting
• Extensive experience with SQL Server 2000/2005/2008/2008 R2
• Experienced and proficient in various phases of Software Development Life Cycle (SDLC) such as Requirement Capturing & Analysis, Design, Code construction, Implementation, Software Release/Deployment and Post Deployment Support.
• Experience in Telecommunication and Insurance sectors.
• Expertise in SQL Server 2005 Development, SSIS Packages
• Expert in using tools like SQL Profiler, Index tuning Wizard for optimal performance of MS SQL Server
• Proficient in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS with MS SQL Server 2000/2005/2008
• Expert in developing SSIS packages to Extract, Transform and Load (ETL)/DTS data into the data warehouse database from various heterogeneous databases like Oracle, DB2, Sybase, Excel, Access etc.
• Good knowledge in developing and implementing Replication models using different replication techniques like Snapshot, Merge, Transactional.
• Hands on experience in installation, configuration, performance tuning, optimization in SQL Server 2008/2005.
• Experienced in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, and User Defined Functions.
• Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Skilled in Business Intelligence tools like SQL Server 2005 Integration Services (SSIS), Reporting Services (SSRS)
• Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server 2005 using SSIS tools like Import and Export Wizard, Package Installation and BIDS.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent
• Extensive experience in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, and Chart reports using SQL Server Reporting Services.
• A well-organized, goal-oriented, highly motivated and effective team leader/member with excellent analytical, troubleshooting, and problem solving Skill.
• Excellent Verbal & Written Communication skills and strong in Documentation.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.




Skills Profile
Operating Systems: Windows NT/95/98/XP/2000/2007 Server 2003, UNIX 4.0
Databases: MS SQL Server 2000/2005/2008/2008 R2, Oracle 8i/9i, MS Access
ETL Tools: DTS (Data transformation services), SQL Server Integration Services (SSIS)
Database Tools: SQL Profiler, SQL Query Analyzer, DTS Import/Export, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, Visual Source Safe.
Skills and Languages: Transact SQL (T-SQL), VB Script, .Net
Reporting Tools: SQL Server Reporting Services (SSRS), MS Excel





Professional Experience
Nationwide Insurance - Columbus, OH March 2012 – Till Date
SQL Server SSIS SSRS Developer
Project Abstract:
ECIM is Enterprise Customer Information Management.
ECIM is a consolidated view of the customer and allows Nationwide to take advantage of enhanced selling capabilities, such as active marketing, cross-enterprise business models and cross sell analysis. Additionally, ECIF facilitates seamless delivery across multiple products and customer touch points and differentiates customer services based on a customer’s relationship with Nationwide.

Responsibilities:
• Onshore Lead - Coordinate with Onshore and offshore teams.
• Involved in gathering Business Requirement after interacting with the Manager and
development team to build up a solution to implement in SQL Server.
• Installed and configured SQL Server successfully.
• Creating Store Procedures to retrieve data from the database and use those stored procedures to build reports as per the business requirements
• Incorporating user defined functions in queries and stored procedures as needed.
• Implement Complex business logic with User-Defined-Functions and Index.
• Writing complex queries using multiple joins over tables across the database.
• Debugging code and optimizing the performance of SQL Queries to increase efficiency and reduce cost in query execution plan.
• Maintain data integrity by performing validation checks.
• Fine tuning of database objects and server to ensure efficient data retrieval.
• Built mock up reports using MS excel and MS Power Pivot which were used for building the SSRS reports.
• Debugging stored procedures and troubleshooting database issues.
• Monitor performance and optimize SQL queries for maximum efficiency.
• Loading data from different instances using SQL queries for mock up reports.
• Extensive use of SSIS in extracting data across multiple servers, performing various manipulations and then loading them into downstream databases.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Deployed packages on different servers by configuring it.
• Used System tables, System Stored Procedure, DBCC commands for Database maintenance.
• Generating reports using global variables and expressions.
• Developing drill through and drill down reports as per the report requirements.
• Modifying the SSRS reports to enhance their visual representation.
• Creating several Complex Reports (sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas, summarized and conditional formatting) using SSRS.
• Developing Stored Procedures and Views to be used to supply data to the reports. Also use complex formulas to show derived fields and to format the data based on specific conditions.
• Quality analysis of reports built by different team members and troubleshooting errors before deployment for testing through continuous interactions with Business Analysts.
• Loading business events for validation using complex CTEs.
• Frequent Client interaction regarding various new business requirements and active participation towards implementation, testing, and deployment.
• Used different tasks, transformations, containers and source/destination components to
create SSIS packages.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy
• Lookups, Lookups.
• Developed SSIS packages using various transformations such as Conditional Splits,
• Fuzzy Look Ups, Aggregations, and Multicasting.
• Extract data from access, excel, flat file, and different data base and load in SQL data
base Using SSIS packages.
• Involved in development of complex stored procedures, functions, triggers and performance tuning of various DB objects
• Working on Infrastructure issues faced by team
• Installation of DB2, IBM MQ, WAS server on local machine.
• Validating the SQL code written by offshore team with Client.

Environment:
MS SQL Server 2008, MS SQL SSRS, MS SSIS, MS Access, MS Power Pivot.






Western Heritage Insurance - Columbus OH March 2011 – March 2012
SQL Server SSIS SSRS Developer
Project Abstract:
Western Heritage Insurance Company is a subsidiary for Nationwide Insurance. Project was to migrate from Documentum to Tridion (Web content Management tool). Tridion helps WHI in taking advantage of latest technology that it offers for its clients.

Responsibilities:
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Created complex SQL stored procedures using Microsoft SQL Server 2008 and 2008 R2.
• Continuously interacted with Business Analysts and end users to gather business requirements.
• Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.
• Developed processes to extract the source data and load it into the data warehouse after cleansing, transforms and integrating.
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Extensively involved in designing the SSIS packages to export data of heterogeneous data (like XML, Excel, CSV, PGP, Flat file) source to staging tables in SQL Server Database.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, and Term extraction, 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.
• Developed Tablix Reports, Sub Reports, Matrix Reports, Charts, and Drill down reports, Ad Hoc reports using SQL Server Reporting Services (SSRS).
• Created Tabular, Charts and graphs as per customer requirements Using SSRS.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Worked on Dashboards using SSRS.

Environment:
MS SQL Server 2005/2008, MS SQL SSRS, SSIS, Visual SourceSafe, Windows 2003 Advanced Server.






Sprint Telecom - Kansas City, KS Aug 2007 – Mar 2011
SQL Server BI Developer
Technology:
• C#, Sql Server 2005, ASP Web Services, Windows Service, IBM MQ, XML, SSIS Packages, SSRS

Project Abstract:
• CAPT (Cable Automation Provisioning Tool) Application is an automatic provisioning system which takes order from cable partner and processes it. CAPT receives order through SB service broker and drop order to CAPT DB for provisioning. Orders are passed through various provisioning group for validation. Validations are done via DB Jobs, SSIS packages or windows services.
• Once Validation is complete on order, a notification is sent to cable partner for installation/disconnection of order.
• The CAPT system consist of one web application, 2 web services, 1 reporting site, 3 SSIS packages and 15 windows services.

Web Applications:
• Web Application is used to display validation order, web application is also used by various provisioning group to process certain type of order.

Reporting Site:
• Reporting services are used to provide various order reports to Cable partners.
Example – CP Order report, Detail order report etc

Web Services
• Web services are used to receive order from different cable partners and store them in database.(TWC, SPMP)

SSIS Packages
• SSIS Packages are used to perform validation on orders and to communicate with sub systems. (VDC, CIS, NENA)

Windows Services
• Windows services are used to perform validation on order with various downstream systems. (CASA,CEAS, NMS etc)


Responsibilities:
• An Active team member as well as the owner of win services and BI Module (SSIS & SSRS).
• Involved in the Business Requirement Analysis, Design and Coding.
• Created SSIS packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2008.
• Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.
• Performed root cause analysis and corrective action planning with business areas as indicated by data and/or trends.
• Configured XML config. files (.dtsconfig files) to change properties of packages dynamically.
• Used highly complex T-SQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.
• Used multiple join statements to retrieve data from several tables.
• Deployed .rdl files to the report manager
• Involved in defining Referenced Relationships with the measure groups and fact tables
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Created data source views for different security reasons.
• Responsible for scheduling the jobs to streamline and automate cumbersome repeated tasks.
• Developed Inventory and financial reports for different versions like Semester, Quarter and Year using SSRS.
• Developed different kinds of reports like tabular, drill down, drill through, charts, and web receiving reports using SSRS.
• Involved in development of complex stored procedures, functions, cursors and triggers and performance tuning of various DB objects.
• Involved in development of various mid level and advanced level SSIS Packages.
• Created SQL Server Reports using SSRS.
• Identified the Data Sources and defined them to build the Data Source Views.
• Developed Query for generating drill down/drill through reports in SSRS.
• Developed, monitored and deployed SSIS packages.
• Involved in the development of custom stored procedures, functions.
• Involved in the optimization of SQL queries which resulted in substantial performance
improvement for the conversion processes
• Resolving Production issues reported by client.
• Providing development support during migrations and releases to Production.
• Maintained the client relationship by communicating the daily statuses and weekly
Statuses of the project.
• Coordinating with the onsite team.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment:
MS SQL Server 2005, SSIS, SSRS, MS Excel, Windows 97/2000/XP, Toad.






HDFC Bank, Hyderabad, India June 2006 – July 2007
SQL Server Developer
HDFC Bank is India's largest private sector bank by market capitalization and second largest overall in terms of assets. Bank has total assets of about USD 77 billion, a network of over 1,400 branches, and 24 million customers. Worked on retail collection system, a GUI based client/server bill collection software, to assist brokers in carrying out their daily transactions. Upgrade from MS SQL Server 7.0 to 2000.

Responsibilities:
• Involved in requirements gathering, analysis, design, development, change management.
• Developed backup restore scripts for SQL Server as needed.
• Upgraded to latest version from SQL server 7.0 to 2000.
• Written various stored procedures for the purpose of application development.
• Tuned SQL statements (Using Indexes) and Stored Procedures.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Disaster recovery and database maintenance plan.
• Replication of data using Transactional method.
• Data conversion from Text File into SQL Server Table.
• Created constraints and validated database integrity.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Job scheduling and alerts.
• Designed and implemented user log in and security.
• Extracted Data from MS Access and Oracle.
• Created many complex Stored Procedures / Functions and used them in Table Reports.
• Creating reports and hosting it in the web for the users.
• Created reports for the senior management.
• Successfully tested all the stored procedures on SQL 2000 server.

Environment:
SQL Server 2000, T-SQL, SQL Server 2000 Reporting Service, VSS, Windows 2000 Server, Enterprise Manager, Query Analyzer, SQL Profiler, Crystal Reports.




Education
• Bachelor of Engineering in Computer Technology