SUMMARY

• 7+ years of IT experience in Database Development, Design, Analysis, Support of MS SQL Servers 2008, 2005, 2000 in Development, Testing and Production Environments with various business domains.
• Hands on experience with features and functions of Microsoft SQL Server 2012.
• Experience on data migration from SQL Server .
• Expertise in scripting T - SQL queries, Complex Stored Procedures, User Defined Functions (UDF), Database Triggers, using tools like SQL Profiler and Database Tuning Advisor (DTA).
• Used Sub-Queries and Joins to simplify complex queries involving multiple tables.
• Expertise in creating, maintaining database objects like Indexes, Functions, views, Triggers, UDF’s, constraints.
• Hands on experience in Performance tuning and query optimization including updating statistics, rebuilding and re-organizing indexes.
• Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
• Experience in bulk importing CSV, XML and Flat files data using Bulk copy program BCP.
• Experienced in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Very Strong skill in building and using CTE’s (Common table Expressions) for building recursive queries.
• Experience in Monitoring, Job Scheduling, Troubleshooting, Back Up, recovery and system upgrading.
• Closely working with category for implementation master data management (MDM) of new products, customers and vendors.
• Very strong implementation of Microsoft Business Intelligence(BI) platforms including SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS) and Microsoft office SharePoint Server 8 in SQL Server 2005/2008.
• Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Experience in Error handling, Debugging, error logging for production support in SSIS.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTSand SSIS services.
• SQL Server 2008/2005/2000 OLAP database development including KPIs, Data mining, working with changing dimensions.
• Performed Logging and Deployment of various packages in SSIS.
• Experienced in enhancing and deploying the SSIS Packages from development server to production server.
• ETL implementation using SQL Server Integration Services (SSIS), Reporting Services (SSRS).
• Developing reports on SSRS on SQL Server (2000/2005/2008 ).
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Implemented parameterized, cascading parameterized, drill-down, drill-through and sub-reports using SSRS.
• Involved in migration and conversion of Reports from Crystal Reports to SSRS 2008R2.
• Developed ad-hoc reports using Power Pivot.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Experienced in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Experienced in Creating and Updating Statistics to improve the SQL Server Performance.
• Good knowledge Database Console Commands (DBCC).
• Experienced in managing Data and Transaction log files, Files Groups.
• Experienced in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
• Experienced in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.

TECHNICAL SKILLS

Relational Databases: SQL Server 2012/2008R 2/2008/2005/2000 , MS Access.

Tools: and Packages SQL Server Management studio, SSIS, SSRS, SSAS, DTS, Microsoft Visual Source Safe, SQL Query Editor, TFS

Languages: T-SQL, HTML, PL/SQL, XML, SQL, C, VB.Net, ASP.Net

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS

Web Technologies: HTML, XML, XSL, IIS (4.0/5.0/6/0)

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), Performance Point Server 2007

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

SQL Server SSIS/SSRS Developer

Responsibilities:

• Worked closely with client to understand the business requirements, data analysis and identify final deliverables.
• Extensive work in SSRS, SSIS, MS SQL Server, SQL Programming and MS Access.
• Created database objects like Tables, Stored Procedure, Functions, Triggers, etc.
• Created complex Stored Procedures using Linked Server, CTE, Temp Table, SQL Joins etc.
• Responsible for performing T-SQL tuning, multi-tasking and optimizing queries which takes longer time in execution with SQL Server 2008/2012.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2008/2012.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Extensively designed the packages and data mapping using Control flow task, Sequence Container, For Each Loop, Sequence Container, Dataflow Task, Execute SQL Task, File System Task and Script Task in SSIS Designer.
• Built SSIS packages, to fetch file from remote location like FTP and SFTP, decrypt it, transform it, mart it to data warehouse and provide proper error handling and alerting.
• Extensive use of Expressions, Variables, Row Count in SSIS packages
• Data validation and cleansing of staged input records was performed before loading into Data Warehouse.
• Performed Data reconciliation, validation and error handling after Extracting data into SQL Server.
• Automated the process of extracting the various files like flat/excel files from different sources like FTP and SFTP (Secure FTP).
• Analyzed code to find causes of errors and revise programs as needed.
• Fixed data issues and bugs by changing code or business rules. Troubleshoot import function/daily feed file failure.
• Developed email automation job.
• Assess detailed specifications against design requirements.
• Developed reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Designed cube to analyze the claims based on the regions and come up with future premiums.
• Performed Unit testing and Integration testing for various modules.
• Ability to analyze and resolve performance issue with database code involving SSIS and MS SQL Server 2008\2012.

