SUMMARY

• 8+ years of IT experience in Design, development & Administration of Business Intelligence Solutions with Microsoft SQL server 2012/2008/2005/2000 with various business domains like Pharmaceutical, Information Technology.
• Experience in writing Efficient T - SQL queries, Sub-queries, Dynamic queries, Stored Procedures, User Defined Functions, Database Triggers and Exception Handlers.
• Experience in creating SSIS Packages for integrating data using OLEDB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Expert in configuring and creating SSIS solutions for high performance Data Integration, Data Migration and Business Intelligence Process that includes Merging Data from various Heterogeneous Data Stores, Populating Data Warehouses and Data Marts, Cleaning and Standardizing Data.
• Experience in creating automated administrative functions such as backing up and restoring databases, copying SQL Server databases and the objects they contain, copying SQL Server objects, and loading data using SSIS.
• Experience in implementing and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables, Check Points and Expressions for SSIS Packages.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Experience in Administering SSIS packages such as Scheduling package execution, backing up and Restoring packages, Monitoring Integration Services Performance and activity, and implementing Security considerations for SSIS Packages.
• Expertise in OLTP/OLAP system study, Good experience building Star schema and Snowflake schema depending on the business data requirements.
• Experience in Deploying and Monitoring Analysis services.
• Experience in developing OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Expertise in using HIPAA(Health Insurance Portability and Accountability Act) and HEDIS (Healthcare Effectiveness Data and Information Set) to protect patient's privacy expectations under the policies and procedures.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Experience in creating Report Models for building Ad hoc reports using SSRS.
• Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Experience in Administering, Managing and Troubleshooting Reporting services.
• Worked on administration tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.
• Extensive knowledge in Tuning SQL queries, T/SQL queries and improving the performance of the Database.
• Experience in implementing different types of Replication models like Snapshot, Merge, Transactional and Peer to Peer.
• Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication, Log shipping, clustering (Active/Passive) and Database Mirroring.
• Experience in .NET/C# application development environment to use SQL Server Databases.
• Excellent communication, interpersonal and analytical skills
• Good experience in Information Technology field as a SQL server Developer with strong expertise in SQL server development, designing Stored Procedures/Transact-SQL coding.
• Excellent in High Level Design of ETL - DTS Packages & SSIS Packages - for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2012/2008/2005.
• Expert in creating complex Stored Procedures, User Defined Functions, and effective Triggers to facilitate efficient data manipulation and data integrity
• Worked very closely with Customers, End users and powered users collect requirements and training or resolve any business process related issues.
• Expertise in Database Administration operations like Backup, Recovery, Replication and using SQL Profiler and excellent knowledge of DDL and DML in T-SQL

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL. HTML, XML

Databases: SQL Server 2012/2008/2005/2000/7.0, Oracle 9i/8.x

Reporting Tools: SQL Server Reporting Service (SSRS), Power BI, Informatica

Other Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, HIPAA, HEDIS, ETL, SSMS, Configuration Manager, Enterprise Manager, Query Analyzer Profiler, SSAS, SSRS, Database Tuning Advisor, 10 BI tools (Report Studio, Analysis Studio, Query Studio,).

Other Software: MS Office- 2007/2003/2000, SharePoint

Operating Systems: Windows / 98/2000/2003/ XP/Vista, Unix, Linux RedHat 5.2/5.0/4.0

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, SQL Server Management Studio(SSMS), SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Business Intelligence Development Studio(BIDS)

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE

Confidential, NY

SQL/SSRS/SSAS Developer

Responsibilities:

