| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate
Candidate's Name
PHONE NUMBER AVAILABLEEMAIL AVAILABLEUSCSUMMARY Around 9 years of extensive IT Experience as MS SQL Server/BI Developer and in-depth experience in Database and Business Intelligence Technologies with expertise in Database Design, Development, Unit Level Testing, ETL Process, and Reporting services using MS SQL Server
Designed, developed and implemented multi-tiered Splunk log collection solutions. 2008/2008R2/2012/2014, SSIS, SSRS and SSAS in Development, Test and Production Environments. Hands-on experience in installing, configuring, upgrading, managing, migrating, monitoring, troubleshooting, and maintaining MS SQL Server 2008/2008R2/2012/2014. Experience in design and implementation of Normalization and Denormalization techniques for both OLTP and OLAP systems with strong Knowledge of Relational and Multidimensional modeling concepts. Experience with Snowflake Multi - Cluster Warehouses. Experienced in Conceptual, logical, and physical data modeling, data mapping, data normalization building Referential Integrity & Constraints, data denormalization with Fact and Dimension tables, data marts, data warehousing with star schema and snowflake schema modeling. Experience in using Business Intelligence tools(SSIS,SSAS,SSRS) in MS SQL Server 2008 Proficient in T-SQLprograms(DDL, DML, and DCL) skills like creating Stored Procedures, User Defined Functions, Indexes, Views, Tables, Constraints, Triggers, and writing complex queries using Joins, AggregateFunctions, Sub-queries, Derived Tables, and CTE. Created SSIS packages to populate data from various data sources. Experienced with Python frameworks likeWebapp2 and, Flask. Created packages using SSIS for data extraction from Flat Files, Excel Files, OLEDB to SQL Server. Excellent experience in developing complex SSRSReports with functionality such as ChartReport, Drill-Down, Drill-Through, Cross-Tab, Sub-Reports, Tabular, Matrix Reports, Ad-hoc and different types of Parameterized Reports including Cascading parameter reports.
Solid knowledge of Power BI and Tableau Desktop report performance optimization. Experienced in deploying SSRS reports across test, development, and production environments from SSAS cubes and various data sources on the portal for user accessibility. Used UNIX Shell scripts for Extracting and Parsing data from the files. FTP process is extensively used to send and receive the flat files. Wrote complex PL/SQL package, functions, procedures, batch processes using bulk processing, ref cursors and Pl/Sql Tables. Participates in the development improvement and maintenance of snowflake database applications Installing and Configuring MicroStrategy suite including MicroStrategy Desktop, Administrator, Intelligence Server, Web, and Narrowcast Server on NT Servers and Sun Solaris Environments. Created ASP.NET pages using C#.NET for middle-tier processing of client requests with ADO.NET interfaces for database and implemented stored procedures Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python / Java Experienced in using ETL tools in (SSIS) MS SQL 2008,MS SQL 2005 and DTS in MS SQL 2000 Worked Extensively on ETLProcesses by developing SSIS packages with various Control Flow and Dataflow Tasks and has in-depth experience in maintaining Batch Logging, Error Logging with Event Handlers, and Configuring Connection Managers using SSIS. Good Knowledge of Python and Python Web Framework Django. Expert in Performance tuning by rewriting queries, providing an index, index views, table hints, forced parameterization experience using Execution Plan, SQL Profiler, Tuning Advisor, Windows Performance Monitor, DMV, and DMF. Hands-on experience in SDLC (Software Development Life Cycle) like gathering requirements, design, development, implementation, and testing of projects before moving to production. Excellent assessing client needs, prioritizing projects, problem-solving, and analytics with great technical, interpersonal, and communication skills. Extremely diligent, strong team player with an ability to quickly adapt to new environments and technologies. Experienced in managing users, groups, sites, permissions and roles on Tableau server. Data analysis and data migration by transferring them using SSIS packages. Designed and developed Unix shell script to perform data loading, BOD setting of systems, intra-day processing and reporting.TECHNICAL SKILLSLanguagesT-SQL, SQL, PL/SQL, Unix, Dynamic SQL, C#, VBRDBMSSQL Server 2014/2012/2008/2005/2000, Oracle 11g/10g/9i, PostgreSQL 9.1, IBM DB2 UDB 8.2/8.0 & Sybase Server 15.0.2DWH / BI ToolsSQL Server Reporting Services (SSRS), SSIS, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), SSDT, Visual Studio, Power BI.Tools and UtilitiesSQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio, SSDT.Operating SystemsOracle Linux, Windows NT/XP/2003/2008r2/2012/2016,Windows 9x and MS-DOSWORK EXPERIENCEClient: Ameren Corporation, St. Louis, MO July 2021 - PresentTitle: Sr. SQL /SSIS Developer/Power Bi developerAmeren Corporation is a power company. I have implemented comprehensive data solutions for the ARCOS application, leveraging advanced SQL, Power BI, SSIS, and MuleSoft. Skilled in optimizing database performance, facilitating seamless data integration, and delivering actionable insights to drive business decisions. Expertise in writing complex Queries and formulas for ARCOS Application Created Workspace and content packs for business users to view the developed reports. Scheduled Automatic refresh and scheduling refresh in Power BI service. Plan, design, and implement application database code objects, such as stored procedures and views. Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using MuleSoft. Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS) and MuleSoft. Developed Power BI model used for medical reporting. Utilized multidimensional and tabular model in analysis services to pull and generate reports directly in-memory from back- end relational data sources. Utilized Power Query in Power BI to Pivot and Unpivot the data model for data cleansing and data massaging. Designed SSRS reports for in depth business analyses. Adept at developing and supporting analysis solutions, data transformations, and reports. In-depth understanding of all stages of the software development life cycle (SDLC). Perform quality assurance and testing of SQL server environment. Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options. Handled escalated support tickets still closure for MS Azure laaS platform. Moderate, Manage and storage Account and affinity group in Azure Portal. Supported all production operation activities, with focus on integration and development of new and existing products and services. Worked with internal and external clients for import and normalization of third-party data. Created packages using different transformations like pivot, condition split, fuzzy lookup, aggregate, merge join, execute SQL flow task, data flow task to extract data from different databases and flat files. Created complex SQL queries by joining multiple tables, dynamic SQL and subqueries in SQL. Worked on migrating data from non-relational database to relation database. Used Microsoft Power BI to Build and maintain the reports and dashboards. Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports. Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI. Utilized Power BI gateway to keep dashboards and reports up-to-date with on premise data sources. Created auto generated emails using stored procedures. Assisted in the definition of the database requirements; analyzed existing models and reports looking for opportunities to improve their efficiency and troubleshoot various performance issues. Advised optimization of slow performance queries by looking at Execution Plan for better tuning of the database. Improved the performance of long running views and stored procedures. Improved performance by adding indexes, removing unnecessary columns in the inner views and adding conditions to get only required data.Cotiviti, Dayton OH Feb 2021 June 2021Sr. SQL SERVER DEVELOPERCotiviti is a leading solution and analytics company that is reshaping the economics of healthcare, helping its clients uncover new opportunities to unlock value. I am working on developing reports using SSRS, database design, and ETL.
Responsibilities Involved in Conceptual, Logical, and Physical Development of the database as well as the creation of user documentation. Write complex SQL scripts, created Stored Procedures, Scalar & Table Functions, Views, Triggers, and Tables that are used by different applications, SSIS packages, and SSRS Reports as per business requirements using MS SQL Server 2014/2012/2008, SSDT, and BIDS. Developed Python batch processors to consume and produce various feeds.
Developed and deployed Parameterized, Cascading, Drilldown, Drill-through, Sub-Reports, linked, charts, gauge, and Matrix full-scale enterprise and web-enabled reporting solutions based on end-user requests using MS SSRS 2012/2014 for the Admin, Member Outreach, and Operation departments.
Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments Implemented Rest Services using node JS and C# to serve the web application with JSON data. Build efficient SSIS packages for processing fact and dimension tables with complex Transforms and type 1 and type 2 slowly changing dimensions. Assists customers in the use of data visualization tools and develops custom reports using SSRS to review score cards and business trends based on the data from different locations. Performed identification, and root cause analysis and resolved different issues (bugs) within time scope and established development guidelines. Developed a data warehouse model in snowflake for over 100 datasets using whereScape. Designed, developed, and deployed ETL Jobs using Various SSIS Tasks like Execute SQL Task, Script task, Data flow task, File system task, SFTP Task, for each loop container, Sequence Container, Send Mail task, and transformations like Conditional Split, Data Conversion, Merge. Designed and provided a solution for the ongoing problem of Error logging and Process Logging of the SSIS packages. Extensive experience in using Oracle seeded packages like DBMS_OUTPUT, DBMS_SCHEDULER,UTL_FILE, DBMS_SQL and DBMS_STATS. Troubleshoot and tune Splunk deployment for servers,applications and network devices Solid experience in building interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background by using POWER BI and Tableau desktop. Developed various EDI interfaces using Pro*C and embedded PL/SQL stored packages and procedures. Also developed Unix and AutoSys job-scheduling scripts for the same. Designed an email notification system when SSIS packages Fail. Worked in MicroStrategy Administration creating new users, roles, privileges, shared folders, access controls Lists. Fine-tuned procedures/SQL queries for maximum efficiency in various databases using Oracle Hints, for Rule based optimization. Creating ASP.Net web pages using C#.NET, HTML, CSS, AJAX, JQuery for sorting and filtering. Worked extensively on Performance tuning by rewriting queries and providing indexes. Working with the business & data analysts to understand the business requirements to be fulfilled by the data, assessing requirements for completeness and accuracy. Analyze and interpret all complex data on the target system and analyze and provide resolutions to all data issues and coordinate with analysts to validate all requirements.Hayat Brown Washington D.C. March2019 Jan2021SQL/BI DeveloperHayat Brown, LLC is an engineering firm providing program, project, construction management, budgeting, planning, design, and related consulting services to government agencies and private companies involved in transportation and water and sewer infrastructure projects, particularly in urban areas. I am working extensively on the support of engineering, finance, and HR-related applications and the ETL process of feeding data into various applications these included applications run by vendors. My work also involves collaborating with application developers to design and deploy full-scale enterprise and web-enabled SSRS Reports.Responsibilities Been part of production support, working with business, finance, and customer service teams, to handle any data issues, data analysis, data verification, change requests, and ad-hoc report requests.
Created Database objects including Tables, Views, Stored Procedures, and User-DefinedFunctions. Designed and developed Oracle forms & reports generating up to 60 reports Implemented XML, JavaScript, Web Services using C#.NET Worked on performance tuning of SQL, PL/SQL and analyzed Tables. Developed User-defined functions, stored procedures, indexes, and Triggers. Assists customers in the use of data visualization tools and develops custom reports using SSRS to review scorecard and business trends based on the data from different locations. Performed identification, and root cause analysis and resolved different issues (bugs) within time scope and established development guidelines. Worked on Oracle Databases, RedShift and Snowflakes Upgraded Oracle 9i to 10g software in different environments for latest features and also tested databases. worked on performance tuning of SQL, PL/SQL and analyzed Tables. Created various reports using Tableau based on the client s needs. Created SSIS package to load data from Flat Files and Excel Files to Data warehouse and Report-Datamart using Execute SQL Task, Data flow task Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
Scheduled the SSIS packages to run at different intervals to load the data. Designed and provided a solution for the ongoing problem of Error logging and Process Logging of the SSIS packages. Developed Merge jobs in Python to extract and load data into MySQL database.
Optimization of slow performance queries by looking at the Execution Plan for better tuning of
the database.Mercy Hospital Oklahoma City, OklahomaJan 2018 Feb2019Sr. SQL/BI Server Developer
Mercy Hospital, Inc. is a Catholic non-profit hospital and health care system. It has a complex core integrated system for registration, accounting, finance,HR, and Billing processes. MS SQL Server relational database is used to support and maintain core institute mission-critical day-to-day and transaction data.Responsibility Analyze business requirements and build logical data models that describe all the data and relationships between the data.
Developed packages, procedures, functions and database triggers using SQL and PL/SQL Created data-related documentation (e.g., file descriptions and definitions, entity relationships, and attributes). Give SSRStraining and customer support for the clients. Created complex stored procedures and functions to support efficient data storage and manipulation. Created Parameterized, Cascading, Drilldown, and Drill-through, Sub-Reports, linked, charts, gauge, and Matrix reports using MS SSRS 2012/2008 for the Sales, Human Resource, and Operation departments. Define virtual warehouse sizing for Snowflake for different type of workloads. Designed new SSIS packages and deployed them, involved in implementing SSIS package security, protecting packages, executing, monitoring, and managing them. Wrote Python scripts to parse XML documents and load the data in database.
Used SSIS to populate data from various data sources, creating packages for different data loading operations for applications. Used SSIS to unite data from existing system and performed transformations on MS SQL 2005. Configured report server and report manager for SSRS report and deployed reports in the report server. Referenced Microsoft SharePoint Assemblies such as Microsoft, SharePoint, Client.Runtime.dll and Microsoft.SharePoint.Client.dll to connect to C# code. Collaborated with a network operator, application developer, and DBA to enhance the end-userexperience.VPS Technologies- India Sep 2015 Nov 2017SQL/SSIS DeveloperA unification of highly skilled and experienced IT professionals, who are veterans of creative manipulation of technology. We attempt to provide services to companies, individuals, groups, or any other business entity around the globe.Responsibilities Installed, Configured, and Managed SQL Server 2005, 2008, and 2008R2 in development, test, and production environment. Daily routine DBA tasks like Backups and Restores, handling user's permissions and space issues on Production Servers and handling maintenance Jobs. Implemented Server security by assigning logins, server and database roles, and server permissions. Standardize Splunk forwarder deployment, configuration and maintenance in Linux and windows platforms Worked with data extraction using SSIS and Data Warehouse staging, and loading. Working with various business groups while developing their applications, assisting in database design, creating ER diagrams, phasing from development to QA and to the Production environment. Involved in extensive coding in Oracle forms/reports using PL/SQL. Creating and manipulating database objects such as tables, views, user-defined functions, clustered and non-clustered indexes, store procedures, triggers, and maintaining Referential Integrity. Wrote complex SQL scripts for DML and DDL based on business requirements. Export and import data from Flat file, CSV file, Excel to/from SQL Server Database using SSIS. Involved in automating SSIS Packages using SQL Server Agent Jobs. Configured various event-driven e-mail notification processes in SSIS packages. Created an audit database to handle SSIS error output and validate data. Designed, developed, and deployed SSRS reports with functionality such as Drill Down, Drill through, and Parameters.
Optimized SQL queries for improved performance and Report rendering.EDUCATION BACKGROUND Bachelor of Computer Science 2015, Punjab Technical University |
