PROFESSIONAL SUMMARY:

• Around 7 (Seven) years of work experience in the IT industry as a SQL BI Developer which includes experience in design, development, implementation and administration of database systems using MS - SQL Server for both OLTP & Data Warehousing Systems applications with various business domains like Insurance, Healthcare and Credit reporting.
• Excellent understanding of Relational Database Systems, Normalization, logical and physical data modeling.
• Wrote complex queries involving multiple tables using T-SQL skills and developed the ability to create and maintain stored procedures, triggers and user defined functions.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to improve SQL Server Performance.
• Experience in Performance Tuning and Query Optimization.
• Maintained Error logging using Exception Handling in T-SQL and SSIS.
• Good knowledge of System Development Life Cycle (SDLC).
• Good Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill Down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, and Sub Reports.
• Experienced in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Expert in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS) and creating Dynamic packages for Incremental Loads.
• Experience in enhancing and deploying SSIS Packages from development server to production server by using package configurations.
• Experience in creating packages to transfer data between ORACLE, MS ACCESS and FLAT FILES to SQL SERVER using SSIS.
• Expert in using tools like Bulk Copy (BCP), SSIS and Data Transformation Services (DTS).
• Experience in Data Conversion and Data Migration using SSIS across different databases like Oracle, MS access and flat files.
• Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools.
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experience in MS SQL Server configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery.
• Experience in using Profilers, Index Tuning Wizard and Performance Monitor to monitor SQL Server.
• Extensively used SQL Server Import/Export Wizard, for performing the ETL operations.
• Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
• Understanding of Power BI reporting to develop reports on various visualization techniques by connecting to different databases.
• Generated various Monthly, Quarterly, Bi-Yearly and Yearly reports using custom reporting tools and SQL Server Reporting Services (SSRS) for various business users.

TECHNICAL SKILLS:

• SSRS
• SSAS
• Open Text
• C
• C++
• SQL
• T-SQL
• PL/SQL
• HTML
• XML
• DAX
• MDX
• DTS
• Power BI
• Power Shell
• VBScript
• C#.Net
• Windows Vista/NT/XP/98/95
• Windows 2003/2000 Server
• UNIX
• MS SQL Server 2016/2014/2012/2008R2
• Oracle 10g/9i/8i
• MYSQL
• MS-ACCESS
• Data Transformation Services (DTS)
• MS SQL Server Integration Services (SSIS)
• IBM AS/400

PROFESSIONAL EXPERIENCE:

Confidential, Marlton, NJ

SQL BI Developer / Data Integrator

Responsibilities:

• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Designed Dimensional model by analyzing all the requirements from the clients for the different source systems.
• Developed C#.net code in script task to extract data from various sources like SQL Server, Web API, Oracle, .CSV, Excel and Text file from Client servers and through SFTP.
• Developed PowerShell scripts to combine the data from two or more files and to automate the build and release process.
• Developed VB Script to automate file landing and loading.
• Automated multi step file retrieval and loading into SQL server with Triggers, Cursors and Stored Procedures.
• Troubleshooted SSIS packages and migration procedures and documenting the complex SSIS packages and migration procedures.
• Performance tuning of SQL queries and stored procedures
• Proficiency and expertise in SQL Server database Backup/Recovery and OLAP cube replication.
• Created dynamic queries to perform ETL operations by looping through multiple database servers and tables.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems.
• Created various statistics reports that includes Charts, Filters, Scorecards, Drilldown and Drill-Through, Cascade, Parameterized reports that involved conditional formatting for monitoring file system, processing and loading of files.
• Created Key Performance Indicators depicting behavior of data processing.
• Worked on Logging, Error Handling and Checkpoints in SSIS Packages.
• Extensively tested, whole automation process of fileretrieval and loading.

Environment: SQL Server, T-SQL, Oracle, PL/SQL, SSIS, SSRS, Visual Studio, SQL Server Data Tools, SQL Server Management Studio, SQL Developer, TOAD.

Confidential, Tuscaloosa, AL

SQL Server BI Developer

Responsibilities:

• Served as the primary point of contact for a vendor specific data.
• Worked on listing out schema changes and impacts during upgrades.
• Created SSIS packages to implement upstream source server upgrades by using Heterogeneous Data Sources like oracle, flat files and flowing the data into SQL Server.
• Implemented custom reporting using EDI.
• Created Table Valued Functions and Stored Procedures required for reporting.
• Created View Layers for multiple Line of Business to provide specific data with all the required filters.
• Performed Decommission tasks while performing upgrade tasks.
• Performed Troubleshooting of reporting data with the required changes both at the front end UI interface and back end queries.
• Worked on various Schema Changes that are required as part of updates to the upstream source servers.
• Created complex Stored Procedures, Table valued functions, Triggers, Cursors and other SQL Joins by using T-SQL, SQL Server and Oracle.
• Worked on Error Handling and Logging in SSIS Packages.
• Tested applications for performance, data integrity and validation issues.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help the Lines of Business with understanding the end product.
• Extensively used T-SQL, SQL Server and Oracle in constructing User Defined Functions, Views, Indexes and User Profiles.
• Used SQL Profiler and Execution Plan to view index performance and thereby eliminating table scans.
• Participated in Technical and Code review meetings as the mappings are developed and the design is implemented.
• Used various Transformations in SSIS Data flow and used Control flow for loop containers and Execute SQL tasks.
• Designed ETL packages dealing with different data sources (SQL Server, Flat files, Oracle, Excel) and loaded the data to the target environment by performing different kinds of Transformations like Conditional Split, Derived Column, Data Conversion, Look up and Merge Join as required.
• Created stored procedures using Common Table Expression (CTE) and various types of User Defined functions.
• Developed complex T-SQL queries, common table expressions (CTE), stored procedures, and functions used for developing SSIS packages.
• Worked in an agile scrum methodology.
• Schedule the jobs using SQL Server Agent.
• Worked on writing T-SQL queries for the historical data to pull according to the business requirement.

Environment: SQL Server, T-SQL, Oracle, PL/SQL, SSIS, SSRS, Visual Studio, SQL Server Data Tools, SQL Server Management Studio, SQL Developer, TOAD.

Confidential, Birmingham, AL

SQL Server BI Developer

Responsibilities:

• Involved in requirements gathering from Business Users and Stakeholders.
• Design databases, systems, data collection methods and measurements (definition, design, workflow).
• Define, design, and coordinate approval of validation testing controls, processes, and study documentation.
• Function as liaison with Clinical Team to coordinate appropriate application of regulations, policies & procedures to data control and analytic activity.
• Responsible for fielding data process and quality challenges in consultation with diverse clinical personnel.
• Provide strategic guidance and data analysis within a managed care organization, including health care costs, provider contracts, revenue & profitability, provider incentives & utilization.
• Prepare clear and well-organized project-specific documentation to reflect analytic methods used, key decision points, anomalies identified, etc with supporting documentation.
• Created SQL Server Reports using SSRS. Identified the data sources and defined them to build the data source views.
• Involved in debugging and deploying Reports.
• Scheduled the Reports to run automatically using data driven subscriptions.
• Experience in creating complex SSIS packages using control and data flow tasks with error handling and logging.
• Created/Updated Views, Stored Procedure, Triggers, User Defined Functions (UDF) and Scripts using T-SQL and SQL Server.
• Generated parameterized reports, sub reports, tabular reports using SSRS.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and parameterized reports using SSRS.
• Experience in moving the data from heterogeneous data sources like oracle and flat files to SQL Server using SSIS.
• Hands on experience in using different transformations like fuzzy lookup, derived column transformation using SSIS.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
• Used Multi-dimensional expressions (MDX) to present the data asked by the user, to simultaneously query on different dimensions.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Improved the performance of cubes by creating Attribute Relationships, Partitions, Aggregations, getting rid of unused attributes and changing the attribute hierarchy options in SSAS.
• Extensively used SQL Server Import/Export Wizard, for performing the ETL operations.
• Create and optimize complex T-SQL queries and stored procedures to encapsulate reporting logic.
• Created SSIS packages to migrate data from Oracle DB to SQL Server.
• Involved in Data migration (Import & Export using BCP) from text to SQL Server.
• Involved in Creating Stored Procedures for Reports generation.
• Designed and implemented stored procedures and triggers for automating tasks.
• Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
• Perform T-SQL tuning and optimizing queries for SSIS packages and provided production support for all the scripts and packages.
• Created numerous simple to complex queries involving self joins, correlated sub queries, CTE's for diverse business requirements.

