Software Engineer Resume
Irving, TexaS
SUMMARY:
- Over 6+ years of IT experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), installation and configuration of MS SQL Server.
- Proficient in Microsoft suite of products like SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
- 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.
- Designed SQL Server database objects to support outsourcing data integration (SSIS), analysis and various business processes.
- Strong in SQL Server 2016/2 developer skills.
- Hands on experience with installation and configuration of MS SQL Server 2016/2012/2008 versions on Stand-Alone and Clustered base environment.
- Expertise in backup and restore using Import/Export wizard and generating scripts.
- Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
- Expertise in scheduling database tasks like Jobs, Alerts, Notification and Emails.
- Hands on experience in writing T-SQL Queries, Scripts, Stored Procedures and functions.
- Experienced in performance tuning using SQL Profiler, Query optimization and Database consistency checks using DBCC commands.
- Involved in optimizing code and improving efficiency in databases including re-building the indexes, updating statistics, recompiling stored procedures and performing other tasks SQL Profiler and Execution plans.
- Knowledge of high availability of SQL Server solutions, including Log shipping, Replication and SQL Server clustering.
- Knowledge of data extraction from different sources like MS Excel, XML files and Flat files and perform transformations and populating the data to the destination using DTS/SSIS.
- Skilled in error and event handling: Precedence Constraints, Break Points, Check Point and Logging.
- Excellent work experience in creating packages to handle Incremental loads and Slowly Changing Dimensions to update data in Data warehouse using SSIS.
- Experienced in installing, configuring, developing and deploying reports using SQL Server Reporting Services (SSRS).
- Hands on experience in deploying SSRS reports in the test/production servers.
- Knowledge of creating Tabular reports, Drill-Down reports, Drill through, parameterized reports, Ad-hoc reportsusing SSRS.
- Proficient in deploying reports and creating subscriptions on the report manager to provide access or give permissions to the specific reports to the business users.
- Worked on all activities related to the development, implementation administration and support of ETL process for large-scale data using SSIS.
- Create Business Intelligence reports and Design Dashboards.
- Create Dashboards on the data collected using Tableau Desktop.
- Analyze Social media (Facebook and Twitter) using Maltego.
- Gathering information (User name, email address, relationships) using Shadow Dragon.
- Goal oriented with business and technical background skills. Adaptable to new environment quickly.
- Meticulous and Articulate. Quick learner.
- Possessing excellent interpersonal, analytical and negotiation skills towards the accomplishment of organizational goals.
- Willing to learn and stay updated about the emerging Real - time Technologies.
- Ambitious to develop a career in a growing company where my skills and expertise will be utilized in achieving the goals and objectives of the organization.
- Ability to organize, schedule and coordinate workloads to meet established deadlines.
TECHNICAL SKILLS:
RDBMS: MS SQL Server 2012/ 2008R2/ 2008, Oracle, Teradata, MS Access.
BI and SQL Tools: SSIS, SSRS, Business Intelligence Development Studio (BIDS), SSMS,SQL Profiler, Query analyzer, Export and Import, Visual Studio, MS Visio.
Scripting and Query Languages: T-SQL, HTML, VBScript, C#.Net, PL/SQL
Operating Systems: MS Windows 2010/08/07/03 , Windows Server 2016/2014/2012/2008 R2, MS-DOS
Tools: Erwin, ER studio, ODBC, Teradata
Others: MS office 2013/2010/2007 , Agile and waterfall methodology, Power Pivot, Qlik View, Tableau, MS Project Management, Tableau, Power BI,SSDT, Maltego, Shadow Dragon, SharePoint, Red Gate Pro, dB Forge SQL decryptor or, Tree Size.
PROFESSIONAL EXPERIENCE:
Confidential, Irving, Texas
Software Engineer
- Install and configure SQL Server 2008R2/2012 along with SQL Server Data Tools (SSDT).
- Actively participated in gathering business requirements and system specifications.
- Extracted Data from heterogeneous source systems into the Operational Data Store and Data warehouse.
- Created SSIS packages to load the data into Data Warehouse using SSIS tasks like Execute SQL Task, Bulk Insert Task, Data Flow Task, and Send Mail Task.
- Created packages by implementing various transformations like Derived Columns, Conditional Split, Aggregation, Merge and Lookup for loading the data.
- Created SQL Agent jobs, maintenance plans to check SQL process failures to provide solutions and SQL Mail Setup.
- Involved in development of SSIS packages for Convert PDF to TIFF for Patient care OCR and Patient Portal.
- Upgrade DTS packages to SSIS packages in Galactica Suite.
- Worked on providing 24/7 support on rotation with multiple DBAs providing technical support in coordination with customer support.
- Automated and enhanced daily administrative tasks using scripts including space management, database backup and recovery.
- Created reports using SQL Server Reporting Services (SSRS) for customized and Ad-hoc queries.
- Created Tabular, Matrix, List reports and Parameterized reports, Drill down and Drill through reports.
- Develop and configure SSRS reports as per specifications provided by internal and external clients.
- Configure and setup Image archiving process on user’s PC on different windows platforms.
- Design and execute the test cases on the different applications as per HIPPA policy and TSG standards.
- Generated database SQL scripts and deployed databases including installation and configuration.
- Analyzed complex reports and improved performance of reports by adding new filters to filter the data.
- Involved in Database writing SQL Queries, configure and troubleshooting TSG applications.
- Plan, design and implement application database code objects, such as stored procedures and views also work on SQL Server maintenance, patch deployment, backups.
- Involved in upgrading SQL 2005 to SQL 2012 SP4 for Galactica Test/Live servers.
- Identified data issues and provided recommendations for resolution to ensure optimal Performance. Work on support tickets, maintenance tasks and assigned projects at discretion of the Queue coordinator.
- Experienced working with Meditech and HIS applications.
- Experienced installing Windows Server 2012R2/ 2016 and Hyper-V.
- Management of Active Directory users, computers and group accounts
- Actively participated in interacting with users, team lead, DBAs to fully understand the requirements of the system.
- Performed database performance monitoring and tuning using system monitor, event log view, SQL profiler, SQL Query analyzer, stored procedure etc. monitored and resolved deadlocks and blocking.
- Created Indexes on columns having high selectivity and low density to speed up the execution of data retrieval queries and stored procedures.
- Create technical specifications and knowledge base documents.
- Work with business stakeholders, application developers. Production teams and across functional units to identify business needs and daily support issues.
Confidential, Princeton, New Jersey
ETL Developer
- Involved in understanding and analyzing the business requirements providing better approach to the system.
- Designed and developed various SSIS packages to extract and transform data and involved in scheduling SSIS Packages using SQL Server Agent.
- Used various transformation tasks to create ETL packages for data conversion.
- Extract Transform and Load the source data into the respective target tables to build required data marts.
- Analyzed the existing tool and participated in meetings with the business users to gather requirements and design goals of the Data Warehouse.
- Performed cost benefit analysis of different ETL packages to determine the optimal process.
- Developed T-SQL functions, triggers, Inner Joins, Outer Joins and Indexes.
- Implemented Custom logging, Audit and Email notifications using SSIS.
- Compensation assisted with payroll, tax and account processing.
- Discount and commission margins for Welcome, Claim free and multipolicy.
- Created Parameterized reports, Drill-down reports and List reports using SQL Reporting Services (SSRS).
Confidential
MS SQL Server Developer/BI Developer
- Involved in planning, defining and designing data based on business requirements and provided documentation.
- Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
- Established the relationships between tables using Primary Key and Foreign Key constraints.
- Involved in DE-Normalization of existing tables using Pivot transformation for faster query retrieval.
- Created packages to extract the data from OLTP systems to Data Warehouse using SQL Server Integrations Services (SSIS).
- Deploy the SSIS packages and batch process to Production environment and modify the package according to the business needs.
- Created Alerts for successful and unsuccessful completions of Scheduled jobs.
- Used various SSIS transformations such as Conditional Split, Derived Column which were used for Data Scrubbing and Data Validation checks during Staging, before loading the data into the Data Warehouse.
- Developed SSIS packages for File Transfer from one location to the other using File Transfer Protocol (FTP) task.
- Used ETL to implement the Slowly Changing Transformation to maintain Historical Data in the Data Warehouse.
- Experience in Debugging, Error handling for SQL Server Integration Services (SSIS).
- Created Sub-reports, Drill-down and Parameterized reports in SQL Reporting services (SSRS).
- Created Reports using SSRS from various data sources and deployed on the report server.
- Performed T-SQL tuning and optimization of queries for reports that look longer execution time using MS SQL Profiler and Index Tuning Wizard.
Confidential
ETL Developer
- Involved in installation and configuration of SQL Server 2014.
- Extracted the data from sourceslike SQL Server and Excel using SQL Server Integration Services and loaded into the SQL Database.
- Created packages by implementing various transformations like Derived Columns, Conditional Split, Aggregation, Merge and Lookup.
- Developed stored procedures and used for designing SSIS packages.
- Used the SSIS Import/Export to migrate the data to the SQL Server.
- Developed packages in SSIS with logging, checkpoints and breakpoints.
- Involved in Performance tuning by optimizing the existing SQL Query using SQL Profiler.
- Created Parameterized reports, Drill-down reports and Tabular reports using SQL Server Reporting Services.
- Involved in weekly meetings directly with the manager to discuss about the progress and provided the technical feedback based on the requirement provided.
Confidential
ETL Developer/DBA (Intern)
- Involved in gathering business requirements and system specifications.
- Created new databases, tables and established relationships between the tables in the database.
- Created Database objects - Tables, Indexes, Views, User defined functions, Triggers, Stored Procedure and Constraints.
- Used Bulk Copy Program (BCP) utility to publish table output to text files.
- Involved in extracting data from MS Access, Oracle, Excel and loading into the SQL Server Database using SSIS.
- Monitored performance and optimized SQL Queries for maximum efficiency.
- Implemented fine tuning of database objects and server to ensure efficient data retrieval.
- Used SQL Profiler to view index performance to mostly eliminate table scan.
- Maintained the consistency of the client’s database using Database console commands (DBCC) .
- Involved in Performance tuning and optimization of T-SQL Queries.
- Provided support for database backup/restore and database transfer activity from test environment to production environment.
- Set up SQL mail and created jobs to automate and schedule many tasks.