• Involved in Physical / Logical design of database, creating and managing the database and all the database objects.
• Among a team of developers that successfully completed a complex data conversion project that was designed to migrate millions of records to a new system (QNXT).
• Responsible for fixing hundreds of critical defects addressed during data conversion.
• Updated mapping tables related to assigned functional areas as directed by the Business Analysts.
• Created and modified tables, views and indexes; PL/SQL stored procedures, functions and triggers according to business requirement.
• Executed SQL conversion pre-validation and post-validation scripts to avoid data loss.
• Created business reports by joining multiple tables from multiples database using complex SQL queries.
• Responsible for debugging, troubleshooting, and tuning PL/SQL stored procedures and functions and Complex SQL.
• Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created checkpoints, configuration files in SSIS packages and Deployed SSIS packages with minimal changes using XML configuration file.
• Designed and build the OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.
• Used to extract all the Eligibility Files like 837, 835, 999 and 834 from Facets and the used to migrate the data according to client requirement.
• Represented HEDIS team in collaboration with internal departments for HEDIS improvement.
• Ensured all data sent to HEDIS software vendor are accurate and meet HEDIS reporting timeline.
• Assisted with documents necessary in the HEDIS Road Map and all other documents required by auditor.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Coordination of Control-M development team.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2012.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Performed data profiling in the source systems that are required for RML System.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Detailed knowledge of Health Edge's, other transaction system (Facets, QNXT, etc.).
• Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.
• Created Power BI Dashboards (Power View, Power Query, Power Pivot, and Power Maps) and integrated them to share point.
• Experienced in maintaining and supporting operational reports, dashboards, and scorecards using Microsoft Power BI (Power Pivot, T-SQL, Excel pivot tables).
• Used DAX expressions in MS Power BI Desktop.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
• Developed working documents to support findings and assign specific tasks.
• Extracted the customer data, marketing data related to customers from sources like oracle, teradata using SAS/Access ‘SQL pass through facility’ and libname statements.
• Modified and manipulated the data using data step Programming, SAS functions and Proc SQL statements.
• Used Proc Sort, Set, Update and Merge statements for creating, updating and merging various SAS datasets
• Participated in marketing campaign-planning meetings with Marketing managers, Managers to develop and document campaigns specifications.
• Created ER diagrams (physical and logical using Erwin) and mapping the data into database objects.
• Worked with Implementation team and closely moved with end users to implement manufacturing solutions.
• Worked closely with developers, end users and Administrators in designing and creating databases and other objects.
• Actively involved in designing databases for the system.
• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Creation/ Maintenance of Indexes for fast and efficient reporting process.

Environment: Microsoft SQL Server 2016/2014Enterprise Edition, MS Access, ETL Packages(SSIS), QNXT, SSRS, SQL Server Analysis Services(SSAS), Team Foundation Server (TFS), Power BI, T-SQL, Business Objects XIR2, ER Studio 8.0.3. Base SAS, Enterprise guide, Enterprise miner, Integrated studios.

Confidential, Peapack, NJ

SQL/Data Analyst

Responsibilities:

• Adjust BOX technology to be used as a document share platform and use Java to successfully test.
• Experienced using TOAD, SQL Developer tools to develop Oracle stored packages, functions and procedures for Oracle database back-end validations.
• Create updated triggers based on new tables with journal tables for inserting, updating and deleting.
• Develop and generate different kinds of reports based on the data getting from database.
• Use Pipeline Pilot to do some ETL process and do comparison with different reports.
• Created test case for testing new developed software and platform.
• Take part in AAEM project for maintaining door access and activities data, based on development environment and production environment.
• Joined AMS project, for modifying every release version changes via PLP protocols based on requirements from business side.

Environment: SQL Server 2005, Windows 2000/2003,MS Access 2000/2003,T-SQL,Windows 2000 Advanced Server, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services.

Confidential, Pasadena CA

SSIS SQL Developer

Responsibilities:

• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Performed cost benefit analysis of different ETL packages (SSIS) to determine the optimal Process.
• Created ETL metadata reports using SSRS, reports include like execution times for the SSIS packages, Failure reports with error description.
• Responsible for Data migration from SQL Server 2000 to SQL Server 2005 Databases.
• Developed an automated report subscription process using SSRS.
• Applied conditional formatting in SSRS to highlight key areas in the report data
• Created report links to refer other reports in a particular report.
• Resolved any deadlocks issues with the Databases/Servers on a timely basis.
• Handled Underwriting and pricing of renewal accounts within underwriting authority for
• Compensation. Assisted (via remote) with payroll, tax, and account processing.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2012.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Performed data profiling in the source systems that are required for RML System.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Detailed knowledge of Health Edge's, other transaction system (Facets, QNXT, etc.).
• Used Open Query from SQL Server the SSAS Server to combine data from SSAS cube and DW database.
• Created Power BI Dashboards (Power View, Power Query, Power Pivot, and Power Maps) and integrated them to share point.
• Experienced in maintaining and supporting operational reports, dashboards, and scorecards using Microsoft Power BI (Power Pivot, T-SQL, Excel pivot tables).
• Used DAX expressions in MS Power BI Desktop.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment.
• Developed working documents to support findings and assign specific tasks.
• Installed SQL server 2000 on Windows 2003 servers and involved in Physical and logical Database Design using Erwin tool.
• Created database objects like tables, users, roles, stored procedures, triggers.
• Worked on solving issues by doing data recovery in existing database.
• Used various formatting techniques like interactive sorting, grouping to created user friendly reports.

