Summary:

• Microsoft Business Intelligence and Data Warehouse developer with over 5+years of experience in IT, BI and Data warehouse lifecycle using SQL server tools like SSRS
• Experienced in design and development of SSIS packages to Extract, Transform and Load data from heterogeneous sources (excel, flat files) to data warehouse (OLAP) according to user requirements.
• Experienced in coordinating across various phases of Software Development Life cycle, Engaged in Database Design, Development and Maintenance of OLTP system.
• Strong command over the creation of various Database objects like Tables, Views, Indexes, Stored Procedures, Functions and User Defined Data types.
• Expertise in creating Workflows based on Functional Specification Document.
• Experience in Deploying and Monitoring ETL packages in SQL Server by job scheduling the flow of packages from Development Server to Test and Production Server.
• Proficient in optimizing SQL queries, performance tuning using SQL Profiler as well as understanding execution plans.
• Experienced in creating various reports like Tabular, Matrix, Drill down, Drill - through, Parameterized, Cascading, Conditional, Chart, Sub Reports and Deploying Reports in report server.
• Coherent with Data Profiling, Data Cleansing, Data Conversion, Performance Tuning, Unit Testing, System Testing, User Acceptance Testing.
• Expert in Unit Testing, System Integration Testing, Performance Tuning and In-depth knowledge in Tuning SQL Queries and improving Query performance.
• Worked closely with the Project/Program Managers, Business Analyst, Data/ETL in determining the exact business rules and functionalities required for deliverables.
• Good knowledge in Multi-tier and Cross-platform environments; strong analytical and leadership qualities with excellent communication skills.
• Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.
• Excellent knowledge of entire Software Development Life Cycle (SDLC) methodologies like Agile, Scrum, UML, Waterfall and Project Management Methodologies.
• Well versed with Tuning SQL Queries & Stored Procedures to improve performance
• Expert in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports.
• Excellent Analytical, Problem-solving Skills, and Communication Skills, a Motivated Team-player with Excellent Inter-Personal
• Built database Model, Views and API's using Python for interactive web based solutions.
• Used Python scripts to update the content in database and manipulate files.
• Worked on developing internal testing tools which were written in Python.

TECHNICAL SKILLS:S

cript and Query Languages: T-SQL, PL/SQL, XML, HTML, VBSCRIPT

SQL Tools and Reporting: SSIS, SSRS, BUSINESS INTEGELLIENCE STUDIO BIDS, SSMS, VISUAL STUDIO, SSDT, SQL SERVER MANAGEMENT STUDIO(SSMS), Power BI, Tableau, SQL Server Reporting Tools(SSRS), Report Builder.

Operating systems: WINDOWS 7/10, LINUX, UNIX

Databases: Microsoft SQL Server 2016/2014/2012 2008R2, EXCEL, MS Access, Excel.

Others: MS OFFICE, JIRA, POWER PIV OT, MS ACCESS, TFS, GIT, EXCEL, NOTEPAD++, POWERPOINT.

Professional Experience:

Confidential, Philadelphia, PA

SQL Developer

Responsibilities

• Responsible for the whole project life cycle of Maintenance and Support Group which includes gathering the tickets generated by the business users and resolves the tickets raised by delivering on-time solutions.
• Participating in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.
• Worked with Pandas, Numpy for data analysis using Python
• Involved in gathering requirements, performing source system analysis and development of ETL jobs to populate data from the transactional data source to the target Data warehouse.
• Working with different databases for data analysis and creating reports using SSRS.
• Developed processes based on technical specifications and development standards.
• Analyzing and visualizing data to find better solutions and to increase the performance.
• Worked with application developers to create optimized queries.
• Improved the performance of the T-SQL queries and Stored procedures by using SQL profiler, Execution plan, SQL performance monitor and Index tuning advisor.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.
• Reviewing query performance and optimizing code, Designing and coding database table to store the application data.
• Wrote and executed various MYSQL database queries from Python using Python-MySQL connector and MySQL dB package.
• Used Collections in Python for manipulating and looping through different user defined objects.
• Developing and Designing tables and procedures for new modules added for application enhancements.
• Involved in testing for contract set-up, enrollment and claims processing for four new managed care contracts for Medicaid mental and physical health providers.
• Used Test driven approach for developing the application and implemented the unit tests using Python unit test framework.
• Fixed any issues related to database performance and provide corrective measures.
• Developed database schemas, table and procedures.
• Monitor job performances to ensure processes run according to schedule and troubleshoot/ resolve issues as needed.
• Implemented Sql based security modes to protect sensitive data from unauthorized users.
• Created database triggers for automation like auto email notifications.
• Developed Table indexes, fine-tuned procedures/SQL queries for maximum efficiency.
• Provided via the phone, application support. Developed and tested Windows command files and SQL Server queries for Production database monitoring in support.
• Good exposure in running jobs in enterprise manager using job scheduling tool.

