PROFESSIONAL SUMMARY:

• 9+ years of experience in IT as Sr. MS SQL Server Developer working in various domains such as Finance, Insurance and Healthcare in 2012/2008R 2/2008/2005/2000 Windows Environment.
• Extensive experience in T - SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) creating Design, Development, Testing, Implementation and Production/Support phases of SDLC for Data Warehouse, Client/Server, RDBMS and Web Based Application working in Agile, Waterfall, RUP environment
• Expertise in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Data Transform Services (DTS), Bulk Insert, BCP.
• Experience in building robust Architecture to organize Data flow from various homogeneous and heterogeneous system using SQL Server Integration Services (SSIS) and Data Transform Services (DTS).
• Expertise in upgrading/migrating from DTS to SSIS packages, resolving complex issues and Error Handling in SSIS.
• Extensive experience in Tuning SQL queries and improving the query performance.
• Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective experienced in implementation of strong referential integrity and auditing by the use of triggers and SQL Scripts.
• In-depth experience of Transact-SQL (DDL and DML) operations.
• Experience in optimizing the database by creating various Clustered, Non-clustered indexes.
• Expert in creating Chart reports, Drill down and Drill through Reports by passing parameters in SQL Server Reporting Services (SSRS).
• Expert in Database Normalization, DE normalization, Optimization and Tuning, Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled DTS and SSIS Packages.
• Good experience in Developing and Extending OLAP Cubes, Dimensions and data source view and designing, creating, processing of cubes using SSAS.
• Expert in calculating measures and dimension members using multidimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experience in creating reports using SSRS (SQL Server Reporting Services), Crystal Reports, SSAS (SQL Server Analytical Services) objects and OLAP including Interfaces with BIDS (Business Intelligence Development Studio).
• Experience in designing Database Models using MS Visio and Erwin Data Modeler.
• Experienced in planning and implementing MS SQL Server Security and database Permissions.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Design and build executive ready reports and dashboards from SharePoint in SSRS
• Design and build additional features such as Charts
• Assist in quality assurance testing to establish reports validity

TECHNICAL SKILLS:

• MS SQL Server 2012/2008R 2/2008/2005/2000/7.0
• MS SQL Server 2008/2005 Analysis Services (SSAS)
• MS SQL Server Integration Service (SSIS)
• MS SQL Server Reporting Services (SSRS)
• Business Intelligence Development Studio (BIDS)
• BCP
• SQL Profiler
• Enterprise manager
• Management studio
• Microsoft Access 2000
• ERWIN 4.0/4.1/4.2/7.2
• Microsoft Visio 10.0/11.0
• T-SQL
• ASP.NET
• C#
• VB.Net
• HTML
• XML
• XSL
• Oracle 11g/10g
• Visual Studio.NET
• VB.NET
• Crystal Reports 8.5/9/10/11
• TFS
• Visual source safe 2005
• MS office 2007/2003
• Windows 2008/2003/2000 Advanced Server/Professional.

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

SQL/ SSIS/ SSRS Developer

Responsibilities:

• Involved Automation of Back Office project and Migration of SQL.
• Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server T-SQL stored procedures within SQL Server 2012 environment.
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS.
• Created Position and Transaction OLAP Cubes for mortgages Loans for various measure groups and dimensions (Loan Position, Commitment Schedule, Loan Journal Entry, Loan journal Entry Period Zero, Time Period, Loan, Account, Portfolio, Property, Business Unit, Borrower, Journal Entry Demographic, Journal Entry Line Item etc. ) to address the business needs using SSAS
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Integrated SQL server reporting services with ASP.Net to view generated reports in Crystal reports.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Tools: & Technologies: MS SQL Server 2008R2, T- SQL, MS Excel 2010/2007/2003, Microsoft SQL Server Integration Services (SSIS) 2008R2, Microsoft SQL Server Reporting Services (SSRS) 2008R2, Microsoft SQL Server Analysis Services (SSAS) 2008R2, Crystal Reports, SQL Server Business Intelligence Development Studio, Star Team Version Control tool), Erwin 8.0/MS Visio 2010

Confidential, Richmond, VA