Environment: SQL Server, T-SQL, Oracle, PL/SQL, SSIS, SSRS, Visual Studio, SQL Server Data Tools, SQL Server Management Studio, SQL Developer, TOAD.

Confidential, Short Hills, NJ

SQL Server BI Developer

Responsibilities:

• Created Digital sales Acquisition dashboards and reports for multiple lines of businesses that was published to Executive Manager.
• Performed deep-dive analysis on cyber attacts (Distributed Denial of Service Attacks) and identified pattern for high risk logins.
• Proactively created a self service reporting environment that improved customer experience and reduced Time-to-Access data by 70%.
• Maintained 50+ critical operational reports and dashboards on business objects platform(Info View/Launch Pad) on daily,weekly and monthly basis.
• Communicating with business users to deliver reports and other user interfaces that drive business value and efficiently leverage the use of data.
• Interaction with a variety of internal and external users to develop technical designs and reviews with the rest of the project team as appropriate.
• Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and technical specifications.
• Created stored procedures, triggers, views, functions and wrote complex queries using T-SQL Joins to address various reporting operations and random data requests.
• Created packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local databases to facilitate reporting operations. Loaded the Fact and Dimension tables.
• Implemented Complex Logging in SSIS Packages.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Involved in various Transformation and data cleansing activities using various Control flow and data flow tasks in SSIS packages during data migration.
• Generated various Monthly, Quarterly, Bi-Yearly, Yearly and random ad-hoc reports using SQL Server Reporting Services (SSRS) for various business users.
• Generated Sub-Reports, Drill Down reports, Drill through reports and Parameterized reports using SSRS. Deployed all the reports to reporting server, SharePoint, Excel & PDF using SSRS.
• Created List reports, Cross-Tab reports and different types of charts like Column charts and Bar charts using SSRS Report Builder.
• Assigning different access permissions and security levels for the reports in SSRS for various levels of users in the company. Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Reports using Global Variables, Expressions and Functions for the reports. Identified and worked with Parameters for parameterized reports in SSRS.
• Having knowledge in Dimensional Data Modeling, Cube development and manipulations in SQL Server Analysis Services (SSAS).

Environment: SQL Server, T-SQL, Oracle, PL/SQL, SSIS, SSRS, Visual Studio, SQL Server Data Tools, SQL Server Management Studio, SQL Developer, TOAD.

Confidential

SQL Server Developer

Responsibilities:

• Involved in development phase meetings for Business Analysis and Requirements Gathering.
• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Involved in ER diagrams (Physical and Logical using Erwin) and data mapping the data into database objects.
• Designed database, tables and views structure for the new data mart.
• Created complex Stored Procedures and Functions for integrity checks of transferred data.
• Performed Unit Testing and Tuned SQL statements using Indexes and Stored Procedures
• Helped provide end users with the ability to access and utilize the data stored in the data mart.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries
• Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, index tuning wizard.

Environment: SQL Server Enterprise Edition, MS Access, Erwin, T-SQL, MS-Excel, MS-Access, SQL Query Analyzer, Visual Source Safe, MS SQL Profiler.

Confidential

Software Analyst / SQL Server Developer

Responsibilities:

• Understanding the product software ‘Cabinet Vision’, Development of new enhancement, Defect analysis and providing its solution, Attending the client weekly status calls and discussing the defect progress, Configuration management.
• Application maintenance and support
• Fixed the bugs reported by the QA team.
• Effectively done peer code reviews to improve the quality of the product
• Provided technical leadership to the team to develop new features at platform/product level.
• Documented the newly developed/existing features to improve the product usage at system expert level.
• Documented the software architecture documentation(SAD) to streamline the maintenance
• Design and document the release process
• Effectively facilitate the sprint ceremonies like Planning, Review, Retrospective, Backlog refinement and Daily scrum to create the transparency with the product owner
• Review the work-product created by the offshore team before delivery to the client

Environment: C++, Microsoft Visual Studio, TFS, Jira