Environment: SQL Server 2017(SSDT) ( SSRS), FTP, JIRA, WINDOWS 10, VISUAL STUDIO 2017, MS SQL Server 2016, MS Access, Microsoft Team Foundation Server (TFS),.

Confidential, Schaumburg, IL

SQL Developer

Responsibilities:

• Gathering business requirements from different databases and interacting with end clients to understand data.
• Analyzing and visualizing the data to provide better business solutions.
• Participating in Daily stand up Agile/Scrum meetings to discuss regarding the enhancements to be made for the existing requirements.
• Acted as intermediates between the Account / Finance team and Offshore Lease wave team.
• Worked with Quality Control team to identify and address further issues detected during the data replication process. Reconciliation report was executed at the end of every data load process to provide counts and fallout statistics.
• Developed Dashboard Visualizations, cross tables, Bar charts, Waterfall, Tree map and complex reports which involves custom Controls and Custom Expressions using bars, lines and pies, maps, scatter plots, Gantts, bubbles, histograms, bullets, heat maps and highlight table.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Created and modified various Stored Procedures used in the application using T-SQL.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Develop SQL based solutions to handle requirements from developers in the SQL Server 2012 back-end databases.
• Maintain and tune production and development SQL Server 2012 databases through maintenance plans and backup procedures.
• Worked to write and modify Store procedure to implement business logic in facet extension and interface application.
• Aggressively worked with the team to review data for extracting, formatting, and loading into the destination tables from a flat file received from the government, using SQL Server, EXCEL and MySQL.
• Created complex functions, Scripts, Stored procedures and triggers to support application development.
• Worked with different types of reports pie chart, bar graph, Semi - pie reports, Table report, matrix report linked reports, click through reports, sub reports and Ad hoc reports.
• Experience in writing complex expressions to calculate, parameterize, group, filter and format the contents of a report for Business users.

Environment: SQL Server 2017(SSDT) ( SSRS), FTP, JIRA, WINDOWS 10, VISUAL STUDIO 2017, MS SQL Server 2016, MS Access, Microsoft Team Foundation Server (TFS), Agile Scrum, Web Services, T-SQL, SQL Analyzer and Enterprise Manager and SQL Agent, BI Development Studio 2016.

Confidential, Basking Ridge, NJ

Report Developer

Responsibilities:

• Working with business team to analyze mapping constraints, preparing technical design document to demonstrate Proof of Concept for the audit trail process and ETL framework.
• Worked in full cycle software development projects, analyzing requirements, designing and developing packages to perform ETL process, which required Data Extraction from unclassified database, manipulating the data to meet the new business rules on the target site and loading into the classified database, testing, implementing and supporting the applications.
• Designed and developed various SSIS packages (ETL) to extract and transform data and involved in Scheduling SSIS Packages.
• Developed and maintained ETL (Extract, Transform and Load) mappings to extract the data from different source database.
• Worked to implement and modify Index, Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
• Experienced on configuration of report server and report manager scheduling in SQL Server Reporting Services (SSRS).
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Maintained ETL strategies while extracting data from different sources such as SQL Server, flat files and Excel.
• Involved in Database migrations from legacy systems, SQL server to Oracle.
• Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit, and Data Conversion etc.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server. Involved in Maintenance and Deployment of SSIS Packages.
• Developed Custom Reports by Ad-hoc Reports using SQL Server Reporting Services (SSRS).
• Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS.
• Created Parameterized Report, Dashboard Report and Sub Report by Year, Quarter, Month, and Week.
• Generated Reports using Confidential Variables, Expressions and Functions based on the requirements in SSRS.
• Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.
• Implemented multiple grouping into several reports using visibility and toggle options.
• Administrated and scheduled mailing subscriptions on SSRS reporting server.
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
• Ability to perform duties in a very fast pace environment and ability to learn new technology.

Environment: SQL Server 2014(SSDT) (SSIS, SSRS), FTP, SSIS, WINDOWS 10, VISUAL STUDIO 2012, MS SQL Server 2012, MS Access, Microsoft Team Foundation Server (TFS), Power BI Desktop.

Confidential LOGIC

SQL Developer

Responsibilities:

• Experience with complete SDLC life cycle, which includes requirement gathering, analysis, design, development, maintenance and implementation.
• Experience in all areas of SQL Server development including tables, user functions, views, indexes, functions, triggers, clustering, relational database models, data dictionaries, and data integrity.
• Experience in scripting T- SQL queries, complex stored procedures, user defined functions (UDF), Database triggers. Initiate and develop adequate stored procedures.
• Used Temporary tables, Table variables and Common Table Expressions (CTE) depending on the requirement.
• Experience in using Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key & Foreign Key Constraints
• Developed functions, procedures and packages to implement the system's business logic using PL/SQL.
• Involved in the design phase of the development.
• Created Several User Roles and Groups to the end -user and provided row level security to them
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Handled the responsibility for the physical as well as logical design on the storage media.
• Analyzed data access controls and provided suggestions in enhancing the security.
• Created and managed the database triggers and subprograms and executing complex queries.

Environment: SQL Server management studio 2012, MS SQL Server 2008.