Environment: MS SQL Server 2008/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Service (SSAS), Share Point, Visual Safe Source, FTP, SFTP, MS Access and Windows 2012 Server

Confidential, New York, NY

MSBI Developer (SSMS, SSIS, SSAS, Tableau)

Responsibilities:

• Analyzed and reviewed business requirements and interacted with Business Analyst.
• Worked with Project Manager in estimating and planning the Project delivery.
• Used T-SQL in SQL Server 2012 to develop Stored Procedures, User-Defined Functions (UDFs), Indexed Views, and DML Triggers to support ETL packages.
• Gathered requirements from Marketing department, Human Resource Department, and provided the functional and text reports.
• Extracted, reviewed and transformed monthly data from various data sources (Excel, SQL Server, Flat File) by creating various SSIS packages.
• Troubleshot and debug ETL packages using breakpoint and checkpoint to facilitate stability and reusability; use XML configuration and SQL Server table configuration to prepare deployment-ready packages.
• Utilized ETL Tools such as SSIS to implement process chain which automates data cleaning and loads data from staging area into database.
• Deployed & configured ETL packages and coordinated with DBAs to schedule the package in SQL Server Agent to run the packages every month and run reconciliation queries to cross-check the data.
• Involved in fine-tuning the code of Stored Procedures in SQL Server and ETL Packages in SSIS to obtain optimal performance.
• Mastered creating the OLAP cubes using various dimensions and creating SSAS projects.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards to Tableau application.
• Created best visualizations reports as per the business requirements using Tableau Desktop professional edition. Blended data using multiple data sources (primary and secondary)
• Using Alteryx to blend the data from different sources and prepare for generating reports.
• Developed dynamic GL reports: Gross Margin, Net Revenue, Operating Expenses, Summarized Reports based on the Profit Territories etc., using SSRS and Tableau. Ran the reports every month and distributed them to respective users through mailing server subscriptions and SharePoint server.
• Developed Invoices Reports, Expenditure Trend Analysis Reports, and Asset Depreciation Reports using Tableau for top management.
• Developed Operational Financial Reports (i.e. operational income & expenditure trend analysis, AR/AP, inventory turnover reports) using Tableau.

Environment: SQL Server Management Studio (SSMS) 2012/2008 R2, Server Integration Services (SSIS), Alteryx, SQL Server Data Tools (SSDT), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), T-SQL, Microsoft Excel 2010, Teradata, Oracle 9i/10g, Tableau Desktop 7.0/8.0, Tableau Server.

Confidential, Rockville, MD

Sr. SQL Server/BI Developer

Responsibilities:

• Worked with various upstream and downstream customers in interfacing various systems and processes for Data extractions, ETL, Analytics and reporting needs.
• Point of contact for all the Data processes, Data Mappings, Data dictionaries, Data pulls and Reporting solutions.
• Creating packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local databases to facilitate reporting operations.
• Performing Data source investigation, developed source to destination mappings and data cleansing while loading the data into staging/ODS regions.
• Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
• Applied various data transformations like Lookup, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Creating SQL Server Agent Jobs to maintain and run various SSIS packages periodically or as scheduled.
• Worked on Key Performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SQL Server Analysis Services (SSAS).
• Loading the Fact and Dimension tables.
• Querying, creating stored procedures and writing complex queries and T-SQL joins to address various reporting operations and also random data requests.
• Created Drill-through reports, parameterized reports and linked reports using SSRS 2005 and 2008 and were integrated in the Performance point server.
• Generating various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using SQL Server Reporting Services (SSRS) for various in-house users and also for reinsurers and producers.
• Creating and maintaining various subscriptions in the Report Manager for the reports.
• Creating custom forms using MS Access to facilitate user data requests on demand.
• Developing products by determining what competitors are doing, risk assessments, ratings assessments, pricing and coverage.
• Developing materials and underwritings.
• Involved in User communication for requirement gathering and Change control and code control policies and procedures.

