SUMMARY:

• 10+ Years of working experience as SQL Server Database developer in Financial, Healthcare, Insurance and Telecommunication domains.
• Comprehensive knowledge and exposure to different phases of Software Development Life Cycle (SDLC).
• Master in T - SQL Programming, SQL stack including SSIS, SSRS and SSAS.
• Experienced in RDBMS concepts, DDL, DML, constructing normalized and de-normalized tables, user defined functions, complex and dynamic stored procedures, views, triggers, synonyms, cursors and Indexes.
• Expertise working on Online Transaction Processing (OLTP), Data Warehousing and Online Analytical Processing (OLAP) environments.
• Designed SQL Server database objects (tables, stored procedures, functions and views) to support outsourcing data integration (SSIS), analysis, and various business processes.
• Experience in Importing/Exporting Data from various data sources like MS Access, Excel Files, Oracle, DB2, XML Files and Flat Files using DTS utility. Involved in ETL transformation of OLTP data to the Data Warehouse implementing all transformations using SSIS and SQL commands.
• Mastery in migrating DTS packages, deploying and scheduling SSIS packages as jobs using SSIS 2005/2008 as batch process.
• Experience in installing, configuring, developing and deploying reports using SQL Server Reporting Services (SSRS). Created various reports like table, matrix and chart formats.
• Expert in Ad-hoc reports, drill down and drill through reports and cross tab reports.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users of financial and banking in SQL Server Reporting Services (SSRS).
• Experience in designing Star Schema and Snowflake Schema with Facts, Dimensions, Measures and Cubes using SSAS for enterprise and insurance domains.
• Modified existing OLAP cube to extract historical data to support healthcare cost utilization analysis and actuarial reporting (SSRS).
• Developed strategic database architecture plans and data modeling for Oracle, SQL Server and Sybase databases.
• Extensive experience in agile software development and SCRUM methodology.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other tasks using SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Tuning poorly performing queries, long running queries by capturing the events through Profiler.
• Knowledge of high availability SQL Server solutions, including Log shipping, Replication and SQL Server clustering.
• Experience in the Installation, Registration, Configuration, Database Backup/Recovery and Disaster Recovery procedures for MS Server 2000/2005/2008
• Experience in creating semantic layer data modelling for business analysis.
• Designed and documented reporting and information management strategies for various industrial, financial, healthcare and insurance domains.
• Effective working as individual or as a cooperative team member with good communication and interpersonal skills.

TECHNICAL SKILLS:

Databases: MS SQL Server 2014, 2012/08/05, 2000, MS-Access, Sybase, Oracle, MySQL, DB2, Teradata

Languages: T-SQL, PL/SQL, XML, HTML, C, C++, ASP.Net, C#.Net, Java Scripting

Server Tools: SSMS, SQL Profiler, Query Analyzer, Export & Import, DTS, Replication, SSIS, SSRS, SSAS, Management Studio, Tableau Reporting Services, PowerPivot, Team Foundation Server(TFS).

Operating systems: Windows XP/NT/2000, UNIX, DOS, Windows Server 2003

Portal Server: MOSS 2007, SPS 2010, SPS 2003, WSS 3.0

Tools: Microsoft Visual Studio 2003/2005/2008, MOSS2007, Informatica, Erwin Tableau, Cognos, Microstratergy, Power BI, SQL Server Data Tools.

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Sr. Data Engineering/Analyst/ BI Developer Lead

Responsibilities:

• Installed and Configured DB2 and SQL Server 2012 along with SQL Server Data Tools(SSDT).
• Developed SSRS reports by migrating data from DB2.
• Data Engineered the Employee Claimant Services (ECS) Application issues.
• Analyzed the application reporting data and developed the DB2 scripts to fix the issues.
• Created subscriptions in Report Manager as an automated process to deliver the reports directly to the client (end user) as an email attachment.
• Deployed all SSIS packages and batch process to Production environment and modified the package according to the business rules.
• Migrated data from Heterogeneous Data Sources and legacy system DB2 to SQL Server databases using SQL Server Integration Services.
• Tested, Cleaned and Standardized Data to meet the business standards.
• United tested all the scripts, reports and packages.
• Created user stories based on the data analysis in rally.
• Used Query Analyzer to optimize SQL Queries and shortened lengthy queries.
• Created SQL server Tables and Developed Stored Procedures and user defined functions those are required for the front-end applications.
• Developed and Deployed reports/report model using SQL Server Reporting Services.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Written Technical Requirement Documents for User Stories.

