SQL Developer
Resume:
Pradeep Manandhar
******************@*****.***
Green Card Holder
EXPERIENCE SUMMARY: -
Overall, 5+ years of experience in Database Development, Data Analysis, System Analysis, Design, Development and Support of MS SQL Server 2016, 2014, 2012, 2008 in Production, Testing and Development.
Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.
Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
Proficient in writing Complex T-SQL Stored Procedure and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models and data integrity, SQL joins and writing Sub Queries.
Well versed in designing highly flexible Database Architectures and Data Modelling, Data Mapping, Table Normalization, performance tuning and optimization of SQL scripts and SQL queries.
Expertise in creating and managing Package Configurations, Logging system, Package deployment and User-defined Variables for SSIS Packages.
Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Breakpoints, Event Handlers and Loggings (SSIS or Custom Loggings).
Expertise in Merging data from various Heterogeneous sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
Hands on experience with performing various SSIS data transformation tasks like Lookups, Fuzzy Look- ups, Conditional Splits and Event Handlers.
Strong knowledge in designing Extraction, Transforming and Loading (ETL) data flows using creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.
Experience in DTS Migration and Metadata Management: Migrating DTS packages to Package Migration Wizard, and Storage Management using SSIS (SQL Server Integration Services).
Expert in creating various types of reports like complex drill down reports & drill through reports, Matrix reports, sub reports and charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
Good knowledge on Datawarehouse concepts and SSAS cubes.
Experience in cubes construction based on data volumes mostly adhering to Star Schema using strong knowledge of Data Warehousing, Star Schema, Fact and Dimension Tables. Familiar with use of ERWIN to design Normalized and De-Normalized Data Models
TECHNICAL SKILLS
Operating systems
Windows 98/NT/2000/XP/Vista/Windows7/8/10
Databases
MS SQL Server 2005/2008,2012/2014, MS Access
Database Tools
SQL Enterprise Manager, SQL Profiler, DTS Import/Export, SQL Client Configuration utility, Backup Server, Replication Server, OLAP Services, SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS)
ETL Tools
DTS, SQL Server Integration Services, SQL Server Analysis
Reporting Tools
SSRS, R studio, Crystal Reports, Congo's, Micro Strategy
Development Skills
Transact SQL (T SQL), PL/SQL
Languages
HTML, XML, VB.Net, Asp.Net (C#)
Application Packages
Microsoft Office Suite
PROFESSIONAL EXPERIENCE
SMS InfoComm
Grapevine, TX
SQL Developer
Jan 2022- Current
ROLES AND RESPONSIBILITIES:
Responsible and active in the analysis, design, implementation, and deployment of full Software Development Lifecycle (SDLC) of the project.
Coordinated with the front-end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
Created database objects like tables views, materialized views, procedures, and packages using oracle tools like SQL Developer.
Created SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
Worked on SQL Loader to load data from flat files obtained from various facilities every day.
Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server integration services (SSIS).
Created and executed SSIS packages to populate data from the various data sources for different data loading operations for many applications.
Migrated data between different heterogeneous sources such as Flat file, Excel using SSIS.
Partitioned the fact tables and materialized views to enhance the performance.
Extensively used bulk collection in SQL objects for improving the performing.
Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
Worked extensively in various kinds of queries, Sub- Queries, Correlated Sub-Queries, Dynamic SQL, and Union Queries.
Used SQL hints and indexes to improve SQL performance and analyzed the schema tables to get the better performance.
Transferred data from various OLTP data sources, such as Oracle, Teradata, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008.
Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence container and Conditional split, Data conversion, Derived column and Multi casting.
Designed Web-based ASP.NET Internet applications linked to firm-wide SQL databases.
Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions.
Generated reports that can handle dynamic grouping and dynamic sorting for efficient and clear viewing of the reports.
Developed Sub Reports, Matrix Reports, Charts, and Drill Down Reports, using SQL Server Reporting Services (SSRS).
Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.
Analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
Performed Server level tuning, performance monitoring, Index Tuning, Query Tuning.
BCBS
Richardson, TX
SQL Developer
May 2020 - Dec 2021
Responsibilities:
Created Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
Created scripts components to write customer functions in dataflow used data grids to display the data in a customized way.
Created SQL Server Integration Service (SSIS) packages between enterprise databases and third-party data source to transfer data.
Ensured SSIS Packages to read data from different locations to stage database.
Ensured and monitored store procedures and functions for SSIS packages to transfer data in Load database.
Monitored an application on different platforms using VMWare.
Monitored queries for optimization while execution.
Designed and developed cascaded and parameterized SSRS reports.
Job monitored through Sql server Agent and DB Visualizer.
Provided the Test feedback to the client and getting sign-off from the Test Results.
Worked on new reports as per the business requirement and provide optimize performance tuning suggestions.
Worked with Business Client to gather requirements and provide them essential feedback.
Communicated with the Business Analyst's to prepare the Requirement/Specification document.
Prepared Technical Architecture Document and guided Offshore Team members to prepare design documents
Checked the status from offshore team on day-to-day activities and reviewed the work done by the offshore team.
Provided standard solution across all markets in globe for all new implementation and updating in existing system.
Worked with the client to open the CMR and SSR and got the codes to be migrated to production.
Closely involved on critical issues requiring quick resolution and involved in resolving all Dashboard problems.
KMD Corp
Dallas, TX
SQL/SSIS Developer
Jun 2018 - Apr 2020
Responsibility: -
Coordinating with business users in analyzing business requirements and translating them to technical specifications.
Designed and implemented the ETL processes using SSIS which involved collection of data from sources like SQL Server 2008/2014.
Developed and deployed SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files, Flat files.
Troubleshooting reports issues, ETL job failures, optimizing query performances.
Automated File Transfer Processes and mail notifications by using FTP Task and Send Mail task in packages.
Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
Designed and built-up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.
Extracted data from different sources and stored the data into the intermediate Staging Database using SSIS ETL tool.
Creating and managing schema objects such as, Tables, Views, Indexes, and referential integrity depending on user requirements.
Multi-geographic Technical Support (for all Windows 2000/2003/2008/2012 Virtual/HP/Dell/IBM/Cisco 8000+ servers) over the phone, in person, or via e-mail and using Ticketing System (Service-Now), handling each with professionalism and timeliness.
Developed SSIS packages to extract the data from SQL server tables and import the data to excel files.
Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
Scheduled Automatic refresh and scheduling refresh in Power BI service.
Used SSRS Report Manager to assign roles, permissions and to create report schedules.
Transferred data from various sources like MS Excel, Flat File and SQL Server using SSIS and then created reports using this data using SSRS.
Generated the weekly, monthly, and quarterly report by using SQL Server Reporting Services (SSRS) for the managers.
Work with the end users to ensure that the reports are working as per the Business requirements.
Maintained and optimized the existing databases; monitored database performance and growth, performance tuning, generated reports according to the business requirements using SQL Server.
SanMar
Issaquah, WA
SQL/SSIS/SSRS Developer
Mar 2017- May 2018
Responsibility: -
Experience working in waterfall development environment.
Active participant in Product Backlog Management, Sprint Planning and Estimation Sessions.
Had direct interaction with clients, handled scrum calls with them daily.
Documentation like Unit Test Case Document, Managing Table schema.
Creating a generic package which loads the data from all the different types of source systems that included DB2, Informix, CSV, SQL Server, and Oracle. Only one package loads the data into all the 500+ tables.
Worked on Configuration, Logging and Error Handling.
Got hands on experience on Joins and View.
Worked with Sequence Container, For Each Loop Container, Data Flow Task, Execute SQL Task, Send Email Task, Lookups, Merge Joins, Multicast, Conditional Split, Derived Column, Data Conversion Task.
Created and maintained project tasks and schedules.
Fine tuning the Application – Upgrading and Optimizing the existing code.
Involved in creating tables, writing queries, database interactions and scheduling batch jobs.
Handling all the tasks related to CMR (Change Management Request) and IMR (Incidence Management Request) processes which includes raising ticket get it approved by the respective teams, Validation and Closure.
Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.
Developed mock-up Tableau Dashboards to explore options for visualization of data, presentation, and analysis.
Created and published data sources to the Tableau Server and used for developing and designing dashboards on Tableau Desktop.
Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
Promoting the data to the higher environments.
Collaborated with other members of the product development as well as the front-end team.
Contact this candidate