SQL/ SSRS/ SSIS/ SSAS Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
• Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
• Developed, monitored and deployed SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Full load & Incremental load with several Data flow tasks and Control Flow Tasks using SSIS.
• Created Position and Transaction OLAP Cubes for mortgages Loans for various measure groups and dimensions (Loan Position, Commitment Schedule, Loan Journal Entry, Loan journal Entry Period Zero, Time Period, Loan, Account, Portfolio, Property, Business Unit, Borrower, Journal Entry Demographic, Journal Entry Line Item etc. to address the business needs using SSAS
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

Tools: & Technologies: MS SQL Server 2012, T- SQL, Power pivot, MS Excel 2007/2003, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Services (SSAS),SQL Server Business Intelligence Development Studio, Team Foundation Server (TFS), Visual Source Safe (VSS), Erwin 8.0/MS Visio 2010

Confidential, Columbia, MD

SQL/ SSRS/ SSIS Developer

Responsibilities:

• Worked with Business Analyst and Business Users in requirements gathering phase actively cataloging and supporting various issues and providing their solution.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel Spreadsheet, Flat Files and OLEDB Sources.
• Performed Data cleansing by creating tables to eliminate the dirty data using SSIS.
• Involved in performing incremental loads while transferring the data OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Used various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Use ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Created packages in SSIS with error handling
• Worked with different methods of logging in SSIS.
• Designed & Supported daily, weekly, monthly batch processes using SQL Server Agent.
• Responsible for creating database objects like table, views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized table, established joins and created Clustered, Non-Clustered indexes whenever necessary.
• Generated various kinds of reports such as Patient History, Physical Examination Report, Consultation, Operative, Radiology, Pathology, Laboratory, Emergency reports and complex SOAP (Subjective, Objective, Assessment, and Plan) reports using SSRS 2008R2 from SQL Server 2008R2 Database (OLTP) and SQL Server Analysis Services (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Deployed and configured the reports in the Report Server.
• Involved in identifying and creating Data Sources and Data Source Views (DSV) in SSAS.
• Involved in creating relationships and hierarchies between attributes and measure groups and defined granularity within the measure group and drill through action using SSAS.
• Created and managed users, roles and groups and handled cube security.

Tools: & Technologies: MS SQL Server 2008R2, T- SQL, MS Excel 2010/2007/2003, Microsoft SQL Server Integration Services (SSIS) 2008R2, Microsoft SQL Server Reporting Services (SSRS) 2008R2, Microsoft SQL Server Analysis Services (SSAS) 2008R2,SQL Server Business Intelligence Development Studio, Star Team Version Control tool), Erwin 8.0/MS Visio 2010

Confidential, Sacramento, CA

SQL Server/ BI Developer

Responsibilities:

• Involved in gathering Business Requirement after interacting with the Manager and development team to build up a solution to implement in SQL Server 2008.
• Filtered and cleansed dirty data from legacy system using complex T- SQL statements in staging area, and implemented various constraints and triggers for data consistency.
• Created SSIS package to load data from Flat File to Flat File and Flat File to SQL Server using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot and Un-pivot Transformation.
• Successfully migrated old data from legacy systems (FoxPro) and external system including excel and oracle into SQL Server 2008 using SSIS Packages.
• Created scripts to verify and reconcile the migrated data from legacy system to SQL Server.
• Developed complex Stored Procedures to process prospective customer information and balanced the processing load between front end and back end.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Designed the Forms, templates & created Reports using SSRS 2008 reporting services.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Performed Unit testing for the screens and code in Visual Basic .NET and SQL Server 2008.

Tools: & Technologies: SQL Server 2008, Oracle 9i, T-SQL, Excel, Access, Report Builder 3.0, Windows Server 2003, Visual Basic .Net, Query Analyzer, SQL Server Profiler, Erwin 7.3/MS Visio 2007.

Confidential, Austin, TX

SQL/ SSIS/ SSRS Developer

Responsibilities:

• Responsible for the design of the SSIS package to load data into the data mart from OLTP database using ETL tools.
• Use Data Viewers in SSIS Packages to see whether the data flow properly or not.
• Provided Dynamic Configuration, Custom Package Logging, and Error Handling to SSIS template package.
• Created deployment utility to deploy SSIS Packages.
• Created various database objects including Tables, User Defined Functions, Procedures, Packages, Triggers, Indexes and Views based on user requirements.
• Developed SQL Queries to fetch complex data from different tables in remote databases using Inner/Outer joins, sub-queries, accommodating complex filters and database links.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Tuned SQL queries using Show Plans and Execution Plans for better performance.
• Provide fields mapping document, refreshed table/packages data load to UAT after delivery up on the completed data mart.
• Developed and maintained enterprise reporting (SSRS Reporting Service) based on specifications and business needs and modified existing reports as needed.
• Use temporary table to reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Created complex stored procedures to generate reports using SSRS
• Designed Reports in SSRS, using Shared data source and specified data source.

Tools: & Technologies: MS SQL Server 2008, T- SQL, MS Excel 2007/2003, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), SQL Server Business Intelligence Development Studio, MS Visio 2007.