Environment: SQL Server 2012, DB2, T-SQL, SSIS, SSRS, Windows 7, Rally, SQL Tool.

Confidential, Bowie, MD

Sr. SQL Data/Report Analyst Lead

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source system to destination system.
• Actively involved with Directors, VP, managers and other Business Analysts to discuss the current business and future implementations.
• Work on projects like Hix Ecaas, Ecass Advantage and Indices to generate the reports.
• Performed duties including the Data Checks and validations.
• SSIS ETL tool is used for data migration, import and export of various forms of flat and xml files that provided by the clients.
• Performed various SSIS data transformation and scripting tasks for data cleansing, encrypting, decrypting sensitive information.
• Advanced the data analysis and reporting skills using SQL server Data Tool 2012 (SSRS) and Tableau Desktop.
• Designed and created Report templates and Adhoc reports based on the Commercial Healthcare data.
• Developed various types of Complex reports like Drill Down and Drill through reports for Dashboards.
• Created SSRS reports in with different type of properties like chart controls, filters, Interactive Sorting, parameters etc.
• Created Business Analysis Dashboards using Tableau Desktop.
• Created semantic layer for business representation of client data to helps end users access data using common business terms.
• Developed SQL Scripts for the Online Editing Application for the Client interface.
• Performed the optimization, Tuning of the indexes and the queries.
• Experience with HIPAA and CMS Commercial Data Guidelines to Edge Server Submissions.
• Analyzed and developed Reinsurance discrepancy reports based on CMS.
• Deployed all the reports and documents to SharePoint and TFS.

Environment: SQL Server 2008R2/2012, Windows Server 2007, T-SQL, SSIS, SSRS, SQL Profiler, Visio, MSO SharePoint 2007/2010, Tableau Reporting, TFS.

Confidential, Baltimore, MD

Sr. SQL Data/Report Analyst

Responsibilities:

• Interacted with Directors, VP and other Business Analysts to discuss the current business and future implementations
• Performed duties including the monitoring and maintenance of database software upgrades, backups, migrations, standardization and implementation of databases to improve the management of production and test environments.
• SSIS ETL tool is used for data migration, import and export and for generation of various forms of flat files that required for the business.
• Various SSIS package where developed and processed and schedule jobs through Server Agent
• Created jobs, alerts to run SSIS packages, SSRS reports periodically.
• Developed various SSIS templates for heterogeneous data migrations.
• Retrieved and analyzed data using T-SQL, Excel, SSRS
• Developed multiple processes for Daily Reports using SSRS, Tableau and PowerPivot.
• Created various ad hoc report to meet the daily business requirement and for analysis purpose.
• Migrated and Integrated SSRS report with SharePoint 2007/2010.
• Created semantic layer for business representation of client data to helps end users access data using common business terms.
• Coordinated with Program Manager and Assistant Program Manager to ensure problem resolutions.
• Documented and placed all the methodologies for end user reference in SharePoint and TFS.

Environment: SQL Server 2000/2005/2008 /R2/2012, Windows Server 2003, Erwin, DTS, T-SQL, SSIS, SSRS, SSAS, SQL Profiler, Visio, MSO SharePoint 2007/2010, Tableau Reporting, PowerPivot, TFS.

Confidential, Baton Rouge, LA

SQL BI Tech Support / SQL DBA

Responsibilities:

• Interacted closely with Director of IT Revenue, Manager of Business Production Team, Vice president of Business Reporting Team, Business Analyst, Project manager and gathered and Peer Reviewed the Business Requirements, Software Requirement, Developing, Testing and Maintenance of data warehouse database, processes and services.
• Developed multiple processes for Monthly Reports using SSIS and MS Excel.
• Created SSIS packages to load data from different sources like Excel, Access and SQL Server.
• Written T-SQL scripts to meet the business logic and requirements and supported the reporting team, troubleshoot and cleared the issues.
• Re-designed the Reporting process by creating new Databases and Schemas.
• Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2008 database and performed tuning on it.
• Collected all the specs from different reporting team and develop the new process.
• Developed performance efficient stored procedures and transact SQL queries to pull the data into reports.
• Experience with AGILE Methodologies.
• Developed SSRS report to ASPX web applications using SQL Server Reporting.
• Used Reporting Services Subscriptions(SSRS) to schedule reports to be generated on predetermined time.
• Created datasets using stored procedures and reports using multi value parameters.
• Tuning the database servers, when the user reports that a particular region is running slow.
• As per the client requirements, rendered the Reports in the form PDF, Excel and .CSV formats
• Documented all the process with detailed Business Logic.

Environment: SQL Server 2008, Windows 7 Enterprise, T-SQL, ASP.NET, SSIS, SSRS, SQL Profiler, MS Excel, MS Access.

Confidential, Richardson, TX

SQL BI Developer

Responsibilities:

• Implemented various ETL process by using SSIS, Informatics and ODBC tools.
• Generated reports using SSRS that could be used to send information to diverse group of users.
• Developed ad-hoc reports using Report Builder.
• Developed Report Model so that the end users can create their own reports using Report Builder.
• Developed various kinds of interactive reports like Drill Down, Cascading Parameters, Sub reports, Charts and Graphs reports.
• Developed reports using SSRS and published as PDF formats. Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Tuning the database servers, when the user reports that a particular region is running slow.
• Deployed and processed SSIS Packages and SSRS Reports weekly to update information (As per business logic) by using SQL Server Agent and windows Scheduler.
• Created jobs, alerts to run SSIS packages, SSRS reports to processes automatically.

Environment: SQL Server 2005/2008, Windows Server 2003, T-SQL, SSIS, SSRS, SQL Profiler

Confidential, Dallas, TX

SQL BI Developer

Responsibilities:

• Installed and Configured Oracle 9i, DB2 V8, Teradata and SQL Server 2005 along with SQL Server Business Intelligence Development Studio in new server.
• Migrated SSRS 2005 reports to SSRS 2008
• Created subscriptions in Report Manager as an automated process to deliver the reports directly to the client (end user) as an email attachment.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Converted Informatica mappings to SSIS packages using MS BIDS.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services.
• Migrated DTS packages to SQL Server Integration Services and modified the existing packages by using the advanced features and tools
• Used Query Analyzer to optimize SQL Queries and shortened lengthy queries.
• Developed and Deployed reports/report model using SQL Server Reporting Services.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Environment: Informatica Power Center 8.1 (Source Analyzer, Warehouse Designer, Transformations Developer, Mapplet Designer, Mapping Designer, Workflow Manager) Worklets, SQL, Oracle 9i, DB2 V8, Tera Data, MS SQL 2005/2008, T-SQL, SSIS, SSRS, Windows NT.

Confidential

Business Intelligence/ SQL Developer

Responsibilities:

• Participating in weekly Systems and DB Meetings and updating the Project status to the Project Manager.
• Analyze d business requirements and build logical data models that describe all the data and relationships between the data
• Created & scheduled SSIS packages from OLTP to various data warehouses. Also Migrated SQL 2000 DTS packages to SSIS packages
• Generated reports using SSRS that could be used to send information to diverse group of users.
• Knowledge in documentation of backup and recovery strategies for production environment
• Developed various revenue reports using reporting service (SSRS) as required.
• Involved in troubleshooting of existing SSIS Packages.
• Worked on SSIS Packages, changes Structure of tables and created new Columns during transformation using SSIS packages.
• Created and monitored the jobs to perform tasks such as database cleaning, backups, data loading.

Environment: MS SQL Server 7.0/2000/2005, Windows 2000 Server, Windows NT Server, TSQL, SQL Server Query Analyzer, SSIS, SSRS