Environment: SQL Server 2005, Windows 2000/2003,MS Access 2000/2003,T-SQL,Windows 2000 Advanced Server, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services.

Confidential, San Francisco, CA

MS SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

• Created complex Stored Procedures and Functions to support the front-end application.
• Created database triggers to implement business requirements.
• Monitored growth of database objects for capacity planning and involved in tuning the database and T-SQL queries using Explain Plan.
• Created and managed schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Created several SSIS Packages to load data from various data sources including Flat files, MS Excel, MS Access, DB2 etc. to SQL Server
• Created SSIS package to load multilevel XML data into SQL SERVER database.
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Designed SSIS packages to export and import data from SQL Server to MS Access, text files and Excel files.
• Used SSIS transformation for Data Cleansing to remove unnecessary data.
• Expertise in creating Reports, Sub Reports, drill down reports using various features like Charts, filters etc.
• Created Complex Reports like Cascaded Reports, Drill Through, Tabular Reports, Matrix Reports, Drill-down, and Cross Tab Reports in SSRS.
• Created report models for ad-hoc reports using SSRS 2012.
• Designed and created Report templates, bar graphs, pie charts based on the financial data.
• Generated periodic reports based on the statistical analysis of the data using SSRS 2012.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report and also generated reports using Crystal Reports.
• Building BI capabilities in an organization, with specialized capabilities including Business Intelligence(BI).
• Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Use business tools to target and select optimal populations for chart review; partnership with Nurse ChartReveiw Coordinator as well as Chart Review Coordinator.
• SME for regulatory rate release notes and summaries - lead on reviewing and applying risk adjustment changes specific to Annual Rate Notices and interim rate bulletins from state and federal regulatory agencies.
• Used to resolve on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Developed and created data dictionary, advanced queries, views, indices, and functions for databases.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Involved in creating Users and Roles, and managing security and permission of database, managing Jobs and error logs.
• Used all SAS products like Enterprise Miner, Enterprise guide, Add in for Microsoft to do analysis on all the records generated.
• Gathered Business Requirement specification, Table specs and functional specification documents and communicated with the marketing manager to know the type of reports to be developed.

Environment: MS SQL Server 2014, Windows Server 2012, Enterprise manager, Query Analyzer, SSIS, SSAS, SSRS, SQL profiler, Performance Monitor, Query Optimizer, T-SQL, Agile, XML, ETL, Microsoft Visio 2003, MS Visual Studio 2012, Composite Studio 6.1, Oracle 11g, Team Foundation Server (TFS).Base SAS, Enterprise guide, Enterprise miner, Integrated studios.

Confidential

SQL Server DBA

Responsibilities:

• Installing SQL Server 2005 and administration of servers, ensuring zero downtime and provide 24 X 7 dedicated support to all Production, development servers.
• Interacting with Developers in identifying the requirements and designing and implementing the Database Schema.
• Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs.
• Created and modified stored procedures, triggers, views and indexes to provide best performance.
• Successfully implemented and maintained Microsoft clustered technologies for database servers.
• Managing security, which includes monitoring and controlling database access, assigning permissions to application owners.
• Created tables, indexes and constraints and various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Created Temp tables in stored procedure for different applications.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Developed and maintained relational databases.
• Developed Reports to generate daily, monthly, quarterly, yearly reports using Crystal Reports.
• Generating ad-hoc reports using MS-Excel and Crystal Reports.
• Scheduled jobs and alerted using SQL Server Agent.
• Responsible for Query optimization and Performance tuning, tuned SQL queries using Show Plans and Execution Plans.

Environment: SQL Server 2005, Windows 2000/2003,MS Access 2000/2003,T-SQL,Windows 2000 Advanced Server, SQL.