Environment: MS SQL Server 2012/2008/2005 , SQL Server Reporting Services (SSRS) 2012/2008, SQL Server Integration Services (SSIS) 2012/2008/2005 , SQL Server Analysis Services (SSAS) 2005, Share Point, MS Project, MS Access 2003/2007, VBA.

Confidential

SQL Server BI Developer

Responsibilities:

• Written T- SQL, Pl/SQL queries for data retrieval.
• Data migration from Text to SQL Server using BCP command line utility and Bulk insert.
• Reduced the T-SQL overhead and responsible for developing processes, automation of maintenance jobs, tuning SQL Server and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Fine-tuned SQL queries using hints for maximum efficiency and performance
• Tested packages and fixed bugs using SQL 2005 Business Intelligence development studio
• Developed ETL Packages using SQL Server 2005 integration services to populate data from different sources like from flat files/SQL/Oracle Server to the staging database and then into the data warehouse.
• The packages created included a variety of transformations like slowly changing dimensions, look up, aggregate, derived column, conditional split, fuzzy lookup, multicast and data conversion.
• Developed reports using SSRS 2005 and crystal reports and used table control, matrix control for cross tab reports.
• Created drill down reports using SQL Server 2005 Reporting Services and deployed the generated reports on to the server.
• Configured replication servers and transactional replication between production and standby server for disaster recovery.
• Created reports by linking data from data warehouse cubes using SQL Server 2005 reporting services.
• Wrote complex SQL queries to populate data from different tables and which can be used for reports.
• Worked on querying data and creating on-demand reports using report builder in SSRS reports and sending the reports via email.

Environment: SQL Server 2000/2005, T-SQL, MS Access 2000, Windows NT platform, SQL Server 2005 Reporting Services, SQL server Integration Services Data Transformation Services (DTS), Oracle 9i, Toad, MS Excel, Crystal Reports.

Confidential

SQL Server Developer

Responsibilities:

• Generated SQL Scripts for copying/migrating databases and database objects.
• Gathered data for validation and populate them into tables using stored procedures.
• Modified current database by adding tables, altering referential integrity and relationships to support online system.
• Extensive use of Stored procedures, writing new stored procedures and modifying existing ones and tune them such that they perform well
• Involved in designing various reports to flat files generated by the database script.
• Create Stored Procedures, Triggers, Views, joins and Functions for the Application
• Create, debug, and execute T-SQL scripts and stored procedures
• Extensively involved in error handling stored procedures
• Imported various Sources, Targets and Transformations using Transact-SQL Server.
• Used SSIS for data population from different sources and create packages for data conversions and load data from flat flies or excel files.
• Actively involved Normalization & De-normalization of database
• Extensive Testing on the Performance of the Stored Procedures.
• Worked closely with Application Developers and Business Analysts to produce all required documentation
• Identified, tested and resolved database performance issues to ensure database optimization.
• Created complex views, partition views for the application to increase the performance and reduce server load.
• Write complex T-SQL statements for retrieval of data.
• Testing the Performance of the database and fine-tuning is also done for complicated queries that take time to carry out, Analyzing and creation of appropriate indexes to optimize application performance
• Create joins and sub-queries for complex queries involving multiple tables.
• Design and create SQL Database, tables, indexes

Environment: MS SQL Server 2005, Windows 2003 Server, Transact-SQL, SSIS, SSRS